pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Dec 25 23:47:45 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 48,417,206 log entries in 2m43s
Log start from 2024-12-25 00:00:00 to 2024-12-25 22:45:02

Global Stats

22,847 Number of unique normalized queries
20,667,263 Number of queries
7d20h50m7s Total query duration
2024-12-25 00:00:00 First query
2024-12-25 22:45:02 Last query
6,210 queries/s at 2024-12-25 17:03:12 Query peak

7d20h50m7s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
7d20h50m7s Execute total duration

23,496 Number of events
26 Number of unique normalized events
10,010 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
20,667,263 Average queries per session
7d20h50m7s 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,210 queries/s Query Peak
2024-12-25 17:03:12 Date

SELECT Traffic

Key values

6,031 queries/s Query Peak
2024-12-25 11:10:34 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,400 queries/s Query Peak
2024-12-25 17:03:12 Date

Queries duration

Key values

7d20h50m7s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 25	00	299,098	0ms	4s429ms	20ms	3m12s	3m46s	3m58s
	01	304,975	0ms	4s336ms	19ms	3m19s	3m32s	4m41s
	02	260,652	0ms	1s89ms	22ms	3m22s	3m32s	4m33s
	03	228,366	0ms	2s348ms	23ms	2m52s	2m59s	3m53s
	04	260,805	0ms	646ms	23ms	3m14s	4m10s	5m35s
	05	213,680	0ms	807ms	23ms	2m51s	3m25s	4m29s
	06	237,948	0ms	4s638ms	20ms	2m54s	2m59s	3m29s
	07	187,986	0ms	1s344ms	16ms	1m45s	2m26s	3m35s
	08	408,485	0ms	2s334ms	11ms	2m40s	3m18s	3m30s
	09	1,162,559	0ms	13m56s	32ms	6m12s	58m59s	3h46m23s
	10	1,527,628	0ms	21m43s	19ms	6m48s	8m32s	3h48m43s
	11	1,712,729	0ms	33m25s	37ms	31m40s	50m50s	8h25m3s
	12	1,618,812	0ms	18m8s	35ms	45m35s	1h19m32s	5h16m2s
	13	1,958,566	0ms	11m57s	19ms	30m41s	51m58s	1h9m6s
	14	1,699,616	0ms	20m55s	25ms	8m49s	2h8m45s	3h9m47s
	15	1,565,272	0ms	24m57s	19ms	6m30s	59m28s	2h44m43s
	16	1,527,599	0ms	16m23s	27ms	8m39s	45m10s	3h1m46s
	17	1,502,532	0ms	4m57s	24ms	26m54s	39m28s	54m35s
	18	1,175,644	0ms	4m41s	21ms	11m40s	13m39s	19m38s
	19	986,417	0ms	48m15s	51ms	10m2s	11m39s	8h32m21s
	20	862,542	0ms	41m51s	70ms	19m22s	38m11s	7h18m6s
	21	580,711	0ms	30m27s	79ms	7m	8m19s	9h3m42s
	22	384,641	0ms	50m57s	179ms	5m1s	5m38s	13h33m16s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 25	00	161,590	38ms	2m42s	3m12s	3m48s
	01	163,282	37ms	2m30s	3m18s	4m22s
	02	130,624	45ms	2m48s	3m21s	3m33s
	03	113,775	47ms	2m19s	2m52s	3m29s
	04	133,172	46ms	2m23s	3m13s	5m9s
	05	107,831	46ms	1m55s	2m50s	3m37s
	06	126,368	38ms	2m9s	2m54s	3m22s
	07	102,373	30ms	1m21s	1m45s	3m19s
	08	234,571	19ms	2m9s	2m40s	3m25s
	09	691,368	17ms	5m7s	5m40s	6m11s
	10	898,844	17ms	5m59s	6m45s	8m30s
	11	1,027,594	13ms	5m16s	6m22s	7m37s
	12	979,262	10ms	3m47s	4m19s	6m52s
	13	1,211,113	17ms	7m41s	8m36s	11m12s
	14	1,029,239	13ms	5m16s	6m47s	8m47s
	15	933,333	13ms	4m36s	5m32s	7m8s
	16	924,512	17ms	6m15s	7m5s	7m59s
	17	919,103	26ms	9m38s	11m58s	13m3s
	18	683,593	36ms	9m4s	11m38s	14m54s
	19	581,595	34ms	7m38s	9m18s	11m9s
	20	516,227	47ms	10m11s	11m55s	19m46s
	21	340,618	40ms	5m10s	6m49s	8m18s
	22	225,822	32ms	3m38s	4m37s	5m38s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 25	00	26,684	6,059	145	0	0ms	152ms	205ms	296ms
	01	26,174	5,927	137	0	0ms	131ms	198ms	382ms
	02	21,651	6,132	135	0	0ms	128ms	179ms	324ms
	03	18,369	6,015	130	0	0ms	123ms	164ms	243ms
	04	23,022	5,523	132	0	0ms	123ms	176ms	328ms
	05	17,617	5,431	135	0	0ms	118ms	162ms	257ms
	06	18,822	4,910	138	0	0ms	105ms	142ms	253ms
	07	11,090	3,882	149	0	0ms	63ms	85ms	235ms
	08	16,720	6,137	408	0	0ms	117ms	154ms	191ms
	09	51,043	18,095	734	0	373ms	327ms	433ms	58m34s
	10	68,869	21,679	774	0	149ms	434ms	507ms	627ms
	11	70,086	20,808	662	0	541ms	463ms	726ms	49m6s
	12	56,508	18,238	581	0	615ms	373ms	534ms	1h17m28s
	13	86,087	30,162	878	15	148ms	629ms	16s455ms	48m32s
	14	59,324	22,817	700	0	342ms	422ms	549ms	2h6m43s
	15	60,678	23,080	776	0	218ms	359ms	449ms	56m49s
	16	67,946	27,122	772	3	268ms	437ms	590ms	41m19s
	17	87,421	28,709	926	0	106ms	843ms	1s336ms	33m40s
	18	95,626	26,007	646	0	8ms	686ms	1s345ms	1m46s
	19	75,518	22,379	519	2	315ms	557ms	662ms	1m51s
	20	87,951	31,968	452	0	302ms	679ms	942ms	35m16s
	21	54,751	13,070	395	0	477ms	310ms	412ms	49s819ms
	22	30,146	6,332	362	0	1s672ms	211ms	250ms	3h32m24s

Day	Hour	Percentage of prepare
Dec 25	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
Dec 25	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s

Day	Hour	Average Duration	Average idle time
Dec 25	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

372,622 buffers Checkpoint Peak
2024-12-25 10:41:21 Date
270.052 seconds Highest write time
0.393 seconds Sync time

Checkpoints Wal files

Key values

171 files Wal files usage Peak
2024-12-25 10:41:21 Date

Checkpoints distance

Key values

5,486.71 Mo Distance Peak
2024-12-25 10:41:21 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 25	00	122,344	3,239.546s	0.03s	3,239.622s
	01	149,831	3,239.543s	0.028s	3,239.618s
	02	159,568	3,239.576s	0.036s	3,239.653s
	03	118,777	3,239.581s	0.032s	3,239.652s
	04	166,102	3,239.57s	0.034s	3,239.658s
	05	108,804	3,239.532s	0.031s	3,239.605s
	06	116,993	3,239.633s	0.029s	3,239.706s
	07	90,813	3,148.471s	0.026s	3,148.542s
	08	127,118	3,127.576s	0.035s	3,127.654s
	09	337,748	3,239.545s	0.044s	3,239.662s
	10	820,264	3,239.071s	0.44s	3,239.644s
	11	579,884	3,239.324s	0.065s	3,239.615s
	12	457,852	3,239.496s	0.053s	3,239.631s
	13	559,316	3,239.466s	0.059s	3,239.62s
	14	489,254	3,239.572s	0.045s	3,239.71s
	15	436,944	3,239.445s	0.044s	3,239.562s
	16	409,639	3,239.602s	0.048s	3,239.724s
	17	411,987	2,891.685s	0.073s	2,891.841s
	18	476,158	3,239.424s	0.059s	3,239.569s
	19	402,927	3,239.522s	0.046s	3,239.652s
	20	274,867	3,239.508s	0.06s	3,239.633s
	21	269,186	3,239.57s	0.061s	3,239.691s
	22	172,071	2,429.617s	0.033s	2,429.692s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 25	00	0	49	3,308	0.002s	0.012s
	01	0	59	2,864	0.002s	0.012s
	02	0	61	2,939	0.002s	0.012s
	03	0	47	2,539	0.002s	0.012s
	04	0	67	2,618	0.002s	0.012s
	05	0	45	2,517	0.002s	0.012s
	06	0	48	2,523	0.002s	0.012s
	07	0	36	2,639	0.002s	0.012s
	08	0	47	3,286	0.002s	0.012s
	09	0	127	4,859	0.003s	0.012s
	10	8	345	5,257	0.387s	0.012s
	11	61	174	5,709	0.004s	0.012s
	12	0	184	5,323	0.002s	0.012s
	13	0	231	5,654	0.003s	0.012s
	14	0	197	5,629	0.003s	0.012s
	15	0	177	5,593	0.002s	0.012s
	16	0	162	5,771	0.002s	0.012s
	17	0	171	5,749	0.010s	0.012s
	18	0	206	5,955	0.003s	0.012s
	19	0	180	5,615	0.002s	0.012s
	20	0	122	5,091	0.003s	0.012s
	21	0	117	4,889	0.002s	0.012s
	22	0	75	3,596	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Dec 25	00	66,955.50 kB	109,317.42 kB
	01	80,280.75 kB	116,509.42 kB
	02	82,972.67 kB	162,176.92 kB
	03	64,681.83 kB	112,685.50 kB
	04	90,690.92 kB	118,625.00 kB
	05	62,085.00 kB	99,310.67 kB
	06	64,620.08 kB	88,082.08 kB
	07	52,867.45 kB	80,411.00 kB
	08	63,676.58 kB	90,862.08 kB
	09	169,233.18 kB	223,725.09 kB
	10	481,388.08 kB	1,022,266.08 kB
	11	321,592.73 kB	1,310,436.45 kB
	12	250,735.17 kB	565,792.67 kB
	13	318,111.73 kB	372,607.36 kB
	14	269,567.42 kB	362,607.75 kB
	15	241,229.82 kB	284,162.09 kB
	16	221,010.17 kB	312,431.58 kB
	17	233,452.42 kB	300,250.67 kB
	18	282,035.08 kB	344,397.42 kB
	19	244,984.33 kB	359,560.17 kB
	20	167,071.42 kB	252,063.58 kB
	21	160,062.42 kB	219,596.58 kB
	22	136,484.67 kB	203,224.78 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

12,235,809 Total read queries
5,737,893 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,235,809	59.20%
INSERT	1,132,103	5.48%
UPDATE	360,482	1.74%
DELETE	10,686	0.05%
COPY FROM	20	0.00%
COPY TO	0	0.00%
CTE	32,330	0.16%
DDL	3,273	0.02%
TCL	4,198,999	20.32%
CURSOR	0	0.00%
OTHERS	2,693,561	13.03%

Queries by database

Key values

unknown Main database
20,667,263 Requests
7d20h50m7s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	20,667,263	7d20h50m7s
	copy from	20	17ms
	cte	32,330	7s300ms
	ddl	3,273	459ms
	delete	10,686	2m23s
	insert	1,132,103	6m3s
	others	2,693,561	2m5s
	select	12,235,809	3d5h25m14s
	tcl	4,198,999	2m57s
	update	360,482	4d15h11m16s

Queries by user

Key values

unknown Main user
20,667,263 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	20,667,263	7d20h50m7s
	copy from	20	17ms
	cte	32,330	7s300ms
	ddl	3,273	459ms
	delete	10,686	2m23s
	insert	1,132,103	6m3s
	others	2,693,561	2m5s
	select	12,235,809	3d5h25m14s
	tcl	4,198,999	2m57s
	update	360,482	4d15h11m16s

Duration by user

Key values

7d20h50m7s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	20,667,263	7d20h50m7s
	copy from	20	17ms
	cte	32,330	7s300ms
	ddl	3,273	459ms
	delete	10,686	2m23s
	insert	1,132,103	6m3s
	others	2,693,561	2m5s
	select	12,235,809	3d5h25m14s
	tcl	4,198,999	2m57s
	update	360,482	4d15h11m16s

Queries by host

Key values

unknown Main host
20,667,263 Requests
7d20h50m7s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	20,667,263	7d20h50m7s
	copy from	20	17ms
	cte	32,330	7s300ms
	ddl	3,273	459ms
	delete	10,686	2m23s
	insert	1,132,103	6m3s
	others	2,693,561	2m5s
	select	12,235,809	3d5h25m14s
	tcl	4,198,999	2m57s
	update	360,482	4d15h11m16s

Queries by application

Key values

unknown Main application
20,667,263 Requests
7d20h50m7s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	20,667,263	7d20h50m7s
	copy from	20	17ms
	cte	32,330	7s300ms
	ddl	3,273	459ms
	delete	10,686	2m23s
	insert	1,132,103	6m3s
	others	2,693,561	2m5s
	select	12,235,809	3d5h25m14s
	tcl	4,198,999	2m57s
	update	360,482	4d15h11m16s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-25 19:03:21 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,273,598 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,273,598	93.26%
