pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Dec 26 23:47:43 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 48,495,394 log entries in 2m42s
Log start from 2024-12-26 00:00:00 to 2024-12-26 22:45:01

Global Stats

25,021 Number of unique normalized queries
20,700,657 Number of queries
6d11h17m54s Total query duration
2024-12-26 00:00:00 First query
2024-12-26 22:45:01 Last query
8,506 queries/s at 2024-12-26 11:47:12 Query peak

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

21,982 Number of events
26 Number of unique normalized events
10,012 Max number of times the same event was reported
0 Number of cancellation

0 Total number of automatic vacuums
0 Total number of automatic analyzes

0 Number temporary file
0 Max size of temporary file
0.00 B Average size of temporary file

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
20,700,657 Average queries per session
6d11h17m54s 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

8,506 queries/s Query Peak
2024-12-26 11:47:12 Date

SELECT Traffic

Key values

5,776 queries/s Query Peak
2024-12-26 11:47:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,888 queries/s Query Peak
2024-12-26 11:47:12 Date

Queries duration

Key values

6d11h17m54s 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 26	00	273,949	0ms	29m57s	23ms	2m43s	3m33s	31m2s
	01	263,219	0ms	4s315ms	19ms	2m22s	2m40s	3m32s
	02	249,281	0ms	1s11ms	20ms	2m32s	2m52s	3m8s
	03	238,369	0ms	2s18ms	21ms	2m39s	3m43s	4m38s
	04	237,239	0ms	11s548ms	24ms	3m6s	3m10s	3m19s
	05	168,257	0ms	588ms	19ms	1m55s	2m2s	3m28s
	06	273,388	0ms	4s474ms	17ms	2m41s	2m53s	4m15s
	07	271,159	0ms	4s306ms	19ms	3m8s	3m48s	4m14s
	08	522,541	0ms	12m42s	49ms	3m30s	1h19m49s	2h57m32s
	09	1,253,450	0ms	8m15s	22ms	6m58s	9m28s	2h4m28s
	10	1,559,253	0ms	19m4s	24ms	8m33s	39m47s	4h34m9s
	11	1,941,360	0ms	14m7s	23ms	14m47s	43m58s	2h49m37s
	12	1,777,497	0ms	14m25s	18ms	6m12s	46m59s	2h48m46s
	13	1,603,399	0ms	16m59s	27ms	6m25s	2h26m13s	3h45m35s
	14	1,747,820	0ms	15m9s	29ms	10m18s	2h40m18s	2h50m55s
	15	1,562,221	0ms	22m53s	43ms	7m43s	36m59s	7h51m46s
	16	1,595,892	0ms	23m11s	24ms	11m33s	1h8m13s	2h14m19s
	17	1,355,423	0ms	9m13s	15ms	7m48s	8m54s	1h52m55s
	18	1,118,779	0ms	34m42s	36ms	9m43s	10m55s	6h46m59s
	19	919,977	0ms	1m50s	18ms	7m33s	8m13s	9m54s
	20	776,156	0ms	7m29s	30ms	15m19s	16m59s	19m18s
	21	588,094	0ms	56s605ms	25ms	6m25s	7m58s	11m8s
	22	403,934	0ms	51m5s	73ms	5m19s	5m52s	6h22m46s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 26	00	147,794	30ms	2m8s	2m39s	3m32s
	01	141,525	35ms	1m52s	2m22s	3m10s
	02	127,682	40ms	2m4s	2m32s	2m53s
	03	120,722	41ms	2m5s	2m38s	4m19s
	04	122,243	46ms	2m47s	2m58s	3m13s
	05	81,392	39ms	1m27s	1m55s	2m20s
	06	144,227	32ms	1m58s	2m41s	3m2s
	07	147,217	36ms	2m19s	3m8s	3m49s
	08	315,348	14ms	2m8s	2m45s	3m46s
	09	737,492	19ms	5m13s	6m17s	8m45s
	10	920,271	15ms	5m1s	6m8s	8m31s
	11	1,187,537	18ms	8m18s	10m15s	11m57s
	12	1,076,589	13ms	5m15s	5m52s	6m11s
	13	953,985	12ms	4m45s	5m40s	7m3s
	14	1,062,057	16ms	6m26s	7m24s	10m6s
	15	912,679	15ms	4m39s	6m39s	7m42s
	16	971,611	18ms	7m2s	7m36s	8m16s
	17	810,287	17ms	5m8s	7m36s	8m52s
	18	655,994	24ms	6m23s	7m56s	10m54s
	19	541,429	31ms	6m3s	7m32s	8m11s
	20	440,252	52ms	9m40s	13m35s	17m11s
	21	336,915	44ms	5m21s	6m25s	8m56s
	22	238,475	28ms	3m8s	5m	9m11s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 26	00	20,925	4,645	149	0	70ms	127ms	171ms	260ms
	01	20,300	5,205	137	0	0ms	121ms	157ms	197ms
	02	18,570	5,466	136	0	0ms	115ms	145ms	187ms
	03	17,951	5,669	153	0	0ms	118ms	172ms	255ms
	04	23,689	5,769	160	0	0ms	145ms	212ms	250ms
	05	11,528	3,251	132	0	0ms	69ms	100ms	160ms
	06	18,911	5,003	154	0	0ms	113ms	148ms	193ms
	07	18,650	6,275	209	0	0ms	110ms	134ms	204ms
	08	19,674	7,672	354	0	763ms	141ms	200ms	1h19m17s
	09	61,582	21,638	751	0	159ms	379ms	474ms	1m2s
	10	64,725	21,404	730	0	272ms	427ms	527ms	36m55s
	11	89,764	29,585	690	0	194ms	652ms	991ms	40m26s
	12	70,060	23,115	777	5	202ms	420ms	510ms	43m57s
	13	57,171	22,766	666	6	390ms	340ms	407ms	2h23m17s
	14	76,051	26,277	784	0	328ms	477ms	552ms	2h37m10s
	15	72,735	26,954	1,108	1	524ms	393ms	509ms	34m22s
	16	73,989	23,430	667	1	207ms	500ms	705ms	1h6m6s
	17	62,684	20,268	783	0	79ms	513ms	701ms	845ms
	18	77,988	23,316	753	0	241ms	483ms	750ms	1m21s
	19	78,244	21,751	659	0	1ms	512ms	558ms	776ms
	20	79,222	27,730	465	0	8ms	587ms	831ms	2m37s
	21	57,360	11,164	499	0	1ms	336ms	423ms	791ms
	22	31,321	6,772	193	0	598ms	236ms	358ms	38s215ms

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

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

190,269 buffers Checkpoint Peak
2024-12-26 18:41:24 Date
270.058 seconds Highest write time
0.016 seconds Sync time

Checkpoints Wal files

Key values

124 files Wal files usage Peak
2024-12-26 18:41:24 Date

Checkpoints distance

Key values

3,953.67 Mo Distance Peak
2024-12-26 18:41:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 26	00	98,454	3,239.582s	0.029s	3,239.662s
	01	165,480	3,239.528s	0.039s	3,239.615s
	02	160,615	3,239.512s	0.049s	3,239.616s
	03	169,320	3,239.631s	0.033s	3,239.715s
	04	163,806	3,239.506s	0.041s	3,239.592s
	05	95,089	3,239.642s	0.025s	3,239.708s
	06	129,690	3,206.579s	0.032s	3,206.651s
	07	114,959	3,179.503s	0.03s	3,179.584s
	08	146,592	3,239.481s	0.037s	3,239.561s
	09	395,799	3,239.593s	0.052s	3,239.719s
	10	493,922	3,239.458s	0.049s	3,239.591s
	11	606,149	3,239.486s	0.06s	3,239.652s
	12	543,527	3,239.548s	0.05s	3,239.723s
	13	464,070	3,239.411s	0.062s	3,239.553s
	14	556,906	3,239.485s	0.067s	3,239.647s
	15	509,708	3,239.539s	0.055s	3,239.69s
	16	426,369	3,239.547s	0.063s	3,239.68s
	17	392,139	2,882.21s	0.069s	2,882.362s
	18	490,168	3,239.508s	0.063s	3,239.673s
	19	384,075	3,239.54s	0.046s	3,239.658s
	20	413,882	3,239.528s	0.055s	3,239.673s
	21	313,871	3,239.575s	0.053s	3,239.691s
	22	161,424	2,429.607s	0.027s	2,429.675s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 26	00	0	45	3,153	0.002s	0.012s
	01	0	72	2,918	0.012s	0.012s
	02	0	72	2,713	0.015s	0.012s
	03	0	75	2,705	0.002s	0.012s
	04	0	73	2,802	0.002s	0.012s
	05	0	44	2,130	0.002s	0.012s
	06	0	58	2,637	0.002s	0.012s
	07	0	52	2,906	0.002s	0.012s
	08	0	65	3,816	0.006s	0.012s
	09	0	172	4,929	0.003s	0.012s
	10	0	220	5,359	0.003s	0.012s
	11	0	269	5,434	0.003s	0.012s
	12	0	242	5,467	0.002s	0.012s
	13	0	202	5,293	0.003s	0.012s
	14	0	245	5,430	0.003s	0.012s
	15	0	222	5,655	0.003s	0.012s
	16	0	182	5,535	0.002s	0.012s
	17	0	171	5,570	0.007s	0.012s
	18	8	247	5,402	0.003s	0.012s
	19	4	152	5,303	0.003s	0.012s
	20	0	176	5,290	0.003s	0.012s
	21	0	130	4,688	0.014s	0.012s
	22	0	66	3,331	0.002s	0.009s

Day	Hour	Avg time (sec)
Dec 26	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 26	00	61,234.00 kB	105,550.00 kB
	01	98,331.92 kB	126,708.50 kB
	02	98,850.75 kB	132,498.17 kB
	03	101,195.58 kB	130,835.67 kB
	04	98,697.45 kB	136,109.18 kB
	05	60,173.17 kB	105,886.92 kB
	06	79,155.67 kB	115,898.83 kB
	07	70,557.83 kB	112,678.08 kB
	08	88,172.00 kB	114,885.33 kB
	09	235,209.17 kB	257,276.67 kB
	10	300,197.92 kB	373,769.42 kB
	11	367,002.17 kB	452,478.00 kB
	12	327,982.55 kB	404,063.00 kB
	13	281,177.73 kB	355,009.73 kB
	14	333,977.82 kB	377,537.36 kB
	15	304,367.91 kB	368,069.73 kB
	16	248,606.08 kB	340,115.42 kB
	17	233,751.58 kB	334,864.00 kB
	18	348,778.75 kB	762,303.58 kB
	19	213,027.67 kB	928,504.08 kB
	20	239,269.50 kB	419,607.42 kB
	21	178,590.83 kB	266,761.50 kB
	22	120,032.22 kB	205,224.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 26	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 26	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

12,193,723 Total read queries
5,782,754 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	12,193,723	58.91%
INSERT	1,123,094	5.43%
UPDATE	355,125	1.72%
DELETE	11,109	0.05%
COPY FROM	13	0.00%
COPY TO	0	0.00%
CTE	30,191	0.15%
DDL	2,740	0.01%
TCL	4,260,482	20.58%
CURSOR	0	0.00%
OTHERS	2,724,180	13.16%

Queries by database

Key values

unknown Main database
20,700,657 Requests
6d11h17m54s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	20,700,657	6d11h17m54s
	copy from	13	11ms
	cte	30,191	6s598ms
	ddl	2,740	394ms
	delete	11,109	1s636ms
	insert	1,123,094	5m45s
	others	2,724,180	2m6s
	select	12,193,723	3d50m51s
	tcl	4,260,482	2m56s
	update	355,125	3d10h16m6s

Queries by user

Key values

unknown Main user
20,700,657 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	20,700,657	6d11h17m54s
	copy from	13	11ms
	cte	30,191	6s598ms
	ddl	2,740	394ms
	delete	11,109	1s636ms
	insert	1,123,094	5m45s
	others	2,724,180	2m6s
	select	12,193,723	3d50m51s
	tcl	4,260,482	2m56s
	update	355,125	3d10h16m6s

Duration by user

Key values

6d11h17m54s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	20,700,657	6d11h17m54s
	copy from	13	11ms
	cte	30,191	6s598ms
	ddl	2,740	394ms
	delete	11,109	1s636ms
	insert	1,123,094	5m45s
	others	2,724,180	2m6s
	select	12,193,723	3d50m51s
	tcl	4,260,482	2m56s
	update	355,125	3d10h16m6s

Queries by host

Key values

unknown Main host
20,700,657 Requests
6d11h17m54s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	20,700,657	6d11h17m54s
	copy from	13	11ms
	cte	30,191	6s598ms
	ddl	2,740	394ms
	delete	11,109	1s636ms
	insert	1,123,094	5m45s
	others	2,724,180	2m6s
	select	12,193,723	3d50m51s
	tcl	4,260,482	2m56s
	update	355,125	3d10h16m6s

Queries by application

Key values

