pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Thu Mar 13 23:48:18 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,564,541 log entries in 3m17s
Log start from 2025-03-12 23:00:09 to 2025-03-13 19:45:01

Global Stats

19,978 Number of unique normalized queries
18,771,719 Number of queries
7d17h30m18s Total query duration
2025-03-12 23:00:09 First query
2025-03-13 19:45:01 Last query
3,188 queries/s at 2025-03-13 14:21:56 Query peak

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

3,465 Number of events
23 Number of unique normalized events
1,305 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
18,771,719 Average queries per session
7d17h30m18s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

3,188 queries/s Query Peak
2025-03-13 14:21:56 Date

SELECT Traffic

Key values

2,162 queries/s Query Peak
2025-03-13 14:21:56 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,150 queries/s Query Peak
2025-03-13 18:57:23 Date

Queries duration

Key values

7d17h30m18s 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)
Mar 12	23	705,671	0ms	43s323ms	29ms	8m8s	9m24s	11m11s
Mar 13	00	484,869	0ms	49s296ms	32ms	6m37s	6m41s	7m17s
	01	422,633	0ms	4m14s	42ms	8m2s	9m54s	12m18s
	02	376,308	0ms	23s662ms	42ms	8m25s	9m27s	10m
	03	291,994	0ms	3m5s	33ms	5m26s	5m48s	6m55s
	04	381,313	0ms	1s894ms	36ms	5m42s	6m6s	7m8s
	05	346,254	0ms	1m14s	47ms	8m13s	10m15s	10m54s
	06	377,808	0ms	11s525ms	44ms	7m2s	8m40s	9m38s
	07	344,114	0ms	3s377ms	35ms	5m6s	6m23s	6m51s
	08	588,529	0ms	10s743ms	28ms	6m14s	7m41s	9m57s
	09	1,092,218	0ms	9s224ms	19ms	8m42s	9m45s	10m25s
	10	1,658,022	0ms	59s565ms	19ms	15m4s	16m18s	18m16s
	11	1,812,142	0ms	38s603ms	32ms	23m	25m11s	25m39s
	12	1,884,854	0ms	2m21s	53ms	37m40s	42m23s	45m11s
	13	1,870,863	0ms	10m7s	60ms	45m6s	46m44s	55m4s
	14	1,594,026	0ms	1m10s	33ms	25m23s	28m25s	29m55s
	15	1,456,351	0ms	7s995ms	23ms	14m35s	16m48s	18m52s
	16	941,236	0ms	4s42ms	24ms	11m35s	12m23s	13m27s
	17	506,181	0ms	54s472ms	32ms	8m56s	9m29s	10m46s
	18	880,678	0ms	1m6s	36ms	13m42s	14m33s	16m57s
	19	755,655	0ms	14m49s	32ms	13m58s	14m42s	23m40s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 12	23	427,882	47ms	7m5s	8m8s	10m13s
Mar 13	00	279,110	56ms	5m50s	6m37s	6m49s
	01	236,488	75ms	6m18s	7m32s	10m13s
	02	212,956	74ms	7m3s	8m25s	9m47s
	03	161,486	59ms	4m9s	5m12s	5m48s
	04	211,388	65ms	5m2s	5m42s	6m43s
	05	188,397	86ms	6m56s	8m12s	10m44s
	06	201,246	83ms	5m45s	7m1s	8m57s
	07	190,035	63ms	4m29s	5m5s	6m24s
	08	348,698	47ms	5m53s	6m14s	8m31s
	09	654,798	32ms	7m31s	8m41s	10m1s
	10	1,004,106	32ms	11m43s	15m2s	16m26s
	11	1,065,223	54ms	20m6s	22m57s	25m8s
	12	1,086,100	92ms	34m8s	37m37s	43m29s
	13	1,101,328	100ms	40m47s	44m54s	46m41s
	14	987,463	54ms	21m59s	24m47s	29m40s
	15	899,940	38ms	12m4s	14m34s	16m53s
	16	536,467	43ms	8m21s	11m34s	12m36s
	17	273,208	60ms	7m12s	8m56s	10m36s
	18	501,386	63ms	11m34s	13m41s	14m43s
	19	439,303	56ms	11m53s	13m3s	23m39s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Mar 12	23	53,433	12,542	553	0	0ms	324ms	385ms	843ms
Mar 13	00	39,363	8,995	194	0	1ms	253ms	304ms	418ms
	01	45,364	8,303	164	0	5ms	260ms	349ms	635ms
	02	34,789	8,001	129	0	1ms	334ms	482ms	1s146ms
	03	26,848	5,118	162	0	6ms	201ms	269ms	378ms
	04	33,684	7,680	92	0	0ms	233ms	272ms	333ms
	05	36,033	8,647	115	0	4ms	260ms	372ms	510ms
	06	37,441	7,060	298	0	0ms	253ms	301ms	511ms
	07	27,252	6,789	87	0	0ms	189ms	228ms	281ms
	08	37,417	10,107	255	0	0ms	251ms	284ms	357ms
	09	55,590	14,209	723	0	0ms	355ms	407ms	487ms
	10	81,925	17,596	1,284	0	1ms	562ms	767ms	1s63ms
	11	94,386	22,696	1,027	0	1ms	833ms	893ms	1s120ms
	12	125,556	24,902	1,210	0	5ms	1s240ms	1s572ms	1m47s
	13	110,890	23,777	1,094	1	11ms	1s123ms	1s279ms	4m1s
	14	81,538	17,657	978	0	1ms	957ms	1s239ms	14s810ms
	15	74,257	17,754	1,102	0	0ms	543ms	712ms	959ms
	16	53,581	12,780	662	0	0ms	359ms	454ms	772ms
	17	31,424	9,092	413	0	0ms	226ms	264ms	353ms
	18	68,763	16,805	639	0	0ms	392ms	473ms	1s11ms
	19	44,725	10,034	568	0	2ms	386ms	444ms	616ms

Day	Hour	Percentage of prepare
Mar 12	23	0.00%
Mar 13	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%

Day	Hour	Average / Second
Mar 12	23	0.00/s
Mar 13	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

Day	Hour	Average Duration	Average idle time
Mar 12	23	0ms	0ms
Mar 13	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

↑ 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

102,279 buffers Checkpoint Peak
2025-03-13 14:09:41 Date
270.057 seconds Highest write time
0.016 seconds Sync time

Checkpoints Wal files

Key values

37 files Wal files usage Peak
2025-03-13 12:39:40 Date

Checkpoints distance

Key values

1,158.50 Mo Distance Peak
2025-03-13 12:39:40 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Mar 12	23	290,075	2,968.763s	0.04s	2,968.858s
Mar 13	00	193,422	3,239.503s	0.039s	3,239.594s
	01	240,144	3,239.609s	0.033s	3,239.697s
	02	256,584	2,429.702s	0.065s	2,429.822s
	03	155,744	3,239.555s	0.033s	3,239.639s
	04	232,317	3,239.558s	0.037s	3,239.658s
	05	218,743	3,161.948s	0.05s	3,162.061s
	06	308,795	3,239.567s	0.039s	3,239.689s
	07	215,390	3,239.562s	0.036s	3,239.656s
	08	235,967	2,969.506s	0.04s	2,969.608s
	09	389,322	3,239.509s	0.048s	3,239.625s
	10	609,904	3,239.428s	0.058s	3,239.585s
	11	718,751	2,969.782s	0.088s	2,970.005s
	12	918,195	3,239.372s	0.102s	3,239.668s
	13	792,981	3,239.396s	0.091s	3,239.649s
	14	654,431	2,430.412s	0.093s	2,430.637s
	15	527,426	3,239.471s	0.076s	3,239.64s
	16	383,757	3,239.551s	0.054s	3,239.685s
	17	175,713	3,161.662s	0.053s	3,161.767s
	18	315,929	3,239.507s	0.063s	3,239.639s
	19	309,796	2,429.622s	0.048s	2,429.741s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Mar 12	23	112	4,555	0.002s	0.011s
Mar 13	00	78	4,427	0.002s	0.012s
	01	97	4,296	0.002s	0.012s
	02	100	3,699	0.009s	0.011s
	03	62	3,513	0.002s	0.012s
	04	92	3,672	0.002s	0.012s
	05	90	3,525	0.003s	0.013s
	06	123	3,577	0.002s	0.012s
	07	88	3,702	0.002s	0.012s
	08	92	4,080	0.005s	0.012s
	09	156	5,150	0.003s	0.012s
	10	250	5,367	0.003s	0.012s
	11	291	5,396	0.007s	0.012s
	12	383	5,435	0.003s	0.012s
	13	328	5,607	0.003s	0.012s
	14	248	5,233	0.005s	0.011s
	15	218	5,512	0.003s	0.012s
	16	157	5,254	0.002s	0.012s
	17	71	4,536	0.006s	0.013s
	18	131	5,011	0.002s	0.012s
	19	134	3,888	0.003s	0.009s

Day	Hour	Avg time (sec)
Mar 12	23	0s
Mar 13	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

Day	Hour	Mean distance	Mean estimate
Mar 12	23	167,427.73 kB	224,563.64 kB
Mar 13	00	106,029.83 kB	169,925.58 kB
	01	132,002.50 kB	210,582.92 kB
	02	149,018.91 kB	181,143.18 kB
	03	85,399.83 kB	146,197.00 kB
	04	125,643.82 kB	152,570.27 kB
	05	112,912.62 kB	151,501.77 kB
	06	169,174.27 kB	194,793.73 kB
	07	120,135.17 kB	187,335.00 kB
	08	126,146.33 kB	144,131.50 kB
	09	211,905.50 kB	246,014.75 kB
	10	341,895.17 kB	382,207.83 kB
	11	397,562.75 kB	422,211.25 kB
	12	522,594.92 kB	550,448.08 kB
	13	445,834.00 kB	541,001.82 kB
	14	369,258.36 kB	421,670.45 kB
	15	297,657.67 kB	364,138.67 kB
	16	214,517.00 kB	297,582.42 kB
	17	89,411.77 kB	122,839.62 kB
	18	178,276.08 kB	194,025.17 kB
	19	245,189.22 kB	343,223.11 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (240) Main checkpoint cause
248 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	240
shutdown immediate	8
Total	248

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
Mar 12	23	0	0	0
Mar 13	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

↑ 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
Mar 12	23	0	0
Mar 13	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

↑ 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

11,007,008 Total read queries
5,336,879 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,007,008	58.64%
INSERT	1,194,259	6.36%
UPDATE	270,544	1.44%
DELETE	11,749	0.06%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	21,001	0.11%
DDL	238	0.00%
TCL	3,839,087	20.45%
CURSOR	0	0.00%
OTHERS	2,427,832	12.93%

Queries by database

Key values

unknown Main database
18,771,719 Requests
7d17h30m18s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,771,719	7d17h30m18s
	copy from	1	1ms
	cte	21,001	6s361ms
	ddl	238	38ms
	delete	11,749	1m13s
	insert	1,194,259	8m
	others	2,427,832	2m25s
	select	11,007,008	7d16h15m48s
	tcl	3,839,087	3m18s
	update	270,544	59m25s

Queries by user

Key values

unknown Main user
18,771,719 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,771,719	7d17h30m18s
	copy from	1	1ms
	cte	21,001	6s361ms
	ddl	238	38ms
	delete	11,749	1m13s
	insert	1,194,259	8m
	others	2,427,832	2m25s
	select	11,007,008	7d16h15m48s
	tcl	3,839,087	3m18s
	update	270,544	59m25s

Duration by user

Key values

7d17h30m18s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,771,719	7d17h30m18s
	copy from	1	1ms
	cte	21,001	6s361ms
	ddl	238	38ms
	delete	11,749	1m13s
	insert	1,194,259	8m
	others	2,427,832	2m25s
	select	11,007,008	7d16h15m48s
	tcl	3,839,087	3m18s
	update	270,544	59m25s

Queries by host

Key values

unknown Main host
18,771,719 Requests
7d17h30m18s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,771,719	7d17h30m18s
	copy from	1	1ms
	cte	21,001	6s361ms
	ddl	238	38ms
	delete	11,749	1m13s
	insert	1,194,259	8m
	others	2,427,832	2m25s
	select	11,007,008	7d16h15m48s
	tcl	3,839,087	3m18s
	update	270,544	59m25s

Queries by application

Key values

unknown Main application
18,771,719 Requests
7d17h30m18s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,771,719	7d17h30m18s
	copy from	1	1ms
	cte	21,001	6s361ms
	ddl	238	38ms
	delete	11,749	1m13s
	insert	1,194,259	8m
	others	2,427,832	2m25s
	select	11,007,008	7d16h15m48s
	tcl	3,839,087	3m18s
	update	270,544	59m25s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-03-13 07:22:02 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,096,366 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,096,366	91.08%
1-5ms	542,702	2.89%
5-10ms	43,999	0.23%
10-25ms	40,550	0.22%
25-50ms	26,762	0.14%
50-100ms	178,853	0.95%
100-500ms	372,526	1.98%
500-1000ms	247,500	1.32%
1000-10000ms	222,391	1.18%
> 10000ms	70	0.00%

Slowest individual queries

Rank	Duration	Query
1	14m49s	SELECT COUNT() FROM ( SELECT FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 128, 23)))))) AND ("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)))) LIMIT 10001) t; [ Date:* 2025-03-13 19:04:22 ]
2	10m7s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 12:27:08.929927', "write_uid" = 934 WHERE id IN (44820888); [ Date: 2025-03-13 13:37:27 ]
3	5m22s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 12:29:34.371073', "write_uid" = 934 WHERE id IN (44820888); [ Date: 2025-03-13 13:35:02 ]
4	4m14s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-12 23:57:53.331154', "write_uid" = 1086 WHERE id IN (45025735); [ Date: 2025-03-13 01:02:10 ]
5	4m	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 12:35:38.247258', "write_uid" = 938 WHERE id IN (44820888); [ Date: 2025-03-13 13:39:48 ]
6	3m5s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 02:51:57.228858', "write_uid" = 1224 WHERE id IN (45004252); [ Date: 2025-03-13 03:55:05 ]
7	2m29s	UPDATE "shipping_policy" SET "delegate_button" = true, "last_action" = '2025-03-13', "last_warehouse" = 62, "new_destination_button" = true, "state" = 'in_way', "write_date" = '2025-03-13 11:58:45.850435', "write_uid" = 951 WHERE id IN (6164357, 6160145); [ Date: 2025-03-13 13:01:24 ]
8	2m21s	update shipping_policy set count_search = 2 where id = 6026945; [ Date: 2025-03-13 12:46:26 ]
9	2m17s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 12:25:24.040045', "write_uid" = 934 WHERE id IN (44820888); [ Date: 2025-03-13 13:27:52 ]
10	2m	update shipping_policy set count_search = 8 where id = 6235233; [ Date: 2025-03-13 12:48:27 ]
11	1m46s	update shipping_policy set count_search = 4 where id = 6246246; [ Date: 2025-03-13 12:38:26 ]
12	1m41s	update shipping_policy set count_search = 1 where id = 6191917; [ Date: 2025-03-13 19:44:46 ]
13	1m31s	update shipping_policy set count_search = 2 where id = 6107001; [ Date: 2025-03-13 12:33:19 ]
14	1m17s	UPDATE "shipping_policy" SET "client_date" = '2025-03-13', "client_delivery_button" = true, "edit_cash_button" = false, "receive_man_id" = 'احمد محمد دسوقي', "return_button" = true, "state" = 'client_receive', "write_date" = '2025-03-13 11:36:57.068535', "write_uid" = 979 WHERE id IN (6167968, 6189148, 6176338, 6081500, 6140633, 6171773, 6132010, 6172624, 6185787, 6131225, 6182147, 6117449, 6200135, 6164807, 6173907, 6035332, 6137042, 6078366, 6165547, 6147342, 5991147, 6177982, 6183191, 6150240, 6154603, 6117549, 6184795); [ Date: 2025-03-13 12:46:26 ]
15	1m14s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 04:01:42.112369', "write_uid" = 1001 WHERE id IN (45118694); [ Date: 2025-03-13 05:02:59 ]
16	1m12s	update shipping_policy set count_search = 2 where id = 6026945; [ Date: 2025-03-13 12:46:29 ]
17	1m10s	DELETE FROM "res_users" WHERE id IN (1392); [ Date: 2025-03-13 14:03:34 ]
18	1m7s	UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-13 04:01:45.438920', "write_uid" = 1244 WHERE id IN (45153552); [ Date: 2025-03-13 05:02:55 ]
19	1m6s	SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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)))))) AND ("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" LIMIT 8; [ Date: 2025-03-13 18:50:55 ]
20	1m4s	update shipping_policy set count_search = 8 where id = 6235233; [ Date: 2025-03-13 12:47:17 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d5h28m34s

303,825

Details

675ms

8s359ms

1s202ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11,140	2h58m17s	960ms
Mar 13	00	8,464	2h13m	942ms
	01	10,341	2h44m48s	956ms
	02	11,754	2h43m57s	836ms
	03	7,345	1h32m23s	754ms
	04	10,205	2h10m28s	767ms
	05	11,105	2h40m48s	868ms
	06	13,900	3h15m53s	845ms
	07	9,076	2h5m	826ms
	08	9,230	2h15m53s	883ms
	09	12,168	3h6m36s	920ms
	10	18,333	5h18m42s	1s43ms
	11	22,707	8h19m58s	1s321ms
	12	27,928	15h28m13s	1s994ms
	13	29,216	17h31m54s	2s160ms
	14	21,161	8h2m8s	1s367ms
	15	18,553	5h22m51s	1s44ms
	16	12,266	3h13m16s	945ms
	17	8,758	2h9m42s	888ms
	18	16,889	4h34m50s	976ms
	19	13,286	3h39m47s	992ms

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

Date: 2025-03-13 12:06:10 Duration: 8s359ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293356)) AND (("shipping_track"."id" not in (52553959, 52553959)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:25:31 Duration: 8s298ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293340)) AND (("shipping_track"."id" not in (52553071, 52553071)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:23:58 Duration: 8s271ms

2

20h35m35s

52,226

Details

681ms

9s262ms

1s419ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 12	23	2,312	36m43s	953ms
Mar 13	00	694	10m50s	937ms
	01	482	7m40s	956ms
	02	897	12m55s	864ms
	03	353	4m34s	776ms
	04	409	5m29s	804ms
	05	338	5m18s	941ms
	06	1,252	18m14s	874ms
	07	318	4m45s	896ms
	08	864	13m10s	915ms
	09	2,543	39m59s	943ms
	10	4,728	1h25m36s	1s86ms
	11	4,564	1h57m50s	1s549ms
	12	5,972	3h56m59s	2s381ms
	13	5,741	4h5m25s	2s564ms
	14	4,627	2h2m4s	1s582ms
	15	4,362	1h18m49s	1s84ms
	16	3,379	53m28s	949ms
	17	1,619	23m55s	886ms
	18	3,285	54m18s	991ms
	19	3,487	57m25s	988ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6247140, 6223113, 6217007, 6183532, 6151626, 6113269, 6094988)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:18:53 Duration: 9s262ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6248357, 6137452, 6240084, 6240179, 6240236, 6240247, 6247652, 6169092, 6172116, 6172786, 6177219, 6184165, 6184471, 6185767, 6188460, 6188814, 6189174, 6197970, 6206830, 6207985, 6208174, 6210000, 6210238, 6211014, 6212674, 6212748, 6214090, 6214736, 6214753, 6215212, 6216416, 6217983, 6218565, 6220778, 6220812, 6223498, 6224751, 6226072, 6228040, 6228097, 6228114, 6228505, 6229315, 6229389, 6231031, 6231465, 6235170, 6235265, 6236925, 6236993, 6237038, 6237067, 6237127, 6237138, 6237142, 6237146, 6237165)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:26:47 Duration: 8s981ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6292943, 6292941, 6292938, 6292935, 6292934, 6292932)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 12:29:07 Duration: 8s744ms

3

17h24m19s

137,752

Details

250ms

3s142ms

454ms

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
Mar 12	23	2,962	19m33s	396ms
Mar 13	00	2,878	18m28s	385ms
	01	1,859	11m48s	381ms
	02	4,775	26m48s	336ms
	03	1,827	8m57s	294ms
	04	3,500	17m32s	300ms
	05	4,430	21m59s	297ms
	06	3,742	18m30s	296ms
	07	5,041	24m13s	288ms
	08	8,525	42m22s	298ms
	09	6,736	35m10s	313ms
	10	5,494	32m10s	351ms
	11	12,513	1h49m7s	523ms
	12	14,261	2h45m58s	698ms
	13	12,189	2h36m27s	770ms
	14	7,617	1h9m10s	544ms
	15	8,059	58m21s	434ms
	16	7,737	50m26s	391ms
	17	7,340	44m51s	366ms
	18	10,807	1h15m21s	418ms
	19	5,460	36m59s	406ms

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

Date: 2025-03-13 13:38:09 Duration: 3s142ms
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" = '1072169')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-03-13 13:19:45 Duration: 2s925ms
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" = '1038752')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-03-13 13:38:06 Duration: 2s924ms

4

6h48m4s

20,362

Details

905ms

3s93ms

1s202ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	1,362	26m45s	1s178ms
Mar 13	00	1,546	29m12s	1s133ms
	01	1,746	33m53s	1s164ms
	02	868	16m53s	1s167ms
	03	1,267	23m24s	1s108ms
	04	1,925	35m44s	1s114ms
	05	2,241	43m16s	1s158ms
	06	921	17m39s	1s150ms
	07	1,083	19m59s	1s108ms
	08	1,476	27m26s	1s115ms
	09	1,004	19m46s	1s181ms
	10	533	10m52s	1s223ms
	11	326	9m5s	1s672ms
	12	187	6m48s	2s185ms
	13	159	5m37s	2s120ms
	14	292	8m54s	1s829ms
	15	193	4m25s	1s373ms
	16	500	10m21s	1s242ms
	17	628	12m23s	1s184ms
	18	1,282	27m33s	1s289ms
	19	823	18m	1s313ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9546848')) 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: 2025-03-13 12:36:03 Duration: 3s93ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '972202')) 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: 2025-03-13 12:27:23 Duration: 3s11ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1015112')) AND ("policy_number"."package_id" = 2414)) 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: 2025-03-13 13:22:28 Duration: 2s880ms

5

4h35m54s

23,206

Details

276ms

4s464ms

713ms

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 ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 13	07	378	2m17s	363ms
	08	1,150	8m	417ms
	09	677	4m33s	404ms
	10	5	3s155ms	631ms
	11	3,556	40m23s	681ms
	12	2,874	45m26s	948ms
	13	3,905	1h6m22s	1s19ms
	14	3,660	47m8s	772ms
	15	1,707	16m32s	581ms
	16	2,420	20m16s	502ms
	17	1,618	13m9s	487ms
	18	929	8m40s	559ms
	19	327	3m	553ms

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" = '976502')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 12:23:37 Duration: 4s464ms
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" = '661022')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:22:37 Duration: 4s358ms
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" = '466766')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:16:38 Duration: 4s269ms

6

4h34m54s

170,566

Details

47ms

592ms

96ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7,124	9m26s	79ms
Mar 13	00	4,556	5m49s	76ms
	01	4,101	5m18s	77ms
	02	4,617	4m46s	62ms
	03	2,662	2m25s	54ms
	04	3,877	3m37s	56ms
	05	4,003	4m19s	64ms
	06	5,113	5m29s	64ms
	07	2,942	3m2s	61ms
	08	3,770	4m13s	67ms
	09	6,971	8m8s	70ms
	10	12,368	16m25s	79ms
	11	15,975	27m31s	103ms
	12	19,816	47m42s	144ms
	13	19,352	50m5s	155ms
	14	12,319	23m9s	112ms
	15	10,801	15m53s	88ms
	16	8,283	10m55s	79ms
	17	4,714	5m17s	67ms
	18	10,892	13m20s	73ms
	19	6,310	7m55s	75ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6200716, 6192914, 6178704, 6178103, 6175852, 6175277, 6167713, 6147270)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:08:21 Duration: 592ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6233865, 6233779, 6220951, 6196184, 6185444, 6105549, 6001076)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:56:14 Duration: 580ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187658, 6176247, 6168446, 6167391, 6141469, 6097824, 6089202)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 13:19:13 Duration: 565ms

7

4h16m27s

59,247

Details

92ms

1s80ms

259ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	4,788	19m27s	243ms
Mar 13	00	5,553	21m53s	236ms
	01	6,593	27m29s	250ms
	02	2,806	10m23s	222ms
	03	3,260	11m48s	217ms
	04	4,362	15m35s	214ms
	05	4,436	17m2s	230ms
	06	1,810	7m23s	244ms
	07	2,120	8m	226ms
	08	3,164	12m7s	230ms
	09	2,210	9m1s	245ms
	10	1,312	5m42s	261ms
	11	696	4m19s	373ms
	12	676	6m10s	548ms
	13	1,232	11m36s	565ms
	14	1,154	6m56s	361ms
	15	1,572	7m12s	275ms
	16	1,826	9m5s	298ms
	17	2,357	9m18s	236ms
	18	4,129	20m10s	293ms
	19	3,191	15m39s	294ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 14:22:23 Duration: 1s80ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ندادين')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 13:26:48 Duration: 996ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عاس')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 13:41:33 Duration: 984ms

8

3h10m6s

9,670

Details

401ms

2s771ms

1s179ms

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
Mar 12	23	1,056	19m6s	1s85ms
Mar 13	00	1,262	22m5s	1s50ms
	01	1,584	28m17s	1s71ms
	02	553	9m25s	1s22ms
	03	386	6m34s	1s21ms
	04	278	4m49s	1s39ms
	08	127	2m8s	1s15ms
	09	128	2m12s	1s37ms
	10	134	2m46s	1s242ms
	11	30	46s15ms	1s533ms
	12	162	5m2s	1s869ms
	13	472	15m36s	1s984ms
	14	290	6m20s	1s311ms
	15	608	13m27s	1s328ms
	16	431	8m23s	1s168ms
	17	567	9m49s	1s40ms
	18	807	17m7s	1s273ms
	19	795	16m4s	1s213ms

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

Date: 2025-03-13 13:22:20 Duration: 2s771ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '315305')) 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 (19))))))) 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 (19)))))) 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 (19)))))) 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 (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-03-13 13:25:44 Duration: 2s768ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1077610')) AND ("policy_number"."package_id" = 2414)) 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 (19))))))) 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 (19)))))) 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 (19)))))) 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 (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-03-13 13:36:59 Duration: 2s752ms

9

2h49m30s

20,067

Details

257ms

2s911ms

506ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	2,064	13m38s	396ms
Mar 13	00	1,463	9m22s	384ms
	01	120	45s650ms	380ms
	02	330	1m51s	338ms
	03	374	1m52s	301ms
	04	244	1m14s	306ms
	06	693	3m25s	296ms
	07	654	3m8s	287ms
	08	1,158	5m51s	303ms
	09	1,409	7m16s	310ms
	10	1,882	11m15s	358ms
	11	1,628	14m50s	546ms
	12	2,273	27m50s	734ms
	13	3,104	45m5s	871ms
	14	1,616	14m42s	546ms
	15	513	3m46s	441ms
	16	234	1m28s	377ms
	17	57	21s379ms	375ms
	18	102	43s62ms	422ms
	19	149	58s779ms	394ms

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

Date: 2025-03-13 13:35:47 Duration: 2s907ms

10

1h54m11s

27,023

Details

121ms

1s117ms

253ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	876	2m25s	165ms
Mar 13	00	289	45s958ms	159ms
	01	111	17s936ms	161ms
	02	37	6s609ms	178ms
	03	76	10s952ms	144ms
	04	1	136ms	136ms
	05	30	4s936ms	164ms
	06	210	35s805ms	170ms
	07	109	15s464ms	141ms
	08	195	29s919ms	153ms
	09	1,838	4m53s	159ms
	10	3,099	9m32s	184ms
	11	2,679	11m34s	259ms
	12	3,825	24m28s	383ms
	13	3,558	25m1s	422ms
	14	3,600	14m40s	244ms
	15	2,434	7m16s	179ms
	16	1,058	2m51s	162ms
	17	332	56s222ms	169ms
	18	1,659	4m51s	175ms
	19	1,007	2m50s	169ms

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

Date: 2025-03-13 12:26:38 Duration: 1s117ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8329506)) AND (("cash_track"."id" not in (9411080)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-03-13 13:28:26 Duration: 1s116ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8329604)) AND (("cash_track"."id" not in (9411784)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-03-13 13:36:30 Duration: 1s116ms

11

1h41m44s

51,885

Details

60ms

495ms

117ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 12	23	51	4s411ms	86ms
Mar 13	00	3	241ms	80ms
	07	406	29s973ms	73ms
	08	2,661	3m24s	76ms
	09	1,509	1m59s	79ms
	10	178	15s111ms	84ms
	11	5,832	12m4s	124ms
	12	6,947	17m9s	148ms
	13	10,330	27m42s	160ms
	14	6,261	11m51s	113ms
	15	3,647	5m52s	96ms
	16	4,753	7m10s	90ms
	17	3,347	4m41s	84ms
	18	5,225	7m52s	90ms
	19	735	1m5s	88ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6093601) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 12:25:40 Duration: 495ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6126764) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:33:19 Duration: 472ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6211537) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 14:25:59 Duration: 455ms

12

1h10m52s

18,166

Details

177ms

446ms

234ms

select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) 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 #12

Day	Hour	Count	Duration	Avg duration
Mar 12	23	871	3m51s	265ms
Mar 13	00	1,245	5m22s	258ms
	01	1,575	6m44s	256ms
	02	3,416	13m28s	236ms
	03	1,388	4m53s	211ms
	04	3,153	11m31s	219ms
	05	3,187	12m19s	231ms
	06	1,781	6m58s	234ms
	07	1,498	5m32s	222ms
	08	52	12s65ms	232ms

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" = '1037610')) 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: 2025-03-13 02:23:17 Duration: 446ms
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" = '895465')) 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: 2025-03-13 02:01:38 Duration: 391ms
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" = '1021241')) 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: 2025-03-12 23:29:24 Duration: 324ms

13

58m30s

8,158

Details

191ms

2s332ms

430ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11	3s966ms	360ms
Mar 13	01	55	22s122ms	402ms
	07	2	556ms	278ms
	08	810	3m28s	256ms
	09	1,282	5m44s	269ms
	10	874	4m35s	315ms
	11	1,420	9m58s	421ms
	12	1,807	19m22s	643ms
	13	606	6m17s	622ms
	14	469	3m50s	490ms
	15	270	1m47s	398ms
	16	252	1m27s	346ms
	17	124	36s680ms	295ms
	18	86	28s339ms	329ms
	19	90	27s347ms	303ms

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

Date: 2025-03-13 12:05:14 Duration: 2s332ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '896204')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:18:03 Duration: 2s315ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1047035')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:12:37 Duration: 2s307ms

14

47m12s

2,629

Details

26ms

2s383ms

1s77ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	23	28	18s429ms	658ms
Mar 13	00	12	6s2ms	500ms
	01	4	1s197ms	299ms
	02	3	1s472ms	490ms
	05	1	1s357ms	1s357ms
	06	1	962ms	962ms
	07	14	13s807ms	986ms
	08	42	27s257ms	648ms
	09	219	2m27s	673ms
	10	229	3m19s	869ms
	11	307	6m4s	1s188ms
	12	361	8m27s	1s405ms
	13	447	9m43s	1s305ms
	14	326	6m3s	1s115ms
	15	297	4m	810ms
	16	63	59s748ms	948ms
	17	38	33s962ms	893ms
	18	155	2m58s	1s151ms
	19	82	1m22s	1s1ms

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

Date: 2025-03-13 13:41:23 Duration: 2s383ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-03-13 13:38:56 Duration: 2s367ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-03-13 14:18:47 Duration: 2s364ms

15

44m24s

6,326

Details

123ms

1s383ms

421ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 12	23	200	31s657ms	158ms
Mar 13	00	52	8s7ms	153ms
	01	96	14s776ms	153ms
	02	45	7s390ms	164ms
	03	130	17s598ms	135ms
	04	128	17s516ms	136ms
	05	40	6s225ms	155ms
	06	15	2s269ms	151ms
	07	40	5s825ms	145ms
	08	131	20s398ms	155ms
	09	258	42s718ms	165ms
	10	664	2m32s	229ms
	11	1,082	6m41s	371ms
	12	1,031	12m17s	715ms
	13	1,161	13m37s	704ms
	14	527	3m52s	440ms
	15	355	1m18s	220ms
	16	143	26s94ms	182ms
	17	41	6s538ms	159ms
	18	59	11s271ms	191ms
	19	128	26s31ms	203ms

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

Date: 2025-03-13 13:35:33 Duration: 1s383ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 73)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-03-13 13:39:09 Duration: 1s299ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-03-13 13:24:31 Duration: 1s292ms

16

38m20s

22,238

Details

53ms

379ms

103ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 13	07	200	13s202ms	66ms
	08	1,212	1m25s	70ms
	09	994	1m10s	71ms
	10	5	385ms	77ms
	11	2,834	5m13s	110ms
	12	3,255	7m4s	130ms
	13	3,031	7m5s	140ms
	14	3,435	5m58s	104ms
	15	1,618	2m25s	89ms
	16	2,143	3m1s	84ms
	17	1,629	2m4s	76ms
	18	1,554	2m10s	84ms
	19	328	25s842ms	78ms

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

Date: 2025-03-13 14:23:18 Duration: 379ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6154694) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:58:20 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6122522) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:23:47 Duration: 377ms

17

35m43s

4,094

Details

259ms

2s854ms

523ms

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and (((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) and (("cash_policy"."state" not in (...)) or "cash_policy"."state" is null)) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11	4s747ms	431ms
Mar 13	01	55	25s701ms	467ms
	07	2	550ms	275ms
	08	313	1m32s	296ms
	09	343	1m46s	309ms
	10	422	2m37s	373ms
	11	667	5m26s	489ms
	12	522	7m17s	837ms
	13	474	6m31s	826ms
	14	467	4m29s	576ms
	15	266	2m	454ms
	16	252	1m37s	385ms
	17	124	44s919ms	362ms
	18	86	34s591ms	402ms
	19	90	33s543ms	372ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1013262')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:35:48 Duration: 2s854ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1040351')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:27:29 Duration: 2s810ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '734030')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:26:43 Duration: 2s762ms

18

34m29s

4,064

Details

262ms

2s775ms

509ms

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 13	08	498	2m27s	295ms
	09	938	4m53s	313ms
	10	452	2m39s	352ms
	11	753	6m20s	505ms
	12	1,286	16m34s	773ms
	13	131	1m30s	689ms
	14	2	1s110ms	555ms
	15	4	1s901ms	475ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897361')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:25:22 Duration: 2s775ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897336')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:27:32 Duration: 2s763ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897399')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:25:32 Duration: 2s756ms

19

34m6s

2,145

Details

326ms

5s751ms

954ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 12	23	100	53s505ms	535ms
Mar 13	00	53	26s317ms	496ms
	01	41	19s707ms	480ms
	02	100	44s773ms	447ms
	03	40	15s198ms	379ms
	04	67	26s390ms	393ms
	05	76	30s939ms	407ms
	06	72	28s747ms	399ms
	07	73	28s77ms	384ms
	08	111	46s426ms	418ms
	09	66	28s588ms	433ms
	10	108	1m1s	571ms
	11	207	4m16s	1s237ms
	12	231	7m34s	1s967ms
	13	237	8m2s	2s34ms
	14	206	4m2s	1s176ms
	15	117	1m13s	625ms
	16	63	33s683ms	534ms
	17	34	16s315ms	479ms
	18	69	38s104ms	552ms
	19	74	39s512ms	533ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('930391', '964392', '394775', '269496', '908458', '1040119', '');

Date: 2025-03-13 14:01:42 Duration: 5s751ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('679644', '1005615', '1025009', '', '');

Date: 2025-03-13 13:04:03 Duration: 4s613ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9794279', '9794293', '9794292', '9794285', '9794287', '');

Date: 2025-03-13 13:12:01 Duration: 4s570ms

20

32m29s

4,038

Details

253ms

2s861ms

482ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7	3s3ms	429ms
Mar 13	02	30	8s982ms	299ms
	03	47	13s801ms	293ms
	05	481	2m19s	289ms
	08	431	2m8s	297ms
	09	127	39s847ms	313ms
	10	212	1m17s	365ms
	11	2,344	21m42s	555ms
	12	292	3m28s	714ms
	16	67	27s550ms	411ms

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

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

Date: 2025-03-13 12:21:38 Duration: 2s858ms
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" = '1096246')) 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, 23, 112, 12)))) 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, 23, 112, 12))))) 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, 23, 112, 12))))) 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: 2025-03-13 11:54:47 Duration: 2s657ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,427,624

Details

2m25s

0ms

3ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	23	82,061	3s927ms	0ms
Mar 13	00	62,611	3s100ms	0ms
	01	53,207	2s687ms	0ms
	02	48,002	2s93ms	0ms
	03	40,076	1s890ms	0ms
	04	50,867	2s516ms	0ms
	05	45,338	2s	0ms
	06	51,566	2s534ms	0ms
	07	47,479	2s333ms	0ms
	08	74,071	3s418ms	0ms
	09	139,172	7s504ms	0ms
	10	207,953	12s979ms	0ms
	11	237,928	15s990ms	0ms
	12	245,890	19s47ms	0ms
	13	241,179	18s671ms	0ms
	14	192,560	11s242ms	0ms
	15	175,945	11s100ms	0ms
	16	133,327	7s457ms	0ms
	17	80,640	3s339ms	0ms
	18	115,792	5s891ms	0ms
	19	101,960	5s702ms	0ms

DISCARD ALL;

Date: 2025-03-13 13:19:54 Duration: 3ms
DISCARD ALL;

Date: 2025-03-13 13:30:40 Duration: 2ms
DISCARD ALL;

Date: 2025-03-13 13:31:31 Duration: 2ms

2

1,919,580

Details

39s159ms

0ms

27ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Mar 12	23	63,788	988ms	0ms
Mar 13	00	47,045	735ms	0ms
	01	39,441	645ms	0ms
	02	35,869	586ms	0ms
	03	29,024	484ms	0ms
	04	38,715	666ms	0ms
	05	33,815	575ms	0ms
	06	40,032	701ms	0ms
	07	36,169	623ms	0ms
	08	58,774	979ms	0ms
	09	113,202	1s969ms	0ms
	10	171,252	3s298ms	0ms
	11	194,423	4s666ms	0ms
	12	200,154	5s684ms	0ms
	13	195,407	5s438ms	0ms
	14	155,091	3s151ms	0ms
	15	142,109	2s556ms	0ms
	16	101,900	1s678ms	0ms
	17	55,574	812ms	0ms
	18	88,433	1s536ms	0ms
	19	79,363	1s380ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-03-13 13:39:39 Duration: 27ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-03-13 11:13:54 Duration: 18ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-03-13 12:37:11 Duration: 1ms

3

1,236,716

Details

15s383ms

0ms

3ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Mar 12	23	42,240	429ms	0ms
Mar 13	00	32,299	312ms	0ms
	01	27,443	271ms	0ms
	02	24,806	262ms	0ms
	03	20,832	212ms	0ms
	04	26,215	277ms	0ms
	05	23,527	255ms	0ms
	06	26,582	294ms	0ms
	07	24,514	258ms	0ms
	08	38,110	399ms	0ms
	09	71,075	768ms	0ms
	10	105,384	1s285ms	0ms
	11	120,344	1s715ms	0ms
	12	124,236	1s949ms	0ms
	13	122,065	1s996ms	0ms
	14	97,599	1s345ms	0ms
	15	89,183	1s22ms	0ms
	16	67,544	703ms	0ms
	17	41,241	394ms	0ms
	18	59,647	660ms	0ms
	19	51,830	567ms	0ms

ROLLBACK;

Date: 2025-03-13 13:33:00 Duration: 3ms
ROLLBACK;

Date: 2025-03-13 03:55:04 Duration: 1ms
ROLLBACK;

Date: 2025-03-13 02:52:42 Duration: 1ms

4

1,225,915

Details

4m43s

0ms

24ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Mar 12	23	41,376	8s4ms	0ms
Mar 13	00	31,485	5s680ms	0ms
	01	26,709	4s958ms	0ms
	02	24,043	5s376ms	0ms
	03	20,086	4s335ms	0ms
	04	25,492	5s818ms	0ms
	05	22,776	5s349ms	0ms
	06	25,895	6s234ms	0ms
	07	23,818	5s477ms	0ms
	08	37,413	8s229ms	0ms
	09	70,563	15s113ms	0ms
	10	105,358	23s897ms	0ms
	11	120,539	33s71ms	0ms
	12	124,373	35s530ms	0ms
	13	122,196	34s73ms	0ms
	14	97,653	23s805ms	0ms
	15	88,639	17s832ms	0ms
	16	67,015	12s495ms	0ms
	17	40,648	7s160ms	0ms
	18	58,268	11s434ms	0ms
	19	51,570	10s60ms	0ms

SELECT payload FROM http_sessions WHERE sid = '114ddf4e87c31b73c39a5586eda2aeb368e3a8be';

Date: 2025-03-13 13:24:21 Duration: 24ms
SELECT payload FROM http_sessions WHERE sid = 'ded24291f60a0dc8e764a48c4ae2f93549a496e9';

Date: 2025-03-13 10:30:10 Duration: 22ms
SELECT payload FROM http_sessions WHERE sid = 'f15be138537efc89e6b93525076a5b91087d6601';

Date: 2025-03-13 10:30:10 Duration: 22ms

5

1,213,269

Details

2m14s

0ms

2ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 12	23	41,035	3s790ms	0ms
Mar 13	00	31,334	2s739ms	0ms
	01	26,634	2s381ms	0ms
	02	24,044	2s440ms	0ms
	03	20,085	1s949ms	0ms
	04	25,474	2s555ms	0ms
	05	22,744	2s335ms	0ms
	06	25,823	2s689ms	0ms
	07	23,779	2s338ms	0ms
	08	37,024	3s689ms	0ms
	09	69,423	6s928ms	0ms
	10	103,831	11s132ms	0ms
	11	118,916	15s141ms	0ms
	12	122,860	16s592ms	0ms
	13	120,457	16s167ms	0ms
	14	96,183	11s720ms	0ms
	15	87,848	9s223ms	0ms
	16	66,645	6s451ms	0ms
	17	40,381	3s619ms	0ms
	18	57,833	5s807ms	0ms
	19	50,916	5s107ms	0ms

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

Date: 2025-03-13 13:20:15 Duration: 2ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-03-13 13:12:07 Duration: 2ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-03-13 14:32:52 Duration: 1ms

6

682,785

Details

2m23s

0ms

68ms

0ms

commit;

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 12	23	21,545	3s829ms	0ms
Mar 13	00	14,739	2s206ms	0ms
	01	12,006	2s193ms	0ms
	02	11,059	2s325ms	0ms
	03	8,185	1s512ms	0ms
	04	12,504	2s335ms	0ms
	05	10,287	2s144ms	0ms
	06	13,450	2s933ms	0ms
	07	11,654	2s205ms	0ms
	08	20,656	2s953ms	0ms
	09	42,124	6s282ms	0ms
	10	65,871	11s756ms	0ms
	11	74,056	17s651ms	0ms
	12	75,922	20s937ms	0ms
	13	73,344	20s22ms	0ms
	14	57,463	13s763ms	0ms
	15	52,930	10s20ms	0ms
	16	34,357	5s916ms	0ms
	17	14,317	2s638ms	0ms
	18	28,792	5s411ms	0ms
	19	27,524	4s833ms	0ms

COMMIT;

Date: 2025-03-13 13:29:52 Duration: 68ms
COMMIT;

Date: 2025-03-13 13:24:47 Duration: 66ms
COMMIT;

Date: 2025-03-13 11:24:40 Duration: 65ms

7

588,916

Details

1m58s

0ms

8ms

0ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 12	23	17,480	2s832ms	0ms
Mar 13	00	14,175	1s941ms	0ms
	01	13,874	2s42ms	0ms
	02	9,778	1s794ms	0ms
	03	8,047	1s24ms	0ms
	04	14,079	2s89ms	0ms
	05	10,891	1s662ms	0ms
	06	12,342	2s41ms	0ms
	07	10,182	1s587ms	0ms
	08	17,294	2s650ms	0ms
	09	36,942	5s640ms	0ms
	10	57,849	10s625ms	0ms
	11	64,461	16s77ms	0ms
	12	70,511	18s566ms	0ms
	13	60,046	16s196ms	0ms
	14	42,946	9s395ms	0ms
	15	41,409	7s693ms	0ms
	16	28,785	4s597ms	0ms
	17	11,760	1s782ms	0ms
	18	23,356	4s49ms	0ms
	19	22,709	3s818ms	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 (5312886, 5104971, 5550219, 5553642, 5119596, 5552105, 5165521, 5543033, 5428177, 5451354, 5158241, 5117752, 5100482, 5099133, 5116472, 5119604, 5099244, 5131559, 5104311, 5099758, 5486244, 5099028, 5104816, 5100452, 5102647, 5244891, 5099257, 5215705, 5099131, 5411861, 5110614, 5128549, 5099167, 5099014, 5099119, 5116550, 5542901, 5099285, 5101654, 5099181, 5341752, 5099007, 5412279, 5107143, 5252447, 5551954, 5099296, 5172271, 5450098, 5108793, 5298879, 5113672, 5137895, 5128452, 5553805, 5548702, 5551959, 5548452, 5304680, 5254200, 5552113, 5553312, 5417248, 5125373, 5099013, 5448584, 5099174, 5251303, 5276675, 5104059, 5260032, 5099010, 5551362, 5099585, 5102807, 5182581, 5099130, 5099186, 5469314, 5099321, 5099103, 5099095, 5553311, 5102257, 5120582, 5099503, 5115653, 5111795, 5117794, 5393882, 5111018, 5551940, 5099646, 5099009, 5548621, 5553629, 5550545, 5099248, 5424993, 5550218, 5099008, 5099129, 5488860, 5550206, 5259292, 5159798, 5099415, 5550525, 5100772, 5448245, 5550541, 5113702, 5099190, 5198649, 5544695, 5550546, 5101122, 5540643, 5551760, 5551957, 5275562, 5551747, 5153840, 5441705, 5115015, 5100070, 5550542, 5100796, 5099677, 5100321, 5546010, 5152965, 5099403, 5100150, 5100749, 5100218, 5099144, 5115518, 5551943, 5102176, 5128386, 5550190, 5548635, 5548618, 5153217, 5547711, 5550221, 5550532, 5100097, 5099105, 5550533, 5402559, 5548701, 5102366, 5100832, 5548616, 5099815, 5099590, 5100514, 5099011, 5109643, 5106640, 5105195, 5099873, 5100273, 5188723, 5100801, 5175265, 5131378, 5547562, 5099904, 5099224, 5548617, 5099788, 5155985, 5099765, 5550191, 5548620, 5550181, 5114680, 5138612, 5364771, 5244337);

Date: 2025-03-13 14:21:59 Duration: 8ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (4142332, 5099007, 5099644, 5099547, 5102668, 5099010, 5099046, 5103262, 5099038, 5264907, 5544010, 5099009, 5236627, 5099727, 5107101, 5099102, 5098996, 5099035, 5099140, 5099590, 5103192, 5103633, 5099815, 5100843, 5099254, 5245677, 5099111, 5099013, 5101424, 5108300, 5099206, 5099360, 5099170, 5099500, 5099540, 5100482, 5099568, 5099614, 5100252);

Date: 2025-03-13 02:22:07 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (4142332, 5099007, 5099644, 5099547, 5102668, 5099010, 5099046, 5103262, 5099038, 5264907, 5544010, 5099009, 5236627, 5099727, 5107101, 5099102, 5098996, 5099035, 5099140, 5099590, 5103192, 5103633, 5099815, 5100843, 5099254, 5245677, 5099111, 5099013, 5101424, 5108300, 5099206, 5099360, 5099170, 5099500, 5099540, 5100482, 5099568, 5099614, 5100252);

Date: 2025-03-13 02:22:07 Duration: 6ms

8

565,664

Details

1m

0ms

27ms

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"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 12	23	17,518	1s327ms	0ms
Mar 13	00	12,066	841ms	0ms
	01	9,380	685ms	0ms
	02	7,924	623ms	0ms
	03	5,692	387ms	0ms
	04	9,413	667ms	0ms
	05	7,176	546ms	0ms
	06	11,088	782ms	0ms
	07	8,832	584ms	0ms
	08	15,247	1s127ms	0ms
	09	33,990	2s854ms	0ms
	10	55,252	5s302ms	0ms
	11	60,949	8s141ms	0ms
	12	68,904	10s129ms	0ms
	13	60,690	9s531ms	0ms
	14	46,736	5s699ms	0ms
	15	44,211	4s254ms	0ms
	16	29,533	2s368ms	0ms
	17	12,989	965ms	0ms
	18	24,707	2s226ms	0ms
	19	23,367	1s949ms	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"."is_no_change_office" AS "is_no_change_office", "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 (121);

Date: 2025-03-13 13:58:00 Duration: 27ms
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"."is_no_change_office" AS "is_no_change_office", "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 (32);

Date: 2025-03-13 16:21:22 Duration: 2ms
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"."is_no_change_office" AS "is_no_change_office", "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 (67, 17, 71);

Date: 2025-03-13 16:25:25 Duration: 2ms

9

397,503

Details

2m57s

0ms

21ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	16,974	5s766ms	0ms
Mar 13	00	8,219	2s755ms	0ms
	01	4,710	1s611ms	0ms
	02	5,747	2s70ms	0ms
	03	3,967	1s243ms	0ms
	04	3,768	1s340ms	0ms
	05	2,960	1s89ms	0ms
	06	3,170	1s153ms	0ms
	07	3,612	1s231ms	0ms
	08	11,958	4s216ms	0ms
	09	25,639	9s401ms	0ms
	10	45,344	19s73ms	0ms
	11	40,245	20s825ms	0ms
	12	34,837	20s272ms	0ms
	13	38,945	21s994ms	0ms
	14	49,680	24s95ms	0ms
	15	44,550	18s299ms	0ms
	16	18,226	6s991ms	0ms
	17	6,576	2s345ms	0ms
	18	13,951	5s514ms	0ms
	19	14,425	5s768ms	0ms

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 = 1398) OR r.global) ORDER BY r.id;

Date: 2025-03-13 16:11:14 Duration: 21ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.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 = 960) OR r.global) ORDER BY r.id;

Date: 2025-03-13 09:55:55 Duration: 4ms
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 = 1256) OR r.global) ORDER BY r.id;

Date: 2025-03-13 14:21:56 Duration: 4ms

10

380,665

Details

1m37s

0ms

10ms

0ms

select "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" from "res_partner" where "res_partner".id in (...);

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Mar 12	23	10,727	2s234ms	0ms
Mar 13	00	7,889	1s470ms	0ms
	01	6,161	1s180ms	0ms
	02	5,072	1s137ms	0ms
	03	4,421	753ms	0ms
	04	5,981	1s162ms	0ms
	05	4,763	1s22ms	0ms
	06	6,279	1s292ms	0ms
	07	6,393	1s168ms	0ms
	08	12,005	2s266ms	0ms
	09	25,725	4s926ms	0ms
	10	37,222	8s585ms	0ms
	11	40,363	12s330ms	0ms
	12	43,757	14s773ms	0ms
	13	40,646	13s590ms	0ms
	14	32,116	9s208ms	0ms
	15	29,309	7s61ms	0ms
	16	20,009	4s130ms	0ms
	17	8,115	1s653ms	0ms
	18	17,413	3s919ms	0ms
	19	16,299	3s671ms	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 (1);

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

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

Date: 2025-03-13 14:21:56 Duration: 3ms

11

318,977

Details

41s658ms

0ms

15ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Mar 12	23	9,397	969ms	0ms
Mar 13	00	6,997	664ms	0ms
	01	5,337	541ms	0ms
	02	4,291	536ms	0ms
	03	3,382	351ms	0ms
	04	5,165	526ms	0ms
	05	3,932	520ms	0ms
	06	5,588	636ms	0ms
	07	5,204	526ms	0ms
	08	9,749	980ms	0ms
	09	20,891	1s952ms	0ms
	10	31,632	3s562ms	0ms
	11	34,149	5s340ms	0ms
	12	37,015	6s311ms	0ms
	13	34,164	5s987ms	0ms
	14	26,345	3s883ms	0ms
	15	24,912	2s908ms	0ms
	16	16,663	1s691ms	0ms
	17	6,946	740ms	0ms
	18	14,189	1s586ms	0ms
	19	13,029	1s439ms	0ms

SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1302, 835, 977, 986, 917);

Date: 2025-03-13 16:34:17 Duration: 15ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (821);

Date: 2025-03-13 12:56:48 Duration: 3ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (821);

Date: 2025-03-13 13:19:27 Duration: 3ms

12

303,825

Details

4d5h28m34s

675ms

8s359ms

1s202ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11,140	2h58m17s	960ms
Mar 13	00	8,464	2h13m	942ms
	01	10,341	2h44m48s	956ms
	02	11,754	2h43m57s	836ms
	03	7,345	1h32m23s	754ms
	04	10,205	2h10m28s	767ms
	05	11,105	2h40m48s	868ms
	06	13,900	3h15m53s	845ms
	07	9,076	2h5m	826ms
	08	9,230	2h15m53s	883ms
	09	12,168	3h6m36s	920ms
	10	18,333	5h18m42s	1s43ms
	11	22,707	8h19m58s	1s321ms
	12	27,928	15h28m13s	1s994ms
	13	29,216	17h31m54s	2s160ms
	14	21,161	8h2m8s	1s367ms
	15	18,553	5h22m51s	1s44ms
	16	12,266	3h13m16s	945ms
	17	8,758	2h9m42s	888ms
	18	16,889	4h34m50s	976ms
	19	13,286	3h39m47s	992ms

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

Date: 2025-03-13 12:06:10 Duration: 8s359ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293356)) AND (("shipping_track"."id" not in (52553959, 52553959)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:25:31 Duration: 8s298ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293340)) AND (("shipping_track"."id" not in (52553071, 52553071)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:23:58 Duration: 8s271ms

13

303,272

Details

1m13s

0ms

21ms

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	13,078	2s503ms	0ms
Mar 13	00	6,706	1s95ms	0ms
	01	4,475	711ms	0ms
	02	5,881	1s19ms	0ms
	03	3,406	511ms	0ms
	04	3,429	550ms	0ms
	05	2,968	489ms	0ms
	06	2,679	445ms	0ms
	07	4,190	632ms	0ms
	08	12,027	2s55ms	0ms
	09	22,321	4s351ms	0ms
	10	31,680	7s738ms	0ms
	11	29,554	8s510ms	0ms
	12	24,299	7s644ms	0ms
	13	29,097	9s108ms	0ms
	14	36,532	10s568ms	0ms
	15	30,641	7s358ms	0ms
	16	12,774	2s502ms	0ms
	17	4,692	853ms	0ms
	18	11,762	2s357ms	0ms
	19	11,081	2s283ms	0ms

SELECT 1 FROM res_groups_users_rel WHERE uid = 831 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'active_unactive_policy' AND model = 'res.groups');

Date: 2025-03-13 19:26:44 Duration: 21ms
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: 2025-03-13 10:34:44 Duration: 3ms
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: 2025-03-13 13:54:33 Duration: 2ms

14

266,458

Details

1m34s

0ms

23ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	23	9,069	2s681ms	0ms
Mar 13	00	7,025	1s856ms	0ms
	01	7,182	1s981ms	0ms
	02	4,459	1s609ms	0ms
	03	3,958	1s	0ms
	04	6,195	1s758ms	0ms
	05	5,076	1s678ms	0ms
	06	5,065	1s626ms	0ms
	07	4,483	1s334ms	0ms
	08	7,796	2s409ms	0ms
	09	15,736	4s42ms	0ms
	10	24,486	7s723ms	0ms
	11	26,557	11s607ms	0ms
	12	30,778	14s200ms	0ms
	13	27,063	13s792ms	0ms
	14	20,334	7s566ms	0ms
	15	19,291	5s915ms	0ms
	16	12,771	3s614ms	0ms
	17	5,680	1s649ms	0ms
	18	12,754	3s599ms	0ms
	19	10,700	3s121ms	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 (44971227, 44617249, 45032222, 44963578, 45030130, 45091005, 44956945, 45219075, 44956534, 44956942, 45181313, 45181911, 32180328, 45077482, 45163546, 45163547, 45153490, 45077390, 45072269, 45029022, 45084891, 45084892, 45084896, 45139793, 44907008, 44964595, 45032536, 40141239, 45102135, 45153497, 45028909, 45170467, 45084897, 45076740, 45136146, 45202193, 45076304, 45076263, 45132567, 44746783, 44746775, 32475236, 44746299, 45076365, 45076951, 45084051, 45018482, 45094717, 45110997, 45160569, 45202113, 45018808, 45109956, 45178355, 44775646, 45156875, 45134097, 45019317, 45048536, 45092817, 45160969, 45093167, 45091431, 44779879, 45172767, 45172768, 44854914, 45114915, 45209371, 45172401, 45128445, 45172059, 45172046, 44954323, 45045892, 45178518, 45083757, 45045836, 45125347, 45048866, 45048872, 45048510, 45172212, 45139748, 45146952, 45144091, 45074818, 44863603, 45088339, 45146162, 45136563, 45069525, 32474785, 45124835, 45000731, 45158515, 45097664, 44849397, 45083866, 45097866);

Date: 2025-03-13 14:21:56 Duration: 23ms
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 (41935718, 41987042, 40591295, 44714208, 41667306, 41672683, 42088046, 44599482, 44622669, 32448285, 32265888, 32266382, 32560196, 41281584, 41461150, 41550660, 41574678, 42013038, 42160209, 44606902, 44754491, 32196562, 32667122, 41619496, 41821771, 41822591, 41961689, 44751194, 44839011, 32207370, 32338832, 32353212, 32357461, 32387655, 32427872, 32429159, 32445106, 32459937, 32472170, 32478586, 32547367, 32568164, 41460564, 41502183, 41608100, 41635117, 41662237, 41803349, 41873333, 41887213, 41986484, 42002774, 42130570, 42137423, 44519001, 44549473, 44703088, 44729802, 44879719, 44898242, 44882413, 44898332, 44987001, 44805823, 45097729, 45105389, 32191900, 32354174, 32508588, 32528950, 32537128, 41166489, 41262970, 41450893, 41512783, 41662276, 41701213, 41790877, 41794716, 41840451, 41867294, 41936145, 41936347, 41936516, 41941099, 42047823, 42112723, 42119203, 42129611, 42138201, 42142188, 42148487, 44500107, 44500623, 44515636, 44531347, 44649094, 44770159, 44825285, 44902666);

Date: 2025-03-13 02:22:09 Duration: 20ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (45148885, 44839256, 44550656, 45134057, 45093352, 44838659, 44765570, 44992451, 45018352, 44872099, 45046737, 44714048, 32439040, 44834447, 44847476, 44835228, 45129884, 44954907, 44878776, 44982566, 44834304, 44907347, 44902502, 45033307, 44964041, 44864769, 45104390, 45032522, 45083466, 45138171, 45052834, 44714623, 44677953, 45059025, 44920786, 44969585, 44913781, 45078300, 44864610, 44994528, 45042803, 45075236, 45106156, 45133328, 45136327, 45148120, 45148425, 45149173, 44550591, 44853946, 44905852, 44924589, 44952806, 45011136, 45011569, 45042327, 45047282, 45148194, 44885734, 44949046, 45071638, 44993432, 44893556, 45053416, 45056754, 45074178, 44632540, 44974397, 45056204, 45046722);

Date: 2025-03-13 02:22:07 Duration: 18ms

15

200,035

Details

36s782ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Mar 12	23	5,176	754ms	0ms
Mar 13	00	3,933	587ms	0ms
	01	3,730	601ms	0ms
	02	2,963	552ms	0ms
	03	2,195	348ms	0ms
	04	3,965	677ms	0ms
	05	2,803	507ms	0ms
	06	3,822	693ms	0ms
	07	3,216	566ms	0ms
	08	5,523	924ms	0ms
	09	12,653	1s108ms	0ms
	10	20,400	2s475ms	0ms
	11	23,018	4s722ms	0ms
	12	25,996	7s611ms	0ms
	13	21,382	6s810ms	0ms
	14	15,365	2s400ms	0ms
	15	14,496	1s902ms	0ms
	16	10,002	1s243ms	0ms
	17	3,777	521ms	0ms
	18	7,811	978ms	0ms
	19	7,809	793ms	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 (2414);

Date: 2025-03-13 13:19:49 Duration: 2ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2414);

Date: 2025-03-13 02:21:56 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 (2414);

Date: 2025-03-13 12:19:20 Duration: 1ms

16

174,954

Details

14s372ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7,970	504ms	0ms
Mar 13	00	3,718	212ms	0ms
	01	2,063	117ms	0ms
	02	2,555	161ms	0ms
	03	1,685	90ms	0ms
	04	1,498	88ms	0ms
	05	1,169	74ms	0ms
	06	1,333	82ms	0ms
	07	1,598	89ms	0ms
	08	5,238	316ms	0ms
	09	12,086	787ms	0ms
	10	20,494	1s617ms	0ms
	11	17,255	1s684ms	0ms
	12	14,227	1s549ms	0ms
	13	16,670	1s816ms	0ms
	14	22,299	2s100ms	0ms
	15	20,173	1s539ms	0ms
	16	7,773	512ms	0ms
	17	2,753	171ms	0ms
	18	6,205	427ms	0ms
	19	6,192	428ms	0ms

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

Date: 2025-03-13 13:51:54 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2025-03-13 13:34:32 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (88, 89);

Date: 2025-03-13 13:16:40 Duration: 1ms

17

170,566

Details

4h34m54s

47ms

592ms

96ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7,124	9m26s	79ms
Mar 13	00	4,556	5m49s	76ms
	01	4,101	5m18s	77ms
	02	4,617	4m46s	62ms
	03	2,662	2m25s	54ms
	04	3,877	3m37s	56ms
	05	4,003	4m19s	64ms
	06	5,113	5m29s	64ms
	07	2,942	3m2s	61ms
	08	3,770	4m13s	67ms
	09	6,971	8m8s	70ms
	10	12,368	16m25s	79ms
	11	15,975	27m31s	103ms
	12	19,816	47m42s	144ms
	13	19,352	50m5s	155ms
	14	12,319	23m9s	112ms
	15	10,801	15m53s	88ms
	16	8,283	10m55s	79ms
	17	4,714	5m17s	67ms
	18	10,892	13m20s	73ms
	19	6,310	7m55s	75ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6200716, 6192914, 6178704, 6178103, 6175852, 6175277, 6167713, 6147270)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:08:21 Duration: 592ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6233865, 6233779, 6220951, 6196184, 6185444, 6105549, 6001076)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:56:14 Duration: 580ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187658, 6176247, 6168446, 6167391, 6141469, 6097824, 6089202)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 13:19:13 Duration: 565ms

18

168,899

Details

2m5s

0ms

30ms

0ms

select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "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
Mar 12	23	1,662	1s194ms	0ms
Mar 13	00	1,036	609ms	0ms
	01	1,393	1s218ms	0ms
	02	1,319	1s97ms	0ms
	03	698	520ms	0ms
	04	937	728ms	0ms
	05	564	394ms	0ms
	06	1,560	875ms	0ms
	07	3,516	1s825ms	0ms
	08	7,243	3s623ms	0ms
	09	10,276	6s347ms	0ms
	10	12,182	9s254ms	0ms
	11	15,326	13s295ms	0ms
	12	18,422	18s921ms	1ms
	13	20,344	20s138ms	0ms
	14	15,370	12s30ms	0ms
	15	15,537	9s933ms	0ms
	16	10,780	6s117ms	0ms
	17	8,196	4s94ms	0ms
	18	12,086	7s78ms	0ms
	19	10,452	5s947ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "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 (6044483, 6152651, 6073605, 6044487, 6152683, 6087828, 6087838, 6087837, 6112726, 6071030, 6129499, 5919466, 6093432, 6112816, 5873269, 6087839, 6069250, 6059969, 6073594, 6101701, 6015509, 6059392, 6077538, 5449523, 5695108, 6125200, 6086375, 6058782, 6078123, 6086368, 6073582, 6077554, 6125325, 6165710, 6108315, 6078280, 6129871, 6054123, 5994389, 6138042, 6112212, 6048939, 6029561, 5985653, 6112216, 5956690, 5990596, 6029563, 6068676, 5767068, 6029511, 5906864, 6071002, 6046741, 6029513, 6059962, 6059988, 6014454, 6059965, 6014497, 6010666, 6026975, 6027021, 6078272, 6015511, 6027023, 6078273, 6129050, 5956857, 6078125, 6073607, 6056040, 5873271, 5956856, 6058810, 5939466, 6070857, 6077544, 6077547, 6070859, 6028444, 6014957, 5985678, 5627326, 6060011, 6057660, 6078182, 6012639, 6012634, 5990058, 6045455, 5990154, 6012641, 5886023, 6013570, 6028448, 6028443, 6046736, 6069146, 5990607, 6029515, 6014438, 6028445, 6028442, 6028441, 6012636, 5956858, 6010664, 6010650, 5990151, 5864305, 6028446, 6028450, 6012595, 6012598, 6012599, 6012489, 5990149, 6012594, 5964948, 5854400, 5833604, 5906883, 5907289, 5743669, 1644726, 5911406, 5874591, 5907348, 5910143, 5765321, 5886894, 5695603, 5880209, 5907345, 5845555, 5845838, 5880208, 5767076, 5833602, 5804846, 5802173, 5802078, 5845441, 5841696, 5864925, 5754168, 5802171, 5865003, 5804798, 5776735, 5845834, 5846088, 5776732, 5841686, 5763605, 5695100, 5736563, 5736561, 5804608, 5691275, 5802169, 5727161, 5763701, 5736564, 5736560, 5690606, 5763690, 5743658, 5691387, 5695517, 5663147, 5691315, 5690300, 5663148, 5695605, 5690282, 5690283, 5604927, 5696214, 5691314, 5691273, 5691313, 5663149, 5690302, 5692477, 5690345, 5690965, 5604928, 5690966, 5690967, 5604776, 5614248, 5604782, 5604780, 5614250, 5604930, 5604924, 5614079, 5604926, 5614233, 5604764, 5604923, 5503172, 4371039);

Date: 2025-03-13 10:30:10 Duration: 30ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "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 (6158844, 6158813, 6194747, 6158989, 6158865, 5976246, 6194767, 6158830, 6194743, 6194785, 5973769, 5730798, 5976234, 6158985, 6158982, 6194744, 6200364, 6194755, 5973774, 6158799, 6158881, 6158820, 6158807, 6014261, 6014263, 6158892, 6194763, 6158838, 6194758, 6199490, 6196092, 6082303, 6064217, 6061944, 6067516, 6064129, 6081066, 6067377, 6060757);

Date: 2025-03-13 12:42:58 Duration: 27ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "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 (6173892, 6092579, 6130501, 6211712, 6137781, 6178204, 6086842, 5966277, 6137761, 6216903, 6168301, 6211607, 6168291, 6103225, 6092602, 6219000, 6247506, 6165381, 5565736, 6211809, 6206834, 6216868, 6211785, 6220981, 6211541, 6216842, 6211547, 6206873, 6178276, 6216846, 6216828, 6178378, 6146437, 6186585, 6194141, 6202215, 6220271, 6221653, 6222175, 6242250, 6247445, 6247447, 6211596, 6219028, 6168304, 6173874, 6178281, 6216912, 6178370, 6173846, 6137778, 6173844, 6206832, 6165368, 6216916, 6092629, 6173902, 6086836, 6130482, 6216837, 6178329, 6206818, 6137809, 6130223, 6173884, 5898398, 6165377, 6216834, 6173834, 6085788, 6085791, 6158366, 6159681, 6183528, 6184143, 6192364, 6192589, 6207114, 6130518, 6091808, 6128609, 6165307, 6178799, 6181510, 6189222, 6206813, 6173895, 6213586, 6230150, 6173901, 6168316, 6211621, 6168318, 6035714, 6036085, 6173814, 6130206, 5792025, 6090666, 6211592, 6137798, 5986487, 6173836, 6130492, 6168296, 5832941, 6130114, 6130499, 6130226, 6071444, 6173816, 6058489, 6137744, 6178260, 6178147, 6137789, 6090714, 6137821, 6068791, 6130182, 5996924, 6137802, 6173896, 5914323, 6168319, 6173899, 6090669, 6168288, 6168289, 6173889, 6130111, 6092606, 6137793, 6178321, 5966368, 6071428, 6029643, 6165386, 6151886, 6168529, 6182586, 6192918, 6207110, 6210619, 6173881, 6173824, 6130479, 6072978, 6130163, 6090752, 6090649, 6092650, 6071439, 5748298, 6130516, 6029652, 6137767, 6128133, 6173612, 6207113, 6137768, 6137824, 6130205, 6103181, 6051345, 6090618, 6126961, 6175634, 5667751, 5838390, 5909895, 5964732, 5997697, 6056999, 6121324, 6133344, 6151576, 6153736, 6157699, 6165309, 6175931, 6173826, 6137806, 6068784, 6092641, 6130126, 6137804, 6090629, 6090687, 5784206, 5993365, 6130165, 6090663, 6130122, 5993384, 6103446, 6090684, 6137791);

Date: 2025-03-13 14:21:59 Duration: 25ms

19

167,143

Details

31s140ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7,329	989ms	0ms
Mar 13	00	3,385	418ms	0ms
	01	1,921	234ms	0ms
	02	2,526	333ms	0ms
	03	1,395	156ms	0ms
	04	1,445	180ms	0ms
	05	1,150	151ms	0ms
	06	1,308	171ms	0ms
	07	1,568	187ms	0ms
	08	5,107	668ms	0ms
	09	11,588	1s692ms	0ms
	10	19,742	3s559ms	0ms
	11	16,728	3s781ms	0ms
	12	13,577	3s428ms	0ms
	13	15,907	4s48ms	0ms
	14	21,350	4s603ms	0ms
	15	19,099	3s287ms	0ms
	16	7,536	1s94ms	0ms
	17	2,643	351ms	0ms
	18	5,935	898ms	0ms
	19	5,904	903ms	0ms

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

Date: 2025-03-13 15:26:46 Duration: 2ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (95) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-03-13 10:42:45 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-03-13 12:00:17 Duration: 1ms

20

145,888

Details

56s699ms

0ms

25ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Mar 12	23	9,912	3s188ms	0ms
Mar 13	00	11,657	3s547ms	0ms
	01	14,599	4s677ms	0ms
	02	8,231	3s143ms	0ms
	03	8,010	2s613ms	0ms
	04	10,796	3s586ms	0ms
	05	11,336	4s53ms	0ms
	06	7,396	3s209ms	0ms
	07	6,553	2s444ms	0ms
	08	7,562	2s567ms	0ms
	09	5,014	1s766ms	0ms
	10	3,406	1s438ms	0ms
	11	2,967	2s79ms	0ms
	12	3,789	3s80ms	0ms
	13	3,560	2s651ms	0ms
	14	3,495	2s138ms	0ms
	15	4,013	1s855ms	0ms
	16	3,942	1s450ms	0ms
	17	4,783	1s522ms	0ms
	18	8,429	3s259ms	0ms
	19	6,438	2s424ms	0ms

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

Date: 2025-03-13 11:27:04 Duration: 25ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 17) AND ("price_list"."to_office_id" = 64)) ORDER BY "price_list"."id";

Date: 2025-03-13 14:22:22 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 22) AND ("price_list"."to_office_id" = 78)) ORDER BY "price_list"."id";

Date: 2025-03-13 10:34:17 Duration: 2ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

681ms

9s262ms

1s419ms

52,226

Details

20h35m35s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Mar 12	23	2,312	36m43s	953ms
Mar 13	00	694	10m50s	937ms
	01	482	7m40s	956ms
	02	897	12m55s	864ms
	03	353	4m34s	776ms
	04	409	5m29s	804ms
	05	338	5m18s	941ms
	06	1,252	18m14s	874ms
	07	318	4m45s	896ms
	08	864	13m10s	915ms
	09	2,543	39m59s	943ms
	10	4,728	1h25m36s	1s86ms
	11	4,564	1h57m50s	1s549ms
	12	5,972	3h56m59s	2s381ms
	13	5,741	4h5m25s	2s564ms
	14	4,627	2h2m4s	1s582ms
	15	4,362	1h18m49s	1s84ms
	16	3,379	53m28s	949ms
	17	1,619	23m55s	886ms
	18	3,285	54m18s	991ms
	19	3,487	57m25s	988ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6247140, 6223113, 6217007, 6183532, 6151626, 6113269, 6094988)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:18:53 Duration: 9s262ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6248357, 6137452, 6240084, 6240179, 6240236, 6240247, 6247652, 6169092, 6172116, 6172786, 6177219, 6184165, 6184471, 6185767, 6188460, 6188814, 6189174, 6197970, 6206830, 6207985, 6208174, 6210000, 6210238, 6211014, 6212674, 6212748, 6214090, 6214736, 6214753, 6215212, 6216416, 6217983, 6218565, 6220778, 6220812, 6223498, 6224751, 6226072, 6228040, 6228097, 6228114, 6228505, 6229315, 6229389, 6231031, 6231465, 6235170, 6235265, 6236925, 6236993, 6237038, 6237067, 6237127, 6237138, 6237142, 6237146, 6237165)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:26:47 Duration: 8s981ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6292943, 6292941, 6292938, 6292935, 6292934, 6292932)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 12:29:07 Duration: 8s744ms

2

905ms

3s93ms

1s202ms

20,362

Details

6h48m4s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	1,362	26m45s	1s178ms
Mar 13	00	1,546	29m12s	1s133ms
	01	1,746	33m53s	1s164ms
	02	868	16m53s	1s167ms
	03	1,267	23m24s	1s108ms
	04	1,925	35m44s	1s114ms
	05	2,241	43m16s	1s158ms
	06	921	17m39s	1s150ms
	07	1,083	19m59s	1s108ms
	08	1,476	27m26s	1s115ms
	09	1,004	19m46s	1s181ms
	10	533	10m52s	1s223ms
	11	326	9m5s	1s672ms
	12	187	6m48s	2s185ms
	13	159	5m37s	2s120ms
	14	292	8m54s	1s829ms
	15	193	4m25s	1s373ms
	16	500	10m21s	1s242ms
	17	628	12m23s	1s184ms
	18	1,282	27m33s	1s289ms
	19	823	18m	1s313ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9546848')) 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: 2025-03-13 12:36:03 Duration: 3s93ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '972202')) 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: 2025-03-13 12:27:23 Duration: 3s11ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1015112')) AND ("policy_number"."package_id" = 2414)) 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: 2025-03-13 13:22:28 Duration: 2s880ms

3

675ms

8s359ms

1s202ms

303,825

Details

4d5h28m34s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11,140	2h58m17s	960ms
Mar 13	00	8,464	2h13m	942ms
	01	10,341	2h44m48s	956ms
	02	11,754	2h43m57s	836ms
	03	7,345	1h32m23s	754ms
	04	10,205	2h10m28s	767ms
	05	11,105	2h40m48s	868ms
	06	13,900	3h15m53s	845ms
	07	9,076	2h5m	826ms
	08	9,230	2h15m53s	883ms
	09	12,168	3h6m36s	920ms
	10	18,333	5h18m42s	1s43ms
	11	22,707	8h19m58s	1s321ms
	12	27,928	15h28m13s	1s994ms
	13	29,216	17h31m54s	2s160ms
	14	21,161	8h2m8s	1s367ms
	15	18,553	5h22m51s	1s44ms
	16	12,266	3h13m16s	945ms
	17	8,758	2h9m42s	888ms
	18	16,889	4h34m50s	976ms
	19	13,286	3h39m47s	992ms

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

Date: 2025-03-13 12:06:10 Duration: 8s359ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293356)) AND (("shipping_track"."id" not in (52553959, 52553959)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:25:31 Duration: 8s298ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6293340)) AND (("shipping_track"."id" not in (52553071, 52553071)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-03-13 13:23:58 Duration: 8s271ms

4

401ms

2s771ms

1s179ms

9,670

Details

3h10m6s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Mar 12	23	1,056	19m6s	1s85ms
Mar 13	00	1,262	22m5s	1s50ms
	01	1,584	28m17s	1s71ms
	02	553	9m25s	1s22ms
	03	386	6m34s	1s21ms
	04	278	4m49s	1s39ms
	08	127	2m8s	1s15ms
	09	128	2m12s	1s37ms
	10	134	2m46s	1s242ms
	11	30	46s15ms	1s533ms
	12	162	5m2s	1s869ms
	13	472	15m36s	1s984ms
	14	290	6m20s	1s311ms
	15	608	13m27s	1s328ms
	16	431	8m23s	1s168ms
	17	567	9m49s	1s40ms
	18	807	17m7s	1s273ms
	19	795	16m4s	1s213ms

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

Date: 2025-03-13 13:22:20 Duration: 2s771ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '315305')) 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 (19))))))) 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 (19)))))) 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 (19)))))) 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 (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-03-13 13:25:44 Duration: 2s768ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1077610')) AND ("policy_number"."package_id" = 2414)) 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 (19))))))) 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 (19)))))) 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 (19)))))) 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 (19))))))))) ORDER BY "policy_number"."id";

Date: 2025-03-13 13:36:59 Duration: 2s752ms

5

26ms

2s383ms

1s77ms

2,629

Details

47m12s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Mar 12	23	28	18s429ms	658ms
Mar 13	00	12	6s2ms	500ms
	01	4	1s197ms	299ms
	02	3	1s472ms	490ms
	05	1	1s357ms	1s357ms
	06	1	962ms	962ms
	07	14	13s807ms	986ms
	08	42	27s257ms	648ms
	09	219	2m27s	673ms
	10	229	3m19s	869ms
	11	307	6m4s	1s188ms
	12	361	8m27s	1s405ms
	13	447	9m43s	1s305ms
	14	326	6m3s	1s115ms
	15	297	4m	810ms
	16	63	59s748ms	948ms
	17	38	33s962ms	893ms
	18	155	2m58s	1s151ms
	19	82	1m22s	1s1ms

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

Date: 2025-03-13 13:41:23 Duration: 2s383ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-03-13 13:38:56 Duration: 2s367ms
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;

Date: 2025-03-13 14:18:47 Duration: 2s364ms

6

326ms

5s751ms

954ms

2,145

Details

34m6s

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Mar 12	23	100	53s505ms	535ms
Mar 13	00	53	26s317ms	496ms
	01	41	19s707ms	480ms
	02	100	44s773ms	447ms
	03	40	15s198ms	379ms
	04	67	26s390ms	393ms
	05	76	30s939ms	407ms
	06	72	28s747ms	399ms
	07	73	28s77ms	384ms
	08	111	46s426ms	418ms
	09	66	28s588ms	433ms
	10	108	1m1s	571ms
	11	207	4m16s	1s237ms
	12	231	7m34s	1s967ms
	13	237	8m2s	2s34ms
	14	206	4m2s	1s176ms
	15	117	1m13s	625ms
	16	63	33s683ms	534ms
	17	34	16s315ms	479ms
	18	69	38s104ms	552ms
	19	74	39s512ms	533ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('930391', '964392', '394775', '269496', '908458', '1040119', '');

Date: 2025-03-13 14:01:42 Duration: 5s751ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('679644', '1005615', '1025009', '', '');

Date: 2025-03-13 13:04:03 Duration: 4s613ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9794279', '9794293', '9794292', '9794285', '9794287', '');

Date: 2025-03-13 13:12:01 Duration: 4s570ms

7

276ms

4s464ms

713ms

23,206

Details

4h35m54s

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 ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Mar 13	07	378	2m17s	363ms
	08	1,150	8m	417ms
	09	677	4m33s	404ms
	10	5	3s155ms	631ms
	11	3,556	40m23s	681ms
	12	2,874	45m26s	948ms
	13	3,905	1h6m22s	1s19ms
	14	3,660	47m8s	772ms
	15	1,707	16m32s	581ms
	16	2,420	20m16s	502ms
	17	1,618	13m9s	487ms
	18	929	8m40s	559ms
	19	327	3m	553ms

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" = '976502')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 12:23:37 Duration: 4s464ms
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" = '661022')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:22:37 Duration: 4s358ms
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" = '466766')))) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:16:38 Duration: 4s269ms

8

259ms

2s854ms

523ms

4,094

Details

35m43s

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and (((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) and (("cash_policy"."state" not in (...)) or "cash_policy"."state" is null)) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11	4s747ms	431ms
Mar 13	01	55	25s701ms	467ms
	07	2	550ms	275ms
	08	313	1m32s	296ms
	09	343	1m46s	309ms
	10	422	2m37s	373ms
	11	667	5m26s	489ms
	12	522	7m17s	837ms
	13	474	6m31s	826ms
	14	467	4m29s	576ms
	15	266	2m	454ms
	16	252	1m37s	385ms
	17	124	44s919ms	362ms
	18	86	34s591ms	402ms
	19	90	33s543ms	372ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1013262')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:35:48 Duration: 2s854ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1040351')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:27:29 Duration: 2s810ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '734030')) AND (((("cash_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, 128, 23)))) OR ("cash_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, 128, 23))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:26:43 Duration: 2s762ms

9

262ms

2s775ms

509ms

4,064

Details

34m29s

select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Mar 13	08	498	2m27s	295ms
	09	938	4m53s	313ms
	10	452	2m39s	352ms
	11	753	6m20s	505ms
	12	1,286	16m34s	773ms
	13	131	1m30s	689ms
	14	2	1s110ms	555ms
	15	4	1s901ms	475ms

SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897361')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:25:22 Duration: 2s775ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897336')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:27:32 Duration: 2s763ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '897399')) AND ((("cash_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, 23, 112)))) OR ("cash_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, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:25:32 Duration: 2s756ms

10

257ms

2s911ms

506ms

20,067

Details

2h49m30s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	2,064	13m38s	396ms
Mar 13	00	1,463	9m22s	384ms
	01	120	45s650ms	380ms
	02	330	1m51s	338ms
	03	374	1m52s	301ms
	04	244	1m14s	306ms
	06	693	3m25s	296ms
	07	654	3m8s	287ms
	08	1,158	5m51s	303ms
	09	1,409	7m16s	310ms
	10	1,882	11m15s	358ms
	11	1,628	14m50s	546ms
	12	2,273	27m50s	734ms
	13	3,104	45m5s	871ms
	14	1,616	14m42s	546ms
	15	513	3m46s	441ms
	16	234	1m28s	377ms
	17	57	21s379ms	375ms
	18	102	43s62ms	422ms
	19	149	58s779ms	394ms

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

Date: 2025-03-13 13:35:47 Duration: 2s907ms

11

253ms

2s861ms

482ms

4,038

Details

32m29s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	7	3s3ms	429ms
Mar 13	02	30	8s982ms	299ms
	03	47	13s801ms	293ms
	05	481	2m19s	289ms
	08	431	2m8s	297ms
	09	127	39s847ms	313ms
	10	212	1m17s	365ms
	11	2,344	21m42s	555ms
	12	292	3m28s	714ms
	16	67	27s550ms	411ms

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

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

Date: 2025-03-13 12:21:38 Duration: 2s858ms
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" = '1096246')) 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, 23, 112, 12)))) 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, 23, 112, 12))))) 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, 23, 112, 12))))) 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: 2025-03-13 11:54:47 Duration: 2s657ms

12

250ms

3s142ms

454ms

137,752

Details

17h24m19s

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
Mar 12	23	2,962	19m33s	396ms
Mar 13	00	2,878	18m28s	385ms
	01	1,859	11m48s	381ms
	02	4,775	26m48s	336ms
	03	1,827	8m57s	294ms
	04	3,500	17m32s	300ms
	05	4,430	21m59s	297ms
	06	3,742	18m30s	296ms
	07	5,041	24m13s	288ms
	08	8,525	42m22s	298ms
	09	6,736	35m10s	313ms
	10	5,494	32m10s	351ms
	11	12,513	1h49m7s	523ms
	12	14,261	2h45m58s	698ms
	13	12,189	2h36m27s	770ms
	14	7,617	1h9m10s	544ms
	15	8,059	58m21s	434ms
	16	7,737	50m26s	391ms
	17	7,340	44m51s	366ms
	18	10,807	1h15m21s	418ms
	19	5,460	36m59s	406ms

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

Date: 2025-03-13 13:38:09 Duration: 3s142ms
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" = '1072169')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-03-13 13:19:45 Duration: 2s925ms
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" = '1038752')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-03-13 13:38:06 Duration: 2s924ms

13

191ms

2s332ms

430ms

8,158

Details

58m30s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Mar 12	23	11	3s966ms	360ms
Mar 13	01	55	22s122ms	402ms
	07	2	556ms	278ms
	08	810	3m28s	256ms
	09	1,282	5m44s	269ms
	10	874	4m35s	315ms
	11	1,420	9m58s	421ms
	12	1,807	19m22s	643ms
	13	606	6m17s	622ms
	14	469	3m50s	490ms
	15	270	1m47s	398ms
	16	252	1m27s	346ms
	17	124	36s680ms	295ms
	18	86	28s339ms	329ms
	19	90	27s347ms	303ms

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

Date: 2025-03-13 12:05:14 Duration: 2s332ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '896204')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 12:18:03 Duration: 2s315ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '1047035')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-03-13 13:12:37 Duration: 2s307ms

14

123ms

1s383ms

421ms

6,326

Details

44m24s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Mar 12	23	200	31s657ms	158ms
Mar 13	00	52	8s7ms	153ms
	01	96	14s776ms	153ms
	02	45	7s390ms	164ms
	03	130	17s598ms	135ms
	04	128	17s516ms	136ms
	05	40	6s225ms	155ms
	06	15	2s269ms	151ms
	07	40	5s825ms	145ms
	08	131	20s398ms	155ms
	09	258	42s718ms	165ms
	10	664	2m32s	229ms
	11	1,082	6m41s	371ms
	12	1,031	12m17s	715ms
	13	1,161	13m37s	704ms
	14	527	3m52s	440ms
	15	355	1m18s	220ms
	16	143	26s94ms	182ms
	17	41	6s538ms	159ms
	18	59	11s271ms	191ms
	19	128	26s31ms	203ms

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

Date: 2025-03-13 13:35:33 Duration: 1s383ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 73)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-03-13 13:39:09 Duration: 1s299ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 27)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-03-13 13:24:31 Duration: 1s292ms

15

92ms

1s80ms

259ms

59,247

Details

4h16m27s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	4,788	19m27s	243ms
Mar 13	00	5,553	21m53s	236ms
	01	6,593	27m29s	250ms
	02	2,806	10m23s	222ms
	03	3,260	11m48s	217ms
	04	4,362	15m35s	214ms
	05	4,436	17m2s	230ms
	06	1,810	7m23s	244ms
	07	2,120	8m	226ms
	08	3,164	12m7s	230ms
	09	2,210	9m1s	245ms
	10	1,312	5m42s	261ms
	11	696	4m19s	373ms
	12	676	6m10s	548ms
	13	1,232	11m36s	565ms
	14	1,154	6m56s	361ms
	15	1,572	7m12s	275ms
	16	1,826	9m5s	298ms
	17	2,357	9m18s	236ms
	18	4,129	20m10s	293ms
	19	3,191	15m39s	294ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 14:22:23 Duration: 1s80ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ندادين')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 13:26:48 Duration: 996ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عاس')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-03-13 13:41:33 Duration: 984ms

16

121ms

1s117ms

253ms

27,023

Details

1h54m11s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	876	2m25s	165ms
Mar 13	00	289	45s958ms	159ms
	01	111	17s936ms	161ms
	02	37	6s609ms	178ms
	03	76	10s952ms	144ms
	04	1	136ms	136ms
	05	30	4s936ms	164ms
	06	210	35s805ms	170ms
	07	109	15s464ms	141ms
	08	195	29s919ms	153ms
	09	1,838	4m53s	159ms
	10	3,099	9m32s	184ms
	11	2,679	11m34s	259ms
	12	3,825	24m28s	383ms
	13	3,558	25m1s	422ms
	14	3,600	14m40s	244ms
	15	2,434	7m16s	179ms
	16	1,058	2m51s	162ms
	17	332	56s222ms	169ms
	18	1,659	4m51s	175ms
	19	1,007	2m50s	169ms

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

Date: 2025-03-13 12:26:38 Duration: 1s117ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8329506)) AND (("cash_track"."id" not in (9411080)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-03-13 13:28:26 Duration: 1s116ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8329604)) AND (("cash_track"."id" not in (9411784)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-03-13 13:36:30 Duration: 1s116ms

17

177ms

446ms

234ms

18,166

Details

1h10m52s

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

Day	Hour	Count	Duration	Avg duration
Mar 12	23	871	3m51s	265ms
Mar 13	00	1,245	5m22s	258ms
	01	1,575	6m44s	256ms
	02	3,416	13m28s	236ms
	03	1,388	4m53s	211ms
	04	3,153	11m31s	219ms
	05	3,187	12m19s	231ms
	06	1,781	6m58s	234ms
	07	1,498	5m32s	222ms
	08	52	12s65ms	232ms

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" = '1037610')) 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: 2025-03-13 02:23:17 Duration: 446ms
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" = '895465')) 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: 2025-03-13 02:01:38 Duration: 391ms
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" = '1021241')) 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: 2025-03-12 23:29:24 Duration: 324ms

18

60ms

495ms

117ms

51,885

Details

1h41m44s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Mar 12	23	51	4s411ms	86ms
Mar 13	00	3	241ms	80ms
	07	406	29s973ms	73ms
	08	2,661	3m24s	76ms
	09	1,509	1m59s	79ms
	10	178	15s111ms	84ms
	11	5,832	12m4s	124ms
	12	6,947	17m9s	148ms
	13	10,330	27m42s	160ms
	14	6,261	11m51s	113ms
	15	3,647	5m52s	96ms
	16	4,753	7m10s	90ms
	17	3,347	4m41s	84ms
	18	5,225	7m52s	90ms
	19	735	1m5s	88ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6093601) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 12:25:40 Duration: 495ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6126764) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:33:19 Duration: 472ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6211537) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 23)))) ORDER BY "collection_policy"."id";

Date: 2025-03-13 14:25:59 Duration: 455ms

19

53ms

379ms

103ms

22,238

Details

38m20s

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
Mar 13	07	200	13s202ms	66ms
	08	1,212	1m25s	70ms
	09	994	1m10s	71ms
	10	5	385ms	77ms
	11	2,834	5m13s	110ms
	12	3,255	7m4s	130ms
	13	3,031	7m5s	140ms
	14	3,435	5m58s	104ms
	15	1,618	2m25s	89ms
	16	2,143	3m1s	84ms
	17	1,629	2m4s	76ms
	18	1,554	2m10s	84ms
	19	328	25s842ms	78ms

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

Date: 2025-03-13 14:23:18 Duration: 379ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6154694) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:58:20 Duration: 377ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6122522) ORDER BY "collection_policy"."id";

Date: 2025-03-13 13:23:47 Duration: 377ms

20

47ms

592ms

96ms

170,566

Details

4h34m54s

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
Mar 12	23	7,124	9m26s	79ms
Mar 13	00	4,556	5m49s	76ms
	01	4,101	5m18s	77ms
	02	4,617	4m46s	62ms
	03	2,662	2m25s	54ms
	04	3,877	3m37s	56ms
	05	4,003	4m19s	64ms
	06	5,113	5m29s	64ms
	07	2,942	3m2s	61ms
	08	3,770	4m13s	67ms
	09	6,971	8m8s	70ms
	10	12,368	16m25s	79ms
	11	15,975	27m31s	103ms
	12	19,816	47m42s	144ms
	13	19,352	50m5s	155ms
	14	12,319	23m9s	112ms
	15	10,801	15m53s	88ms
	16	8,283	10m55s	79ms
	17	4,714	5m17s	67ms
	18	10,892	13m20s	73ms
	19	6,310	7m55s	75ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6200716, 6192914, 6178704, 6178103, 6175852, 6175277, 6167713, 6147270)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:08:21 Duration: 592ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6233865, 6233779, 6220951, 6196184, 6185444, 6105549, 6001076)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 12:56:14 Duration: 580ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187658, 6176247, 6168446, 6167391, 6141469, 6097824, 6089202)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-03-13 13:19:13 Duration: 565ms

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

18,777,015 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	59	0.00%
DETAIL	35	0.00%
ERROR	765	0.00%
EVENTLOG	11	0.00%
FATAL	2,689	0.01%
HINT	16	0.00%
LOG	18,772,486	99.98%
STATEMENT	954	0.01%

Events distribution (except queries)

Key values

0 PANIC entries
2689 FATAL entries
765 ERROR entries
0 WARNING entries
11 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,305 Max number of times the same event was reported
3,465 Total events found

Rank

Times reported

Error

1

1,305

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Mar 13	02	282
	05	147
	08	147
	11	194
	14	341
	17	194

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

2

1,169

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Mar 13	02	57
	05	47
	08	62
	11	421
	14	465
	17	117

3

447

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Mar 12	23	15
Mar 13	00	10
	01	4
	02	16
	03	3
	04	8
	05	7
	06	4
	07	3
	08	9
	09	11
	10	12
	11	31
	12	67
	13	74
	14	45
	15	33
	16	17
	17	10
	18	41
	19	27

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

4

240

Details

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

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Mar 12	23	7
Mar 13	00	4
	01	8
	03	3
	07	2
	08	8
	09	14
	10	29
	11	23
	12	21
	13	44
	14	35
	15	12
	16	1
	17	2
	18	7
	19	20

ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 159

5

169

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Mar 13	02	12
	05	8
	08	8
	11	16
	14	105
	17	20

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

6

43

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Mar 13	02	2
	05	2
	08	2
	11	4
	14	28
	17	5

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

7

16

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Mar 12	23	2
Mar 13	02	3
	06	1
	10	1
	12	2
	13	3
	14	1
	15	1
	17	2

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

8

12

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Mar 12	23	2
Mar 13	02	1
	05	3
	11	2
	14	4

9

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Mar 13	06	3
	13	3
	18	3

FATAL: password authentication failed for user "postgres"

10

9

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Mar 12	23	1
Mar 13	02	2
	05	1
	08	1
	11	1
	14	2
	17	1

11

8

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Mar 12	23	1
Mar 13	13	1
	15	2
	16	1
	17	2
	19	1

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

12

6

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Mar 13	12	1
	14	1
	15	4

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

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Mar 13	00	3
	07	1
	11	1
	19	1

14

5

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Mar 13	09	3
	12	2

15

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Mar 13	02	1
	07	1
	11	1
	19	1

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Mar 13	09	1
	10	1
	14	2

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

17

4

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Mar 13	00	1
	07	1
	11	1
	19	1

18

3

Details

FATAL: canceling authentication due to timeout

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Mar 13	02	1
	08	1
	11	1

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Mar 13	00	1
	10	1

20

1

Details

ERROR: incomplete startup packet

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Mar 13	12	1

21

1

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Mar 13	13	1

ERROR: column urgent_office.is_no_change_office does not exist at character 574

22

1

Details

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

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Mar 12	23	1

23

1

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Mar 13	00	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