pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Dec 28 23:47:25 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 40,867,460 log entries in 2m24s
Log start from 2024-12-28 00:00:00 to 2024-12-28 22:45:01

Global Stats

16,942 Number of unique normalized queries
17,575,700 Number of queries
5d15h2m18s Total query duration
2024-12-28 00:00:00 First query
2024-12-28 22:45:01 Last query
6,200 queries/s at 2024-12-28 09:36:12 Query peak

5d15h2m18s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5d15h2m18s Execute total duration

9,661 Number of events
22 Number of unique normalized events
3,794 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
17,575,700 Average queries per session
5d15h2m18s 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,200 queries/s Query Peak
2024-12-28 09:36:12 Date

SELECT Traffic

Key values

4,432 queries/s Query Peak
2024-12-28 09:36:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,227 queries/s Query Peak
2024-12-28 09:36:12 Date

Queries duration

Key values

5d15h2m18s 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 28	00	188,634	0ms	1h	72ms	1m49s	2m26s	3h2m24s
	01	237,688	0ms	3s165ms	18ms	2m21s	2m40s	2m54s
	02	211,931	0ms	694ms	15ms	1m47s	2m3s	2m8s
	03	184,313	0ms	27m43s	213ms	2m3s	3m12s	9h56m57s
	04	136,591	0ms	563ms	18ms	1m28s	1m53s	2m4s
	05	95,707	0ms	563ms	13ms	1m10s	1m32s	1m43s
	06	143,001	0ms	568ms	10ms	1m12s	1m22s	2m7s
	07	167,698	0ms	912ms	9ms	1m2s	1m8s	1m26s
	08	343,527	0ms	11m6s	32ms	1m50s	2m29s	2h18m32s
	09	1,059,982	0ms	10m47s	21ms	5m56s	7m1s	3h12m28s
	10	1,286,129	0ms	20m28s	34ms	6m13s	52m15s	6h14m12s
	11	1,466,191	0ms	4s29ms	9ms	6m4s	6m34s	6m46s
	12	1,569,424	0ms	13m39s	14ms	6m15s	6m35s	2h16m33s
	13	1,502,704	0ms	25m42s	25ms	6m7s	42m30s	4h41m56s
	14	1,392,678	0ms	22m57s	38ms	5m46s	1h12m18s	5h33m7s
	15	1,323,638	0ms	12m57s	22ms	5m20s	7m31s	3h58m32s
	16	1,428,712	0ms	5m58s	26ms	28m38s	1h2m30s	1h21m36s
	17	1,314,290	0ms	1m49s	18ms	11m24s	21m43s	40m10s
	18	1,096,266	0ms	6m16s	25ms	8m27s	32m47s	2h3m45s
	19	975,197	0ms	27m49s	28ms	7m56s	9m19s	3h21m18s
	20	664,131	0ms	10m22s	31ms	4m50s	5m53s	2h55m32s
	21	503,408	0ms	14m47s	48ms	4m31s	5m58s	4h17m12s
	22	283,860	0ms	1h	59ms	3m29s	5m28s	2h34m54s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 28	00	95,418	26ms	1m8s	1m40s	2m25s
	01	123,669	36ms	1m58s	2m21s	2m43s
	02	107,498	30ms	1m34s	1m47s	2m5s
	03	97,339	37ms	1m46s	2m1s	3m11s
	04	69,228	37ms	1m7s	1m28s	2m1s
	05	44,383	28ms	33s728ms	1m10s	1m32s
	06	78,664	19ms	47s162ms	1m12s	1m30s
	07	93,098	16ms	47s206ms	1m2s	1m20s
	08	202,783	14ms	1m30s	1m50s	2m28s
	09	653,527	17ms	4m25s	5m34s	7m
	10	780,628	14ms	4m21s	5m8s	6m12s
	11	838,740	17ms	4m59s	6m3s	6m40s
	12	926,224	15ms	5m21s	6m10s	6m33s
	13	895,129	13ms	4m24s	5m22s	6m29s
	14	822,654	13ms	4m16s	5m22s	5m56s
	15	778,491	14ms	4m5s	4m48s	6m51s
	16	879,208	16ms	5m41s	6m21s	7m14s
	17	791,278	24ms	7m40s	9m38s	11m53s
	18	652,052	24ms	5m48s	7m51s	8m47s
	19	570,750	28ms	6m18s	7m46s	9m18s
	20	399,335	26ms	4m21s	4m47s	5m52s
	21	297,335	30ms	3m22s	4m27s	5m57s
	22	162,801	25ms	2m12s	3m24s	5m27s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 28	00	10,415	2,554	139	0	853ms	67ms	98ms	233ms
	01	20,470	4,827	133	0	0ms	127ms	165ms	282ms
	02	21,783	5,665	133	0	0ms	98ms	136ms	537ms
	03	14,478	3,696	138	0	1s952ms	94ms	130ms	264ms
	04	9,901	2,872	128	0	0ms	63ms	86ms	128ms
	05	4,289	1,317	132	0	0ms	26ms	45ms	111ms
	06	8,452	1,771	133	0	0ms	38ms	72ms	147ms
	07	6,662	2,191	134	0	0ms	39ms	59ms	113ms
	08	11,313	4,476	329	0	513ms	88ms	140ms	176ms
	09	50,984	14,695	798	0	173ms	337ms	400ms	508ms
	10	54,376	16,668	640	0	456ms	305ms	382ms	50m21s
	11	72,365	21,056	723	0	0ms	413ms	496ms	557ms
	12	69,746	20,984	722	0	89ms	413ms	502ms	747ms
	13	57,631	19,817	564	3	338ms	350ms	498ms	39m21s
	14	57,037	20,377	778	0	554ms	336ms	461ms	1h11m32s
	15	55,416	19,215	733	0	244ms	337ms	407ms	573ms
	16	53,792	20,515	693	10	305ms	428ms	617ms	1h1m5s
	17	73,059	27,079	734	3	52ms	662ms	875ms	20m45s
	18	75,442	22,909	717	0	113ms	481ms	625ms	31m16s
	19	69,894	17,712	513	0	136ms	438ms	555ms	939ms
	20	55,220	12,802	478	0	152ms	342ms	419ms	558ms
	21	43,931	9,627	242	0	285ms	266ms	368ms	488ms
	22	19,800	4,515	224	0	524ms	169ms	214ms	1h

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

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

63,525 buffers Checkpoint Peak
2024-12-28 12:06:24 Date
270.051 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

27 files Wal files usage Peak
2024-12-28 13:36:24 Date

Checkpoints distance

Key values

860.89 Mo Distance Peak
2024-12-28 11:26:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 28	00	57,048	3,171.482s	0.038s	3,171.564s
	01	90,803	2,890.536s	0.027s	2,890.61s
	02	136,480	3,243.156s	0.03s	3,243.232s
	03	85,862	2,968.837s	0.025s	2,968.902s
	04	75,956	3,239.592s	0.026s	3,239.655s
	05	50,892	2,665.705s	0.023s	2,665.764s
	06	43,985	2,648.998s	0.025s	2,649.052s
	07	42,291	2,887.372s	0.024s	2,887.432s
	08	93,611	3,001.453s	0.029s	3,001.523s
	09	348,261	3,239.531s	0.044s	3,239.658s
	10	433,362	3,239.466s	0.037s	3,239.585s
	11	547,665	3,239.582s	0.056s	3,239.734s
	12	582,104	3,239.446s	0.056s	3,239.59s
	13	502,206	3,239.526s	0.064s	3,239.666s
	14	413,681	3,239.47s	0.048s	3,239.599s
	15	396,266	3,239.489s	0.044s	3,239.607s
	16	294,012	3,239.596s	0.051s	3,239.71s
	17	332,183	2,887.453s	0.074s	2,887.598s
	18	336,158	3,239.495s	0.05s	3,239.618s
	19	300,703	3,239.498s	0.066s	3,239.635s
	20	254,054	3,239.535s	0.053s	3,239.653s
	21	155,467	3,239.562s	0.063s	3,239.67s
	22	97,200	2,429.661s	0.025s	2,429.72s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 28	00	25	3,195	0.010s	0.012s
	01	41	3,116	0.002s	0.012s
	02	58	3,028	0.002s	0.013s
	03	39	2,215	0.002s	0.011s
	04	32	2,253	0.002s	0.012s
	05	21	1,910	0.002s	0.012s
	06	18	2,020	0.002s	0.011s
	07	17	2,247	0.002s	0.012s
	08	39	3,435	0.002s	0.012s
	09	148	4,649	0.003s	0.012s
	10	183	5,020	0.002s	0.012s
	11	236	5,167	0.002s	0.012s
	12	256	5,411	0.002s	0.012s
	13	216	5,203	0.005s	0.012s
	14	181	5,263	0.002s	0.012s
	15	171	5,270	0.002s	0.012s
	16	124	5,721	0.004s	0.012s
	17	143	5,426	0.007s	0.012s
	18	151	5,381	0.002s	0.012s
	19	140	5,142	0.003s	0.012s
	20	112	5,039	0.002s	0.012s
	21	69	4,404	0.011s	0.012s
	22	42	3,347	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 28	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 28	00	34,197.00 kB	60,546.25 kB
	01	55,015.83 kB	78,496.67 kB
	02	74,022.62 kB	144,360.15 kB
	03	56,873.45 kB	121,068.36 kB
	04	43,501.42 kB	72,378.83 kB
	05	28,973.83 kB	49,800.00 kB
	06	27,000.55 kB	43,832.45 kB
	07	23,378.25 kB	37,429.75 kB
	08	52,576.33 kB	68,081.25 kB
	09	202,449.67 kB	230,102.17 kB
	10	249,974.75 kB	315,832.00 kB
	11	322,265.42 kB	380,529.58 kB
	12	349,604.08 kB	403,685.58 kB
	13	295,457.25 kB	382,007.25 kB
	14	247,428.27 kB	325,014.18 kB
	15	231,560.00 kB	296,139.55 kB
	16	168,215.00 kB	224,818.25 kB
	17	195,693.58 kB	244,324.33 kB
	18	206,404.92 kB	269,361.17 kB
	19	191,056.67 kB	241,637.75 kB
	20	153,337.00 kB	215,450.50 kB
	21	93,012.42 kB	145,833.42 kB
	22	77,406.67 kB	111,775.22 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (271) Main checkpoint cause
272 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	271
shutdown immediate	1
Total	272

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 28	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 28	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

10,360,232 Total read queries
4,874,667 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,360,232	58.95%
INSERT	916,456	5.21%
UPDATE	277,340	1.58%
DELETE	9,958	0.06%
COPY FROM	16	0.00%
COPY TO	0	0.00%
CTE	26,980	0.15%
DDL	2,344	0.01%
TCL	3,641,573	20.72%
CURSOR	0	0.00%
OTHERS	2,340,801	13.32%

Queries by database

Key values

unknown Main database
17,575,700 Requests
5d15h2m18s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	17,575,700	5d15h2m18s
	copy from	16	24ms
	cte	26,980	5s731ms
	ddl	2,344	325ms
	delete	9,958	1s326ms
	insert	916,456	4m44s
	others	2,340,801	1m50s
	select	10,360,232	2d7h30m37s
	tcl	3,641,573	2m31s
	update	277,340	3d7h22m26s

Queries by user

Key values

unknown Main user
17,575,700 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	17,575,700	5d15h2m18s
	copy from	16	24ms
	cte	26,980	5s731ms
	ddl	2,344	325ms
	delete	9,958	1s326ms
	insert	916,456	4m44s
	others	2,340,801	1m50s
	select	10,360,232	2d7h30m37s
	tcl	3,641,573	2m31s
	update	277,340	3d7h22m26s

Duration by user

Key values

5d15h2m18s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	17,575,700	5d15h2m18s
	copy from	16	24ms
	cte	26,980	5s731ms
	ddl	2,344	325ms
	delete	9,958	1s326ms
	insert	916,456	4m44s
	others	2,340,801	1m50s
	select	10,360,232	2d7h30m37s
	tcl	3,641,573	2m31s
	update	277,340	3d7h22m26s

Queries by host

Key values

unknown Main host
17,575,700 Requests
5d15h2m18s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	17,575,700	5d15h2m18s
	copy from	16	24ms
	cte	26,980	5s731ms
	ddl	2,344	325ms
	delete	9,958	1s326ms
	insert	916,456	4m44s
	others	2,340,801	1m50s
	select	10,360,232	2d7h30m37s
	tcl	3,641,573	2m31s
	update	277,340	3d7h22m26s

Queries by application

Key values

unknown Main application
17,575,700 Requests
5d15h2m18s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	17,575,700	5d15h2m18s
	copy from	16	24ms
	cte	26,980	5s731ms
	ddl	2,344	325ms
	delete	9,958	1s326ms
	insert	916,456	4m44s
	others	2,340,801	1m50s
	select	10,360,232	2d7h30m37s
	tcl	3,641,573	2m31s
	update	277,340	3d7h22m26s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-28 19:17:23 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