1-5ms	331,729	1.61%
5-10ms	15,857	0.08%
10-25ms	56,114	0.27%
25-50ms	207,430	1.00%
50-100ms	75,308	0.36%
100-500ms	573,603	2.78%
500-1000ms	127,230	0.62%
1000-10000ms	5,049	0.02%
> 10000ms	1,345	0.01%

Slowest individual queries

Rank	Duration	Query
1	50m57s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.067299', exp_date = '2024-12-25 21:20:24.067301', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
2	50m57s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.066861', exp_date = '2024-12-25 21:20:24.066864', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
3	49m35s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:36:45.248057', exp_date = '2024-12-25 21:21:45.248060', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
4	48m15s	UPDATE "res_users" SET "exp_date" = '2024-12-25 18:19:06.199511', "last_update" = '2024-12-25 17:34:06.199542', "write_date" = '2024-12-25 17:34:05.749351', "write_uid" = 1357 WHERE id IN (1357); [ Date: 2024-12-25 19:22:21 ]
5	48m2s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:34:18.300354', exp_date = '2024-12-25 18:19:18.300357', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
6	46m27s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:39:53.533783', exp_date = '2024-12-25 21:24:53.533787', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
7	46m	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:36:21.150355', exp_date = '2024-12-25 18:21:21.150359', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
8	45m48s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:36:32.260422', exp_date = '2024-12-25 18:21:32.260424', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
9	45m47s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:36:33.745841', exp_date = '2024-12-25 18:21:33.745846', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
10	43m48s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:42:32.650421', exp_date = '2024-12-25 21:27:32.650426', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
11	43m36s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:42:44.762781', exp_date = '2024-12-25 21:27:44.762787', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
12	43m32s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:42:48.568079', exp_date = '2024-12-25 21:27:48.568082', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
13	43m10s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:43:10.479785', exp_date = '2024-12-25 21:28:10.479789', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
14	42m29s	update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:43:51.468007', exp_date = '2024-12-25 21:28:51.468012', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-25 22:26:21 ]
15	41m51s	UPDATE "res_users" SET "exp_date" = '2024-12-25 19:21:29.928118', "last_update" = '2024-12-25 18:36:29.928152', "write_date" = '2024-12-25 18:36:29.490364', "write_uid" = 1 WHERE id IN (1229); [ Date: 2024-12-25 20:18:21 ]
16	41m31s	update res_users set sid = '26e5cc547d9670b24d76db95101483eecbb52faf', last_update = '2024-12-25 18:36:49.552925', exp_date = '2024-12-25 19:21:49.552929', logged_in = 'TRUE' where id = 1229; [ Date: 2024-12-25 20:18:21 ]
17	40m7s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:42:13.334006', exp_date = '2024-12-25 18:27:13.334007', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
18	40m7s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:42:13.815780', exp_date = '2024-12-25 18:27:13.815785', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
19	40m6s	update res_users set sid = '3cfa25ff00b016f5cff5b05f9c61502907e085f8', last_update = '2024-12-25 17:42:14.567275', exp_date = '2024-12-25 18:27:14.567277', logged_in = 'TRUE' where id = 1357; [ Date: 2024-12-25 19:22:21 ]
20	39m14s	update res_users set sid = '26e5cc547d9670b24d76db95101483eecbb52faf', last_update = '2024-12-25 18:39:06.544346', exp_date = '2024-12-25 19:24:06.544351', logged_in = 'TRUE' where id = 1229; [ Date: 2024-12-25 20:18:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d7h33m46s

84,691

Details

0ms

50m57s

4s402ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 25	00	736	174ms	0ms
	01	957	216ms	0ms
	02	1,084	243ms	0ms
	03	1,064	2s590ms	2ms
	04	963	216ms	0ms
	05	725	159ms	0ms
	06	698	157ms	0ms
	07	505	111ms	0ms
	08	1,661	365ms	0ms
	09	5,156	7h14m9s	5s52ms
	10	7,216	2h40m43s	1s336ms
	11	8,000	12h57m48s	5s833ms
	12	7,811	12h51m47s	5s928ms
	13	8,808	4h31m3s	1s846ms
	14	7,542	7h46m50s	3s713ms
	15	7,110	4h57m55s	2s514ms
	16	6,353	6h52m1s	3s891ms
	17	6,508	3h20m53s	1s852ms
	18	3,854	13m44s	213ms
	19	2,999	7h10m35s	8s614ms
	20	2,210	9h19m19s	15s185ms
	21	1,600	8h47m3s	19s764ms
	22	1,131	14h49m45s	47s201ms

update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.067299', exp_date = '2024-12-25 21:20:24.067301', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 50m57s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.066861', exp_date = '2024-12-25 21:20:24.066864', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 50m57s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:36:45.248057', exp_date = '2024-12-25 21:21:45.248060', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 49m35s

2

1d14h22m39s

280,788

Details

366ms

4s648ms

492ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 25	00	7,932	1h1m5s	462ms
	01	7,871	1h34s	461ms
	02	7,833	59m18s	454ms
	03	7,609	57m10s	450ms
	04	8,920	1h8m1s	457ms
	05	6,445	48m57s	455ms
	06	5,927	45m2s	455ms
	07	3,902	29m21s	451ms
	08	6,268	47m19s	452ms
	09	11,930	1h33m55s	472ms
	10	18,165	2h28m18s	489ms
	11	15,732	2h6m22s	481ms
	12	12,357	1h36m47s	469ms
	13	18,375	2h39m39s	521ms
	14	11,238	1h31m42s	489ms
	15	10,347	1h21m55s	475ms
	16	13,629	1h52m38s	495ms
	17	18,783	2h51m39s	548ms
	18	23,952	3h30m59s	528ms
	19	20,721	2h55m12s	507ms
	20	14,171	2h11m51s	558ms
	21	17,711	2h20m45s	476ms
	22	10,970	1h23m59s	459ms

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

Date: 2024-12-25 20:56:03 Duration: 4s648ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943246)) AND (("shipping_track"."id" not in (32138970, 32138970)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:56:36 Duration: 4s380ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943147)) AND (("shipping_track"."id" not in (32138568, 32138568)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:54:22 Duration: 4s269ms

3

10h25m14s

155,152

Details

175ms

1s663ms

241ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 25	00	1,419	5m4s	214ms
	01	1,674	6m	215ms
	02	2,678	9m43s	217ms
	03	2,709	9m46s	216ms
	04	2,501	9m5s	218ms
	05	2,546	9m9s	215ms
	06	2,613	9m27s	217ms
	07	1,608	5m45s	214ms
	08	1,669	6m2s	217ms
	09	7,597	29m1s	229ms
	10	5,879	23m40s	241ms
	11	4,485	17m54s	239ms
	12	2,363	8m56s	226ms
	13	12,766	53m2s	249ms
	14	6,895	27m15s	237ms
	15	7,373	28m54s	235ms
	16	8,457	33m11s	235ms
	17	11,937	48m25s	243ms
	18	15,309	1h40s	237ms
	19	15,329	59m18s	232ms
	20	32,333	2h26m49s	272ms
	21	4,154	15m12s	219ms
	22	858	2m45s	192ms

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

Date: 2024-12-25 20:56:23 Duration: 1s663ms
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" = '9417933')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 20:55:54 Duration: 1s653ms
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" = '9548527')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 20:54:17 Duration: 1s642ms

4

6h36m22s

47,112

Details

387ms

4s72ms

504ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 25	00	290	2m20s	484ms
	01	179	1m31s	511ms
	02	172	1m27s	510ms
	03	161	1m24s	524ms
	04	176	1m30s	513ms
	05	196	1m38s	503ms
	06	194	1m32s	476ms
	07	213	1m39s	468ms
	08	1,297	9m51s	456ms
	09	3,256	26m19s	485ms
	10	3,681	31m22s	511ms
	11	3,915	32m3s	491ms
	12	2,927	23m47s	487ms
	13	5,029	44m36s	532ms
	14	3,684	30m29s	496ms
	15	3,298	26m37s	484ms
	16	3,898	32m11s	495ms
	17	4,672	41m49s	537ms
	18	3,311	29m45s	539ms
	19	2,370	19m53s	503ms
	20	1,679	14m42s	525ms
	21	1,443	11m33s	480ms
	22	1,071	8m12s	460ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3908756, 3882681, 3847076, 3841673, 3805399)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 17:53:59 Duration: 4s72ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3939424, 3939414, 3939411, 3939406, 3939404, 3939396, 3939394)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:55:57 Duration: 3s884ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3933724, 3933713, 3933462, 3933441, 3933423, 3931331)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:56:21 Duration: 3s613ms

5

5h44m54s

345

Details

0ms

37m54s

59s985ms

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
Dec 25	00	7	9ms	1ms
	01	3	3ms	1ms
	02	2	0ms	0ms
	03	2	0ms	0ms
	04	1	0ms	0ms
	05	1	0ms	0ms
	06	1	0ms	0ms
	07	4	0ms	0ms
	08	17	4ms	0ms
	09	28	18ms	0ms
	10	36	1h5m44s	1m49s
	11	40	48m29s	1m12s
	12	22	30ms	1ms
	13	38	8m22s	13s215ms
	14	27	2m28s	5s500ms
	15	28	9m9s	19s608ms
	16	20	15m42s	47s144ms
	17	15	4m10s	16s698ms
	18	12	10ms	0ms
	19	18	37m21s	2m4s
	20	11	1m19s	7s211ms
	21	3	15m14s	5m4s
	22	9	2h16m52s	15m12s

UPDATE "res_users" SET "exp_date" = '2024-12-25 21:33:26.840851', "last_update" = '2024-12-25 20:48:26.840873', "sid" = '8f65279a9393712c75d4bc1fb6449452b2e3c747', "write_date" = '2024-12-25 20:48:26.513559', "write_uid" = 1 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 37m54s
UPDATE "res_users" SET "exp_date" = '2024-12-25 21:33:37.682146', "last_update" = '2024-12-25 20:48:37.682170', "sid" = '8f65279a9393712c75d4bc1fb6449452b2e3c747', "write_date" = '2024-12-25 20:48:37.355320', "write_uid" = 1294 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 37m43s
UPDATE "res_users" SET "exp_date" = '2024-12-25 21:38:51.892549', "last_update" = '2024-12-25 20:53:51.892567', "sid" = 'cb23fc7d8e2e6377de2159dfd37b6d7910899b39', "write_date" = '2024-12-25 20:53:51.572566', "write_uid" = 1 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 32m29s

6

4h28m6s

66,597

Details

90ms

916ms

241ms

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
Dec 25	00	3,468	11m47s	203ms
	01	2,964	10m31s	213ms
	02	1,674	6m3s	216ms
	03	1,318	5m	227ms
	04	1,794	6m36s	220ms
	05	1,662	6m40s	241ms
	06	1,969	7m19s	222ms
	07	1,047	3m47s	217ms
	08	538	1m58s	219ms
	09	104	18s38ms	173ms
	10	248	50s140ms	202ms
	11	360	1m21s	225ms
	12	310	1m11s	229ms
	13	858	3m56s	276ms
	14	2,144	9m29s	265ms
	15	1,056	4m10s	237ms
	16	4,276	17m35s	246ms
	17	7,961	38m22s	289ms
	18	7,622	33m34s	264ms
	19	6,384	26m25s	248ms
	20	10,865	41m51s	231ms
	21	5,901	22m45s	231ms
	22	2,074	6m29s	187ms

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

Date: 2024-12-25 15:32:52 Duration: 916ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'علاء')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-25 20:24:38 Duration: 913ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'هشام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-25 20:24:38 Duration: 913ms

7

2h32m11s

10,444

Details

37ms

2s64ms

874ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 25	00	746	7m33s	608ms
	01	551	5m3s	551ms
	02	351	5m48s	994ms
	10	19	19s808ms	1s42ms
	11	2	2s319ms	1s159ms
	13	191	3m39s	1s147ms
	14	238	4m27s	1s125ms
	15	178	3m2s	1s27ms
	16	905	11m6s	736ms
	17	905	15m40s	1s39ms
	18	1,177	17m50s	909ms
	19	711	12m17s	1s36ms
	20	2,626	38m8s	871ms
	21	1,156	16m15s	844ms
	22	688	10m53s	949ms

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

Date: 2024-12-25 20:56:22 Duration: 2s64ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9596128')) 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 (14, 74, 70))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:51 Duration: 2s22ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9405503')) 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 (29))))))) 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 (29)))))) 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 (29)))))) 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 (29))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:27 Duration: 1s955ms

8

2h10m41s

23,243

Details

221ms

2s153ms

337ms

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
Dec 25	00	998	5m13s	314ms
	01	945	4m59s	316ms
	02	493	2m36s	318ms
	03	682	3m35s	315ms
	04	915	4m50s	317ms
	05	851	4m28s	315ms
	06	996	5m9s	310ms
	07	526	2m43s	310ms
	08	273	1m23s	307ms
	09	55	18s320ms	333ms
	10	114	39s340ms	345ms
	11	184	1m4s	347ms
	12	160	53s141ms	332ms
	13	242	1m32s	380ms
	14	845	4m49s	342ms
	15	353	2m2s	347ms
	16	1,262	7m25s	353ms
	17	3,123	19m22s	372ms
	18	2,662	15m46s	355ms
	19	2,508	13m51s	331ms
	20	2,847	16m34s	349ms
	21	1,836	9m31s	311ms
	22	373	1m49s	293ms

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

