pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Dec 7 23:47:22 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 64,893,544 log entries in 2m20s
Log start from 2024-12-07 00:00:00 to 2024-12-07 22:45:02

Global Stats

17,775 Number of unique normalized queries
17,703,285 Number of queries
2d14h53m40s Total query duration
2024-12-07 00:00:00 First query
2024-12-07 22:45:02 Last query
3,001 queries/s at 2024-12-07 17:33:30 Query peak

2d14h53m40s Total query duration
1s37ms Prepare/parse total duration
42s464ms Bind total duration
2d14h52m57s Execute total duration

1,422 Number of events
25 Number of unique normalized events
453 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,703,285 Average queries per session
2d14h53m40s 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

3,001 queries/s Query Peak
2024-12-07 17:33:30 Date

SELECT Traffic

Key values

1,693 queries/s Query Peak
2024-12-07 17:33:30 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,292 queries/s Query Peak
2024-12-07 17:33:30 Date

Queries duration

Key values

2d14h53m40s 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 07	00	266,915	0ms	3s233ms	13ms	1m51s	2m10s	2m13s
	01	261,202	0ms	1s289ms	15ms	2m9s	2m23s	2m41s
	02	264,311	0ms	1s273ms	13ms	1m45s	2m3s	2m15s
	03	256,016	0ms	920ms	14ms	2m12s	3m28s	4m11s
	04	211,894	0ms	4s579ms	11ms	1m37s	1m50s	3m36s
	05	209,067	0ms	4s266ms	16ms	1m53s	2m10s	2m42s
	06	195,003	0ms	1s119ms	5ms	53s368ms	1m1s	1m19s
	07	181,386	0ms	474ms	4ms	41s401ms	50s111ms	1m4s
	08	459,230	0ms	3s833ms	5ms	1m45s	2m4s	2m38s
	09	952,253	0ms	3s835ms	7ms	3m28s	4m6s	4m15s
	10	1,446,167	0ms	4s540ms	8ms	5m29s	6m21s	6m32s
	11	1,401,110	0ms	3s841ms	7ms	4m29s	5m46s	6m29s
	12	1,379,975	0ms	4s998ms	8ms	5m15s	6m1s	6m59s
	13	1,252,784	0ms	4s451ms	6ms	3m30s	4m13s	6m1s
	14	1,201,183	0ms	3s934ms	6ms	3m44s	4m19s	4m27s
	15	1,138,752	0ms	3s596ms	6ms	3m20s	4m13s	5m3s
	16	1,211,734	0ms	15s572ms	9ms	7m33s	7m57s	9m11s
	17	1,164,961	0ms	21s381ms	12ms	7m1s	7m35s	9m1s
	18	1,169,445	0ms	5s806ms	12ms	7m8s	9m47s	10m38s
	19	1,130,631	0ms	11m12s	26ms	12m40s	13m41s	2h13m13s
	20	900,813	0ms	27m23s	40ms	8m35s	12m14s	5h1m5s
	21	726,950	0ms	2m18s	16ms	6m1s	6m28s	8m3s
	22	321,503	0ms	59m59s	49ms	3m17s	3m44s	3h1m39s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 07	00	165,566	21ms	1m25s	1m51s	2m11s
	01	160,566	24ms	1m54s	2m8s	2m34s
	02	160,788	21ms	1m29s	1m45s	2m10s
	03	156,163	23ms	1m22s	2m12s	3m43s
	04	130,432	19ms	1m5s	1m37s	2m27s
	05	131,473	25ms	1m34s	1m53s	2m19s
	06	131,036	8ms	37s265ms	53s199ms	1m4s
	07	121,578	5ms	23s341ms	41s269ms	1m
	08	283,874	9ms	1m14s	1m45s	2m31s
	09	563,722	12ms	2m47s	3m27s	4m8s
	10	851,620	14ms	4m24s	5m28s	6m24s
	11	794,828	13ms	3m45s	4m28s	6m2s
	12	776,892	14ms	4m23s	5m14s	6m46s
	13	703,139	12ms	3m8s	3m29s	4m37s
	14	678,204	12ms	3m15s	3m43s	4m18s
	15	672,547	10ms	2m27s	3m20s	4m12s
	16	716,536	16ms	4m52s	7m31s	8m30s
	17	714,304	20ms	5m35s	7m	8m58s
	18	724,880	20ms	5m21s	7m6s	9m52s
	19	713,635	29ms	9m23s	11m37s	13m23s
	20	569,098	31ms	6m52s	8m28s	12m13s
	21	460,112	25ms	4m49s	5m59s	6m27s
	22	205,523	24ms	2m51s	3m7s	3m45s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 07	00	18,044	3,200	141	0	0ms	92ms	123ms	192ms
	01	20,801	3,941	80	0	0ms	126ms	177ms	233ms
	02	15,708	3,710	82	0	0ms	94ms	122ms	168ms
	03	17,131	3,419	74	0	0ms	97ms	132ms	272ms
	04	10,162	2,732	68	0	0ms	66ms	92ms	178ms
	05	13,745	3,959	74	0	0ms	100ms	125ms	158ms
	06	5,587	1,391	89	0	0ms	28ms	56ms	107ms
	07	2,575	799	94	0	0ms	18ms	32ms	56ms
	08	13,711	3,104	326	0	0ms	94ms	137ms	230ms
	09	37,728	8,884	743	0	0ms	189ms	249ms	467ms
	10	75,793	11,796	780	0	0ms	404ms	477ms	578ms
	11	69,078	12,233	789	0	0ms	357ms	417ms	523ms
	12	68,315	12,888	652	1	0ms	369ms	428ms	564ms
	13	52,972	11,922	619	1	0ms	258ms	320ms	392ms
	14	48,510	11,575	449	0	0ms	244ms	308ms	402ms
	15	41,928	11,244	554	6	0ms	212ms	285ms	399ms
	16	56,124	17,391	652	14	0ms	351ms	454ms	1s20ms
	17	59,915	17,129	647	1	0ms	460ms	537ms	899ms
	18	74,923	17,473	553	0	0ms	464ms	578ms	792ms
	19	77,730	30,913	826	0	77ms	622ms	771ms	2m15s
	20	64,781	19,432	500	0	213ms	404ms	472ms	813ms
	21	57,281	12,817	443	0	5ms	333ms	457ms	1m32s
	22	25,867	5,355	153	0	341ms	199ms	239ms	373ms

Day	Hour	Prepare	Bind	Bind/Prepare	Percentage of prepare
Dec 07	00	118	61,228	518.88	0.05%
	01	118	61,228	518.88	0.05%
	02	118	61,228	518.88	0.05%
	03	118	61,228	518.88	0.05%
	04	118	61,228	518.88	0.06%
	05	118	61,228	518.88	0.06%
	06	118	61,228	518.88	0.07%
	07	118	61,228	518.88	0.07%
	08	118	61,228	518.88	0.03%
	09	118	61,228	518.88	0.01%
	10	118	61,228	518.88	0.01%
	11	118	61,228	518.88	0.01%
	12	118	61,228	518.88	0.01%
	13	118	61,228	518.88	0.01%
	14	118	61,228	518.88	0.01%
	15	118	61,228	518.88	0.01%
	16	118	61,228	518.88	0.01%
	17	121	59,327	490.31	0.01%
	18	118	61,228	518.88	0.01%
	19	118	61,228	518.88	0.01%
	20	118	61,228	518.88	0.01%
	21	118	61,228	518.88	0.02%
	22	97	45,971	473.93	0.03%

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

264,529 buffers Checkpoint Peak
2024-12-07 15:26:30 Date
270.059 seconds Highest write time
6.098 seconds Sync time

Checkpoints Wal files

Key values

285 files Wal files usage Peak
2024-12-07 22:31:33 Date

Checkpoints distance

Key values

10,101.18 Mo Distance Peak
2024-12-07 22:26:14 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 07	00	119,504	3,166.869s	0.05s	3,166.958s
	01	99,857	3,123.163s	0.028s	3,123.233s
	02	83,131	3,239.509s	0.028s	3,239.58s
	03	109,569	3,239.615s	0.03s	3,239.688s
	04	67,443	3,168.502s	0.025s	3,168.571s
	05	84,366	3,376.773s	0.04s	3,376.854s
	06	34,026	2,261.156s	0.022s	2,261.201s
	07	24,721	1,681.066s	0.019s	1,681.11s
	08	104,628	3,044.683s	0.031s	3,044.748s
	09	274,981	3,239.647s	0.043s	3,239.752s
	10	518,930	3,239.489s	0.058s	3,239.63s
	11	526,115	3,239.457s	0.05s	3,239.604s
	12	526,769	3,239.474s	0.054s	3,239.614s
	13	421,854	3,239.514s	0.054s	3,239.648s
	14	376,670	3,239.579s	0.045s	3,239.718s
	15	538,608	3,239.541s	0.052s	3,239.669s
	16	331,290	3,239.495s	0.046s	3,239.606s
	17	447,444	2,881.933s	0.072s	2,882.088s
	18	335,543	3,239.569s	0.059s	3,239.698s
	19	317,119	3,239.509s	0.046s	3,239.633s
	20	338,446	3,239.52s	0.048s	3,239.641s
	21	277,986	3,239.534s	0.042s	3,239.652s
	22	1,549,270	2,350.974s	50.512s	2,404.496s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 07	00	0	52	3,596	0.010s	0.012s
	01	0	44	2,650	0.002s	0.012s
	02	0	38	2,401	0.002s	0.012s
	03	0	62	2,551	0.002s	0.012s
	04	0	30	2,281	0.002s	0.012s
	05	0	39	2,455	0.012s	0.013s
	06	0	15	2,185	0.002s	0.01s
	07	0	11	1,574	0.002s	0.011s
	08	0	46	3,108	0.002s	0.012s
	09	0	117	4,385	0.002s	0.012s
	10	0	235	4,788	0.002s	0.012s
	11	0	249	4,991	0.002s	0.012s
	12	0	245	5,084	0.003s	0.012s
	13	0	195	5,200	0.003s	0.012s
	14	0	175	5,154	0.002s	0.012s
	15	0	219	5,403	0.003s	0.012s
	16	0	130	5,349	0.002s	0.012s
	17	0	185	5,532	0.006s	0.012s
	18	0	138	5,552	0.003s	0.012s
	19	0	129	5,296	0.003s	0.012s
	20	0	143	5,142	0.003s	0.012s
	21	0	114	5,004	0.002s	0.012s
	22	755	3,756	12,558	0.853s	0.247s

Day	Hour	Avg time (sec)
Dec 07	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 07	00	71,290.08 kB	101,569.17 kB
	01	60,537.42 kB	101,620.00 kB
	02	51,470.92 kB	77,075.33 kB
	03	84,064.67 kB	173,757.42 kB
	04	42,014.67 kB	101,676.17 kB
	05	48,470.77 kB	66,602.77 kB
	06	25,760.30 kB	55,991.00 kB
	07	15,243.73 kB	35,088.36 kB
	08	62,931.58 kB	74,589.17 kB
	09	143,058.91 kB	201,283.55 kB
	10	321,177.67 kB	381,974.50 kB
	11	333,205.36 kB	410,094.64 kB
	12	334,905.58 kB	390,540.08 kB
	13	266,624.00 kB	325,917.42 kB
	14	239,370.45 kB	296,679.18 kB
	15	299,101.00 kB	849,780.08 kB
	16	181,506.82 kB	574,848.27 kB
	17	252,175.08 kB	345,567.25 kB
	18	187,136.82 kB	272,517.18 kB
	19	175,781.92 kB	232,771.42 kB
	20	194,902.92 kB	233,431.25 kB
	21	156,916.17 kB	197,734.08 kB
	22	3,212,949.83 kB	3,957,694.30 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (269) Main checkpoint cause
285 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	269
wal	14
immediate force wait	1
shutdown immediate	1
Total	285

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 07	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 07	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,586,516 Total read queries
4,798,647 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,586,516	59.80%
INSERT	928,409	5.24%
UPDATE	227,307	1.28%
DELETE	9,388	0.05%
COPY FROM	23	0.00%
COPY TO	0	0.00%
CTE	100,156	0.57%
DDL	744	0.00%
TCL	3,532,620	19.95%
CURSOR	0	0.00%
OTHERS	2,318,122	13.09%

Queries by database

Key values

unknown Main database
17,703,285 Requests
2d14h52m57s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	17,703,285	2d14h52m57s
	copy from	23	19ms
	cte	100,156	56s448ms
	ddl	744	3m22s
	delete	9,388	1s149ms
	insert	928,409	4m46s
	others	2,318,121	2m2s
	select	10,586,516	2d4h10m28s
	tcl	3,532,620	2m5s
	update	227,307	10h29m15s

Queries by user

Key values

unknown Main user
17,703,285 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	17,703,285	2d14h52m57s
	copy from	23	19ms
	cte	100,156	56s448ms
	ddl	744	3m22s
	delete	9,388	1s149ms
	insert	928,409	4m46s
	others	2,318,121	2m2s
	select	10,586,516	2d4h10m28s
	tcl	3,532,620	2m5s
	update	227,307	10h29m15s

Duration by user

Key values

2d14h52m57s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	17,703,285	2d14h52m57s
	copy from	23	19ms
	cte	100,156	56s448ms
	ddl	744	3m22s
	delete	9,388	1s149ms
	insert	928,409	4m46s
	others	2,318,121	2m2s
	select	10,586,516	2d4h10m28s
	tcl	3,532,620	2m5s
	update	227,307	10h29m15s

Queries by host

Key values

unknown Main host
17,703,285 Requests
2d14h52m57s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	17,703,285	2d14h52m57s
	copy from	23	19ms
	cte	100,156	56s448ms
	ddl	744	3m22s
	delete	9,388	1s149ms
	insert	928,409	4m46s
	others	2,318,121	2m2s
	select	10,586,516	2d4h10m28s
	tcl	3,532,620	2m5s
	update	227,307	10h29m15s

Queries by application

Key values

unknown Main application
17,703,285 Requests
2d14h52m57s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	17,703,285	2d14h52m57s
	copy from	23	19ms
	cte	100,156	56s448ms
	ddl	744	3m22s
	delete	9,388	1s149ms
	insert	928,409	4m46s
	others	2,318,121	2m2s
	select	10,586,516	2d4h10m28s
	tcl	3,532,620	2m5s
	update	227,307	10h29m15s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-07 19:24:07 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

16,495,568 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	16,495,568	93.18%
1-5ms	378,444	2.14%
5-10ms	18,170	0.10%
10-25ms	55,485	0.31%
25-50ms	186,059	1.05%
50-100ms	43,453	0.25%
100-500ms	504,032	2.85%
500-1000ms	17,096	0.10%
1000-10000ms	4,870	0.03%
> 10000ms	108	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869308', exp_date = '2024-12-07 20:55:36.869311', logged_in = 'TRUE' where id = 956; [ Date: 2024-12-07 22:10:36 ]
2	59m59s	update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869307', exp_date = '2024-12-07 20:55:36.869309', logged_in = 'TRUE' where id = 956; [ Date: 2024-12-07 22:10:36 ]
3	58m37s	update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:11:59.301053', exp_date = '2024-12-07 20:56:59.301056', logged_in = 'TRUE' where id = 956; [ Date: 2024-12-07 22:10:36 ]
4	27m23s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:30:57.611210', exp_date = '2024-12-07 20:15:57.611213', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
5	27m23s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:30:57.611154', exp_date = '2024-12-07 20:15:57.611158', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
6	24m28s	UPDATE "res_users" SET "exp_date" = '2024-12-07 20:18:51.874895', "last_update" = '2024-12-07 19:33:51.874920', "logged_in" = true, "sid" = 'a7291f598aeda37ad01b47e62891f15863374183', "write_date" = '2024-12-07 19:33:51.537018', "write_uid" = 949 WHERE id IN (949); [ Date: 2024-12-07 20:58:20 ]
7	24m25s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:33:55.068782', exp_date = '2024-12-07 20:18:55.068784', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
8	24m4s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:34:16.243388', exp_date = '2024-12-07 20:19:16.243392', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
9	15m20s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:43:00.057328', exp_date = '2024-12-07 20:28:00.057331', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
10	15m16s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:43:03.728126', exp_date = '2024-12-07 20:28:03.728130', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
11	14m28s	update res_users set sid = 'a7291f598aeda37ad01b47e62891f15863374183', last_update = '2024-12-07 19:43:52.369426', exp_date = '2024-12-07 20:28:52.369429', logged_in = 'TRUE' where id = 949; [ Date: 2024-12-07 20:58:20 ]
12	13m46s	update res_users set sid = 'a7291f598aeda37ad01b47e62891f15863374183', last_update = '2024-12-07 19:44:34.555674', exp_date = '2024-12-07 20:29:34.555680', logged_in = 'TRUE' where id = 949; [ Date: 2024-12-07 20:58:20 ]
13	12m40s	UPDATE "res_users" SET "exp_date" = '2024-12-07 20:30:40.257201', "last_update" = '2024-12-07 19:45:40.257223', "logged_in" = true, "sid" = 'c84c324ed00819e929f25faba3943d797e9f08d5', "write_date" = '2024-12-07 19:45:39.915384', "write_uid" = 949 WHERE id IN (949); [ Date: 2024-12-07 20:58:20 ]
14	12m39s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:45:41.141422', exp_date = '2024-12-07 20:30:41.141425', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
15	12m34s	update res_users set sid = '02ca7895913f017217d1e5c739cd705c37351717', last_update = '2024-12-07 19:45:45.880870', exp_date = '2024-12-07 20:30:45.880872', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-07 20:58:20 ]
16	11m12s	update res_users set sid = '24010ce30ddb8c1230499ce954bb1afed41f64ba', last_update = '2024-12-07 18:20:08.759618', exp_date = '2024-12-07 19:05:08.759620', logged_in = 'TRUE' where id = 1116; [ Date: 2024-12-07 19:31:20 ]
17	10m33s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2024-12-07 18:20:47.855726', exp_date = '2024-12-07 19:05:47.855731', logged_in = 'TRUE' where id = 833; [ Date: 2024-12-07 19:31:20 ]
18	10m29s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2024-12-07 18:20:51.424824', exp_date = '2024-12-07 19:05:51.424827', logged_in = 'TRUE' where id = 833; [ Date: 2024-12-07 19:31:20 ]
19	10m26s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2024-12-07 18:20:54.740166', exp_date = '2024-12-07 19:05:54.740171', logged_in = 'TRUE' where id = 833; [ Date: 2024-12-07 19:31:20 ]
20	10m23s	update res_users set sid = '07c1953fe064bf0b17cf41261f3951da3d0a2d26', last_update = '2024-12-07 18:20:57.787388', exp_date = '2024-12-07 19:05:57.787392', logged_in = 'TRUE' where id = 833; [ Date: 2024-12-07 19:31:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1d55m14s

231,040

Details

321ms

1s109ms

388ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	4,960	29m41s	359ms
	01	6,100	36m28s	358ms
	02	5,582	33m5s	355ms
	03	6,019	35m47s	356ms
	04	3,921	23m20s	357ms
	05	4,274	25m29s	357ms
	06	1,409	8m27s	360ms
	07	1,117	6m22s	342ms
	08	3,974	23m2s	347ms
	09	9,703	57m21s	354ms
	10	19,429	2h37s	372ms
	11	17,257	1h46m51s	371ms
	12	15,710	1h38m29s	376ms
	13	10,255	1h2m22s	364ms
	14	9,308	56m36s	364ms
	15	7,398	44m59s	364ms
	16	11,436	1h13m31s	385ms
	17	17,131	1h55m29s	404ms
	18	15,057	1h46m8s	422ms
	19	17,593	2h7m51s	436ms
	20	21,155	2h32m45s	433ms
	21	17,000	1h55m2s	406ms
	22	5,252	35m22s	404ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3219807)) AND (("shipping_track"."id" not in (26313506, 26314819, 26315109, 26427568, 26427682, 26463147, 26523260, 26680843, 26680984, 26681059, 27158286, 27254646, 27354844, 27355043, 27355043)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 1s109ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345087)) AND (("shipping_track"."id" not in (27353987, 27353987)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:14:03 Duration: 1s45ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345516)) AND (("shipping_track"."id" not in (27355044, 27355044)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 918ms

2

9h25m57s

8,743

Details

0ms

59m59s

3s883ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 07	19	3,398	2h17m48s	2s433ms
	20	2,641	4h3m24s	5s529ms
	21	1,940	6m7s	189ms
	22	764	2h58m37s	14s28ms

update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869308', exp_date = '2024-12-07 20:55:36.869311', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 59m59s
update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869307', exp_date = '2024-12-07 20:55:36.869309', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 59m59s
update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:11:59.301053', exp_date = '2024-12-07 20:56:59.301056', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 58m37s

3

6h33m35s

107,087

Details

171ms

403ms

220ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 07	00	538	1m46s	197ms
	01	945	3m6s	197ms
	02	1,480	4m52s	197ms
	03	1,168	3m52s	199ms
	04	1,378	4m33s	198ms
	05	2,679	8m52s	198ms
	06	280	55s822ms	199ms
	07	454	1m29s	196ms
	08	1,476	4m54s	199ms
	09	4,070	13m45s	202ms
	10	3,471	12m15s	211ms
	11	3,240	11m21s	210ms
	12	5,506	19m33s	213ms
	13	4,866	16m47s	206ms
	14	4,944	17m11s	208ms
	15	4,477	15m6s	202ms
	16	11,049	40m48s	221ms
	17	11,043	40m45s	221ms
	18	1,913	7m5s	222ms
	19	27,307	1h49m57s	241ms
	20	13,481	50m14s	223ms
	21	1,073	3m33s	199ms
	22	249	47s5ms	188ms

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

Date: 2024-12-07 19:14:02 Duration: 403ms
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" = '9197371')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-07 19:19:37 Duration: 389ms
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" = '7914557')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-07 19:18:27 Duration: 384ms

4

4h38m6s

43,088

Details

325ms

1s201ms

387ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 07	00	525	3m5s	352ms
	01	128	50s42ms	390ms
	02	143	57s799ms	404ms
	03	127	52s200ms	411ms
	04	106	42s85ms	397ms
	05	105	42s307ms	402ms
	06	209	1m14s	358ms
	07	207	1m12s	351ms
	08	1,160	6m52s	355ms
	09	3,308	20m1s	363ms
	10	4,143	26m29s	383ms
	11	4,366	27m39s	380ms
	12	3,654	23m34s	387ms
	13	3,212	20m5s	375ms
	14	3,027	18m43s	371ms
	15	2,209	13m28s	366ms
	16	3,715	23m26s	378ms
	17	3,343	22m40s	407ms
	18	2,643	18m4s	410ms
	19	2,911	20m57s	432ms
	20	1,650	11m44s	426ms
	21	1,795	12m3s	403ms
	22	402	2m37s	391ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3266981, 3266978, 3266977, 3266974, 3266972, 3266969, 3266968, 3266965, 3266962, 3266959, 3266957, 3266955, 3266952, 3266950, 3266948, 3266946, 3266945, 3266943, 3266941, 3266939, 3266938, 3266936, 3266934, 3266933, 3266931, 3266930, 3266928, 3266926, 3266925, 3266923, 3266921, 3266920, 3266918, 3266916, 3266915, 3266913, 3266911, 3266910, 3266908, 3266907, 3266905, 3266903, 3266902, 3266901, 3266899, 3266897, 3266896, 3266894, 3266892, 3266891, 3266889, 3266887, 3266886, 3266884, 3266882, 3266881, 3266879, 3266878, 3266876, 3266873, 3266870, 3266868, 3266865, 3266863, 3266859, 3266855, 3266851, 3266846, 3266841, 3266832, 3266830, 3266826, 3266823, 3266820, 3266816, 3266814, 3266810, 3266808, 3266805, 3266801, 3266799, 3266796, 3266793, 3266791, 3266788, 3266784, 3266782, 3266779, 3266777, 3266774, 3266771, 3266768, 3266766, 3266762, 3266759, 3266756, 3266753, 3266749, 3266746, 3266742, 3266737, 3265878, 3265872, 3265866, 3265817, 3265682, 3265679, 3265676, 3265673, 3265670, 3265666, 3265663, 3265661, 3265659, 3265657, 3265655, 3265653, 3265651, 3265648, 3265646, 3265644, 3265642, 3265640, 3265638, 3265636, 3265633, 3265631, 3265629, 3265627, 3265625, 3265621, 3265618, 3265615, 3265612, 3265468, 3265467, 3265466, 3265465, 3265464, 3265463, 3265462, 3265461, 3265460, 3265459, 3265458, 3265457, 3265456, 3265455, 3265454, 3265453, 3265452, 3265451, 3265450, 3265449, 3265448, 3265447, 3265446, 3265445, 3265444, 3265443, 3265442, 3265441, 3265439, 3265438, 3265437, 3265436, 3265435, 3265434, 3265433, 3265432, 3265431, 3265430, 3265429, 3265428, 3265427, 3265426, 3265425, 3265424, 3265423, 3265422, 3265420, 3265419, 3265417, 3265416, 3265415, 3265414, 3265412, 3265411, 3265410, 3265409, 3265407, 3265406, 3265405, 3265403, 3265402, 3265401, 3265399, 3265398, 3265397, 3265395, 3265394, 3265393, 3265392, 3265390, 3265388, 3265385, 3265382, 3265380, 3265377, 3265374, 3265372, 3265369, 3265367, 3265364, 3265362, 3265359, 3265356, 3265352, 3265350, 3265347, 3265343, 3265341, 3265338, 3265335, 3265333, 3265330, 3265327, 3265325, 3265322, 3265320, 3265317, 3265314, 3265312, 3265310, 3265307, 3265304, 3265301, 3265298, 3265296, 3265293, 3265290, 3265288, 3265285, 3265282, 3265280, 3265277, 3265274, 3265272, 3265269, 3265268, 3265265, 3265262, 3265259, 3265257, 3265254, 3265252, 3265249, 3265246)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 17:21:55 Duration: 1s201ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3159069)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:38 Duration: 875ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3328173, 3301677)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 20:26:06 Duration: 766ms

5

3h32m40s

53,686

Details

91ms

950ms

237ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,279	7m26s	196ms
	01	2,521	8m	190ms
	02	1,752	6m1s	206ms
	03	2,118	9m31s	269ms
	04	974	4m10s	257ms
	05	1,808	6m12s	206ms
	06	728	2m30s	206ms
	07	12	2s398ms	199ms
	08	108	16s722ms	154ms
	09	2	260ms	130ms
	10	54	12s219ms	226ms
	11	52	15s401ms	296ms
	12	396	1m35s	241ms
	13	486	1m47s	221ms
	14	688	2m31s	220ms
	15	1,370	5m7s	224ms
	16	2,598	10m40s	246ms
	17	3,771	16m2s	255ms
	18	8,568	35m21s	247ms
	19	6,815	31m24s	276ms
	20	6,396	25m54s	243ms
	21	5,856	23m7s	236ms
	22	4,334	14m25s	199ms

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-07 18:09:52 Duration: 950ms
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-07 18:09:52 Duration: 950ms
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-07 18:46:37 Duration: 880ms

6

3h16m4s

12,242

Details

223ms

1s804ms

960ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 07	00	638	10m12s	960ms
	01	499	7m54s	951ms
	02	155	2m27s	953ms
	08	2	1s918ms	959ms
	10	6	6s11ms	1s1ms
	11	17	20s934ms	1s231ms
	12	133	2m20s	1s54ms
	13	78	1m20s	1s38ms
	14	140	2m21s	1s7ms
	15	447	7m18s	981ms
	16	936	16m2s	1s28ms
	17	600	10m13s	1s22ms
	18	2,243	35m38s	953ms
	19	1,578	28m6s	1s68ms
	20	1,575	25m20s	965ms
	21	1,365	22m9s	973ms
	22	1,830	24m9s	792ms

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

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

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

Date: 2024-12-07 19:18:28 Duration: 1s610ms

7

1h19m39s

134,841

Details

27ms

94ms

35ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,028	1m8s	33ms
	01	2,408	1m20s	33ms
	02	1,702	57s316ms	33ms
	03	1,659	55s793ms	33ms
	04	1,026	35s48ms	34ms
	05	903	30s26ms	33ms
	06	765	25s674ms	33ms
	07	519	17s349ms	33ms
	08	2,636	1m28s	33ms
	09	6,939	4m	34ms
	10	15,019	8m58s	35ms
	11	13,297	7m53s	35ms
	12	13,116	7m52s	36ms
	13	8,893	5m11s	34ms
	14	8,278	4m48s	34ms
	15	6,115	3m31s	34ms
	16	7,214	4m18s	35ms
	17	7,192	4m20s	36ms
	18	10,027	5m58s	35ms
	19	9,126	5m41s	37ms
	20	6,318	3m51s	36ms
	21	6,764	3m56s	35ms
	22	2,897	1m38s	33ms

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

Date: 2024-12-07 17:22:02 Duration: 94ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3219807)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 19:19:38 Duration: 84ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2962165)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 12:58:34 Duration: 72ms

8

1h15m6s

15,018

Details

213ms

528ms

300ms

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 07	00	512	2m24s	281ms
	01	771	3m35s	279ms
	02	735	3m27s	282ms
	03	1,126	5m25s	288ms
	04	521	2m28s	285ms
	05	909	4m15s	281ms
	06	367	1m40s	272ms
	07	6	1s675ms	279ms
	08	52	15s51ms	289ms
	09	1	337ms	337ms
	10	21	6s554ms	312ms
	11	9	2s938ms	326ms
	12	95	27s915ms	293ms
	13	170	51s795ms	304ms
	14	210	1m2s	297ms
	15	251	1m14s	296ms
	16	375	1m57s	313ms
	17	1,320	6m44s	306ms
	18	2,071	10m34s	306ms
	19	1,858	10m5s	325ms
	20	1,655	8m43s	316ms
	21	1,605	7m56s	296ms
	22	378	1m42s	271ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9280777')) 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-07 17:21:57 Duration: 528ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9041574')) 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-07 20:26:08 Duration: 504ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9113780')) 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-07 19:14:00 Duration: 503ms

9

1h1m3s

14,708

Details

187ms

382ms

249ms

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 07	08	713	2m49s	237ms
	09	1,547	6m16s	243ms
	10	1,523	6m36s	260ms
	11	936	3m56s	252ms
	12	2,200	9m20s	254ms
	13	2,161	8m54s	247ms
	14	1,576	6m26s	245ms
	15	1,947	7m54s	243ms
	16	826	3m24s	247ms
	17	957	4m5s	256ms
	18	322	1m18s	244ms

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

Date: 2024-12-07 10:52:56 Duration: 382ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9130839')))) ORDER BY "collection_policy"."id";

Date: 2024-12-07 10:52:56 Duration: 355ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9130653')))) ORDER BY "collection_policy"."id";

Date: 2024-12-07 10:51:34 Duration: 351ms

10

57m45s

97

Details

0ms

24m28s

35s730ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 07	19	26	46ms	1ms
	20	41	57m45s	1m24s
	21	20	23ms	1ms
	22	10	14ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-07 20:18:51.874895', "last_update" = '2024-12-07 19:33:51.874920', "logged_in" = true, "sid" = 'a7291f598aeda37ad01b47e62891f15863374183', "write_date" = '2024-12-07 19:33:51.537018', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 24m28s
UPDATE "res_users" SET "exp_date" = '2024-12-07 20:30:40.257201', "last_update" = '2024-12-07 19:45:40.257223', "logged_in" = true, "sid" = 'c84c324ed00819e929f25faba3943d797e9f08d5', "write_date" = '2024-12-07 19:45:39.915384', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 12m40s
UPDATE "res_users" SET "exp_date" = '2024-12-07 20:35:29.863763', "last_update" = '2024-12-07 19:50:29.863789', "logged_in" = true, "sid" = '1d730bebbc756664b57081a48ac0b183ea47b934', "write_date" = '2024-12-07 19:50:29.521539', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 7m50s

11

26m47s

18,903

Details

69ms

146ms

85ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	105	8s413ms	80ms
	01	45	3s490ms	77ms
	06	59	4s623ms	78ms
	08	213	17s668ms	82ms
	09	669	57s166ms	85ms
	10	1,641	2m21s	86ms
	11	1,907	2m40s	84ms
	12	1,925	2m42s	84ms
	13	2,082	2m51s	82ms
	14	2,239	3m6s	83ms
	15	1,735	2m22s	81ms
	16	1,564	2m13s	85ms
	17	836	1m15s	90ms
	18	1,133	1m37s	86ms
	19	887	1m23s	94ms
	20	745	1m6s	89ms
	21	1,000	1m24s	84ms
	22	118	9s760ms	82ms

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

Date: 2024-12-07 18:46:24 Duration: 146ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7777901)) AND (("cash_track"."id" not in (5424895)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-07 19:50:08 Duration: 134ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7777374)) AND (("cash_track"."id" not in (5423124)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-07 18:46:26 Duration: 132ms

12

24m48s

7,288

Details

174ms

274ms

204ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 07	00	54	10s707ms	198ms
	01	272	53s873ms	198ms
	02	9	1s757ms	195ms
	03	118	23s523ms	199ms
	04	391	1m17s	197ms
	05	685	2m16s	199ms
	06	135	26s908ms	199ms
	07	443	1m27s	197ms
	08	256	50s629ms	197ms
	09	1,272	4m19s	203ms
	10	765	2m41s	211ms
	11	864	3m1s	209ms
	12	530	1m52s	212ms
	13	305	1m2s	205ms
	14	322	1m6s	206ms
	15	334	1m7s	202ms
	16	89	18s435ms	207ms
	17	21	4s670ms	222ms
	18	147	30s650ms	208ms
	20	68	13s105ms	192ms
	21	175	33s968ms	194ms
	22	33	6s289ms	190ms

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

Date: 2024-12-07 12:36:04 Duration: 274ms
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" = '9252501')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-07 11:52:10 Duration: 270ms
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" = '9115890')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-07 11:52:11 Duration: 269ms

13

23m3s

32,675

Details

32ms

135ms

42ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 07	00	33	1s289ms	39ms
	01	11	431ms	39ms
	02	4	162ms	40ms
	05	39	1s483ms	38ms
	06	12	472ms	39ms
	07	12	470ms	39ms
	08	1,181	45s494ms	38ms
	09	3,171	2m5s	39ms
	10	3,142	2m10s	41ms
	11	1,762	1m12s	41ms
	12	4,214	2m57s	42ms
	13	2,834	1m54s	40ms
	14	4,277	2m54s	40ms
	15	3,519	2m22s	40ms
	16	2,177	1m29s	41ms
	17	2,599	1m59s	46ms
	18	2,255	1m55s	51ms
	19	652	34s565ms	53ms
	20	419	20s946ms	49ms
	21	275	13s127ms	47ms
	22	87	3s993ms	45ms

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

Date: 2024-12-07 17:21:55 Duration: 135ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3324500) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-07 19:17:24 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3302816) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-07 19:17:41 Duration: 84ms

14

17m58s

5,450

Details

176ms

233ms

197ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 07	00	484	1m35s	197ms
	01	665	2m10s	196ms
	02	1,104	3m38s	197ms
	03	1,029	3m25s	199ms
	04	910	3m	198ms
	05	1,026	3m23s	198ms
	06	22	4s361ms	198ms
	21	2	390ms	195ms
	22	208	39s400ms	189ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9248584')) 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-07 03:22:17 Duration: 233ms
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" = '9098603')) 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-07 03:21:43 Duration: 233ms
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" = '9257172')) 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-07 03:21:36 Duration: 232ms

15

15m40s

335

Details

335ms

4s705ms

2s806ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	3	9s521ms	3s173ms
	09	12	42s412ms	3s534ms
	10	15	57s441ms	3s829ms
	11	11	40s478ms	3s679ms
	12	11	45s70ms	4s97ms
	13	24	1m23s	3s476ms
	14	26	1m32s	3s561ms
	15	18	1m	3s361ms
	16	47	1m45s	2s246ms
	17	52	2m33s	2s943ms
	18	30	45s177ms	1s505ms
	19	27	46s669ms	1s728ms
	20	17	32s994ms	1s940ms
	21	38	1m52s	2s957ms
	22	4	12s641ms	3s160ms

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

Date: 2024-12-07 12:01:55 Duration: 4s705ms
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 (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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) 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"."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)))))))) AND ("policy_number"."name"::text ilike '%925869%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-07 12:01:53 Duration: 4s614ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-07 17:13:54 Duration: 4s610ms

16

13m51s

5,914

Details

120ms

249ms

140ms

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 07	00	38	4s977ms	130ms
	01	1	129ms	129ms
	06	6	774ms	129ms
	07	2	263ms	131ms
	08	60	7s913ms	131ms
	09	220	29s902ms	135ms
	10	1,117	2m39s	142ms
	11	1,015	2m22s	140ms
	12	1,032	2m25s	141ms
	13	696	1m36s	138ms
	14	393	54s318ms	138ms
	15	165	22s326ms	135ms
	16	175	25s299ms	144ms
	17	678	1m36s	142ms
	18	83	11s358ms	136ms
	19	64	9s705ms	151ms
	20	85	12s416ms	146ms
	21	54	7s163ms	132ms
	22	30	4s18ms	133ms

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

Date: 2024-12-07 10:52:56 Duration: 249ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 115)) 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-07 17:22:12 Duration: 224ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 44)) 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-07 20:32:57 Duration: 195ms

17

8m46s

2,640

Details

15ms

620ms

199ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 07	00	5	970ms	194ms
	01	1	18ms	18ms
	03	1	297ms	297ms
	06	8	2s149ms	268ms
	07	5	684ms	136ms
	08	61	6s88ms	99ms
	09	99	16s253ms	164ms
	10	223	38s431ms	172ms
	11	277	52s419ms	189ms
	12	306	56s210ms	183ms
	13	325	1m3s	195ms
	14	305	1m6s	217ms
	15	284	56s202ms	197ms
	16	172	36s815ms	214ms
	17	163	37s549ms	230ms
	18	174	33s549ms	192ms
	19	88	23s563ms	267ms
	20	80	20s895ms	261ms
	21	47	12s692ms	270ms
	22	16	1s686ms	105ms

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

Date: 2024-12-07 19:14:02 Duration: 620ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-07 20:25:46 Duration: 528ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-07 19:15:11 Duration: 513ms

18

7m32s

12,250

Details

29ms

62ms

36ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 07	08	623	22s39ms	35ms
	09	1,236	44s92ms	35ms
	10	1,185	44s28ms	37ms
	11	877	32s368ms	36ms
	12	1,475	54s356ms	36ms
	13	1,647	59s667ms	36ms
	14	1,515	54s987ms	36ms
	15	1,673	1m	36ms
	16	806	29s771ms	36ms
	17	895	37s158ms	41ms
	18	318	13s397ms	42ms

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

Date: 2024-12-07 12:27:17 Duration: 62ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3114057) ORDER BY "collection_policy"."id";

Date: 2024-12-07 17:47:14 Duration: 59ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3052707) ORDER BY "collection_policy"."id";

Date: 2024-12-07 17:47:14 Duration: 59ms

19

6m48s

2,701

Details

131ms

272ms

151ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and (("res_partner"."type_employee" = ?) and ("res_partner"."type_driver" = ?))) 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 limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 07	00	41	5s805ms	141ms
	01	66	9s383ms	142ms
	02	97	13s783ms	142ms
	03	84	11s973ms	142ms
	04	71	10s157ms	143ms
	05	89	12s622ms	141ms
	06	52	7s351ms	141ms
	07	16	2s246ms	140ms
	08	40	5s737ms	143ms
	09	70	10s195ms	145ms
	10	174	27s391ms	157ms
	11	232	35s560ms	153ms
	12	209	32s660ms	156ms
	13	203	30s363ms	149ms
	14	174	25s901ms	148ms
	15	143	20s935ms	146ms
	16	144	22s32ms	153ms
	17	167	26s425ms	158ms
	18	214	32s775ms	153ms
	19	147	24s523ms	166ms
	20	112	17s886ms	159ms
	21	126	18s615ms	147ms
	22	30	4s357ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:19:34 Duration: 272ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:17:19 Duration: 252ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:19:21 Duration: 242ms

20

6m28s

2,726

Details

123ms

254ms

142ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 07	00	120	16s301ms	135ms
	01	120	16s345ms	136ms
	02	120	16s306ms	135ms
	03	120	16s396ms	136ms
	04	120	16s343ms	136ms
	05	120	16s233ms	135ms
	06	120	16s210ms	135ms
	07	120	16s225ms	135ms
	08	120	16s419ms	136ms
	09	120	16s820ms	140ms
	10	120	17s738ms	147ms
	11	120	17s625ms	146ms
	12	120	17s684ms	147ms
	13	120	17s265ms	143ms
	14	120	16s985ms	141ms
	15	120	16s890ms	140ms
	16	120	17s231ms	143ms
	17	116	17s498ms	150ms
	18	120	17s890ms	149ms
	19	120	19s283ms	160ms
	20	120	18s566ms	154ms
	21	120	17s600ms	146ms
	22	90	12s880ms	143ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:16:01 Duration: 254ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:14:01 Duration: 251ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:14:01 Duration: 248ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,317,433

Details

2m2s

0ms

2ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 07	00	33,030	1s556ms	0ms
	01	31,445	1s476ms	0ms
	02	34,505	1s646ms	0ms
	03	32,244	1s543ms	0ms
	04	28,308	1s324ms	0ms
	05	24,584	1s186ms	0ms
	06	22,107	986ms	0ms
	07	22,244	1s7ms	0ms
	08	61,702	3s14ms	0ms
	09	131,878	7s84ms	0ms
	10	192,112	10s977ms	0ms
	11	201,926	11s633ms	0ms
	12	202,122	11s736ms	0ms
	13	190,254	10s850ms	0ms
	14	183,028	10s277ms	0ms
	15	163,874	7s506ms	0ms
	16	164,944	7s937ms	0ms
	17	143,658	7s626ms	0ms
	18	134,948	6s443ms	0ms
	19	117,817	5s895ms	0ms
	20	93,541	5s133ms	0ms
	21	75,587	3s919ms	0ms
	22	31,575	1s372ms	0ms

DISCARD ALL;

Date: 2024-12-07 09:36:35 Duration: 2ms
DISCARD ALL;

Date: 2024-12-07 11:57:17 Duration: 1ms
DISCARD ALL;

Date: 2024-12-07 12:42:08 Duration: 1ms

2

1,766,333

Details

25s124ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 07	00	21,570	293ms	0ms
	01	20,323	279ms	0ms
	02	22,925	312ms	0ms
	03	21,683	296ms	0ms
	04	18,292	243ms	0ms
	05	15,815	222ms	0ms
	06	15,482	200ms	0ms
	07	15,148	195ms	0ms
	08	46,198	607ms	0ms
	09	102,434	1s410ms	0ms
	10	154,418	2s181ms	0ms
	11	159,128	2s212ms	0ms
	12	157,612	2s219ms	0ms
	13	144,997	1s981ms	0ms
	14	137,771	1s889ms	0ms
	15	121,721	1s568ms	0ms
	16	125,530	1s704ms	0ms
	17	111,826	1s698ms	0ms
	18	105,308	1s516ms	0ms
	19	91,617	1s512ms	0ms
	20	73,828	1s264ms	0ms
	21	57,717	933ms	0ms
	22	24,990	377ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-07 12:24:11 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-07 12:41:24 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-07 17:18:11 Duration: 1ms

3

1,172,671

Details

11s523ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 07	00	16,760	145ms	0ms
	01	15,961	137ms	0ms
	02	17,506	150ms	0ms
	03	16,385	152ms	0ms
	04	14,373	125ms	0ms
	05	12,497	108ms	0ms
	06	11,327	93ms	0ms
	07	11,358	92ms	0ms
	08	31,299	270ms	0ms
	09	66,529	625ms	0ms
	10	96,602	963ms	0ms
	11	101,568	1s18ms	0ms
	12	101,870	1s25ms	0ms
	13	95,698	935ms	0ms
	14	92,177	887ms	0ms
	15	82,409	727ms	0ms
	16	83,036	769ms	0ms
	17	72,245	732ms	0ms
	18	67,976	714ms	0ms
	19	60,613	712ms	0ms
	20	48,928	562ms	0ms
	21	38,841	406ms	0ms
	22	16,713	165ms	0ms

ROLLBACK;

Date: 2024-12-07 11:36:37 Duration: 1ms
ROLLBACK;

Date: 2024-12-07 16:27:35 Duration: 0ms
ROLLBACK;

Date: 2024-12-07 09:30:54 Duration: 0ms

4

1,161,004

Details

3m6s

0ms

16ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 07	00	16,308	2s311ms	0ms
	01	15,502	2s226ms	0ms
	02	17,013	2s463ms	0ms
	03	15,880	2s283ms	0ms
	04	13,914	1s894ms	0ms
	05	12,051	1s767ms	0ms
	06	10,888	1s367ms	0ms
	07	10,916	1s311ms	0ms
	08	30,731	4s162ms	0ms
	09	66,431	9s850ms	0ms
	10	96,617	15s39ms	0ms
	11	101,676	15s437ms	0ms
	12	101,692	15s400ms	0ms
	13	95,711	13s796ms	0ms
	14	92,094	13s121ms	0ms
	15	82,347	12s163ms	0ms
	16	82,742	12s853ms	0ms
	17	72,234	13s442ms	0ms
	18	67,451	13s205ms	0ms
	19	58,576	12s368ms	0ms
	20	46,422	9s724ms	0ms
	21	37,638	7s464ms	0ms
	22	16,170	2s960ms	0ms

SELECT payload FROM http_sessions WHERE sid = '1224319e9888aabb2e1d8127fccd5b313fd8fe7b';

Date: 2024-12-07 20:44:47 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '083a019a4156b8b546c096af06a0650d0de541f3';

Date: 2024-12-07 10:58:10 Duration: 13ms
SELECT payload FROM http_sessions WHERE sid = '25d22730833fcddeb23b4605dfb68c67a7e8f898';

Date: 2024-12-07 17:21:53 Duration: 10ms

5

1,155,150

Details

1m40s

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 07	00	16,445	1s314ms	0ms
	01	15,650	1s259ms	0ms
	02	17,180	1s380ms	0ms
	03	16,058	1s298ms	0ms
	04	14,098	1s109ms	0ms
	05	12,229	1s2ms	0ms
	06	10,981	820ms	0ms
	07	11,047	838ms	0ms
	08	30,697	2s410ms	0ms
	09	65,761	5s493ms	0ms
	10	95,898	8s326ms	0ms
	11	100,785	8s648ms	0ms
	12	100,860	8s661ms	0ms
	13	94,960	7s908ms	0ms
	14	91,330	7s531ms	0ms
	15	81,787	6s737ms	0ms
	16	82,331	7s48ms	0ms
	17	71,687	6s781ms	0ms
	18	67,322	6s436ms	0ms
	19	58,481	5s767ms	0ms
	20	46,204	4s477ms	0ms
	21	37,536	3s538ms	0ms
	22	15,823	1s469ms	0ms

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

Date: 2024-12-07 14:20:02 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-07 20:12:14 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-07 12:03:07 Duration: 1ms

6

593,490

Details

1m28s

0ms

34ms

0ms

commit;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 07	00	4,811	893ms	0ms
	01	4,364	923ms	0ms
	02	5,418	962ms	0ms
	03	5,298	961ms	0ms
	04	3,920	761ms	0ms
	05	3,318	750ms	0ms
	06	4,155	571ms	0ms
	07	3,790	452ms	0ms
	08	14,897	1s829ms	0ms
	09	35,907	4s583ms	0ms
	10	57,812	8s351ms	0ms
	11	57,563	8s135ms	0ms
	12	55,742	8s14ms	0ms
	13	49,298	6s679ms	0ms
	14	45,594	6s184ms	0ms
	15	39,313	5s84ms	0ms
	16	42,480	5s692ms	0ms
	17	39,576	5s965ms	0ms
	18	37,312	5s454ms	0ms
	19	30,937	5s889ms	0ms
	20	24,871	5s86ms	0ms
	21	18,868	3s754ms	0ms
	22	8,246	1s362ms	0ms

COMMIT;

Date: 2024-12-07 16:52:27 Duration: 34ms
COMMIT;

Date: 2024-12-07 09:35:26 Duration: 30ms
COMMIT;

Date: 2024-12-07 10:07:12 Duration: 29ms

7

511,131

Details

1m11s

0ms

16ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	5,085	588ms	0ms
	01	4,491	543ms	0ms
	02	5,084	623ms	0ms
	03	5,604	718ms	0ms
	04	3,427	425ms	0ms
	05	2,475	296ms	0ms
	06	2,653	293ms	0ms
	07	2,446	333ms	0ms
	08	11,328	1s502ms	0ms
	09	31,387	4s845ms	0ms
	10	51,434	8s523ms	0ms
	11	51,553	7s900ms	0ms
	12	49,059	7s254ms	0ms
	13	41,112	5s587ms	0ms
	14	37,385	5s9ms	0ms
	15	31,333	4s87ms	0ms
	16	35,271	4s550ms	0ms
	17	34,544	4s883ms	0ms
	18	34,059	4s546ms	0ms
	19	25,039	3s357ms	0ms
	20	22,197	3s11ms	0ms
	21	16,299	1s914ms	0ms
	22	7,866	869ms	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 (5099244, 5416991, 5101199, 5100850, 5099186, 5101444, 5311173, 5416990, 5104556, 5099585, 5099010, 5099921, 5100857, 5235666, 5099788, 5099446, 5099311, 5100762, 5100004, 5099641, 5099129, 5099008, 5099181, 5100729, 5126401, 5099088, 5103853, 5099120, 5099169, 5099035, 5103711, 5101193, 5099590, 5103223, 5099309, 5099296, 5099177, 5099644, 5099920, 5099413, 5104084, 5099119, 5099873, 5101653, 5100785, 5103778, 5101313, 5099924, 5100482, 5099248, 5099162, 5099095);

Date: 2024-12-07 19:12:24 Duration: 16ms
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 (5410118, 5155836, 5299059, 5410289, 5234832, 5398026, 5179973, 5196281, 5194153, 5412653, 5412902, 5161300, 5265190, 5157306, 5340766, 5306925, 5215816, 5403037, 5411108, 5158356, 5413023, 5413382, 5411090, 5413214, 5411170, 5297626, 5141013, 5413332, 5181983, 5195057, 5372418, 5372417, 5409194, 5326485, 5224948, 5379170, 5405920, 5413726, 5400033, 5414679, 5234315, 5270079, 5163412, 5210060, 5349716, 5164867, 5412014, 5373241, 5412885, 5193920, 5183366, 5259556, 5258400, 5176168, 5414667, 5319689, 5411802, 5138720, 5181839, 5206955, 5247982, 5256338, 5250254, 5413090, 5410909, 5180910, 5389309, 5198278, 5410493, 5412856, 5181540, 5248520, 5374362, 5271898, 5348498, 5413164, 5410048, 5153493, 5405832, 5158209, 5411435, 5227094, 5411481, 5209161, 5161370, 5221194, 5411393, 5137949, 5407863, 5401086, 5262255, 5352619, 5167761, 5295741, 5403810, 5407812, 5178897, 5183398, 5294841, 5378998, 5412020, 5323671, 5148612, 5413946, 5208599, 5164455, 5411914, 5217267, 5213759, 5410953, 5198401, 5208722, 5410521, 5209125, 5354545, 5410975, 5164802, 5344112, 5413188, 5178707, 5311366, 5176228, 5233372, 5400079, 5412123, 5412766, 5412549, 5168364, 5412133, 5411310, 5411309, 5188381, 5400397, 5412385, 5413158, 5146697, 5173700, 5257146, 5414508, 5288643, 5409478, 5315251, 5397381, 5179116, 5194560, 5413508, 5353449, 5378356, 5326674, 5413251, 5412386, 5309919, 5161928, 5407265, 5347479, 5233886, 5251179, 5412369, 5269886, 5413088, 5167506, 5218847, 5407113, 5225773, 5411972, 5410707, 5343377, 5169424, 5164711, 5400476, 5307391, 5314383, 5174771, 5254739, 5410268, 5168334, 5193778, 5412452, 5339164, 5302519, 5410520, 5412863, 5227171, 5413162, 5287348, 5412556, 5412467, 5407471, 5197692, 5149885, 5227101, 5375921, 5410844, 5376003, 5401091, 5197778, 5412750, 5413184, 5385575, 5399603, 5160068, 5412414, 5413365, 5165619, 5360804, 5412994, 5406711, 5411606, 5288087, 5172946, 5245401, 5406160, 5334278, 5202873, 5413361, 5313828, 5413107, 5368458, 5316128, 5361742, 5284196, 5413564, 5366214, 5413222, 5412537, 5149595, 5410026, 5237515, 5407472, 5322831, 5172940, 5403945, 5201531, 5167760, 5146755, 5406444, 5414258, 5364141, 5185291, 5151966, 5193771, 5160766, 5138918, 5413918, 5414555, 5414876, 5157143, 5406810, 5162782, 5404545, 5414189, 5180304, 5258619, 5207413, 5300340, 5177739, 5330467, 5414027, 5348342, 5264734, 5144974, 5339191, 5399992, 5147221, 5171438, 5341054, 5413561, 5147499, 5337992, 5397639, 5336612, 5411994, 5148390, 5340780, 5179915, 5154691, 5414472, 5283689, 5409988, 5413667, 5406858, 5203147, 5407432, 5196311, 5209336, 5146326, 5414586, 5414917, 5380447, 5240610, 5383331, 5152012, 5411248, 5309322, 5269742, 5192236, 5165875, 5188290, 5153753, 5199603, 5236507, 5177661, 5149762, 5272476, 5197916, 5232899, 5177846, 5187751, 5297917, 5194360, 5152751, 5278694, 5202733, 5236973, 5412923, 5359622, 5403243, 5238093, 5235631, 5413886, 5137921, 5414696, 5412932, 5412857, 5413663, 5413221, 5412738, 5411742, 5191584, 5138722, 5299403, 5412541, 5399266, 5406004, 5240528, 5317898, 5408371, 5398920, 5402383, 5323337, 5396465, 5400961, 5348639, 5410435, 5361364, 5171004, 5314160, 5155401, 5398422, 5412425, 5151285, 5413613, 5360291, 5246596, 5261751, 5199868, 5412226, 5148737, 5339491, 5412717, 5412075, 5304737, 5371477, 5341068, 5278495, 5197627, 5406791, 5413101, 5185748, 5184462, 5399861, 5405048, 5256329, 5402326, 5163361, 5407215, 5400320, 5406427, 5363950, 5274954, 5413930, 5269277, 5414994, 5231624, 5300491, 5250027, 5378148, 5415634, 5386476, 5280642, 5398474, 5157759, 5402519, 5201281, 5398533, 5410962, 5411570, 5409808, 5414369, 5415646, 5275403, 5221401, 5372565, 5370132, 5197388, 5180898, 5407510, 5290581, 5404297, 5410028, 5405281, 5211913, 5209179, 5282039, 5293627, 5168345, 5172985, 5250421, 5392408, 5201924, 5413374, 5400210, 5207022, 5413456, 5373892, 5281932, 5410964, 5378058, 5405873, 5405874, 5406391, 5415478, 5287740, 5413333, 5407945, 5139368, 5278675, 5330069, 5150350, 5318143, 5159719, 5271212, 5409723, 5152267, 5281497, 5410197, 5164126, 5409802, 5409804, 5411714, 5156476, 5415485, 5185873, 5407536, 5273802, 5359035, 5274580, 5208004, 5410773, 5368610, 5216453, 5363119, 5283124, 5410024, 5159793, 5410936, 5234740, 5390612, 5189375, 5342001, 5298388, 5163291, 5158106, 5283201, 5253168, 5202389, 5413156, 5291796, 5406752, 5406750, 5206417, 5155921, 5411275, 5411400, 5358695, 5409268, 5335742, 5405859, 5295532, 5307255, 5176736, 5340783, 5169117, 5213330, 5410537, 5411727, 5207690, 5209079, 5363455, 5277495, 5406935, 5397564, 5234789, 5407052, 5226044, 5409841, 5168509, 5411410, 5160845, 5263183, 5157253, 5412912, 5244767, 5195529, 5412313, 5406112, 5173787, 5380628, 5259729, 5173936, 5173042, 5404585, 5378688, 5182350, 5355351, 5408866, 5408865, 5394763, 5412585, 5274983, 5403758, 5248251, 5410808, 5159924, 5412326, 5406111, 5412029, 5281780, 5413210, 5192208, 5343728, 5318080, 5219561, 5411071, 5411269, 5410053, 5410051, 5154529, 5412533, 5412474, 5391284, 5412468, 5201538, 5405245, 5406666, 5409020, 5399879, 5407014, 5411256, 5251206, 5412224, 5413025, 5147315, 5241441, 5364634, 5159389, 5382751, 5401366, 5187174, 5222734, 5276024, 5407492, 5228958, 5275831, 5401563, 5415297, 5231893, 5411954, 5161551, 5409662, 5410628, 5412239, 5403985, 5414015, 5198131, 5191684, 5198121, 5165098, 5397383, 5275104, 5412017, 5203921, 5413489, 5412654, 5410566, 5411284, 5398736, 5413119, 5166323, 5239629, 5400855, 5413300, 5407025, 5324843, 5277439, 5413604, 5144954, 5228648, 5215315, 5413099, 5407980, 5194150, 5265728, 5408286, 5410080, 5410284, 5411049, 5413466, 5401132, 5148282, 5413204, 5162203, 5402296, 5170268, 5308561, 5347976, 5293512, 5201599, 5413303, 5391935, 5221659, 5412787, 5312897, 5210796, 5209304, 5237895, 5153157, 5220682, 5145492, 5397252, 5162588, 5268723, 5204420, 5413305, 5413297, 5183213, 5415583, 5290745, 5413265, 5410681, 5412589, 5303429, 5217628, 5412964, 5142318, 5165704, 5229910, 5408483, 5144655, 5269877, 5153011, 5355877, 5219434, 5323529, 5353092, 5277698, 5413104, 5255517, 5410526, 5227017, 5410717, 5409712, 5405717, 5410777, 5413098, 5412234, 5410697, 5308578);

Date: 2024-12-07 10:54:02 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 (5410118, 5155836, 5299059, 5410289, 5234832, 5398026, 5179973, 5196281, 5194153, 5412653, 5412902, 5161300, 5265190, 5157306, 5340766, 5306925, 5215816, 5403037, 5411108, 5158356, 5413023, 5413382, 5411090, 5413214, 5411170, 5297626, 5141013, 5413332, 5181983, 5195057, 5372418, 5372417, 5409194, 5326485, 5224948, 5379170, 5405920, 5413726, 5400033, 5414679, 5234315, 5270079, 5163412, 5210060, 5349716, 5164867, 5412014, 5373241, 5412885, 5193920, 5183366, 5259556, 5258400, 5176168, 5414667, 5319689, 5411802, 5138720, 5181839, 5206955, 5247982, 5256338, 5250254, 5413090, 5410909, 5180910, 5389309, 5198278, 5410493, 5412856, 5181540, 5248520, 5374362, 5271898, 5348498, 5413164, 5410048, 5153493, 5405832, 5158209, 5411435, 5227094, 5411481, 5209161, 5161370, 5221194, 5411393, 5137949, 5407863, 5401086, 5262255, 5352619, 5167761, 5295741, 5403810, 5407812, 5178897, 5183398, 5294841, 5378998, 5412020, 5323671, 5148612, 5413946, 5208599, 5164455, 5411914, 5217267, 5213759, 5410953, 5198401, 5208722, 5410521, 5209125, 5354545, 5410975, 5164802, 5344112, 5413188, 5178707, 5311366, 5176228, 5233372, 5400079, 5412123, 5412766, 5412549, 5168364, 5412133, 5411310, 5411309, 5188381, 5400397, 5412385, 5413158, 5146697, 5173700, 5257146, 5414508, 5288643, 5409478, 5315251, 5397381, 5179116, 5194560, 5413508, 5353449, 5378356, 5326674, 5413251, 5412386, 5309919, 5161928, 5407265, 5347479, 5233886, 5251179, 5412369, 5269886, 5413088, 5167506, 5218847, 5407113, 5225773, 5411972, 5410707, 5343377, 5169424, 5164711, 5400476, 5307391, 5314383, 5174771, 5254739, 5410268, 5168334, 5193778, 5412452, 5339164, 5302519, 5410520, 5412863, 5227171, 5413162, 5287348, 5412556, 5412467, 5407471, 5197692, 5149885, 5227101, 5375921, 5410844, 5376003, 5401091, 5197778, 5412750, 5413184, 5385575, 5399603, 5160068, 5412414, 5413365, 5165619, 5360804, 5412994, 5406711, 5411606, 5288087, 5172946, 5245401, 5406160, 5334278, 5202873, 5413361, 5313828, 5413107, 5368458, 5316128, 5361742, 5284196, 5413564, 5366214, 5413222, 5412537, 5149595, 5410026, 5237515, 5407472, 5322831, 5172940, 5403945, 5201531, 5167760, 5146755, 5406444, 5414258, 5364141, 5185291, 5151966, 5193771, 5160766, 5138918, 5413918, 5414555, 5414876, 5157143, 5406810, 5162782, 5404545, 5414189, 5180304, 5258619, 5207413, 5300340, 5177739, 5330467, 5414027, 5348342, 5264734, 5144974, 5339191, 5399992, 5147221, 5171438, 5341054, 5413561, 5147499, 5337992, 5397639, 5336612, 5411994, 5148390, 5340780, 5179915, 5154691, 5414472, 5283689, 5409988, 5413667, 5406858, 5203147, 5407432, 5196311, 5209336, 5146326, 5414586, 5414917, 5380447, 5240610, 5383331, 5152012, 5411248, 5309322, 5269742, 5192236, 5165875, 5188290, 5153753, 5199603, 5236507, 5177661, 5149762, 5272476, 5197916, 5232899, 5177846, 5187751, 5297917, 5194360, 5152751, 5278694, 5202733, 5236973, 5412923, 5359622, 5403243, 5238093, 5235631, 5413886, 5137921, 5414696, 5412932, 5412857, 5413663, 5413221, 5412738, 5411742, 5191584, 5138722, 5299403, 5412541, 5399266, 5406004, 5240528, 5317898, 5408371, 5398920, 5402383, 5323337, 5396465, 5400961, 5348639, 5410435, 5361364, 5171004, 5314160, 5155401, 5398422, 5412425, 5151285, 5413613, 5360291, 5246596, 5261751, 5199868, 5412226, 5148737, 5339491, 5412717, 5412075, 5304737, 5371477, 5341068, 5278495, 5197627, 5406791, 5413101, 5185748, 5184462, 5399861, 5405048, 5256329, 5402326, 5163361, 5407215, 5400320, 5406427, 5363950, 5274954, 5413930, 5269277, 5414994, 5231624, 5300491, 5250027, 5378148, 5415634, 5386476, 5280642, 5398474, 5157759, 5402519, 5201281, 5398533, 5410962, 5411570, 5409808, 5414369, 5415646, 5275403, 5221401, 5372565, 5370132, 5197388, 5180898, 5407510, 5290581, 5404297, 5410028, 5405281, 5211913, 5209179, 5282039, 5293627, 5168345, 5172985, 5250421, 5392408, 5201924, 5413374, 5400210, 5207022, 5413456, 5373892, 5281932, 5410964, 5378058, 5405873, 5405874, 5406391, 5415478, 5287740, 5413333, 5407945, 5139368, 5278675, 5330069, 5150350, 5318143, 5159719, 5271212, 5409723, 5152267, 5281497, 5410197, 5164126, 5409802, 5409804, 5411714, 5156476, 5415485, 5185873, 5407536, 5273802, 5359035, 5274580, 5208004, 5410773, 5368610, 5216453, 5363119, 5283124, 5410024, 5159793, 5410936, 5234740, 5390612, 5189375, 5342001, 5298388, 5163291, 5158106, 5283201, 5253168, 5202389, 5413156, 5291796, 5406752, 5406750, 5206417, 5155921, 5411275, 5411400, 5358695, 5409268, 5335742, 5405859, 5295532, 5307255, 5176736, 5340783, 5169117, 5213330, 5410537, 5411727, 5207690, 5209079, 5363455, 5277495, 5406935, 5397564, 5234789, 5407052, 5226044, 5409841, 5168509, 5411410, 5160845, 5263183, 5157253, 5412912, 5244767, 5195529, 5412313, 5406112, 5173787, 5380628, 5259729, 5173936, 5173042, 5404585, 5378688, 5182350, 5355351, 5408866, 5408865, 5394763, 5412585, 5274983, 5403758, 5248251, 5410808, 5159924, 5412326, 5406111, 5412029, 5281780, 5413210, 5192208, 5343728, 5318080, 5219561, 5411071, 5411269, 5410053, 5410051, 5154529, 5412533, 5412474, 5391284, 5412468, 5201538, 5405245, 5406666, 5409020, 5399879, 5407014, 5411256, 5251206, 5412224, 5413025, 5147315, 5241441, 5364634, 5159389, 5382751, 5401366, 5187174, 5222734, 5276024, 5407492, 5228958, 5275831, 5401563, 5415297, 5231893, 5411954, 5161551, 5409662, 5410628, 5412239, 5403985, 5414015, 5198131, 5191684, 5198121, 5165098, 5397383, 5275104, 5412017, 5203921, 5413489, 5412654, 5410566, 5411284, 5398736, 5413119, 5166323, 5239629, 5400855, 5413300, 5407025, 5324843, 5277439, 5413604, 5144954, 5228648, 5215315, 5413099, 5407980, 5194150, 5265728, 5408286, 5410080, 5410284, 5411049, 5413466, 5401132, 5148282, 5413204, 5162203, 5402296, 5170268, 5308561, 5347976, 5293512, 5201599, 5413303, 5391935, 5221659, 5412787, 5312897, 5210796, 5209304, 5237895, 5153157, 5220682, 5145492, 5397252, 5162588, 5268723, 5204420, 5413305, 5413297, 5183213, 5415583, 5290745, 5413265, 5410681, 5412589, 5303429, 5217628, 5412964, 5142318, 5165704, 5229910, 5408483, 5144655, 5269877, 5153011, 5355877, 5219434, 5323529, 5353092, 5277698, 5413104, 5255517, 5410526, 5227017, 5410717, 5409712, 5405717, 5410777, 5413098, 5412234, 5410697, 5308578);

Date: 2024-12-07 10:54:11 Duration: 3ms

8

502,113

Details

29s182ms

0ms

14ms

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 07	00	4,391	230ms	0ms
	01	3,346	200ms	0ms
	02	3,741	200ms	0ms
	03	3,853	199ms	0ms
	04	2,627	141ms	0ms
	05	1,888	112ms	0ms
	06	3,421	160ms	0ms
	07	3,014	135ms	0ms
	08	11,540	580ms	0ms
	09	30,547	1s669ms	0ms
	10	48,635	2s895ms	0ms
	11	49,377	2s806ms	0ms
	12	46,255	2s651ms	0ms
	13	41,257	2s226ms	0ms
	14	37,820	2s14ms	0ms
	15	33,075	1s796ms	0ms
	16	37,457	2s165ms	0ms
	17	35,104	2s187ms	0ms
	18	34,232	2s175ms	0ms
	19	26,636	1s855ms	0ms
	20	20,324	1s372ms	0ms
	21	16,756	1s23ms	0ms
	22	6,817	379ms	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 (48, 49, 52, 70, 64, 7, 60, 67, 46, 17, 61, 40, 41, 79, 11, 4, 71, 22, 24, 27, 1, 39, 10, 8, 36, 32, 26, 16, 28, 13, 30, 123, 19, 35, 53, 6);

Date: 2024-12-07 11:32:44 Duration: 14ms
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, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112, 12);

Date: 2024-12-07 17:21:54 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112, 12);

Date: 2024-12-07 17:21:54 Duration: 0ms

9

344,534

Details

1m

0ms

12ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,295	387ms	0ms
	01	1,893	332ms	0ms
	02	2,266	396ms	0ms
	03	2,272	398ms	0ms
	04	1,628	287ms	0ms
	05	1,213	203ms	0ms
	06	2,268	343ms	0ms
	07	2,226	339ms	0ms
	08	9,499	1s437ms	0ms
	09	23,165	3s724ms	0ms
	10	34,328	6s119ms	0ms
	11	32,897	5s882ms	0ms
	12	33,978	5s928ms	0ms
	13	28,962	4s953ms	0ms
	14	27,880	4s650ms	0ms
	15	24,402	4s5ms	0ms
	16	25,667	4s477ms	0ms
	17	23,203	4s382ms	0ms
	18	20,687	3s967ms	0ms
	19	17,131	3s499ms	0ms
	20	12,776	2s525ms	0ms
	21	9,754	1s784ms	0ms
	22	4,144	786ms	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 (2);

Date: 2024-12-07 17:21:54 Duration: 12ms
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 (8006288);

Date: 2024-12-07 17:21:54 Duration: 4ms
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 (8006541);

Date: 2024-12-07 17:21:54 Duration: 4ms

10

260,561

Details

1m27s

0ms

5ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,465	775ms	0ms
	01	1,931	628ms	0ms
	02	1,897	622ms	0ms
	03	1,403	443ms	0ms
	04	950	317ms	0ms
	05	774	266ms	0ms
	06	1,704	534ms	0ms
	07	1,637	489ms	0ms
	08	7,230	2s243ms	0ms
	09	15,116	4s988ms	0ms
	10	24,464	8s473ms	0ms
	11	16,958	5s889ms	0ms
	12	13,140	4s594ms	0ms
	13	12,273	4s194ms	0ms
	14	12,212	4s114ms	0ms
	15	21,562	6s952ms	0ms
	16	21,125	7s84ms	0ms
	17	24,135	8s374ms	0ms
	18	25,521	8s511ms	0ms
	19	22,002	7s598ms	0ms
	20	14,909	4s961ms	0ms
	21	13,038	4s59ms	0ms
	22	4,115	1s233ms	0ms

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

Date: 2024-12-07 12:01:53 Duration: 5ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'mail.activity' 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 = 906) OR r.global) ORDER BY r.id;

Date: 2024-12-07 12:01:53 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.partner' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 906) OR r.global) ORDER BY r.id;

Date: 2024-12-07 12:01:53 Duration: 4ms

11

243,876

Details

3m8s

0ms

14s792ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,030	136ms	0ms
	01	1,665	119ms	0ms
	02	2,108	141ms	0ms
	03	2,049	138ms	0ms
	04	1,470	101ms	0ms
	05	918	63ms	0ms
	06	1,931	118ms	0ms
	07	1,952	118ms	0ms
	08	7,358	471ms	0ms
	09	17,803	1s256ms	0ms
	10	26,991	2s71ms	0ms
	11	27,034	2s3ms	0ms
	12	26,250	1s912ms	0ms
	13	23,337	1s593ms	0ms
	14	22,130	1s475ms	0ms
	15	19,486	1s264ms	0ms
	16	20,970	1s465ms	0ms
	17	19,341	1s441ms	0ms
	18	17,279	1s250ms	0ms
	19	1,774	2m51s	96ms

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"."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 (1);

Date: 2024-12-07 19:06:09 Duration: 14s792ms
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"."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 (994);

Date: 2024-12-07 19:06:09 Duration: 12s29ms
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"."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 (848, 869, 920, 861, 988, 838, 993, 837, 854);

Date: 2024-12-07 19:06:09 Duration: 11s360ms

12

237,741

Details

57s870ms

0ms

18ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,649	601ms	0ms
	01	2,359	557ms	0ms
	02	2,351	560ms	0ms
	03	2,687	657ms	0ms
	04	1,573	373ms	0ms
	05	1,440	364ms	0ms
	06	1,446	311ms	0ms
	07	1,039	268ms	0ms
	08	4,635	1s151ms	0ms
	09	12,417	3s850ms	0ms
	10	20,634	6s558ms	0ms
	11	21,347	5s581ms	0ms
	12	21,055	5s15ms	0ms
	13	18,812	3s997ms	0ms
	14	18,120	3s700ms	0ms
	15	14,871	3s66ms	0ms
	16	17,208	3s546ms	0ms
	17	15,630	3s889ms	0ms
	18	17,593	4s110ms	0ms
	19	15,116	3s652ms	0ms
	20	11,128	2s898ms	0ms
	21	9,264	2s87ms	0ms
	22	4,367	1s68ms	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 (40144841, 39878822, 39570092, 39750167, 38557925, 39423184, 39853805, 39769815, 39742445, 39791280, 39641907, 38977619, 39684909, 39684974, 39668685, 39684886, 39742084, 39665142, 39741853, 40246284, 39956348, 39856944, 40246250, 40861792, 39417115, 39641987, 40012072, 37644384, 39613497, 39931878, 32589166, 32595766, 39956369, 39918468, 39379175, 39932363, 40967206, 38937732, 39475572, 39804003, 32583155, 39609713, 39609725, 39641662, 39511332, 39208991, 39791498, 39756342, 38945533, 39571785, 39571782, 39571786, 39774217, 39571797, 39571801, 39571791, 39571798, 39202877, 39541885, 39615320, 32592497, 39680125, 39264566, 39753143, 39846776, 39762561, 39746800, 39631056, 39458317, 38534880, 39754865, 39754866, 39622687, 39838379, 39838378, 39833141, 39371966, 39612041, 39547073, 39587775, 39188327, 39837868, 40305648, 39621889, 39779282, 38977310, 39593816, 39734712, 39708246, 39708247, 40389462, 39778696, 39544508, 39807945, 39839488, 39441264, 39778783, 39735525, 39559983, 32591803);

Date: 2024-12-07 17:21:56 Duration: 18ms
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 (41266281, 41062112, 41353472, 41113360, 41073468, 41327901, 41250720, 41339010, 41151502, 41008101, 41326454, 41132522, 41155176, 41303367, 41175426, 41050401, 41247001, 41302716, 41324710, 41268342, 41180191, 41101322, 41230684, 41179582, 41128592, 40789678, 41123344, 41255201, 41023185, 41066114, 40853815, 41146881, 41191647, 40964910, 41224369, 41252906, 41085644, 41241283, 41193779, 41301183, 41303069, 41210554, 41115605, 41284890, 41288866, 41129908, 41239370, 40368785, 41306840, 41152712, 41241573, 41071338, 40346681, 41056322, 41228482, 41223964, 41212347, 41162583, 41196792, 41085648, 32628772, 41242958, 41278451, 41295747, 41045578, 41238370, 41140238, 40992224, 41242978, 41277681, 41160794, 41197774, 41224603, 41241149, 40748119, 40895633, 41272739, 41257921, 41259907, 40546167, 41234427, 41285594, 40816363, 41250713, 41012100, 41189549, 41189658, 41157890, 41244447, 41249567, 41180707, 41272598, 41296040, 41272429, 41166811, 41149276, 41087793, 41213291, 41243288, 41202784, 41242972, 41126273, 40963420, 41017117, 41228355, 40444185, 40979813, 41054814, 41207911, 40916540, 41237997, 41114820, 41288907, 41246220, 40883986, 41078950, 41296152, 41137408, 41084993, 41139088, 41146783, 41206394, 41286970, 41176879, 41024564, 41054757, 41242160, 41023108, 41140028, 41201444, 41237786, 40549949, 40626012, 41203538, 41097312, 41190458, 41239314, 41249069, 41260643, 41122953, 40719041, 41237788, 41278030, 41087609, 41090620, 41170033, 41241398, 41302124, 40997509, 41269694, 41237264, 41170258, 41250715, 40815808, 41069248, 41013481, 40599638, 41211996, 41223536, 41026549, 41212166, 41179745, 41239302, 41222262, 32620241, 41152970, 41277393, 41072828, 40210694, 41069541, 40792907, 41201253, 41118120, 41139324, 41257249, 41168046, 41170895, 41273218, 40762384, 41067100, 41073349, 41062479, 32620204, 41125950, 41277401, 40847141, 41271915, 40823220, 32617525, 40969178, 41208114, 41134917, 40970807, 41216654, 41278514, 41071233, 41174679, 41141259, 41210034, 41016658, 41227083, 40791355, 41017782, 41133201, 41035962, 41064591, 41020512, 41157167, 40255925, 41239245, 41026616, 41015238, 41102561, 41117356, 40953614, 41226747, 41166018, 40913802, 41200380, 41188792, 41239253, 41189225, 40590764, 41037094, 41072198, 41139267, 41239895, 41097504, 41137523, 41219786, 40965679, 41239214, 41139070, 41019841, 41045349, 41244680, 41278499, 41226918, 41077258, 41131811, 41023001, 41239206, 41188823, 41106889, 40965849, 32630556, 40896430, 32615878, 41011860, 41185548, 40705834, 41178071, 41133150, 41174845, 41127017, 40926538, 41065041, 41151079, 41125881, 41089483, 41015192, 41157019, 41151182, 41134255, 40930354, 41256494, 40940774, 41126820, 41148476, 41067182, 41115856, 40975575, 40913805, 41015549, 41018509, 41237227, 41139043, 41018510, 41209800, 40719039, 41184624, 40995478, 41006770, 41106866, 41011885, 40840441, 41247862, 40952790, 41176227, 41022038, 40878329, 41065188, 41168218, 41177124, 41202126, 41189012, 41085120, 40779324, 38894427, 40963892, 41077156, 40895934, 40896426, 41098099, 40964974, 41056346, 40927913, 41092901, 41149255, 41166215, 40806782, 41018512, 41149554, 41099042, 40937263, 41117846, 41118622, 41067215, 41014875, 40679468, 41070467, 41076349, 41145527, 41147748, 41177977, 41016762, 41053366, 41062429, 41083450, 41131991, 41149530, 40877982, 41097095, 41072575, 40990334, 40214082, 41004129, 41105803, 41141562, 41106324, 41114259, 41045111, 41222093, 41069713, 41132889, 41180204, 41049431, 41133594, 41206697, 41188762, 40601617, 41164248, 41122082, 41135955, 41094688, 41011867, 41145195, 41173330, 41116976, 40808518, 41152658, 40415833, 41027309, 41167669, 41153889, 41118665, 41144160, 41090215, 41016379, 41154922, 40914453, 41090335, 41132366, 41153655, 41132569, 41105085, 41097186, 41071886, 40816100, 32620019, 41216416, 41072170, 41071753, 32628268, 41003521, 41019426, 41142589, 41132617, 41152835, 41152648, 41054601, 41154805, 40895687, 40954532, 41062252, 41132343, 40886351, 41066102, 41097295, 40688589, 41077376, 40952132, 41062840, 41125762, 41007600, 40966037, 40902467, 41053644, 32631041, 41132268, 41005462, 41017785, 41137507, 41056878, 40963759, 40698508, 41042443, 41089546, 41089200, 40964349, 40964609, 41105746, 40952628, 41152796, 41142147, 41073415, 41183683, 40896156, 40496231, 41147692, 40999085, 40626811, 41105056, 40980440, 40974653, 41011679, 41075108, 41020562, 41105901, 41021638, 41115883, 40965550, 41021518, 41002870, 41105266, 32626079, 40770428, 40504486, 41115791, 41044796, 41117981, 41016378, 41148797, 41144265, 41173536, 40422845, 41059017, 41149454, 40918378, 40872425, 41155922, 41154384, 40975546, 41044724, 40997622, 41042243, 41075123, 41042244, 41021204, 32618911, 41090298, 41005113, 41043411, 41011763, 41119657, 41154167, 40747312, 40537489, 40931559, 41006092, 41072050, 40937922, 41142655, 40626013, 41019383, 40807550, 41073850, 40915923, 40813273, 41086715, 40964726, 38892730, 40705823, 41118026, 40996458, 41154962, 40950618, 41101154, 41091956, 40937928, 41117989, 41066339, 41155990, 40895837, 32623561, 41027999, 41068044, 40912805, 32619337, 41116931, 41016854, 40895681, 41026805, 40989735, 40930488, 40739359, 40779432, 41063948, 40950572, 41048362, 41044235, 40847317, 40981490, 41020149, 40965657, 41025462, 41067689, 41064233, 40992304, 41077504, 41038321, 41016782, 41036891, 41048197, 40877721, 40998301, 40981215, 40914979, 40978013, 41033090, 40952762, 41068012, 40978352, 41029096, 40520235, 40849512, 41005123, 41091955, 40952453, 40952594, 41020971, 40530237, 41055348, 40981670, 40892718, 41007822, 41069494, 41011145, 40770403, 40620024, 41108234, 41004304, 40899609, 40910253, 40990908, 40838685, 40680216, 40978224, 40873100, 40926176, 41019151, 40664829, 40978954, 41061684, 40840026, 41050990, 40931386, 40527884, 40936507, 40599633, 40866791, 41049420, 40833129, 40885628, 41091452, 40834780, 40915847, 41037024, 41015132, 41036812, 40775523, 41031715, 40817204, 41036837, 40989382, 40748123, 40819229, 41002322, 41064385, 40917780, 41007743, 40832772, 40896082, 41034223, 40601467, 40881139, 40952370, 40952447, 40789781, 41042253, 40920530, 40990699, 40964719, 41049601, 40868453, 41066959, 40990277, 40914393, 41011908, 41108494, 40937648, 40952462, 41067045, 41002025, 40990941, 40800556, 40977088, 40753173, 40561432, 40905310, 40986798, 41053861, 41022056, 41092153, 40914355, 32628948, 41006623, 32620818, 40976599, 41053668, 40425436, 40752038, 32616118, 41031799, 41092187, 40950219, 40477539, 41005244, 41066642, 41005443, 40207222, 41053004, 40915974, 40963992, 41007284, 41007292, 32618183, 41030147, 40982202, 41068003, 41028990, 40175269, 40900900, 40996777, 41022639, 40882811, 41066757, 40937244, 40937903, 40841900, 40968772, 41045784, 40816182, 40927666, 40952826, 40989988, 40840420, 40771517, 40978293, 39677028, 40901414, 40144025, 41008601, 40790525, 41024543, 40714991, 40950375, 40977593, 40968304, 40928766, 40863982, 40775520, 41006840, 40422687, 40846161, 40953590, 32620867, 41000952, 40756008, 41050164, 40990247, 40905501, 41038316, 40650762, 41049923, 40991225, 40915745, 40851119, 40856943, 40999532, 40832323, 41024507, 40850739, 41026470, 41030045, 40936497, 40913058, 40940840, 40913585, 40800804, 40815822, 40824980, 40878960, 40587709, 40920534, 40977568, 40836391, 40985811, 40708126, 40629359, 40895701, 40926428, 40925212, 40988876, 40697735, 41004262, 40812678, 41026097, 41032652, 41035057, 40700702, 41061646, 40996961, 40675377, 40163830, 40507540, 40700126, 32618017, 40857616, 40834779, 40847817, 40822158, 40744169, 32620860, 40847676, 40904779, 40847635, 40934910, 32628138, 40913963, 40913846, 40950286, 40477523, 40982448, 41005984, 40872643, 41025659, 40914820, 41001776, 40369834, 40775502, 40330491, 40720582, 40868323, 40990027, 40951606, 40857015, 41003810, 40824520, 40824514, 40963581, 40981369, 32621090, 40977262, 40690092, 40690107, 40690093, 40989134, 40444187, 40932535, 40640879, 40791696, 41009243, 40940463, 40599629, 41005901, 40888534, 40847606, 40917574, 41008651, 40936449, 40791485, 40978898, 40840549, 40923662, 40975753, 40714538, 40922891, 40885599, 40962981, 40806944, 40935879, 40984179, 40889642, 41051716, 40968762, 40900259, 40146975, 41011265, 40941360, 41010731, 40867978, 40944506, 41010704, 40829698, 40999977, 40868320, 40948256, 40956127, 40907546, 40870923, 39784994, 40903188, 40777287, 40739657, 40889079, 40988723, 40739450, 40913448, 40934691, 40759008, 40444186, 41009520, 40783471, 40416235, 40301996, 40952845, 40904958, 40851980, 40100158, 40745302, 40923970, 40923879, 40411290, 40923073, 40823756, 40823750, 40917721, 40742465, 32621250, 40923705, 40854294, 40854024, 40706148, 40918463, 40827046, 40882526, 40776530, 40794088, 40936795, 40667276, 40977297, 40823793, 32623106, 40556316, 40958394, 40916631, 40850818, 40848760, 40915063, 40881322, 40832599, 32621300, 40755716, 32628322, 40880407, 40853624, 40659534, 40912897, 40916625, 40842418, 40911217, 40832596, 40629370, 40810570, 40848016, 40906203, 40977249, 39458086, 40883011, 40627775, 40847443, 39997185, 40860015, 40915270, 40614391, 40716428, 40915465, 40831807, 40845690, 40755726, 40923253, 32628440, 40823866, 40826833, 40901047, 40919640, 40953483, 40812962, 40979995, 40880532, 40879903, 32626996, 40925253, 40882883, 40580225, 40939095, 40824305, 40919074, 40931934, 40902743, 40681498, 40757706, 40905641, 40938238, 40880530, 40938210, 40799927, 40800634, 40790270, 40393492, 40017222, 40564338, 40714969, 40715673, 40820593, 40617222, 40910305, 40841283, 40771511, 40773331, 40776010, 40680209, 40890666, 40673487, 40890659, 40852190, 40717125, 40369711, 40740726, 39858184, 40907323, 40824872, 40967852, 40799873, 40797996, 40826330, 40856605, 40852151, 40901093, 40470258, 40900539, 40918294, 40862661, 40909994, 40943401, 40825459, 40907442, 40906827, 40659666, 40755693, 40868594, 40915252, 40942639, 40845849, 40816752, 40689578, 40846536, 40921447, 40604093, 40714537, 40809600, 40846519, 40800109, 40846575, 40534788, 40922582, 40832128, 40668389, 32628035);

Date: 2024-12-07 10:27:45 Duration: 13ms
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 (41403784, 41403783, 41403782, 41403781, 41403780, 41403779, 41403778, 41403777, 41403776, 41403775, 41403774, 41403773, 41403772, 41403771, 41403770, 41403769, 41403768, 41403767, 41403766, 41403765, 41403764, 41403763, 41403762, 41403761, 41403760, 41403759, 41403758, 41403757, 41403756, 41403755, 41403754, 41403753, 41403752, 41204813, 41300371, 41299739, 41515658, 41515657, 41515656, 41515655, 41515654, 41515653, 41515652, 41515649, 41515648, 41515647, 41515646, 41515645, 41515644, 41515643, 41515642, 41191615, 41191613, 41191612, 41191611, 41191610, 41191609, 41191608, 41040164, 41191607, 41040172, 41191606, 41191605, 41040173, 41191604, 41040175, 41040176, 41191603, 41191602, 41040188, 41276599, 41191601, 41040189, 41191600, 41040167, 41191599, 41039985, 41191598, 40616752, 41191597, 41191596, 41191595, 41191594, 41191593, 41366248, 41191592, 41366247, 41191591, 41366246, 41191590, 41366242, 41191589, 41366241, 41191588, 41366240, 41191587, 39735833, 41191586, 41366146, 41191585);

Date: 2024-12-07 17:21:55 Duration: 10ms

13

231,040

Details

1d55m14s

321ms

1s109ms

388ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 07	00	4,960	29m41s	359ms
	01	6,100	36m28s	358ms
	02	5,582	33m5s	355ms
	03	6,019	35m47s	356ms
	04	3,921	23m20s	357ms
	05	4,274	25m29s	357ms
	06	1,409	8m27s	360ms
	07	1,117	6m22s	342ms
	08	3,974	23m2s	347ms
	09	9,703	57m21s	354ms
	10	19,429	2h37s	372ms
	11	17,257	1h46m51s	371ms
	12	15,710	1h38m29s	376ms
	13	10,255	1h2m22s	364ms
	14	9,308	56m36s	364ms
	15	7,398	44m59s	364ms
	16	11,436	1h13m31s	385ms
	17	17,131	1h55m29s	404ms
	18	15,057	1h46m8s	422ms
	19	17,593	2h7m51s	436ms
	20	21,155	2h32m45s	433ms
	21	17,000	1h55m2s	406ms
	22	5,252	35m22s	404ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3219807)) AND (("shipping_track"."id" not in (26313506, 26314819, 26315109, 26427568, 26427682, 26463147, 26523260, 26680843, 26680984, 26681059, 27158286, 27254646, 27354844, 27355043, 27355043)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 1s109ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345087)) AND (("shipping_track"."id" not in (27353987, 27353987)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:14:03 Duration: 1s45ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345516)) AND (("shipping_track"."id" not in (27355044, 27355044)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 918ms

14

188,679

Details

31s937ms

0ms

16ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	1,709	248ms	0ms
	01	2,268	312ms	0ms
	02	2,367	314ms	0ms
	03	1,228	156ms	0ms
	04	992	125ms	0ms
	05	1,255	157ms	0ms
	06	1,337	182ms	0ms
	07	1,825	241ms	0ms
	08	7,584	1s78ms	0ms
	09	12,091	1s908ms	0ms
	10	16,871	2s932ms	0ms
	11	12,047	1s971ms	0ms
	12	8,649	1s442ms	0ms
	13	7,405	1s205ms	0ms
	14	8,796	1s366ms	0ms
	15	14,605	2s391ms	0ms
	16	13,459	2s314ms	0ms
	17	16,128	2s953ms	0ms
	18	17,197	3s98ms	0ms
	19	16,477	3s229ms	0ms
	20	11,755	2s194ms	0ms
	21	9,422	1s617ms	0ms
	22	3,212	495ms	0ms

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

Date: 2024-12-07 19:12:24 Duration: 16ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 906 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_portal' AND model = 'res.groups');

Date: 2024-12-07 12:01:53 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 933 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');

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

15

175,187

Details

11s402ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 07	00	1,322	84ms	0ms
	01	1,075	76ms	0ms
	02	1,441	100ms	0ms
	03	1,555	111ms	0ms
	04	1,044	74ms	0ms
	05	531	36ms	0ms
	06	880	52ms	0ms
	07	938	55ms	0ms
	08	4,008	257ms	0ms
	09	10,897	753ms	0ms
	10	18,130	1s243ms	0ms
	11	18,522	1s53ms	0ms
	12	17,666	1s8ms	0ms
	13	15,116	831ms	0ms
	14	13,818	803ms	0ms
	15	11,466	695ms	0ms
	16	12,640	846ms	0ms
	17	11,876	759ms	0ms
	18	10,901	745ms	0ms
	19	7,817	637ms	0ms
	20	6,886	606ms	0ms
	21	4,656	391ms	0ms
	22	2,002	175ms	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-07 15:16:18 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-07 19:15:18 Duration: 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-07 10:47:26 Duration: 0ms

16

162,848

Details

1m24s

0ms

28ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 07	00	417	203ms	0ms
	01	136	89ms	0ms
	02	326	152ms	0ms
	03	161	89ms	0ms
	04	130	66ms	0ms
	05	142	70ms	0ms
	06	621	216ms	0ms
	07	548	198ms	0ms
	08	2,312	1s88ms	0ms
	09	5,038	3s410ms	0ms
	10	8,415	6s340ms	0ms
	11	8,450	4s948ms	0ms
	12	10,246	5s787ms	0ms
	13	9,742	5s127ms	0ms
	14	10,031	5s231ms	0ms
	15	8,236	4s255ms	0ms
	16	13,820	6s894ms	0ms
	17	18,252	9s665ms	0ms
	18	6,256	3s901ms	0ms
	19	20,938	10s473ms	0ms
	20	27,131	11s417ms	0ms
	21	10,767	4s687ms	0ms
	22	733	443ms	0ms

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

Date: 2024-12-07 17:21:54 Duration: 28ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3122226, 3152169, 3181015, 3117177, 3148599, 3177473, 3116165, 3114911, 3181007, 3072531, 3153636, 3181104, 3181009, 3150617, 3187020, 3184207, 3124438, 3155961, 3152176, 3155960, 3148918, 3220668, 3120833, 3124434, 3187023, 3119643, 2969358, 3122234, 3114942, 3114939, 3155957, 3155964, 3162457, 3153794, 3119635, 3151111, 3154505, 3152808, 3162441, 3077167, 3077111, 2473144, 3049630, 3122162, 3114937, 3075625, 3155962, 3073241, 2911488, 3148080, 3116334, 3120129, 3122217, 3009478, 3117169, 3047864, 3047839, 3072528, 3122177, 3114938, 3114941, 3148924, 3117172, 3148920, 3117167, 3148446, 3072529, 3148868, 2944314, 3117179, 3072527, 3069168, 3122187, 2694681, 2799642, 3077118, 3072154, 3077120, 3072526);

Date: 2024-12-07 17:21:54 Duration: 21ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3122226, 3152169, 3181015, 3117177, 3148599, 3177473, 3116165, 3114911, 3181007, 3072531, 3153636, 3181104, 3181009, 3150617, 3187020, 3184207, 3124438, 3155961, 3152176, 3155960, 3148918, 3220668, 3120833, 3124434, 3187023, 3119643, 2969358, 3122234, 3114942, 3114939, 3155957, 3155964, 3162457, 3153794, 3151111, 3154505, 3152808, 3162441, 3077167, 3077111, 2473144, 3049630, 3122162, 3114937, 3075625, 3155962, 3073241, 2911488, 3148080, 3116334, 3120129, 3122217, 3009478, 3117169, 3047864, 3047839, 3072528, 3122177, 3114938, 3114941, 3148924, 3117172, 3148920, 3117167, 3148446, 3072529, 3148868, 2944314, 3117179, 3072527, 3069168, 3122187, 2694681, 2799642, 3077118, 3077120, 3072526, 3077116, 2396135);

Date: 2024-12-07 17:21:54 Duration: 21ms

17

134,841

Details

1h19m39s

27ms

94ms

35ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,028	1m8s	33ms
	01	2,408	1m20s	33ms
	02	1,702	57s316ms	33ms
	03	1,659	55s793ms	33ms
	04	1,026	35s48ms	34ms
	05	903	30s26ms	33ms
	06	765	25s674ms	33ms
	07	519	17s349ms	33ms
	08	2,636	1m28s	33ms
	09	6,939	4m	34ms
	10	15,019	8m58s	35ms
	11	13,297	7m53s	35ms
	12	13,116	7m52s	36ms
	13	8,893	5m11s	34ms
	14	8,278	4m48s	34ms
	15	6,115	3m31s	34ms
	16	7,214	4m18s	35ms
	17	7,192	4m20s	36ms
	18	10,027	5m58s	35ms
	19	9,126	5m41s	37ms
	20	6,318	3m51s	36ms
	21	6,764	3m56s	35ms
	22	2,897	1m38s	33ms

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

Date: 2024-12-07 17:22:02 Duration: 94ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3219807)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 19:19:38 Duration: 84ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2962165)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 12:58:34 Duration: 72ms

18

122,040

Details

8s176ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	1,533	85ms	0ms
	01	1,404	73ms	0ms
	02	1,885	86ms	0ms
	03	1,991	81ms	0ms
	04	1,366	55ms	0ms
	05	828	39ms	0ms
	06	787	49ms	0ms
	07	784	42ms	0ms
	08	3,251	190ms	0ms
	09	8,173	520ms	0ms
	10	12,968	899ms	0ms
	11	11,446	662ms	0ms
	12	9,538	527ms	0ms
	13	8,099	438ms	0ms
	14	7,686	410ms	0ms
	15	7,722	537ms	0ms
	16	8,305	593ms	0ms
	17	7,991	652ms	0ms
	18	8,135	696ms	0ms
	19	6,958	659ms	0ms
	20	4,965	432ms	0ms
	21	4,413	339ms	0ms
	22	1,812	101ms	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 (17, 41);

Date: 2024-12-07 14:33:08 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 (85, 50, 41, 82, 64, 62, 46, 61, 81, 42, 51, 73, 67, 52, 80, 11, 47, 100, 37, 12, 112, 14, 72, 36, 70, 66);

Date: 2024-12-07 09:39:24 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);

Date: 2024-12-07 19:27:28 Duration: 0ms

19

121,916

Details

37s985ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 07	00	5,305	1s521ms	0ms
	01	6,302	1s906ms	0ms
	02	5,031	1s614ms	0ms
	03	5,906	1s890ms	0ms
	04	3,183	1s81ms	0ms
	05	4,876	1s542ms	0ms
	06	1,671	470ms	0ms
	07	392	178ms	0ms
	08	704	286ms	0ms
	09	627	306ms	0ms
	10	1,423	696ms	0ms
	11	1,675	827ms	0ms
	12	1,693	722ms	0ms
	13	1,320	454ms	0ms
	14	1,644	531ms	0ms
	15	2,883	864ms	0ms
	16	5,318	1s622ms	0ms
	17	7,569	2s266ms	0ms
	18	17,244	5s131ms	0ms
	19	13,775	4s578ms	0ms
	20	12,859	3s861ms	0ms
	21	11,773	3s332ms	0ms
	22	8,743	2s295ms	0ms

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

Date: 2024-12-07 17:21:58 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 10) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";

Date: 2024-12-07 09:13:39 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 71) AND ("price_list"."to_office_id" = 110)) ORDER BY "price_list"."id";

Date: 2024-12-07 12:47:32 Duration: 1ms

20

112,950

Details

6s449ms

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	1,056	54ms	0ms
	01	858	43ms	0ms
	02	824	41ms	0ms
	03	488	23ms	0ms
	04	374	19ms	0ms
	05	309	15ms	0ms
	06	752	37ms	0ms
	07	749	37ms	0ms
	08	3,391	174ms	0ms
	09	6,693	373ms	0ms
	10	10,214	606ms	0ms
	11	6,875	394ms	0ms
	12	5,225	300ms	0ms
	13	4,897	271ms	0ms
	14	5,069	275ms	0ms
	15	9,753	533ms	0ms
	16	9,139	517ms	0ms
	17	10,530	628ms	0ms
	18	11,409	662ms	0ms
	19	10,017	623ms	0ms
	20	6,557	392ms	0ms
	21	5,899	325ms	0ms
	22	1,872	96ms	0ms

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

Date: 2024-12-07 15:59:29 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 (21);

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

Date: 2024-12-07 18:11:27 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

24m28s

35s730ms

97

Details

57m45s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 07	19	26	46ms	1ms
	20	41	57m45s	1m24s
	21	20	23ms	1ms
	22	10	14ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-07 20:18:51.874895', "last_update" = '2024-12-07 19:33:51.874920', "logged_in" = true, "sid" = 'a7291f598aeda37ad01b47e62891f15863374183', "write_date" = '2024-12-07 19:33:51.537018', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 24m28s
UPDATE "res_users" SET "exp_date" = '2024-12-07 20:30:40.257201', "last_update" = '2024-12-07 19:45:40.257223', "logged_in" = true, "sid" = 'c84c324ed00819e929f25faba3943d797e9f08d5', "write_date" = '2024-12-07 19:45:39.915384', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 12m40s
UPDATE "res_users" SET "exp_date" = '2024-12-07 20:35:29.863763', "last_update" = '2024-12-07 19:50:29.863789', "logged_in" = true, "sid" = '1d730bebbc756664b57081a48ac0b183ea47b934', "write_date" = '2024-12-07 19:50:29.521539', "write_uid" = 949 WHERE id IN (949);

Date: 2024-12-07 20:58:20 Duration: 7m50s

2

0ms

59m59s

3s883ms

8,743

Details

9h25m57s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 07	19	3,398	2h17m48s	2s433ms
	20	2,641	4h3m24s	5s529ms
	21	1,940	6m7s	189ms
	22	764	2h58m37s	14s28ms

update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869308', exp_date = '2024-12-07 20:55:36.869311', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 59m59s
update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:10:36.869307', exp_date = '2024-12-07 20:55:36.869309', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 59m59s
update res_users set sid = '20703f902f28256f6a815a52110c8025684c15dd', last_update = '2024-12-07 20:11:59.301053', exp_date = '2024-12-07 20:56:59.301056', logged_in = 'TRUE' where id = 956;

Date: 2024-12-07 22:10:36 Duration: 58m37s

3

335ms

4s705ms

2s806ms

335

Details

15m40s

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	3	9s521ms	3s173ms
	09	12	42s412ms	3s534ms
	10	15	57s441ms	3s829ms
	11	11	40s478ms	3s679ms
	12	11	45s70ms	4s97ms
	13	24	1m23s	3s476ms
	14	26	1m32s	3s561ms
	15	18	1m	3s361ms
	16	47	1m45s	2s246ms
	17	52	2m33s	2s943ms
	18	30	45s177ms	1s505ms
	19	27	46s669ms	1s728ms
	20	17	32s994ms	1s940ms
	21	38	1m52s	2s957ms
	22	4	12s641ms	3s160ms

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

Date: 2024-12-07 12:01:55 Duration: 4s705ms
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 (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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) 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"."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)))))))) AND ("policy_number"."name"::text ilike '%925869%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-07 12:01:53 Duration: 4s614ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-07 17:13:54 Duration: 4s610ms

4

223ms

1s804ms

960ms

12,242

Details

3h16m4s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 07	00	638	10m12s	960ms
	01	499	7m54s	951ms
	02	155	2m27s	953ms
	08	2	1s918ms	959ms
	10	6	6s11ms	1s1ms
	11	17	20s934ms	1s231ms
	12	133	2m20s	1s54ms
	13	78	1m20s	1s38ms
	14	140	2m21s	1s7ms
	15	447	7m18s	981ms
	16	936	16m2s	1s28ms
	17	600	10m13s	1s22ms
	18	2,243	35m38s	953ms
	19	1,578	28m6s	1s68ms
	20	1,575	25m20s	965ms
	21	1,365	22m9s	973ms
	22	1,830	24m9s	792ms

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

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

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

Date: 2024-12-07 19:18:28 Duration: 1s610ms

5

321ms

1s109ms

388ms

231,040

Details

1d55m14s

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	4,960	29m41s	359ms
	01	6,100	36m28s	358ms
	02	5,582	33m5s	355ms
	03	6,019	35m47s	356ms
	04	3,921	23m20s	357ms
	05	4,274	25m29s	357ms
	06	1,409	8m27s	360ms
	07	1,117	6m22s	342ms
	08	3,974	23m2s	347ms
	09	9,703	57m21s	354ms
	10	19,429	2h37s	372ms
	11	17,257	1h46m51s	371ms
	12	15,710	1h38m29s	376ms
	13	10,255	1h2m22s	364ms
	14	9,308	56m36s	364ms
	15	7,398	44m59s	364ms
	16	11,436	1h13m31s	385ms
	17	17,131	1h55m29s	404ms
	18	15,057	1h46m8s	422ms
	19	17,593	2h7m51s	436ms
	20	21,155	2h32m45s	433ms
	21	17,000	1h55m2s	406ms
	22	5,252	35m22s	404ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3219807)) AND (("shipping_track"."id" not in (26313506, 26314819, 26315109, 26427568, 26427682, 26463147, 26523260, 26680843, 26680984, 26681059, 27158286, 27254646, 27354844, 27355043, 27355043)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 1s109ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345087)) AND (("shipping_track"."id" not in (27353987, 27353987)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:14:03 Duration: 1s45ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3345516)) AND (("shipping_track"."id" not in (27355044, 27355044)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:39 Duration: 918ms

6

325ms

1s201ms

387ms

43,088

Details

4h38m6s

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 07	00	525	3m5s	352ms
	01	128	50s42ms	390ms
	02	143	57s799ms	404ms
	03	127	52s200ms	411ms
	04	106	42s85ms	397ms
	05	105	42s307ms	402ms
	06	209	1m14s	358ms
	07	207	1m12s	351ms
	08	1,160	6m52s	355ms
	09	3,308	20m1s	363ms
	10	4,143	26m29s	383ms
	11	4,366	27m39s	380ms
	12	3,654	23m34s	387ms
	13	3,212	20m5s	375ms
	14	3,027	18m43s	371ms
	15	2,209	13m28s	366ms
	16	3,715	23m26s	378ms
	17	3,343	22m40s	407ms
	18	2,643	18m4s	410ms
	19	2,911	20m57s	432ms
	20	1,650	11m44s	426ms
	21	1,795	12m3s	403ms
	22	402	2m37s	391ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3266981, 3266978, 3266977, 3266974, 3266972, 3266969, 3266968, 3266965, 3266962, 3266959, 3266957, 3266955, 3266952, 3266950, 3266948, 3266946, 3266945, 3266943, 3266941, 3266939, 3266938, 3266936, 3266934, 3266933, 3266931, 3266930, 3266928, 3266926, 3266925, 3266923, 3266921, 3266920, 3266918, 3266916, 3266915, 3266913, 3266911, 3266910, 3266908, 3266907, 3266905, 3266903, 3266902, 3266901, 3266899, 3266897, 3266896, 3266894, 3266892, 3266891, 3266889, 3266887, 3266886, 3266884, 3266882, 3266881, 3266879, 3266878, 3266876, 3266873, 3266870, 3266868, 3266865, 3266863, 3266859, 3266855, 3266851, 3266846, 3266841, 3266832, 3266830, 3266826, 3266823, 3266820, 3266816, 3266814, 3266810, 3266808, 3266805, 3266801, 3266799, 3266796, 3266793, 3266791, 3266788, 3266784, 3266782, 3266779, 3266777, 3266774, 3266771, 3266768, 3266766, 3266762, 3266759, 3266756, 3266753, 3266749, 3266746, 3266742, 3266737, 3265878, 3265872, 3265866, 3265817, 3265682, 3265679, 3265676, 3265673, 3265670, 3265666, 3265663, 3265661, 3265659, 3265657, 3265655, 3265653, 3265651, 3265648, 3265646, 3265644, 3265642, 3265640, 3265638, 3265636, 3265633, 3265631, 3265629, 3265627, 3265625, 3265621, 3265618, 3265615, 3265612, 3265468, 3265467, 3265466, 3265465, 3265464, 3265463, 3265462, 3265461, 3265460, 3265459, 3265458, 3265457, 3265456, 3265455, 3265454, 3265453, 3265452, 3265451, 3265450, 3265449, 3265448, 3265447, 3265446, 3265445, 3265444, 3265443, 3265442, 3265441, 3265439, 3265438, 3265437, 3265436, 3265435, 3265434, 3265433, 3265432, 3265431, 3265430, 3265429, 3265428, 3265427, 3265426, 3265425, 3265424, 3265423, 3265422, 3265420, 3265419, 3265417, 3265416, 3265415, 3265414, 3265412, 3265411, 3265410, 3265409, 3265407, 3265406, 3265405, 3265403, 3265402, 3265401, 3265399, 3265398, 3265397, 3265395, 3265394, 3265393, 3265392, 3265390, 3265388, 3265385, 3265382, 3265380, 3265377, 3265374, 3265372, 3265369, 3265367, 3265364, 3265362, 3265359, 3265356, 3265352, 3265350, 3265347, 3265343, 3265341, 3265338, 3265335, 3265333, 3265330, 3265327, 3265325, 3265322, 3265320, 3265317, 3265314, 3265312, 3265310, 3265307, 3265304, 3265301, 3265298, 3265296, 3265293, 3265290, 3265288, 3265285, 3265282, 3265280, 3265277, 3265274, 3265272, 3265269, 3265268, 3265265, 3265262, 3265259, 3265257, 3265254, 3265252, 3265249, 3265246)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 17:21:55 Duration: 1s201ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3159069)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 19:19:38 Duration: 875ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3328173, 3301677)) ORDER BY "shipping_track"."id";

Date: 2024-12-07 20:26:06 Duration: 766ms

7

213ms

528ms

300ms

15,018

Details

1h15m6s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 07	00	512	2m24s	281ms
	01	771	3m35s	279ms
	02	735	3m27s	282ms
	03	1,126	5m25s	288ms
	04	521	2m28s	285ms
	05	909	4m15s	281ms
	06	367	1m40s	272ms
	07	6	1s675ms	279ms
	08	52	15s51ms	289ms
	09	1	337ms	337ms
	10	21	6s554ms	312ms
	11	9	2s938ms	326ms
	12	95	27s915ms	293ms
	13	170	51s795ms	304ms
	14	210	1m2s	297ms
	15	251	1m14s	296ms
	16	375	1m57s	313ms
	17	1,320	6m44s	306ms
	18	2,071	10m34s	306ms
	19	1,858	10m5s	325ms
	20	1,655	8m43s	316ms
	21	1,605	7m56s	296ms
	22	378	1m42s	271ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9280777')) 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-07 17:21:57 Duration: 528ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9041574')) 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-07 20:26:08 Duration: 504ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9113780')) 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-07 19:14:00 Duration: 503ms

8

187ms

382ms

249ms

14,708

Details

1h1m3s

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 07	08	713	2m49s	237ms
	09	1,547	6m16s	243ms
	10	1,523	6m36s	260ms
	11	936	3m56s	252ms
	12	2,200	9m20s	254ms
	13	2,161	8m54s	247ms
	14	1,576	6m26s	245ms
	15	1,947	7m54s	243ms
	16	826	3m24s	247ms
	17	957	4m5s	256ms
	18	322	1m18s	244ms

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

Date: 2024-12-07 10:52:56 Duration: 382ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9130839')))) ORDER BY "collection_policy"."id";

Date: 2024-12-07 10:52:56 Duration: 355ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9130653')))) ORDER BY "collection_policy"."id";

Date: 2024-12-07 10:51:34 Duration: 351ms

9

91ms

950ms

237ms

53,686

Details

3h32m40s

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	2,279	7m26s	196ms
	01	2,521	8m	190ms
	02	1,752	6m1s	206ms
	03	2,118	9m31s	269ms
	04	974	4m10s	257ms
	05	1,808	6m12s	206ms
	06	728	2m30s	206ms
	07	12	2s398ms	199ms
	08	108	16s722ms	154ms
	09	2	260ms	130ms
	10	54	12s219ms	226ms
	11	52	15s401ms	296ms
	12	396	1m35s	241ms
	13	486	1m47s	221ms
	14	688	2m31s	220ms
	15	1,370	5m7s	224ms
	16	2,598	10m40s	246ms
	17	3,771	16m2s	255ms
	18	8,568	35m21s	247ms
	19	6,815	31m24s	276ms
	20	6,396	25m54s	243ms
	21	5,856	23m7s	236ms
	22	4,334	14m25s	199ms

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-07 18:09:52 Duration: 950ms
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-07 18:09:52 Duration: 950ms
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-07 18:46:37 Duration: 880ms

10

171ms

403ms

220ms

107,087

Details

6h33m35s

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

Day	Hour	Count	Duration	Avg duration
Dec 07	00	538	1m46s	197ms
	01	945	3m6s	197ms
	02	1,480	4m52s	197ms
	03	1,168	3m52s	199ms
	04	1,378	4m33s	198ms
	05	2,679	8m52s	198ms
	06	280	55s822ms	199ms
	07	454	1m29s	196ms
	08	1,476	4m54s	199ms
	09	4,070	13m45s	202ms
	10	3,471	12m15s	211ms
	11	3,240	11m21s	210ms
	12	5,506	19m33s	213ms
	13	4,866	16m47s	206ms
	14	4,944	17m11s	208ms
	15	4,477	15m6s	202ms
	16	11,049	40m48s	221ms
	17	11,043	40m45s	221ms
	18	1,913	7m5s	222ms
	19	27,307	1h49m57s	241ms
	20	13,481	50m14s	223ms
	21	1,073	3m33s	199ms
	22	249	47s5ms	188ms

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

Date: 2024-12-07 19:14:02 Duration: 403ms
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" = '9197371')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-07 19:19:37 Duration: 389ms
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" = '7914557')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-07 19:18:27 Duration: 384ms

11

174ms

274ms

204ms

7,288

Details

24m48s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 07	00	54	10s707ms	198ms
	01	272	53s873ms	198ms
	02	9	1s757ms	195ms
	03	118	23s523ms	199ms
	04	391	1m17s	197ms
	05	685	2m16s	199ms
	06	135	26s908ms	199ms
	07	443	1m27s	197ms
	08	256	50s629ms	197ms
	09	1,272	4m19s	203ms
	10	765	2m41s	211ms
	11	864	3m1s	209ms
	12	530	1m52s	212ms
	13	305	1m2s	205ms
	14	322	1m6s	206ms
	15	334	1m7s	202ms
	16	89	18s435ms	207ms
	17	21	4s670ms	222ms
	18	147	30s650ms	208ms
	20	68	13s105ms	192ms
	21	175	33s968ms	194ms
	22	33	6s289ms	190ms

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

Date: 2024-12-07 12:36:04 Duration: 274ms
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" = '9252501')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-07 11:52:10 Duration: 270ms
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" = '9115890')) 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)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))) 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-07 11:52:11 Duration: 269ms

12

15ms

620ms

199ms

2,640

Details

8m46s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 07	00	5	970ms	194ms
	01	1	18ms	18ms
	03	1	297ms	297ms
	06	8	2s149ms	268ms
	07	5	684ms	136ms
	08	61	6s88ms	99ms
	09	99	16s253ms	164ms
	10	223	38s431ms	172ms
	11	277	52s419ms	189ms
	12	306	56s210ms	183ms
	13	325	1m3s	195ms
	14	305	1m6s	217ms
	15	284	56s202ms	197ms
	16	172	36s815ms	214ms
	17	163	37s549ms	230ms
	18	174	33s549ms	192ms
	19	88	23s563ms	267ms
	20	80	20s895ms	261ms
	21	47	12s692ms	270ms
	22	16	1s686ms	105ms

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

Date: 2024-12-07 19:14:02 Duration: 620ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-07 20:25:46 Duration: 528ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (73))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2024-12-07 19:15:11 Duration: 513ms

13

176ms

233ms

197ms

5,450

Details

17m58s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 07	00	484	1m35s	197ms
	01	665	2m10s	196ms
	02	1,104	3m38s	197ms
	03	1,029	3m25s	199ms
	04	910	3m	198ms
	05	1,026	3m23s	198ms
	06	22	4s361ms	198ms
	21	2	390ms	195ms
	22	208	39s400ms	189ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9248584')) 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-07 03:22:17 Duration: 233ms
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" = '9098603')) 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-07 03:21:43 Duration: 233ms
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" = '9257172')) 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-07 03:21:36 Duration: 232ms

14

131ms

272ms

151ms

2,701

Details

6m48s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and (("res_partner"."type_employee" = ?) and ("res_partner"."type_driver" = ?))) 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 limit ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 07	00	41	5s805ms	141ms
	01	66	9s383ms	142ms
	02	97	13s783ms	142ms
	03	84	11s973ms	142ms
	04	71	10s157ms	143ms
	05	89	12s622ms	141ms
	06	52	7s351ms	141ms
	07	16	2s246ms	140ms
	08	40	5s737ms	143ms
	09	70	10s195ms	145ms
	10	174	27s391ms	157ms
	11	232	35s560ms	153ms
	12	209	32s660ms	156ms
	13	203	30s363ms	149ms
	14	174	25s901ms	148ms
	15	143	20s935ms	146ms
	16	144	22s32ms	153ms
	17	167	26s425ms	158ms
	18	214	32s775ms	153ms
	19	147	24s523ms	166ms
	20	112	17s886ms	159ms
	21	126	18s615ms	147ms
	22	30	4s357ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:19:34 Duration: 272ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:17:19 Duration: 252ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-07 19:19:21 Duration: 242ms

15

123ms

254ms

142ms

2,726

Details

6m28s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 07	00	120	16s301ms	135ms
	01	120	16s345ms	136ms
	02	120	16s306ms	135ms
	03	120	16s396ms	136ms
	04	120	16s343ms	136ms
	05	120	16s233ms	135ms
	06	120	16s210ms	135ms
	07	120	16s225ms	135ms
	08	120	16s419ms	136ms
	09	120	16s820ms	140ms
	10	120	17s738ms	147ms
	11	120	17s625ms	146ms
	12	120	17s684ms	147ms
	13	120	17s265ms	143ms
	14	120	16s985ms	141ms
	15	120	16s890ms	140ms
	16	120	17s231ms	143ms
	17	116	17s498ms	150ms
	18	120	17s890ms	149ms
	19	120	19s283ms	160ms
	20	120	18s566ms	154ms
	21	120	17s600ms	146ms
	22	90	12s880ms	143ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:16:01 Duration: 254ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:14:01 Duration: 251ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-07 19:14:01 Duration: 248ms

16

120ms

249ms

140ms

5,914

Details

13m51s

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 07	00	38	4s977ms	130ms
	01	1	129ms	129ms
	06	6	774ms	129ms
	07	2	263ms	131ms
	08	60	7s913ms	131ms
	09	220	29s902ms	135ms
	10	1,117	2m39s	142ms
	11	1,015	2m22s	140ms
	12	1,032	2m25s	141ms
	13	696	1m36s	138ms
	14	393	54s318ms	138ms
	15	165	22s326ms	135ms
	16	175	25s299ms	144ms
	17	678	1m36s	142ms
	18	83	11s358ms	136ms
	19	64	9s705ms	151ms
	20	85	12s416ms	146ms
	21	54	7s163ms	132ms
	22	30	4s18ms	133ms

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

Date: 2024-12-07 10:52:56 Duration: 249ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 115)) 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-07 17:22:12 Duration: 224ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 44)) 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-07 20:32:57 Duration: 195ms

17

69ms

146ms

85ms

18,903

Details

26m47s

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 07	00	105	8s413ms	80ms
	01	45	3s490ms	77ms
	06	59	4s623ms	78ms
	08	213	17s668ms	82ms
	09	669	57s166ms	85ms
	10	1,641	2m21s	86ms
	11	1,907	2m40s	84ms
	12	1,925	2m42s	84ms
	13	2,082	2m51s	82ms
	14	2,239	3m6s	83ms
	15	1,735	2m22s	81ms
	16	1,564	2m13s	85ms
	17	836	1m15s	90ms
	18	1,133	1m37s	86ms
	19	887	1m23s	94ms
	20	745	1m6s	89ms
	21	1,000	1m24s	84ms
	22	118	9s760ms	82ms

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

Date: 2024-12-07 18:46:24 Duration: 146ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7777901)) AND (("cash_track"."id" not in (5424895)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-07 19:50:08 Duration: 134ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7777374)) AND (("cash_track"."id" not in (5423124)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-07 18:46:26 Duration: 132ms

18

32ms

135ms

42ms

32,675

Details

23m3s

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 07	00	33	1s289ms	39ms
	01	11	431ms	39ms
	02	4	162ms	40ms
	05	39	1s483ms	38ms
	06	12	472ms	39ms
	07	12	470ms	39ms
	08	1,181	45s494ms	38ms
	09	3,171	2m5s	39ms
	10	3,142	2m10s	41ms
	11	1,762	1m12s	41ms
	12	4,214	2m57s	42ms
	13	2,834	1m54s	40ms
	14	4,277	2m54s	40ms
	15	3,519	2m22s	40ms
	16	2,177	1m29s	41ms
	17	2,599	1m59s	46ms
	18	2,255	1m55s	51ms
	19	652	34s565ms	53ms
	20	419	20s946ms	49ms
	21	275	13s127ms	47ms
	22	87	3s993ms	45ms

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

Date: 2024-12-07 17:21:55 Duration: 135ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3324500) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-07 19:17:24 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3302816) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-07 19:17:41 Duration: 84ms

19

29ms

62ms

36ms

12,250

Details

7m32s

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 07	08	623	22s39ms	35ms
	09	1,236	44s92ms	35ms
	10	1,185	44s28ms	37ms
	11	877	32s368ms	36ms
	12	1,475	54s356ms	36ms
	13	1,647	59s667ms	36ms
	14	1,515	54s987ms	36ms
	15	1,673	1m	36ms
	16	806	29s771ms	36ms
	17	895	37s158ms	41ms
	18	318	13s397ms	42ms

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

Date: 2024-12-07 12:27:17 Duration: 62ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3114057) ORDER BY "collection_policy"."id";

Date: 2024-12-07 17:47:14 Duration: 59ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3052707) ORDER BY "collection_policy"."id";

Date: 2024-12-07 17:47:14 Duration: 59ms

20

27ms

94ms

35ms

134,841

Details

1h19m39s

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 07	00	2,028	1m8s	33ms
	01	2,408	1m20s	33ms
	02	1,702	57s316ms	33ms
	03	1,659	55s793ms	33ms
	04	1,026	35s48ms	34ms
	05	903	30s26ms	33ms
	06	765	25s674ms	33ms
	07	519	17s349ms	33ms
	08	2,636	1m28s	33ms
	09	6,939	4m	34ms
	10	15,019	8m58s	35ms
	11	13,297	7m53s	35ms
	12	13,116	7m52s	36ms
	13	8,893	5m11s	34ms
	14	8,278	4m48s	34ms
	15	6,115	3m31s	34ms
	16	7,214	4m18s	35ms
	17	7,192	4m20s	36ms
	18	10,027	5m58s	35ms
	19	9,126	5m41s	37ms
	20	6,318	3m51s	36ms
	21	6,764	3m56s	35ms
	22	2,897	1m38s	33ms

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

Date: 2024-12-07 17:22:02 Duration: 94ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3219807)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 19:19:38 Duration: 84ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2962165)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-07 12:58:34 Duration: 72ms

Time consuming prepare


Date: 2024-12-07 20:02:13
Duration: 3ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 2ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 1ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 2ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres

Time consuming bind


Date: 2024-12-07 20:02:13
Duration: 6ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 1ms
Database: postgres
Date: 2024-12-07 16:12:07
Duration: 0ms
Database: postgres
Date: 2024-12-07 19:21:58
Duration: 0ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres
Date: 2024-12-07 17:21:55
Duration: 0ms
Database: postgres

Log levels

Key values

19,100,080 Log entries

Chart
Table

Type	Count	Percentage
CONTEXT	7	0.00%
DETAIL	24	0.00%
ERROR	899	0.00%
FATAL	492	0.00%
HINT	13	0.00%
LOG	19,097,766	99.99%
STATEMENT	879	0.00%

Events distribution

Key values

0 PANIC entries
492 FATAL entries
930 ERROR entries
0 WARNING entries

Most Frequent Errors/Events

Key values

453 Max number of times the same event was reported
1,422 Total events found

Rank

Times reported

Error

1

453

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 07	02	2
	03	1
	04	1
	05	1
	08	1
	09	3
	10	7
	11	4
	12	2
	13	3
	14	2
	15	4
	16	16
	17	13
	18	1
	19	149
	20	132
	21	38
	22	73

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

361

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 07	17	103
	22	258

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

3

346

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 07	19	130
	20	119
	21	28
	22	69

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

4

78

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 07	15	1
	16	4
	18	7
	19	37
	20	27
	22	2

5

78

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 07	15	1
	16	4
	18	7
	19	37
	20	27
	22	2

6

17

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 07	18	3
	19	11
	20	3

7

16

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 07	17	16

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

8

15

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 07	17	15

9

10

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 07	11	1
	12	3
	13	3
	14	3

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 07	01	3
	10	2
	13	2
	14	1
	18	1

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 300

11

6

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 07	14	1
	18	3
	19	2

12

5

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 07	09	3
	15	2

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

13

4

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 07	17	2
	18	2

ERROR: could not create unique index "bank_deposit_deposite_2_name"

14

4

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 07	09	1
	19	3

FATAL: password authentication failed for user "postgres"

15

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 07	17	3

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 07	17	3

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

17

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 07	07	1
	18	1
	19	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 07	07	1
	18	1

19

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 07	09	1
	17	1

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

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 07	07	1
	18	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 07	07	1

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 07	17	1

23

1

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 07	16	1

ERROR: deadlock detected

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 07	04	1

25

1

Details

ERROR: canceling statement due to lock timeout

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 07	19	1

ERROR: canceling statement due to lock timeout

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