16,492,725 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	16,492,725	93.84%
1-5ms	258,708	1.47%
5-10ms	11,481	0.07%
10-25ms	52,356	0.30%
25-50ms	201,634	1.15%
50-100ms	49,664	0.28%
100-500ms	436,309	2.48%
500-1000ms	68,304	0.39%
1000-10000ms	3,558	0.02%
> 10000ms	961	0.01%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.438724', exp_date = '2024-12-27 23:09:21.438729', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-28 00:24:21 ]
2	1h	update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.439054', exp_date = '2024-12-27 23:09:21.439059', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-28 00:24:21 ]
3	1h	update res_users set sid = 'f1508fffc6f62ff40db53629d9d10a2512cdbf3e', last_update = '2024-12-28 20:37:27.528101', exp_date = '2024-12-28 21:22:27.528103', logged_in = 'TRUE' where id = 1359; [ Date: 2024-12-28 22:37:27 ]
4	1h	update res_users set sid = 'f1508fffc6f62ff40db53629d9d10a2512cdbf3e', last_update = '2024-12-28 20:37:27.528048', exp_date = '2024-12-28 21:22:27.528051', logged_in = 'TRUE' where id = 1359; [ Date: 2024-12-28 22:37:27 ]
5	59m59s	update res_users set sid = 'e649cf963b1fda3abd746544eb67e68ac38bd0fd', last_update = '2024-12-28 20:33:05.153692', exp_date = '2024-12-28 21:18:05.153694', logged_in = 'TRUE' where id = 1026; [ Date: 2024-12-28 22:33:05 ]
6	59m52s	update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:29.339958', exp_date = '2024-12-27 23:09:29.339963', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-28 00:24:21 ]
7	34m20s	update res_users set sid = 'f1508fffc6f62ff40db53629d9d10a2512cdbf3e', last_update = '2024-12-28 21:03:06.684260', exp_date = '2024-12-28 21:48:06.684264', logged_in = 'TRUE' where id = 1359; [ Date: 2024-12-28 22:37:27 ]
8	27m49s	update res_users set sid = 'c161469560606e4b329d1f0a5efaaf60d90427f7', last_update = '2024-12-28 18:31:30.464525', exp_date = '2024-12-28 19:16:30.464529', logged_in = 'TRUE' where id = 956; [ Date: 2024-12-28 19:59:20 ]
9	27m49s	update res_users set sid = 'c161469560606e4b329d1f0a5efaaf60d90427f7', last_update = '2024-12-28 18:31:30.463993', exp_date = '2024-12-28 19:16:30.463997', logged_in = 'TRUE' where id = 956; [ Date: 2024-12-28 19:59:20 ]
10	27m43s	UPDATE "res_users" SET "exp_date" = '2024-12-28 02:18:36.314915', "last_update" = '2024-12-28 01:33:36.314938', "sid" = 'fc80c979b36d901420a614ce2450d600d35b894a', "write_date" = '2024-12-28 01:33:35.987792', "write_uid" = 1 WHERE id IN (901); [ Date: 2024-12-28 03:01:20 ]
11	26m20s	update res_users set sid = '852bf9e0704b55c94ecd980f3b3150fa36b74871', last_update = '2024-12-28 01:34:59.865359', exp_date = '2024-12-28 02:19:59.865361', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
12	26m18s	update res_users set sid = '852bf9e0704b55c94ecd980f3b3150fa36b74871', last_update = '2024-12-28 01:35:01.980978', exp_date = '2024-12-28 02:20:01.980980', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
13	25m42s	update res_users set sid = '193b3151d181e62d5cd1ca76339c2fbdf7c5040c', last_update = '2024-12-28 12:30:38.548499', exp_date = '2024-12-28 13:15:38.548503', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-28 13:56:20 ]
14	25m42s	update res_users set sid = '193b3151d181e62d5cd1ca76339c2fbdf7c5040c', last_update = '2024-12-28 12:30:38.548272', exp_date = '2024-12-28 13:15:38.548276', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-28 13:56:20 ]
15	25m20s	update res_users set sid = 'fc80c979b36d901420a614ce2450d600d35b894a', last_update = '2024-12-28 01:36:00.168163', exp_date = '2024-12-28 02:21:00.168165', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
16	25m20s	update res_users set sid = 'fc80c979b36d901420a614ce2450d600d35b894a', last_update = '2024-12-28 01:36:00.173176', exp_date = '2024-12-28 02:21:00.173179', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
17	25m20s	update res_users set sid = 'fc80c979b36d901420a614ce2450d600d35b894a', last_update = '2024-12-28 01:36:00.176641', exp_date = '2024-12-28 02:21:00.176644', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
18	25m20s	update res_users set sid = 'fc80c979b36d901420a614ce2450d600d35b894a', last_update = '2024-12-28 01:36:00.179050', exp_date = '2024-12-28 02:21:00.179054', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
19	25m20s	update res_users set sid = 'fc80c979b36d901420a614ce2450d600d35b894a', last_update = '2024-12-28 01:36:00.179993', exp_date = '2024-12-28 02:21:00.179996', logged_in = 'TRUE' where id = 901; [ Date: 2024-12-28 03:01:20 ]
20	24m35s	update res_users set sid = '193b3151d181e62d5cd1ca76339c2fbdf7c5040c', last_update = '2024-12-28 12:31:44.805570', exp_date = '2024-12-28 13:16:44.805572', logged_in = 'TRUE' where id = 847; [ Date: 2024-12-28 13:56:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d2h3m33s

70,805

Details

0ms

1h

3s765ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 28	00	448	2h59m52s	24s90ms
	01	623	136ms	0ms
	02	508	109ms	0ms
	03	526	7h2m32s	48s199ms
	04	402	86ms	0ms
	05	284	61ms	0ms
	06	283	61ms	0ms
	07	383	87ms	0ms
	08	1,168	2h5m14s	6s433ms
	09	3,574	3h2m15s	3s59ms
	10	5,526	8h25m33s	5s489ms
	11	6,999	1s710ms	0ms
	12	7,562	2h15m38s	1s76ms
	13	7,831	7h9m24s	3s290ms
	14	6,615	11h19m45s	6s165ms
	15	5,903	5h6m56s	3s119ms
	16	5,761	6h12m18s	3s877ms
	17	5,239	1h24m24s	966ms
	18	3,873	2h55m13s	2s714ms
	19	3,352	3h19m45s	3s575ms
	20	1,832	2h54m9s	5s703ms
	21	1,335	4h16m4s	11s509ms
	22	778	3h34m21s	16s531ms

update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.438724', exp_date = '2024-12-27 23:09:21.438729', logged_in = 'TRUE' where id = 932;

Date: 2024-12-28 00:24:21 Duration: 1h
update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.439054', exp_date = '2024-12-27 23:09:21.439059', logged_in = 'TRUE' where id = 932;

Date: 2024-12-28 00:24:21 Duration: 1h
update res_users set sid = 'f1508fffc6f62ff40db53629d9d10a2512cdbf3e', last_update = '2024-12-28 20:37:27.528101', exp_date = '2024-12-28 21:22:27.528103', logged_in = 'TRUE' where id = 1359;

Date: 2024-12-28 22:37:27 Duration: 1h

2

1d3h59m9s

215,202

Details

391ms

2s802ms

468ms

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 28	00	2,642	19m53s	451ms
	01	5,962	44m32s	448ms
	02	4,499	33m15s	443ms
	03	5,782	42m23s	439ms
	04	3,647	26m43s	439ms
	05	2,205	15m44s	428ms
	06	1,743	13m12s	454ms
	07	1,608	11m52s	442ms
	08	3,722	26m51s	433ms
	09	13,604	1h44m35s	461ms
	10	12,475	1h34m58s	456ms
	11	16,855	2h12m42s	472ms
	12	17,131	2h16m14s	477ms
	13	12,718	1h38m56s	466ms
	14	9,793	1h15m32s	462ms
	15	11,119	1h25m24s	460ms
	16	11,463	1h32m11s	482ms
	17	16,268	2h15m34s	500ms
	18	15,751	2h6m27s	481ms
	19	18,537	2h28m58s	482ms
	20	13,351	1h42m51s	462ms
	21	9,545	1h14m8s	466ms
	22	4,782	36m3s	452ms

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

Date: 2024-12-28 17:24:20 Duration: 2s802ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3840418)) AND (("shipping_track"."id" not in (31302127, 31309642, 31310256, 31394918, 31394955, 31394991, 31475908, 31507111, 31779159, 31779236, 31779289, 31919501, 31919541, 32017946, 32563008, 32563009, 32563015, 32563018, 32781046, 32792725, 32793184, 32793184)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:55 Duration: 2s355ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4008877)) AND (("shipping_track"."id" not in (32793151, 32793151)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:45 Duration: 998ms

3

5h47m1s

43,768

Details

404ms

3s182ms

475ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 28	00	160	1m13s	456ms
	01	163	1m19s	486ms
	02	110	55s332ms	503ms
	03	119	1m1s	515ms
	04	83	41s966ms	505ms
	05	59	29s782ms	504ms
	06	170	1m15s	444ms
	07	414	3m2s	441ms
	08	862	6m23s	444ms
	09	3,173	24m53s	470ms
	10	2,940	23m13s	474ms
	11	3,573	29m19s	492ms
	12	4,393	35m59s	491ms
	13	3,506	27m53s	477ms
	14	3,415	26m37s	467ms
	15	4,179	32m24s	465ms
	16	3,383	27m7s	481ms
	17	3,656	30m31s	500ms
	18	2,677	20m58s	470ms
	19	3,156	24m46s	470ms
	20	1,971	14m53s	453ms
	21	926	6m57s	450ms
	22	680	5m2s	444ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3840418, 3539189, 3464959, 3464956, 3054919, 2315038)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:53 Duration: 3s182ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3890802)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:58 Duration: 2s756ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3890802)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:58 Duration: 2s482ms

4

5h4m24s

339

Details

0ms

27m43s

53s877ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 28	00	2	6m31s	3m15s
	01	1	1ms	1ms
	02	1	1ms	1ms
	03	13	2h53m16s	13m19s
	04	1	1ms	1ms
	05	1	1ms	1ms
	06	2	1ms	0ms
	07	3	1ms	0ms
	08	14	1m23s	5s994ms
	09	39	9m8s	14s72ms
	10	38	39m13s	1m1s
	11	23	24ms	1ms
	12	25	22ms	0ms
	13	17	9m40s	34s127ms
	14	26	42m4s	1m37s
	15	26	34ms	1ms
	16	25	8m47s	21s113ms
	17	19	2m35s	8s204ms
	18	23	11m41s	30s489ms
	19	16	20ms	1ms
	20	4	6ms	1ms
	21	8	9ms	1ms
	22	12	12ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-28 02:18:36.314915', "last_update" = '2024-12-28 01:33:36.314938', "sid" = 'fc80c979b36d901420a614ce2450d600d35b894a', "write_date" = '2024-12-28 01:33:35.987792', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 27m43s
UPDATE "res_users" SET "exp_date" = '2024-12-28 02:23:52.473164', "last_update" = '2024-12-28 01:38:52.473181', "sid" = '163b4dbdfc6572f9cd3b3fe612b8b6b337406db6', "write_date" = '2024-12-28 01:38:52.151069', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 22m27s
UPDATE "res_users" SET "exp_date" = '2024-12-28 02:25:13.592365', "last_update" = '2024-12-28 01:40:13.592386', "sid" = '163b4dbdfc6572f9cd3b3fe612b8b6b337406db6', "write_date" = '2024-12-28 01:40:13.269493', "write_uid" = 901 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 21m6s

5

4h55m23s

85,248

Details

152ms

1s151ms

207ms

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

Day	Hour	Count	Duration	Avg duration
Dec 28	00	482	1m38s	203ms
	01	1,278	4m19s	203ms
	02	959	3m14s	202ms
	03	1,101	3m45s	204ms
	04	1,161	3m55s	202ms
	05	512	1m44s	204ms
	06	346	1m10s	203ms
	07	705	2m23s	203ms
	08	1,376	4m40s	204ms
	09	5,948	21m16s	214ms
	10	6,559	23m38s	216ms
	11	6,898	25m24s	221ms
	12	5,012	18m36s	222ms
	13	6,106	22m2s	216ms
	14	4,764	17m17s	217ms
	15	4,573	16m28s	216ms
	16	6,420	23m2s	215ms
	17	20,668	1h9m40s	202ms
	18	8,713	26m12s	180ms
	19	1,415	4m7s	174ms
	20	108	19s535ms	180ms
	21	144	23s593ms	163ms

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

Date: 2024-12-28 12:00:09 Duration: 1s151ms
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" = '9361572')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-28 12:00:10 Duration: 1s116ms
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" = '9579759')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-28 17:50:57 Duration: 607ms

6

3h29m11s

53,189

Details

90ms

865ms

235ms

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 28	00	1,538	4m58s	193ms
	01	2,567	8m24s	196ms
	02	1,566	5m57s	228ms
	03	1,198	4m48s	240ms
	04	998	3m26s	206ms
	06	1,072	3m39s	204ms
	07	572	2m11s	229ms
	08	68	14s771ms	217ms
	09	42	9s869ms	234ms
	10	222	1m	271ms
	11	72	15s595ms	216ms
	12	224	51s582ms	230ms
	13	664	2m24s	217ms
	14	912	3m40s	241ms
	15	1,510	6m11s	245ms
	16	4,187	17m36s	252ms
	17	3,973	17m40s	266ms
	18	8,002	32m24s	243ms
	19	7,880	31m41s	241ms
	20	6,387	25m58s	243ms
	21	7,106	26m50s	226ms
	22	2,429	8m46s	216ms

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-28 18:02:34 Duration: 865ms
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-28 18:02:34 Duration: 864ms
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-28 19:18:23 Duration: 861ms

7

2h31m48s

10,126

Details

28ms

1s692ms

899ms

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 28	00	375	5m59s	958ms
	01	357	3m2s	509ms
	08	3	2s897ms	965ms
	10	5	155ms	31ms
	11	9	10s229ms	1s136ms
	12	5	5s732ms	1s146ms
	13	18	15s96ms	838ms
	14	90	1m32s	1s22ms
	15	314	5m14s	1s2ms
	16	1,100	19m6s	1s41ms
	17	787	14m10s	1s80ms
	18	1,908	28m31s	896ms
	19	1,851	23m58s	777ms
	20	918	12m14s	800ms
	21	1,648	25m36s	932ms
	22	738	11m48s	960ms

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

Date: 2024-12-28 17:22:06 Duration: 1s692ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9560896')) 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 (85))))))) 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 (85)))))) 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 (85)))))) 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 (85))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-28 17:47:27 Duration: 1s588ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9568485')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-28 17:47:29 Duration: 1s518ms

8

1h38m4s

21,874

Details

158ms

624ms

269ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 28	07	169	43s876ms	259ms
	08	422	1m44s	248ms
	09	2,145	9m33s	267ms
	10	3,035	13m42s	270ms
	11	1,849	8m40s	281ms
	12	1,783	8m27s	284ms
	13	2,255	10m12s	271ms
	14	2,673	11m52s	266ms
	15	1,841	8m22s	272ms
	16	2,338	10m40s	274ms
	17	2,283	9m47s	257ms
	18	759	3m1s	238ms
	19	322	1m15s	233ms

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

Date: 2024-12-28 12:00:06 Duration: 624ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '8909807')))) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:06 Duration: 600ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '8911942')))) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:07 Duration: 561ms

9

1h33m8s

140,137

Details

30ms

104ms

39ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 28	00	1,062	40s403ms	38ms
	01	2,646	1m40s	37ms
	02	1,496	57s116ms	38ms
	03	1,876	1m11s	38ms
	04	1,043	39s519ms	37ms
	05	598	23s207ms	38ms
	06	1,037	39s535ms	38ms
	07	1,266	48s603ms	38ms
	08	1,686	1m4s	38ms
	09	8,825	5m53s	40ms
	10	10,085	6m42s	39ms
	11	14,208	9m43s	41ms
	12	14,495	9m59s	41ms
	13	10,803	7m17s	40ms
	14	7,806	5m11s	39ms
	15	8,889	5m54s	39ms
	16	8,850	5m59s	40ms
	17	8,730	6m2s	41ms
	18	8,001	5m13s	39ms
	19	10,706	7m4s	39ms
	20	7,209	4m33s	37ms
	21	5,882	3m39s	37ms
	22	2,938	1m48s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3972519, 3964105, 3959836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:50:44 Duration: 104ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3993897, 3989075, 3977024, 3973714, 3972065, 3963825, 3906901)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:45:54 Duration: 100ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3383277)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:21:57 Duration: 90ms

10

1h23m5s

16,793

Details

196ms

491ms

296ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 28	00	401	2m	300ms
	01	943	4m44s	301ms
	02	789	3m54s	297ms
	03	605	3m1s	300ms
	04	505	2m29s	295ms
	06	543	2m40s	295ms
	07	289	1m24s	293ms
	08	31	9s442ms	304ms
	09	21	6s858ms	326ms
	10	107	33s431ms	312ms
	11	27	9s904ms	366ms
	12	111	36s510ms	328ms
	13	318	1m46s	334ms
	14	377	2m3s	326ms
	15	448	2m22s	317ms
	16	1,017	5m33s	327ms
	17	1,221	6m28s	318ms
	18	2,151	10m33s	294ms
	19	2,124	10m32s	297ms
	20	2,331	10m54s	280ms
	21	1,939	8m48s	272ms
	22	495	2m12s	267ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9640008')) 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-28 17:47:24 Duration: 491ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9570019')) 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-28 17:50:46 Duration: 478ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9432825')) 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-28 11:32:42 Duration: 477ms

11

36m34s

46,376

Details

36ms

109ms

47ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 28	00	74	3s283ms	44ms
	01	4	197ms	49ms
	06	5	243ms	48ms
	07	306	13s607ms	44ms
	08	496	21s739ms	43ms
	09	3,755	2m52s	45ms
	10	4,055	3m7s	46ms
	11	5,276	4m13s	48ms
	12	4,343	3m31s	48ms
	13	4,211	3m19s	47ms
	14	3,990	3m7s	47ms
	15	4,123	3m14s	47ms
	16	5,622	4m26s	47ms
	17	5,470	4m21s	47ms
	18	2,258	1m46s	47ms
	19	1,895	1m29s	47ms
	20	217	10s491ms	48ms
	21	178	8s301ms	46ms
	22	98	4s444ms	45ms

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

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

Date: 2024-12-28 17:47:19 Duration: 94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3732631) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-28 15:02:58 Duration: 88ms

12

30m8s

18,598

Details

80ms

299ms

97ms

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

Day	Hour	Count	Duration	Avg duration
Dec 28	00	162	14s522ms	89ms
	01	721	1m4s	88ms
	02	719	1m5s	90ms
	06	6	541ms	90ms
	07	43	3s921ms	91ms
	08	206	19s569ms	94ms
	09	888	1m28s	100ms
	10	1,102	1m46s	96ms
	11	1,229	2m3s	100ms
	12	1,408	2m24s	102ms
	13	1,715	2m47s	97ms
	14	3,357	5m19s	95ms
	15	2,235	3m34s	96ms
	16	1,164	1m55s	99ms
	17	995	1m42s	102ms
	18	1,256	2m1s	96ms
	19	482	48s694ms	101ms
	20	672	1m4s	95ms
	21	132	12s419ms	94ms
	22	106	10s280ms	96ms

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

Date: 2024-12-28 12:00:06 Duration: 299ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7896945)) AND (("cash_track"."id" not in (6302975)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-28 17:22:29 Duration: 260ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7894894)) AND (("cash_track"."id" not in (6288296)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-28 12:00:10 Duration: 212ms

13

28m52s

8,228

Details

153ms

401ms

210ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 28	00	65	13s305ms	204ms
	01	167	34s38ms	203ms
	04	192	38s705ms	201ms
	05	110	22s292ms	202ms
	06	99	20s23ms	202ms
	07	276	56s96ms	203ms
	08	687	2m20s	204ms
	09	883	3m6s	211ms
	10	989	3m31s	214ms
	11	1,195	4m22s	219ms
	12	891	3m18s	222ms
	13	441	1m37s	220ms
	14	175	39s238ms	224ms
	15	369	1m20s	217ms
	16	872	3m5s	212ms
	17	303	56s788ms	187ms
	18	28	5s700ms	203ms
	19	342	59s302ms	173ms
	21	144	23s666ms	164ms

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" = '9614325')) 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-28 12:00:10 Duration: 401ms
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" = '9687180')) 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-28 12:00:10 Duration: 361ms
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" = '9530274')) 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-28 12:00:12 Duration: 340ms

14

19m11s

5,431

Details

155ms

313ms

212ms

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

Day	Hour	Count	Duration	Avg duration
Dec 28	06	192	39s375ms	205ms
	07	87	17s618ms	202ms
	08	129	26s281ms	203ms
	09	1,543	5m35s	217ms
	10	238	53s299ms	223ms
	11	962	3m32s	220ms
	12	136	30s478ms	224ms
	13	256	57s150ms	223ms
	14	369	1m18s	213ms
	16	378	1m22s	217ms
	17	545	1m51s	204ms
	18	331	1m	182ms
	19	265	46s883ms	176ms

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" = '461696')) 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-28 17:50:39 Duration: 313ms
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" = '9026739')) 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-28 11:56:22 Duration: 298ms
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" = '9461344')) 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-28 17:50:21 Duration: 291ms

15

16m

4,718

Details

183ms

234ms

203ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 28	00	417	1m24s	203ms
	01	911	3m5s	203ms
	02	949	3m12s	202ms
	03	1,101	3m45s	204ms
	04	969	3m16s	203ms
	05	316	1m4s	205ms
	06	55	11s63ms	201ms

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" = '9640315')) 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-28 03:49:01 Duration: 234ms
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" = '9603626')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 43, 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-28 05:21:04 Duration: 234ms
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" = '9581596')) 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-28 03:15:01 Duration: 232ms

16

13m59s

19,760

Details

32ms

74ms

42ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 28	07	159	6s291ms	39ms
	08	225	9s155ms	40ms
	09	1,385	57s869ms	41ms
	10	1,867	1m17s	41ms
	11	2,461	1m45s	42ms
	12	1,673	1m11s	42ms
	13	1,882	1m20s	42ms
	14	1,786	1m16s	42ms
	15	2,586	1m49s	42ms
	16	2,339	1m39s	42ms
	17	2,232	1m37s	43ms
	18	639	25s615ms	40ms
	19	515	22s278ms	43ms
	20	11	495ms	45ms

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

Date: 2024-12-28 12:00:01 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3905316) ORDER BY "collection_policy"."id";

Date: 2024-12-28 17:24:17 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3950298) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:02 Duration: 69ms

17

13m11s

5,575

Details

119ms

248ms

141ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 28	00	26	3s389ms	130ms
	01	30	3s888ms	129ms
	07	10	1s313ms	131ms
	08	77	10s155ms	131ms
	09	456	1m4s	141ms
	10	671	1m33s	138ms
	11	1,057	2m33s	144ms
	12	982	2m21s	144ms
	13	792	1m53s	143ms
	14	476	1m6s	139ms
	15	252	34s737ms	137ms
	16	224	32s342ms	144ms
	17	108	16s627ms	153ms
	18	90	12s995ms	144ms
	19	89	12s603ms	141ms
	20	80	10s860ms	135ms
	21	80	10s555ms	131ms
	22	75	9s733ms	129ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 36)) 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-28 17:50:33 Duration: 248ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 38)) 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-28 11:32:41 Duration: 206ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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-28 12:01:03 Duration: 201ms

18

11m42s

282

Details

27ms

4s514ms

2s490ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 28	01	3	9s335ms	3s111ms
	09	17	1m	3s534ms
	11	13	30s43ms	2s311ms
	12	8	29s939ms	3s742ms
	13	2	6s544ms	3s272ms
	14	10	22s759ms	2s275ms
	15	34	1m28s	2s592ms
	16	56	1m23s	1s496ms
	17	52	2m45s	3s185ms
	18	35	59s161ms	1s690ms
	19	21	1m10s	3s339ms
	20	14	45s106ms	3s221ms
	21	14	22s114ms	1s579ms
	22	3	9s453ms	3s151ms

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

Date: 2024-12-28 17:26:39 Duration: 4s514ms
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 (80))))))) 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 (80)))))) 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 (80)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (80)))))) 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 (80))))))))) 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 (80)))))))) AND ("policy_number"."name"::text ilike '%9294040%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-28 17:24:09 Duration: 4s355ms
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 (115))))))) 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 (115)))))) 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 (115)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (115)))))) 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 (115))))))))) 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 (115)))))))) AND ("policy_number"."name"::text ilike '%8338599%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-28 17:26:42 Duration: 4s350ms

19

11m22s

32

Details

0ms

11m6s

21s326ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 28	03	1	1ms	1ms
	08	3	11m6s	3m42s
	09	1	2ms	2ms
	10	3	1ms	0ms
	12	4	2ms	0ms
	13	2	0ms	0ms
	14	8	9ms	1ms
	16	1	1ms	1ms
	17	3	16s21ms	5s340ms
	18	4	3ms	0ms
	19	2	2ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-28 08:29:14.590872', "last_update" = '2024-12-28 07:44:14.590890', "write_date" = '2024-12-28 07:44:14.250022', "write_uid" = 1 WHERE id IN (838);

Date: 2024-12-28 08:55:20 Duration: 11m6s
UPDATE "res_users" SET "exp_date" = '2024-12-28 16:50:05.008322', "last_update" = '2024-12-28 16:05:05.008354', "write_date" = '2024-12-28 16:05:04.681571', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-28 17:05:21 Duration: 16s17ms
UPDATE "res_users" SET "exp_date" = '2024-12-28 16:52:00.252705', "last_update" = '2024-12-28 16:07:00.252745', "write_date" = '2024-12-28 16:06:59.842437', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-28 17:07:00 Duration: 2ms

20

10m52s

2,517

Details

197ms

402ms

259ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 28	10	181	50s346ms	278ms
	11	119	33s706ms	283ms
	12	114	30s677ms	269ms
	13	294	1m20s	275ms
	14	276	1m15s	274ms
	16	403	1m47s	267ms
	17	488	2m6s	260ms
	18	319	1m15s	235ms
	19	323	1m11s	221ms

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

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

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

Date: 2024-12-28 17:50:34 Duration: 373ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,339,340

Details

1m50s

0ms

2ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 28	00	34,301	1s217ms	0ms
	01	36,583	1s523ms	0ms
	02	31,824	1s281ms	0ms
	03	27,801	1s16ms	0ms
	04	22,398	813ms	0ms
	05	18,921	643ms	0ms
	06	21,280	772ms	0ms
	07	25,223	985ms	0ms
	08	47,602	1s959ms	0ms
	09	126,740	6s379ms	0ms
	10	165,030	7s447ms	0ms
	11	203,502	10s949ms	0ms
	12	211,227	10s910ms	0ms
	13	204,991	9s490ms	0ms
	14	193,004	8s285ms	0ms
	15	185,224	7s821ms	0ms
	16	186,951	8s482ms	0ms
	17	163,174	8s676ms	0ms
	18	134,295	7s392ms	0ms
	19	123,233	6s603ms	0ms
	20	77,125	3s170ms	0ms
	21	60,642	2s568ms	0ms
	22	38,269	1s659ms	0ms

DISCARD ALL;

Date: 2024-12-28 18:20:42 Duration: 2ms
DISCARD ALL;

Date: 2024-12-28 12:00:14 Duration: 1ms
DISCARD ALL;

Date: 2024-12-28 09:59:45 Duration: 1ms

2

1,821,328

Details

26s746ms

0ms

15ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 28	00	22,833	318ms	0ms
	01	25,959	400ms	0ms
	02	22,497	344ms	0ms
	03	20,269	292ms	0ms
	04	16,004	234ms	0ms
	05	13,313	195ms	0ms
	06	16,329	237ms	0ms
	07	20,137	285ms	0ms
	08	38,153	545ms	0ms
	09	105,296	1s603ms	0ms
	10	132,890	1s844ms	0ms
	11	164,474	2s564ms	0ms
	12	169,213	2s581ms	0ms
	13	160,957	2s276ms	0ms
	14	148,118	1s971ms	0ms
	15	141,221	1s914ms	0ms
	16	141,728	2s73ms	0ms
	17	128,215	2s35ms	0ms
	18	104,667	1s642ms	0ms
	19	96,005	1s502ms	0ms
	20	58,829	802ms	0ms
	21	45,315	660ms	0ms
	22	28,906	420ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

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

Date: 2024-12-28 11:54:51 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-28 12:03:45 Duration: 1ms

3

1,192,362

Details

11s987ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 28	00	17,887	146ms	0ms
	01	18,862	174ms	0ms
	02	16,571	147ms	0ms
	03	14,462	131ms	0ms
	04	11,773	104ms	0ms
	05	10,039	85ms	0ms
	06	11,271	102ms	0ms
	07	13,233	120ms	0ms
	08	24,703	223ms	0ms
	09	64,640	658ms	0ms
	10	83,739	830ms	0ms
	11	103,109	1s90ms	0ms
	12	107,034	1s124ms	0ms
	13	104,035	1s36ms	0ms
	14	97,933	944ms	0ms
	15	94,350	909ms	0ms
	16	94,931	953ms	0ms
	17	82,966	911ms	0ms
	18	68,293	731ms	0ms
	19	62,406	666ms	0ms
	20	39,327	403ms	0ms
	21	31,086	308ms	0ms
	22	19,712	181ms	0ms

ROLLBACK;

Date: 2024-12-28 11:10:16 Duration: 1ms
ROLLBACK;

Date: 2024-12-28 13:26:43 Duration: 1ms
ROLLBACK;

Date: 2024-12-28 14:52:34 Duration: 0ms

4

1,177,524

Details

3m39s

0ms

18ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 28	00	17,228	2s494ms	0ms
	01	18,277	3s255ms	0ms
	02	15,922	2s612ms	0ms
	03	13,805	2s421ms	0ms
	04	11,177	1s879ms	0ms
	05	9,429	1s336ms	0ms
	06	10,621	1s581ms	0ms
	07	12,613	1s910ms	0ms
	08	24,044	4s33ms	0ms
	09	64,047	12s706ms	0ms
	10	82,945	15s432ms	0ms
	11	102,767	19s951ms	0ms
	12	106,524	20s424ms	0ms
	13	103,326	18s662ms	0ms
	14	97,246	16s797ms	0ms
	15	93,457	16s347ms	0ms
	16	93,740	17s254ms	0ms
	17	81,883	16s742ms	0ms
	18	67,674	13s548ms	0ms
	19	62,118	12s953ms	0ms
	20	38,817	7s830ms	0ms
	21	30,578	5s913ms	0ms
	22	19,286	3s291ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'effd2d2088a7eba20a336d78276dd543ed5ad69c';

Date: 2024-12-28 20:39:16 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = 'f85dee1e03b5a71851fb9a948ccc9cf9f24d0e05';

Date: 2024-12-28 15:30:34 Duration: 12ms
SELECT payload FROM http_sessions WHERE sid = 'e112822e9ecac569a0e10641290cf2b114c4ee94';

Date: 2024-12-28 12:01:51 Duration: 10ms

5

1,169,608

Details

1m46s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 28	00	17,213	1s236ms	0ms
	01	18,370	1s547ms	0ms
	02	15,970	1s300ms	0ms
	03	13,961	1s188ms	0ms
	04	11,280	889ms	0ms
	05	9,536	735ms	0ms
	06	10,714	859ms	0ms
	07	12,686	1s38ms	0ms
	08	23,807	1s936ms	0ms
	09	63,280	5s830ms	0ms
	10	82,406	7s280ms	0ms
	11	101,739	9s592ms	0ms
	12	105,566	9s889ms	0ms
	13	102,445	9s137ms	0ms
	14	96,434	8s487ms	0ms
	15	92,567	8s64ms	0ms
	16	93,337	8s518ms	0ms
	17	81,496	8s246ms	0ms
	18	67,100	6s602ms	0ms
	19	61,597	5s907ms	0ms
	20	38,595	3s504ms	0ms
	21	30,368	2s720ms	0ms
	22	19,141	1s584ms	0ms

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

Date: 2024-12-28 16:15:50 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-28 11:50:24 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-28 12:01:35 Duration: 1ms

6

814,084

Details

1m55s

0ms

21ms

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 28	00	6,204	971ms	0ms
	01	8,584	1s325ms	0ms
	02	7,118	1s67ms	0ms
	03	6,801	992ms	0ms
	04	4,923	784ms	0ms
	05	3,604	606ms	0ms
	06	6,437	912ms	0ms
	07	8,033	1s139ms	0ms
	08	17,075	2s306ms	0ms
	09	52,970	7s341ms	0ms
	10	64,511	8s237ms	0ms
	11	80,857	11s601ms	0ms
	12	82,137	11s731ms	0ms
	13	75,690	10s746ms	0ms
	14	67,328	8s757ms	0ms
	15	61,178	8s207ms	0ms
	16	59,223	8s591ms	0ms
	17	57,841	8s855ms	0ms
	18	46,554	6s806ms	0ms
	19	43,449	7s287ms	0ms
	20	24,385	3s91ms	0ms
	21	17,924	2s478ms	0ms
	22	11,258	1s841ms	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 (900);

Date: 2024-12-28 15:10:52 Duration: 21ms
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 (1078);

Date: 2024-12-28 15:10:52 Duration: 21ms
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 (904);

Date: 2024-12-28 17:02:22 Duration: 12ms

7

627,829

Details

1m52s

0ms

33ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 28	00	4,950	863ms	0ms
	01	7,096	1s370ms	0ms
	02	5,887	1s83ms	0ms
	03	5,804	1s227ms	0ms
	04	4,231	889ms	0ms
	05	3,275	623ms	0ms
	06	5,058	826ms	0ms
	07	6,904	1s36ms	0ms
	08	13,416	2s190ms	0ms
	09	40,620	6s787ms	0ms
	10	49,019	8s97ms	0ms
	11	61,353	10s903ms	0ms
	12	62,151	11s750ms	0ms
	13	56,804	10s251ms	0ms
	14	50,108	9s21ms	0ms
	15	46,779	8s422ms	0ms
	16	46,563	7s880ms	0ms
	17	45,122	8s553ms	0ms
	18	36,269	6s595ms	0ms
	19	33,565	6s246ms	0ms
	20	19,440	4s16ms	0ms
	21	14,222	2s679ms	0ms
	22	9,193	1s653ms	0ms

COMMIT;

Date: 2024-12-28 17:28:57 Duration: 33ms
COMMIT;

Date: 2024-12-28 15:18:43 Duration: 30ms
COMMIT;

Date: 2024-12-28 14:25:00 Duration: 30ms

8

503,139

Details

30s859ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 28	00	3,286	171ms	0ms
	01	4,159	228ms	0ms
	02	3,211	155ms	0ms
	03	2,958	153ms	0ms
	04	2,106	108ms	0ms
	05	1,426	73ms	0ms
	06	4,823	224ms	0ms
	07	5,391	267ms	0ms
	08	9,660	503ms	0ms
	09	31,755	1s901ms	0ms
	10	37,696	2s254ms	0ms
	11	47,548	3s45ms	0ms
	12	50,926	3s295ms	0ms
	13	44,796	2s755ms	0ms
	14	42,781	2s388ms	0ms
	15	40,551	2s307ms	0ms
	16	36,915	2s430ms	0ms
	17	35,625	2s471ms	0ms
	18	29,694	1s987ms	0ms
	19	29,961	1s913ms	0ms
	20	17,736	1s82ms	0ms
	21	12,984	757ms	0ms
	22	7,151	380ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (27);

Date: 2024-12-28 17:21:54 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (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, 57, 59, 97, 101, 108, 118, 120, 129);

Date: 2024-12-28 17:48:04 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (55, 64, 17, 14, 39, 70, 16, 13, 26, 67, 22, 78, 79, 51);

Date: 2024-12-28 17:28:33 Duration: 0ms

9

500,267

Details

1m5s

0ms

8ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 28	00	4,303	427ms	0ms
	01	5,808	626ms	0ms
	02	4,849	512ms	0ms
	03	4,184	525ms	0ms
	04	3,060	348ms	0ms
	05	1,312	184ms	0ms
	06	5,031	565ms	0ms
	07	3,742	413ms	0ms
	08	8,933	1s102ms	0ms
	09	30,713	4s231ms	0ms
	10	37,421	5s397ms	0ms
	11	49,873	7s115ms	0ms
	12	50,615	7s276ms	0ms
	13	45,060	6s232ms	0ms
	14	41,575	4s803ms	0ms
	15	36,972	4s614ms	0ms
	16	33,480	4s362ms	0ms
	17	32,977	4s618ms	0ms
	18	30,903	3s914ms	0ms
	19	30,489	3s683ms	0ms
	20	17,700	2s99ms	0ms
	21	13,733	1s518ms	0ms
	22	7,534	835ms	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 (5099540, 5099035, 5101886, 5099930, 5099007, 5099013, 5099009, 5417409, 5101119, 5158979, 5099349, 5101315, 5106068, 5099014, 5103223, 5099690, 5099382, 5099687, 5099010, 5100477, 5414457, 5178974, 5100431, 5102630, 5100144, 5104173, 5100254, 5099356, 5114905, 5397436, 5102416, 5101468, 5100202, 5099873, 5100781, 5109813, 5099815, 5099046, 5099204, 5099144, 5099006, 5099765, 5099574, 5123891, 5099174, 5115681, 5099206, 5099507, 5099254, 5113818, 5350876, 5099162, 5404234, 5099521, 5100846, 5100362, 5104336, 5107065, 5106166, 5362738, 5114382, 5099111, 5099404, 5100204, 5099639, 5099169, 5403993, 5099194, 5099045, 5106083, 5099025, 5411855, 5099662, 5101846, 5099102, 5099037, 5099027, 5102094, 5099248, 5102119, 5101568, 5101207, 5414998, 5099190, 5101294, 5332717, 5099119, 5132233, 5276675, 5100181, 5099746, 5099130, 5099103, 5120122, 5101020, 5099092, 5100714, 5101850, 5100554, 5184887, 5099764, 5197968, 5099360, 5100810, 5099309, 5117367, 5099128, 5121988, 5099244, 5109522, 5099272, 5136188, 5099195);

Date: 2024-12-28 12:35:28 Duration: 8ms
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 (5098996, 5110603, 5357078, 5099403, 5119681, 5123579, 5100295, 5105921, 5417410, 5101438, 5158981, 5100747, 5099348, 5099731, 5127113, 5100396, 5099216, 5099677, 5118498, 5100700, 5100163, 5415180, 5100538, 5202873, 5125639, 5100476, 5099654, 5100023, 5102068, 5109010, 5099120, 5107075, 5099929, 5099122, 5100364, 5101219, 5104775, 5099857, 5100952, 5114378, 5102602, 5099082, 5099137, 5107138, 5409657, 5099386, 5099590, 5099141, 5100529, 5102856, 5102661, 5101775, 5208599, 5409988, 5099166, 5103258, 5257647, 5100506, 5413281, 5100067, 5107184, 5099513, 5108851, 5099431, 5105188, 5119758, 5099135, 5100339, 5399603, 5100929, 5099168, 5099502, 5099558, 5100201, 5114820, 5099299, 5099117, 5099243, 5114566, 5151845, 5411977, 5127194, 5099321, 5121179, 5132500, 5099446, 5102892, 5099263, 5099499, 5099231, 5414065, 5117452, 5107019, 5099768, 5100596, 5100919, 5108015, 5099585, 5105954, 5099442, 5106592, 5403434, 5122815, 5099387, 5107494, 5100302, 5100062, 5103853, 5099920, 5098989, 5099091, 5099693, 5101356, 5100258, 5099277, 5101013, 5100401, 5099333, 5179973, 5410108, 5265780, 5265190, 5099429, 5099668, 5107216, 5151966, 5099266, 5099995, 5102489, 5099464, 5099116, 5254762, 5198278);

Date: 2024-12-28 12:35:28 Duration: 4ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5136159, 5134271, 5137717, 5152979, 5136360, 5145645, 5153324, 5137711, 5153002, 5137722, 5167494, 5155690, 5145630, 5160215, 5160216, 5160208, 5152980, 5155692, 5154667, 5146324, 5153322, 5153323, 5146326, 5152981, 5160213, 5142684, 5142823, 5160209, 5136355, 5160212, 5146097, 5155691, 5175466, 5175465, 5173254, 5183496, 5153003, 5160214, 5148660, 5180370, 5174077, 5160211, 5167496, 5182937, 5182938, 5153001, 5175467, 5186822, 5160207, 5195964, 5161192, 5183498, 5186821, 5183497, 5187827, 5139053, 5187828, 5186823, 5195963, 5147484, 5160210, 5192542, 5167897, 5200291, 5137587, 5140611, 5202475, 5205567, 5179806, 5139165, 5180369, 5195966, 5156108, 5209381, 5193304, 5209383, 5205568, 5201979, 5196386, 5155456, 5175695, 5193732, 5158565, 5180368, 5192116, 5211782, 5209385, 5209386, 5182902, 5212768, 5212767, 5212766, 5215125, 5211783, 5208090, 5206657, 5209387, 5215775, 5195965, 5195967, 5215776, 5222914, 5180092, 5197552, 5222913, 5218769, 5218770, 5218882, 5171840, 5218771, 5208540, 5212765, 5183493, 5227182, 5211784, 5218883, 5152256, 5202016, 5194535, 5227183, 5149256, 5230519, 5162472, 5200768, 5219361, 5224100, 5165782, 5179910, 5152858, 5236578, 5192456, 5151885, 5236562, 5236567, 5239613, 5233069, 5139380, 5227381, 5134624, 5194737, 5239599, 5243055, 5160348, 5225036, 5215127, 5169190, 5225033, 5179789, 5239616, 5243054, 5239617, 5236517, 5225034, 5218772, 5144774, 5148386, 5235853, 5215126, 5195522, 5208539, 5246660, 5158081, 5225005, 5229368, 5202473, 5227184, 5163934, 5244341, 5246662, 5155960, 5230520, 5226167, 5212281, 5239618, 5246661, 5248730, 5247279, 5252403, 5249232, 5254698, 5203099, 5239619, 5149540, 5142139, 5149830, 5144073, 5254697, 5255124, 5224099, 5252401, 5251698, 5228396, 5209606, 5148798, 5261739, 5214827, 5260482, 5261736, 5261738, 5187588, 5257649, 5168676, 5261741, 5261740, 5235749, 5172765, 5254789, 5255126, 5252402, 5149081, 5251727, 5167875, 5273317, 5266977, 5269852, 5244272, 5261737, 5192546, 5266978, 5161887, 5270284, 5277825, 5200755, 5268309, 5257698, 5207095, 5276895, 5204456, 5150259, 5192552, 5277852, 5286077, 5170358, 5255732, 5241963, 5199068, 5266979, 5266551, 5232523, 5181151, 5255730, 5248754, 5269856, 5273316, 5283007, 5146908, 5281007, 5294253, 5216725, 5143008, 5266981, 5273490, 5297830, 5286075, 5294255, 5285924, 5269853, 5269854, 5298664, 5285922, 5294936, 5294937, 5286395, 5289741, 5285798, 5190823, 5285799, 5264141, 5294934, 5298311, 5181729, 5285797, 5282290, 5172175, 5277847, 5294935, 5285068, 5286078, 5286079, 5294933, 5294247, 5294248, 5305661, 5179938, 5285925, 5178445, 5159845, 5262705, 5307357, 5276897, 5139168, 5276894, 5257215, 5260481, 5149298, 5307155, 5294254, 5307220, 5285926, 5298662, 5303234, 5307156, 5219433, 5309836, 5307481, 5298312, 5294259, 5312728, 5249620, 5285927, 5318016, 5298015, 5309835, 5218881, 5161779, 5310223, 5298310, 5307358, 5213249, 5229834, 5317356, 5307480, 5315132, 5318018, 5268195, 5322657, 5171961, 5155913, 5320253, 5164596, 5255658, 5318019, 5315266, 5294258, 5175972, 5318001, 5225794, 5137263, 5323705, 5156283, 5274316, 5249810, 5319971, 5330767, 5330768, 5259355, 5200964, 5294257, 5318024, 5303251, 5324808, 5171651, 5323790, 5269855, 5315131, 5330978, 5318015, 5207390, 5251768, 5244784, 5309996, 5237549, 5315421, 5318017, 5192100, 5326268, 5330766, 5161736, 5183213, 5322763, 5135510, 5290256, 5229537, 5326029, 5333685, 5285923, 5236948, 5155987, 5226654, 5172383, 5330769, 5163337, 5189169, 5350338, 5333683, 5333168, 5330977, 5345018, 5277902, 5315267, 5313014, 5139920, 5335907, 5158024, 5170240, 5277841, 5333169, 5225079, 5196342, 5340202, 5352597, 5330770, 5333682, 5207523, 5322764, 5249548, 5154724, 5156886, 5152494, 5328892, 5335908, 5194414, 5345368, 5315268, 5197399, 5198401, 5350671, 5142715, 5339132, 5252310, 5345366, 5196345, 5326028, 5323569, 5323570, 5174438, 5153148, 5247745, 5195352, 5350669, 5163474, 5347703, 5336760, 5301526, 5343024, 5152410, 5269622, 5173036, 5352596, 5161782, 5348178, 5348187, 5211781, 5355274, 5278680, 5174966, 5356977, 5188736, 5368462, 5352598, 5359335, 5304867, 5184405, 5347455, 5185008, 5144735, 5365349, 5228098, 5166861, 5353080, 5363188, 5170494, 5358265, 5167735, 5347704, 5154734, 5361082, 5363190, 5361289, 5356979, 5381230, 5359065, 5363139, 5387912, 5381221, 5230836, 5193422, 5274620, 5313144, 5335107, 5363189, 5171987, 5338421, 5174533, 5365309, 5292797, 5314142, 5365680, 5139969, 5329845, 5160799, 5201165, 5363191, 5207057, 5173682, 5356980, 5180577, 5163356, 5208359, 5275798, 5290712, 5245054, 5218858, 5249768, 5396828, 5146305, 5203540, 5193702, 5383798, 5399019, 5171461, 5387906, 5193413, 5365668, 5401147, 5394877, 5185010, 5174078, 5368461, 5197669, 5154383, 5154960, 5401230, 5291137, 5390708, 5393141, 5195644, 5401483, 5203001, 5217037, 5404334, 5178522, 5161759, 5149403, 5381235, 5149748, 5399888, 5137372, 5401484, 5365350, 5180357, 5194400, 5381142, 5134623, 5233325, 5403673, 5137037, 5410005, 5174855, 5374018, 5163370, 5410006, 5154969, 5325465, 5411821, 5411820, 5362026, 5396987, 5176349, 5407742, 5250806, 5190845, 5407494, 5376052, 5210565, 5411822, 5403672, 5207123, 5414106, 5302865, 5387293, 5155667, 5383796, 5283765, 5144101, 5306933, 5374465, 5307352, 5148632, 5155796, 5425346, 5231233, 5229193, 5413774, 5149286, 5278678, 5416469, 5425348, 5263288, 5205014, 5214615, 5220962, 5426016, 5251748, 5209726, 5189314, 5254379, 5217941, 5172179, 5167858, 5161370, 5225722, 5238689, 5390042, 5426017, 5158808, 5173776, 5425347, 5413775, 5215957, 5251691, 5177516, 5415829, 5208893, 5303470, 5427296, 5431150, 5431151, 5432204, 5290948, 5308965, 5425477, 5439550, 5231188, 5215377, 5207020, 5310218, 5351473, 5309335, 5241154, 5434038, 5267242, 5177001, 5255888, 5435444, 5198305, 5307372, 5213911, 5437678, 5206238, 5154740, 5258048, 5439549, 5434037, 5414105, 5435445, 5435446, 5159760, 5434039, 5285395, 5145625, 5156238, 5255406, 5439545, 5442488, 5442487, 5202561, 5391423, 5142320, 5437442, 5295952, 5314220, 5139371, 5443345, 5439548, 5189876, 5162195, 5443344, 5178969, 5169036, 5158209, 5192520, 5445449, 5445447, 5233563, 5313972, 5170807, 5445875, 5447015, 5150805, 5445873, 5285343, 5239917, 5448793, 5172508, 5174080, 5159416, 5450588, 5227228, 5155515, 5200851, 5157111);

Date: 2024-12-28 13:10:47 Duration: 3ms

10

350,814

Details

1m54s

0ms

4ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 28	00	1,775	497ms	0ms
	01	2,207	664ms	0ms
	02	1,349	410ms	0ms
	03	1,833	559ms	0ms
	04	1,018	311ms	0ms
	05	580	186ms	0ms
	06	1,504	448ms	0ms
	07	1,471	443ms	0ms
	08	6,610	1s991ms	0ms
	09	25,417	8s138ms	0ms
	10	29,701	9s455ms	0ms
	11	23,562	8s122ms	0ms
	12	31,579	10s950ms	0ms
	13	33,271	10s857ms	0ms
	14	28,661	8s961ms	0ms
	15	28,735	9s93ms	0ms
	16	39,329	12s807ms	0ms
	17	29,554	10s301ms	0ms
	18	20,081	6s648ms	0ms
	19	15,924	5s302ms	0ms
	20	13,591	4s186ms	0ms
	21	8,495	2s567ms	0ms
	22	4,567	1s292ms	0ms

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

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

Date: 2024-12-28 12:35:54 Duration: 2ms
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 = 852) OR r.global) ORDER BY r.id;

Date: 2024-12-28 18:03:39 Duration: 2ms

11

345,339

Details

1m4s

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 28	00	2,259	377ms	0ms
	01	2,451	455ms	0ms
	02	2,069	373ms	0ms
	03	1,918	367ms	0ms
	04	1,274	232ms	0ms
	05	813	148ms	0ms
	06	2,653	440ms	0ms
	07	3,924	597ms	0ms
	08	7,638	1s213ms	0ms
	09	22,822	4s117ms	0ms
	10	28,366	5s32ms	0ms
	11	32,625	6s320ms	0ms
	12	34,120	6s631ms	0ms
	13	32,373	6s66ms	0ms
	14	30,519	5s375ms	0ms
	15	28,157	5s19ms	0ms
	16	26,326	5s90ms	0ms
	17	24,536	5s66ms	0ms
	18	19,760	3s777ms	0ms
	19	18,358	3s517ms	0ms
	20	10,156	1s863ms	0ms
	21	7,541	1s315ms	0ms
	22	4,681	776ms	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 (8007565, 8006454, 8007563, 8007364, 8007200, 8007305, 8006453, 8006408, 8006432, 8006459, 8006403, 8004698, 8006282, 8004682, 8006319, 8006410, 8006374, 8006864, 8006297, 8006461, 8006455, 8006288, 8006460, 8006380, 8004670, 8006534, 8006830);

Date: 2024-12-28 13:12:33 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 (1);

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

Date: 2024-12-28 17:21:54 Duration: 8ms

12

256,770

Details

44s712ms

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 28	00	1,617	210ms	0ms
	01	1,972	267ms	0ms
	02	1,278	161ms	0ms
	03	1,728	242ms	0ms
	04	1,311	162ms	0ms
	05	962	124ms	0ms
	06	716	107ms	0ms
	07	1,493	199ms	0ms
	08	6,476	943ms	0ms
	09	20,065	3s484ms	0ms
	10	22,274	3s860ms	0ms
	11	16,112	2s794ms	0ms
	12	21,067	3s997ms	0ms
	13	23,776	4s203ms	0ms
	14	20,893	3s511ms	0ms
	15	19,904	3s383ms	0ms
	16	27,882	5s158ms	0ms
	17	21,987	4s203ms	0ms
	18	15,181	2s641ms	0ms
	19	11,623	2s31ms	0ms
	20	8,697	1s523ms	0ms
	21	6,251	987ms	0ms
	22	3,505	510ms	0ms

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

Date: 2024-12-28 17:21:54 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1082 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_shipping_policy' AND name = 'edit_shipping_policy' AND model = 'res.groups');

Date: 2024-12-28 11:39:53 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1049 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-28 14:46:27 Duration: 2ms

13

231,672

Details

57s366ms

0ms

6ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 28	00	2,036	440ms	0ms
	01	2,874	657ms	0ms
	02	4,324	645ms	0ms
	03	1,865	551ms	0ms
	04	1,342	361ms	0ms
	05	467	143ms	0ms
	06	2,282	575ms	0ms
	07	1,891	461ms	0ms
	08	3,672	918ms	0ms
	09	12,513	3s453ms	0ms
	10	15,319	4s367ms	0ms
	11	20,255	5s522ms	0ms
	12	21,178	5s543ms	0ms
	13	19,517	4s808ms	0ms
	14	20,590	4s98ms	0ms
	15	18,070	3s933ms	0ms
	16	16,271	3s891ms	0ms
	17	15,654	4s286ms	0ms
	18	16,159	4s59ms	0ms
	19	14,562	3s656ms	0ms
	20	9,589	2s348ms	0ms
	21	7,612	1s799ms	0ms
	22	3,630	842ms	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 (41764066, 41688739, 41736744, 41799245, 41623233, 41461883, 41607606, 41412209, 41672148, 41760098, 41446604, 41769017, 41702722, 41463370, 41803949, 41089614, 41681688, 38477773, 41793464, 41749387, 41695901, 41754403, 41626618, 41415837, 41875956, 41737365, 41651736, 40768729, 41663639, 41805818, 41671428, 41494279, 41621390, 41547431, 41711468);

Date: 2024-12-28 17:21:58 Duration: 6ms
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 (41719848, 41613612, 41570035, 41746046, 41412574, 41686691, 41667980, 41749011, 41748867, 41793106, 41725112, 41733667, 41786839, 41671397, 41813110, 41796994, 41632257, 41658194, 41788790, 41781117, 41651076, 41688905, 41668662, 41714407, 41720975, 41796294, 41811253, 41787374, 41790963, 41811134, 41748003, 41844808, 41706960, 41759293, 41753250, 41716988, 41753386, 41647132, 41753385, 41737852, 41719239, 41615973, 41373958, 41773827, 41767751, 41352540, 41661807, 41278782, 41628020, 41816499, 41661791, 38767587, 40969580, 41799500, 41758860, 41700006, 41743038, 41720420, 41584252, 41759880, 41781511, 41781593, 41668637, 41617011, 41699103, 41688900, 41706939, 41625638, 41782400, 41751172, 41726408, 41733676, 41734594, 41494027, 41685972, 41746051, 32641214, 41415939, 41463433, 41754240, 41726377, 41774758, 41697177, 41728560, 41678877, 41670505, 41670494, 41455496, 41672291, 41721586, 41759903, 41799007, 41707407, 41620860, 41759930, 41759915, 41584213, 41606412, 41684453, 41707396, 32641205, 41764979, 41706679, 41781605, 41740449, 41796549, 41651052, 41616016, 41742931, 41745698, 41780674, 41740944, 32641216, 41748755, 41700705, 41780101, 41740997, 41793507, 41707245, 41786710, 41828151, 41705327, 41616499, 41759737, 41748770, 41263185, 41700836, 41745514, 41616789, 41720982, 41630259, 41110762, 41723473, 41692331, 41781037, 41558072, 41737624, 41808954, 41754213, 32648813, 41604136, 41769130, 41757310, 41719240, 41707253, 41845342, 41799202, 41845355, 41611415, 41583962, 41757192, 41229270, 41730113, 41463898, 41757161, 41632081, 41577031, 41626628, 41436584, 41778896, 41746741, 41508037, 41827896, 41754759, 41753895, 41754234, 41695587, 41828849, 41461930, 41684521, 41652329, 41584228, 41655517, 41599803, 41794478, 41781372, 41746109, 41719310, 41806919, 41500876, 41781612, 41375830, 41664439, 41728562, 41570040, 41570217, 41733838, 32641359, 41651720, 41764304, 41743044, 41755203, 41669581, 41802222, 41787699, 41742439, 41746687, 32641206, 41529537, 41734516, 41690311, 41844820, 41742163, 41768830, 41632256, 41778731, 41702830, 41286336, 41759872, 41690300, 41528479, 41741048, 41692368, 41604038, 41597064, 41789113, 41733819, 41436591, 41119189, 41680419, 41666281, 41769405, 41692190, 41570232, 41769466, 41707250, 41665197, 41827861, 41781640, 41668705, 41789828, 41789784, 32644250, 41732706, 41436298, 41802277, 41730706, 41731815, 41740655, 41714422, 41737856, 41050423, 41700758, 41633319, 41733821, 41664532, 41201937, 41229418, 32641416, 41662456, 41449064, 41679468, 41804349, 41711555, 41600365, 41843516, 41614360, 41759828, 41757172, 41730108, 40872217, 41263182, 41613844, 41682647, 41742441, 41742846, 32648676, 32648831, 41689117, 41668413, 41132980, 41725697, 41758446, 41261811, 41791438, 41719559, 41818834, 41782107, 41692187, 41667817, 41623345, 41600456, 41600427, 41692417, 41229451, 41499974, 41668552, 41667772, 41719185, 41774693, 41684246, 41754701, 41714079, 41632521, 41770387, 41824863, 41709247, 41805335, 41732087, 41506478, 41711778, 41751201, 41796306, 41668415, 41225538, 32641607, 41728510, 41668117, 41687172, 41844729, 41694876, 41807947, 41540096, 41795114, 41692234, 41600470, 41600492, 41553461, 41600540, 41600546, 41796004, 41653221, 41628351, 41759907, 41754780, 41661909, 41753273, 41765665, 41470291, 41757328, 41689537, 41574187, 41691623, 41719164, 41719215, 41741314, 41529002, 41531452, 41726138, 41692359, 41808953, 41606415, 41802305, 41468993, 41557310, 41350728, 41692242, 40967468, 41171330, 41799484, 41794878, 41692108, 41252047, 41658835, 41652227, 41802359, 41693733, 41706964, 41764320, 41657145, 41747975, 41769443, 41787575, 41754210, 41754205, 41410635, 41801694, 41714082, 41799284, 41689124, 41680415, 41753534, 41842683, 32641559, 41725397, 41745977, 41745651, 41416476, 32641440, 41670187, 41751956, 41774596, 41804698, 41792427, 41632267, 41791648, 41811255, 41733671, 41669011, 41782381, 41577552, 32641226, 41709117, 41782393, 41632633, 41569304, 32641046, 41489374, 41749209, 41707418, 41799265, 41754750, 41788059, 41774667, 41796305, 41764060, 41618592, 41764318, 41799300, 41657079, 41544632, 41589721, 41689206, 41633519, 41669580, 41442422, 41665866, 41780963, 41788053, 41739468, 41748762, 41489220, 41798854, 41711845, 41824656, 32641546, 41759719, 41669582, 41628622, 41565784, 41601219, 41707397, 41742810, 41645681, 41827893, 41739200, 41788998, 41731818, 41684891, 32644245, 41847692, 41632297, 41530480, 41689059, 41702716, 32641023, 41611289, 41643225, 41758065, 41740966, 41802250, 41792363, 41778805, 41793723, 41769206, 41810747, 41576446, 41733829, 41625814, 41784841, 41643238, 41787663, 41687267, 41604139, 41731702, 41600566, 32641022, 41684512, 41719555, 41616992, 41584218, 41601217, 41748479, 41805685, 41709105, 41781951, 41696143, 41691301, 41668304, 41808947, 41712643, 41600234, 41827874, 32641578, 41657443, 41583956, 41840894, 41793510, 41673612, 41759874, 41750943, 41824876, 41630957, 41695420, 41813115, 41765692, 41549700, 41790903, 41774687, 41707214, 41627944, 41280631, 41739867, 41522004, 41706953, 41698348, 41712071, 41651008, 41642796, 41297090, 41684886, 41551678, 41731132, 41692181, 41628615, 41229307, 41728540, 41621361, 41741884, 41129582, 41575892, 41689309, 41748407, 41690139, 41744373, 41536221, 41789149, 41431776, 41748467, 41787543, 41741077, 41584219, 41130637, 41617013, 41701824, 41844768, 41706892, 41719494, 41707206, 41647130, 41849844, 41659055, 41570153, 41690715, 41744591, 41788994, 41828839, 41416150, 41745320, 41594640, 41539464, 41824645, 41421729, 41732085, 41631808, 41754218, 41285028, 41768981, 41802368, 41706976, 41691761, 41467090, 41568239, 41764312, 41604628, 41707184, 41357138, 40831762, 41698347, 41841249, 32612190, 41693750, 41743030, 41785790, 41368611, 41700696, 41672489, 41706860, 41657136, 41712019, 40831763, 41774627, 41813092, 41731809, 41263078, 41707144, 41416234, 41663215, 41742184, 41642713, 41751958, 41742104, 41769114, 41575030, 41767816, 41741449, 41769561, 41585435, 41805998, 41778996, 41743005, 41802283, 38767604, 41797413, 41774776, 41628361, 41615723, 41692329, 41648260, 41368623, 41573981, 41781944, 32641588, 32641585, 41783281, 41676530, 41523461, 32641228, 41754774, 41742814, 41784891, 41739352, 41789796, 41784915, 41788095, 41764151, 41748950, 41731463, 41791462, 41657984, 41561520, 41624008, 41824869, 41297815, 41768729, 41563045, 41745657, 41774706, 41665867, 41714241, 41740343, 32639937, 41297084, 40960935, 41769772, 41585602, 41769810, 41694988, 32639930, 41840700, 41687835, 41393572, 41804360, 32641229, 41610625, 41751356, 41263172, 41816442, 41732084, 41816484, 41651426, 41707261, 41796172, 41461764, 41361788, 41733513, 41759913, 41790894, 41787416, 41678875, 41739906, 41410640, 41110817, 41697904, 41828826, 41658688, 40448071, 41721582, 41633536, 41739471, 41702820, 41792294, 41732062, 32641576, 40552011, 41780362, 41798896, 41729350, 41670511, 41799223, 41748707, 41723489, 32641024, 41706967, 41741218, 41740646, 41784873, 41664540, 41828804, 41740953, 41745699, 41324604, 41696971, 41584283, 41668656, 41657529, 41787546, 41737247, 41784914, 41790993, 41787351, 41667010, 41678284, 41742000, 41596289, 41725153, 41684517, 41793092, 32630873, 41669891, 41604182, 41263175, 41759964, 41690333, 41751301, 41692229, 41712054, 41689026, 41616535, 41711919, 41754203, 41573978, 41781630, 41523114, 41770161, 41658514, 41578576, 41759259, 40860428, 41602932, 41600375, 41219589, 41570762, 41751296, 41588740, 41658515, 41522052, 41614370, 41813671, 41651020, 41687269, 32646167, 41789147, 41769547, 41692217, 41719952, 41726375, 41707240, 41757322, 41789855, 41651072, 41789798, 41829479, 41818800, 41829248, 41749244, 41769054, 41712671, 41530484, 41824671, 41778877, 41813121, 41789115, 41782589, 41732080, 41732081, 41769083, 41584264, 41645153, 41692344, 41785914, 41725115, 41781126, 41700991, 41700989, 41718230, 41617002, 41694839, 41798858, 41449057, 41592711, 41449051, 41745972);

Date: 2024-12-28 10:48:24 Duration: 6ms
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 (41228912, 41228909, 32645832, 41229458, 32645567, 41229640, 32645822, 41229186, 41710326, 41712491, 41689179, 41710056, 41710057, 41395274, 41689190, 41611776, 41713278, 41712464, 41713279, 41689186, 41689187, 41689184, 41611775, 41713277, 41163974, 41710560, 41710561, 41710562, 41395268, 41395270, 41395272, 41395275, 41710555, 41689182, 41689181, 41395269, 41395278, 41689189, 41689183, 41710059, 41710058, 41710557, 41689180, 41611774, 41611777, 41713276, 41395277, 41712465, 41712489, 41163975, 41710564, 41710558, 41710556, 41710559, 41764663, 41779271, 41747548, 41747547, 41747546, 41671493, 41671492, 41671491, 41671488, 41671485, 41744414, 41744413, 41744412, 41744409, 41671490, 41671489, 41744411, 41744410, 41744408, 41744407, 41745015, 41745007, 41745005, 41745004, 41745003, 41745002, 41745014, 41745013, 41745012, 41745011, 41745010, 41745009, 41745008, 41745006, 41745001, 41745000, 41747115, 41747114, 41747113, 41747112, 41747111, 41747110, 41747109, 41747108, 41747107, 41747106);

Date: 2024-12-28 17:22:00 Duration: 6ms

14

215,202

Details

1d3h59m9s

391ms

2s802ms

468ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 28	00	2,642	19m53s	451ms
	01	5,962	44m32s	448ms
	02	4,499	33m15s	443ms
	03	5,782	42m23s	439ms
	04	3,647	26m43s	439ms
	05	2,205	15m44s	428ms
	06	1,743	13m12s	454ms
	07	1,608	11m52s	442ms
	08	3,722	26m51s	433ms
	09	13,604	1h44m35s	461ms
	10	12,475	1h34m58s	456ms
	11	16,855	2h12m42s	472ms
	12	17,131	2h16m14s	477ms
	13	12,718	1h38m56s	466ms
	14	9,793	1h15m32s	462ms
	15	11,119	1h25m24s	460ms
	16	11,463	1h32m11s	482ms
	17	16,268	2h15m34s	500ms
	18	15,751	2h6m27s	481ms
	19	18,537	2h28m58s	482ms
	20	13,351	1h42m51s	462ms
	21	9,545	1h14m8s	466ms
	22	4,782	36m3s	452ms

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

Date: 2024-12-28 17:24:20 Duration: 2s802ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3840418)) AND (("shipping_track"."id" not in (31302127, 31309642, 31310256, 31394918, 31394955, 31394991, 31475908, 31507111, 31779159, 31779236, 31779289, 31919501, 31919541, 32017946, 32563008, 32563009, 32563015, 32563018, 32781046, 32792725, 32793184, 32793184)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:55 Duration: 2s355ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4008877)) AND (("shipping_track"."id" not in (32793151, 32793151)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:45 Duration: 998ms

15

172,696

Details

13s374ms

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 28	00	1,232	83ms	0ms
	01	1,519	113ms	0ms
	02	1,356	93ms	0ms
	03	1,254	92ms	0ms
	04	833	58ms	0ms
	05	468	29ms	0ms
	06	1,618	101ms	0ms
	07	1,336	81ms	0ms
	08	3,207	204ms	0ms
	09	11,040	871ms	0ms
	10	13,411	960ms	0ms
	11	17,667	1s228ms	0ms
	12	18,426	1s373ms	0ms
	13	16,519	1s238ms	0ms
	14	15,700	1s173ms	0ms
	15	13,732	1s37ms	0ms
	16	11,751	1s95ms	0ms
	17	11,450	1s191ms	0ms
	18	9,663	691ms	0ms
	19	9,485	727ms	0ms
	20	5,100	425ms	0ms
	21	3,743	331ms	0ms
	22	2,186	170ms	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-28 12:35:28 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-28 17:21:54 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-28 17:21:54 Duration: 0ms

16

150,115

Details

8s633ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 28	00	789	36ms	0ms
	01	873	42ms	0ms
	02	569	26ms	0ms
	03	739	36ms	0ms
	04	438	21ms	0ms
	05	269	13ms	0ms
	06	592	29ms	0ms
	07	582	28ms	0ms
	08	2,876	146ms	0ms
	09	11,006	625ms	0ms
	10	12,842	725ms	0ms
	11	9,282	553ms	0ms
	12	13,423	836ms	0ms
	13	14,033	811ms	0ms
	14	12,346	676ms	0ms
	15	12,433	686ms	0ms
	16	17,239	1s18ms	0ms
	17	12,567	783ms	0ms
	18	8,820	511ms	0ms
	19	6,677	391ms	0ms
	20	5,930	329ms	0ms
	21	3,716	198ms	0ms
	22	2,074	100ms	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-28 12:46:05 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (33);

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

Date: 2024-12-28 17:24:07 Duration: 0ms

17

145,507

Details

17s632ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 28	00	774	73ms	0ms
	01	870	88ms	0ms
	02	540	53ms	0ms
	03	721	72ms	0ms
	04	435	44ms	0ms
	05	260	26ms	0ms
	06	583	62ms	0ms
	07	572	58ms	0ms
	08	2,788	298ms	0ms
	09	10,818	1s300ms	0ms
	10	12,577	1s489ms	0ms
	11	9,050	1s134ms	0ms
	12	13,080	1s721ms	0ms
	13	13,610	1s644ms	0ms
	14	12,077	1s383ms	0ms
	15	12,130	1s403ms	0ms
	16	16,649	2s92ms	0ms
	17	12,075	1s605ms	0ms
	18	8,430	1s42ms	0ms
	19	6,434	797ms	0ms
	20	5,499	638ms	0ms
	21	3,565	397ms	0ms
	22	1,970	201ms	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-28 13:05:33 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

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

Date: 2024-12-28 15:53:35 Duration: 0ms

18

140,137

Details

1h33m8s

30ms

104ms

39ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 28	00	1,062	40s403ms	38ms
	01	2,646	1m40s	37ms
	02	1,496	57s116ms	38ms
	03	1,876	1m11s	38ms
	04	1,043	39s519ms	37ms
	05	598	23s207ms	38ms
	06	1,037	39s535ms	38ms
	07	1,266	48s603ms	38ms
	08	1,686	1m4s	38ms
	09	8,825	5m53s	40ms
	10	10,085	6m42s	39ms
	11	14,208	9m43s	41ms
	12	14,495	9m59s	41ms
	13	10,803	7m17s	40ms
	14	7,806	5m11s	39ms
	15	8,889	5m54s	39ms
	16	8,850	5m59s	40ms
	17	8,730	6m2s	41ms
	18	8,001	5m13s	39ms
	19	10,706	7m4s	39ms
	20	7,209	4m33s	37ms
	21	5,882	3m39s	37ms
	22	2,938	1m48s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3972519, 3964105, 3959836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:50:44 Duration: 104ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3993897, 3989075, 3977024, 3973714, 3972065, 3963825, 3906901)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:45:54 Duration: 100ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3383277)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:21:57 Duration: 90ms

19

127,821

Details

26s152ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 28	00	659	115ms	0ms
	01	759	139ms	0ms
	02	467	83ms	0ms
	03	685	123ms	0ms
	04	394	71ms	0ms
	05	263	48ms	0ms
	06	450	85ms	0ms
	07	527	97ms	0ms
	08	2,535	476ms	0ms
	09	9,669	1s916ms	0ms
	10	11,250	2s228ms	0ms
	11	8,574	1s825ms	0ms
	12	11,985	2s585ms	0ms
	13	12,037	2s438ms	0ms
	14	10,473	2s53ms	0ms
	15	10,459	2s85ms	0ms
	16	13,765	2s881ms	0ms
	17	10,430	2s308ms	0ms
	18	7,278	1s542ms	0ms
	19	5,810	1s228ms	0ms
	20	4,590	918ms	0ms
	21	3,099	601ms	0ms
	22	1,663	298ms	0ms

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

Date: 2024-12-28 11:59:49 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (937) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-28 16:24:31 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (835) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-28 17:21:54 Duration: 1ms

20

126,161

Details

9s596ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 28	00	1,231	53ms	0ms
	01	1,818	87ms	0ms
	02	1,767	69ms	0ms
	03	1,772	90ms	0ms
	04	1,110	53ms	0ms
	05	608	26ms	0ms
	06	1,442	61ms	0ms
	07	1,021	50ms	0ms
	08	2,519	170ms	0ms
	09	8,486	690ms	0ms
	10	10,054	786ms	0ms
	11	11,980	797ms	0ms
	12	13,363	1s70ms	0ms
	13	11,384	886ms	0ms
	14	8,872	660ms	0ms
	15	9,372	709ms	0ms
	16	9,118	893ms	0ms
	17	8,262	757ms	0ms
	18	6,475	521ms	0ms
	19	6,255	473ms	0ms
	20	4,210	355ms	0ms
	21	3,283	229ms	0ms
	22	1,759	102ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (37, 18);

Date: 2024-12-28 11:44:51 Duration: 1ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (16, 75);

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

Date: 2024-12-28 17:37:34 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

27m43s

53s877ms

339

Details

5h4m24s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 28	00	2	6m31s	3m15s
	01	1	1ms	1ms
	02	1	1ms	1ms
	03	13	2h53m16s	13m19s
	04	1	1ms	1ms
	05	1	1ms	1ms
	06	2	1ms	0ms
	07	3	1ms	0ms
	08	14	1m23s	5s994ms
	09	39	9m8s	14s72ms
	10	38	39m13s	1m1s
	11	23	24ms	1ms
	12	25	22ms	0ms
	13	17	9m40s	34s127ms
	14	26	42m4s	1m37s
	15	26	34ms	1ms
	16	25	8m47s	21s113ms
	17	19	2m35s	8s204ms
	18	23	11m41s	30s489ms
	19	16	20ms	1ms
	20	4	6ms	1ms
	21	8	9ms	1ms
	22	12	12ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-28 02:18:36.314915', "last_update" = '2024-12-28 01:33:36.314938', "sid" = 'fc80c979b36d901420a614ce2450d600d35b894a', "write_date" = '2024-12-28 01:33:35.987792', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 27m43s
UPDATE "res_users" SET "exp_date" = '2024-12-28 02:23:52.473164', "last_update" = '2024-12-28 01:38:52.473181', "sid" = '163b4dbdfc6572f9cd3b3fe612b8b6b337406db6', "write_date" = '2024-12-28 01:38:52.151069', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 22m27s
UPDATE "res_users" SET "exp_date" = '2024-12-28 02:25:13.592365', "last_update" = '2024-12-28 01:40:13.592386', "sid" = '163b4dbdfc6572f9cd3b3fe612b8b6b337406db6', "write_date" = '2024-12-28 01:40:13.269493', "write_uid" = 901 WHERE id IN (901);

Date: 2024-12-28 03:01:20 Duration: 21m6s

2

0ms

11m6s

21s326ms

32

Details

11m22s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 28	03	1	1ms	1ms
	08	3	11m6s	3m42s
	09	1	2ms	2ms
	10	3	1ms	0ms
	12	4	2ms	0ms
	13	2	0ms	0ms
	14	8	9ms	1ms
	16	1	1ms	1ms
	17	3	16s21ms	5s340ms
	18	4	3ms	0ms
	19	2	2ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-28 08:29:14.590872', "last_update" = '2024-12-28 07:44:14.590890', "write_date" = '2024-12-28 07:44:14.250022', "write_uid" = 1 WHERE id IN (838);

Date: 2024-12-28 08:55:20 Duration: 11m6s
UPDATE "res_users" SET "exp_date" = '2024-12-28 16:50:05.008322', "last_update" = '2024-12-28 16:05:05.008354', "write_date" = '2024-12-28 16:05:04.681571', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-28 17:05:21 Duration: 16s17ms
UPDATE "res_users" SET "exp_date" = '2024-12-28 16:52:00.252705', "last_update" = '2024-12-28 16:07:00.252745', "write_date" = '2024-12-28 16:06:59.842437', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-28 17:07:00 Duration: 2ms

3

0ms

1h

3s765ms

70,805

Details

3d2h3m33s

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 28	00	448	2h59m52s	24s90ms
	01	623	136ms	0ms
	02	508	109ms	0ms
	03	526	7h2m32s	48s199ms
	04	402	86ms	0ms
	05	284	61ms	0ms
	06	283	61ms	0ms
	07	383	87ms	0ms
	08	1,168	2h5m14s	6s433ms
	09	3,574	3h2m15s	3s59ms
	10	5,526	8h25m33s	5s489ms
	11	6,999	1s710ms	0ms
	12	7,562	2h15m38s	1s76ms
	13	7,831	7h9m24s	3s290ms
	14	6,615	11h19m45s	6s165ms
	15	5,903	5h6m56s	3s119ms
	16	5,761	6h12m18s	3s877ms
	17	5,239	1h24m24s	966ms
	18	3,873	2h55m13s	2s714ms
	19	3,352	3h19m45s	3s575ms
	20	1,832	2h54m9s	5s703ms
	21	1,335	4h16m4s	11s509ms
	22	778	3h34m21s	16s531ms

update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.438724', exp_date = '2024-12-27 23:09:21.438729', logged_in = 'TRUE' where id = 932;

Date: 2024-12-28 00:24:21 Duration: 1h
update res_users set sid = 'c9a0bd2cea4aeb70f78b0062ffea8f294e00d74e', last_update = '2024-12-27 22:24:21.439054', exp_date = '2024-12-27 23:09:21.439059', logged_in = 'TRUE' where id = 932;

Date: 2024-12-28 00:24:21 Duration: 1h
update res_users set sid = 'f1508fffc6f62ff40db53629d9d10a2512cdbf3e', last_update = '2024-12-28 20:37:27.528101', exp_date = '2024-12-28 21:22:27.528103', logged_in = 'TRUE' where id = 1359;

Date: 2024-12-28 22:37:27 Duration: 1h

4

27ms

4s514ms

2s490ms

282

Details

11m42s

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 28	01	3	9s335ms	3s111ms
	09	17	1m	3s534ms
	11	13	30s43ms	2s311ms
	12	8	29s939ms	3s742ms
	13	2	6s544ms	3s272ms
	14	10	22s759ms	2s275ms
	15	34	1m28s	2s592ms
	16	56	1m23s	1s496ms
	17	52	2m45s	3s185ms
	18	35	59s161ms	1s690ms
	19	21	1m10s	3s339ms
	20	14	45s106ms	3s221ms
	21	14	22s114ms	1s579ms
	22	3	9s453ms	3s151ms

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

Date: 2024-12-28 17:26:39 Duration: 4s514ms
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 (80))))))) 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 (80)))))) 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 (80)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (80)))))) 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 (80))))))))) 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 (80)))))))) AND ("policy_number"."name"::text ilike '%9294040%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-28 17:24:09 Duration: 4s355ms
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 (115))))))) 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 (115)))))) 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 (115)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (115)))))) 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 (115))))))))) 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 (115)))))))) AND ("policy_number"."name"::text ilike '%8338599%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-28 17:26:42 Duration: 4s350ms

5

28ms

1s692ms

899ms

10,126

Details

2h31m48s

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 28	00	375	5m59s	958ms
	01	357	3m2s	509ms
	08	3	2s897ms	965ms
	10	5	155ms	31ms
	11	9	10s229ms	1s136ms
	12	5	5s732ms	1s146ms
	13	18	15s96ms	838ms
	14	90	1m32s	1s22ms
	15	314	5m14s	1s2ms
	16	1,100	19m6s	1s41ms
	17	787	14m10s	1s80ms
	18	1,908	28m31s	896ms
	19	1,851	23m58s	777ms
	20	918	12m14s	800ms
	21	1,648	25m36s	932ms
	22	738	11m48s	960ms

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

Date: 2024-12-28 17:22:06 Duration: 1s692ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9560896')) 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 (85))))))) 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 (85)))))) 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 (85)))))) 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 (85))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-28 17:47:27 Duration: 1s588ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9568485')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-28 17:47:29 Duration: 1s518ms

6

404ms

3s182ms

475ms

43,768

Details

5h47m1s

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 28	00	160	1m13s	456ms
	01	163	1m19s	486ms
	02	110	55s332ms	503ms
	03	119	1m1s	515ms
	04	83	41s966ms	505ms
	05	59	29s782ms	504ms
	06	170	1m15s	444ms
	07	414	3m2s	441ms
	08	862	6m23s	444ms
	09	3,173	24m53s	470ms
	10	2,940	23m13s	474ms
	11	3,573	29m19s	492ms
	12	4,393	35m59s	491ms
	13	3,506	27m53s	477ms
	14	3,415	26m37s	467ms
	15	4,179	32m24s	465ms
	16	3,383	27m7s	481ms
	17	3,656	30m31s	500ms
	18	2,677	20m58s	470ms
	19	3,156	24m46s	470ms
	20	1,971	14m53s	453ms
	21	926	6m57s	450ms
	22	680	5m2s	444ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3840418, 3539189, 3464959, 3464956, 3054919, 2315038)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:53 Duration: 3s182ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3890802)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:58 Duration: 2s756ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3890802)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:58 Duration: 2s482ms

7

391ms

2s802ms

468ms

215,202

Details

1d3h59m9s

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 28	00	2,642	19m53s	451ms
	01	5,962	44m32s	448ms
	02	4,499	33m15s	443ms
	03	5,782	42m23s	439ms
	04	3,647	26m43s	439ms
	05	2,205	15m44s	428ms
	06	1,743	13m12s	454ms
	07	1,608	11m52s	442ms
	08	3,722	26m51s	433ms
	09	13,604	1h44m35s	461ms
	10	12,475	1h34m58s	456ms
	11	16,855	2h12m42s	472ms
	12	17,131	2h16m14s	477ms
	13	12,718	1h38m56s	466ms
	14	9,793	1h15m32s	462ms
	15	11,119	1h25m24s	460ms
	16	11,463	1h32m11s	482ms
	17	16,268	2h15m34s	500ms
	18	15,751	2h6m27s	481ms
	19	18,537	2h28m58s	482ms
	20	13,351	1h42m51s	462ms
	21	9,545	1h14m8s	466ms
	22	4,782	36m3s	452ms

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

Date: 2024-12-28 17:24:20 Duration: 2s802ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3840418)) AND (("shipping_track"."id" not in (31302127, 31309642, 31310256, 31394918, 31394955, 31394991, 31475908, 31507111, 31779159, 31779236, 31779289, 31919501, 31919541, 32017946, 32563008, 32563009, 32563015, 32563018, 32781046, 32792725, 32793184, 32793184)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:55 Duration: 2s355ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4008877)) AND (("shipping_track"."id" not in (32793151, 32793151)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-28 17:50:45 Duration: 998ms

8

196ms

491ms

296ms

16,793

Details

1h23m5s

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 28	00	401	2m	300ms
	01	943	4m44s	301ms
	02	789	3m54s	297ms
	03	605	3m1s	300ms
	04	505	2m29s	295ms
	06	543	2m40s	295ms
	07	289	1m24s	293ms
	08	31	9s442ms	304ms
	09	21	6s858ms	326ms
	10	107	33s431ms	312ms
	11	27	9s904ms	366ms
	12	111	36s510ms	328ms
	13	318	1m46s	334ms
	14	377	2m3s	326ms
	15	448	2m22s	317ms
	16	1,017	5m33s	327ms
	17	1,221	6m28s	318ms
	18	2,151	10m33s	294ms
	19	2,124	10m32s	297ms
	20	2,331	10m54s	280ms
	21	1,939	8m48s	272ms
	22	495	2m12s	267ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9640008')) 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-28 17:47:24 Duration: 491ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9570019')) 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-28 17:50:46 Duration: 478ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9432825')) 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-28 11:32:42 Duration: 477ms

9

158ms

624ms

269ms

21,874

Details

1h38m4s

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 28	07	169	43s876ms	259ms
	08	422	1m44s	248ms
	09	2,145	9m33s	267ms
	10	3,035	13m42s	270ms
	11	1,849	8m40s	281ms
	12	1,783	8m27s	284ms
	13	2,255	10m12s	271ms
	14	2,673	11m52s	266ms
	15	1,841	8m22s	272ms
	16	2,338	10m40s	274ms
	17	2,283	9m47s	257ms
	18	759	3m1s	238ms
	19	322	1m15s	233ms

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

Date: 2024-12-28 12:00:06 Duration: 624ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '8909807')))) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:06 Duration: 600ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '8911942')))) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:07 Duration: 561ms

10

197ms

402ms

259ms

2,517

Details

10m52s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 28	10	181	50s346ms	278ms
	11	119	33s706ms	283ms
	12	114	30s677ms	269ms
	13	294	1m20s	275ms
	14	276	1m15s	274ms
	16	403	1m47s	267ms
	17	488	2m6s	260ms
	18	319	1m15s	235ms
	19	323	1m11s	221ms

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

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

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

Date: 2024-12-28 17:50:34 Duration: 373ms

11

90ms

865ms

235ms

53,189

Details

3h29m11s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 28	00	1,538	4m58s	193ms
	01	2,567	8m24s	196ms
	02	1,566	5m57s	228ms
	03	1,198	4m48s	240ms
	04	998	3m26s	206ms
	06	1,072	3m39s	204ms
	07	572	2m11s	229ms
	08	68	14s771ms	217ms
	09	42	9s869ms	234ms
	10	222	1m	271ms
	11	72	15s595ms	216ms
	12	224	51s582ms	230ms
	13	664	2m24s	217ms
	14	912	3m40s	241ms
	15	1,510	6m11s	245ms
	16	4,187	17m36s	252ms
	17	3,973	17m40s	266ms
	18	8,002	32m24s	243ms
	19	7,880	31m41s	241ms
	20	6,387	25m58s	243ms
	21	7,106	26m50s	226ms
	22	2,429	8m46s	216ms

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-28 18:02:34 Duration: 865ms
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-28 18:02:34 Duration: 864ms
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-28 19:18:23 Duration: 861ms

12

155ms

313ms

212ms

5,431

Details

19m11s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 28	06	192	39s375ms	205ms
	07	87	17s618ms	202ms
	08	129	26s281ms	203ms
	09	1,543	5m35s	217ms
	10	238	53s299ms	223ms
	11	962	3m32s	220ms
	12	136	30s478ms	224ms
	13	256	57s150ms	223ms
	14	369	1m18s	213ms
	16	378	1m22s	217ms
	17	545	1m51s	204ms
	18	331	1m	182ms
	19	265	46s883ms	176ms

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" = '461696')) 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-28 17:50:39 Duration: 313ms
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" = '9026739')) 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-28 11:56:22 Duration: 298ms
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" = '9461344')) 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-28 17:50:21 Duration: 291ms

13

153ms

401ms

210ms

8,228

Details

28m52s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 28	00	65	13s305ms	204ms
	01	167	34s38ms	203ms
	04	192	38s705ms	201ms
	05	110	22s292ms	202ms
	06	99	20s23ms	202ms
	07	276	56s96ms	203ms
	08	687	2m20s	204ms
	09	883	3m6s	211ms
	10	989	3m31s	214ms
	11	1,195	4m22s	219ms
	12	891	3m18s	222ms
	13	441	1m37s	220ms
	14	175	39s238ms	224ms
	15	369	1m20s	217ms
	16	872	3m5s	212ms
	17	303	56s788ms	187ms
	18	28	5s700ms	203ms
	19	342	59s302ms	173ms
	21	144	23s666ms	164ms

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" = '9614325')) 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-28 12:00:10 Duration: 401ms
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" = '9687180')) 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-28 12:00:10 Duration: 361ms
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" = '9530274')) 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-28 12:00:12 Duration: 340ms

14

152ms

1s151ms

207ms

85,248

Details

4h55m23s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 28	00	482	1m38s	203ms
	01	1,278	4m19s	203ms
	02	959	3m14s	202ms
	03	1,101	3m45s	204ms
	04	1,161	3m55s	202ms
	05	512	1m44s	204ms
	06	346	1m10s	203ms
	07	705	2m23s	203ms
	08	1,376	4m40s	204ms
	09	5,948	21m16s	214ms
	10	6,559	23m38s	216ms
	11	6,898	25m24s	221ms
	12	5,012	18m36s	222ms
	13	6,106	22m2s	216ms
	14	4,764	17m17s	217ms
	15	4,573	16m28s	216ms
	16	6,420	23m2s	215ms
	17	20,668	1h9m40s	202ms
	18	8,713	26m12s	180ms
	19	1,415	4m7s	174ms
	20	108	19s535ms	180ms
	21	144	23s593ms	163ms

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

Date: 2024-12-28 12:00:09 Duration: 1s151ms
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" = '9361572')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-28 12:00:10 Duration: 1s116ms
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" = '9579759')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-28 17:50:57 Duration: 607ms

15

183ms

234ms

203ms

4,718

Details

16m

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 28	00	417	1m24s	203ms
	01	911	3m5s	203ms
	02	949	3m12s	202ms
	03	1,101	3m45s	204ms
	04	969	3m16s	203ms
	05	316	1m4s	205ms
	06	55	11s63ms	201ms

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" = '9640315')) 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-28 03:49:01 Duration: 234ms
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" = '9603626')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 43, 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-28 05:21:04 Duration: 234ms
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" = '9581596')) 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-28 03:15:01 Duration: 232ms

16

119ms

248ms

141ms

5,575

Details

13m11s

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 28	00	26	3s389ms	130ms
	01	30	3s888ms	129ms
	07	10	1s313ms	131ms
	08	77	10s155ms	131ms
	09	456	1m4s	141ms
	10	671	1m33s	138ms
	11	1,057	2m33s	144ms
	12	982	2m21s	144ms
	13	792	1m53s	143ms
	14	476	1m6s	139ms
	15	252	34s737ms	137ms
	16	224	32s342ms	144ms
	17	108	16s627ms	153ms
	18	90	12s995ms	144ms
	19	89	12s603ms	141ms
	20	80	10s860ms	135ms
	21	80	10s555ms	131ms
	22	75	9s733ms	129ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 36)) 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-28 17:50:33 Duration: 248ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 38)) 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-28 11:32:41 Duration: 206ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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-28 12:01:03 Duration: 201ms

17

80ms

299ms

97ms

18,598

Details

30m8s

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 28	00	162	14s522ms	89ms
	01	721	1m4s	88ms
	02	719	1m5s	90ms
	06	6	541ms	90ms
	07	43	3s921ms	91ms
	08	206	19s569ms	94ms
	09	888	1m28s	100ms
	10	1,102	1m46s	96ms
	11	1,229	2m3s	100ms
	12	1,408	2m24s	102ms
	13	1,715	2m47s	97ms
	14	3,357	5m19s	95ms
	15	2,235	3m34s	96ms
	16	1,164	1m55s	99ms
	17	995	1m42s	102ms
	18	1,256	2m1s	96ms
	19	482	48s694ms	101ms
	20	672	1m4s	95ms
	21	132	12s419ms	94ms
	22	106	10s280ms	96ms

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

Date: 2024-12-28 12:00:06 Duration: 299ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7896945)) AND (("cash_track"."id" not in (6302975)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-28 17:22:29 Duration: 260ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7894894)) AND (("cash_track"."id" not in (6288296)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-28 12:00:10 Duration: 212ms

18

36ms

109ms

47ms

46,376

Details

36m34s

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 28	00	74	3s283ms	44ms
	01	4	197ms	49ms
	06	5	243ms	48ms
	07	306	13s607ms	44ms
	08	496	21s739ms	43ms
	09	3,755	2m52s	45ms
	10	4,055	3m7s	46ms
	11	5,276	4m13s	48ms
	12	4,343	3m31s	48ms
	13	4,211	3m19s	47ms
	14	3,990	3m7s	47ms
	15	4,123	3m14s	47ms
	16	5,622	4m26s	47ms
	17	5,470	4m21s	47ms
	18	2,258	1m46s	47ms
	19	1,895	1m29s	47ms
	20	217	10s491ms	48ms
	21	178	8s301ms	46ms
	22	98	4s444ms	45ms

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

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

Date: 2024-12-28 17:47:19 Duration: 94ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3732631) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-28 15:02:58 Duration: 88ms

19

32ms

74ms

42ms

19,760

Details

13m59s

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 28	07	159	6s291ms	39ms
	08	225	9s155ms	40ms
	09	1,385	57s869ms	41ms
	10	1,867	1m17s	41ms
	11	2,461	1m45s	42ms
	12	1,673	1m11s	42ms
	13	1,882	1m20s	42ms
	14	1,786	1m16s	42ms
	15	2,586	1m49s	42ms
	16	2,339	1m39s	42ms
	17	2,232	1m37s	43ms
	18	639	25s615ms	40ms
	19	515	22s278ms	43ms
	20	11	495ms	45ms

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

Date: 2024-12-28 12:00:01 Duration: 74ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3905316) ORDER BY "collection_policy"."id";

Date: 2024-12-28 17:24:17 Duration: 73ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3950298) ORDER BY "collection_policy"."id";

Date: 2024-12-28 12:00:02 Duration: 69ms

20

30ms

104ms

39ms

140,137

Details

1h33m8s

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 28	00	1,062	40s403ms	38ms
	01	2,646	1m40s	37ms
	02	1,496	57s116ms	38ms
	03	1,876	1m11s	38ms
	04	1,043	39s519ms	37ms
	05	598	23s207ms	38ms
	06	1,037	39s535ms	38ms
	07	1,266	48s603ms	38ms
	08	1,686	1m4s	38ms
	09	8,825	5m53s	40ms
	10	10,085	6m42s	39ms
	11	14,208	9m43s	41ms
	12	14,495	9m59s	41ms
	13	10,803	7m17s	40ms
	14	7,806	5m11s	39ms
	15	8,889	5m54s	39ms
	16	8,850	5m59s	40ms
	17	8,730	6m2s	41ms
	18	8,001	5m13s	39ms
	19	10,706	7m4s	39ms
	20	7,209	4m33s	37ms
	21	5,882	3m39s	37ms
	22	2,938	1m48s	37ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3972519, 3964105, 3959836)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:50:44 Duration: 104ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3993897, 3989075, 3977024, 3973714, 3972065, 3963825, 3906901)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:45:54 Duration: 100ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3383277)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-28 17:21:57 Duration: 90ms

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

17,593,413 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	7	0.00%
DETAIL	24	0.00%
ERROR	7,425	0.04%
EVENTLOG	1,207	0.01%
FATAL	1,029	0.01%
HINT	3	0.00%
LOG	17,576,262	99.90%
STATEMENT	7,456	0.04%

Events distribution (except queries)

Key values

0 PANIC entries
1029 FATAL entries
7425 ERROR entries
0 WARNING entries
1207 EVENTLOG entries

Most Frequent Errors/Events

Key values

3,794 Max number of times the same event was reported
9,661 Total events found

Rank

Times reported

Error

1

3,794

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 28	00	34
	01	2
	02	5
	03	10
	04	2
	05	14
	06	8
	07	15
	08	36
	09	127
	10	234
	11	247
	12	365
	13	512
	14	404
	15	507
	16	490
	17	439
	18	165
	19	91
	20	37
	21	26
	22	24

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

2

3,602

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 28	00	30
	01	1
	02	4
	03	10
	04	1
	05	14
	06	8
	07	15
	08	36
	09	118
	10	220
	11	235
	12	350
	13	494
	14	387
	15	490
	16	471
	17	397
	18	156
	19	83
	20	34
	21	26
	22	22

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

3

898

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 28	00	2
	03	32
	08	25
	09	27
	10	104
	12	28
	13	69
	14	73
	15	55
	16	223
	17	85
	18	88
	19	28
	20	30
	21	28
	22	1

4

898

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 28	00	2
	03	32
	08	25
	09	27
	10	104
	12	28
	13	69
	14	73
	15	55
	16	223
	17	85
	18	88
	19	28
	20	30
	21	28
	22	1

5

214

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 28	00	2
	03	10
	08	9
	09	6
	10	29
	12	4
	13	27
	14	31
	15	10
	16	37
	17	14
	18	15
	19	8
	20	6
	21	3
	22	3

6

94

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 28	08	5
	09	4
	10	15
	12	1
	13	17
	14	12
	15	5
	16	20
	17	3
	18	3
	19	1
	20	5
	21	2
	22	1

7

88

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 28	17	88

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

8

20

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 28	17	20

9

15

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 28	11	2
	12	2
	13	5
	14	3
	17	2
	20	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

10

9

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 28	12	5
	17	2
	18	2

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

11

6

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 28	02	3
	18	3

FATAL: password authentication failed for user "postgres"

12

4

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 28	17	4

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

13

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 28	01	1
	12	1
	16	1

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

14

3

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 28	11	2
	12	1

15

2

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 28	12	1
	21	1

16

2

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 28	12	1
	21	1

17

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 28	09	1
	20	1

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

18

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 28	12	1
	21	1

19

2

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 28	17	2

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 28	17	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 28	02	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

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