Date: 2024-12-25 20:55:35 Duration: 2s153ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510667')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:38 Duration: 2s125ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510395')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 18:45:48 Duration: 2s14ms

9

2h4m31s

24,836

Details

206ms

584ms

300ms

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
Dec 25	09	2,005	9m18s	278ms
	10	1,461	8m10s	335ms
	11	964	4m45s	296ms
	12	863	4m13s	294ms
	13	4,055	21m19s	315ms
	14	3,524	17m13s	293ms
	15	3,478	16m55s	292ms
	16	2,470	11m59s	291ms
	17	4,048	20m47s	308ms
	18	1,417	7m21s	311ms
	19	551	2m26s	266ms

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

Date: 2024-12-25 13:39:10 Duration: 584ms
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" = '9542156')))) ORDER BY "collection_policy"."id";

Date: 2024-12-25 10:15:33 Duration: 552ms
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" = '9157135')))) ORDER BY "collection_policy"."id";

Date: 2024-12-25 10:15:43 Duration: 551ms

10

1h49m22s

159,246

Details

30ms

237ms

41ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,638	2m18s	38ms
	01	2,942	1m52s	38ms
	02	2,028	1m17s	38ms
	03	1,960	1m15s	38ms
	04	3,122	1m59s	38ms
	05	1,745	1m6s	38ms
	06	1,645	1m3s	38ms
	07	1,167	44s821ms	38ms
	08	2,261	1m27s	38ms
	09	7,713	5m9s	40ms
	10	13,416	9m17s	41ms
	11	12,784	8m47s	41ms
	12	10,192	6m51s	40ms
	13	15,694	11m32s	44ms
	14	8,850	6m4s	41ms
	15	9,011	6m5s	40ms
	16	9,953	6m51s	41ms
	17	12,268	8m57s	43ms
	18	12,500	8m49s	42ms
	19	10,087	6m52s	40ms
	20	7,485	5m24s	43ms
	21	5,856	3m45s	38ms
	22	2,929	1m49s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3873389, 3865464, 3832487, 3498158)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:54 Duration: 237ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3943134)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:12 Duration: 220ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3837793)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:56:21 Duration: 217ms

11

1h30m6s

31

Details

0ms

48m15s

2m54s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 25	04	1	1ms	1ms
	05	1	0ms	0ms
	08	2	2ms	1ms
	10	3	4ms	1ms
	11	3	0ms	0ms
	13	4	5ms	1ms
	14	1	1ms	1ms
	16	1	0ms	0ms
	17	2	1ms	0ms
	18	1	0ms	0ms
	19	5	48m15s	9m39s
	20	5	41m51s	8m22s
	21	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-25 18:19:06.199511', "last_update" = '2024-12-25 17:34:06.199542', "write_date" = '2024-12-25 17:34:05.749351', "write_uid" = 1357 WHERE id IN (1357);

Date: 2024-12-25 19:22:21 Duration: 48m15s
UPDATE "res_users" SET "exp_date" = '2024-12-25 19:21:29.928118', "last_update" = '2024-12-25 18:36:29.928152', "write_date" = '2024-12-25 18:36:29.490364', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-25 20:18:21 Duration: 41m51s
UPDATE "res_users" SET "exp_date" = '2024-12-25 10:39:06.514039', "last_update" = '2024-12-25 09:54:06.514065', "write_date" = '2024-12-25 09:54:06.151912', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-25 10:54:06 Duration: 2ms

12

56m27s

14,637

Details

177ms

498ms

231ms

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
Dec 25	00	6	1s307ms	217ms
	01	96	20s708ms	215ms
	03	405	1m27s	216ms
	04	547	1m59s	219ms
	05	664	2m22s	214ms
	06	1,109	3m59s	216ms
	07	927	3m19s	215ms
	08	1,035	3m44s	217ms
	09	1,507	5m44s	228ms
	10	901	3m36s	239ms
	11	1,107	4m25s	240ms
	12	344	1m16s	222ms
	13	1,549	6m42s	259ms
	14	1,225	4m48s	235ms
	15	428	1m41s	236ms
	16	584	2m19s	239ms
	17	1,188	4m58s	251ms
	18	198	41s222ms	208ms
	19	359	1m20s	225ms
	20	265	58s136ms	219ms
	21	193	38s641ms	200ms

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

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

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

Date: 2024-12-25 11:12:32 Duration: 417ms

13

46m4s

12,751

Details

195ms

271ms

216ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 25	00	1,088	3m53s	214ms
	01	1,391	4m59s	214ms
	02	2,630	9m33s	217ms
	03	2,304	8m18s	216ms
	04	1,954	7m6s	218ms
	05	1,876	6m45s	216ms
	06	849	3m4s	217ms
	07	367	1m19s	216ms
	08	292	1m4s	220ms

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

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

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

Date: 2024-12-25 04:24:26 Duration: 269ms

14

45m34s

53,775

Details

36ms

285ms

50ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3	144ms	48ms
	01	1	49ms	49ms
	02	6	286ms	47ms
	06	7	331ms	47ms
	07	13	608ms	46ms
	08	140	6s603ms	47ms
	09	3,832	3m5s	48ms
	10	3,699	3m3s	49ms
	11	2,301	1m56s	50ms
	12	1,889	1m34s	49ms
	13	7,363	6m40s	54ms
	14	4,875	4m	49ms
	15	5,969	4m48s	48ms
	16	6,366	5m16s	49ms
	17	8,254	7m19s	53ms
	18	4,738	4m5s	51ms
	19	3,661	3m2s	49ms
	20	338	17s547ms	51ms
	21	201	9s766ms	48ms
	22	119	5s660ms	47ms

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

Date: 2024-12-25 20:55:50 Duration: 285ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3920983) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-25 11:12:46 Duration: 262ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3680051) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-25 13:39:09 Duration: 253ms

15

38m20s

22,938

Details

78ms

692ms

100ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 25	07	28	2s556ms	91ms
	08	199	19s380ms	97ms
	09	2,523	4m5s	97ms
	10	1,126	1m53s	100ms
	11	2,480	4m7s	99ms
	12	2,311	3m41s	95ms
	13	2,672	4m43s	105ms
	14	2,011	3m17s	98ms
	15	2,786	4m30s	96ms
	16	1,642	2m45s	101ms
	17	1,519	2m44s	108ms
	18	976	1m45s	108ms
	19	676	1m8s	101ms
	20	692	1m15s	108ms
	21	550	52s676ms	95ms
	22	747	1m8s	91ms

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

Date: 2024-12-25 20:55:45 Duration: 692ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7882474)) AND (("cash_track"."id" not in (6200661)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-25 18:45:45 Duration: 647ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7883079)) AND (("cash_track"."id" not in (6207085)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-25 20:55:57 Duration: 645ms

16

24m38s

6,379

Details

186ms

1s71ms

231ms

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

Day	Hour	Count	Duration	Avg duration
Dec 25	00	311	1m7s	215ms
	01	15	3s149ms	209ms
	06	656	2m22s	217ms
	07	179	38s85ms	212ms
	08	339	1m13s	215ms
	09	379	1m25s	226ms
	10	1,460	5m54s	242ms
	11	188	43s340ms	230ms
	12	119	28s46ms	235ms
	13	252	1m2s	246ms
	14	530	2m4s	235ms
	15	814	3m6s	229ms
	16	858	3m23s	237ms
	17	206	48s644ms	236ms
	18	73	16s818ms	230ms

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

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

Date: 2024-12-25 17:53:09 Duration: 400ms
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" = '9467541')) 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: 2024-12-25 10:15:32 Duration: 364ms

17

15m39s

20,422

Details

33ms

93ms

45ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 25	08	5	212ms	42ms
	09	1,216	55s120ms	45ms
	10	1,480	1m7s	45ms
	11	882	39s659ms	44ms
	12	822	36s624ms	44ms
	13	3,312	2m36s	47ms
	14	2,389	1m47s	45ms
	15	2,485	1m49s	44ms
	16	2,789	2m5s	44ms
	17	2,772	2m14s	48ms
	18	1,930	1m31s	47ms
	19	339	15s215ms	44ms
	20	1	42ms	42ms

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

Date: 2024-12-25 13:52:37 Duration: 93ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3768905) ORDER BY "collection_policy"."id";

Date: 2024-12-25 13:39:32 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3823138) ORDER BY "collection_policy"."id";

Date: 2024-12-25 18:45:42 Duration: 82ms

18

14m13s

5,763

Details

121ms

792ms

148ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 25	00	17	2s226ms	130ms
	04	4	513ms	128ms
	05	5	647ms	129ms
	07	5	661ms	132ms
	08	113	14s967ms	132ms
	09	291	41s663ms	143ms
	10	1,034	2m33s	148ms
	11	1,079	2m37s	146ms
	12	858	2m1s	142ms
	13	767	2m	157ms
	14	380	55s809ms	146ms
	15	315	44s388ms	140ms
	16	228	33s980ms	149ms
	17	232	40s722ms	175ms
	18	215	33s85ms	153ms
	19	113	16s479ms	145ms
	20	29	4s188ms	144ms
	21	52	7s172ms	137ms
	22	26	3s427ms	131ms

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

Date: 2024-12-25 17:53:09 Duration: 792ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 102)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-25 17:53:51 Duration: 523ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-25 17:53:17 Duration: 376ms

19

14m9s

300

Details

12ms

4s835ms

2s832ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 25	09	15	54s98ms	3s606ms
	10	17	41s280ms	2s428ms
	11	14	21s790ms	1s556ms
	12	16	53s547ms	3s346ms
	13	8	13s826ms	1s728ms
	14	14	35s806ms	2s557ms
	15	34	1m4s	1s906ms
	16	37	1m52s	3s27ms
	17	29	1m46s	3s682ms
	18	21	56s902ms	2s709ms
	19	17	54s715ms	3s218ms
	20	60	3m	3s12ms
	21	6	18s876ms	3s146ms
	22	12	34s455ms	2s871ms

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