unknown Main application
20,700,657 Requests
6d11h17m54s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	20,700,657	6d11h17m54s
	copy from	13	11ms
	cte	30,191	6s598ms
	ddl	2,740	394ms
	delete	11,109	1s636ms
	insert	1,123,094	5m45s
	others	2,724,180	2m6s
	select	12,193,723	3d50m51s
	tcl	4,260,482	2m56s
	update	355,125	3d10h16m6s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-26 14:11:19 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

19,328,065 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	19,328,065	93.37%
1-5ms	315,059	1.52%
5-10ms	14,928	0.07%
10-25ms	61,026	0.29%
25-50ms	237,907	1.15%
50-100ms	73,393	0.35%
100-500ms	562,101	2.72%
500-1000ms	102,215	0.49%
1000-10000ms	4,887	0.02%
> 10000ms	1,076	0.01%

Slowest individual queries

Rank	Duration	Query
1	51m5s	UPDATE "res_users" SET "exp_date" = '2024-12-26 21:29:15.349827', "last_update" = '2024-12-26 20:44:15.349847', "write_date" = '2024-12-26 20:44:15.028108', "write_uid" = 1223 WHERE id IN (1223); [ Date: 2024-12-26 22:35:20 ]
2	48m37s	update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:46:43.545084', exp_date = '2024-12-26 21:31:43.545088', logged_in = 'TRUE' where id = 1223; [ Date: 2024-12-26 22:35:20 ]
3	43m5s	update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:52:15.735253', exp_date = '2024-12-26 21:37:15.735257', logged_in = 'TRUE' where id = 1223; [ Date: 2024-12-26 22:35:20 ]
4	34m42s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:42:38.645720', exp_date = '2024-12-26 17:27:38.645723', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
5	34m42s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:42:38.645067', exp_date = '2024-12-26 17:27:38.645070', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
6	32m10s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:45:10.893325', exp_date = '2024-12-26 17:30:10.893329', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
7	31m54s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:45:26.475008', exp_date = '2024-12-26 17:30:26.475012', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
8	29m57s	UPDATE "res_users" SET "exp_date" = '2024-12-26 00:12:52.842104', "last_update" = '2024-12-25 23:27:52.842128', "sid" = 'eb92e49f2b309acd9c3ade111f236f2f27104228', "write_date" = '2024-12-25 23:27:52.517934', "write_uid" = 1 WHERE id IN (823); [ Date: 2024-12-26 00:57:50 ]
9	28m1s	update res_users set sid = 'a2145d861f51720f20328dac1faa127d87d16ec0', last_update = '2024-12-26 16:49:19.509717', exp_date = '2024-12-26 17:34:19.509720', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
10	27m48s	update res_users set sid = 'a2145d861f51720f20328dac1faa127d87d16ec0', last_update = '2024-12-26 16:49:32.523769', exp_date = '2024-12-26 17:34:32.523771', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
11	27m24s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:49:56.641364', exp_date = '2024-12-26 17:34:56.641367', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
12	24m45s	update res_users set sid = 'a2145d861f51720f20328dac1faa127d87d16ec0', last_update = '2024-12-26 16:52:35.247016', exp_date = '2024-12-26 17:37:35.247018', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]
13	23m11s	update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2024-12-26 15:11:09.267885', exp_date = '2024-12-26 15:56:09.267890', logged_in = 'TRUE' where id = 1049; [ Date: 2024-12-26 16:34:20 ]
14	23m11s	update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2024-12-26 15:11:09.267935', exp_date = '2024-12-26 15:56:09.267937', logged_in = 'TRUE' where id = 1049; [ Date: 2024-12-26 16:34:20 ]
15	22m53s	update res_users set sid = '60f653100cefaa9be05bc1975bab65100144152f', last_update = '2024-12-26 14:28:27.244164', exp_date = '2024-12-26 15:13:27.244168', logged_in = 'TRUE' where id = 1242; [ Date: 2024-12-26 15:51:20 ]
16	22m53s	update res_users set sid = '60f653100cefaa9be05bc1975bab65100144152f', last_update = '2024-12-26 14:28:27.244022', exp_date = '2024-12-26 15:13:27.244026', logged_in = 'TRUE' where id = 1242; [ Date: 2024-12-26 15:51:20 ]
17	22m9s	update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2024-12-26 14:29:11.015664', exp_date = '2024-12-26 15:14:11.015669', logged_in = 'TRUE' where id = 1049; [ Date: 2024-12-26 15:51:20 ]
18	22m9s	update res_users set sid = '2fa23b723cee9ff223c52a72b0acb54f3dbd00d6', last_update = '2024-12-26 14:29:11.015106', exp_date = '2024-12-26 15:14:11.015109', logged_in = 'TRUE' where id = 1049; [ Date: 2024-12-26 15:51:20 ]
19	21m35s	update res_users set sid = '8dcf4972cde88040145e99988956b1a56a41c10f', last_update = '2024-12-26 14:29:44.920747', exp_date = '2024-12-26 15:14:44.920752', logged_in = 'TRUE' where id = 1049; [ Date: 2024-12-26 15:51:20 ]
20	21m8s	update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:56:12.724734', exp_date = '2024-12-26 17:41:12.724739', logged_in = 'TRUE' where id = 870; [ Date: 2024-12-26 18:17:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d5h30m57s

86,557

Details

0ms

48m37s

3s223ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 26	00	673	146ms	0ms
	01	800	169ms	0ms
	02	845	178ms	0ms
	03	700	145ms	0ms
	04	740	156ms	0ms
	05	553	113ms	0ms
	06	836	177ms	0ms
	07	747	157ms	0ms
	08	2,138	5h27m25s	9s188ms
	09	5,556	3h40m22s	2s379ms
	10	7,102	6h18m52s	3s200ms
	11	9,087	5h58m32s	2s367ms
	12	8,060	5h15m11s	2s346ms
	13	8,454	8h30m10s	3s620ms
	14	8,280	9h20m36s	4s62ms
	15	7,943	14h17m50s	6s479ms
	16	6,665	5h11m26s	2s803ms
	17	5,739	1h50m55s	1s159ms
	18	3,765	6h41m10s	6s393ms
	19	2,914	1m50s	38ms
	20	2,280	9m55s	261ms
	21	1,678	1m13s	43ms
	22	1,002	4h45m21s	17s87ms

update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:46:43.545084', exp_date = '2024-12-26 21:31:43.545088', logged_in = 'TRUE' where id = 1223;

Date: 2024-12-26 22:35:20 Duration: 48m37s
update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:52:15.735253', exp_date = '2024-12-26 21:37:15.735257', logged_in = 'TRUE' where id = 1223;

Date: 2024-12-26 22:35:20 Duration: 43m5s
update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:42:38.645720', exp_date = '2024-12-26 17:27:38.645723', logged_in = 'TRUE' where id = 870;

Date: 2024-12-26 18:17:21 Duration: 34m42s

2

1d12h3m54s

270,309

Details

380ms

4s501ms

480ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 26	00	5,912	45m33s	462ms
	01	7,104	53m34s	452ms
	02	7,307	54m41s	449ms
	03	6,885	52m17s	455ms
	04	7,967	1h41s	457ms
	05	5,220	38m37s	443ms
	06	6,406	48m30s	454ms
	07	6,083	45m54s	452ms
	08	5,439	41m21s	456ms
	09	14,242	1h53m42s	479ms
	10	14,074	1h53m16s	482ms
	11	19,766	2h54m27s	529ms
	12	15,030	2h17s	480ms
	13	10,205	1h20m36s	473ms
	14	14,527	2h1m13s	500ms
	15	13,533	1h47m24s	476ms
	16	18,037	2h30m52s	501ms
	17	14,175	1h53m18s	479ms
	18	15,267	2h3m6s	483ms
	19	15,233	2h2m4s	480ms
	20	17,965	2h30m49s	503ms
	21	22,154	2h51m54s	465ms
	22	7,778	59m39s	460ms

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

Date: 2024-12-26 20:32:18 Duration: 4s501ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974187)) AND (("shipping_track"."id" not in (32411060, 32411060)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:30:13 Duration: 4s222ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974096)) AND (("shipping_track"."id" not in (32410915, 32410915)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:28:52 Duration: 4s139ms

3

8h52m42s

139,900

Details

169ms

1s707ms

228ms

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 26	00	644	2m4s	193ms
	01	1,871	5m58s	191ms
	02	2,267	7m18s	193ms
	03	2,313	7m26s	193ms
	04	1,918	6m8s	192ms
	05	1,545	4m58s	193ms
	06	2,511	8m5s	193ms
	07	5,289	17m16s	195ms
	08	2,461	8m	195ms
	09	9,546	33m45s	212ms
	10	7,255	25m20s	209ms
	11	16,206	1h2m9s	230ms
	12	4,712	16m38s	211ms
	13	8,842	31m9s	211ms
	14	10,306	38m26s	223ms
	15	7,574	26m50s	212ms
	16	6,106	22m21s	219ms
	17	2,702	10m16s	228ms
	18	6,279	26m11s	250ms
	19	8,048	30m46s	229ms
	20	30,465	2h17m51s	271ms
	21	865	3m1s	209ms
	22	175	35s569ms	203ms

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

Date: 2024-12-26 11:10:38 Duration: 1s707ms
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" = '9433562')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-26 11:10:27 Duration: 1s637ms
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" = '9469418')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-26 20:25:04 Duration: 1s633ms

4

6h47m27s

49,854

Details

377ms

3s499ms

490ms

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 26	00	225	1m49s	487ms
	01	206	1m41s	491ms
	02	248	2m1s	488ms
	03	298	2m22s	479ms
	04	344	2m43s	476ms
	05	157	1m17s	495ms
	06	331	2m38s	479ms
	07	575	4m25s	461ms
	08	1,034	7m54s	458ms
	09	3,656	29m39s	486ms
	10	3,222	26m52s	500ms
	11	4,188	38m2s	545ms
	12	3,774	31m11s	495ms
	13	3,425	27m46s	486ms
	14	4,548	38m22s	506ms
	15	4,563	36m31s	480ms
	16	3,911	33m8s	508ms
	17	4,294	34m10s	477ms
	18	3,253	25m19s	467ms
	19	2,958	22m42s	460ms
	20	1,983	16m26s	497ms
	21	1,553	12m3s	466ms
	22	1,108	8m13s	445ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3921141, 3919326, 3919235, 3915234, 3913715, 3913373, 3913340, 3912771, 3912298, 3910506, 3907634, 3907455, 3907409, 3906288, 3904453, 3904324, 3904175, 3901451, 3901179, 3901142, 3900936, 3899738, 3898207, 3897761, 3896422, 3896203, 3895497, 3891784, 3886581, 3883001, 3840079)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 11:10:30 Duration: 3s499ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3952415)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:30:11 Duration: 3s85ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3936881)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:31:55 Duration: 2s890ms

5

4h3m27s

60,720

Details

91ms

966ms

240ms

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 26	00	2,656	9m14s	208ms
	01	1,836	6m40s	217ms
	02	1,380	4m36s	200ms
	03	1,752	6m23s	218ms
	04	2,770	10m37s	230ms
	05	272	1m1s	227ms
	06	1,278	5m12s	244ms
	07	1,126	4m43s	252ms
	08	1,308	5m	229ms
	09	260	53s98ms	204ms
	10	532	1m47s	202ms
	11	404	1m52s	278ms
	12	556	2m20s	253ms
	13	608	2m10s	214ms
	14	1,721	7m5s	247ms
	15	1,327	5m14s	236ms
	16	3,102	13m42s	265ms
	17	4,467	19m11s	257ms
	18	7,966	31m9s	234ms
	19	9,546	37m37s	236ms
	20	6,000	27m17s	272ms
	21	5,807	23m38s	244ms
	22	4,046	15m55s	236ms

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-26 20:30:54 Duration: 966ms
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-26 20:30:54 Duration: 877ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مصنع')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-26 20:42:58 Duration: 864ms

6

3h33m47s

391

Details

0ms

29m57s

32s806ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 26	00	7	29m57s	4m16s
	01	4	1ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	04	1	0ms	0ms
	06	5	0ms	0ms
	07	3	0ms	0ms
	08	23	24m52s	1m4s
	09	28	16ms	0ms
	10	35	7m49s	13s418ms
	11	41	29m43s	43s496ms
	12	29	1m3s	2s204ms
	13	25	14m32s	34s909ms
	14	38	3m59s	6s310ms
	15	26	22m53s	52s825ms
	16	38	24m9s	38s153ms
	17	20	28ms	1ms
	18	22	9m31s	25s991ms
	19	11	14ms	1ms
	20	8	8ms	1ms
	21	15	6ms	0ms
	22	9	45m12s	5m1s

UPDATE "res_users" SET "exp_date" = '2024-12-26 00:12:52.842104', "last_update" = '2024-12-25 23:27:52.842128', "sid" = 'eb92e49f2b309acd9c3ade111f236f2f27104228', "write_date" = '2024-12-25 23:27:52.517934', "write_uid" = 1 WHERE id IN (823);

Date: 2024-12-26 00:57:50 Duration: 29m57s
UPDATE "res_users" SET "exp_date" = '2024-12-26 15:59:57.069700', "last_update" = '2024-12-26 15:14:57.069723', "sid" = 'd0a2b79be8f21005f1a9c1a9c28db8fdec4c34bd', "write_date" = '2024-12-26 15:14:56.716187', "write_uid" = 1 WHERE id IN (1049);

Date: 2024-12-26 16:34:20 Duration: 19m23s
UPDATE "res_users" SET "exp_date" = '2024-12-26 14:57:11.766861', "last_update" = '2024-12-26 14:12:11.766886', "sid" = '1b5da9ce4182dc7e251104a701f1182913bd6ab0', "write_date" = '2024-12-26 14:12:11.403872', "write_uid" = 1 WHERE id IN (853);

Date: 2024-12-26 15:28:20 Duration: 16m8s

7

2h25m13s

9,828

Details

237ms

2s231ms

886ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 26	00	503	6m19s	754ms
	01	162	2m28s	915ms
	02	555	5m52s	635ms
	03	98	1m30s	924ms
	09	44	45s206ms	1s27ms
	10	31	31s164ms	1s5ms
	11	47	54s749ms	1s164ms
	12	70	1m14s	1s70ms
	13	107	1m49s	1s27ms
	14	306	5m9s	1s12ms
	15	49	50s127ms	1s23ms
	16	407	7m	1s33ms
	17	547	9m51s	1s81ms
	18	1,339	21m39s	970ms
	19	2,943	35m35s	725ms
	20	707	11m59s	1s18ms
	21	1,023	16m45s	982ms
	22	890	14m54s	1s4ms

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

Date: 2024-12-26 20:24:57 Duration: 2s231ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9614324')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-26 20:31:35 Duration: 1s982ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9457542')) 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 (52))))))) 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 (52)))))) 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 (52)))))) 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 (52))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-26 20:31:40 Duration: 1s961ms

8

2h12m9s

28,632

Details

181ms

1s713ms

276ms

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 26	07	908	3m46s	249ms
	08	63	17s856ms	283ms
	09	2,304	10m38s	277ms
	10	3,569	15m55s	267ms
	11	3,163	15m22s	291ms
	12	1,540	7m23s	288ms
	13	3,481	15m16s	263ms
	14	4,456	20m59s	282ms
	15	2,539	11m14s	265ms
	16	3,172	14m16s	270ms
	17	902	4m30s	300ms
	18	233	1m13s	316ms
	19	905	3m59s	264ms
	20	1,397	7m13s	310ms

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

Date: 2024-12-26 20:29:23 Duration: 1s713ms
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" = '9522472')))) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:10:45 Duration: 1s636ms
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" = '9361433')))) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:29:29 Duration: 784ms

9

1h52m45s

20,892

Details

214ms

2s227ms

323ms

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	840	4m4s	290ms
	01	764	3m42s	291ms
	02	141	41s61ms	291ms
	03	782	3m50s	294ms
	04	1,393	6m47s	292ms
	05	137	39s374ms	287ms
	06	647	3m6s	288ms
	07	567	2m43s	288ms
	08	659	3m13s	292ms
	09	103	37s487ms	363ms
	10	248	1m19s	322ms
	11	159	54s375ms	341ms
	12	220	1m11s	323ms
	13	213	1m5s	308ms
	14	574	3m1s	315ms
	15	623	3m21s	323ms
	16	1,162	6m41s	345ms
	17	1,714	9m17s	325ms
	18	2,676	14m46s	331ms
	19	1,874	10m21s	331ms
	20	2,329	14m45s	380ms
	21	1,900	10m32s	333ms
	22	1,167	5m59s	308ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9623174')) 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-26 20:24:59 Duration: 2s227ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9570747')) 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-26 20:31:41 Duration: 2s56ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9474946')) 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-26 20:30:02 Duration: 2s24ms

10

1h51m5s

165,872

Details

29ms

247ms

40ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3,063	1m54s	37ms
	01	2,643	1m38s	37ms
	02	2,674	1m39s	37ms
	03	1,885	1m10s	37ms
	04	3,079	1m54s	37ms
	05	1,694	1m3s	37ms
	06	2,490	1m33s	37ms
	07	1,931	1m12s	37ms
	08	2,724	1m41s	37ms
	09	9,366	6m13s	39ms
	10	10,853	7m17s	40ms
	11	16,759	12m14s	43ms
	12	11,814	7m51s	39ms
	13	8,520	5m35s	39ms
	14	12,093	8m15s	40ms
	15	11,277	7m24s	39ms
	16	15,740	10m42s	40ms
	17	9,905	6m38s	40ms
	18	9,532	6m25s	40ms
	19	8,925	5m56s	39ms
	20	8,360	5m51s	42ms
	21	6,007	3m56s	39ms
	22	4,538	2m55s	38ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3894430, 3874753)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 11:10:32 Duration: 247ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3974052)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:32:04 Duration: 211ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3907187)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:24:59 Duration: 209ms

11

57m38s

49

Details

0ms

51m5s

1m10s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 26	08	2	2ms	1ms
	09	3	2ms	0ms
	10	11	6m32s	35s714ms
	11	6	10ms	1ms
	12	4	6ms	1ms
	13	4	3ms	0ms
	14	4	6ms	1ms
	15	1	1ms	1ms
	16	1	1ms	1ms
	17	1	1ms	1ms
	18	4	5ms	1ms
	19	2	2ms	1ms
	20	2	2ms	1ms
	21	3	2ms	0ms
	22	1	51m5s	51m5s

UPDATE "res_users" SET "exp_date" = '2024-12-26 21:29:15.349827', "last_update" = '2024-12-26 20:44:15.349847', "write_date" = '2024-12-26 20:44:15.028108', "write_uid" = 1223 WHERE id IN (1223);

Date: 2024-12-26 22:35:20 Duration: 51m5s
UPDATE "res_users" SET "exp_date" = '2024-12-26 10:35:48.379405', "last_update" = '2024-12-26 09:50:48.379430', "write_date" = '2024-12-26 09:50:48.003933', "write_uid" = 1 WHERE id IN (1292);

Date: 2024-12-26 10:57:21 Duration: 6m32s
UPDATE "res_users" SET "exp_date" = '2024-12-26 10:37:18.903774', "last_update" = '2024-12-26 09:52:18.903806', "write_date" = '2024-12-26 09:52:18.416374', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-26 10:52:18 Duration: 3ms

12

57m13s

69,827

Details

36ms

273ms

49ms

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	34	1s610ms	47ms
	01	4	188ms	47ms
	02	10	458ms	45ms
	03	11	508ms	46ms
	04	10	462ms	46ms
	05	15	678ms	45ms
	06	11	507ms	46ms
	07	128	5s713ms	44ms
	08	220	10s402ms	47ms
	09	4,638	3m41s	47ms
	10	4,401	3m34s	48ms
	11	10,111	9m1s	53ms
	12	3,227	2m37s	48ms
	13	3,396	2m44s	48ms
	14	6,108	5m13s	51ms
	15	10,142	8m12s	48ms
	16	19,232	15m16s	47ms
	17	3,218	2m32s	47ms
	18	1,960	1m33s	47ms
	19	1,572	1m12s	46ms
	20	824	47s266ms	57ms
	21	347	16s536ms	47ms
	22	208	9s692ms	46ms

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

Date: 2024-12-26 20:28:43 Duration: 273ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3779523) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:29:36 Duration: 258ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3906834) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:10:43 Duration: 250ms

13

52m24s

14,879

Details

170ms

1s108ms

211ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3	582ms	194ms
	01	172	33s5ms	191ms
	02	190	36s735ms	193ms
	03	16	3s23ms	188ms
	04	240	45s985ms	191ms
	05	135	26s584ms	196ms
	06	705	2m17s	195ms
	07	893	2m56s	198ms
	08	1,141	3m40s	193ms
	09	2,900	10m7s	209ms
	10	891	3m4s	206ms
	11	1,689	6m21s	225ms
	12	1,051	3m41s	210ms
	13	660	2m21s	214ms
	14	1,335	4m52s	218ms
	15	661	2m17s	207ms
	16	346	1m16s	222ms
	17	389	1m22s	212ms
	18	427	1m34s	221ms
	19	290	1m2s	213ms
	20	429	1m55s	269ms
	21	145	31s299ms	215ms
	22	171	34s890ms	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" = '9509118')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2024-12-26 20:25:09 Duration: 456ms
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" = '9513841')) 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 (14, 74, 70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) 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-26 20:29:05 Duration: 456ms

14

37m29s

22,735

Details

78ms

679ms

98ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 26	02	3	294ms	98ms
	03	23	2s218ms	96ms
	04	17	1s600ms	94ms
	05	4	378ms	94ms
	06	10	956ms	95ms
	07	60	5s716ms	95ms
	08	249	23s459ms	94ms
	09	1,449	2m24s	99ms
	10	2,108	3m28s	98ms
	11	2,268	3m58s	105ms
	12	2,261	3m38s	96ms
	13	2,186	3m29s	95ms
	14	2,782	4m35s	98ms
	15	2,928	4m42s	96ms
	16	1,851	3m9s	102ms
	17	1,125	1m51s	98ms
	18	1,451	2m25s	100ms
	19	768	1m14s	96ms
	20	696	1m9s	100ms
	21	299	30s204ms	101ms
	22	197	18s208ms	92ms

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

Date: 2024-12-26 11:10:31 Duration: 679ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7889180)) AND (("cash_track"."id" not in (6256645)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-26 20:29:38 Duration: 430ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7884908)) AND (("cash_track"."id" not in (6218350)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-26 11:10:28 Duration: 213ms

15

34m14s

10,668

Details

173ms

229ms

192ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 26	00	619	1m59s	193ms
	01	1,581	5m2s	191ms
	02	2,057	6m37s	193ms
	03	2,257	7m14s	192ms
	04	1,164	3m43s	192ms
	05	1,410	4m31s	192ms
	06	1,101	3m32s	192ms
	07	309	1m	194ms
	08	170	32s765ms	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9547248')) 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-26 00:04:36 Duration: 229ms
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" = '9499648')) 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-26 02:26:02 Duration: 227ms
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" = '9520569')) 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-26 02:38:27 Duration: 226ms

16

22m11s

6,294

Details

177ms

1s105ms

211ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 26	00	22	4s304ms	195ms
	06	259	50s568ms	195ms
	07	651	2m6s	194ms
	08	292	57s261ms	196ms
	09	2,017	7m7s	212ms
	10	648	2m14s	208ms
	11	285	1m8s	239ms
	12	495	1m44s	210ms
	13	237	48s952ms	206ms
	14	219	50s969ms	232ms
	15	515	1m50s	213ms
	16	336	1m13s	219ms
	17	296	1m8s	232ms
	21	18	3s682ms	204ms
	22	4	830ms	207ms

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

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

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

Date: 2024-12-26 11:10:27 Duration: 380ms

17

16m48s

22,441

Details

32ms

97ms

44ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 26	07	74	3s71ms	41ms
	08	68	2s926ms	43ms
	09	1,997	1m24s	42ms
	10	2,310	1m41s	44ms
	11	3,245	2m38s	48ms
	12	1,422	1m1s	43ms
	13	1,546	1m8s	44ms
	14	2,489	1m55s	46ms
	15	3,381	2m32s	44ms
	16	3,677	2m39s	43ms
	17	1,146	49s786ms	43ms
	18	369	15s417ms	41ms
	19	478	20s178ms	42ms
	20	239	14s484ms	60ms

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

Date: 2024-12-26 20:30:23 Duration: 97ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3785893) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:13:04 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3773772) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:30:27 Duration: 83ms

18

15m8s

6,124

Details

120ms

1s138ms

148ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 26	00	30	3s912ms	130ms
	01	10	1s275ms	127ms
	02	6	781ms	130ms
	04	5	653ms	130ms
	07	20	2s646ms	132ms
	08	62	8s333ms	134ms
	09	626	1m28s	140ms
	10	736	1m46s	144ms
	11	1,295	3m32s	164ms
	12	1,072	2m34s	144ms
	13	455	1m4s	141ms
	14	572	1m24s	147ms
	15	289	41s219ms	142ms
	16	291	43s515ms	149ms
	17	277	39s962ms	144ms
	18	102	14s426ms	141ms
	19	59	8s759ms	148ms
	20	99	16s453ms	166ms
	21	94	13s45ms	138ms
	22	24	3s271ms	136ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 64)) 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-26 11:10:44 Duration: 1s138ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) 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-26 20:29:01 Duration: 1s95ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-26 11:17:38 Duration: 1s81ms

19

12m50s

3,133

Details

17ms

2s913ms

245ms

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3	64ms	21ms
	01	5	1s208ms	241ms
	04	3	1s260ms	420ms
	06	2	814ms	407ms
	07	5	1s38ms	207ms
	08	62	7s501ms	120ms
	09	187	38s592ms	206ms
	10	275	1m4s	233ms
	11	295	1m11s	242ms
	12	438	1m47s	245ms
	13	433	1m44s	241ms
	14	368	1m31s	248ms
	15	288	1m7s	233ms
	16	228	1m6s	291ms
	17	213	57s989ms	272ms
	18	102	32s343ms	317ms
	19	123	22s921ms	186ms
	20	62	24s52ms	387ms
	21	14	4s316ms	308ms
	22	27	5s350ms	198ms

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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-26 20:29:31 Duration: 2s913ms
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 (30)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-26 11:13:11 Duration: 1s784ms
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 (11)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))) 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-26 11:10:43 Duration: 1s774ms

20

12m12s

2,700

Details

183ms

435ms

271ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 26	10	396	1m42s	258ms
	11	235	1m7s	286ms
	12	197	50s816ms	257ms
	13	253	1m5s	259ms
	14	219	1m3s	287ms
	15	714	3m9s	264ms
	16	426	1m57s	276ms
	17	260	1m16s	294ms

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

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

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

Date: 2024-12-26 17:24:40 Duration: 415ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,722,470

Details

2m6s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 26	00	41,754	1s616ms	0ms
	01	38,927	1s697ms	0ms
	02	39,394	1s718ms	0ms
	03	37,995	1s634ms	0ms
	04	34,316	1s531ms	0ms
	05	29,245	1s230ms	0ms
	06	40,474	1s875ms	0ms
	07	38,634	1s783ms	0ms
	08	68,634	2s696ms	0ms
	09	162,975	7s749ms	0ms
	10	210,017	10s24ms	0ms
	11	241,189	11s526ms	0ms
	12	232,347	10s492ms	0ms
	13	219,801	9s499ms	0ms
	14	224,173	9s712ms	0ms
	15	214,358	9s79ms	0ms
	16	206,368	9s48ms	0ms
	17	178,064	8s688ms	0ms
	18	140,870	7s578ms	0ms
	19	109,733	5s481ms	0ms
	20	90,729	5s97ms	0ms
	21	72,433	3s946ms	0ms
	22	50,040	2s530ms	0ms

DISCARD ALL;

Date: 2024-12-26 19:52:46 Duration: 1ms
DISCARD ALL;

Date: 2024-12-26 15:48:56 Duration: 1ms
DISCARD ALL;

Date: 2024-12-26 15:54:23 Duration: 1ms

2

2,130,873

Details

29s886ms

0ms

13ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 26	00	29,186	404ms	0ms
	01	28,385	421ms	0ms
	02	28,947	425ms	0ms
	03	27,910	405ms	0ms
	04	25,514	386ms	0ms
	05	21,338	317ms	0ms
	06	32,276	480ms	0ms
	07	30,037	445ms	0ms
	08	54,736	717ms	0ms
	09	133,648	1s804ms	0ms
	10	169,932	2s307ms	0ms
	11	194,130	2s750ms	0ms
	12	185,569	2s425ms	0ms
	13	173,105	2s163ms	0ms
	14	177,255	2s353ms	0ms
	15	166,055	2s63ms	0ms
	16	158,116	2s139ms	0ms
	17	140,522	2s1ms	0ms
	18	109,221	1s748ms	0ms
	19	83,453	1s337ms	0ms
	20	68,642	1s254ms	0ms
	21	54,677	939ms	0ms
	22	38,219	590ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-26 10:16:25 Duration: 13ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-26 00:04:53 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-26 15:48:10 Duration: 1ms

3

1,385,474

Details

13s691ms

0ms

1ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 26	00	21,596	179ms	0ms
	01	20,113	180ms	0ms
	02	20,268	180ms	0ms
	03	19,579	171ms	0ms
	04	17,724	160ms	0ms
	05	15,201	131ms	0ms
	06	20,965	194ms	0ms
	07	19,949	183ms	0ms
	08	35,522	311ms	0ms
	09	82,549	820ms	0ms
	10	106,810	1s22ms	0ms
	11	122,675	1s315ms	0ms
	12	117,494	1s156ms	0ms
	13	111,395	1s32ms	0ms
	14	113,835	1s135ms	0ms
	15	108,661	999ms	0ms
	16	104,614	1s52ms	0ms
	17	90,244	908ms	0ms
	18	71,465	749ms	0ms
	19	55,794	598ms	0ms
	20	46,323	546ms	0ms
	21	37,138	401ms	0ms
	22	25,560	258ms	0ms

ROLLBACK;

Date: 2024-12-26 11:01:48 Duration: 1ms
ROLLBACK;

Date: 2024-12-26 17:39:51 Duration: 0ms
ROLLBACK;

Date: 2024-12-26 12:19:12 Duration: 0ms

4

1,370,510

Details

3m54s

0ms

15ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 26	00	21,015	2s956ms	0ms
	01	19,525	3s10ms	0ms
	02	19,702	3s51ms	0ms
	03	18,945	2s804ms	0ms
	04	17,126	2s654ms	0ms
	05	14,611	2s91ms	0ms
	06	20,309	3s98ms	0ms
	07	19,281	2s921ms	0ms
	08	34,519	5s165ms	0ms
	09	82,180	13s793ms	0ms
	10	105,973	16s800ms	0ms
	11	121,803	21s158ms	0ms
	12	116,917	19s106ms	0ms
	13	110,735	17s80ms	0ms
	14	112,993	18s936ms	0ms
	15	107,896	16s451ms	0ms
	16	103,670	17s356ms	0ms
	17	89,706	16s204ms	0ms
	18	70,961	14s196ms	0ms
	19	55,308	11s738ms	0ms
	20	45,762	10s624ms	0ms
	21	36,476	7s882ms	0ms
	22	25,097	4s925ms	0ms

SELECT payload FROM http_sessions WHERE sid = '272a650f33058ab3034d1f4ef0a92eb950929be5';

Date: 2024-12-26 18:17:23 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = 'd5ffb33e89f1565c0395d92602a5114ff1086726';

Date: 2024-12-26 15:45:23 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = '0da4689aa0c378ac657514db6802d659e81af59f';

Date: 2024-12-26 20:53:44 Duration: 15ms

5

1,360,851

Details

2m1s

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 26	00	20,935	1s604ms	0ms
	01	19,536	1s636ms	0ms
	02	19,778	1s650ms	0ms
	03	19,065	1s557ms	0ms
	04	17,242	1s454ms	0ms
	05	14,710	1s192ms	0ms
	06	20,297	1s713ms	0ms
	07	19,372	1s625ms	0ms
	08	34,222	2s705ms	0ms
	09	81,368	7s147ms	0ms
	10	104,863	8s984ms	0ms
	11	120,465	11s369ms	0ms
	12	116,067	10s306ms	0ms
	13	109,836	9s211ms	0ms
	14	111,964	10s12ms	0ms
	15	107,094	8s873ms	0ms
	16	103,059	9s423ms	0ms
	17	89,010	8s212ms	0ms
	18	70,423	6s771ms	0ms
	19	54,893	5s296ms	0ms
	20	45,399	4s642ms	0ms
	21	36,214	3s450ms	0ms
	22	25,039	2s263ms	0ms

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

Date: 2024-12-26 12:39:19 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-26 10:15:54 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-26 14:29:46 Duration: 1ms

6

970,193

Details

2m16s

0ms

29ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 26	00	9,459	1s479ms	0ms
	01	10,064	1s534ms	0ms
	02	10,228	1s579ms	0ms
	03	9,692	1s470ms	0ms
	04	9,234	1s472ms	0ms
	05	7,388	1s145ms	0ms
	06	13,654	2s15ms	0ms
	07	12,411	1s849ms	0ms
	08	24,182	3s123ms	0ms
	09	66,726	9s867ms	0ms
	10	83,145	11s341ms	0ms
	11	94,999	13s624ms	0ms
	12	90,756	11s652ms	0ms
	13	82,672	10s400ms	0ms
	14	84,271	11s134ms	0ms
	15	76,175	9s887ms	0ms
	16	69,542	9s789ms	0ms
	17	65,070	9s51ms	0ms
	18	49,121	7s289ms	0ms
	19	35,317	5s276ms	0ms
	20	28,278	5s248ms	0ms
	21	22,305	3s744ms	0ms
	22	15,504	2s637ms	0ms

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

Date: 2024-12-26 11:07:52 Duration: 29ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1089);

Date: 2024-12-26 11:11:52 Duration: 28ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1198);

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

7

744,083

Details

2m12s

0ms

43ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 26	00	7,591	1s437ms	0ms
	01	8,273	1s676ms	0ms
	02	8,677	1s859ms	0ms
	03	8,332	1s731ms	0ms
	04	7,791	1s740ms	0ms
	05	6,134	1s241ms	0ms
	06	11,310	1s869ms	0ms
	07	10,092	1s660ms	0ms
	08	19,103	2s869ms	0ms
	09	51,021	8s478ms	0ms
	10	62,975	10s357ms	0ms
	11	71,314	13s797ms	0ms
	12	67,949	11s327ms	0ms
	13	61,580	10s182ms	0ms
	14	63,287	11s439ms	0ms
	15	57,232	9s968ms	0ms
	16	53,329	9s135ms	0ms
	17	50,228	8s812ms	0ms
	18	37,731	7s	0ms
	19	27,657	5s339ms	0ms
	20	22,320	4s975ms	0ms
	21	17,539	3s852ms	0ms
	22	12,618	2s138ms	0ms

COMMIT;

Date: 2024-12-26 16:42:23 Duration: 43ms
COMMIT;

Date: 2024-12-26 15:36:22 Duration: 39ms
COMMIT;

Date: 2024-12-26 11:17:58 Duration: 38ms

8

587,039

Details

1m18s

0ms

12ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 26	00	7,391	806ms	0ms
	01	6,329	747ms	0ms
	02	5,428	649ms	0ms
	03	5,403	634ms	0ms
	04	6,048	674ms	0ms
	05	4,149	558ms	0ms
	06	7,268	880ms	0ms
	07	6,555	826ms	0ms
	08	12,686	1s508ms	0ms
	09	39,944	5s257ms	0ms
	10	49,789	6s577ms	0ms
	11	55,465	8s432ms	0ms
	12	55,054	7s982ms	0ms
	13	49,262	6s507ms	0ms
	14	48,187	6s987ms	0ms
	15	44,549	5s815ms	0ms
	16	39,303	5s619ms	0ms
	17	39,678	4s932ms	0ms
	18	35,015	4s308ms	0ms
	19	25,101	3s75ms	0ms
	20	18,662	2s698ms	0ms
	21	16,135	1s984ms	0ms
	22	9,638	1s56ms	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 (5445245, 5435618, 5101193, 5407485, 5099401, 5422590, 5099140, 5108493, 5099200, 5099130, 5099009, 5106611, 5099129, 5099014, 5316725, 5099499, 5370977, 5099251, 5125556, 5099128, 5104510, 5099202, 5099798, 5445434, 5439177, 5099693, 5115311, 5100514, 5099500, 5099206, 5443222, 5099497, 5102053, 5099873, 5111981, 5108635, 5422583, 5129398, 5230129, 5103065, 5099117, 5099006, 5100772, 5442417, 5099027, 5099105, 5427297, 5099434, 5099103, 5099678, 5228947, 5100129, 5100443, 5100729, 5100207, 5099159, 5100607, 5102186, 5103352, 5116743, 5446692, 5441108, 5099445, 5448582, 5317497, 5099092, 5108871, 5110354, 5165545, 5170515, 5100148, 5184426, 5427925, 5317499, 5104138, 5231016, 5230160, 5252953, 5103370, 5264020, 5293215, 5445250, 5104912, 5107276, 5099008, 5342585, 5448961, 5099573, 5099921, 5100952, 5100842, 5099013, 5102276, 5439145, 5129096, 5099095, 5440720, 5108594, 5267828, 5111365, 5100477, 5101020, 5106226, 5107369, 5099254, 5099007, 5100881, 5361929, 5099003, 5099914, 5432151, 5099149, 5099169, 5099022, 5099277, 5338838, 5099010, 5103478, 5099035, 5210313, 5099525, 5099138, 5265116, 5314795, 5099223, 5100911, 5446786, 5108399, 5435162, 5099236, 5435163, 5099285, 5099045, 5099024);

Date: 2024-12-26 17:21:55 Duration: 12ms
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 (5100070, 5105205, 5103981, 5099321, 5099095, 5101324, 5101539, 5099995, 5099141, 5324943, 5100883, 5099027, 5196392, 5099415, 5106283, 5099598, 5099009, 5099045, 5099144, 5208811, 5099523, 5356793, 5450483, 5099089, 5099224, 5099010, 5099474, 5450341, 5153796, 5374440, 5099035, 5099094, 5450112, 5309185, 5100919, 5099013, 5099590, 5440989, 5099572, 5118828, 5099158, 5099924, 5108260, 5099767, 5101246, 5099014, 5101461, 5102966, 5100540, 5100386, 5124807, 5128960, 5101470, 5099120, 5100148, 5109169, 5099433, 5099630, 5102345, 5099513, 5099103, 5099007, 5101493, 5104872, 5106172, 5099102, 5102921, 5120099, 5099090, 5100827, 5104897, 5100981, 5233325, 5099639, 5116980, 5099282, 5103426, 5100902);

Date: 2024-12-26 17:21:55 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5289990, 5104692, 5099648, 5118354, 5106960, 5124557, 5112160, 5310986, 5207113, 5101010, 5107659, 5110784, 5099258, 5119979, 5103166, 5248852, 5099111, 5100827, 5114879, 5109066, 5099967, 5108142, 5178676, 5112036, 5142955, 5111876, 5105117, 5099761, 5446568, 5099404, 5446690, 5446691, 5127194, 5129217, 5264019, 5427242, 5114481, 5108851, 5111521, 5110435, 5099699, 5099671, 5406080, 5447018, 5127908, 5101920, 5445380, 5440719, 5261751, 5176256, 5101027, 5103898, 5101884, 5099290, 5440723, 5120208, 5107846, 5099102, 5099141, 5100927, 5107009, 5267316, 5121073, 5427227, 5099119, 5445244, 5435155, 5435161, 5099924, 5443887);

Date: 2024-12-26 17:21:55 Duration: 5ms

9

580,924

Details

38s96ms

0ms

13ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 26	00	5,668	303ms	0ms
	01	5,189	297ms	0ms
	02	4,657	259ms	0ms
	03	4,221	222ms	0ms
	04	4,285	229ms	0ms
	05	3,339	172ms	0ms
	06	6,869	361ms	0ms
	07	6,599	376ms	0ms
	08	13,325	750ms	0ms
	09	39,531	2s459ms	0ms
	10	48,630	3s71ms	0ms
	11	56,160	4s327ms	0ms
	12	53,338	3s559ms	0ms
	13	48,807	3s79ms	0ms
	14	48,627	3s382ms	0ms
	15	45,766	2s863ms	0ms
	16	42,410	3s62ms	0ms
	17	42,010	2s615ms	0ms
	18	32,876	2s124ms	0ms
	19	23,686	1s601ms	0ms
	20	18,573	1s393ms	0ms
	21	15,139	962ms	0ms
	22	11,219	617ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 9, 2, 5, 26, 71, 36, 73, 3, 28, 8, 27, 7, 1, 78, 16, 6, 19, 65, 64, 24);

Date: 2024-12-26 12:07:38 Duration: 13ms
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);

Date: 2024-12-26 17:21:55 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 (111);

Date: 2024-12-26 17:21:55 Duration: 1ms

10

404,020

Details

1m15s

0ms

10ms

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3,586	584ms	0ms
	01	3,234	556ms	0ms
	02	2,850	487ms	0ms
	03	2,542	450ms	0ms
	04	2,601	477ms	0ms
	05	1,893	340ms	0ms
	06	4,586	771ms	0ms
	07	4,956	796ms	0ms
	08	11,207	1s733ms	0ms
	09	28,097	4s997ms	0ms
	10	35,119	6s347ms	0ms
	11	40,463	8s447ms	0ms
	12	38,448	7s98ms	0ms
	13	34,800	6s155ms	0ms
	14	36,018	6s850ms	0ms
	15	33,216	5s800ms	0ms
	16	30,942	5s925ms	0ms
	17	29,189	5s450ms	0ms
	18	20,320	3s887ms	0ms
	19	13,940	2s763ms	0ms
	20	10,417	2s285ms	0ms
	21	8,465	1s692ms	0ms
	22	7,131	1s278ms	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 (8004688);

Date: 2024-12-26 17:21:55 Duration: 10ms
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 (8004688);

Date: 2024-12-26 17:21:55 Duration: 10ms
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 (8004719);

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

11

403,361

Details

2m13s

0ms

3ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3,181	891ms	0ms
	01	3,040	932ms	0ms
	02	2,262	711ms	0ms
	03	1,312	426ms	0ms
	04	1,093	356ms	0ms
	05	624	205ms	0ms
	06	1,934	597ms	0ms
	07	2,326	717ms	0ms
	08	10,383	3s18ms	0ms
	09	22,916	7s483ms	0ms
	10	29,681	9s733ms	0ms
	11	47,454	16s858ms	0ms
	12	43,667	14s451ms	0ms
	13	35,287	11s162ms	0ms
	14	42,218	14s95ms	0ms
	15	29,884	9s404ms	0ms
	16	38,023	12s844ms	0ms
	17	30,559	10s262ms	0ms
	18	20,516	6s800ms	0ms
	19	15,843	5s334ms	0ms
	20	8,649	3s135ms	0ms
	21	6,403	2s82ms	0ms
	22	6,106	1s835ms	0ms

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

Date: 2024-12-26 17:21:55 Duration: 3ms
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 = 1030) OR r.global) ORDER BY r.id;

Date: 2024-12-26 11:12:17 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.office' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1300) OR r.global) ORDER BY r.id;

Date: 2024-12-26 10:15:05 Duration: 3ms

12

296,613

Details

53s258ms

0ms

5ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 26	00	2,873	398ms	0ms
	01	2,488	360ms	0ms
	02	2,255	296ms	0ms
	03	1,455	186ms	0ms
	04	1,081	141ms	0ms
	05	980	123ms	0ms
	06	2,131	299ms	0ms
	07	2,548	352ms	0ms
	08	9,836	1s446ms	0ms
	09	17,952	3s76ms	0ms
	10	23,428	4s76ms	0ms
	11	34,026	6s919ms	0ms
	12	29,135	5s434ms	0ms
	13	25,137	4s335ms	0ms
	14	31,497	5s924ms	0ms
	15	21,105	3s646ms	0ms
	16	27,232	5s158ms	0ms
	17	20,060	3s728ms	0ms
	18	13,448	2s462ms	0ms
	19	11,216	2s46ms	0ms
	20	7,028	1s298ms	0ms
	21	4,892	797ms	0ms
	22	4,810	748ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 884 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_shipping_policy' AND name = 'group_confirm_payment_wizard' AND model = 'res.groups');

Date: 2024-12-26 14:57:12 Duration: 5ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-26 14:45:24 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 961 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_allow_export' AND model = 'res.groups');

Date: 2024-12-26 15:31:43 Duration: 1ms

13

270,597

Details

1m8s

0ms

20ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3,408	816ms	0ms
	01	2,825	671ms	0ms
	02	2,379	595ms	0ms
	03	2,511	638ms	0ms
	04	3,064	765ms	0ms
	05	1,520	488ms	0ms
	06	3,094	836ms	0ms
	07	2,894	793ms	0ms
	08	5,587	1s465ms	0ms
	09	16,217	4s329ms	0ms
	10	21,259	5s161ms	0ms
	11	23,773	6s787ms	0ms
	12	23,913	6s50ms	0ms
	13	21,963	5s74ms	0ms
	14	22,815	5s770ms	0ms
	15	21,602	5s6ms	0ms
	16	19,204	4s920ms	0ms
	17	18,287	4s501ms	0ms
	18	17,606	4s71ms	0ms
	19	13,449	3s338ms	0ms
	20	9,758	2s711ms	0ms
	21	8,095	2s139ms	0ms
	22	5,374	1s290ms	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 (41626016, 41623183, 41813120, 41845345, 41778865, 41778910, 41769503, 41079591, 41740787, 41774792, 41632350, 41712664, 41663219, 41451299, 41758585, 41689039, 41784927, 41795496, 41781503, 41472812, 41784892, 41784784, 41786982, 41290327, 41734825, 41712072, 41712066, 41768727, 41628626, 41628597, 41694293, 41673777, 41722186, 41730098, 41768811, 41782566, 41757725, 41698997, 41663272, 41562061, 41784707, 41188144, 41739270, 32630877, 41756942, 41768394, 41603528, 41697216, 41735074, 41689502, 41261797, 41701909, 41462422, 41666280, 41691114, 41316992, 41510270, 41604195, 41665586, 41678605, 41633173, 41639924, 41665394, 41574148, 41646157, 40265739, 41630125, 41654271, 41441153, 41501168, 41550971, 41445085, 41638343, 41566830, 41496858, 41283306, 41573651, 41392957, 41532457, 41133944, 41507447, 41412417, 41191835, 41373117, 41282751, 41282223, 41439194, 41416719, 41133943, 41372001, 41137220, 41371411, 41246259, 41195830, 41195829, 40892454, 41019579);

Date: 2024-12-26 17:21:55 Duration: 20ms
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 (41742821, 41810542, 41436253, 41495877, 41631325, 40630539, 41782555, 41781251, 41793801, 41780935, 41769280, 41758309, 41495811, 41781938, 41780910, 41780694, 41758291, 41758059, 41829396, 41780394, 41757942, 41758405, 41657556, 41755239, 41607295, 41768117, 41296957, 41600286, 41780333, 41684243, 41802181, 41740806, 41725075, 41691930, 41691929, 41687815, 41718083, 41628586, 41669956, 41667321, 41633327, 41657490, 41672670, 41129614, 41739261, 41562921, 41661203, 41503019, 32640817, 41565830, 41626100, 41643617, 41708242, 41707823, 41731124, 41507743, 41656330, 41768327, 41705298, 41669155, 41524246, 41698704, 41606317, 41727826, 41727824, 41613185, 41651704, 41741255, 41328928, 41768545, 41589182, 41510003, 41668045, 41650679, 41663203, 41714576, 41530148, 41599989, 41613277, 41584332, 41718177, 41616900, 41633227, 41628185, 41691796, 41672166, 41720353, 41720356, 41728167, 41666239, 41748298, 41016226, 41724628, 41786496, 41735098, 41689512, 40616131, 41540078, 41670065, 41695094);

Date: 2024-12-26 17:21:55 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 (39570092, 40246250, 39878822, 39750167, 38557925, 40861792, 41504197, 39417115, 39641987, 39423184, 39853805, 39769815, 39742445, 40012072, 41504196, 40967206, 39956348, 39856944, 40246284, 39613497, 37644384, 39791280, 39931878, 32589166, 32595766, 39641907, 38977619, 39956369, 39684909, 39684974, 39668685, 39918468, 39932363, 39379175, 39684886, 39742084, 40144841, 39665142, 39741853, 38937732, 39804003, 39475572, 32583155, 39609713, 39609725, 39511332, 39641662, 39791498, 39208991, 38945533, 39756342, 39571782, 39571786, 39571785, 39774217, 39571797, 39571791, 39571798, 39571801, 39541885, 39202877, 39762561, 39846776, 39753143, 40305648, 39837868, 39621889, 40389462, 39779282, 39746800, 39631056, 38977310, 39458317, 38534880, 39754866, 39754865, 32592497, 39615320, 39264566, 39680125, 39622687, 39838379, 39593816, 39734712, 39838378, 39833141, 39612041, 39371966, 39547073, 39587775, 39708246, 39188327, 39708247, 39778696, 39839488, 39807945, 39441264, 39778783, 39735525, 39559983);

Date: 2024-12-26 17:21:56 Duration: 16ms

14

270,309

Details

1d12h3m54s

380ms

4s501ms

480ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 26	00	5,912	45m33s	462ms
	01	7,104	53m34s	452ms
	02	7,307	54m41s	449ms
	03	6,885	52m17s	455ms
	04	7,967	1h41s	457ms
	05	5,220	38m37s	443ms
	06	6,406	48m30s	454ms
	07	6,083	45m54s	452ms
	08	5,439	41m21s	456ms
	09	14,242	1h53m42s	479ms
	10	14,074	1h53m16s	482ms
	11	19,766	2h54m27s	529ms
	12	15,030	2h17s	480ms
	13	10,205	1h20m36s	473ms
	14	14,527	2h1m13s	500ms
	15	13,533	1h47m24s	476ms
	16	18,037	2h30m52s	501ms
	17	14,175	1h53m18s	479ms
	18	15,267	2h3m6s	483ms
	19	15,233	2h2m4s	480ms
	20	17,965	2h30m49s	503ms
	21	22,154	2h51m54s	465ms
	22	7,778	59m39s	460ms

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

Date: 2024-12-26 20:32:18 Duration: 4s501ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974187)) AND (("shipping_track"."id" not in (32411060, 32411060)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:30:13 Duration: 4s222ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974096)) AND (("shipping_track"."id" not in (32410915, 32410915)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:28:52 Duration: 4s139ms

15

201,723

Details

16s380ms

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 26	00	2,036	144ms	0ms
	01	1,860	152ms	0ms
	02	1,638	134ms	0ms
	03	1,550	128ms	0ms
	04	1,606	137ms	0ms
	05	1,366	102ms	0ms
	06	2,348	193ms	0ms
	07	2,162	174ms	0ms
	08	4,355	326ms	0ms
	09	14,017	1s313ms	0ms
	10	18,159	1s649ms	0ms
	11	20,163	1s654ms	0ms
	12	19,941	1s437ms	0ms
	13	18,287	1s324ms	0ms
	14	17,480	1s503ms	0ms
	15	15,983	1s323ms	0ms
	16	13,824	992ms	0ms
	17	13,628	948ms	0ms
	18	10,973	899ms	0ms
	19	7,171	730ms	0ms
	20	5,598	590ms	0ms
	21	4,680	327ms	0ms
	22	2,898	188ms	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-26 17:21:55 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

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

Date: 2024-12-26 17:21:55 Duration: 1ms

16

174,757

Details

10s321ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 26	00	1,388	66ms	0ms
	01	1,355	69ms	0ms
	02	890	46ms	0ms
	03	466	23ms	0ms
	04	411	21ms	0ms
	05	236	12ms	0ms
	06	866	45ms	0ms
	07	943	48ms	0ms
	08	4,864	248ms	0ms
	09	9,726	558ms	0ms
	10	13,032	755ms	0ms
	11	20,414	1s343ms	0ms
	12	18,827	1s116ms	0ms
	13	15,164	843ms	0ms
	14	18,584	1s118ms	0ms
	15	13,000	725ms	0ms
	16	17,261	1s61ms	0ms
	17	12,945	776ms	0ms
	18	8,664	508ms	0ms
	19	6,834	412ms	0ms
	20	3,668	233ms	0ms
	21	2,577	145ms	0ms
	22	2,642	140ms	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-26 12:36:55 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 (2, 10);

Date: 2024-12-26 21:51:52 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-26 15:31:18 Duration: 0ms

17

168,818

Details

21s172ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 26	00	1,353	137ms	0ms
	01	1,340	145ms	0ms
	02	884	96ms	0ms
	03	459	49ms	0ms
	04	411	45ms	0ms
	05	236	25ms	0ms
	06	834	93ms	0ms
	07	929	102ms	0ms
	08	4,755	506ms	0ms
	09	9,578	1s164ms	0ms
	10	12,689	1s553ms	0ms
	11	19,743	2s803ms	0ms
	12	18,234	2s280ms	0ms
	13	14,626	1s712ms	0ms
	14	17,755	2s280ms	0ms
	15	12,461	1s468ms	0ms
	16	16,633	2s190ms	0ms
	17	12,527	1s597ms	0ms
	18	8,308	1s30ms	0ms
	19	6,611	841ms	0ms
	20	3,492	475ms	0ms
	21	2,365	283ms	0ms
	22	2,595	289ms	0ms

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

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

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

Date: 2024-12-26 15:08:12 Duration: 1ms

18

168,656

Details

1m37s

0ms

24ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 26	00	275	149ms	0ms
	01	428	218ms	0ms
	02	332	164ms	0ms
	03	408	184ms	0ms
	04	674	307ms	0ms
	05	156	87ms	0ms
	06	830	333ms	0ms
	07	2,514	1s48ms	0ms
	08	1,927	993ms	0ms
	09	7,480	4s178ms	0ms
	10	10,200	6s137ms	0ms
	11	16,026	9s605ms	0ms
	12	11,996	8s799ms	0ms
	13	13,873	8s909ms	0ms
	14	14,356	8s958ms	0ms
	15	11,540	7s145ms	0ms
	16	9,772	6s449ms	0ms
	17	7,617	4s147ms	0ms
	18	7,305	4s224ms	0ms
	19	6,991	3s613ms	0ms
	20	23,187	12s332ms	0ms
	21	18,079	7s853ms	0ms
	22	2,690	1s241ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3826941, 3636384, 591060, 3176783, 2739596, 3405937, 2966672, 3518745, 3124358, 2739592, 2785166, 3374683, 3602690, 3856739, 3891442, 3856415, 3831648, 3890496, 3518746, 3349864, 3518748, 3889283, 3787062, 3856732, 3828844, 3706842, 3889364, 3737385, 3826933, 3737384, 3737382, 3826985, 3837080, 3786090, 3786089, 3890208, 3837100, 3405471, 3405470, 3405889, 3889286, 3856397, 3786068, 3770718, 3786066, 3770713, 3770720, 3865160, 3739512, 3481392, 3481159, 2938714, 3857864, 3739518, 3854556, 3567690, 3567691, 3419696, 3856425, 3856422, 3856426, 3856427, 3856429, 3856428, 3745080, 3786065, 3889319, 3896944, 3889340, 3889338, 3889344, 3889317, 3670301, 3896946, 3566983, 3889341, 3889321, 3889316, 3889313, 3705615, 3896974, 3705616, 3896949, 1184371, 1183899, 3826976, 3826977, 3896952, 3826973, 3571301, 3895734, 3786050, 3895731, 3895737, 3786788, 3786789, 3889327, 3630185, 3737403, 3287719, 3898614, 3582560, 3861448, 3706057, 3636405, 3828236, 3737398, 3670312, 3786070, 3670313, 3442148, 3861445, 3896957, 3567704, 3895721, 3571299, 3038241, 3791250, 3672693, 3889295, 1005997, 3571277, 3826955, 3828848, 3739513, 3739515, 3737404, 2095722, 3518742, 3630164, 3516330, 3705601, 3861442, 3177183, 3831654, 3889287, 3480397, 3705578, 3826935, 3857872, 3857871, 3857870, 3630136, 3857865, 3630175, 3630176, 3630177, 2919796, 2919794, 2940590, 3797996);

Date: 2024-12-26 17:21:55 Duration: 24ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3767518, 3825923, 3823009, 3507616, 3438755, 3757714, 3719587, 3757763, 3822307, 3719563, 3744196, 3783428, 3667123, 3818317, 3823000, 3825072, 3856562, 3744194, 3850612, 3515430, 3826073, 3850611, 3850614, 3767576, 3744184, 3823735, 3620921, 3852254, 3766433, 3854232, 3854026, 3854271, 3854203, 3822836, 3867726, 2990644, 3764685, 3819212, 3819217, 3826179, 3546557, 3825540, 3626264, 3718968, 3825915, 3825919, 3853175, 3524980, 3853166, 3823734, 3853163, 3736484, 3477748, 3736452, 3856329, 3767301, 3735324, 3759178, 3550364, 3783421, 3766732, 3625778, 3660831, 3737478, 3802361, 3822543, 3813061, 3822835, 3816635, 3805894, 3767984, 3822577, 3783177, 3499971, 3822291, 3822621, 3822564, 3825962, 3822809, 3762356, 3768235, 3824495, 3764769, 3781527, 3512088, 3546642, 3823783, 3823298, 3767594, 3764725, 3823750, 3702960, 3823306, 3805996, 3757667, 3813301, 3782742, 3666311, 3683263, 3475435, 3825205, 3764687, 3728335, 3469165, 3683262, 3579540, 3764747, 3626079, 3765734, 3744198, 3703914, 3766341, 3768028, 3737472, 3666939, 3765737, 3681917, 3768135, 3718967, 3744190, 3735839, 3598923, 3767988, 3767213, 3766715, 3764797, 3783075, 3798346, 3719559, 3683257, 3767006, 3702924, 3703458, 3783455, 2927029, 3666607, 3669422, 3704101, 3550077, 3629647, 3735763, 3767781, 3767932, 3758978, 3632004, 3759098, 3247753, 3736765, 3736779, 3763051, 3624954, 3719062, 3704246, 3550218, 3625733, 3440267, 3736197, 3667960, 2686103, 3703808, 3368133, 3736196, 3600991, 3732687, 3599155, 3703870, 3734373, 3499657, 3667902, 3667906, 3702641, 3681908, 3625835, 3703801, 3702379, 3703968, 3681843, 3652072, 3704596, 3702646, 3600160, 3668396, 3626075, 3667067, 3537560, 3703247, 3627351, 3473049, 3701188, 3630074, 3699477, 3547839, 3652132, 3716876, 3630067, 3703960, 3652078, 3629860, 3600922, 3626301, 3625000, 3600077, 3701186, 3634040, 3594813, 3667393, 3627414, 3565890, 3706587, 3623869, 3627336, 3666949, 3626558, 3305206, 3651895, 3652374, 3668364, 3499873, 3305196, 3627047, 3630045, 3662105, 3439027, 3285205, 3666926, 3589912, 3547841, 3625478, 3625252, 3621130, 3548297, 3652101, 3629631, 3670134, 3629855, 3626858, 3629649, 3547836, 3625562, 3565862, 3600281, 3589907, 3601384, 3631325, 3629914, 3655738, 3547834, 3627322, 3627271, 3630046, 3592774, 3547835, 3548753, 3625461, 3547831, 3626285, 3441416, 3589909, 3631333, 3601311, 3549412, 3546562, 3479820, 3604470, 3601448, 3603066, 3589910, 3525226, 3601479, 3549763, 3547829, 3547837, 3566096, 3600432, 3514046, 3514396, 3547843, 3549409, 3512302, 3525198, 3549130, 3547842, 3515326, 3547833, 3563970, 3547827, 3547832, 3547826, 3549548, 3174308, 3549734, 3515217, 3547830, 3566106, 3547776, 3547838, 3513215, 3502810, 3525195, 3514277, 3549324, 3479781, 3514063, 3547779, 3479174, 3477243, 3512300, 3512295, 3479287, 3402655, 3512625, 3512436, 3284517, 3507913, 3513094, 2994820, 2994847, 3240173, 3479400, 3477968, 3479715, 3479381, 3479373, 3479109, 3479114, 2938876, 3432783, 3317621, 3316669, 3400991, 2654239, 3316210, 3316986, 3313400, 3276431, 3276432, 3314903, 3137692, 3058713, 2975403, 2998291, 2998826, 2964473, 2937500, 2888850, 2881619, 2881615, 2880861, 2880476);

Date: 2024-12-26 13:42:20 Duration: 19ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3900668, 3722301, 3907742, 3917285, 3837534, 3867639, 3922157, 3906979, 3882472, 3915502, 3851078, 3918092, 3848084, 3873805, 3874861, 3880814, 3894552, 3902157, 3884821, 3917638, 3860664, 3869857, 3917996, 3856449, 3880883, 3874568, 3868594, 3894648, 3909947, 3881204, 3884631, 3863487, 3888414, 3874957, 3908911, 3899115, 3899131, 3863110, 3861060, 3905515, 3905664, 3909862, 3885603, 3885482, 3880836, 3904223, 3862797, 3907572, 3913900, 3909362, 3882578, 3910611, 3877271, 3901862, 3879869, 3899453, 3903785, 3922165, 3904784, 3893559, 3893489, 3911084, 3918066, 3897458, 3902095, 3894729, 3894862, 3875209, 3487868, 3891278, 3869700, 3861362, 3904392, 3903947, 3890299, 3829232, 3894483, 3896772, 3898179, 3891822, 3906072, 3861282, 3902102, 3900347, 3924047, 3891324, 3902742, 3859883, 3861291, 3860368, 3892683, 3907151, 3889492, 3907196, 3906943, 3891341, 3895730, 3896284, 3914089, 3921243, 3864727, 3915356, 3917318, 3904359, 3908905, 3877281, 3901360, 3904738, 3885602, 3892928, 3841607, 3840125, 3884731, 3917935, 3907134, 3872037, 3885597, 3878947, 3868768, 3868987, 3898848, 3911151, 3924056, 3894662, 3890154, 3895172, 3864999, 3902116, 3869480, 3870514, 3905412, 3862898);

Date: 2024-12-26 12:41:43 Duration: 17ms

19

165,872

Details

1h51m5s

29ms

247ms

40ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3,063	1m54s	37ms
	01	2,643	1m38s	37ms
	02	2,674	1m39s	37ms
	03	1,885	1m10s	37ms
	04	3,079	1m54s	37ms
	05	1,694	1m3s	37ms
	06	2,490	1m33s	37ms
	07	1,931	1m12s	37ms
	08	2,724	1m41s	37ms
	09	9,366	6m13s	39ms
	10	10,853	7m17s	40ms
	11	16,759	12m14s	43ms
	12	11,814	7m51s	39ms
	13	8,520	5m35s	39ms
	14	12,093	8m15s	40ms
	15	11,277	7m24s	39ms
	16	15,740	10m42s	40ms
	17	9,905	6m38s	40ms
	18	9,532	6m25s	40ms
	19	8,925	5m56s	39ms
	20	8,360	5m51s	42ms
	21	6,007	3m56s	39ms
	22	4,538	2m55s	38ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3894430, 3874753)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 11:10:32 Duration: 247ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3974052)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:32:04 Duration: 211ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3907187)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:24:59 Duration: 209ms

20

149,042

Details

30s857ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 26	00	1,158	203ms	0ms
	01	1,180	214ms	0ms
	02	796	147ms	0ms
	03	482	89ms	0ms
	04	460	87ms	0ms
	05	289	53ms	0ms
	06	837	156ms	0ms
	07	851	159ms	0ms
	08	4,086	750ms	0ms
	09	8,860	1s792ms	0ms
	10	11,582	2s354ms	0ms
	11	17,557	3s859ms	0ms
	12	16,092	3s320ms	0ms
	13	12,701	2s499ms	0ms
	14	15,239	3s198ms	0ms
	15	11,096	2s189ms	0ms
	16	13,962	2s973ms	0ms
	17	10,762	2s294ms	0ms
	18	7,359	1s559ms	0ms
	19	5,842	1s262ms	0ms
	20	3,309	775ms	0ms
	21	2,344	485ms	0ms
	22	2,198	429ms	0ms

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

Date: 2024-12-26 17:21:55 Duration: 1ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1030) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

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

Date: 2024-12-26 20:24:21 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

51m5s

1m10s

49

Details

57m38s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 26	08	2	2ms	1ms
	09	3	2ms	0ms
	10	11	6m32s	35s714ms
	11	6	10ms	1ms
	12	4	6ms	1ms
	13	4	3ms	0ms
	14	4	6ms	1ms
	15	1	1ms	1ms
	16	1	1ms	1ms
	17	1	1ms	1ms
	18	4	5ms	1ms
	19	2	2ms	1ms
	20	2	2ms	1ms
	21	3	2ms	0ms
	22	1	51m5s	51m5s

UPDATE "res_users" SET "exp_date" = '2024-12-26 21:29:15.349827', "last_update" = '2024-12-26 20:44:15.349847', "write_date" = '2024-12-26 20:44:15.028108', "write_uid" = 1223 WHERE id IN (1223);

Date: 2024-12-26 22:35:20 Duration: 51m5s
UPDATE "res_users" SET "exp_date" = '2024-12-26 10:35:48.379405', "last_update" = '2024-12-26 09:50:48.379430', "write_date" = '2024-12-26 09:50:48.003933', "write_uid" = 1 WHERE id IN (1292);

Date: 2024-12-26 10:57:21 Duration: 6m32s
UPDATE "res_users" SET "exp_date" = '2024-12-26 10:37:18.903774', "last_update" = '2024-12-26 09:52:18.903806', "write_date" = '2024-12-26 09:52:18.416374', "write_uid" = 1 WHERE id IN (866);

Date: 2024-12-26 10:52:18 Duration: 3ms

2

0ms

29m57s

32s806ms

391

Details

3h33m47s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 26	00	7	29m57s	4m16s
	01	4	1ms	0ms
	02	1	0ms	0ms
	03	2	0ms	0ms
	04	1	0ms	0ms
	06	5	0ms	0ms
	07	3	0ms	0ms
	08	23	24m52s	1m4s
	09	28	16ms	0ms
	10	35	7m49s	13s418ms
	11	41	29m43s	43s496ms
	12	29	1m3s	2s204ms
	13	25	14m32s	34s909ms
	14	38	3m59s	6s310ms
	15	26	22m53s	52s825ms
	16	38	24m9s	38s153ms
	17	20	28ms	1ms
	18	22	9m31s	25s991ms
	19	11	14ms	1ms
	20	8	8ms	1ms
	21	15	6ms	0ms
	22	9	45m12s	5m1s

UPDATE "res_users" SET "exp_date" = '2024-12-26 00:12:52.842104', "last_update" = '2024-12-25 23:27:52.842128', "sid" = 'eb92e49f2b309acd9c3ade111f236f2f27104228', "write_date" = '2024-12-25 23:27:52.517934', "write_uid" = 1 WHERE id IN (823);

Date: 2024-12-26 00:57:50 Duration: 29m57s
UPDATE "res_users" SET "exp_date" = '2024-12-26 15:59:57.069700', "last_update" = '2024-12-26 15:14:57.069723', "sid" = 'd0a2b79be8f21005f1a9c1a9c28db8fdec4c34bd', "write_date" = '2024-12-26 15:14:56.716187', "write_uid" = 1 WHERE id IN (1049);

Date: 2024-12-26 16:34:20 Duration: 19m23s
UPDATE "res_users" SET "exp_date" = '2024-12-26 14:57:11.766861', "last_update" = '2024-12-26 14:12:11.766886', "sid" = '1b5da9ce4182dc7e251104a701f1182913bd6ab0', "write_date" = '2024-12-26 14:12:11.403872', "write_uid" = 1 WHERE id IN (853);

Date: 2024-12-26 15:28:20 Duration: 16m8s

3

0ms

48m37s

3s223ms

86,557

Details

3d5h30m57s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 26	00	673	146ms	0ms
	01	800	169ms	0ms
	02	845	178ms	0ms
	03	700	145ms	0ms
	04	740	156ms	0ms
	05	553	113ms	0ms
	06	836	177ms	0ms
	07	747	157ms	0ms
	08	2,138	5h27m25s	9s188ms
	09	5,556	3h40m22s	2s379ms
	10	7,102	6h18m52s	3s200ms
	11	9,087	5h58m32s	2s367ms
	12	8,060	5h15m11s	2s346ms
	13	8,454	8h30m10s	3s620ms
	14	8,280	9h20m36s	4s62ms
	15	7,943	14h17m50s	6s479ms
	16	6,665	5h11m26s	2s803ms
	17	5,739	1h50m55s	1s159ms
	18	3,765	6h41m10s	6s393ms
	19	2,914	1m50s	38ms
	20	2,280	9m55s	261ms
	21	1,678	1m13s	43ms
	22	1,002	4h45m21s	17s87ms

update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:46:43.545084', exp_date = '2024-12-26 21:31:43.545088', logged_in = 'TRUE' where id = 1223;

Date: 2024-12-26 22:35:20 Duration: 48m37s
update res_users set sid = 'cca7c12dcc9b8f4154c3a1dd29874f2ca1fae238', last_update = '2024-12-26 20:52:15.735253', exp_date = '2024-12-26 21:37:15.735257', logged_in = 'TRUE' where id = 1223;

Date: 2024-12-26 22:35:20 Duration: 43m5s
update res_users set sid = '5b1bf6eff598501698ad033d9015650f010512d0', last_update = '2024-12-26 16:42:38.645720', exp_date = '2024-12-26 17:27:38.645723', logged_in = 'TRUE' where id = 870;

Date: 2024-12-26 18:17:21 Duration: 34m42s

4

237ms

2s231ms

886ms

9,828

Details

2h25m13s

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 26	00	503	6m19s	754ms
	01	162	2m28s	915ms
	02	555	5m52s	635ms
	03	98	1m30s	924ms
	09	44	45s206ms	1s27ms
	10	31	31s164ms	1s5ms
	11	47	54s749ms	1s164ms
	12	70	1m14s	1s70ms
	13	107	1m49s	1s27ms
	14	306	5m9s	1s12ms
	15	49	50s127ms	1s23ms
	16	407	7m	1s33ms
	17	547	9m51s	1s81ms
	18	1,339	21m39s	970ms
	19	2,943	35m35s	725ms
	20	707	11m59s	1s18ms
	21	1,023	16m45s	982ms
	22	890	14m54s	1s4ms

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

Date: 2024-12-26 20:24:57 Duration: 2s231ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9614324')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-26 20:31:35 Duration: 1s982ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9457542')) 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 (52))))))) 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 (52)))))) 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 (52)))))) 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 (52))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-26 20:31:40 Duration: 1s961ms

5

377ms

3s499ms

490ms

49,854

Details

6h47m27s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 26	00	225	1m49s	487ms
	01	206	1m41s	491ms
	02	248	2m1s	488ms
	03	298	2m22s	479ms
	04	344	2m43s	476ms
	05	157	1m17s	495ms
	06	331	2m38s	479ms
	07	575	4m25s	461ms
	08	1,034	7m54s	458ms
	09	3,656	29m39s	486ms
	10	3,222	26m52s	500ms
	11	4,188	38m2s	545ms
	12	3,774	31m11s	495ms
	13	3,425	27m46s	486ms
	14	4,548	38m22s	506ms
	15	4,563	36m31s	480ms
	16	3,911	33m8s	508ms
	17	4,294	34m10s	477ms
	18	3,253	25m19s	467ms
	19	2,958	22m42s	460ms
	20	1,983	16m26s	497ms
	21	1,553	12m3s	466ms
	22	1,108	8m13s	445ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3921141, 3919326, 3919235, 3915234, 3913715, 3913373, 3913340, 3912771, 3912298, 3910506, 3907634, 3907455, 3907409, 3906288, 3904453, 3904324, 3904175, 3901451, 3901179, 3901142, 3900936, 3899738, 3898207, 3897761, 3896422, 3896203, 3895497, 3891784, 3886581, 3883001, 3840079)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 11:10:30 Duration: 3s499ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3952415)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:30:11 Duration: 3s85ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3936881)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:31:55 Duration: 2s890ms

6

380ms

4s501ms

480ms

270,309

Details

1d12h3m54s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 26	00	5,912	45m33s	462ms
	01	7,104	53m34s	452ms
	02	7,307	54m41s	449ms
	03	6,885	52m17s	455ms
	04	7,967	1h41s	457ms
	05	5,220	38m37s	443ms
	06	6,406	48m30s	454ms
	07	6,083	45m54s	452ms
	08	5,439	41m21s	456ms
	09	14,242	1h53m42s	479ms
	10	14,074	1h53m16s	482ms
	11	19,766	2h54m27s	529ms
	12	15,030	2h17s	480ms
	13	10,205	1h20m36s	473ms
	14	14,527	2h1m13s	500ms
	15	13,533	1h47m24s	476ms
	16	18,037	2h30m52s	501ms
	17	14,175	1h53m18s	479ms
	18	15,267	2h3m6s	483ms
	19	15,233	2h2m4s	480ms
	20	17,965	2h30m49s	503ms
	21	22,154	2h51m54s	465ms
	22	7,778	59m39s	460ms

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

Date: 2024-12-26 20:32:18 Duration: 4s501ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974187)) AND (("shipping_track"."id" not in (32411060, 32411060)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:30:13 Duration: 4s222ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3974096)) AND (("shipping_track"."id" not in (32410915, 32410915)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-26 20:28:52 Duration: 4s139ms

7

214ms

2s227ms

323ms

20,892

Details

1h52m45s

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 26	00	840	4m4s	290ms
	01	764	3m42s	291ms
	02	141	41s61ms	291ms
	03	782	3m50s	294ms
	04	1,393	6m47s	292ms
	05	137	39s374ms	287ms
	06	647	3m6s	288ms
	07	567	2m43s	288ms
	08	659	3m13s	292ms
	09	103	37s487ms	363ms
	10	248	1m19s	322ms
	11	159	54s375ms	341ms
	12	220	1m11s	323ms
	13	213	1m5s	308ms
	14	574	3m1s	315ms
	15	623	3m21s	323ms
	16	1,162	6m41s	345ms
	17	1,714	9m17s	325ms
	18	2,676	14m46s	331ms
	19	1,874	10m21s	331ms
	20	2,329	14m45s	380ms
	21	1,900	10m32s	333ms
	22	1,167	5m59s	308ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9623174')) 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-26 20:24:59 Duration: 2s227ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9570747')) 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-26 20:31:41 Duration: 2s56ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9474946')) 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-26 20:30:02 Duration: 2s24ms

8

181ms

1s713ms

276ms

28,632

Details

2h12m9s

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 26	07	908	3m46s	249ms
	08	63	17s856ms	283ms
	09	2,304	10m38s	277ms
	10	3,569	15m55s	267ms
	11	3,163	15m22s	291ms
	12	1,540	7m23s	288ms
	13	3,481	15m16s	263ms
	14	4,456	20m59s	282ms
	15	2,539	11m14s	265ms
	16	3,172	14m16s	270ms
	17	902	4m30s	300ms
	18	233	1m13s	316ms
	19	905	3m59s	264ms
	20	1,397	7m13s	310ms

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

Date: 2024-12-26 20:29:23 Duration: 1s713ms
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" = '9522472')))) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:10:45 Duration: 1s636ms
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" = '9361433')))) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:29:29 Duration: 784ms

9

183ms

435ms

271ms

2,700

Details

12m12s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 26	10	396	1m42s	258ms
	11	235	1m7s	286ms
	12	197	50s816ms	257ms
	13	253	1m5s	259ms
	14	219	1m3s	287ms
	15	714	3m9s	264ms
	16	426	1m57s	276ms
	17	260	1m16s	294ms

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

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

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

Date: 2024-12-26 17:24:40 Duration: 415ms

10

17ms

2s913ms

245ms

3,133

Details

12m50s

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3	64ms	21ms
	01	5	1s208ms	241ms
	04	3	1s260ms	420ms
	06	2	814ms	407ms
	07	5	1s38ms	207ms
	08	62	7s501ms	120ms
	09	187	38s592ms	206ms
	10	275	1m4s	233ms
	11	295	1m11s	242ms
	12	438	1m47s	245ms
	13	433	1m44s	241ms
	14	368	1m31s	248ms
	15	288	1m7s	233ms
	16	228	1m6s	291ms
	17	213	57s989ms	272ms
	18	102	32s343ms	317ms
	19	123	22s921ms	186ms
	20	62	24s52ms	387ms
	21	14	4s316ms	308ms
	22	27	5s350ms	198ms

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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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-26 20:29:31 Duration: 2s913ms
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 (30)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) 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-26 11:13:11 Duration: 1s784ms
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 (11)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))) 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-26 11:10:43 Duration: 1s774ms

11

91ms

966ms

240ms

60,720

Details

4h3m27s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 26	00	2,656	9m14s	208ms
	01	1,836	6m40s	217ms
	02	1,380	4m36s	200ms
	03	1,752	6m23s	218ms
	04	2,770	10m37s	230ms
	05	272	1m1s	227ms
	06	1,278	5m12s	244ms
	07	1,126	4m43s	252ms
	08	1,308	5m	229ms
	09	260	53s98ms	204ms
	10	532	1m47s	202ms
	11	404	1m52s	278ms
	12	556	2m20s	253ms
	13	608	2m10s	214ms
	14	1,721	7m5s	247ms
	15	1,327	5m14s	236ms
	16	3,102	13m42s	265ms
	17	4,467	19m11s	257ms
	18	7,966	31m9s	234ms
	19	9,546	37m37s	236ms
	20	6,000	27m17s	272ms
	21	5,807	23m38s	244ms
	22	4,046	15m55s	236ms

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-26 20:30:54 Duration: 966ms
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-26 20:30:54 Duration: 877ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مصنع')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-26 20:42:58 Duration: 864ms

12

169ms

1s707ms

228ms

139,900

Details

8h52m42s

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

Day	Hour	Count	Duration	Avg duration
Dec 26	00	644	2m4s	193ms
	01	1,871	5m58s	191ms
	02	2,267	7m18s	193ms
	03	2,313	7m26s	193ms
	04	1,918	6m8s	192ms
	05	1,545	4m58s	193ms
	06	2,511	8m5s	193ms
	07	5,289	17m16s	195ms
	08	2,461	8m	195ms
	09	9,546	33m45s	212ms
	10	7,255	25m20s	209ms
	11	16,206	1h2m9s	230ms
	12	4,712	16m38s	211ms
	13	8,842	31m9s	211ms
	14	10,306	38m26s	223ms
	15	7,574	26m50s	212ms
	16	6,106	22m21s	219ms
	17	2,702	10m16s	228ms
	18	6,279	26m11s	250ms
	19	8,048	30m46s	229ms
	20	30,465	2h17m51s	271ms
	21	865	3m1s	209ms
	22	175	35s569ms	203ms

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

Date: 2024-12-26 11:10:38 Duration: 1s707ms
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" = '9433562')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-26 11:10:27 Duration: 1s637ms
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" = '9469418')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-26 20:25:04 Duration: 1s633ms

13

177ms

1s105ms

211ms

6,294

Details

22m11s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 26	00	22	4s304ms	195ms
	06	259	50s568ms	195ms
	07	651	2m6s	194ms
	08	292	57s261ms	196ms
	09	2,017	7m7s	212ms
	10	648	2m14s	208ms
	11	285	1m8s	239ms
	12	495	1m44s	210ms
	13	237	48s952ms	206ms
	14	219	50s969ms	232ms
	15	515	1m50s	213ms
	16	336	1m13s	219ms
	17	296	1m8s	232ms
	21	18	3s682ms	204ms
	22	4	830ms	207ms

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

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

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

Date: 2024-12-26 11:10:27 Duration: 380ms

14

170ms

1s108ms

211ms

14,879

Details

52m24s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 26	00	3	582ms	194ms
	01	172	33s5ms	191ms
	02	190	36s735ms	193ms
	03	16	3s23ms	188ms
	04	240	45s985ms	191ms
	05	135	26s584ms	196ms
	06	705	2m17s	195ms
	07	893	2m56s	198ms
	08	1,141	3m40s	193ms
	09	2,900	10m7s	209ms
	10	891	3m4s	206ms
	11	1,689	6m21s	225ms
	12	1,051	3m41s	210ms
	13	660	2m21s	214ms
	14	1,335	4m52s	218ms
	15	661	2m17s	207ms
	16	346	1m16s	222ms
	17	389	1m22s	212ms
	18	427	1m34s	221ms
	19	290	1m2s	213ms
	20	429	1m55s	269ms
	21	145	31s299ms	215ms
	22	171	34s890ms	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" = '9509118')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2024-12-26 20:25:09 Duration: 456ms
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" = '9513841')) 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 (14, 74, 70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (14, 74, 70))))) 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-26 20:29:05 Duration: 456ms

15

173ms

229ms

192ms

10,668

Details

34m14s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 26	00	619	1m59s	193ms
	01	1,581	5m2s	191ms
	02	2,057	6m37s	193ms
	03	2,257	7m14s	192ms
	04	1,164	3m43s	192ms
	05	1,410	4m31s	192ms
	06	1,101	3m32s	192ms
	07	309	1m	194ms
	08	170	32s765ms	192ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9547248')) 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-26 00:04:36 Duration: 229ms
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" = '9499648')) 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-26 02:26:02 Duration: 227ms
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" = '9520569')) 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-26 02:38:27 Duration: 226ms

16

120ms

1s138ms

148ms

6,124

Details

15m8s

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 26	00	30	3s912ms	130ms
	01	10	1s275ms	127ms
	02	6	781ms	130ms
	04	5	653ms	130ms
	07	20	2s646ms	132ms
	08	62	8s333ms	134ms
	09	626	1m28s	140ms
	10	736	1m46s	144ms
	11	1,295	3m32s	164ms
	12	1,072	2m34s	144ms
	13	455	1m4s	141ms
	14	572	1m24s	147ms
	15	289	41s219ms	142ms
	16	291	43s515ms	149ms
	17	277	39s962ms	144ms
	18	102	14s426ms	141ms
	19	59	8s759ms	148ms
	20	99	16s453ms	166ms
	21	94	13s45ms	138ms
	22	24	3s271ms	136ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 64)) 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-26 11:10:44 Duration: 1s138ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 60)) 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-26 20:29:01 Duration: 1s95ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-26 11:17:38 Duration: 1s81ms

17

78ms

679ms

98ms

22,735

Details

37m29s

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 26	02	3	294ms	98ms
	03	23	2s218ms	96ms
	04	17	1s600ms	94ms
	05	4	378ms	94ms
	06	10	956ms	95ms
	07	60	5s716ms	95ms
	08	249	23s459ms	94ms
	09	1,449	2m24s	99ms
	10	2,108	3m28s	98ms
	11	2,268	3m58s	105ms
	12	2,261	3m38s	96ms
	13	2,186	3m29s	95ms
	14	2,782	4m35s	98ms
	15	2,928	4m42s	96ms
	16	1,851	3m9s	102ms
	17	1,125	1m51s	98ms
	18	1,451	2m25s	100ms
	19	768	1m14s	96ms
	20	696	1m9s	100ms
	21	299	30s204ms	101ms
	22	197	18s208ms	92ms

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

Date: 2024-12-26 11:10:31 Duration: 679ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7889180)) AND (("cash_track"."id" not in (6256645)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-26 20:29:38 Duration: 430ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7884908)) AND (("cash_track"."id" not in (6218350)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-26 11:10:28 Duration: 213ms

18

36ms

273ms

49ms

69,827

Details

57m13s

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 26	00	34	1s610ms	47ms
	01	4	188ms	47ms
	02	10	458ms	45ms
	03	11	508ms	46ms
	04	10	462ms	46ms
	05	15	678ms	45ms
	06	11	507ms	46ms
	07	128	5s713ms	44ms
	08	220	10s402ms	47ms
	09	4,638	3m41s	47ms
	10	4,401	3m34s	48ms
	11	10,111	9m1s	53ms
	12	3,227	2m37s	48ms
	13	3,396	2m44s	48ms
	14	6,108	5m13s	51ms
	15	10,142	8m12s	48ms
	16	19,232	15m16s	47ms
	17	3,218	2m32s	47ms
	18	1,960	1m33s	47ms
	19	1,572	1m12s	46ms
	20	824	47s266ms	57ms
	21	347	16s536ms	47ms
	22	208	9s692ms	46ms

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

Date: 2024-12-26 20:28:43 Duration: 273ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3779523) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:29:36 Duration: 258ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3906834) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:10:43 Duration: 250ms

19

32ms

97ms

44ms

22,441

Details

16m48s

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 26	07	74	3s71ms	41ms
	08	68	2s926ms	43ms
	09	1,997	1m24s	42ms
	10	2,310	1m41s	44ms
	11	3,245	2m38s	48ms
	12	1,422	1m1s	43ms
	13	1,546	1m8s	44ms
	14	2,489	1m55s	46ms
	15	3,381	2m32s	44ms
	16	3,677	2m39s	43ms
	17	1,146	49s786ms	43ms
	18	369	15s417ms	41ms
	19	478	20s178ms	42ms
	20	239	14s484ms	60ms

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

Date: 2024-12-26 20:30:23 Duration: 97ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3785893) ORDER BY "collection_policy"."id";

Date: 2024-12-26 11:13:04 Duration: 85ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3773772) ORDER BY "collection_policy"."id";

Date: 2024-12-26 20:30:27 Duration: 83ms

20

29ms

247ms

40ms

165,872

Details

1h51m5s

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 26	00	3,063	1m54s	37ms
	01	2,643	1m38s	37ms
	02	2,674	1m39s	37ms
	03	1,885	1m10s	37ms
	04	3,079	1m54s	37ms
	05	1,694	1m3s	37ms
	06	2,490	1m33s	37ms
	07	1,931	1m12s	37ms
	08	2,724	1m41s	37ms
	09	9,366	6m13s	39ms
	10	10,853	7m17s	40ms
	11	16,759	12m14s	43ms
	12	11,814	7m51s	39ms
	13	8,520	5m35s	39ms
	14	12,093	8m15s	40ms
	15	11,277	7m24s	39ms
	16	15,740	10m42s	40ms
	17	9,905	6m38s	40ms
	18	9,532	6m25s	40ms
	19	8,925	5m56s	39ms
	20	8,360	5m51s	42ms
	21	6,007	3m56s	39ms
	22	4,538	2m55s	38ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3894430, 3874753)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 11:10:32 Duration: 247ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3974052)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:32:04 Duration: 211ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3907187)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-26 20:24:59 Duration: 209ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

20,742,701 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	13	0.00%
DETAIL	10,031	0.05%
ERROR	9,401	0.05%
EVENTLOG	1,454	0.01%
FATAL	11,127	0.05%
HINT	6	0.00%
LOG	20,701,238	99.80%
STATEMENT	9,431	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
11127 FATAL entries
9401 ERROR entries
0 WARNING entries
1454 EVENTLOG entries

Most Frequent Errors/Events

Key values

10,012 Max number of times the same event was reported
21,982 Total events found

Rank

Times reported

Error

1

10,012

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 26	07	2
	11	1,215
	12	3,347
	13	3,339
	14	2,109

FATAL: password authentication failed for user "postgres"

2

4,837

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 26	00	22
	01	9
	02	6
	03	5
	04	5
	05	2
	06	4
	07	22
	08	106
	09	170
	10	482
	11	793
	12	361
	13	526
	14	569
	15	459
	16	535
	17	321
	18	93
	19	79
	20	146
	21	94
	22	28

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

3

4,517

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 26	00	18
	01	8
	02	5
	03	2
	04	3
	06	3
	07	20
	08	104
	09	159
	10	465
	11	760
	12	345
	13	500
	14	548
	15	441
	16	508
	17	296
	18	80
	19	73
	20	99
	21	53
	22	27

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

994

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 26	00	2
	08	91
	09	47
	10	111
	11	127
	12	98
	13	74
	14	126
	15	94
	16	144
	17	20
	18	26
	19	2
	22	32

5

994

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 26	00	2
	08	91
	09	47
	10	111
	11	127
	12	98
	13	74
	14	126
	15	94
	16	144
	17	20
	18	26
	19	2
	22	32

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

6

306

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 26	00	1
	08	12
	09	19
	10	23
	11	41
	12	32
	13	24
	14	38
	15	37
	16	55
	17	11
	18	7
	19	1
	22	5

7

153

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 26	08	3
	09	9
	10	9
	11	18
	12	20
	13	17
	14	20
	15	19
	16	27
	17	7
	18	3
	19	1

8

81

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 26	17	81

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

9

20

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 26	17	20

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

10

13

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 26	08	4
	10	4
	14	1
	16	1
	18	3

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

11

10

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 26	09	1
	10	2
	11	2
	12	2
	14	1
	16	1
	17	1

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

12

6

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 26	17	6

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 26	13	6

ERROR: invalid input syntax for type integer: "s" at character 4701

14

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 26	04	1
	10	1
	11	4

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

15

5

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 26	17	5

16

4

Details

ERROR: bigint out of range

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 26	15	4

ERROR: bigint out of range

17

4

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 26	17	4

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

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 26	14	3

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

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 26	03	1
	20	1

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 26	03	1
	20	1

21

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 26	03	1
	20	1

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 26	11	1

23

1

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 26	13	1

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 26	11	1

25

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #25

Day	Hour	Count
Dec 26	08	1

ERROR: could not serialize access due to concurrent delete

26

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #26

Day	Hour	Count
Dec 26	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables