pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Dec 20 23:46:46 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 26,435,313 log entries in 1m45s
Log start from 2024-12-20 00:00:00 to 2024-12-20 22:45:01

Global Stats

16,663 Number of unique normalized queries
11,437,318 Number of queries
3d14h52m59s Total query duration
2024-12-20 00:00:00 First query
2024-12-20 22:45:01 Last query
2,773 queries/s at 2024-12-20 17:51:12 Query peak

3d14h52m59s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3d14h52m59s Execute total duration

3,280 Number of events
24 Number of unique normalized events
1,263 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
11,437,318 Average queries per session
3d14h52m59s 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

2,773 queries/s Query Peak
2024-12-20 17:51:12 Date

SELECT Traffic

Key values

1,816 queries/s Query Peak
2024-12-20 17:51:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,228 queries/s Query Peak
2024-12-20 15:09:34 Date

Queries duration

Key values

3d14h52m59s 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 20	00	285,738	0ms	59m17s	38ms	2m9s	2m19s	1h53m38s
	01	327,456	0ms	1s404ms	16ms	2m28s	3m1s	4m1s
	02	263,988	0ms	1s320ms	18ms	2m54s	3m59s	4m29s
	03	270,338	0ms	1s938ms	22ms	2m52s	3m11s	3m51s
	04	211,274	0ms	564ms	21ms	2m25s	2m59s	3m52s
	05	182,826	0ms	1s933ms	19ms	1m50s	2m2s	3m48s
	06	126,397	0ms	583ms	20ms	1m40s	2m13s	2m24s
	07	158,449	0ms	794ms	26ms	2m19s	2m41s	3m10s
	08	300,256	0ms	606ms	9ms	1m48s	2m49s	3m21s
	09	548,837	0ms	5s419ms	11ms	2m37s	4m7s	4m26s
	10	714,760	0ms	3s368ms	14ms	4m47s	5m12s	5m16s
	11	433,228	0ms	59m59s	30ms	2m35s	3m25s	2h11m8s
	12	838,491	0ms	13m5s	29ms	4m23s	5m29s	4h24m
	13	950,378	0ms	30m37s	32ms	4m13s	4m42s	6h7m23s
	14	913,066	0ms	1h	22ms	5m4s	5m17s	2h39m1s
	15	1,015,193	0ms	18m47s	42ms	8m2s	44m16s	3h55m36s
	16	834,252	0ms	11m57s	24ms	5m15s	42m55s	1h28m26s
	17	748,061	0ms	4m5s	15ms	5m17s	6m34s	7m58s
	18	717,285	0ms	1m12s	16ms	5m36s	8m19s	9m35s
	19	597,823	0ms	59m59s	30ms	3m27s	4m28s	1h59m38s
	20	414,501	0ms	1h	94ms	3m7s	3m49s	6h28m41s
	21	314,075	0ms	3s993ms	10ms	2m36s	2m56s	3m33s
	22	270,646	0ms	20m4s	55ms	2m19s	2m28s	3h19m11s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 20	00	153,182	27ms	1m44s	2m1s	2m18s
	01	177,519	29ms	2m9s	2m27s	3m5s
	02	132,766	36ms	1m59s	2m53s	4m17s
	03	138,936	43ms	2m32s	2m52s	3m29s
	04	104,822	43ms	2m1s	2m25s	3m15s
	05	88,382	41ms	1m34s	1m50s	2m8s
	06	61,908	41ms	1m29s	1m40s	2m13s
	07	87,889	46ms	1m59s	2m19s	2m54s
	08	168,230	17ms	1m31s	1m47s	3m15s
	09	304,325	20ms	2m20s	2m36s	4m19s
	10	399,239	25ms	4m9s	4m46s	5m13s
	11	230,663	24ms	2m9s	2m27s	3m25s
	12	486,421	17ms	3m27s	4m21s	5m28s
	13	565,533	15ms	3m21s	3m57s	4m41s
	14	528,287	17ms	3m33s	3m58s	5m9s
	15	617,196	21ms	5m19s	6m20s	8m1s
	16	488,509	20ms	4m3s	4m39s	5m21s
	17	446,980	25ms	4m18s	5m12s	7m12s
	18	416,984	27ms	4m21s	5m35s	8m37s
	19	341,323	21ms	2m58s	3m14s	3m36s
	20	238,662	21ms	2m11s	2m57s	3m26s
	21	176,555	18ms	1m33s	2m35s	2m56s
	22	159,628	19ms	1m39s	2m16s	2m45s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 20	00	18,989	5,040	146	0	277ms	111ms	169ms	210ms
	01	25,493	5,082	141	0	0ms	138ms	173ms	276ms
	02	18,947	5,082	173	0	0ms	100ms	143ms	281ms
	03	24,000	5,705	130	0	0ms	135ms	167ms	209ms
	04	15,733	5,650	150	0	0ms	95ms	124ms	186ms
	05	15,293	4,367	139	0	0ms	94ms	112ms	135ms
	06	11,260	2,083	128	0	0ms	72ms	98ms	142ms
	07	17,877	4,545	132	0	0ms	104ms	192ms	225ms
	08	9,625	5,300	371	0	0ms	65ms	94ms	153ms
	09	23,653	9,226	347	0	0ms	136ms	162ms	208ms
	10	44,004	11,626	483	0	0ms	219ms	272ms	391ms
	11	22,657	8,145	305	0	251ms	117ms	147ms	299ms
	12	40,652	12,369	408	0	296ms	202ms	262ms	449ms
	13	42,573	13,518	404	0	387ms	221ms	257ms	482ms
	14	44,683	13,252	520	0	185ms	248ms	331ms	2m41s
	15	48,257	17,808	651	1	443ms	306ms	407ms	43m6s
	16	42,685	14,324	524	0	182ms	228ms	312ms	41m13s
	17	44,485	14,758	790	0	7ms	380ms	517ms	31s807ms
	18	46,027	14,666	721	0	2ms	322ms	437ms	17s934ms
	19	34,801	10,270	609	0	237ms	237ms	285ms	1m25s
	20	22,736	6,115	347	0	1s167ms	142ms	202ms	13s227ms
	21	18,022	4,766	263	0	0ms	118ms	152ms	283ms
	22	16,112	3,908	203	1	588ms	126ms	188ms	278ms

Day	Hour	Percentage of prepare
Dec 20	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 20	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 20	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

177,995 buffers Checkpoint Peak
2024-12-20 13:16:25 Date
270.053 seconds Highest write time
0.328 seconds Sync time

Checkpoints Wal files

Key values

73 files Wal files usage Peak
2024-12-20 13:16:25 Date

Checkpoints distance

Key values

2,333.01 Mo Distance Peak
2024-12-20 13:16:25 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 20	00	122,336	3,239.493s	0.036s	3,239.576s
	01	156,756	3,239.593s	0.047s	3,239.689s
	02	134,511	3,239.545s	0.03s	3,239.616s
	03	138,876	3,239.665s	0.031s	3,239.737s
	04	98,363	3,239.601s	0.032s	3,239.67s
	05	116,353	3,207.515s	0.042s	3,207.598s
	06	62,379	3,129.502s	0.025s	3,129.565s
	07	54,416	2,924.315s	0.033s	2,924.382s
	08	74,856	2,909.52s	0.032s	2,909.591s
	09	179,952	3,239.52s	0.036s	3,239.603s
	10	317,504	3,239.552s	0.04s	3,239.652s
	11	190,919	3,239.587s	0.036s	3,239.675s
	12	277,643	3,239.583s	0.037s	3,239.679s
	13	595,882	3,239.12s	0.38s	3,239.586s
	14	376,058	3,239.604s	0.042s	3,239.713s
	15	345,676	3,239.54s	0.053s	3,239.651s
	16	303,268	3,239.466s	0.048s	3,239.572s
	17	308,565	2,886.997s	0.061s	2,887.141s
	18	307,258	3,239.586s	0.044s	3,239.696s
	19	213,049	3,239.519s	0.047s	3,239.622s
	20	169,056	3,239.48s	0.049s	3,239.58s
	21	129,660	3,239.621s	0.034s	3,239.699s
	22	95,053	2,429.668s	0.026s	2,429.73s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Dec 20	00	0	53	3,385	0.002s	0.012s
	01	0	67	3,506	0.010s	0.012s
	02	0	60	2,705	0.002s	0.012s
	03	0	62	2,716	0.002s	0.012s
	04	0	46	2,614	0.002s	0.012s
	05	0	53	2,368	0.015s	0.012s
	06	0	29	2,129	0.002s	0.012s
	07	0	25	2,342	0.002s	0.012s
	08	0	32	2,771	0.003s	0.012s
	09	0	75	4,181	0.002s	0.012s
	10	0	133	4,342	0.002s	0.012s
	11	0	82	4,129	0.002s	0.012s
	12	0	118	4,774	0.002s	0.012s
	13	7	231	4,989	0.025s	0.012s
	14	0	139	4,951	0.002s	0.012s
	15	0	127	5,050	0.006s	0.012s
	16	0	113	5,073	0.003s	0.012s
	17	0	121	5,072	0.014s	0.012s
	18	0	120	5,055	0.002s	0.012s
	19	0	81	4,902	0.004s	0.012s
	20	0	68	4,740	0.013s	0.012s
	21	0	52	4,368	0.002s	0.012s
	22	0	35	3,149	0.003s	0.009s

Day	Hour	Avg time (sec)
Dec 20	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 20	00	72,041.92 kB	113,552.58 kB
	01	92,039.08 kB	127,168.08 kB
	02	80,882.17 kB	115,827.67 kB
	03	84,852.17 kB	113,578.08 kB
	04	63,445.83 kB	97,800.00 kB
	05	72,076.58 kB	121,943.58 kB
	06	39,850.25 kB	73,069.67 kB
	07	34,105.08 kB	55,404.25 kB
	08	39,690.18 kB	58,586.91 kB
	09	102,734.25 kB	120,685.42 kB
	10	181,197.50 kB	205,513.25 kB
	11	113,167.75 kB	199,176.25 kB
	12	160,500.08 kB	213,130.08 kB
	13	339,428.91 kB	728,691.73 kB
	14	189,439.18 kB	435,788.00 kB
	15	173,529.17 kB	268,216.58 kB
	16	151,504.80 kB	253,767.60 kB
	17	156,723.45 kB	202,229.45 kB
	18	170,311.91 kB	222,871.45 kB
	19	110,311.58 kB	168,496.00 kB
	20	92,991.33 kB	132,287.92 kB
	21	71,407.17 kB	116,093.50 kB
	22	64,155.11 kB	108,275.67 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 20	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 20	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

6,513,939 Total read queries
3,335,233 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	6,513,939	56.95%
INSERT	648,564	5.67%
UPDATE	197,605	1.73%
DELETE	8,085	0.07%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	12,538	0.11%
DDL	894	0.01%
TCL	2,467,545	21.57%
CURSOR	0	0.00%
OTHERS	1,588,146	13.89%

Queries by database

Key values

unknown Main database
11,437,318 Requests
3d14h52m59s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	11,437,318	3d14h52m59s
	copy from	2	3ms
	cte	12,538	2s475ms
	ddl	894	119ms
	delete	8,085	1s106ms
	insert	648,564	3m4s
	others	1,588,146	1m12s
	select	6,513,939	1d18h12m59s
	tcl	2,467,545	1m37s
	update	197,605	1d20h34m2s

Queries by user

Key values

unknown Main user
11,437,318 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	11,437,318	3d14h52m59s
	copy from	2	3ms
	cte	12,538	2s475ms
	ddl	894	119ms
	delete	8,085	1s106ms
	insert	648,564	3m4s
	others	1,588,146	1m12s
	select	6,513,939	1d18h12m59s
	tcl	2,467,545	1m37s
	update	197,605	1d20h34m2s

Duration by user

Key values

3d14h52m59s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	11,437,318	3d14h52m59s
	copy from	2	3ms
	cte	12,538	2s475ms
	ddl	894	119ms
	delete	8,085	1s106ms
	insert	648,564	3m4s
	others	1,588,146	1m12s
	select	6,513,939	1d18h12m59s
	tcl	2,467,545	1m37s
	update	197,605	1d20h34m2s

Queries by host

Key values

unknown Main host
11,437,318 Requests
3d14h52m59s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	11,437,318	3d14h52m59s
	copy from	2	3ms
	cte	12,538	2s475ms
	ddl	894	119ms
	delete	8,085	1s106ms
	insert	648,564	3m4s
	others	1,588,146	1m12s
	select	6,513,939	1d18h12m59s
	tcl	2,467,545	1m37s
	update	197,605	1d20h34m2s

Queries by application

Key values

unknown Main application
11,437,318 Requests
3d14h52m59s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	11,437,318	3d14h52m59s
	copy from	2	3ms
	cte	12,538	2s475ms
	ddl	894	119ms
	delete	8,085	1s106ms
	insert	648,564	3m4s
	others	1,588,146	1m12s
	select	6,513,939	1d18h12m59s
	tcl	2,467,545	1m37s
	update	197,605	1d20h34m2s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-20 06:45:30 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

10,632,000 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	10,632,000	92.96%
1-5ms	161,440	1.41%
5-10ms	6,822	0.06%
10-25ms	27,058	0.24%
25-50ms	168,581	1.47%
50-100ms	19,576	0.17%
100-500ms	398,114	3.48%
500-1000ms	22,464	0.20%
1000-10000ms	931	0.01%
> 10000ms	332	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h	update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996994', exp_date = '2024-12-20 18:54:01.996997', logged_in = 'TRUE' where id = 960; [ Date: 2024-12-20 20:09:02 ]
2	1h	update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996854', exp_date = '2024-12-20 18:54:01.996858', logged_in = 'TRUE' where id = 960; [ Date: 2024-12-20 20:09:02 ]
3	1h	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-20 12:44:40.791358', exp_date = '2024-12-20 13:29:40.791360', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-20 14:44:40 ]
4	1h	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-20 12:44:40.791142', exp_date = '2024-12-20 13:29:40.791144', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-20 14:44:40 ]
5	59m59s	update res_users set sid = '64be6a78515dff3bdd19a04657589376119bda13', last_update = '2024-12-20 17:25:44.928449', exp_date = '2024-12-20 18:10:44.928454', logged_in = 'TRUE' where id = 1031; [ Date: 2024-12-20 19:25:44 ]
6	59m59s	update res_users set sid = '95962b12596c4262bc78839e2d33aef9f009d599', last_update = '2024-12-20 09:45:14.899029', exp_date = '2024-12-20 10:30:14.899033', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-20 11:45:14 ]
7	59m59s	update res_users set sid = '95962b12596c4262bc78839e2d33aef9f009d599', last_update = '2024-12-20 09:45:14.899497', exp_date = '2024-12-20 10:30:14.899499', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-20 11:45:14 ]
8	59m59s	UPDATE "res_users" SET "exp_date" = '2024-12-20 17:50:56.596065', "last_update" = '2024-12-20 17:05:56.596095', "write_date" = '2024-12-20 17:05:56.078199', "write_uid" = 1 WHERE id IN (875); [ Date: 2024-12-20 19:05:56 ]
9	59m41s	update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:20.304416', exp_date = '2024-12-20 18:54:20.304421', logged_in = 'TRUE' where id = 960; [ Date: 2024-12-20 20:09:02 ]
10	59m17s	update res_users set sid = '6bcff59311262ad98177d7516ba5db1ce9e2bb40', last_update = '2024-12-19 22:51:06.024524', exp_date = '2024-12-19 23:36:06.024527', logged_in = 'TRUE' where id = 843; [ Date: 2024-12-20 00:50:23 ]
11	58m15s	update res_users set sid = '66712dc0a78f67ef49b5dd2c9ee71e901f8b6816', last_update = '2024-12-20 17:07:40.551307', exp_date = '2024-12-20 17:52:40.551314', logged_in = 'TRUE' where id = 875; [ Date: 2024-12-20 19:05:56 ]
12	52m19s	update res_users set sid = 'c3a82b9bda95a3e40c61f6d096fa0b841f8cb4eb', last_update = '2024-12-19 22:58:04.568011', exp_date = '2024-12-19 23:43:04.568016', logged_in = 'TRUE' where id = 1294; [ Date: 2024-12-20 00:50:23 ]
13	41m32s	update res_users set sid = '92a6ee95feb0a2ef89cbd3544274d241402196b5', last_update = '2024-12-20 18:50:48.633812', exp_date = '2024-12-20 19:35:48.633816', logged_in = 'TRUE' where id = 963; [ Date: 2024-12-20 20:32:21 ]
14	41m32s	update res_users set sid = '92a6ee95feb0a2ef89cbd3544274d241402196b5', last_update = '2024-12-20 18:50:48.633812', exp_date = '2024-12-20 19:35:48.633816', logged_in = 'TRUE' where id = 963; [ Date: 2024-12-20 20:32:21 ]
15	40m57s	update res_users set sid = '92a6ee95feb0a2ef89cbd3544274d241402196b5', last_update = '2024-12-20 18:51:23.212173', exp_date = '2024-12-20 19:36:23.212177', logged_in = 'TRUE' where id = 963; [ Date: 2024-12-20 20:32:21 ]
16	35m34s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-20 13:09:05.986631', exp_date = '2024-12-20 13:54:05.986634', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-20 14:44:40 ]
17	30m37s	update res_users set sid = '98e25af942ad8f306d3fcc484cd6a598ae5619e3', last_update = '2024-12-20 11:42:43.764602', exp_date = '2024-12-20 12:27:43.764604', logged_in = 'TRUE' where id = 865; [ Date: 2024-12-20 13:13:21 ]
18	30m37s	update res_users set sid = '98e25af942ad8f306d3fcc484cd6a598ae5619e3', last_update = '2024-12-20 11:42:43.764591', exp_date = '2024-12-20 12:27:43.764593', logged_in = 'TRUE' where id = 865; [ Date: 2024-12-20 13:13:21 ]
19	29m48s	update res_users set sid = 'd3a65103046e3920878f31ab2af7da2fb0cafb0c', last_update = '2024-12-20 11:43:32.648370', exp_date = '2024-12-20 12:28:32.648374', logged_in = 'TRUE' where id = 1060; [ Date: 2024-12-20 13:13:21 ]
20	28m10s	UPDATE "res_users" SET "exp_date" = '2024-12-20 19:49:10.168852', "last_update" = '2024-12-20 19:04:10.168875', "write_date" = '2024-12-20 19:04:09.841257', "write_uid" = 1 WHERE id IN (1229); [ Date: 2024-12-20 20:32:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1d18h19m40s

39,999

Details

0ms

1h

3s809ms

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 20	00	714	1h51m36s	9s379ms
	01	850	182ms	0ms
	02	841	172ms	0ms
	03	819	168ms	0ms
	04	678	144ms	0ms
	05	529	110ms	0ms
	06	293	60ms	0ms
	07	207	55ms	0ms
	08	1,114	234ms	0ms
	09	2,163	452ms	0ms
	10	2,251	497ms	0ms
	11	1,440	2h10m7s	5s421ms
	12	3,216	4h23m48s	4s921ms
	13	3,535	5h29m24s	5s590ms
	14	3,776	2h57m16s	2s816ms
	15	4,154	8h9m3s	7s64ms
	16	3,407	2h54m15s	3s68ms
	17	2,485	6m30s	157ms
	18	2,452	1m31s	37ms
	19	2,169	1h58m16s	3s271ms
	20	1,239	8h59m35s	26s130ms
	21	911	204ms	0ms
	22	756	3h18m10s	15s728ms

update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996994', exp_date = '2024-12-20 18:54:01.996997', logged_in = 'TRUE' where id = 960;

Date: 2024-12-20 20:09:02 Duration: 1h
update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996854', exp_date = '2024-12-20 18:54:01.996858', logged_in = 'TRUE' where id = 960;

Date: 2024-12-20 20:09:02 Duration: 1h
update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-20 12:44:40.791358', exp_date = '2024-12-20 13:29:40.791360', logged_in = 'TRUE' where id = 861;

Date: 2024-12-20 14:44:40 Duration: 1h

2

21h7m53s

173,320

Details

384ms

766ms

438ms

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 20	00	5,311	38m14s	432ms
	01	7,644	54m56s	431ms
	02	7,463	52m31s	422ms
	03	8,970	1h4m10s	429ms
	04	5,845	41m31s	426ms
	05	5,294	37m21s	423ms
	06	4,339	30m46s	425ms
	07	3,720	28m10s	454ms
	08	2,848	19m48s	417ms
	09	6,732	47m26s	422ms
	10	12,071	1h27m29s	434ms
	11	5,274	37m3s	421ms
	12	9,489	1h9m12s	437ms
	13	9,145	1h6m14s	434ms
	14	11,273	1h22m20s	438ms
	15	12,637	1h35m17s	452ms
	16	11,386	1h23m35s	440ms
	17	12,901	1h37m38s	454ms
	18	11,497	1h28m7s	459ms
	19	7,563	56m43s	449ms
	20	5,259	39m20s	448ms
	21	3,370	25m12s	448ms
	22	3,289	24m39s	449ms

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

Date: 2024-12-20 18:06:03 Duration: 766ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773453)) AND (("shipping_track"."id" not in (30805093, 30805093)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:02 Duration: 764ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773455)) AND (("shipping_track"."id" not in (30805116, 30805116)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:05 Duration: 744ms

3

5h48m

97,174

Details

182ms

409ms

214ms

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 20	00	1,187	3m58s	200ms
	01	974	3m16s	202ms
	02	1,674	5m38s	202ms
	03	1,874	6m18s	202ms
	04	3,540	12m4s	204ms
	05	1,952	6m34s	202ms
	06	638	2m7s	200ms
	07	2,893	9m51s	204ms
	08	3,816	12m56s	203ms
	09	5,535	19m4s	206ms
	10	8,031	28m12s	210ms
	11	6,489	21m57s	202ms
	12	6,002	21m7s	211ms
	13	5,885	20m35s	209ms
	14	3,928	13m51s	211ms
	15	13,601	49m59s	220ms
	16	7,619	26m47s	211ms
	17	9,595	36m57s	231ms
	18	8,307	33m29s	241ms
	19	2,216	8m1s	217ms
	20	437	1m35s	218ms
	21	940	3m24s	217ms
	22	41	8s922ms	217ms

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

Date: 2024-12-20 18:06:05 Duration: 409ms
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" = '9440939')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 18:06:04 Duration: 377ms
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" = '9327634')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 17:21:57 Duration: 372ms

4

3h42m31s

29,710

Details

385ms

1s491ms

449ms

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 20	00	127	1m	477ms
	01	244	1m52s	460ms
	02	628	4m32s	433ms
	03	187	1m30s	481ms
	04	157	1m14s	475ms
	05	135	1m6s	489ms
	06	62	30s612ms	493ms
	07	74	35s515ms	479ms
	08	839	5m58s	427ms
	09	1,239	9m2s	437ms
	10	1,923	14m21s	448ms
	11	1,104	7m59s	434ms
	12	1,850	13m47s	447ms
	13	2,671	19m51s	446ms
	14	2,844	21m13s	447ms
	15	2,388	18m43s	470ms
	16	1,949	14m39s	451ms
	17	2,681	20m18s	454ms
	18	3,148	24m	457ms
	19	2,170	16m5s	444ms
	20	1,773	12m58s	439ms
	21	836	6m8s	441ms
	22	681	4m59s	439ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3702794)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 17:21:57 Duration: 1s491ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3736215, 3736211, 3736167, 3735031, 3731629, 3729473, 3729407, 3729316, 3728614, 3727864, 3727630, 3727442, 3727325, 3725783, 3725724, 3725481, 3725288, 3725268, 3724973, 3724861, 3724408, 3723863, 3721878, 3721409, 3721186, 3719945, 3719221, 3719147, 3718506, 3716908, 3716537, 3715899, 3715866, 3713213, 3711753, 3709963, 3709949, 3707441, 3704003, 3701243, 3701163, 3697471, 3697412, 3697408, 3691957, 3691788, 3688520, 3688505, 3688481, 3683948, 3675936, 3672255, 3666471, 3444522)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 17:21:57 Duration: 1s273ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3723669, 3721914, 3716560, 3716202, 3714638, 3709765, 3690417, 3678049)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 15:47:36 Duration: 739ms

5

2h6s

32,894

Details

92ms

831ms

219ms

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 20	00	2,392	9m3s	227ms
	01	2,875	9m47s	204ms
	02	1,131	3m45s	198ms
	03	2,874	10m39s	222ms
	04	1,366	5m1s	220ms
	05	1,106	4m2s	219ms
	06	822	2m58s	217ms
	07	3,752	13m4s	209ms
	08	22	3s206ms	145ms
	09	50	7s238ms	144ms
	10	488	2m3s	253ms
	11	374	1m12s	194ms
	12	768	2m50s	221ms
	13	116	32s634ms	281ms
	14	684	2m35s	226ms
	15	168	33s294ms	198ms
	16	1,276	5m34s	262ms
	17	2,182	8m36s	236ms
	18	2,408	9m21s	233ms
	19	2,894	10m46s	223ms
	20	2,176	7m40s	211ms
	21	1,302	4m24s	203ms
	22	1,668	5m19s	191ms

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-20 18:06:56 Duration: 831ms
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-20 18:06:56 Duration: 830ms
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-20 16:54:01 Duration: 797ms

6

1h28m10s

12

Details

0ms

59m59s

7m20s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 20	00	2	2ms	1ms
	04	1	0ms	0ms
	10	1	0ms	0ms
	13	1	1ms	1ms
	15	1	1ms	1ms
	17	1	0ms	0ms
	18	1	1ms	1ms
	19	2	59m59s	29m59s
	20	1	28m10s	28m10s
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-20 17:50:56.596065', "last_update" = '2024-12-20 17:05:56.596095', "write_date" = '2024-12-20 17:05:56.078199', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-20 19:05:56 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2024-12-20 19:49:10.168852', "last_update" = '2024-12-20 19:04:10.168875', "write_date" = '2024-12-20 19:04:09.841257', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-20 20:32:21 Duration: 28m10s
UPDATE "res_users" SET "exp_date" = '2024-12-20 13:08:25.899452', "last_update" = '2024-12-20 12:23:25.899477', "write_date" = '2024-12-20 12:23:25.558115', "write_uid" = 886 WHERE id IN (886);

Date: 2024-12-20 13:23:25 Duration: 1ms

7

1h24m39s

19,512

Details

184ms

441ms

260ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 20	07	142	34s395ms	242ms
	08	1,145	4m45s	249ms
	09	1,991	8m26s	254ms
	10	2,506	10m42s	256ms
	11	1,551	6m28s	250ms
	12	2,375	10m20s	261ms
	13	1,407	6m3s	258ms
	14	1,264	5m24s	256ms
	15	3,214	14m19s	267ms
	16	1,257	5m41s	271ms
	17	785	3m29s	267ms
	18	1,177	5m15s	268ms
	19	698	3m7s	268ms

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

Date: 2024-12-20 15:47:42 Duration: 441ms
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" = '8792173')))) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:43 Duration: 439ms
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" = '9365729')))) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:43 Duration: 435ms

8

1h16m50s

4,771

Details

906ms

1s429ms

966ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 20	00	345	5m31s	961ms
	01	400	6m22s	955ms
	02	284	4m36s	974ms
	03	74	1m11s	972ms
	09	21	20s469ms	974ms
	11	6	5s857ms	976ms
	12	5	4s831ms	966ms
	13	7	7s22ms	1s3ms
	14	24	23s825ms	992ms
	15	21	20s621ms	981ms
	16	152	2m30s	991ms
	17	246	4m1s	981ms
	18	865	14m15s	988ms
	19	539	8m37s	960ms
	20	775	12m20s	955ms
	21	501	7m58s	954ms
	22	506	8m1s	952ms

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

Date: 2024-12-20 18:06:04 Duration: 1s429ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9514226')) 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 (2))))))) 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 (2)))))) 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 (2)))))) 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 (2))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-20 18:06:01 Duration: 1s414ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9420648')) 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 (68))))))) 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 (68)))))) 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 (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-20 18:05:59 Duration: 1s368ms

9

59m42s

11,902

Details

226ms

441ms

301ms

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 20	00	864	4m12s	292ms
	01	1,060	5m11s	294ms
	02	283	1m23s	296ms
	03	1,385	6m44s	291ms
	04	697	3m23s	292ms
	05	558	2m40s	288ms
	06	415	2m	290ms
	07	1,881	9m10s	292ms
	08	11	3s201ms	291ms
	09	8	2s154ms	269ms
	10	260	1m18s	302ms
	11	191	55s859ms	292ms
	12	380	2m	316ms
	13	54	16s356ms	302ms
	14	331	1m41s	305ms
	15	69	21s430ms	310ms
	16	493	2m32s	310ms
	17	865	4m37s	320ms
	18	357	1m58s	332ms
	19	925	4m49s	313ms
	20	324	1m42s	316ms
	21	155	48s919ms	315ms
	22	336	1m44s	310ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9468566')) 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-20 18:05:33 Duration: 441ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9494950')) 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-20 17:39:13 Duration: 436ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9509804')) 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-20 17:34:37 Duration: 431ms

10

59m36s

100,280

Details

27ms

88ms

35ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 20	00	2,036	1m10s	34ms
	01	3,244	1m51s	34ms
	02	2,837	1m37s	34ms
	03	2,908	1m40s	34ms
	04	1,690	58s372ms	34ms
	05	1,683	58s283ms	34ms
	06	1,789	1m2s	34ms
	07	1,052	36s146ms	34ms
	08	1,429	49s632ms	34ms
	09	4,446	2m35s	34ms
	10	8,535	5m3s	35ms
	11	4,300	2m28s	34ms
	12	7,099	4m12s	35ms
	13	8,217	4m51s	35ms
	14	9,207	5m26s	35ms
	15	8,822	5m22s	36ms
	16	7,025	4m10s	35ms
	17	5,568	3m24s	36ms
	18	6,028	3m46s	37ms
	19	4,586	2m47s	36ms
	20	3,681	2m13s	36ms
	21	2,257	1m21s	36ms
	22	1,841	1m6s	36ms

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

Date: 2024-12-20 17:21:57 Duration: 88ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3749494)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 14:38:28 Duration: 77ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3670139)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 15:48:09 Duration: 76ms

11

41m13s

184

Details

0ms

23m21s

13s440ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 20	00	6	6ms	1ms
	01	3	5ms	1ms
	02	2	2ms	1ms
	04	5	6ms	1ms
	05	3	0ms	0ms
	07	2	1ms	0ms
	08	10	3ms	0ms
	09	9	3ms	0ms
	10	9	1ms	0ms
	11	4	0ms	0ms
	12	12	7ms	0ms
	13	19	35m2s	1m50s
	14	19	2m41s	8s488ms
	15	17	3m28s	12s279ms
	16	11	11ms	1ms
	17	13	15ms	1ms
	18	10	4ms	0ms
	19	10	5ms	0ms
	20	7	5ms	0ms
	21	6	7ms	1ms
	22	7	8ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-20 12:34:59.959390', "last_update" = '2024-12-20 11:49:59.959412', "sid" = '630536555451fb450491761c74fb365550efd24a', "write_date" = '2024-12-20 11:49:59.614346', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 23m21s
UPDATE "res_users" SET "exp_date" = '2024-12-20 12:52:22.181978', "last_update" = '2024-12-20 12:07:22.181999', "sid" = '630536555451fb450491761c74fb365550efd24a', "write_date" = '2024-12-20 12:07:21.857314', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 5m59s
UPDATE "res_users" SET "exp_date" = '2024-12-20 12:54:34.064492', "last_update" = '2024-12-20 12:09:34.064510', "sid" = '453519eb25e681c733dce7b6d8e252d766e1e286', "write_date" = '2024-12-20 12:09:33.743646', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 3m47s

12

36m34s

10,474

Details

181ms

292ms

209ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 20	00	60	12s112ms	201ms
	02	27	5s453ms	201ms
	03	309	1m2s	202ms
	04	447	1m30s	202ms
	05	125	25s239ms	201ms
	06	84	16s861ms	200ms
	07	131	26s871ms	205ms
	08	430	1m26s	202ms
	09	717	2m28s	206ms
	10	899	3m6s	207ms
	11	399	1m20s	202ms
	12	818	2m49s	207ms
	13	908	3m9s	208ms
	14	1,228	4m19s	211ms
	15	1,344	4m48s	214ms
	16	1,289	4m29s	208ms
	17	517	1m52s	217ms
	18	245	54s133ms	220ms
	19	248	54s262ms	218ms
	20	225	49s41ms	217ms
	22	24	5s192ms	216ms

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

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

Date: 2024-12-20 17:34:33 Duration: 280ms

13

36m27s

10,806

Details

184ms

238ms

202ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 20	00	1,126	3m46s	200ms
	01	974	3m16s	202ms
	02	1,647	5m32s	202ms
	03	1,545	5m12s	202ms
	04	2,565	8m41s	203ms
	05	1,827	6m9s	202ms
	06	554	1m51s	200ms
	07	568	1m56s	205ms

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

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

Date: 2024-12-20 04:57:58 Duration: 232ms

14

32m32s

45,135

Details

34ms

90ms

43ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 20	01	19	873ms	45ms
	02	12	542ms	45ms
	03	10	430ms	43ms
	04	5	232ms	46ms
	07	132	5s528ms	41ms
	08	328	13s860ms	42ms
	09	4,149	2m54s	42ms
	10	6,948	4m59s	43ms
	11	2,820	1m57s	41ms
	12	3,160	2m17s	43ms
	13	3,305	2m23s	43ms
	14	6,056	4m23s	43ms
	15	7,424	5m29s	44ms
	16	2,941	2m7s	43ms
	17	2,078	1m30s	43ms
	18	2,997	2m10s	43ms
	19	2,206	1m32s	41ms
	20	312	13s362ms	42ms
	21	128	5s442ms	42ms
	22	105	4s500ms	42ms

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

Date: 2024-12-20 15:28:52 Duration: 90ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3665022) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-20 18:06:04 Duration: 80ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2780945) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-20 17:22:07 Duration: 75ms

15

20m26s

5,867

Details

185ms

286ms

209ms

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

Day	Hour	Count	Duration	Avg duration
Dec 20	00	1	194ms	194ms
	07	890	3m4s	207ms
	08	84	17s189ms	204ms
	09	550	1m54s	208ms
	10	468	1m39s	213ms
	11	792	2m41s	203ms
	12	238	49s141ms	206ms
	13	2,006	6m58s	208ms
	14	238	49s932ms	209ms
	15	600	2m11s	218ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9194494')) 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-20 15:43:41 Duration: 286ms
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" = '9274676')) 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-20 14:33:23 Duration: 285ms
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" = '9030509')) 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-20 13:37:49 Duration: 283ms

16

13m34s

3,194

Details

192ms

387ms

255ms

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

Day	Hour	Count	Duration	Avg duration
Dec 20	08	84	20s911ms	248ms
	09	168	41s384ms	246ms
	10	446	1m56s	260ms
	11	895	3m38s	243ms
	13	806	3m26s	255ms
	14	201	52s14ms	258ms
	15	594	2m39s	269ms

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" = '9290411') 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-20 15:43:38 Duration: 387ms
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" = '9415225') 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-20 14:33:23 Duration: 359ms
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" = '9444225') 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-20 15:47:43 Duration: 357ms

17

13m19s

20,330

Details

30ms

70ms

39ms

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 20	07	66	2s437ms	36ms
	08	505	19s420ms	38ms
	09	1,445	53s992ms	37ms
	10	3,288	2m6s	38ms
	11	1,376	51s918ms	37ms
	12	1,641	1m2s	38ms
	13	2,525	1m41s	40ms
	14	1,855	1m12s	39ms
	15	3,806	2m38s	41ms
	16	1,271	50s427ms	39ms
	17	703	27s878ms	39ms
	18	1,136	44s574ms	39ms
	19	713	26s927ms	37ms

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

Date: 2024-12-20 13:59:48 Duration: 70ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3683933) ORDER BY "collection_policy"."id";

Date: 2024-12-20 13:59:48 Duration: 67ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3585335) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:40 Duration: 60ms

18

12m18s

8,025

Details

76ms

227ms

91ms

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

Day	Hour	Count	Duration	Avg duration
Dec 20	02	35	3s277ms	93ms
	08	150	13s981ms	93ms
	09	232	21s639ms	93ms
	10	386	35s998ms	93ms
	11	152	14s86ms	92ms
	12	584	53s165ms	91ms
	13	1,744	2m36s	89ms
	14	670	1m2s	93ms
	15	530	51s180ms	96ms
	16	648	59s512ms	91ms
	17	643	1m1s	96ms
	18	755	1m9s	92ms
	19	442	41s33ms	92ms
	20	403	35s877ms	89ms
	21	465	40s804ms	87ms
	22	186	16s723ms	89ms

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

Date: 2024-12-20 17:22:57 Duration: 227ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7853809)) AND (("cash_track"."id" not in (5982492)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-20 18:06:05 Duration: 157ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7833602)) AND (("cash_track"."id" not in (5827751, 5840800, 5863222, 5982485, 5982491, 5982491)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-20 18:06:04 Duration: 151ms

19

8m13s

2,726

Details

143ms

253ms

180ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 20	00	120	22s225ms	185ms
	01	120	22s180ms	184ms
	02	120	22s213ms	185ms
	03	120	22s328ms	186ms
	04	120	22s156ms	184ms
	05	120	22s157ms	184ms
	06	120	22s166ms	184ms
	07	120	22s134ms	184ms
	08	120	22s395ms	186ms
	09	120	22s550ms	187ms
	10	120	23s107ms	192ms
	11	120	22s473ms	187ms
	12	120	23s200ms	193ms
	13	120	22s944ms	191ms
	14	120	23s161ms	193ms
	15	120	23s817ms	198ms
	16	120	23s87ms	192ms
	17	116	20s21ms	172ms
	18	120	19s515ms	162ms
	19	120	18s724ms	156ms
	20	120	18s499ms	154ms
	21	120	18s527ms	154ms
	22	90	13s807ms	153ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 16:04:02 Duration: 253ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 16:04:02 Duration: 247ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 18:06:01 Duration: 246ms

20

8m

148

Details

3s7ms

4s152ms

3s245ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 20	10	6	19s530ms	3s255ms
	11	3	9s588ms	3s196ms
	12	4	12s536ms	3s134ms
	13	9	29s269ms	3s252ms
	14	4	12s852ms	3s213ms
	15	21	1m14s	3s546ms
	16	12	39s65ms	3s255ms
	17	11	35s751ms	3s250ms
	18	3	10s745ms	3s581ms
	19	14	45s395ms	3s242ms
	20	31	1m37s	3s144ms
	21	11	34s116ms	3s101ms
	22	19	59s508ms	3s132ms

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

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

Date: 2024-12-20 15:28:44 Duration: 4s53ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6))))))) 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 (6)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6))))))))) 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 (6)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-20 15:28:24 Duration: 3s913ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

1,587,593

Details

1m12s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 20	00	45,237	1s622ms	0ms
	01	48,330	1s954ms	0ms
	02	43,802	1s753ms	0ms
	03	41,467	1s787ms	0ms
	04	34,904	1s451ms	0ms
	05	30,486	1s265ms	0ms
	06	21,238	816ms	0ms
	07	20,049	793ms	0ms
	08	45,840	1s926ms	0ms
	09	81,923	3s850ms	0ms
	10	100,536	5s250ms	0ms
	11	68,708	3s152ms	0ms
	12	113,101	5s434ms	0ms
	13	124,817	5s511ms	0ms
	14	124,234	5s977ms	0ms
	15	125,207	5s266ms	0ms
	16	111,910	4s860ms	0ms
	17	92,614	4s495ms	0ms
	18	91,695	5s247ms	0ms
	19	81,712	4s404ms	0ms
	20	58,250	2s564ms	0ms
	21	45,905	1s802ms	0ms
	22	35,628	1s424ms	0ms

DISCARD ALL;

Date: 2024-12-20 10:26:44 Duration: 1ms
DISCARD ALL;

Date: 2024-12-20 01:39:33 Duration: 1ms
DISCARD ALL;

Date: 2024-12-20 19:07:28 Duration: 1ms

2

1,233,979

Details

17s166ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 20	00	31,381	406ms	0ms
	01	35,359	482ms	0ms
	02	31,574	432ms	0ms
	03	30,028	437ms	0ms
	04	24,972	370ms	0ms
	05	22,071	332ms	0ms
	06	14,888	227ms	0ms
	07	13,949	224ms	0ms
	08	35,295	486ms	0ms
	09	64,566	899ms	0ms
	10	79,362	1s172ms	0ms
	11	51,280	701ms	0ms
	12	92,331	1s206ms	0ms
	13	101,091	1s272ms	0ms
	14	100,592	1s379ms	0ms
	15	101,813	1s335ms	0ms
	16	87,359	1s160ms	0ms
	17	73,389	1s57ms	0ms
	18	73,320	1s179ms	0ms
	19	64,228	966ms	0ms
	20	43,772	594ms	0ms
	21	34,081	464ms	0ms
	22	27,278	376ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-20 16:29:07 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-20 09:35:32 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-20 15:25:23 Duration: 1ms

3

811,629

Details

7s472ms

0ms

18ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 20	00	23,339	189ms	0ms
	01	24,843	214ms	0ms
	02	22,516	188ms	0ms
	03	21,365	189ms	0ms
	04	18,119	156ms	0ms
	05	15,848	133ms	0ms
	06	11,209	92ms	0ms
	07	10,679	91ms	0ms
	08	23,737	204ms	0ms
	09	41,719	379ms	0ms
	10	51,073	493ms	0ms
	11	35,084	309ms	0ms
	12	57,397	538ms	0ms
	13	63,293	577ms	0ms
	14	63,171	581ms	0ms
	15	63,593	625ms	0ms
	16	56,852	522ms	0ms
	17	47,466	468ms	0ms
	18	46,726	475ms	0ms
	19	41,683	396ms	0ms
	20	29,835	268ms	0ms
	21	23,726	212ms	0ms
	22	18,356	162ms	0ms

ROLLBACK;

Date: 2024-12-20 15:56:09 Duration: 18ms
ROLLBACK;

Date: 2024-12-20 10:22:39 Duration: 0ms
ROLLBACK;

Date: 2024-12-20 14:56:10 Duration: 0ms

4

797,688

Details

2m10s

0ms

14ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 20	00	22,688	3s292ms	0ms
	01	24,215	3s705ms	0ms
	02	21,883	3s265ms	0ms
	03	20,724	3s303ms	0ms
	04	17,431	2s571ms	0ms
	05	15,213	2s214ms	0ms
	06	10,593	1s438ms	0ms
	07	10,021	1s452ms	0ms
	08	23,062	3s247ms	0ms
	09	41,184	6s298ms	0ms
	10	50,492	8s407ms	0ms
	11	34,542	5s169ms	0ms
	12	56,867	8s813ms	0ms
	13	62,681	9s909ms	0ms
	14	62,522	10s11ms	0ms
	15	62,778	10s904ms	0ms
	16	56,220	9s439ms	0ms
	17	46,700	8s748ms	0ms
	18	46,179	9s380ms	0ms
	19	41,222	7s568ms	0ms
	20	29,394	4s936ms	0ms
	21	23,158	3s681ms	0ms
	22	17,919	3s3ms	0ms

SELECT payload FROM http_sessions WHERE sid = '2903008c47b1e01e60d77b817e1f18d1e0820e14';

Date: 2024-12-20 11:49:48 Duration: 14ms
SELECT payload FROM http_sessions WHERE sid = 'e53e1ef8d6534e55bd9ae243d4ff1c502be79eea';

Date: 2024-12-20 10:22:10 Duration: 10ms
SELECT payload FROM http_sessions WHERE sid = '3a2502ebd08a7c189ef7542e004410a94b0fd309';

Date: 2024-12-20 16:35:01 Duration: 8ms

5

794,660

Details

1m7s

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 20	00	22,691	1s760ms	0ms
	01	24,233	1s982ms	0ms
	02	21,992	1s736ms	0ms
	03	20,828	1s736ms	0ms
	04	17,494	1s424ms	0ms
	05	15,320	1s244ms	0ms
	06	10,719	835ms	0ms
	07	10,107	824ms	0ms
	08	22,947	1s827ms	0ms
	09	41,023	3s404ms	0ms
	10	50,318	4s397ms	0ms
	11	34,415	2s703ms	0ms
	12	56,550	4s717ms	0ms
	13	62,413	5s345ms	0ms
	14	62,112	5s303ms	0ms
	15	62,541	5s490ms	0ms
	16	55,931	4s772ms	0ms
	17	46,278	4s303ms	0ms
	18	45,838	4s436ms	0ms
	19	40,885	3s630ms	0ms
	20	29,168	2s410ms	0ms
	21	23,018	1s821ms	0ms
	22	17,839	1s462ms	0ms

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

Date: 2024-12-20 14:33:22 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-20 19:51:20 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

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

6

542,431

Details

1m17s

0ms

8ms

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 20	00	10,105	1s555ms	0ms
	01	13,368	1s848ms	0ms
	02	10,878	1s581ms	0ms
	03	10,353	1s591ms	0ms
	04	7,799	1s243ms	0ms
	05	7,080	1s151ms	0ms
	06	4,643	781ms	0ms
	07	3,545	685ms	0ms
	08	14,554	2s45ms	0ms
	09	29,596	4s56ms	0ms
	10	38,175	5s385ms	0ms
	11	21,063	3s329ms	0ms
	12	47,288	6s17ms	0ms
	13	49,208	6s285ms	0ms
	14	48,397	7s586ms	0ms
	15	49,306	6s542ms	0ms
	16	38,786	5s248ms	0ms
	17	32,992	4s801ms	0ms
	18	34,305	5s446ms	0ms
	19	28,652	4s958ms	0ms
	20	16,954	2s581ms	0ms
	21	14,051	1s750ms	0ms
	22	11,333	1s506ms	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 (932);

Date: 2024-12-20 17:21:52 Duration: 8ms
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-20 17:21:52 Duration: 8ms
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-20 17:21:52 Duration: 8ms

7

421,931

Details

1m12s

0ms

35ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 20	00	8,051	1s399ms	0ms
	01	10,513	1s960ms	0ms
	02	9,061	1s655ms	0ms
	03	8,663	1s715ms	0ms
	04	6,850	1s313ms	0ms
	05	6,226	1s340ms	0ms
	06	3,679	655ms	0ms
	07	3,266	640ms	0ms
	08	11,559	1s730ms	0ms
	09	22,846	3s811ms	0ms
	10	28,282	4s797ms	0ms
	11	16,198	2s793ms	0ms
	12	34,883	5s559ms	0ms
	13	37,771	6s25ms	0ms
	14	37,410	5s872ms	0ms
	15	38,093	6s375ms	0ms
	16	30,404	4s938ms	0ms
	17	25,902	4s729ms	0ms
	18	26,574	5s15ms	0ms
	19	22,531	4s75ms	0ms
	20	13,931	2s473ms	0ms
	21	10,355	2s55ms	0ms
	22	8,883	1s537ms	0ms

COMMIT;

Date: 2024-12-20 17:07:19 Duration: 35ms
COMMIT;

Date: 2024-12-20 04:01:26 Duration: 30ms
COMMIT;

Date: 2024-12-20 16:27:36 Duration: 28ms

8

323,034

Details

39s776ms

0ms

3ms

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 20	00	7,279	843ms	0ms
	01	9,725	1s174ms	0ms
	02	6,278	691ms	0ms
	03	6,985	809ms	0ms
	04	4,022	423ms	0ms
	05	3,368	366ms	0ms
	06	3,736	484ms	0ms
	07	2,702	255ms	0ms
	08	6,904	756ms	0ms
	09	16,722	1s994ms	0ms
	10	23,400	3s277ms	0ms
	11	12,215	1s447ms	0ms
	12	28,520	3s872ms	0ms
	13	27,233	3s328ms	0ms
	14	27,431	3s223ms	0ms
	15	26,633	4s79ms	0ms
	16	21,900	2s725ms	0ms
	17	20,648	2s336ms	0ms
	18	22,706	2s639ms	0ms
	19	18,636	2s	0ms
	20	10,412	1s91ms	0ms
	21	9,019	1s74ms	0ms
	22	6,560	879ms	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 (5099007, 5099296, 5099244, 5099590, 5099009, 5099947, 5099264, 5417173, 5100007, 5121831, 5112417, 5101324, 5323364, 5180158, 5102433, 5099010, 5129576, 5131913, 5099013, 5099141, 5099190, 5099277, 5100302, 5190710, 5099014, 5099130, 5104396, 5099272, 5099263, 5103866, 5099254, 5099224, 5105966, 5099594, 5099049, 5099504, 5100327, 5103635, 5100421, 5206974, 5122425, 5100525, 5110808, 5116518, 5105620, 5102529, 5099564, 5100913, 5100506, 5103585, 5099677, 5100804, 5099995, 5116550, 5193566, 5102811, 5168874);

Date: 2024-12-20 17:21:57 Duration: 3ms
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 (5101252, 5099001, 5099025, 5099403, 5099102, 5099009, 5101987, 5099007, 5099095, 5099321, 5099169, 5099523, 5102936, 5099309, 5099144, 5100881, 5099631, 5101578, 5100762, 5099248, 5208765, 5110724, 5099243, 5125024, 5439103, 5099037, 5099010, 5103019, 5099137, 5123485, 5101482, 5099609, 5440294, 5099181, 5100559, 5099864, 5114626, 5103416, 5439473, 5110245, 5100540, 5101313, 5104300, 5100246, 5100202, 5103853, 5099138, 5099129, 5102785, 5100339, 5099644, 5428928, 5099296, 5099006, 5301710, 5100148, 5101077, 5100800, 5099140, 5099558, 5099130, 5101283, 5099274, 5099693, 5111581, 5099224, 5134271, 5264067, 5142737, 5099642, 5100207, 5099228, 5099236, 5099186, 5099725, 5438375, 5099540, 5099271, 5101370, 5099159, 5099254, 5099119, 5113543, 5102794, 5099013, 5179076, 5102415, 5099858, 5100933, 5107364, 5100726, 5102044, 5099002, 5102070, 5104713, 5099382, 5101319, 5099035, 5099206, 5099650, 5099386, 5099598, 5101610, 5128560, 5106266, 5099046, 5105990, 5101515, 5099133, 5099348, 5114216, 5099802, 5099491, 5101783, 5099714, 5223245, 5100822, 5100935, 5100554, 5099838, 5099168, 5100801, 5105121, 5398424, 5099170, 5099120, 5348621, 5102265, 5440506);

Date: 2024-12-20 17:22:02 Duration: 3ms
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 (5440247, 5258863, 5438435, 5438366, 5438338, 5437898, 5287527, 5255290, 5296648, 5207030, 5204322, 5436365, 5295741, 5412746, 5165540, 5436119, 5144660, 5412934, 5171883, 5435899, 5348183, 5151999, 5198278, 5406358, 5207098, 5165003, 5153749, 5218792, 5171992, 5434133, 5405698, 5358080, 5218770, 5433410, 5176646, 5164695, 5153162, 5430010, 5433160, 5171870, 5148195, 5433060, 5433010, 5432608, 5181457, 5201599, 5432488, 5432396, 5432363, 5361917, 5199868, 5432032, 5431858, 5154986, 5210856, 5431833, 5431755, 5431754, 5194400, 5431747, 5431744, 5241272, 5151885, 5272958, 5220737, 5431677, 5431678, 5431672, 5431673, 5404046, 5223478, 5177670, 5208583, 5273262, 5145492, 5431646, 5329915, 5201388, 5151738, 5179152, 5431490, 5275958, 5431485, 5431439, 5431426, 5431420, 5315251, 5431419, 5415356, 5210245, 5281830, 5431416, 5268528, 5431415, 5184061, 5226044, 5224194, 5431395, 5431349, 5431345, 5139616, 5431336, 5191057, 5410242, 5431337, 5431334, 5280642, 5431315, 5431314, 5431308, 5290201, 5431309, 5246519, 5431131, 5175509, 5153735, 5305599, 5431094, 5431083, 5135077, 5431077, 5431055, 5184682, 5254130, 5246335, 5431028, 5166932, 5416915, 5155873, 5183028, 5326469, 5188300, 5200797, 5430986, 5404337, 5235471, 5198142, 5169553, 5354516, 5401079, 5430834, 5323715, 5430824, 5430822, 5275933, 5430821, 5144737, 5350003, 5202489, 5430778, 5356132, 5430771, 5430744, 5430745, 5139052, 5430733, 5160860, 5324910, 5151834, 5169151, 5430584, 5430573, 5287740, 5430516, 5414948, 5165055, 5298944, 5268249, 5163121, 5152252, 5430448, 5430447, 5430443, 5272374, 5152046, 5215997, 5430368, 5318050, 5427115, 5430355, 5280275, 5179968, 5198488, 5182519, 5150721, 5142608, 5231599, 5135536, 5237035, 5153009, 5217100, 5152801, 5259295, 5248706, 5430087, 5430013, 5286387, 5189375, 5172634, 5177202, 5258406, 5146748, 5203811, 5153919, 5429928, 5156431, 5148170, 5153077, 5203028, 5262327, 5227094, 5219415, 5144659, 5161879, 5157218, 5429851, 5139190, 5248048, 5195057, 5146305, 5427920, 5280290, 5429799, 5169429, 5168233, 5137263, 5429783, 5417009, 5239197, 5161965, 5202336, 5201287, 5429752, 5234188, 5187650, 5161462, 5244767, 5254174, 5367561, 5183227, 5429676, 5297118, 5429671, 5171879, 5257713, 5177785, 5202873, 5429610, 5317394, 5241419, 5429587, 5429581, 5429580, 5250818, 5202055, 5429573, 5149072, 5412425, 5175453, 5186574, 5330592, 5429513, 5429512, 5154728, 5160064, 5429429, 5429420, 5214141, 5424621, 5221105, 5429396, 5429392, 5169882, 5179938, 5429382, 5429365, 5154756, 5345016, 5355570, 5390149, 5358457, 5257259, 5276187, 5429271, 5175148, 5206924, 5168784, 5429233, 5167654, 5429090, 5335107, 5329051, 5251343, 5217360, 5186371, 5257146, 5171988, 5428899, 5165025, 5148331, 5396491, 5207034, 5428663, 5428617, 5228018, 5428580, 5250684, 5428518, 5246836, 5139411, 5428519, 5428517, 5152473, 5428511, 5396067, 5192794, 5155645, 5152035, 5170903, 5164612, 5145970, 5263422, 5213027, 5181721, 5428201, 5252048, 5428118, 5180923, 5427998, 5278102, 5316349, 5234835, 5308427, 5408003, 5362332, 5196580, 5427899, 5193256, 5393756, 5206203, 5427813, 5427803, 5302964, 5427741, 5167761, 5344919, 5137147, 5427533, 5427517, 5372606, 5427476, 5416910, 5194558, 5427384, 5149762, 5305336, 5427365, 5427362, 5323059, 5427310, 5427304, 5427278, 5158951, 5427164, 5150882, 5184242, 5427014, 5197272, 5417772, 5343800, 5135491, 5427007, 5353935, 5185480, 5279567, 5426975, 5150367, 5398730, 5185921, 5426897, 5426857, 5426853, 5320354, 5426817, 5188534, 5414266, 5134271, 5426752, 5152050, 5283647, 5426750, 5300607, 5266830, 5426719, 5285128, 5162588, 5146518, 5178167, 5426677, 5426659, 5387310, 5144929, 5173236, 5426631, 5329625, 5297869, 5250148, 5184815, 5426497, 5149286, 5270429, 5237906, 5188290, 5175860, 5327867, 5225090, 5230640, 5378940, 5164808, 5139505, 5188072, 5426330, 5426320, 5426316, 5192945, 5212739, 5198582, 5313041, 5284536, 5249693, 5149903, 5176269, 5335976, 5426126, 5248540, 5144067, 5426083, 5426080, 5410298, 5426027, 5166539, 5181425, 5426020, 5425361, 5366003, 5248314, 5394361, 5425904, 5425905, 5155503, 5136676, 5263071, 5425884, 5397521, 5249098, 5425732, 5183219, 5265498, 5162752, 5425601, 5146096, 5425540, 5425541, 5425533, 5425511, 5425486, 5425433, 5425407, 5375833, 5315175, 5302066, 5404932, 5214314, 5425391, 5174814, 5425316, 5425170, 5425117, 5288214, 5305200, 5425052, 5292859, 5424896, 5316253, 5424868, 5226776, 5210095, 5208249, 5262254, 5310429, 5424794, 5424735, 5424554, 5237391, 5424538, 5153078, 5350306, 5424416, 5227318, 5157512, 5424284, 5424224, 5139194, 5291129, 5423855, 5154959, 5391935, 5410038, 5423763, 5423614, 5151245, 5175966, 5155743, 5423489, 5147874, 5423216, 5348249, 5210681, 5423093, 5423094, 5422693, 5230645, 5268719, 5172765, 5299355, 5363408, 5162958, 5420165, 5314092, 5416702, 5204687, 5222746, 5161729, 5391718, 5419759, 5411981, 5419742, 5338792, 5321887, 5419604, 5187222, 5419430, 5183728, 5185873, 5149720, 5247267, 5417710, 5417619, 5381915, 5239187, 5278694, 5247046, 5416346, 5257787, 5415899, 5168332, 5415867, 5203918, 5179595, 5288536, 5277789, 5219944, 5195618, 5413368, 5323671, 5146682, 5411081, 5157092, 5236514, 5341469, 5409765, 5404936, 5404937, 5400880, 5394551, 5380628, 5373996, 5361487, 5257827);

Date: 2024-12-20 19:41:03 Duration: 3ms

9

315,013

Details

18s208ms

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 20	00	5,511	316ms	0ms
	01	7,614	435ms	0ms
	02	5,591	315ms	0ms
	03	4,510	268ms	0ms
	04	2,933	181ms	0ms
	05	2,549	144ms	0ms
	06	2,617	135ms	0ms
	07	1,519	112ms	0ms
	08	7,441	453ms	0ms
	09	16,561	955ms	0ms
	10	20,414	1s267ms	0ms
	11	11,013	631ms	0ms
	12	26,883	1s629ms	0ms
	13	30,159	1s749ms	0ms
	14	28,990	1s714ms	0ms
	15	27,641	1s804ms	0ms
	16	22,874	1s308ms	0ms
	17	20,265	1s131ms	0ms
	18	23,485	1s283ms	0ms
	19	18,948	932ms	0ms
	20	11,880	568ms	0ms
	21	8,816	487ms	0ms
	22	6,799	380ms	0ms

SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (128, 11, 8, 7, 102, 38, 24, 70, 16, 28, 113, 71, 115, 10, 35, 78, 26, 48, 32, 19, 126, 49, 52, 39, 27, 65, 5, 42, 60, 121, 2, 64, 17, 6);

Date: 2024-12-20 17:35:18 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (78, 102, 51, 75, 40, 66, 61, 30, 70, 64, 27, 46, 22, 19, 5, 17, 38, 53, 65, 52, 6, 55);

Date: 2024-12-20 17:43:17 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17, 42, 32, 40, 30, 62, 53, 41, 123, 22, 85, 111, 14, 27, 3, 26, 68, 52, 51, 74);

Date: 2024-12-20 13:40:42 Duration: 0ms

10

219,050

Details

36s975ms

0ms

16ms

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 20	00	3,291	563ms	0ms
	01	4,977	849ms	0ms
	02	3,341	572ms	0ms
	03	2,771	497ms	0ms
	04	1,803	328ms	0ms
	05	1,743	314ms	0ms
	06	1,466	249ms	0ms
	07	1,437	228ms	0ms
	08	6,119	979ms	0ms
	09	11,728	1s874ms	0ms
	10	15,229	2s508ms	0ms
	11	7,770	1s214ms	0ms
	12	20,354	3s288ms	0ms
	13	22,337	3s705ms	0ms
	14	19,691	3s422ms	0ms
	15	20,226	3s699ms	0ms
	16	16,533	2s894ms	0ms
	17	14,125	2s473ms	0ms
	18	14,223	2s507ms	0ms
	19	11,507	1s899ms	0ms
	20	7,388	1s166ms	0ms
	21	6,059	938ms	0ms
	22	4,932	794ms	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 (8004658, 8004659, 8006317, 8006839, 8006374, 8007226, 8004657, 8006398, 8006296, 8006397, 8006341, 8006436, 8004672, 8006416, 8006360, 8006300, 8006324, 8004697, 8004669, 8004671, 8007492, 8006427, 8004805, 8007305, 8004661, 8007493, 8006294, 8007461, 8006417, 8006313, 8006602, 8006432, 8007563, 8006442, 8006273, 8006297, 8006345, 8006351, 8004698, 8004673, 8006353, 8004693, 8004679, 8006376, 8006330, 8006272, 8006326, 8006320, 8007502, 8006534, 8006302, 8006303, 8006288, 8006435);

Date: 2024-12-20 16:35:01 Duration: 16ms
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 (8004700);

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

Date: 2024-12-20 15:24:13 Duration: 1ms

11

173,320

Details

21h7m53s

384ms

766ms

438ms

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

Day	Hour	Count	Duration	Avg duration
Dec 20	00	5,311	38m14s	432ms
	01	7,644	54m56s	431ms
	02	7,463	52m31s	422ms
	03	8,970	1h4m10s	429ms
	04	5,845	41m31s	426ms
	05	5,294	37m21s	423ms
	06	4,339	30m46s	425ms
	07	3,720	28m10s	454ms
	08	2,848	19m48s	417ms
	09	6,732	47m26s	422ms
	10	12,071	1h27m29s	434ms
	11	5,274	37m3s	421ms
	12	9,489	1h9m12s	437ms
	13	9,145	1h6m14s	434ms
	14	11,273	1h22m20s	438ms
	15	12,637	1h35m17s	452ms
	16	11,386	1h23m35s	440ms
	17	12,901	1h37m38s	454ms
	18	11,497	1h28m7s	459ms
	19	7,563	56m43s	449ms
	20	5,259	39m20s	448ms
	21	3,370	25m12s	448ms
	22	3,289	24m39s	449ms

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

Date: 2024-12-20 18:06:03 Duration: 766ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773453)) AND (("shipping_track"."id" not in (30805093, 30805093)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:02 Duration: 764ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773455)) AND (("shipping_track"."id" not in (30805116, 30805116)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:05 Duration: 744ms

12

168,745

Details

51s993ms

0ms

4ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 20	00	3,187	867ms	0ms
	01	3,358	1s19ms	0ms
	02	1,819	585ms	0ms
	03	1,737	548ms	0ms
	04	1,155	362ms	0ms
	05	807	250ms	0ms
	06	390	118ms	0ms
	07	1,146	339ms	0ms
	08	4,272	1s263ms	0ms
	09	6,466	2s6ms	0ms
	10	7,166	2s302ms	0ms
	11	3,658	1s102ms	0ms
	12	11,778	3s611ms	0ms
	13	17,970	5s590ms	0ms
	14	14,113	4s446ms	0ms
	15	23,070	7s362ms	0ms
	16	16,458	5s87ms	0ms
	17	14,386	4s500ms	0ms
	18	10,752	3s470ms	0ms
	19	8,245	2s330ms	0ms
	20	6,850	1s930ms	0ms
	21	4,888	1s458ms	0ms
	22	5,074	1s437ms	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 = 1080) OR r.global) ORDER BY r.id;

Date: 2024-12-20 17:21:52 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'cash.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 848) OR r.global) ORDER BY r.id;

Date: 2024-12-20 15:07:39 Duration: 1ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'wating.wizard' 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 = 920) OR r.global) ORDER BY r.id;

Date: 2024-12-20 17:51:31 Duration: 1ms

13

140,376

Details

36s328ms

0ms

9ms

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 20	00	3,357	762ms	0ms
	01	4,433	1s80ms	0ms
	02	2,715	615ms	0ms
	03	3,290	835ms	0ms
	04	1,834	443ms	0ms
	05	1,540	387ms	0ms
	06	1,553	468ms	0ms
	07	2,243	529ms	0ms
	08	2,691	623ms	0ms
	09	6,539	1s608ms	0ms
	10	9,119	2s503ms	0ms
	11	4,771	1s179ms	0ms
	12	12,126	4s884ms	0ms
	13	12,158	2s941ms	0ms
	14	11,709	2s807ms	0ms
	15	10,755	3s175ms	0ms
	16	9,513	2s337ms	0ms
	17	9,194	2s220ms	0ms
	18	10,124	2s255ms	0ms
	19	8,410	1s963ms	0ms
	20	4,921	1s67ms	0ms
	21	4,152	871ms	0ms
	22	3,229	766ms	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 (41663558, 41630704, 41623026, 32640314, 41411820, 41416423, 41641324, 41556562, 40930979, 32638907, 32638359, 41678920, 41678832, 41678928, 41681085, 41504488, 41506285, 41638736, 41638700, 41638924, 41443605, 41423373, 41533387, 41119335, 41283370, 41372410, 41582991, 41567201, 41120299, 41530536, 41666826, 41381161, 41151585, 41447623, 41546680, 41119911, 41647404, 41346961, 41632806, 41616268, 41583216, 41404290, 41287681, 41642113, 41588501, 41634792, 41663166, 41675741, 41199920, 41636861, 41579582, 41374504, 41538999, 41637094, 41537791, 41516567, 41582980, 41583396, 41589039, 41293757, 41535844, 41604997, 41504362, 41624077, 41561725, 41279370, 41263380, 41489292, 41427051);

Date: 2024-12-20 17:21:57 Duration: 9ms
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 (41319994, 41278675, 41013060, 41311857, 40813080, 40812923, 41111465, 41111456, 41241857, 40962056, 41296232, 41295793, 41313521, 41312031, 41285630, 40897785, 41255494, 41101335, 40420781, 41199515, 41199560, 41259767, 41260460, 40970210, 41218565, 41218555, 41218245, 41218388, 41307608, 41266614, 41186983, 41169981, 41169980, 41266956, 41235414, 40040655, 41321609, 41123482, 41272772, 41231237, 41190800, 41185909, 41166666, 41307103, 41266589, 41214320, 41214303, 41185692, 41015323, 41318905, 41166280, 41307271, 41128325, 41123031, 41304648, 41169433, 40878090, 40878084, 41237414, 41214161, 41147593, 41147594, 41260093, 41013056, 40778861, 41047443, 41120727, 41296262, 40884059, 41168794, 41123478, 41130181, 41169952, 41246994, 41289748, 41266465, 41119122, 41265800, 41016607, 41128238, 41149280, 41080562, 41231409, 41015476, 41267895, 41123232, 41272762, 41289847, 40566016, 41266996, 40869791, 40763591, 40973768, 41263856, 40892378, 40973249, 41216896, 41164970, 41240290, 40959172);

Date: 2024-12-20 17:22:03 Duration: 7ms
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 (40870354, 40884071, 41454913, 41159479, 41613434, 41654550, 41677355, 41547283, 41585694, 41647080, 41602463, 41586601, 41492763, 41580147, 41592170, 41694414, 41604898);

Date: 2024-12-20 17:21:52 Duration: 6ms

14

129,557

Details

20s126ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 20	00	3,305	431ms	0ms
	01	2,510	361ms	0ms
	02	1,713	224ms	0ms
	03	1,918	255ms	0ms
	04	1,493	184ms	0ms
	05	1,163	143ms	0ms
	06	291	39ms	0ms
	07	1,343	184ms	0ms
	08	4,178	598ms	0ms
	09	5,356	797ms	0ms
	10	5,021	782ms	0ms
	11	2,989	427ms	0ms
	12	8,979	1s361ms	0ms
	13	12,439	2s5ms	0ms
	14	10,086	1s598ms	0ms
	15	16,200	2s824ms	0ms
	16	13,193	2s93ms	0ms
	17	11,408	1s879ms	0ms
	18	8,002	1s306ms	0ms
	19	5,526	781ms	0ms
	20	4,922	734ms	0ms
	21	3,858	570ms	0ms
	22	3,664	537ms	0ms

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-20 15:46:47 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 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-20 15:24:24 Duration: 1ms
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-20 15:04:00 Duration: 1ms

15

108,687

Details

7s771ms

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 20	00	2,099	128ms	0ms
	01	2,886	191ms	0ms
	02	2,029	133ms	0ms
	03	1,809	135ms	0ms
	04	1,130	86ms	0ms
	05	983	68ms	0ms
	06	1,134	68ms	0ms
	07	348	25ms	0ms
	08	2,362	154ms	0ms
	09	5,959	390ms	0ms
	10	7,909	576ms	0ms
	11	4,114	273ms	0ms
	12	10,057	685ms	0ms
	13	9,952	656ms	0ms
	14	9,925	675ms	0ms
	15	9,374	850ms	0ms
	16	7,629	606ms	0ms
	17	7,002	572ms	0ms
	18	7,621	640ms	0ms
	19	6,097	379ms	0ms
	20	3,267	175ms	0ms
	21	3,008	173ms	0ms
	22	1,993	119ms	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-20 17:21:52 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-20 18:05:54 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2024-12-20 17:16:03 Duration: 0ms

16

100,280

Details

59m36s

27ms

88ms

35ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 20	00	2,036	1m10s	34ms
	01	3,244	1m51s	34ms
	02	2,837	1m37s	34ms
	03	2,908	1m40s	34ms
	04	1,690	58s372ms	34ms
	05	1,683	58s283ms	34ms
	06	1,789	1m2s	34ms
	07	1,052	36s146ms	34ms
	08	1,429	49s632ms	34ms
	09	4,446	2m35s	34ms
	10	8,535	5m3s	35ms
	11	4,300	2m28s	34ms
	12	7,099	4m12s	35ms
	13	8,217	4m51s	35ms
	14	9,207	5m26s	35ms
	15	8,822	5m22s	36ms
	16	7,025	4m10s	35ms
	17	5,568	3m24s	36ms
	18	6,028	3m46s	37ms
	19	4,586	2m47s	36ms
	20	3,681	2m13s	36ms
	21	2,257	1m21s	36ms
	22	1,841	1m6s	36ms

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

Date: 2024-12-20 17:21:57 Duration: 88ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3749494)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 14:38:28 Duration: 77ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3670139)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 15:48:09 Duration: 76ms

17

97,174

Details

5h48m

182ms

409ms

214ms

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

Day	Hour	Count	Duration	Avg duration
Dec 20	00	1,187	3m58s	200ms
	01	974	3m16s	202ms
	02	1,674	5m38s	202ms
	03	1,874	6m18s	202ms
	04	3,540	12m4s	204ms
	05	1,952	6m34s	202ms
	06	638	2m7s	200ms
	07	2,893	9m51s	204ms
	08	3,816	12m56s	203ms
	09	5,535	19m4s	206ms
	10	8,031	28m12s	210ms
	11	6,489	21m57s	202ms
	12	6,002	21m7s	211ms
	13	5,885	20m35s	209ms
	14	3,928	13m51s	211ms
	15	13,601	49m59s	220ms
	16	7,619	26m47s	211ms
	17	9,595	36m57s	231ms
	18	8,307	33m29s	241ms
	19	2,216	8m1s	217ms
	20	437	1m35s	218ms
	21	940	3m24s	217ms
	22	41	8s922ms	217ms

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

Date: 2024-12-20 18:06:05 Duration: 409ms
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" = '9440939')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 18:06:04 Duration: 377ms
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" = '9327634')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 17:21:57 Duration: 372ms

18

94,836

Details

48s304ms

0ms

13ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 20	00	698	469ms	0ms
	01	1,193	734ms	0ms
	02	743	328ms	0ms
	03	203	121ms	0ms
	04	419	194ms	0ms
	05	148	85ms	0ms
	06	71	46ms	0ms
	07	749	298ms	0ms
	08	2,346	1s3ms	0ms
	09	4,461	2s18ms	0ms
	10	7,129	4s326ms	0ms
	11	4,442	1s990ms	0ms
	12	7,109	4s8ms	0ms
	13	6,241	2s911ms	0ms
	14	5,555	2s828ms	0ms
	15	12,796	7s357ms	0ms
	16	8,669	4s100ms	0ms
	17	12,834	5s917ms	0ms
	18	11,312	5s249ms	0ms
	19	3,217	1s406ms	0ms
	20	1,716	762ms	0ms
	21	1,734	1s222ms	0ms
	22	1,051	923ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (3666762, 3629973, 3666718, 3586946, 3705359, 3673070, 3329493, 3705298, 3645987, 3712196, 3639758, 3733837, 3762773, 3625757, 3732406, 3516539, 3437456, 3590609, 3527767, 3681204, 3731587, 3598565, 3692216, 3687174, 3713062, 3725812, 3671114, 3591074, 3696902, 3705512, 3705445, 3688724, 3660283, 3583346, 3757770, 3671257, 3733797, 3701963, 3706849, 3728128, 3680931, 3688076, 3733386, 3680215, 3206736, 3718691, 3713080, 3697640, 3734346, 3724089, 3697340, 3716247, 3737797, 3595831, 3713374, 3433027, 3644696, 3623857, 3724574, 3650143, 3722850, 3692591, 3605652, 3512759, 3739237, 3704681, 3595494, 3652054, 3680852, 3716770, 3731532, 3697701, 3680773, 3738252, 3676519, 3705360, 3680177, 3722592, 3719349, 3715323, 3632846, 3685867, 3722295, 3693661, 3693653, 3657520, 3607913, 3721170, 3678822, 3689049, 3696464, 3696460, 3728268, 3683125, 3728865, 3710595, 3716385, 3723116, 3714734, 3691962, 3252072, 3721986, 3381922, 3711033, 3679513, 3678923, 3691677, 3710017, 3723535, 3642608, 3673289, 3702002, 3735308, 3652011, 3686520, 3658236, 3687987, 3722786, 3697878, 3646564, 3689931, 3732646, 3728822, 3728863, 3730487, 3702101, 3715324, 3706320, 3722629, 3718753, 3714551, 3713074, 3679995, 3711089, 2589868, 3696886, 3716399, 3737800, 3711449, 3706315, 3672492, 3704695, 3724580, 3726731, 3736152, 3680799, 3631447, 3644341, 3732697, 3701970, 3718470, 3732658, 3722315, 3232091, 3534911, 3714200, 3732283, 3732630, 3714108, 3688621, 3723104, 3713727, 3632450, 3715982, 3687955, 3713735, 3682221, 3723528, 3732642, 3559074, 3717792, 3621760, 3702824, 3726910, 3647431, 3554224, 3699680, 3649521, 3596975, 3726725, 3735295, 3022086, 3438764, 3733491, 3517631, 3732640, 3732689, 3648780, 3662090, 3275089, 3646844, 3726932, 3657437, 3733478, 3704691);

Date: 2024-12-20 17:22:02 Duration: 13ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1193185, 2705784, 257738, 195852, 3454645, 1931051, 978947, 640081, 566971, 2509995, 640101, 684493, 2640422, 981149, 2911594, 2967621, 673383, 2977645, 1117035, 3225559, 1223876, 1223883, 2912668, 3404478, 363830, 1640349, 1717418, 2389344, 1559342, 634605, 634604, 3247738, 1458977, 1185634, 2268816, 2977641, 1608470, 1395688, 2260865, 3044320, 684464, 3336371, 3347287, 3535942, 3254696, 1110804, 866243, 3156082, 3156091, 398569, 3683757, 1990990, 437719, 3677601, 2301058, 715143, 991788, 170293, 522410, 1430725, 2367142, 978946, 2894127, 3569618, 115187, 764004, 163205, 3117795, 3344848, 1755190, 163201, 1791608, 1994126, 2624147, 790369, 1161414, 495947, 3261598, 464, 2191028, 2563660, 2110840, 3566014, 437763, 1815983, 936438, 1654625, 1425844, 726529, 3000863, 2563645, 3211335, 562692, 3451463, 2563801, 2186238, 726530, 2298891, 1384907, 1223869, 2563664, 2337543, 2617249, 325750, 2702282, 2506788, 634603, 3180867, 2146061, 1737148, 1755821, 3569620, 3279218, 1632391, 762023, 101695, 3569630, 1523698, 3313379, 1986257, 495953, 2185883, 196794, 3076922, 179253, 3218201, 291195, 3150381, 1717420, 558268, 3044102, 3254569, 3081585, 1923584, 3640898, 634596, 149469, 3482350, 1598717, 2640427, 1096365, 3077140, 3552016, 2268872, 3122715, 1558998, 2567279, 2567284, 1257177, 716038, 2441595, 3378618, 3378614, 2912713, 624277, 3261596, 2896275, 3076901, 1125834, 694675, 495957, 967583, 3547684, 2624949, 3295625, 2743155, 3376523, 3218193, 962435, 2470174, 1802845, 2121549, 2697812, 2476456, 2441926, 3218202, 2665348, 694676, 1046108, 726534, 1557237, 960025, 3353781, 3569584, 634591, 655811, 274496, 3520217, 2327764, 2031931, 437806, 952007);

Date: 2024-12-20 17:37:19 Duration: 8ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (529952, 670908, 760563, 945171, 760570, 591802, 2147333, 2351440, 2971299, 572560, 1972541, 2203930, 2496316, 1186926, 1220124, 537785, 2184037, 2970686, 255715, 193702, 1157552, 1525867, 1293082, 591237, 591411, 932296, 1915907, 3028229, 2030935, 1355097, 2342906, 1992315, 3127501, 2842777, 2315051, 1643980, 741824, 2977791, 996480, 423478, 1865121, 838918, 1458084, 2711783, 1871460, 542649, 2988123, 276137, 3183407, 1387945, 3507737, 861045, 1385281, 2430904, 1671864, 1644213, 2106810, 2248140, 1939509, 1679418, 1543786, 3414933, 1679484, 2386267, 1779007, 1626017, 2325899, 559087, 2403682, 2922610, 3305314, 3393722, 1403516, 3428453, 453571, 289811, 509662, 3132163, 544473, 1167077, 2374408, 2872549, 2076159, 340222, 438036, 892057, 496215, 300893, 171923, 78274, 2377459, 779345, 2020058, 2680341, 461850, 68336, 2714150, 681805, 543329, 358578, 1048659, 1094239, 950837, 2593889);

Date: 2024-12-20 17:25:41 Duration: 8ms

19

84,276

Details

26s235ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 20	00	5,840	1s725ms	0ms
	01	7,314	2s215ms	0ms
	02	4,300	1s575ms	0ms
	03	8,213	2s631ms	0ms
	04	4,582	1s569ms	0ms
	05	3,738	1s277ms	0ms
	06	2,725	920ms	0ms
	07	7,911	2s119ms	0ms
	08	506	228ms	0ms
	09	929	435ms	0ms
	10	2,279	931ms	0ms
	11	903	275ms	0ms
	12	2,456	888ms	0ms
	13	711	305ms	0ms
	14	2,182	802ms	0ms
	15	881	387ms	0ms
	16	2,890	926ms	0ms
	17	4,512	1s280ms	0ms
	18	4,855	1s381ms	0ms
	19	5,999	1s604ms	0ms
	20	4,391	1s136ms	0ms
	21	2,616	671ms	0ms
	22	3,543	944ms	0ms

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

Date: 2024-12-20 17:22:01 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 55) AND ("price_list"."to_office_id" = 13)) ORDER BY "price_list"."id";

Date: 2024-12-20 01:15:02 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 51) AND ("price_list"."to_office_id" = 48)) ORDER BY "price_list"."id";

Date: 2024-12-20 09:42:59 Duration: 1ms

20

81,892

Details

4s852ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 20	00	2,055	98ms	0ms
	01	2,951	144ms	0ms
	02	2,450	105ms	0ms
	03	2,471	109ms	0ms
	04	1,588	70ms	0ms
	05	1,374	55ms	0ms
	06	1,307	44ms	0ms
	07	538	26ms	0ms
	08	1,679	91ms	0ms
	09	3,888	206ms	0ms
	10	4,679	251ms	0ms
	11	2,762	130ms	0ms
	12	6,553	374ms	0ms
	13	7,543	466ms	0ms
	14	6,418	400ms	0ms
	15	7,428	585ms	0ms
	16	5,816	407ms	0ms
	17	5,476	383ms	0ms
	18	4,358	291ms	0ms
	19	4,825	247ms	0ms
	20	2,487	161ms	0ms
	21	1,731	102ms	0ms
	22	1,515	95ms	0ms

SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (42, 78, 123);

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

Date: 2024-12-20 11:16:49 Duration: 0ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (15, 40, 62, 64, 37, 66);

Date: 2024-12-20 09:26:23 Duration: 0ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

7m20s

12

Details

1h28m10s

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 20	00	2	2ms	1ms
	04	1	0ms	0ms
	10	1	0ms	0ms
	13	1	1ms	1ms
	15	1	1ms	1ms
	17	1	0ms	0ms
	18	1	1ms	1ms
	19	2	59m59s	29m59s
	20	1	28m10s	28m10s
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-20 17:50:56.596065', "last_update" = '2024-12-20 17:05:56.596095', "write_date" = '2024-12-20 17:05:56.078199', "write_uid" = 1 WHERE id IN (875);

Date: 2024-12-20 19:05:56 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2024-12-20 19:49:10.168852', "last_update" = '2024-12-20 19:04:10.168875', "write_date" = '2024-12-20 19:04:09.841257', "write_uid" = 1 WHERE id IN (1229);

Date: 2024-12-20 20:32:21 Duration: 28m10s
UPDATE "res_users" SET "exp_date" = '2024-12-20 13:08:25.899452', "last_update" = '2024-12-20 12:23:25.899477', "write_date" = '2024-12-20 12:23:25.558115', "write_uid" = 886 WHERE id IN (886);

Date: 2024-12-20 13:23:25 Duration: 1ms

2

0ms

23m21s

13s440ms

184

Details

41m13s

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 20	00	6	6ms	1ms
	01	3	5ms	1ms
	02	2	2ms	1ms
	04	5	6ms	1ms
	05	3	0ms	0ms
	07	2	1ms	0ms
	08	10	3ms	0ms
	09	9	3ms	0ms
	10	9	1ms	0ms
	11	4	0ms	0ms
	12	12	7ms	0ms
	13	19	35m2s	1m50s
	14	19	2m41s	8s488ms
	15	17	3m28s	12s279ms
	16	11	11ms	1ms
	17	13	15ms	1ms
	18	10	4ms	0ms
	19	10	5ms	0ms
	20	7	5ms	0ms
	21	6	7ms	1ms
	22	7	8ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-20 12:34:59.959390', "last_update" = '2024-12-20 11:49:59.959412', "sid" = '630536555451fb450491761c74fb365550efd24a', "write_date" = '2024-12-20 11:49:59.614346', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 23m21s
UPDATE "res_users" SET "exp_date" = '2024-12-20 12:52:22.181978', "last_update" = '2024-12-20 12:07:22.181999', "sid" = '630536555451fb450491761c74fb365550efd24a', "write_date" = '2024-12-20 12:07:21.857314', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 5m59s
UPDATE "res_users" SET "exp_date" = '2024-12-20 12:54:34.064492', "last_update" = '2024-12-20 12:09:34.064510', "sid" = '453519eb25e681c733dce7b6d8e252d766e1e286', "write_date" = '2024-12-20 12:09:33.743646', "write_uid" = 1060 WHERE id IN (1060);

Date: 2024-12-20 13:13:21 Duration: 3m47s

3

0ms

1h

3s809ms

39,999

Details

1d18h19m40s

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 20	00	714	1h51m36s	9s379ms
	01	850	182ms	0ms
	02	841	172ms	0ms
	03	819	168ms	0ms
	04	678	144ms	0ms
	05	529	110ms	0ms
	06	293	60ms	0ms
	07	207	55ms	0ms
	08	1,114	234ms	0ms
	09	2,163	452ms	0ms
	10	2,251	497ms	0ms
	11	1,440	2h10m7s	5s421ms
	12	3,216	4h23m48s	4s921ms
	13	3,535	5h29m24s	5s590ms
	14	3,776	2h57m16s	2s816ms
	15	4,154	8h9m3s	7s64ms
	16	3,407	2h54m15s	3s68ms
	17	2,485	6m30s	157ms
	18	2,452	1m31s	37ms
	19	2,169	1h58m16s	3s271ms
	20	1,239	8h59m35s	26s130ms
	21	911	204ms	0ms
	22	756	3h18m10s	15s728ms

update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996994', exp_date = '2024-12-20 18:54:01.996997', logged_in = 'TRUE' where id = 960;

Date: 2024-12-20 20:09:02 Duration: 1h
update res_users set sid = 'c7e49afd83adf05a6faecf112971984255a6c235', last_update = '2024-12-20 18:09:01.996854', exp_date = '2024-12-20 18:54:01.996858', logged_in = 'TRUE' where id = 960;

Date: 2024-12-20 20:09:02 Duration: 1h
update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-20 12:44:40.791358', exp_date = '2024-12-20 13:29:40.791360', logged_in = 'TRUE' where id = 861;

Date: 2024-12-20 14:44:40 Duration: 1h

4

3s7ms

4s152ms

3s245ms

148

Details

8m

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 20	10	6	19s530ms	3s255ms
	11	3	9s588ms	3s196ms
	12	4	12s536ms	3s134ms
	13	9	29s269ms	3s252ms
	14	4	12s852ms	3s213ms
	15	21	1m14s	3s546ms
	16	12	39s65ms	3s255ms
	17	11	35s751ms	3s250ms
	18	3	10s745ms	3s581ms
	19	14	45s395ms	3s242ms
	20	31	1m37s	3s144ms
	21	11	34s116ms	3s101ms
	22	19	59s508ms	3s132ms

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

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

Date: 2024-12-20 15:28:44 Duration: 4s53ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6))))))) 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 (6)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (6))))))))) 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 (6)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-20 15:28:24 Duration: 3s913ms

5

906ms

1s429ms

966ms

4,771

Details

1h16m50s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 20	00	345	5m31s	961ms
	01	400	6m22s	955ms
	02	284	4m36s	974ms
	03	74	1m11s	972ms
	09	21	20s469ms	974ms
	11	6	5s857ms	976ms
	12	5	4s831ms	966ms
	13	7	7s22ms	1s3ms
	14	24	23s825ms	992ms
	15	21	20s621ms	981ms
	16	152	2m30s	991ms
	17	246	4m1s	981ms
	18	865	14m15s	988ms
	19	539	8m37s	960ms
	20	775	12m20s	955ms
	21	501	7m58s	954ms
	22	506	8m1s	952ms

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

Date: 2024-12-20 18:06:04 Duration: 1s429ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9514226')) 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 (2))))))) 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 (2)))))) 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 (2)))))) 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 (2))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-20 18:06:01 Duration: 1s414ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9420648')) 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 (68))))))) 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 (68)))))) 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 (68)))))) 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 (68))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-20 18:05:59 Duration: 1s368ms

6

385ms

1s491ms

449ms

29,710

Details

3h42m31s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 20	00	127	1m	477ms
	01	244	1m52s	460ms
	02	628	4m32s	433ms
	03	187	1m30s	481ms
	04	157	1m14s	475ms
	05	135	1m6s	489ms
	06	62	30s612ms	493ms
	07	74	35s515ms	479ms
	08	839	5m58s	427ms
	09	1,239	9m2s	437ms
	10	1,923	14m21s	448ms
	11	1,104	7m59s	434ms
	12	1,850	13m47s	447ms
	13	2,671	19m51s	446ms
	14	2,844	21m13s	447ms
	15	2,388	18m43s	470ms
	16	1,949	14m39s	451ms
	17	2,681	20m18s	454ms
	18	3,148	24m	457ms
	19	2,170	16m5s	444ms
	20	1,773	12m58s	439ms
	21	836	6m8s	441ms
	22	681	4m59s	439ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3702794)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 17:21:57 Duration: 1s491ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3736215, 3736211, 3736167, 3735031, 3731629, 3729473, 3729407, 3729316, 3728614, 3727864, 3727630, 3727442, 3727325, 3725783, 3725724, 3725481, 3725288, 3725268, 3724973, 3724861, 3724408, 3723863, 3721878, 3721409, 3721186, 3719945, 3719221, 3719147, 3718506, 3716908, 3716537, 3715899, 3715866, 3713213, 3711753, 3709963, 3709949, 3707441, 3704003, 3701243, 3701163, 3697471, 3697412, 3697408, 3691957, 3691788, 3688520, 3688505, 3688481, 3683948, 3675936, 3672255, 3666471, 3444522)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 17:21:57 Duration: 1s273ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3723669, 3721914, 3716560, 3716202, 3714638, 3709765, 3690417, 3678049)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 15:47:36 Duration: 739ms

7

384ms

766ms

438ms

173,320

Details

21h7m53s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 20	00	5,311	38m14s	432ms
	01	7,644	54m56s	431ms
	02	7,463	52m31s	422ms
	03	8,970	1h4m10s	429ms
	04	5,845	41m31s	426ms
	05	5,294	37m21s	423ms
	06	4,339	30m46s	425ms
	07	3,720	28m10s	454ms
	08	2,848	19m48s	417ms
	09	6,732	47m26s	422ms
	10	12,071	1h27m29s	434ms
	11	5,274	37m3s	421ms
	12	9,489	1h9m12s	437ms
	13	9,145	1h6m14s	434ms
	14	11,273	1h22m20s	438ms
	15	12,637	1h35m17s	452ms
	16	11,386	1h23m35s	440ms
	17	12,901	1h37m38s	454ms
	18	11,497	1h28m7s	459ms
	19	7,563	56m43s	449ms
	20	5,259	39m20s	448ms
	21	3,370	25m12s	448ms
	22	3,289	24m39s	449ms

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

Date: 2024-12-20 18:06:03 Duration: 766ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773453)) AND (("shipping_track"."id" not in (30805093, 30805093)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:02 Duration: 764ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3773455)) AND (("shipping_track"."id" not in (30805116, 30805116)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-20 18:06:05 Duration: 744ms

8

226ms

441ms

301ms

11,902

Details

59m42s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 20	00	864	4m12s	292ms
	01	1,060	5m11s	294ms
	02	283	1m23s	296ms
	03	1,385	6m44s	291ms
	04	697	3m23s	292ms
	05	558	2m40s	288ms
	06	415	2m	290ms
	07	1,881	9m10s	292ms
	08	11	3s201ms	291ms
	09	8	2s154ms	269ms
	10	260	1m18s	302ms
	11	191	55s859ms	292ms
	12	380	2m	316ms
	13	54	16s356ms	302ms
	14	331	1m41s	305ms
	15	69	21s430ms	310ms
	16	493	2m32s	310ms
	17	865	4m37s	320ms
	18	357	1m58s	332ms
	19	925	4m49s	313ms
	20	324	1m42s	316ms
	21	155	48s919ms	315ms
	22	336	1m44s	310ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9468566')) 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-20 18:05:33 Duration: 441ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9494950')) 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-20 17:39:13 Duration: 436ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9509804')) 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-20 17:34:37 Duration: 431ms

9

184ms

441ms

260ms

19,512

Details

1h24m39s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 20	07	142	34s395ms	242ms
	08	1,145	4m45s	249ms
	09	1,991	8m26s	254ms
	10	2,506	10m42s	256ms
	11	1,551	6m28s	250ms
	12	2,375	10m20s	261ms
	13	1,407	6m3s	258ms
	14	1,264	5m24s	256ms
	15	3,214	14m19s	267ms
	16	1,257	5m41s	271ms
	17	785	3m29s	267ms
	18	1,177	5m15s	268ms
	19	698	3m7s	268ms

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

Date: 2024-12-20 15:47:42 Duration: 441ms
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" = '8792173')))) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:43 Duration: 439ms
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" = '9365729')))) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:43 Duration: 435ms

10

192ms

387ms

255ms

3,194

Details

13m34s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 20	08	84	20s911ms	248ms
	09	168	41s384ms	246ms
	10	446	1m56s	260ms
	11	895	3m38s	243ms
	13	806	3m26s	255ms
	14	201	52s14ms	258ms
	15	594	2m39s	269ms

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" = '9290411') 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-20 15:43:38 Duration: 387ms
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" = '9415225') 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-20 14:33:23 Duration: 359ms
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" = '9444225') 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-20 15:47:43 Duration: 357ms

11

92ms

831ms

219ms

32,894

Details

2h6s

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 20	00	2,392	9m3s	227ms
	01	2,875	9m47s	204ms
	02	1,131	3m45s	198ms
	03	2,874	10m39s	222ms
	04	1,366	5m1s	220ms
	05	1,106	4m2s	219ms
	06	822	2m58s	217ms
	07	3,752	13m4s	209ms
	08	22	3s206ms	145ms
	09	50	7s238ms	144ms
	10	488	2m3s	253ms
	11	374	1m12s	194ms
	12	768	2m50s	221ms
	13	116	32s634ms	281ms
	14	684	2m35s	226ms
	15	168	33s294ms	198ms
	16	1,276	5m34s	262ms
	17	2,182	8m36s	236ms
	18	2,408	9m21s	233ms
	19	2,894	10m46s	223ms
	20	2,176	7m40s	211ms
	21	1,302	4m24s	203ms
	22	1,668	5m19s	191ms

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-20 18:06:56 Duration: 831ms
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-20 18:06:56 Duration: 830ms
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-20 16:54:01 Duration: 797ms

12

182ms

409ms

214ms

97,174

Details

5h48m

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 20	00	1,187	3m58s	200ms
	01	974	3m16s	202ms
	02	1,674	5m38s	202ms
	03	1,874	6m18s	202ms
	04	3,540	12m4s	204ms
	05	1,952	6m34s	202ms
	06	638	2m7s	200ms
	07	2,893	9m51s	204ms
	08	3,816	12m56s	203ms
	09	5,535	19m4s	206ms
	10	8,031	28m12s	210ms
	11	6,489	21m57s	202ms
	12	6,002	21m7s	211ms
	13	5,885	20m35s	209ms
	14	3,928	13m51s	211ms
	15	13,601	49m59s	220ms
	16	7,619	26m47s	211ms
	17	9,595	36m57s	231ms
	18	8,307	33m29s	241ms
	19	2,216	8m1s	217ms
	20	437	1m35s	218ms
	21	940	3m24s	217ms
	22	41	8s922ms	217ms

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

Date: 2024-12-20 18:06:05 Duration: 409ms
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" = '9440939')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 18:06:04 Duration: 377ms
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" = '9327634')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-20 17:21:57 Duration: 372ms

13

181ms

292ms

209ms

10,474

Details

36m34s

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 20	00	60	12s112ms	201ms
	02	27	5s453ms	201ms
	03	309	1m2s	202ms
	04	447	1m30s	202ms
	05	125	25s239ms	201ms
	06	84	16s861ms	200ms
	07	131	26s871ms	205ms
	08	430	1m26s	202ms
	09	717	2m28s	206ms
	10	899	3m6s	207ms
	11	399	1m20s	202ms
	12	818	2m49s	207ms
	13	908	3m9s	208ms
	14	1,228	4m19s	211ms
	15	1,344	4m48s	214ms
	16	1,289	4m29s	208ms
	17	517	1m52s	217ms
	18	245	54s133ms	220ms
	19	248	54s262ms	218ms
	20	225	49s41ms	217ms
	22	24	5s192ms	216ms

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

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

Date: 2024-12-20 17:34:33 Duration: 280ms

14

185ms

286ms

209ms

5,867

Details

20m26s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 20	00	1	194ms	194ms
	07	890	3m4s	207ms
	08	84	17s189ms	204ms
	09	550	1m54s	208ms
	10	468	1m39s	213ms
	11	792	2m41s	203ms
	12	238	49s141ms	206ms
	13	2,006	6m58s	208ms
	14	238	49s932ms	209ms
	15	600	2m11s	218ms

SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9194494')) 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-20 15:43:41 Duration: 286ms
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" = '9274676')) 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-20 14:33:23 Duration: 285ms
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" = '9030509')) 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-20 13:37:49 Duration: 283ms

15

184ms

238ms

202ms

10,806

Details

36m27s

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 20	00	1,126	3m46s	200ms
	01	974	3m16s	202ms
	02	1,647	5m32s	202ms
	03	1,545	5m12s	202ms
	04	2,565	8m41s	203ms
	05	1,827	6m9s	202ms
	06	554	1m51s	200ms
	07	568	1m56s	205ms

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

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

Date: 2024-12-20 04:57:58 Duration: 232ms

16

143ms

253ms

180ms

2,726

Details

8m13s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 20	00	120	22s225ms	185ms
	01	120	22s180ms	184ms
	02	120	22s213ms	185ms
	03	120	22s328ms	186ms
	04	120	22s156ms	184ms
	05	120	22s157ms	184ms
	06	120	22s166ms	184ms
	07	120	22s134ms	184ms
	08	120	22s395ms	186ms
	09	120	22s550ms	187ms
	10	120	23s107ms	192ms
	11	120	22s473ms	187ms
	12	120	23s200ms	193ms
	13	120	22s944ms	191ms
	14	120	23s161ms	193ms
	15	120	23s817ms	198ms
	16	120	23s87ms	192ms
	17	116	20s21ms	172ms
	18	120	19s515ms	162ms
	19	120	18s724ms	156ms
	20	120	18s499ms	154ms
	21	120	18s527ms	154ms
	22	90	13s807ms	153ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 16:04:02 Duration: 253ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 16:04:02 Duration: 247ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-20 18:06:01 Duration: 246ms

17

76ms

227ms

91ms

8,025

Details

12m18s

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 20	02	35	3s277ms	93ms
	08	150	13s981ms	93ms
	09	232	21s639ms	93ms
	10	386	35s998ms	93ms
	11	152	14s86ms	92ms
	12	584	53s165ms	91ms
	13	1,744	2m36s	89ms
	14	670	1m2s	93ms
	15	530	51s180ms	96ms
	16	648	59s512ms	91ms
	17	643	1m1s	96ms
	18	755	1m9s	92ms
	19	442	41s33ms	92ms
	20	403	35s877ms	89ms
	21	465	40s804ms	87ms
	22	186	16s723ms	89ms

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

Date: 2024-12-20 17:22:57 Duration: 227ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7853809)) AND (("cash_track"."id" not in (5982492)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-20 18:06:05 Duration: 157ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7833602)) AND (("cash_track"."id" not in (5827751, 5840800, 5863222, 5982485, 5982491, 5982491)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-20 18:06:04 Duration: 151ms

18

34ms

90ms

43ms

45,135

Details

32m32s

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 20	01	19	873ms	45ms
	02	12	542ms	45ms
	03	10	430ms	43ms
	04	5	232ms	46ms
	07	132	5s528ms	41ms
	08	328	13s860ms	42ms
	09	4,149	2m54s	42ms
	10	6,948	4m59s	43ms
	11	2,820	1m57s	41ms
	12	3,160	2m17s	43ms
	13	3,305	2m23s	43ms
	14	6,056	4m23s	43ms
	15	7,424	5m29s	44ms
	16	2,941	2m7s	43ms
	17	2,078	1m30s	43ms
	18	2,997	2m10s	43ms
	19	2,206	1m32s	41ms
	20	312	13s362ms	42ms
	21	128	5s442ms	42ms
	22	105	4s500ms	42ms

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

Date: 2024-12-20 15:28:52 Duration: 90ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3665022) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-20 18:06:04 Duration: 80ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 2780945) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-20 17:22:07 Duration: 75ms

19

30ms

70ms

39ms

20,330

Details

13m19s

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 20	07	66	2s437ms	36ms
	08	505	19s420ms	38ms
	09	1,445	53s992ms	37ms
	10	3,288	2m6s	38ms
	11	1,376	51s918ms	37ms
	12	1,641	1m2s	38ms
	13	2,525	1m41s	40ms
	14	1,855	1m12s	39ms
	15	3,806	2m38s	41ms
	16	1,271	50s427ms	39ms
	17	703	27s878ms	39ms
	18	1,136	44s574ms	39ms
	19	713	26s927ms	37ms

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

Date: 2024-12-20 13:59:48 Duration: 70ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3683933) ORDER BY "collection_policy"."id";

Date: 2024-12-20 13:59:48 Duration: 67ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3585335) ORDER BY "collection_policy"."id";

Date: 2024-12-20 15:47:40 Duration: 60ms

20

27ms

88ms

35ms

100,280

Details

59m36s

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 20	00	2,036	1m10s	34ms
	01	3,244	1m51s	34ms
	02	2,837	1m37s	34ms
	03	2,908	1m40s	34ms
	04	1,690	58s372ms	34ms
	05	1,683	58s283ms	34ms
	06	1,789	1m2s	34ms
	07	1,052	36s146ms	34ms
	08	1,429	49s632ms	34ms
	09	4,446	2m35s	34ms
	10	8,535	5m3s	35ms
	11	4,300	2m28s	34ms
	12	7,099	4m12s	35ms
	13	8,217	4m51s	35ms
	14	9,207	5m26s	35ms
	15	8,822	5m22s	36ms
	16	7,025	4m10s	35ms
	17	5,568	3m24s	36ms
	18	6,028	3m46s	37ms
	19	4,586	2m47s	36ms
	20	3,681	2m13s	36ms
	21	2,257	1m21s	36ms
	22	1,841	1m6s	36ms

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

Date: 2024-12-20 17:21:57 Duration: 88ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3749494)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 14:38:28 Duration: 77ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3670139)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-20 15:48:09 Duration: 76ms

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

11,443,604 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	7	0.00%
DETAIL	8	0.00%
ERROR	2,382	0.02%
EVENTLOG	432	0.00%
FATAL	466	0.00%
HINT	3	0.00%
LOG	11,437,888	99.95%
STATEMENT	2,418	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
466 FATAL entries
2382 ERROR entries
0 WARNING entries
432 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,263 Max number of times the same event was reported
3,280 Total events found

Rank

Times reported

Error

1

1,263

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 20	00	14
	01	12
	02	18
	03	8
	04	8
	05	5
	06	3
	07	15
	08	58
	09	36
	10	40
	11	25
	12	59
	13	104
	14	138
	15	186
	16	151
	17	193
	18	79
	19	39
	20	44
	21	11
	22	17

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

2

1,105

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 20	00	11
	01	12
	02	16
	03	7
	04	6
	05	4
	06	3
	07	14
	08	54
	09	32
	10	35
	11	18
	12	53
	13	97
	14	127
	15	151
	16	129
	17	171
	18	60
	19	34
	20	44
	21	11
	22	16

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

3

284

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 20	11	2
	12	27
	13	24
	14	8
	15	94
	16	70
	19	2
	20	27
	22	30

LOG: could not send data to client: Broken pipe

4

284

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 20	11	2
	12	27
	13	24
	14	8
	15	94
	16	70
	19	2
	20	27
	22	30

5

128

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 20	17	128

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

6

108

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 20	00	2
	07	3
	11	1
	12	5
	13	15
	14	6
	15	35
	16	28
	19	2
	20	9
	22	2

7

39

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 20	12	2
	13	3
	14	2
	15	17
	16	11
	20	3
	22	1

8

16

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 20	17	16

9

8

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 20	17	8

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

10

7

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 20	07	1
	08	1
	09	2
	15	1
	16	1
	17	1

11

7

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 20	07	1
	08	1
	09	2
	15	1
	16	1
	17	1

12

7

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 20	07	1
	08	1
	09	2
	15	1
	16	1
	17	1

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 20	00	1
	05	2
	19	2
	21	1

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

14

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 20	15	3

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

15

3

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 20	19	3

FATAL: password authentication failed for user "postgres"

16

2

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 20	17	2

17

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 20	04	1
	07	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 20	13	1
	15	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

19

1

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 20	03	1

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 20	17	1

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

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 20	17	1

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

22

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 20	18	1

ERROR: could not serialize access due to concurrent delete

23

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 20	17	1

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 20	16	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