Date: 2024-12-25 17:25:49 Duration: 4s835ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))) 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 (73)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))))) 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 (73)))))))) AND ("policy_number"."name"::text ilike '%9384455%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-25 13:10:57 Duration: 4s581ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))) 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 (73)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))))) 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 (73)))))))) AND ("policy_number"."name"::text ilike '%938%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-25 13:10:56 Duration: 4s534ms

20

13m23s

3,320

Details

188ms

379ms

242ms

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 true order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 25	13	2,505	10m9s	243ms
	18	734	2m57s	241ms
	19	81	17s713ms	218ms

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

Date: 2024-12-25 18:49:12 Duration: 379ms
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" = '7510674')) AND TRUE ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 18:49:02 Duration: 349ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9615761')) AND TRUE ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 13:24:52 Duration: 344ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,691,357

Details

2m5s

0ms

14ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 25	00	43,067	1s958ms	0ms
	01	43,833	2s76ms	0ms
	02	41,096	1s954ms	0ms
	03	36,126	1s705ms	0ms
	04	39,295	1s930ms	0ms
	05	32,972	1s577ms	0ms
	06	34,404	1s687ms	0ms
	07	27,870	1s283ms	0ms
	08	58,347	2s841ms	0ms
	09	152,185	7s415ms	0ms
	10	204,353	10s157ms	0ms
	11	227,002	10s373ms	0ms
	12	218,255	8s761ms	0ms
	13	242,470	11s383ms	0ms
	14	229,408	10s544ms	0ms
	15	212,574	9s413ms	0ms
	16	197,499	9s69ms	0ms
	17	179,340	8s739ms	0ms
	18	145,035	7s992ms	0ms
	19	121,562	5s816ms	0ms
	20	89,096	4s25ms	0ms
	21	68,040	3s46ms	0ms
	22	47,528	2s79ms	0ms

DISCARD ALL;

Date: 2024-12-25 13:09:01 Duration: 14ms
DISCARD ALL;

Date: 2024-12-25 15:43:58 Duration: 1ms
DISCARD ALL;

Date: 2024-12-25 18:07:22 Duration: 1ms

2

2,100,243

Details

30s658ms

0ms

19ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 25	00	30,660	496ms	0ms
	01	32,772	536ms	0ms
	02	30,481	500ms	0ms
	03	26,970	448ms	0ms
	04	29,816	497ms	0ms
	05	24,834	417ms	0ms
	06	26,642	437ms	0ms
	07	21,270	343ms	0ms
	08	45,966	714ms	0ms
	09	123,655	1s807ms	0ms
	10	165,514	2s468ms	0ms
	11	181,710	2s507ms	0ms
	12	171,030	2s177ms	0ms
	13	191,430	2s880ms	0ms
	14	177,361	2s484ms	0ms
	15	165,993	2s228ms	0ms
	16	153,018	2s243ms	0ms
	17	141,759	2s137ms	0ms
	18	111,912	1s740ms	0ms
	19	91,555	1s359ms	0ms
	20	67,575	1s17ms	0ms
	21	51,496	710ms	0ms
	22	36,824	501ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-25 10:29:05 Duration: 19ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-25 12:06:17 Duration: 15ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-25 16:53:56 Duration: 1ms

3

1,370,915

Details

14s95ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 25	00	22,249	213ms	0ms
	01	22,561	218ms	0ms
	02	21,155	202ms	0ms
	03	18,707	184ms	0ms
	04	20,289	204ms	0ms
	05	17,116	169ms	0ms
	06	17,817	175ms	0ms
	07	14,568	135ms	0ms
	08	30,223	292ms	0ms
	09	77,461	793ms	0ms
	10	103,793	1s116ms	0ms
	11	115,330	1s141ms	0ms
	12	110,858	1s71ms	0ms
	13	123,552	1s390ms	0ms
	14	116,277	1s182ms	0ms
	15	107,665	1s58ms	0ms
	16	100,224	1s51ms	0ms
	17	91,174	1s21ms	0ms
	18	73,594	787ms	0ms
	19	61,781	637ms	0ms
	20	45,433	485ms	0ms
	21	34,758	338ms	0ms
	22	24,330	220ms	0ms

ROLLBACK;

Date: 2024-12-25 16:47:15 Duration: 0ms
ROLLBACK;

Date: 2024-12-25 13:40:41 Duration: 0ms
ROLLBACK;

Date: 2024-12-25 12:21:40 Duration: 0ms

4

1,354,082

Details

4m12s

0ms

25ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 25	00	21,578	4s208ms	0ms
	01	21,902	4s404ms	0ms
	02	20,554	4s16ms	0ms
	03	18,058	3s527ms	0ms
	04	19,627	3s921ms	0ms
	05	16,482	3s222ms	0ms
	06	17,171	3s251ms	0ms
	07	13,934	2s402ms	0ms
	08	29,397	5s396ms	0ms
	09	76,819	14s867ms	0ms
	10	103,066	20s307ms	0ms
	11	114,512	20s669ms	0ms
	12	110,069	19s146ms	0ms
	13	121,943	24s652ms	0ms
	14	115,573	21s88ms	0ms
	15	106,936	19s271ms	0ms
	16	99,232	18s965ms	0ms
	17	90,151	17s163ms	0ms
	18	73,121	13s198ms	0ms
	19	61,103	10s576ms	0ms
	20	44,789	8s68ms	0ms
	21	34,162	5s915ms	0ms
	22	23,903	3s898ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'f96e945ce68ad098216d182c099af0f75ea90001';

Date: 2024-12-25 12:34:44 Duration: 25ms
SELECT payload FROM http_sessions WHERE sid = 'bf51627adcbafa9e637dfbe104d6bf65c4893970';

Date: 2024-12-25 10:39:25 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '6e10770f25508679283b50a1d7161178cde21e9f';

Date: 2024-12-25 15:32:32 Duration: 14ms

5

1,345,251

Details

2m2s

0ms

2ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 25	00	21,596	1s959ms	0ms
	01	21,991	1s979ms	0ms
	02	20,628	1s833ms	0ms
	03	18,142	1s612ms	0ms
	04	19,728	1s785ms	0ms
	05	16,559	1s482ms	0ms
	06	17,271	1s553ms	0ms
	07	14,004	1s207ms	0ms
	08	29,128	2s511ms	0ms
	09	75,975	6s842ms	0ms
	10	102,077	9s531ms	0ms
	11	113,351	9s790ms	0ms
	12	108,999	9s310ms	0ms
	13	121,074	11s865ms	0ms
	14	114,619	10s412ms	0ms
	15	106,250	9s591ms	0ms
	16	98,627	9s80ms	0ms
	17	89,554	8s757ms	0ms
	18	72,544	6s979ms	0ms
	19	60,761	5s578ms	0ms
	20	44,529	4s210ms	0ms
	21	34,064	3s81ms	0ms
	22	23,780	2s17ms	0ms

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

Date: 2024-12-25 18:50:10 Duration: 2ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-25 14:40:48 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-25 18:42:50 Duration: 1ms

6

946,201

Details

2m18s

0ms

13ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 25	00	10,476	1s592ms	0ms
	01	14,006	2s44ms	0ms
	02	10,832	1s810ms	0ms
	03	9,739	1s657ms	0ms
	04	11,635	1s892ms	0ms
	05	8,843	1s458ms	0ms
	06	10,769	1s706ms	0ms
	07	7,804	1s300ms	0ms
	08	19,701	2s898ms	0ms
	09	61,085	8s206ms	0ms
	10	82,714	12s748ms	0ms
	11	88,235	12s225ms	0ms
	12	79,316	10s75ms	0ms
	13	88,624	13s86ms	0ms
	14	81,398	11s212ms	0ms
	15	76,347	10s173ms	0ms
	16	68,004	9s664ms	0ms
	17	63,735	10s28ms	0ms
	18	50,419	8s536ms	0ms
	19	38,851	6s451ms	0ms
	20	27,445	4s243ms	0ms
	21	20,874	2s952ms	0ms
	22	15,349	2s164ms	0ms

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

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

Date: 2024-12-25 17:21:59 Duration: 12ms
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 (869);

Date: 2024-12-25 19:22:23 Duration: 12ms

7

727,698

Details

2m12s

0ms

142ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 25	00	8,412	1s551ms	0ms
	01	10,210	1s886ms	0ms
	02	9,326	1s856ms	0ms
	03	8,264	1s771ms	0ms
	04	9,526	1s843ms	0ms
	05	7,719	1s523ms	0ms
	06	8,822	1s491ms	0ms
	07	6,705	1s122ms	0ms
	08	15,739	2s565ms	0ms
	09	46,052	7s402ms	0ms
	10	61,690	12s562ms	0ms
	11	66,145	11s95ms	0ms
	12	59,962	9s859ms	0ms
	13	67,664	13s341ms	0ms
	14	60,991	10s368ms	0ms
	15	58,230	10s108ms	0ms
	16	52,617	8s879ms	0ms
	17	50,382	9s499ms	0ms
	18	38,309	7s642ms	0ms
	19	29,746	5s851ms	0ms
	20	22,052	4s280ms	0ms
	21	16,685	3s425ms	0ms
	22	12,450	2s343ms	0ms

COMMIT;

Date: 2024-12-25 10:36:21 Duration: 142ms
COMMIT;

Date: 2024-12-25 10:36:21 Duration: 140ms
COMMIT;

Date: 2024-12-25 10:39:26 Duration: 40ms

8

576,707

Details

1m21s

0ms

6ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 25	00	7,404	853ms	0ms
	01	10,120	1s844ms	0ms
	02	5,475	725ms	0ms
	03	5,337	708ms	0ms
	04	7,313	1s21ms	0ms
	05	4,527	546ms	0ms
	06	6,874	866ms	0ms
	07	3,438	430ms	0ms
	08	11,077	1s345ms	0ms
	09	37,510	5s168ms	0ms
	10	53,692	8s66ms	0ms
	11	54,243	7s701ms	0ms
	12	46,408	6s280ms	0ms
	13	49,890	8s184ms	0ms
	14	47,224	7s12ms	0ms
	15	46,234	6s534ms	0ms
	16	41,139	5s475ms	0ms
	17	37,498	5s526ms	0ms
	18	33,962	4s733ms	0ms
	19	25,321	3s602ms	0ms
	20	18,137	2s626ms	0ms
	21	14,732	1s654ms	0ms
	22	9,152	1s81ms	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 (5099006, 5103128, 5099321, 5099921, 5099009, 5099007, 5099277, 5100729, 5103741, 5110067, 5099138, 5100016, 5099651, 5099206, 5109317, 5100471, 5102344, 5105592, 5103046, 5106125, 5382009, 5164166, 5099848, 5099843, 5100832, 5157641, 5151834, 5101468, 5099497, 5165146, 5100794, 5128326, 5119680, 5099013, 5099584, 5100699, 5099525, 5102973, 5116074, 5099130, 5100181, 5099244, 5102094, 5116572, 5099804, 5099010, 5099958, 5103178, 5099582, 5100207, 5099513, 5099028, 5099590, 5099045, 5108081, 5103363, 5316188, 5102332, 5099677, 5100045, 5099521, 5099403, 5440597, 5100220, 5099008, 5099967, 5099187, 5113188, 5101304, 5102288, 5099758, 5099198, 5099014, 5340194, 5100603, 5099944, 5108752, 5099906, 5376815, 5099474, 5119011, 5439586, 5112674, 5099203, 5439646, 5101828, 5099528, 5099159, 5099657, 5439909, 5101901, 5099272, 5252764, 5105670, 5099334, 5100362, 5099236, 5099181, 5106787, 5136627, 5263994, 5128214, 5099446, 5100004, 5099430, 5107230, 5116012, 5439051, 5107837, 5099141, 5273269, 5102416, 5099254, 5317797, 5100857, 5099360, 5099523);

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

Date: 2024-12-25 17:57:16 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 (5447537, 5348797, 5447591, 5447592, 5198067, 5246267, 5448750, 5321985, 5173612, 5327596, 5433513, 5179667, 5208858, 5443618, 5240232, 5157547, 5193493, 5176286, 5240318, 5330037, 5449461, 5290607, 5181540, 5296305, 5228475, 5402191, 5449266, 5206696, 5156833, 5449463, 5429228, 5155923, 5330373, 5433576, 5152525, 5140166, 5429229, 5335064, 5170536, 5164077, 5268441, 5149286, 5403145, 5367567, 5409192, 5387804, 5297376, 5403245, 5389663, 5246643, 5174814, 5194633, 5198061, 5386267, 5413598, 5162588, 5361494, 5321685, 5153077, 5322121, 5387580, 5379062, 5337474, 5292539, 5411581, 5242725, 5200974, 5370405, 5173357, 5345429, 5312948, 5364352, 5392408, 5212181, 5136888, 5402140, 5370426, 5373575, 5183389, 5170411, 5174171, 5236585, 5151834, 5199868, 5355877, 5196447, 5370297, 5205152, 5373508, 5358701, 5332850, 5239471, 5177167, 5352104, 5186118, 5195612, 5358569, 5344771, 5344772, 5189324, 5430394, 5161534, 5329265, 5275997, 5177015, 5269277, 5185815, 5287869, 5182350, 5144303, 5151292, 5394567, 5234531, 5217345, 5394577, 5160323, 5394578, 5223351, 5391783, 5167390, 5176609, 5392338, 5392339, 5341398, 5181714, 5392331, 5177255, 5168809, 5275958, 5285730, 5183044, 5148962, 5149765, 5193727, 5390030, 5218155, 5287740, 5353124, 5316149, 5390044, 5134271, 5305995, 5158432, 5392510, 5206848, 5392682, 5142319, 5392677, 5392691, 5198036, 5227107, 5430461, 5392692, 5263637, 5307967, 5392702, 5134624, 5317797, 5151994, 5391985, 5403446, 5194802, 5338907, 5391984, 5177112, 5224409, 5387861, 5340366, 5387864, 5218788, 5438021, 5162834, 5169424, 5176447, 5217807, 5387881, 5387891, 5258619, 5360821, 5199195, 5193563, 5140292, 5400503, 5400504, 5391979, 5316255, 5210060, 5245327, 5363144, 5170010, 5166028, 5400506, 5163022, 5312899, 5199827, 5212461, 5246491, 5288411, 5258400, 5402395, 5341312, 5252050, 5241260, 5278694, 5414125, 5189325, 5226731, 5359466, 5164502, 5360379, 5159679, 5192512, 5179118, 5160129, 5144096, 5156238, 5217025, 5185748, 5144067, 5361163, 5361168, 5203816, 5156285, 5361340, 5201506, 5228419, 5400508, 5341068, 5255563, 5243308, 5442731, 5404054, 5231949, 5392002, 5236893, 5374496, 5294210, 5235969, 5384280, 5226490, 5404076, 5170601, 5387257, 5434048, 5163138, 5155301, 5314798, 5379292, 5379294, 5404107, 5139616, 5379295, 5199844, 5386623, 5217042, 5391997, 5405453, 5338037, 5379309, 5148192, 5359061, 5233677, 5234740, 5362511, 5210154, 5140313, 5404110, 5138377, 5181188, 5402386, 5402388, 5180684, 5387912, 5171696, 5392010, 5379287, 5219607, 5149183, 5219241, 5392016, 5334223, 5311240, 5152616, 5385893, 5185296, 5404145, 5303110, 5171999, 5161879, 5165531, 5280559, 5147297, 5211480, 5354109, 5262975, 5383574, 5412934, 5188095, 5378344, 5320842, 5345334, 5158362, 5392013, 5446192, 5212866, 5327308, 5151450, 5176865, 5278244, 5281953, 5153376, 5392333, 5417305, 5205940, 5417698, 5418028, 5366475, 5420007, 5140187, 5155146, 5174247, 5234014, 5338786, 5367304, 5251113, 5367545, 5198009, 5357284, 5244143, 5391843, 5387938, 5387939, 5392503, 5387937, 5391850, 5392353, 5429236, 5264325, 5248964, 5136246, 5155218, 5392670, 5247676, 5161462, 5137263, 5319699, 5363497, 5194759, 5358347, 5157218, 5213344, 5392673, 5197968, 5156074, 5137584, 5390322, 5163763, 5236880, 5186822, 5181466, 5247982, 5219278, 5345406, 5219951, 5238474, 5256368, 5371747, 5392004, 5386326, 5150306, 5394626, 5393371, 5417287, 5384151, 5230823, 5189314, 5393586, 5154729, 5394505, 5394506, 5154994, 5279990, 5192299, 5380229, 5173550, 5273500, 5165704, 5394507, 5183043, 5384403, 5387081, 5394509, 5211680, 5319620, 5394527, 5394526, 5393300, 5327103, 5184568, 5336174, 5210128, 5394529, 5370578, 5194074, 5146517, 5217048, 5180929, 5164166, 5366799, 5165545, 5198366, 5343030, 5405399, 5307581, 5416035, 5215999, 5289685, 5150882, 5157093, 5366295, 5196511, 5395622, 5155763, 5296399, 5382616, 5207030, 5450081, 5405174, 5180037, 5339356, 5176162, 5405919, 5394677, 5392067, 5323760, 5392672, 5245401, 5320742, 5356558, 5369643, 5136885, 5148441, 5139549, 5175193, 5374596, 5142101, 5149123, 5158087, 5343209, 5343210, 5159089, 5396744, 5392180, 5262056, 5265113, 5359988, 5237391, 5392158, 5212399, 5387186, 5439928, 5387468, 5308561, 5364053, 5177437, 5303805, 5220281, 5276966, 5440549, 5441996, 5309185, 5140193, 5208599, 5208519, 5146785, 5243461, 5215377, 5209463, 5240247, 5170826, 5371809, 5316128, 5392312, 5164695, 5183132, 5331224, 5264089, 5347011, 5295741, 5393851, 5167519, 5206697, 5162182, 5228388, 5381937, 5297128, 5433654, 5159851, 5164808, 5178904, 5183089, 5320743, 5146958, 5384920, 5178872, 5412760, 5386328, 5205167, 5422011, 5191052, 5391511, 5353918, 5272828, 5245926, 5185845, 5140170, 5395487, 5187703, 5391853, 5391860, 5392907, 5416127, 5416128, 5158094, 5319600, 5139053, 5227865, 5217639, 5172891, 5408254, 5163339, 5158064, 5250514, 5308028, 5229216, 5405915, 5230685, 5341747, 5271058, 5433702, 5433771, 5210991, 5433772, 5246156, 5363387, 5149370, 5180608, 5363885, 5391871, 5380255, 5272952, 5396968, 5166211, 5144926, 5165055, 5156214, 5162244, 5392080, 5169579, 5392183, 5156158, 5330341, 5165012, 5224126, 5183144, 5189475, 5171950, 5392240, 5164017, 5404461, 5254378, 5136317, 5197792, 5150807, 5199908, 5135519, 5379831, 5382677, 5394679, 5202964, 5243386, 5149252, 5159086, 5175504, 5388313, 5217934, 5237184, 5396973, 5391864, 5270553, 5405920, 5148736, 5280634, 5236942, 5287841, 5280423, 5200693, 5387555, 5281017, 5387847, 5221816, 5149885, 5396982, 5237549, 5392081, 5267363, 5220737, 5235664, 5177001, 5396977, 5176449, 5392373, 5135742, 5228121, 5396978, 5397484, 5137152, 5155645, 5170220, 5392165, 5397663, 5386331, 5160263, 5405926, 5337963, 5277899, 5226222, 5383013, 5152037, 5365188, 5144659, 5202954, 5146859, 5414499, 5252764, 5231893, 5306956, 5226776, 5258674, 5249255, 5200847, 5157310, 5439485, 5191112, 5396743, 5280472, 5427103, 5427104, 5276218, 5216786, 5159428, 5405080, 5195430, 5230568, 5272958, 5386696, 5237020, 5177542, 5287779, 5313959, 5137866, 5355428, 5322075, 5169854, 5234607, 5258560, 5400346, 5376553, 5187310, 5392161, 5362359, 5362360, 5358902, 5263876, 5219483, 5383068, 5244559, 5290696, 5192268, 5171569, 5393594, 5363802, 5345490, 5393362, 5209163, 5442489, 5232615, 5379627, 5279943, 5219944, 5163288, 5203428, 5365921, 5203356, 5347338, 5165407, 5152602, 5379645, 5302502, 5192537, 5233325, 5431078, 5431079, 5382845, 5287538, 5371659, 5140543, 5257344, 5161183, 5269497, 5392229, 5357255, 5194986, 5363840, 5222225, 5171712, 5179799, 5268236, 5247344, 5392239, 5265433, 5220384, 5173267, 5208141, 5160919, 5151845, 5150123, 5407973, 5393385, 5245608, 5411855, 5429389, 5275267, 5302923, 5236947, 5265814, 5140106, 5164004, 5350318, 5350319, 5206495, 5207615, 5340179, 5301692, 5235045, 5361188, 5361189, 5206974, 5309938, 5205707, 5213544, 5402624, 5202695, 5381377, 5400570, 5324435, 5240528, 5175453, 5230868, 5142947, 5279244, 5202478, 5169561, 5175812, 5388435, 5180949, 5245781, 5149076, 5375359, 5393991, 5176545, 5387367, 5172390, 5153250, 5191989, 5174148, 5142608, 5375562, 5193228, 5394698, 5375577, 5185092, 5391702, 5227603, 5309308, 5375998, 5393930, 5431106, 5383126, 5400496, 5220780, 5160130, 5288077, 5181897, 5168938, 5184257, 5194089, 5392235, 5449593, 5392234, 5150728, 5310718, 5194705, 5170060, 5403037, 5429613, 5153463, 5397216, 5361076, 5248454, 5270260, 5278663, 5194797, 5230041, 5167098, 5393316, 5387143, 5158006, 5164126, 5278976, 5150805, 5302779, 5230952, 5193525, 5274788, 5162059, 5177779, 5341812, 5371029, 5402632, 5402636, 5346539, 5157497, 5338261, 5371054, 5364799, 5366431, 5146518, 5364320, 5196523, 5293081, 5340697, 5404027, 5181401, 5265190, 5148331, 5340876, 5136861, 5397031, 5135740, 5381163, 5135537, 5287348, 5303022, 5389438, 5216735, 5405212, 5188977, 5401738, 5397032, 5151999, 5140036, 5179481, 5197589, 5388594, 5183453, 5134714, 5154529, 5279895, 5429893, 5365280, 5341984, 5375454, 5337253, 5364119, 5155403, 5183227, 5395627, 5429783, 5359990, 5191783, 5402598, 5375563, 5334586, 5288087, 5189375, 5286868, 5446586, 5214985, 5134833, 5393971, 5186719, 5164598, 5390768, 5213673, 5394306, 5432973, 5388634, 5213052, 5285157, 5429244, 5247330, 5400303, 5393332, 5298894, 5135520, 5163051, 5353994, 5310996, 5183366, 5355802, 5134270, 5159759, 5262630, 5286790, 5363681, 5188290, 5177417, 5215953, 5335107, 5275094, 5363729, 5391845, 5182460, 5136297, 5154682, 5157032, 5387985, 5202737, 5173857, 5443192, 5364480, 5394676, 5324570, 5237377, 5142610, 5194081, 5386549, 5365051, 5152013, 5356716, 5380628, 5181387, 5167230, 5304488, 5226348, 5237362, 5303459, 5431508, 5196581, 5200773, 5161667, 5193920, 5286776, 5436604, 5394582, 5396289, 5162900, 5182658, 5137326, 5171392, 5440920, 5383686, 5394785, 5143008, 5260186, 5170362, 5348625, 5393015, 5153785, 5144974, 5158247, 5146820, 5299482, 5413950, 5154980, 5139876, 5439824, 5156988, 5210395, 5147483, 5253296, 5393016, 5179550, 5388887, 5298934, 5329093, 5352090, 5388904, 5331423, 5335289, 5367853, 5165076, 5197420, 5391938, 5171764, 5185574, 5394131, 5198278, 5350550);

Date: 2024-12-25 20:26:04 Duration: 5ms

9

565,754

Details

37s941ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 25	00	5,814	350ms	0ms
	01	7,183	456ms	0ms
	02	4,705	368ms	0ms
	03	3,961	222ms	0ms
	04	5,136	284ms	0ms
	05	3,376	184ms	0ms
	06	5,866	304ms	0ms
	07	4,253	238ms	0ms
	08	11,326	622ms	0ms
	09	35,282	2s184ms	0ms
	10	49,479	3s330ms	0ms
	11	52,607	3s327ms	0ms
	12	47,159	2s879ms	0ms
	13	52,936	4s171ms	0ms
	14	46,918	3s208ms	0ms
	15	47,102	3s16ms	0ms
	16	42,383	2s854ms	0ms
	17	39,570	3s18ms	0ms
	18	32,562	2s407ms	0ms
	19	24,965	1s763ms	0ms
	20	18,442	1s338ms	0ms
	21	14,599	877ms	0ms
	22	10,130	531ms	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 (10);

Date: 2024-12-25 18:59:18 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 (75, 79, 22, 74, 30, 13);

Date: 2024-12-25 18:34:03 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 (85);

Date: 2024-12-25 17:21:59 Duration: 1ms

10

414,864

Details

2m19s

0ms

5ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,441	1s89ms	0ms
	01	2,205	707ms	0ms
	02	1,655	553ms	0ms
	03	1,255	408ms	0ms
	04	1,248	409ms	0ms
	05	1,031	317ms	0ms
	06	1,365	423ms	0ms
	07	1,890	552ms	0ms
	08	6,978	2s185ms	0ms
	09	21,735	7s55ms	0ms
	10	29,358	10s145ms	0ms
	11	35,002	11s238ms	0ms
	12	39,227	12s420ms	0ms
	13	53,795	19s427ms	0ms
	14	42,832	14s265ms	0ms
	15	37,316	12s216ms	0ms
	16	35,918	12s154ms	0ms
	17	34,637	12s808ms	0ms
	18	18,145	6s435ms	0ms
	19	17,642	5s927ms	0ms
	20	14,059	4s789ms	0ms
	21	8,844	2s736ms	0ms
	22	5,286	1s496ms	0ms

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

Date: 2024-12-25 09:52:41 Duration: 5ms
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 = 1080) OR r.global) ORDER BY r.id;

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

Date: 2024-12-25 21:42:01 Duration: 4ms

11

395,249

Details

1m16s

0ms

15ms

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
Dec 25	00	3,849	699ms	0ms
	01	4,964	840ms	0ms
	02	2,789	523ms	0ms
	03	2,329	464ms	0ms
	04	3,036	596ms	0ms
	05	2,347	443ms	0ms
	06	3,641	629ms	0ms
	07	2,882	486ms	0ms
	08	8,907	1s442ms	0ms
	09	27,958	4s972ms	0ms
	10	35,183	6s890ms	0ms
	11	37,720	7s155ms	0ms
	12	33,439	6s240ms	0ms
	13	37,528	8s72ms	0ms
	14	36,252	6s755ms	0ms
	15	31,936	5s973ms	0ms
	16	30,124	5s856ms	0ms
	17	27,794	6s55ms	0ms
	18	21,126	4s259ms	0ms
	19	15,571	3s76ms	0ms
	20	10,951	2s326ms	0ms
	21	8,226	1s535ms	0ms
	22	6,697	1s153ms	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 (8006454, 8006460, 8006462, 8006459, 8006428, 8006595, 8006456, 8006461, 8006453, 8006457, 8006463, 8006330, 8006458, 8006534, 8007571, 8004679, 8006353, 8006311, 8007493, 8006403, 8006469, 8006455, 8007305, 8004699, 8006439, 8006711, 8006401, 8007492, 8006331, 8004661, 8007485, 8004676, 8004805, 8007030, 8006383, 8004657, 8006417, 8006282, 8006297, 8006397, 8004808, 8004695, 8007563);

Date: 2024-12-25 16:23:43 Duration: 15ms
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 (8006321);

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

Date: 2024-12-25 17:21:59 Duration: 3ms

12

312,931

Details

57s692ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,009	440ms	0ms
	01	2,082	288ms	0ms
	02	1,982	265ms	0ms
	03	1,294	170ms	0ms
	04	1,669	214ms	0ms
	05	1,695	205ms	0ms
	06	1,200	165ms	0ms
	07	1,721	240ms	0ms
	08	6,786	1s10ms	0ms
	09	19,304	3s247ms	0ms
	10	20,707	3s842ms	0ms
	11	25,628	4s585ms	0ms
	12	28,954	5s103ms	0ms
	13	39,275	8s269ms	0ms
	14	30,250	5s678ms	0ms
	15	25,174	4s601ms	0ms
	16	27,094	5s55ms	0ms
	17	26,627	5s539ms	0ms
	18	13,311	2s488ms	0ms
	19	13,644	2s513ms	0ms
	20	10,453	2s38ms	0ms
	21	6,702	1s79ms	0ms
	22	4,370	646ms	0ms

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

Date: 2024-12-25 17:21:59 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 849 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');

Date: 2024-12-25 17:21:59 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1364 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-25 17:35:35 Duration: 3ms

13

280,788

Details

1d14h22m39s

366ms

4s648ms

492ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 25	00	7,932	1h1m5s	462ms
	01	7,871	1h34s	461ms
	02	7,833	59m18s	454ms
	03	7,609	57m10s	450ms
	04	8,920	1h8m1s	457ms
	05	6,445	48m57s	455ms
	06	5,927	45m2s	455ms
	07	3,902	29m21s	451ms
	08	6,268	47m19s	452ms
	09	11,930	1h33m55s	472ms
	10	18,165	2h28m18s	489ms
	11	15,732	2h6m22s	481ms
	12	12,357	1h36m47s	469ms
	13	18,375	2h39m39s	521ms
	14	11,238	1h31m42s	489ms
	15	10,347	1h21m55s	475ms
	16	13,629	1h52m38s	495ms
	17	18,783	2h51m39s	548ms
	18	23,952	3h30m59s	528ms
	19	20,721	2h55m12s	507ms
	20	14,171	2h11m51s	558ms
	21	17,711	2h20m45s	476ms
	22	10,970	1h23m59s	459ms

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

Date: 2024-12-25 20:56:03 Duration: 4s648ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943246)) AND (("shipping_track"."id" not in (32138970, 32138970)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:56:36 Duration: 4s380ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943147)) AND (("shipping_track"."id" not in (32138568, 32138568)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:54:22 Duration: 4s269ms

14

264,740

Details

1m11s

0ms

40ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,795	941ms	0ms
	01	4,434	1s638ms	0ms
	02	2,464	684ms	0ms
	03	2,268	652ms	0ms
	04	3,051	962ms	0ms
	05	2,115	607ms	0ms
	06	3,125	893ms	0ms
	07	1,818	597ms	0ms
	08	4,615	1s188ms	0ms
	09	15,074	4s237ms	0ms
	10	21,422	6s335ms	0ms
	11	22,763	5s957ms	0ms
	12	20,127	5s22ms	0ms
	13	22,643	6s559ms	0ms
	14	22,069	5s640ms	0ms
	15	21,224	5s288ms	0ms
	16	19,235	4s853ms	0ms
	17	19,001	5s510ms	0ms
	18	16,402	4s407ms	0ms
	19	12,573	3s391ms	0ms
	20	11,620	3s588ms	0ms
	21	8,069	1s886ms	0ms
	22	4,833	1s97ms	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 (41564225, 41612035, 41569236, 41471388, 41510460, 41547374, 41618993, 41493043, 40980509, 40631131, 41577870, 41331932, 41583655, 41553580, 34002151, 41552084, 41626169, 41624236, 41513155, 41579376, 41499584, 41571278, 41588679, 41650409, 40435730, 41493619, 41252460, 41544126, 41537902, 41684143, 41639313, 41629948, 41591866, 41542571, 41501401, 41492036, 41500679, 41609388, 41440453, 41283013, 41581891, 40872201, 41452741, 41591316, 41641648, 41615066, 41550301, 41567552, 41591391, 41531083, 41537365, 41618838, 41571784, 41639839, 41639840, 41381460, 41661953, 41467988, 41252612, 41454919, 41454920, 41578056, 41577745, 41577751, 41628851, 41628816, 41580726, 41665274, 41639688, 41639858, 41628973, 41639730, 41640454, 41629969, 41635363, 41641514, 41641520, 32639147, 39996029, 41522143, 41491114, 41622056, 41663717, 41348253, 41553572, 41641684, 41686048, 41678942, 41184226, 41592084, 41198528, 41567999, 41605257, 41632754, 41594249, 41660795, 41409940, 41591445, 41592851, 41588573, 41689910, 41530583, 41602232, 41647044, 41642532, 41649680, 41654777, 41639594, 41684679, 41619823, 41677153, 41571869, 41544335, 41542108, 41287737, 41640064, 41647253, 41641808, 41581610, 41628902, 41518378, 41606766, 41639753, 41481188, 41585754, 41696697, 40884074, 41594099, 41578340, 41459170, 32638589, 41543018, 41373180, 41701860, 41568322, 41593168, 41129259, 41229218, 41119908, 41654623, 41679029, 41618155, 41416313, 41442127, 32638185, 41647461, 41603117, 41585642, 41375141, 41650436, 41605124, 41609825, 41515538, 41433609, 41382528, 41603097, 41540523, 32645733);

Date: 2024-12-25 17:21:59 Duration: 40ms
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 (32647641, 41399253, 41042075, 32647636, 41421455, 41407902, 32649839, 32648325, 41457245, 41403783, 41363895, 41128725, 41403711, 41403707, 40967576, 41363847, 41403672, 41403661, 41229092, 41428934, 41482916, 41483316, 40825670, 41191935, 41479059, 41408715, 41418502, 41425293, 41458111, 41345049, 40590246, 41395156, 41399487, 41424960, 41366216, 41390815, 41437328, 41437449, 41365926, 32572030, 41422700, 41399197, 41112587, 41371555, 41081014, 40974066, 32645242, 41228992, 41365285, 41305802, 41280884, 41078706, 41428217, 41464592, 40968185, 41311572, 41310507, 41310515, 41254068, 41378458, 41310208, 41193265, 41281855, 32646246, 41137227, 41183418, 41214879, 41251966, 41136132, 40929438, 41396486, 40974083, 41431451, 40972314, 40972090, 41431325, 41334773, 41342473, 41342472, 40729273, 41271419, 41474663, 41268928, 41466403, 41422553, 41265140, 41433493, 41457412, 41457465, 41457472, 41354277, 41420151, 41457407, 41389457, 41389235, 41420199, 41309161, 40974074, 40973652, 40973899);

Date: 2024-12-25 18:08:50 Duration: 17ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41611654, 39308352, 41753341, 41404239, 41658929, 41324618, 41279007, 41686021, 41461815, 41717205, 38939752, 41374488, 41508571, 41691927, 41794477, 41753367, 41789643, 41678816, 41723425, 41588721, 41787098, 41492634, 41671371, 41789106, 41279369, 41803888, 41648060, 41731935, 41753314, 41792412, 38939756, 41794192, 41643188, 41758092, 41669861, 41328911, 41097591, 41656555, 41750954, 41670076, 41669840, 41691851, 41748636, 41668145, 41722381, 41729150, 41829420, 41572550, 41669576, 41490483, 41580631, 41724937, 41798738, 41616781, 41789188, 41789172, 41359591, 41736941, 41728488, 41410707, 41725878, 41692085, 41657788, 41523741, 41577386, 41577390, 41578549, 41795068, 41415935);

Date: 2024-12-25 17:21:59 Duration: 15ms

15

196,254

Details

16s597ms

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
Dec 25	00	1,990	147ms	0ms
	01	2,914	237ms	0ms
	02	1,603	127ms	0ms
	03	1,580	131ms	0ms
	04	2,138	168ms	0ms
	05	1,239	100ms	0ms
	06	2,069	153ms	0ms
	07	1,056	73ms	0ms
	08	3,890	260ms	0ms
	09	13,211	1s78ms	0ms
	10	19,220	1s688ms	0ms
	11	19,633	1s465ms	0ms
	12	16,871	1s129ms	0ms
	13	18,073	1s683ms	0ms
	14	17,031	1s463ms	0ms
	15	16,654	1s118ms	0ms
	16	14,147	1s126ms	0ms
	17	12,136	1s286ms	0ms
	18	10,869	1s215ms	0ms
	19	8,039	968ms	0ms
	20	4,919	485ms	0ms
	21	4,174	300ms	0ms
	22	2,798	186ms	0ms

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

Date: 2024-12-25 17:57:16 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: 2024-12-25 20:35:07 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-25 11:20:24 Duration: 1ms

16

184,087

Details

1m45s

0ms

24ms

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"."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
Dec 25	00	621	482ms	0ms
	01	1,353	2s364ms	1ms
	02	205	145ms	0ms
	03	175	118ms	0ms
	04	223	150ms	0ms
	05	216	129ms	0ms
	06	469	188ms	0ms
	07	672	259ms	0ms
	08	1,374	705ms	0ms
	09	6,925	3s932ms	0ms
	10	9,056	6s78ms	0ms
	11	13,841	7s188ms	0ms
	12	8,515	5s420ms	0ms
	13	13,889	9s68ms	0ms
	14	13,099	9s274ms	0ms
	15	11,165	6s948ms	0ms
	16	10,269	5s563ms	0ms
	17	11,365	6s565ms	0ms
	18	18,793	10s573ms	0ms
	19	17,742	9s579ms	0ms
	20	18,460	10s108ms	0ms
	21	13,329	5s968ms	0ms
	22	12,331	4s374ms	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"."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 (10507, 10503, 10496, 10476, 10474, 10472, 10470, 10468, 10464, 10456, 34854, 117009, 116984, 103225, 143363, 143362, 143361, 143360, 143359, 143358);

Date: 2024-12-25 17:56:40 Duration: 24ms
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"."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 (3753993, 3750812, 3753586, 3746577, 3746445, 3233731, 3753954, 3527791, 3745404, 3750909, 3750945, 3746444, 3724701, 3750938, 3727435, 3753532, 3750762, 3750942, 3750773, 3753588, 3267287, 3624531, 3722800, 3683825, 3746552, 3728047, 3683836, 3719435, 3722881, 3419191, 3704090, 3022110, 3719531, 3694997, 3695014, 3683895, 3659338, 3683847, 3621667, 3683809, 3683938, 3624527, 3657947, 3657967, 3691765, 3609033, 3683831, 3600917, 3683942, 3657925, 3655477, 3683834, 3683812, 3687521, 3657920, 3683806, 3692856, 3683844, 3694696, 3624491, 3529852, 3601423, 3624489, 3402969, 3402901, 3652979, 3601444, 3644347, 3659352, 3657941, 3621956, 3657962, 3601561, 3644198, 3603038, 3618034, 3587674, 3600984, 3403010, 3624496, 2510622, 3600994, 3625484, 3624523, 3586146, 3659390, 3141342, 3600979, 3624518, 3625493, 3625483, 3644360, 3361470, 3137929, 3419184, 3358683, 3603045, 3621967, 3624492, 3624488, 3587679, 3624525, 3601473, 3052003, 3601589, 3621712, 3625491, 3625487, 3596297, 3602025, 3624499, 3625492, 3625490, 3601440, 3601368, 3601442, 3601374, 3601376, 3587668, 3535674, 3598851, 3403367, 3601540, 3603048, 3583953, 3601371, 3172640, 3267278, 2320046, 3469538, 3535676, 3540414, 3404422, 3542575, 3415442, 3304403, 2321777, 3467221, 3428334, 3131613, 3349179, 3415573, 3077397, 3387770, 3022930, 2719684, 3364436, 3310629, 3310679, 3386066, 3382118, 3386112, 3404469, 3267275, 3310707, 3306545, 3155351, 3310632, 3349184, 3310684, 3310754, 3306486, 3310626, 3310645, 3310653, 3310640, 3310635, 3310715, 3306543, 3306551, 3157109, 3310728, 3310749, 3229832, 3160817, 3229824, 3166060, 3194744, 3165953, 3157038, 3124773, 2768303, 2768286, 2265419);

Date: 2024-12-25 19:24:24 Duration: 18ms
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"."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 (3720542, 3720521, 3534911, 3647492, 3654670, 3673157, 3666662, 3704150, 3654883, 3686549, 3686458, 3654947, 3639843, 3430315, 3645473, 3579484, 3645479, 3668414, 3639630, 3647518, 3686595, 3689773, 3689496, 3414631, 3609692, 3647500, 3654797, 3639492, 3664963, 3609771, 3667740, 3639475, 3622362, 3609780, 3072833, 3647633, 3609756, 3700731, 3622365, 3622363, 3668361, 3622376, 3520841, 3579641, 3579980, 3609769, 3609687, 3579989, 3441379, 3579839, 3622366, 3579847, 3579529, 3579871, 3579858, 3574401, 3579662, 3457440, 3393584, 3557906, 3520840, 3526354, 3491269, 3493627, 3457451, 2530984, 2237650);

Date: 2024-12-25 01:41:31 Duration: 16ms

17

178,416

Details

10s844ms

0ms

16ms

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
Dec 25	00	1,481	79ms	0ms
	01	886	45ms	0ms
	02	659	33ms	0ms
	03	454	23ms	0ms
	04	464	24ms	0ms
	05	377	18ms	0ms
	06	536	27ms	0ms
	07	808	39ms	0ms
	08	2,940	155ms	0ms
	09	9,342	530ms	0ms
	10	12,251	751ms	0ms
	11	14,906	861ms	0ms
	12	17,189	980ms	0ms
	13	23,226	1s593ms	0ms
	14	18,679	1s119ms	0ms
	15	16,261	945ms	0ms
	16	15,336	937ms	0ms
	17	15,094	1s31ms	0ms
	18	7,586	472ms	0ms
	19	7,626	461ms	0ms
	20	6,237	392ms	0ms
	21	3,811	208ms	0ms
	22	2,267	110ms	0ms

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

Date: 2024-12-25 13:57:27 Duration: 16ms
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 (13);

Date: 2024-12-25 19:33:16 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 (99);

Date: 2024-12-25 13:33:08 Duration: 0ms

18

171,738

Details

22s183ms

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
Dec 25	00	1,462	164ms	0ms
	01	875	94ms	0ms
	02	653	71ms	0ms
	03	452	48ms	0ms
	04	460	49ms	0ms
	05	367	37ms	0ms
	06	521	55ms	0ms
	07	795	81ms	0ms
	08	2,853	318ms	0ms
	09	9,158	1s94ms	0ms
	10	11,874	1s549ms	0ms
	11	14,271	1s738ms	0ms
	12	16,457	1s959ms	0ms
	13	22,414	3s286ms	0ms
	14	18,078	2s307ms	0ms
	15	15,604	1s918ms	0ms
	16	14,578	1s886ms	0ms
	17	14,510	2s157ms	0ms
	18	7,302	976ms	0ms
	19	7,170	931ms	0ms
	20	5,968	809ms	0ms
	21	3,674	419ms	0ms
	22	2,242	225ms	0ms

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

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

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

Date: 2024-12-25 17:28:24 Duration: 1ms

19

159,246

Details

1h49m22s

30ms

237ms

41ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,638	2m18s	38ms
	01	2,942	1m52s	38ms
	02	2,028	1m17s	38ms
	03	1,960	1m15s	38ms
	04	3,122	1m59s	38ms
	05	1,745	1m6s	38ms
	06	1,645	1m3s	38ms
	07	1,167	44s821ms	38ms
	08	2,261	1m27s	38ms
	09	7,713	5m9s	40ms
	10	13,416	9m17s	41ms
	11	12,784	8m47s	41ms
	12	10,192	6m51s	40ms
	13	15,694	11m32s	44ms
	14	8,850	6m4s	41ms
	15	9,011	6m5s	40ms
	16	9,953	6m51s	41ms
	17	12,268	8m57s	43ms
	18	12,500	8m49s	42ms
	19	10,087	6m52s	40ms
	20	7,485	5m24s	43ms
	21	5,856	3m45s	38ms
	22	2,929	1m49s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3873389, 3865464, 3832487, 3498158)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:54 Duration: 237ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3943134)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:12 Duration: 220ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3837793)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:56:21 Duration: 217ms

20

157,812

Details

54s694ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 25	00	8,261	2s578ms	0ms
	01	7,675	2s528ms	0ms
	02	5,858	2s234ms	0ms
	03	5,161	2s31ms	0ms
	04	6,091	2s251ms	0ms
	05	5,300	1s917ms	0ms
	06	5,699	1s969ms	0ms
	07	3,279	1s170ms	0ms
	08	2,782	1s180ms	0ms
	09	1,481	749ms	0ms
	10	2,058	1s52ms	0ms
	11	1,775	836ms	0ms
	12	1,558	690ms	0ms
	13	2,285	963ms	0ms
	14	4,770	1s645ms	0ms
	15	2,494	875ms	0ms
	16	8,877	2s928ms	0ms
	17	16,027	5s993ms	0ms
	18	15,281	5s227ms	0ms
	19	12,953	4s108ms	0ms
	20	21,809	7s59ms	0ms
	21	11,998	3s483ms	0ms
	22	4,340	1s216ms	0ms

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

Date: 2024-12-25 17:22:18 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 35) AND ("price_list"."to_office_id" = 35)) ORDER BY "price_list"."id";

Date: 2024-12-25 19:18:18 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 24) AND ("price_list"."to_office_id" = 115)) ORDER BY "price_list"."id";

Date: 2024-12-25 13:43:42 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

48m15s

2m54s

31

Details

1h30m6s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 25	04	1	1ms	1ms
	05	1	0ms	0ms
	08	2	2ms	1ms
	10	3	4ms	1ms
	11	3	0ms	0ms
	13	4	5ms	1ms
	14	1	1ms	1ms
	16	1	0ms	0ms
	17	2	1ms	0ms
	18	1	0ms	0ms
	19	5	48m15s	9m39s
	20	5	41m51s	8m22s
	21	2	3ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-25 18:19:06.199511', "last_update" = '2024-12-25 17:34:06.199542', "write_date" = '2024-12-25 17:34:05.749351', "write_uid" = 1357 WHERE id IN (1357);

Date: 2024-12-25 19:22:21 Duration: 48m15s
UPDATE "res_users" SET "exp_date" = '2024-12-25 19:21:29.928118', "last_update" = '2024-12-25 18:36:29.928152', "write_date" = '2024-12-25 18:36:29.490364', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-25 20:18:21 Duration: 41m51s
UPDATE "res_users" SET "exp_date" = '2024-12-25 10:39:06.514039', "last_update" = '2024-12-25 09:54:06.514065', "write_date" = '2024-12-25 09:54:06.151912', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-25 10:54:06 Duration: 2ms

2

0ms

37m54s

59s985ms

345

Details

5h44m54s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 25	00	7	9ms	1ms
	01	3	3ms	1ms
	02	2	0ms	0ms
	03	2	0ms	0ms
	04	1	0ms	0ms
	05	1	0ms	0ms
	06	1	0ms	0ms
	07	4	0ms	0ms
	08	17	4ms	0ms
	09	28	18ms	0ms
	10	36	1h5m44s	1m49s
	11	40	48m29s	1m12s
	12	22	30ms	1ms
	13	38	8m22s	13s215ms
	14	27	2m28s	5s500ms
	15	28	9m9s	19s608ms
	16	20	15m42s	47s144ms
	17	15	4m10s	16s698ms
	18	12	10ms	0ms
	19	18	37m21s	2m4s
	20	11	1m19s	7s211ms
	21	3	15m14s	5m4s
	22	9	2h16m52s	15m12s

UPDATE "res_users" SET "exp_date" = '2024-12-25 21:33:26.840851', "last_update" = '2024-12-25 20:48:26.840873', "sid" = '8f65279a9393712c75d4bc1fb6449452b2e3c747', "write_date" = '2024-12-25 20:48:26.513559', "write_uid" = 1 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 37m54s
UPDATE "res_users" SET "exp_date" = '2024-12-25 21:33:37.682146', "last_update" = '2024-12-25 20:48:37.682170', "sid" = '8f65279a9393712c75d4bc1fb6449452b2e3c747', "write_date" = '2024-12-25 20:48:37.355320', "write_uid" = 1294 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 37m43s
UPDATE "res_users" SET "exp_date" = '2024-12-25 21:38:51.892549', "last_update" = '2024-12-25 20:53:51.892567', "sid" = 'cb23fc7d8e2e6377de2159dfd37b6d7910899b39', "write_date" = '2024-12-25 20:53:51.572566', "write_uid" = 1 WHERE id IN (1294);

Date: 2024-12-25 22:26:21 Duration: 32m29s

3

0ms

50m57s

4s402ms

84,691

Details

4d7h33m46s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 25	00	736	174ms	0ms
	01	957	216ms	0ms
	02	1,084	243ms	0ms
	03	1,064	2s590ms	2ms
	04	963	216ms	0ms
	05	725	159ms	0ms
	06	698	157ms	0ms
	07	505	111ms	0ms
	08	1,661	365ms	0ms
	09	5,156	7h14m9s	5s52ms
	10	7,216	2h40m43s	1s336ms
	11	8,000	12h57m48s	5s833ms
	12	7,811	12h51m47s	5s928ms
	13	8,808	4h31m3s	1s846ms
	14	7,542	7h46m50s	3s713ms
	15	7,110	4h57m55s	2s514ms
	16	6,353	6h52m1s	3s891ms
	17	6,508	3h20m53s	1s852ms
	18	3,854	13m44s	213ms
	19	2,999	7h10m35s	8s614ms
	20	2,210	9h19m19s	15s185ms
	21	1,600	8h47m3s	19s764ms
	22	1,131	14h49m45s	47s201ms

update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.067299', exp_date = '2024-12-25 21:20:24.067301', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 50m57s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:35:24.066861', exp_date = '2024-12-25 21:20:24.066864', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 50m57s
update res_users set sid = 'd8f863f1d25944808cf682bc0bfd43d09e781095', last_update = '2024-12-25 20:36:45.248057', exp_date = '2024-12-25 21:21:45.248060', logged_in = 'TRUE' where id = 1294;

Date: 2024-12-25 22:26:21 Duration: 49m35s

4

12ms

4s835ms

2s832ms

300

Details

14m9s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 25	09	15	54s98ms	3s606ms
	10	17	41s280ms	2s428ms
	11	14	21s790ms	1s556ms
	12	16	53s547ms	3s346ms
	13	8	13s826ms	1s728ms
	14	14	35s806ms	2s557ms
	15	34	1m4s	1s906ms
	16	37	1m52s	3s27ms
	17	29	1m46s	3s682ms
	18	21	56s902ms	2s709ms
	19	17	54s715ms	3s218ms
	20	60	3m	3s12ms
	21	6	18s876ms	3s146ms
	22	12	34s455ms	2s871ms

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

Date: 2024-12-25 17:25:49 Duration: 4s835ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))) 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 (73)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))))) 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 (73)))))))) AND ("policy_number"."name"::text ilike '%9384455%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-25 13:10:57 Duration: 4s581ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))) 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 (73)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))))))) 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 (73)))))))) AND ("policy_number"."name"::text ilike '%938%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-25 13:10:56 Duration: 4s534ms

5

37ms

2s64ms

874ms

10,444

Details

2h32m11s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 25	00	746	7m33s	608ms
	01	551	5m3s	551ms
	02	351	5m48s	994ms
	10	19	19s808ms	1s42ms
	11	2	2s319ms	1s159ms
	13	191	3m39s	1s147ms
	14	238	4m27s	1s125ms
	15	178	3m2s	1s27ms
	16	905	11m6s	736ms
	17	905	15m40s	1s39ms
	18	1,177	17m50s	909ms
	19	711	12m17s	1s36ms
	20	2,626	38m8s	871ms
	21	1,156	16m15s	844ms
	22	688	10m53s	949ms

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

Date: 2024-12-25 20:56:22 Duration: 2s64ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9596128')) 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 (14, 74, 70))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:51 Duration: 2s22ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9405503')) 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 (29))))))) 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 (29)))))) 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 (29)))))) 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 (29))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:27 Duration: 1s955ms

6

387ms

4s72ms

504ms

47,112

Details

6h36m22s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 25	00	290	2m20s	484ms
	01	179	1m31s	511ms
	02	172	1m27s	510ms
	03	161	1m24s	524ms
	04	176	1m30s	513ms
	05	196	1m38s	503ms
	06	194	1m32s	476ms
	07	213	1m39s	468ms
	08	1,297	9m51s	456ms
	09	3,256	26m19s	485ms
	10	3,681	31m22s	511ms
	11	3,915	32m3s	491ms
	12	2,927	23m47s	487ms
	13	5,029	44m36s	532ms
	14	3,684	30m29s	496ms
	15	3,298	26m37s	484ms
	16	3,898	32m11s	495ms
	17	4,672	41m49s	537ms
	18	3,311	29m45s	539ms
	19	2,370	19m53s	503ms
	20	1,679	14m42s	525ms
	21	1,443	11m33s	480ms
	22	1,071	8m12s	460ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3908756, 3882681, 3847076, 3841673, 3805399)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 17:53:59 Duration: 4s72ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3939424, 3939414, 3939411, 3939406, 3939404, 3939396, 3939394)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:55:57 Duration: 3s884ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3933724, 3933713, 3933462, 3933441, 3933423, 3931331)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:56:21 Duration: 3s613ms

7

366ms

4s648ms

492ms

280,788

Details

1d14h22m39s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 25	00	7,932	1h1m5s	462ms
	01	7,871	1h34s	461ms
	02	7,833	59m18s	454ms
	03	7,609	57m10s	450ms
	04	8,920	1h8m1s	457ms
	05	6,445	48m57s	455ms
	06	5,927	45m2s	455ms
	07	3,902	29m21s	451ms
	08	6,268	47m19s	452ms
	09	11,930	1h33m55s	472ms
	10	18,165	2h28m18s	489ms
	11	15,732	2h6m22s	481ms
	12	12,357	1h36m47s	469ms
	13	18,375	2h39m39s	521ms
	14	11,238	1h31m42s	489ms
	15	10,347	1h21m55s	475ms
	16	13,629	1h52m38s	495ms
	17	18,783	2h51m39s	548ms
	18	23,952	3h30m59s	528ms
	19	20,721	2h55m12s	507ms
	20	14,171	2h11m51s	558ms
	21	17,711	2h20m45s	476ms
	22	10,970	1h23m59s	459ms

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

Date: 2024-12-25 20:56:03 Duration: 4s648ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943246)) AND (("shipping_track"."id" not in (32138970, 32138970)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:56:36 Duration: 4s380ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3943147)) AND (("shipping_track"."id" not in (32138568, 32138568)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-25 20:54:22 Duration: 4s269ms

8

221ms

2s153ms

337ms

23,243

Details

2h10m41s

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
Dec 25	00	998	5m13s	314ms
	01	945	4m59s	316ms
	02	493	2m36s	318ms
	03	682	3m35s	315ms
	04	915	4m50s	317ms
	05	851	4m28s	315ms
	06	996	5m9s	310ms
	07	526	2m43s	310ms
	08	273	1m23s	307ms
	09	55	18s320ms	333ms
	10	114	39s340ms	345ms
	11	184	1m4s	347ms
	12	160	53s141ms	332ms
	13	242	1m32s	380ms
	14	845	4m49s	342ms
	15	353	2m2s	347ms
	16	1,262	7m25s	353ms
	17	3,123	19m22s	372ms
	18	2,662	15m46s	355ms
	19	2,508	13m51s	331ms
	20	2,847	16m34s	349ms
	21	1,836	9m31s	311ms
	22	373	1m49s	293ms

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

Date: 2024-12-25 20:55:35 Duration: 2s153ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510667')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 20:56:38 Duration: 2s125ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510395')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-25 18:45:48 Duration: 2s14ms

9

206ms

584ms

300ms

24,836

Details

2h4m31s

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
Dec 25	09	2,005	9m18s	278ms
	10	1,461	8m10s	335ms
	11	964	4m45s	296ms
	12	863	4m13s	294ms
	13	4,055	21m19s	315ms
	14	3,524	17m13s	293ms
	15	3,478	16m55s	292ms
	16	2,470	11m59s	291ms
	17	4,048	20m47s	308ms
	18	1,417	7m21s	311ms
	19	551	2m26s	266ms

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

Date: 2024-12-25 13:39:10 Duration: 584ms
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" = '9542156')))) ORDER BY "collection_policy"."id";

Date: 2024-12-25 10:15:33 Duration: 552ms
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" = '9157135')))) ORDER BY "collection_policy"."id";

Date: 2024-12-25 10:15:43 Duration: 551ms

10

188ms

379ms

242ms

3,320

Details

13m23s

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 true order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 25	13	2,505	10m9s	243ms
	18	734	2m57s	241ms
	19	81	17s713ms	218ms

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

Date: 2024-12-25 18:49:12 Duration: 379ms
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" = '7510674')) AND TRUE ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 18:49:02 Duration: 349ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9615761')) AND TRUE ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 13:24:52 Duration: 344ms

11

175ms

1s663ms

241ms

155,152

Details

10h25m14s

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
Dec 25	00	1,419	5m4s	214ms
	01	1,674	6m	215ms
	02	2,678	9m43s	217ms
	03	2,709	9m46s	216ms
	04	2,501	9m5s	218ms
	05	2,546	9m9s	215ms
	06	2,613	9m27s	217ms
	07	1,608	5m45s	214ms
	08	1,669	6m2s	217ms
	09	7,597	29m1s	229ms
	10	5,879	23m40s	241ms
	11	4,485	17m54s	239ms
	12	2,363	8m56s	226ms
	13	12,766	53m2s	249ms
	14	6,895	27m15s	237ms
	15	7,373	28m54s	235ms
	16	8,457	33m11s	235ms
	17	11,937	48m25s	243ms
	18	15,309	1h40s	237ms
	19	15,329	59m18s	232ms
	20	32,333	2h26m49s	272ms
	21	4,154	15m12s	219ms
	22	858	2m45s	192ms

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

Date: 2024-12-25 20:56:23 Duration: 1s663ms
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" = '9417933')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 20:55:54 Duration: 1s653ms
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" = '9548527')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-25 20:54:17 Duration: 1s642ms

12

90ms

916ms

241ms

66,597

Details

4h28m6s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,468	11m47s	203ms
	01	2,964	10m31s	213ms
	02	1,674	6m3s	216ms
	03	1,318	5m	227ms
	04	1,794	6m36s	220ms
	05	1,662	6m40s	241ms
	06	1,969	7m19s	222ms
	07	1,047	3m47s	217ms
	08	538	1m58s	219ms
	09	104	18s38ms	173ms
	10	248	50s140ms	202ms
	11	360	1m21s	225ms
	12	310	1m11s	229ms
	13	858	3m56s	276ms
	14	2,144	9m29s	265ms
	15	1,056	4m10s	237ms
	16	4,276	17m35s	246ms
	17	7,961	38m22s	289ms
	18	7,622	33m34s	264ms
	19	6,384	26m25s	248ms
	20	10,865	41m51s	231ms
	21	5,901	22m45s	231ms
	22	2,074	6m29s	187ms

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

Date: 2024-12-25 15:32:52 Duration: 916ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'علاء')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-25 20:24:38 Duration: 913ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'هشام')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-25 20:24:38 Duration: 913ms

13

186ms

1s71ms

231ms

6,379

Details

24m38s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 25	00	311	1m7s	215ms
	01	15	3s149ms	209ms
	06	656	2m22s	217ms
	07	179	38s85ms	212ms
	08	339	1m13s	215ms
	09	379	1m25s	226ms
	10	1,460	5m54s	242ms
	11	188	43s340ms	230ms
	12	119	28s46ms	235ms
	13	252	1m2s	246ms
	14	530	2m4s	235ms
	15	814	3m6s	229ms
	16	858	3m23s	237ms
	17	206	48s644ms	236ms
	18	73	16s818ms	230ms

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

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

Date: 2024-12-25 17:53:09 Duration: 400ms
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" = '9467541')) 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: 2024-12-25 10:15:32 Duration: 364ms

14

177ms

498ms

231ms

14,637

Details

56m27s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 25	00	6	1s307ms	217ms
	01	96	20s708ms	215ms
	03	405	1m27s	216ms
	04	547	1m59s	219ms
	05	664	2m22s	214ms
	06	1,109	3m59s	216ms
	07	927	3m19s	215ms
	08	1,035	3m44s	217ms
	09	1,507	5m44s	228ms
	10	901	3m36s	239ms
	11	1,107	4m25s	240ms
	12	344	1m16s	222ms
	13	1,549	6m42s	259ms
	14	1,225	4m48s	235ms
	15	428	1m41s	236ms
	16	584	2m19s	239ms
	17	1,188	4m58s	251ms
	18	198	41s222ms	208ms
	19	359	1m20s	225ms
	20	265	58s136ms	219ms
	21	193	38s641ms	200ms

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

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

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

Date: 2024-12-25 11:12:32 Duration: 417ms

15

195ms

271ms

216ms

12,751

Details

46m4s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 25	00	1,088	3m53s	214ms
	01	1,391	4m59s	214ms
	02	2,630	9m33s	217ms
	03	2,304	8m18s	216ms
	04	1,954	7m6s	218ms
	05	1,876	6m45s	216ms
	06	849	3m4s	217ms
	07	367	1m19s	216ms
	08	292	1m4s	220ms

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

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

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

Date: 2024-12-25 04:24:26 Duration: 269ms

16

121ms

792ms

148ms

5,763

Details

14m13s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 25	00	17	2s226ms	130ms
	04	4	513ms	128ms
	05	5	647ms	129ms
	07	5	661ms	132ms
	08	113	14s967ms	132ms
	09	291	41s663ms	143ms
	10	1,034	2m33s	148ms
	11	1,079	2m37s	146ms
	12	858	2m1s	142ms
	13	767	2m	157ms
	14	380	55s809ms	146ms
	15	315	44s388ms	140ms
	16	228	33s980ms	149ms
	17	232	40s722ms	175ms
	18	215	33s85ms	153ms
	19	113	16s479ms	145ms
	20	29	4s188ms	144ms
	21	52	7s172ms	137ms
	22	26	3s427ms	131ms

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

Date: 2024-12-25 17:53:09 Duration: 792ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 102)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-25 17:53:51 Duration: 523ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 19)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-25 17:53:17 Duration: 376ms

17

78ms

692ms

100ms

22,938

Details

38m20s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 25	07	28	2s556ms	91ms
	08	199	19s380ms	97ms
	09	2,523	4m5s	97ms
	10	1,126	1m53s	100ms
	11	2,480	4m7s	99ms
	12	2,311	3m41s	95ms
	13	2,672	4m43s	105ms
	14	2,011	3m17s	98ms
	15	2,786	4m30s	96ms
	16	1,642	2m45s	101ms
	17	1,519	2m44s	108ms
	18	976	1m45s	108ms
	19	676	1m8s	101ms
	20	692	1m15s	108ms
	21	550	52s676ms	95ms
	22	747	1m8s	91ms

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

Date: 2024-12-25 20:55:45 Duration: 692ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7882474)) AND (("cash_track"."id" not in (6200661)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-25 18:45:45 Duration: 647ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7883079)) AND (("cash_track"."id" not in (6207085)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-25 20:55:57 Duration: 645ms

18

36ms

285ms

50ms

53,775

Details

45m34s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3	144ms	48ms
	01	1	49ms	49ms
	02	6	286ms	47ms
	06	7	331ms	47ms
	07	13	608ms	46ms
	08	140	6s603ms	47ms
	09	3,832	3m5s	48ms
	10	3,699	3m3s	49ms
	11	2,301	1m56s	50ms
	12	1,889	1m34s	49ms
	13	7,363	6m40s	54ms
	14	4,875	4m	49ms
	15	5,969	4m48s	48ms
	16	6,366	5m16s	49ms
	17	8,254	7m19s	53ms
	18	4,738	4m5s	51ms
	19	3,661	3m2s	49ms
	20	338	17s547ms	51ms
	21	201	9s766ms	48ms
	22	119	5s660ms	47ms

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

Date: 2024-12-25 20:55:50 Duration: 285ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3920983) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-25 11:12:46 Duration: 262ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3680051) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-25 13:39:09 Duration: 253ms

19

33ms

93ms

45ms

20,422

Details

15m39s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 25	08	5	212ms	42ms
	09	1,216	55s120ms	45ms
	10	1,480	1m7s	45ms
	11	882	39s659ms	44ms
	12	822	36s624ms	44ms
	13	3,312	2m36s	47ms
	14	2,389	1m47s	45ms
	15	2,485	1m49s	44ms
	16	2,789	2m5s	44ms
	17	2,772	2m14s	48ms
	18	1,930	1m31s	47ms
	19	339	15s215ms	44ms
	20	1	42ms	42ms

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

Date: 2024-12-25 13:52:37 Duration: 93ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3768905) ORDER BY "collection_policy"."id";

Date: 2024-12-25 13:39:32 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3823138) ORDER BY "collection_policy"."id";

Date: 2024-12-25 18:45:42 Duration: 82ms

20

30ms

237ms

41ms

159,246

Details

1h49m22s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 25	00	3,638	2m18s	38ms
	01	2,942	1m52s	38ms
	02	2,028	1m17s	38ms
	03	1,960	1m15s	38ms
	04	3,122	1m59s	38ms
	05	1,745	1m6s	38ms
	06	1,645	1m3s	38ms
	07	1,167	44s821ms	38ms
	08	2,261	1m27s	38ms
	09	7,713	5m9s	40ms
	10	13,416	9m17s	41ms
	11	12,784	8m47s	41ms
	12	10,192	6m51s	40ms
	13	15,694	11m32s	44ms
	14	8,850	6m4s	41ms
	15	9,011	6m5s	40ms
	16	9,953	6m51s	41ms
	17	12,268	8m57s	43ms
	18	12,500	8m49s	42ms
	19	10,087	6m52s	40ms
	20	7,485	5m24s	43ms
	21	5,856	3m45s	38ms
	22	2,929	1m49s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3873389, 3865464, 3832487, 3498158)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:54 Duration: 237ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3943134)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:55:12 Duration: 220ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3837793)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-25 20:56:21 Duration: 217ms

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

20,711,684 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	16	0.00%
DETAIL	10,030	0.05%
ERROR	10,220	0.05%
EVENTLOG	1,774	0.01%
FATAL	11,502	0.06%
HINT	6	0.00%
LOG	20,667,864	99.79%
STATEMENT	10,272	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
11502 FATAL entries
10220 ERROR entries
0 WARNING entries
1774 EVENTLOG entries

Most Frequent Errors/Events

Key values

10,010 Max number of times the same event was reported
23,496 Total events found

Rank

Times reported

Error

1

10,010

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 25	10	3,098
	11	3,647
	12	3,100
	13	165

FATAL: password authentication failed for user "postgres"

2

5,249

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 25	00	14
	01	5
	02	6
	03	6
	04	6
	05	4
	06	3
	07	8
	08	50
	09	234
	10	339
	11	518
	12	669
	13	1,016
	14	476
	15	327
	16	459
	17	638
	18	201
	19	112
	20	89
	21	20
	22	49

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

3

4,925

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 25	00	14
	01	4
	02	3
	03	5
	04	5
	05	2
	06	3
	07	8
	08	44
	09	221
	10	320
	11	501
	12	649
	13	967
	14	439
	15	319
	16	438
	17	599
	18	150
	19	95
	20	83
	21	17
	22	39

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

4

1,243

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 25	09	92
	10	23
	11	174
	12	171
	13	168
	14	83
	15	72
	16	124
	17	151
	19	27
	20	82
	21	31
	22	45

5

1,243

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 25	09	92
	10	23
	11	174
	12	171
	13	168
	14	83
	15	72
	16	124
	17	151
	19	27
	20	82
	21	31
	22	45

6

362

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 25	09	35
	10	14
	11	60
	12	52
	13	29
	14	15
	15	28
	16	36
	17	43
	19	9
	20	16
	21	2
	22	23

7

168

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 25	09	21
	10	3
	11	24
	12	29
	13	13
	14	6
	15	11
	16	18
	17	22
	19	4
	20	8
	22	9

8

147

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 25	17	147

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

9

38

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 25	17	38

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

10

26

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 25	17	26

11

10

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 25	00	1
	01	1
	04	1
	07	1
	09	1
	16	3
	17	1
	20	1

12

9

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 25	17	9

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

13

8

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 25	00	1
	01	1
	04	1
	07	1
	09	1
	16	1
	17	1
	20	1

14

8

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 25	00	2
	01	1
	04	1
	07	1
	09	1
	17	1
	20	1

15

8

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 25	00	2
	06	1
	18	1
	21	3
	22	1

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

16

8

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 25	10	1
	11	1
	12	1
	14	2
	15	1
	17	1
	18	1

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

17

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 25	13	3
	14	1
	17	1
	18	1

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

18

6

Details

ERROR: could not create unique index "..."

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 25	10	2
	16	4

ERROR: could not create unique index "bank_deposit_deposite_2_name"

19

5

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 25	11	1
	12	1
	14	1
	17	1
	20	1

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

20

5

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 25	11	1
	12	3
	17	1

21

4

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 25	17	4

22

2

Details

ERROR: could not attach to dynamic shared area

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 25	17	2

ERROR: could not attach to dynamic shared area
ERROR: could not attach to dynamic shared area

23

2

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 25	19	2

ERROR: column change_password_user.is_session does not exist at character 461

24

2

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 25	14	1
	16	1

25

1

Details

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

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 25	10	1

26

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #26

Day	Hour	Count
Dec 25	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables