pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Wed Jan 8 23:47:25 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 43,065,979 log entries in 2m24s
Log start from 2025-01-08 00:00:00 to 2025-01-08 22:45:01

Global Stats

20,860 Number of unique normalized queries
18,388,977 Number of queries
5d18h38m24s Total query duration
2025-01-08 00:00:00 First query
2025-01-08 22:45:01 Last query
6,140 queries/s at 2025-01-08 12:23:13 Query peak

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

25,504 Number of events
24 Number of unique normalized events
17,504 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,388,977 Average queries per session
5d18h38m24s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

6,140 queries/s Query Peak
2025-01-08 12:23:13 Date

SELECT Traffic

Key values

4,026 queries/s Query Peak
2025-01-08 12:23:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,444 queries/s Query Peak
2025-01-08 12:08:13 Date

Queries duration

Key values

5d18h38m24s 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)
Jan 08	00	304,203	0ms	55m58s	160ms	3m4s	3m55s	12h5m58s
	01	320,888	0ms	38m36s	66ms	3m34s	4m13s	4h10m25s
	02	306,383	0ms	24m55s	97ms	4m9s	4m26s	6h25m9s
	03	259,685	0ms	1m16s	26ms	3m48s	4m23s	7m2s
	04	180,798	0ms	925ms	22ms	2m29s	3m	3m54s
	05	118,937	0ms	639ms	14ms	1m5s	1m28s	1m31s
	06	224,759	0ms	4s492ms	18ms	2m42s	2m53s	3m24s
	07	195,820	0ms	3s58ms	13ms	1m57s	2m21s	2m49s
	08	418,624	0ms	4s350ms	7ms	2m	2m32s	3m7s
	09	1,108,098	0ms	38m3s	39ms	4m33s	4m46s	8h6m33s
	10	1,571,452	0ms	16m57s	17ms	7m12s	7m53s	2h34m14s
	11	1,613,822	0ms	17m6s	15ms	7m38s	9m7s	2h6m7s
	12	1,682,458	0ms	12m27s	15ms	8m19s	9m	1h31m21s
	13	1,615,495	0ms	26m10s	19ms	6m28s	10m40s	3h13m7s
	14	1,343,694	0ms	41m8s	30ms	5m43s	8m4s	6h14m55s
	15	1,297,255	0ms	1m58s	10ms	5m11s	5m26s	40m30s
	16	1,294,128	0ms	14m11s	16ms	6m39s	8m14s	1h29m59s
	17	1,347,675	0ms	6m58s	21ms	11m55s	14m16s	53m24s
	18	928,329	0ms	55s385ms	16ms	7m51s	9m5s	11m35s
	19	857,841	0ms	5m44s	30ms	7m27s	8m53s	1h56m22s
	20	624,159	0ms	30m56s	70ms	6m42s	9m52s	8h57m14s
	21	502,100	0ms	12m14s	48ms	5m7s	7m42s	3h37m45s
	22	272,374	0ms	3s28ms	22ms	4m36s	6m44s	7m

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 08	00	167,101	31ms	2m20s	2m57s	3m23s
	01	175,938	36ms	2m30s	3m21s	4m12s
	02	168,488	40ms	3m1s	3m57s	4m25s
	03	130,995	51ms	2m36s	3m35s	5m17s
	04	86,154	47ms	1m40s	2m29s	3m33s
	05	55,212	31ms	49s103ms	1m5s	1m29s
	06	122,451	34ms	2m9s	2m42s	3m2s
	07	104,012	24ms	1m10s	1m57s	2m47s
	08	244,502	12ms	1m17s	1m59s	2m53s
	09	655,986	16ms	3m40s	4m21s	4m45s
	10	937,210	16ms	5m51s	7m	7m23s
	11	943,810	18ms	5m56s	7m33s	9m5s
	12	997,373	20ms	7m34s	8m4s	8m58s
	13	957,876	15ms	5m23s	6m6s	8m15s
	14	793,104	14ms	4m36s	5m14s	7m23s
	15	749,596	15ms	4m36s	4m55s	5m25s
	16	740,817	17ms	5m2s	5m55s	7m15s
	17	817,316	31ms	10m31s	11m52s	14m13s
	18	531,727	28ms	5m38s	7m50s	9m58s
	19	512,132	30ms	5m41s	7m5s	8m1s
	20	359,985	33ms	4m44s	5m54s	9m51s
	21	296,562	39ms	4m29s	4m55s	7m42s
	22	151,660	40ms	3m32s	4m36s	6m59s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 08	00	23,819	5,113	134	0	1s500ms	144ms	218ms	50s845ms
	01	25,172	5,969	154	0	478ms	163ms	206ms	489ms
	02	26,564	7,272	136	0	679ms	169ms	233ms	366ms
	03	20,585	6,277	137	0	4ms	130ms	176ms	321ms
	04	14,003	4,191	135	0	0ms	76ms	111ms	244ms
	05	5,056	2,025	138	0	0ms	37ms	53ms	80ms
	06	18,161	4,418	135	0	0ms	107ms	156ms	221ms
	07	7,354	3,337	212	0	0ms	54ms	82ms	133ms
	08	12,124	4,501	331	0	0ms	88ms	116ms	171ms
	09	48,692	14,358	668	0	520ms	262ms	312ms	500ms
	10	64,198	20,834	639	0	141ms	399ms	475ms	3s93ms
	11	76,972	22,605	841	0	73ms	446ms	525ms	709ms
	12	81,036	26,002	1,031	1	47ms	488ms	600ms	782ms
	13	64,684	24,358	581	0	192ms	377ms	471ms	9s266ms
	14	49,077	18,259	498	11	431ms	304ms	372ms	561ms
	15	57,413	21,507	672	2	28ms	301ms	398ms	701ms
	16	56,489	21,158	583	2	104ms	345ms	413ms	2s832ms
	17	74,579	26,844	782	0	32ms	609ms	926ms	46s550ms
	18	58,320	17,543	815	0	1ms	354ms	480ms	645ms
	19	60,225	17,181	547	1	138ms	386ms	452ms	622ms
	20	47,688	14,466	398	1	515ms	317ms	384ms	495ms
	21	46,038	13,086	248	0	216ms	263ms	362ms	471ms
	22	24,079	8,790	180	0	0ms	187ms	238ms	285ms

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

Day	Hour	Average / Second
Jan 08	00	0.00/s
	01	0.00/s
	02	0.00/s
	03	0.00/s
	04	0.00/s
	05	0.00/s
	06	0.00/s
	07	0.00/s
	08	0.00/s
	09	0.00/s
	10	0.00/s
	11	0.00/s
	12	0.00/s
	13	0.00/s
	14	0.00/s
	15	0.00/s
	16	0.00/s
	17	0.00/s
	18	0.00/s
	19	0.00/s
	20	0.00/s
	21	0.00/s
	22	0.00/s

Day	Hour	Average Duration	Average idle time
Jan 08	00	0ms	0ms
	01	0ms	0ms
	02	0ms	0ms
	03	0ms	0ms
	04	0ms	0ms
	05	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	09	0ms	0ms
	10	0ms	0ms
	11	0ms	0ms
	12	0ms	0ms
	13	0ms	0ms
	14	0ms	0ms
	15	0ms	0ms
	16	0ms	0ms
	17	0ms	0ms
	18	0ms	0ms
	19	0ms	0ms
	20	0ms	0ms
	21	0ms	0ms
	22	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

157,388 buffers Checkpoint Peak
2025-01-08 19:51:26 Date
270.051 seconds Highest write time
0.030 seconds Sync time

Checkpoints Wal files

Key values

108 files Wal files usage Peak
2025-01-08 19:51:26 Date

Checkpoints distance

Key values

3,441.35 Mo Distance Peak
2025-01-08 19:51:26 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 08	00	93,806	3,182.548s	0.028s	3,182.621s
	01	184,696	3,239.497s	0.04s	3,239.589s
	02	120,008	3,239.6s	0.032s	3,239.675s
	03	157,002	3,239.626s	0.034s	3,239.71s
	04	109,548	3,239.499s	0.03s	3,239.575s
	05	67,358	3,135.654s	0.027s	3,135.723s
	06	79,336	2,249.139s	0.04s	2,249.216s
	07	72,985	2,844.296s	0.03s	2,844.373s
	08	91,605	2,721.341s	0.038s	2,721.419s
	09	381,498	3,239.541s	0.041s	3,239.662s
	10	456,858	3,239.553s	0.049s	3,239.699s
	11	547,050	3,239.454s	0.056s	3,239.606s
	12	584,980	3,239.474s	0.058s	3,239.629s
	13	502,447	3,239.577s	0.043s	3,239.695s
	14	359,305	3,239.543s	0.044s	3,239.65s
	15	356,646	3,239.445s	0.059s	3,239.571s
	16	346,867	3,239.531s	0.053s	3,239.649s
	17	423,170	2,885.65s	0.091s	2,885.83s
	18	306,018	3,239.463s	0.074s	3,239.607s
	19	430,298	3,239.516s	0.053s	3,239.684s
	20	252,528	3,239.556s	0.053s	3,239.668s
	21	204,077	3,239.549s	0.042s	3,239.646s
	22	96,701	2,429.668s	0.03s	2,429.728s

Day	Hour	Removed	Recycled	Synced files	Longest sync	Average sync
Jan 08	00	0	42	2,825	0.002s	0.012s
	01	0	78	3,249	0.003s	0.012s
	02	0	57	2,821	0.002s	0.012s
	03	0	74	2,516	0.002s	0.012s
	04	0	52	2,249	0.002s	0.012s
	05	0	30	2,010	0.002s	0.013s
	06	0	37	2,496	0.012s	0.011s
	07	0	31	2,671	0.002s	0.013s
	08	0	36	3,242	0.009s	0.011s
	09	0	162	4,822	0.002s	0.012s
	10	0	199	5,244	0.003s	0.012s
	11	0	240	5,092	0.003s	0.012s
	12	0	261	5,294	0.003s	0.012s
	13	0	221	5,297	0.003s	0.012s
	14	0	151	5,485	0.002s	0.012s
	15	0	154	5,533	0.002s	0.012s
	16	0	145	5,686	0.003s	0.012s
	17	0	190	5,454	0.022s	0.012s
	18	0	137	5,257	0.002s	0.012s
	19	12	226	5,219	0.003s	0.012s
	20	0	101	4,901	0.015s	0.012s
	21	0	87	4,841	0.003s	0.012s
	22	0	40	3,336	0.002s	0.009s

Day	Hour	Avg time (sec)
Jan 08	00	0s
	01	0s
	02	0s
	03	0s
	04	0s
	05	0s
	06	0s
	07	0s
	08	0s
	09	0s
	10	0s
	11	0s
	12	0s
	13	0s
	14	0s
	15	0s
	16	0s
	17	0s
	18	0s
	19	0s
	20	0s
	21	0s
	22	0s

Day	Hour	Mean distance	Mean estimate
Jan 08	00	57,947.92 kB	89,479.25 kB
	01	106,366.33 kB	192,441.42 kB
	02	77,573.17 kB	133,181.33 kB
	03	101,215.58 kB	114,532.83 kB
	04	70,590.17 kB	106,951.83 kB
	05	38,370.54 kB	70,006.85 kB
	06	54,330.27 kB	79,591.55 kB
	07	39,703.77 kB	102,704.08 kB
	08	53,675.18 kB	81,801.64 kB
	09	220,803.42 kB	262,292.42 kB
	10	271,693.83 kB	309,295.42 kB
	11	338,356.18 kB	384,212.36 kB
	12	355,979.75 kB	386,622.50 kB
	13	302,142.42 kB	374,924.17 kB
	14	206,523.83 kB	277,321.58 kB
	15	209,103.33 kB	256,771.00 kB
	16	198,796.58 kB	267,203.58 kB
	17	254,805.91 kB	337,467.27 kB
	18	187,082.00 kB	298,008.83 kB
	19	324,024.42 kB	489,629.50 kB
	20	138,970.25 kB	932,542.42 kB
	21	117,923.73 kB	357,635.36 kB
	22	73,475.00 kB	170,840.44 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Jan 08	00	0	0	0
	01	0	0	0
	02	0	0	0
	03	0	0	0
	04	0	0	0
	05	0	0	0
	06	0	0	0
	07	0	0	0
	08	0	0	0
	09	0	0	0
	10	0	0	0
	11	0	0	0
	12	0	0	0
	13	0	0	0
	14	0	0	0
	15	0	0	0
	16	0	0	0
	17	0	0	0
	18	0	0	0
	19	0	0	0
	20	0	0	0
	21	0	0	0
	22	0	0	0

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date
0 sec Highest CPU-cost analyze
Table
Database
Date

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

unknown (0) Main table analyzed (database )
0 analyzes Total

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

unknown (0) Main table vacuumed on database
0 vacuums Total

Chart
Table

Vacuums per tables

		Index	Buffer usage			Skipped		WAL usage
Table	Vacuums	scans	hits	misses	dirtied	pins	frozen	records	full page	bytes
NO DATASET

Tuples removed per table

Key values

unknown (0) Main table with removed tuples on database
0 tuples Total removed

Chart
Table

Tuples removed per tables

		Index	Tuples			Pages
Table	Vacuums	scans	removed	remain	not yet removable	removed	remain
NO DATASET

Pages removed per table

Key values

unknown (0) Main table with removed pages on database unknown
0 pages Total removed

Chart
Table

Pages removed per tables

Table	Number of vacuums	Index scans	Tuples removed	Pages removed
NO DATASET

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 08	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

10,700,007 Total read queries
5,193,159 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,700,007	58.19%
INSERT	962,328	5.23%
UPDATE	310,094	1.69%
DELETE	9,995	0.05%
COPY FROM	18	0.00%
COPY TO	0	0.00%
CTE	21,489	0.12%
DDL	1,472	0.01%
TCL	3,887,763	21.14%
CURSOR	0	0.00%
OTHERS	2,495,811	13.57%

Queries by database

Key values

unknown Main database
18,388,977 Requests
5d18h38m24s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,388,977	5d18h38m24s
	copy from	18	31ms
	cte	21,489	4s692ms
	ddl	1,472	213ms
	delete	9,995	1s345ms
	insert	962,328	4m56s
	others	2,495,811	1m55s
	select	10,700,007	2d19h28m28s
	tcl	3,887,763	2m33s
	update	310,094	2d23h24s

Queries by user

Key values

unknown Main user
18,388,977 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,388,977	5d18h38m24s
	copy from	18	31ms
	cte	21,489	4s692ms
	ddl	1,472	213ms
	delete	9,995	1s345ms
	insert	962,328	4m56s
	others	2,495,811	1m55s
	select	10,700,007	2d19h28m28s
	tcl	3,887,763	2m33s
	update	310,094	2d23h24s

Duration by user

Key values

5d18h38m24s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,388,977	5d18h38m24s
	copy from	18	31ms
	cte	21,489	4s692ms
	ddl	1,472	213ms
	delete	9,995	1s345ms
	insert	962,328	4m56s
	others	2,495,811	1m55s
	select	10,700,007	2d19h28m28s
	tcl	3,887,763	2m33s
	update	310,094	2d23h24s

Queries by host

Key values

unknown Main host
18,388,977 Requests
5d18h38m24s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,388,977	5d18h38m24s
	copy from	18	31ms
	cte	21,489	4s692ms
	ddl	1,472	213ms
	delete	9,995	1s345ms
	insert	962,328	4m56s
	others	2,495,811	1m55s
	select	10,700,007	2d19h28m28s
	tcl	3,887,763	2m33s
	update	310,094	2d23h24s

Queries by application

Key values

unknown Main application
18,388,977 Requests
5d18h38m24s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,388,977	5d18h38m24s
	copy from	18	31ms
	cte	21,489	4s692ms
	ddl	1,472	213ms
	delete	9,995	1s345ms
	insert	962,328	4m56s
	others	2,495,811	1m55s
	select	10,700,007	2d19h28m28s
	tcl	3,887,763	2m33s
	update	310,094	2d23h24s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-08 14:11:28 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,173,954 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,173,954	93.39%
1-5ms	281,017	1.53%
5-10ms	13,798	0.08%
10-25ms	53,721	0.29%
25-50ms	169,941	0.92%
50-100ms	89,215	0.49%
100-500ms	410,816	2.23%
500-1000ms	193,268	1.05%
1000-10000ms	2,629	0.01%
> 10000ms	618	0.00%

Slowest individual queries

Rank	Duration	Query
1	55m58s	UPDATE "res_users" SET "exp_date" = '2025-01-07 23:37:21.808257', "last_update" = '2025-01-07 22:52:21.808293', "write_date" = '2025-01-07 22:52:21.478826', "write_uid" = 1 WHERE id IN (903); [ Date: 2025-01-08 00:48:20 ]
2	55m10s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:09.810157', exp_date = '2025-01-07 23:38:09.810160', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
3	55m9s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:10.898690', exp_date = '2025-01-07 23:38:10.898693', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
4	55m8s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:12.193133', exp_date = '2025-01-07 23:38:12.193137', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
5	54m59s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:21.363891', exp_date = '2025-01-07 23:38:21.363896', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
6	54m57s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:22.949656', exp_date = '2025-01-07 23:38:22.949661', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
7	41m8s	update res_users set sid = '4f1ab4e2e5a0cc6d5535b62113e428cd949e2a45', last_update = '2025-01-08 13:17:12.085481', exp_date = '2025-01-08 14:02:12.085484', logged_in = 'TRUE' where id = 906; [ Date: 2025-01-08 14:58:20 ]
8	41m8s	update res_users set sid = '4f1ab4e2e5a0cc6d5535b62113e428cd949e2a45', last_update = '2025-01-08 13:17:12.085407', exp_date = '2025-01-08 14:02:12.085409', logged_in = 'TRUE' where id = 906; [ Date: 2025-01-08 14:58:20 ]
9	38m36s	update res_users set sid = 'b807e348afe033bb2539de6e4050571ded5539c1', last_update = '2025-01-08 00:09:44.182336', exp_date = '2025-01-08 00:54:44.182338', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-08 01:48:21 ]
10	38m36s	update res_users set sid = 'b807e348afe033bb2539de6e4050571ded5539c1', last_update = '2025-01-08 00:09:44.182203', exp_date = '2025-01-08 00:54:44.182205', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-08 01:48:21 ]
11	38m3s	UPDATE "res_users" SET "exp_date" = '2025-01-08 08:55:16.834618', "last_update" = '2025-01-08 08:10:16.834640', "write_date" = '2025-01-08 08:10:16.476471', "write_uid" = 1 WHERE id IN (959); [ Date: 2025-01-08 09:48:20 ]
12	36m14s	update res_users set sid = 'b2157f1ad7aa7fa9d349d1e5ce6ed64f1b90ff98', last_update = '2025-01-08 08:12:05.876932', exp_date = '2025-01-08 08:57:05.876935', logged_in = 'TRUE' where id = 959; [ Date: 2025-01-08 09:48:20 ]
13	36m4s	update res_users set sid = 'b2157f1ad7aa7fa9d349d1e5ce6ed64f1b90ff98', last_update = '2025-01-08 08:12:15.684613', exp_date = '2025-01-08 08:57:15.684616', logged_in = 'TRUE' where id = 959; [ Date: 2025-01-08 09:48:20 ]
14	35m57s	update res_users set sid = 'b2157f1ad7aa7fa9d349d1e5ce6ed64f1b90ff98', last_update = '2025-01-08 08:12:22.958374', exp_date = '2025-01-08 08:57:22.958377', logged_in = 'TRUE' where id = 959; [ Date: 2025-01-08 09:48:20 ]
15	32m51s	update res_users set sid = '2ba28c41ed2b83d72a5e532fa4b56bf32868d2d5', last_update = '2025-01-08 13:25:29.262278', exp_date = '2025-01-08 14:10:29.262281', logged_in = 'TRUE' where id = 906; [ Date: 2025-01-08 14:58:20 ]
16	32m39s	update res_users set sid = '2ba28c41ed2b83d72a5e532fa4b56bf32868d2d5', last_update = '2025-01-08 13:25:40.657935', exp_date = '2025-01-08 14:10:40.657941', logged_in = 'TRUE' where id = 906; [ Date: 2025-01-08 14:58:20 ]
17	32m23s	update res_users set sid = 'b807e348afe033bb2539de6e4050571ded5539c1', last_update = '2025-01-08 00:15:57.960471', exp_date = '2025-01-08 01:00:57.960474', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-08 01:48:21 ]
18	31m45s	update res_users set sid = 'b807e348afe033bb2539de6e4050571ded5539c1', last_update = '2025-01-08 00:16:35.973779', exp_date = '2025-01-08 01:01:35.973782', logged_in = 'TRUE' where id = 933; [ Date: 2025-01-08 01:48:21 ]
19	30m57s	update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 23:17:23.424195', exp_date = '2025-01-08 00:02:23.424198', logged_in = 'TRUE' where id = 903; [ Date: 2025-01-08 00:48:20 ]
20	30m56s	update res_users set sid = 'aa9c1c8d918773544160ecb915fcd28af45e1d0e', last_update = '2025-01-08 19:23:23.600523', exp_date = '2025-01-08 20:08:23.600527', logged_in = 'TRUE' where id = 884; [ Date: 2025-01-08 20:54:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d20h3m15s

72,472

Details

0ms

55m10s

3s380ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 08	00	805	11h10m50s	50s
	01	858	4h9m37s	17s456ms
	02	964	6h24m28s	23s929ms
	03	1,184	1m51s	93ms
	04	712	150ms	0ms
	05	412	87ms	0ms
	06	617	134ms	0ms
	07	560	115ms	0ms
	08	1,440	304ms	0ms
	09	4,326	8h33m23s	7s120ms
	10	6,242	3h2m47s	1s757ms
	11	6,537	2h3m5s	1s129ms
	12	7,730	1h24m50s	658ms
	13	7,768	4h46m23s	2s212ms
	14	6,218	7h39m19s	4s432ms
	15	5,382	37m13s	414ms
	16	5,337	2h3m57s	1s393ms
	17	4,962	34m46s	420ms
	18	3,528	1m14s	21ms
	19	2,827	2h59m14s	3s804ms
	20	1,994	8h56m36s	16s146ms
	21	1,358	3h33m35s	9s437ms
	22	711	153ms	0ms

update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:09.810157', exp_date = '2025-01-07 23:38:09.810160', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m10s
update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:10.898690', exp_date = '2025-01-07 23:38:10.898693', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m9s
update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:12.193133', exp_date = '2025-01-07 23:38:12.193137', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m8s

2

1d10h11m56s

228,157

Details

445ms

4s11ms

539ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 08	00	5,795	49m18s	510ms
	01	7,903	1h6m40s	506ms
	02	8,267	1h9m46s	506ms
	03	10,365	1h25m48s	496ms
	04	5,808	47m5s	486ms
	05	2,713	21m42s	480ms
	06	4,970	41m39s	502ms
	07	2,839	22m46s	481ms
	08	3,325	26m55s	485ms
	09	11,594	1h37m	502ms
	10	15,600	2h19m19s	535ms
	11	17,392	2h37m37s	543ms
	12	18,759	2h54m58s	559ms
	13	11,951	1h46m6s	532ms
	14	10,503	1h31m9s	520ms
	15	9,247	1h20m11s	520ms
	16	10,301	1h30m19s	526ms
	17	21,072	3h36m25s	616ms
	18	13,774	2h11m7s	571ms
	19	13,533	2h7m44s	566ms
	20	9,491	1h28m39s	560ms
	21	8,649	1h20m31s	558ms
	22	4,306	39m2s	544ms

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

Date: 2025-01-08 17:39:26 Duration: 4s11ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310812)) AND (("shipping_track"."id" not in (35526792, 35526792)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:19 Duration: 3s588ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310832)) AND (("shipping_track"."id" not in (35527215, 35527215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:59 Duration: 3s361ms

3

7h29m9s

135,688

Details

146ms

1s495ms

198ms

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
Jan 08	00	881	2m26s	166ms
	01	1,756	4m53s	166ms
	02	2,372	6m36s	167ms
	03	2,851	7m58s	167ms
	04	2,545	7m2s	166ms
	05	995	2m44s	165ms
	06	1,820	5m3s	166ms
	07	2,364	6m33s	166ms
	08	1,883	5m11s	165ms
	09	4,825	13m41s	170ms
	10	9,512	29m3s	183ms
	11	8,208	25m30s	186ms
	12	9,416	29m57s	190ms
	13	9,263	27m57s	181ms
	14	6,128	18m7s	177ms
	15	7,822	22m48s	174ms
	16	10,434	31m12s	179ms
	17	19,789	1h14m29s	225ms
	18	3,256	12m32s	231ms
	19	4,000	15m11s	227ms
	20	8,582	35m25s	247ms
	21	8,664	33m1s	228ms
	22	8,322	31m38s	228ms

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

Date: 2025-01-08 17:38:17 Duration: 1s495ms
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" = '8640580')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 18:01:33 Duration: 500ms
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" = '9783066')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 17:39:24 Duration: 465ms

4

6h41m26s

43,544

Details

452ms

3s637ms

553ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 08	00	168	1m30s	537ms
	01	264	2m21s	534ms
	02	255	2m20s	551ms
	03	201	1m56s	580ms
	04	121	1m8s	566ms
	05	59	33s238ms	563ms
	06	203	1m48s	533ms
	07	501	4m7s	493ms
	08	1,064	8m45s	493ms
	09	3,277	28m2s	513ms
	10	3,005	27m44s	553ms
	11	4,306	40m10s	559ms
	12	5,197	49m36s	572ms
	13	3,588	32m49s	548ms
	14	2,917	25m39s	527ms
	15	3,130	27m23s	525ms
	16	2,971	26m22s	532ms
	17	3,521	37m24s	637ms
	18	3,349	31m57s	572ms
	19	2,325	21m35s	557ms
	20	1,666	15m8s	545ms
	21	892	8m3s	541ms
	22	564	4m58s	528ms

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

Date: 2025-01-08 17:37:26 Duration: 3s637ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4302247, 4299475, 4299466, 4295075, 4295030, 4292828, 4289461, 4286675, 4283955, 4282608, 4280864, 4279451, 4279389, 4277086, 4254157, 4252286, 4241610, 4239784, 4234411, 4176870)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:37:51 Duration: 3s430ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4134873)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:37:47 Duration: 3s19ms

5

3h33m28s

51,789

Details

99ms

843ms

247ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 08	00	3,478	14m31s	250ms
	01	3,060	12m11s	239ms
	02	3,396	12m52s	227ms
	03	900	3m56s	263ms
	04	392	1m39s	253ms
	05	10	2s120ms	212ms
	06	2,214	8m50s	239ms
	07	42	10s187ms	242ms
	08	16	4s189ms	261ms
	09	140	38s585ms	275ms
	10	308	1m10s	228ms
	11	84	24s717ms	294ms
	12	548	2m34s	281ms
	13	590	2m23s	243ms
	14	874	3m35s	246ms
	15	1,982	8m8s	246ms
	16	1,936	7m58s	247ms
	17	4,616	21m	273ms
	18	5,618	23m	245ms
	19	6,796	27m57s	246ms
	20	5,292	21m27s	243ms
	21	6,735	28m19s	252ms
	22	2,762	10m28s	227ms

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-01-08 19:26:32 Duration: 843ms
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-01-08 19:26:32 Duration: 839ms
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-01-08 19:49:35 Duration: 808ms

6

2h25m1s

9,361

Details

28ms

1s838ms

929ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 08	00	227	3m23s	898ms
	01	355	5m17s	894ms
	02	374	5m34s	894ms
	04	1	925ms	925ms
	09	2	1s896ms	948ms
	10	26	25s943ms	997ms
	11	1	245ms	245ms
	12	60	59s254ms	987ms
	13	226	3m24s	904ms
	14	322	5m8s	956ms
	15	237	3m44s	947ms
	16	368	5m48s	946ms
	17	782	13m38s	1s46ms
	18	1,490	22m51s	920ms
	19	1,741	26m47s	923ms
	20	1,135	16m50s	890ms
	21	1,544	23m43s	921ms
	22	470	7m20s	936ms

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

Date: 2025-01-08 17:37:49 Duration: 1s838ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9795266')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-08 17:37:25 Duration: 1s628ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9795290')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-08 17:37:00 Duration: 1s617ms

7

1h50m45s

142,823

Details

35ms

226ms

46ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2,792	2m1s	43ms
	01	2,551	1m51s	43ms
	02	3,108	2m16s	43ms
	03	1,868	1m23s	44ms
	04	2,068	1m30s	43ms
	05	680	30s95ms	44ms
	06	1,962	1m25s	43ms
	07	903	39s918ms	44ms
	08	1,969	1m26s	43ms
	09	9,138	6m51s	44ms
	10	11,107	8m46s	47ms
	11	14,307	11m27s	48ms
	12	15,270	12m33s	49ms
	13	9,839	7m45s	47ms
	14	9,119	6m59s	45ms
	15	7,957	6m3s	45ms
	16	8,641	6m40s	46ms
	17	9,070	7m47s	51ms
	18	7,268	5m28s	45ms
	19	9,356	7m3s	45ms
	20	6,273	4m40s	44ms
	21	4,754	3m28s	43ms
	22	2,823	2m2s	43ms

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

Date: 2025-01-08 10:36:01 Duration: 226ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4296109)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 10:36:01 Duration: 225ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4222504)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 17:37:38 Duration: 219ms

8

1h47m20s

25,638

Details

157ms

1s785ms

251ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 08	07	781	2m49s	217ms
	08	365	1m36s	264ms
	09	1,460	5m31s	226ms
	10	2,990	12m15s	246ms
	11	2,083	8m37s	248ms
	12	3,068	12m40s	248ms
	13	3,748	16m11s	259ms
	14	1,879	7m52s	251ms
	15	3,595	14m51s	247ms
	16	3,085	12m6s	235ms
	17	1,172	5m57s	304ms
	18	419	2m3s	294ms
	19	993	4m45s	287ms

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

Date: 2025-01-08 17:02:01 Duration: 1s785ms
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" = '9688168')))) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:37:24 Duration: 716ms
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" = '9473451')))) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:37:29 Duration: 638ms

9

1h41m

28

Details

0ms

55m58s

3m36s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1	55m58s	55m58s
	01	1	1ms	1ms
	08	2	2ms	1ms
	09	3	38m3s	12m41s
	10	1	0ms	0ms
	11	1	2ms	2ms
	12	5	2ms	0ms
	13	3	3ms	1ms
	14	3	4ms	1ms
	15	1	1ms	1ms
	16	2	2ms	1ms
	17	2	6m58s	3m29s
	18	2	0ms	0ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 23:37:21.808257', "last_update" = '2025-01-07 22:52:21.808293', "write_date" = '2025-01-07 22:52:21.478826', "write_uid" = 1 WHERE id IN (903);

Date: 2025-01-08 00:48:20 Duration: 55m58s
UPDATE "res_users" SET "exp_date" = '2025-01-08 08:55:16.834618', "last_update" = '2025-01-08 08:10:16.834640', "write_date" = '2025-01-08 08:10:16.476471', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-08 09:48:20 Duration: 38m3s
UPDATE "res_users" SET "exp_date" = '2025-01-08 16:42:22.288617', "last_update" = '2025-01-08 15:57:22.288649', "write_date" = '2025-01-08 15:57:21.782627', "write_uid" = 1 WHERE id IN (974);

Date: 2025-01-08 17:04:20 Duration: 6m58s

10

1h24m1s

16,897

Details

190ms

1s592ms

298ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1,539	6m49s	266ms
	01	1,203	5m23s	269ms
	02	1,357	6m12s	274ms
	03	463	2m4s	269ms
	04	202	55s21ms	272ms
	05	6	1s555ms	259ms
	06	1,123	4m55s	262ms
	07	27	6s879ms	254ms
	08	9	2s327ms	258ms
	09	77	19s672ms	255ms
	10	132	38s771ms	293ms
	11	42	12s96ms	288ms
	12	227	1m11s	314ms
	13	80	21s330ms	266ms
	14	120	31s301ms	260ms
	15	766	3m27s	270ms
	16	615	2m47s	272ms
	17	1,547	9m2s	350ms
	18	1,354	7m18s	324ms
	19	1,685	9m8s	325ms
	20	1,535	8m8s	317ms
	21	1,865	9m46s	314ms
	22	923	4m35s	298ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9787871')) 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-01-08 17:39:00 Duration: 1s592ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9816866')) 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-01-08 17:38:08 Duration: 1s453ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9673746')) 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-01-08 17:37:47 Duration: 565ms

11

1h2m29s

326

Details

0ms

15m33s

11s502ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2	4ms	2ms
	01	5	6ms	1ms
	02	1	1ms	1ms
	03	1	1ms	1ms
	04	1	1ms	1ms
	05	2	1ms	0ms
	06	3	1ms	0ms
	07	1	0ms	0ms
	08	9	4ms	0ms
	09	27	19ms	0ms
	10	38	9m21s	14s769ms
	11	26	26ms	1ms
	12	32	30ms	0ms
	13	31	56s167ms	1s811ms
	14	22	28m4s	1m16s
	15	24	19ms	0ms
	16	25	12m	28s800ms
	17	25	12m7s	29s104ms
	18	14	14ms	1ms
	19	14	10ms	0ms
	20	6	3ms	0ms
	21	13	11ms	0ms
	22	4	3ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-08 14:27:46.598949', "last_update" = '2025-01-08 13:42:46.598971', "sid" = '4eca1f5bd1c20b313a73b54e143c9ea59220cecb', "write_date" = '2025-01-08 13:42:46.272471', "write_uid" = 906 WHERE id IN (906);

Date: 2025-01-08 14:58:20 Duration: 15m33s
UPDATE "res_users" SET "exp_date" = '2025-01-08 14:36:01.004455', "last_update" = '2025-01-08 13:51:01.004478', "sid" = '4eca1f5bd1c20b313a73b54e143c9ea59220cecb', "write_date" = '2025-01-08 13:51:00.659627', "write_uid" = 906 WHERE id IN (906);

Date: 2025-01-08 14:58:20 Duration: 7m19s
UPDATE "res_users" SET "exp_date" = '2025-01-08 16:42:29.369897', "last_update" = '2025-01-08 15:57:29.369921', "sid" = '64731ef20f58a30a0a781503b46baa3a9cb453a8', "write_date" = '2025-01-08 15:57:29.041726', "write_uid" = 1 WHERE id IN (974);

Date: 2025-01-08 17:04:20 Duration: 6m51s

12

50m9s

58,286

Details

38ms

283ms

51ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 08	02	5	272ms	54ms
	06	3	155ms	51ms
	07	6	301ms	50ms
	08	752	35s982ms	47ms
	09	4,123	3m26s	50ms
	10	3,638	3m7s	51ms
	11	5,964	5m17s	53ms
	12	9,063	8m7s	53ms
	13	5,677	4m52s	51ms
	14	7,235	6m3s	50ms
	15	5,445	4m30s	49ms
	16	6,692	5m36s	50ms
	17	4,725	4m26s	56ms
	18	1,550	1m16s	49ms
	19	2,712	2m12s	48ms
	20	350	17s948ms	51ms
	21	261	12s705ms	48ms
	22	85	4s125ms	48ms

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

Date: 2025-01-08 17:37:55 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4188518) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:38:06 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4278748) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:02:02 Duration: 280ms

13

35m13s

11,731

Details

149ms

285ms

180ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 08	00	29	4s914ms	169ms
	03	31	5s246ms	169ms
	04	235	38s804ms	165ms
	05	81	13s516ms	166ms
	06	1,160	3m13s	166ms
	07	1,135	3m8s	166ms
	08	179	30s261ms	169ms
	09	922	2m39s	173ms
	10	1,110	3m18s	179ms
	11	1,699	5m11s	183ms
	12	1,626	5m12s	192ms
	13	1,071	3m10s	177ms
	14	394	1m6s	169ms
	15	521	1m30s	173ms
	16	680	1m59s	176ms
	17	37	7s663ms	207ms
	18	327	1m11s	217ms
	19	163	36s951ms	226ms
	20	70	14s989ms	214ms
	21	107	24s980ms	233ms
	22	154	32s952ms	213ms

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" = '9817420')) 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-01-08 21:09:30 Duration: 285ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9818375')) 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-01-08 19:52:56 Duration: 284ms
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" = '9661128')) 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-01-08 13:09:08 Duration: 279ms

14

32m11s

17,719

Details

87ms

673ms

109ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 08	01	16	1s651ms	103ms
	07	71	7s518ms	105ms
	08	199	20s838ms	104ms
	09	892	1m33s	104ms
	10	1,186	2m9s	109ms
	11	1,714	3m11s	111ms
	12	2,480	4m44s	114ms
	13	2,294	4m11s	109ms
	14	2,212	3m48s	103ms
	15	2,534	4m28s	105ms
	16	1,141	2m	105ms
	17	672	1m25s	126ms
	18	919	1m42s	111ms
	19	579	1m1s	105ms
	20	376	39s185ms	104ms
	21	253	25s347ms	100ms
	22	181	18s194ms	100ms

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

Date: 2025-01-08 17:36:12 Duration: 673ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7955781)) AND (("cash_track"."id" not in (6751962)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-08 17:38:06 Duration: 498ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7955778)) AND (("cash_track"."id" not in (6751959)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-08 17:38:00 Duration: 221ms

15

29m21s

10,535

Details

146ms

260ms

167ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 08	00	852	2m21s	166ms
	01	1,756	4m53s	167ms
	02	2,372	6m36s	167ms
	03	2,810	7m51s	167ms
	04	1,843	5m7s	166ms
	05	898	2m29s	165ms
	22	4	827ms	206ms

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

Date: 2025-01-08 22:39:15 Duration: 214ms

16

24m46s

5,962

Details

162ms

456ms

249ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 08	10	425	1m39s	233ms
	11	1,096	4m15s	232ms
	12	434	1m50s	253ms
	13	446	1m47s	240ms
	14	896	3m24s	228ms
	15	506	1m55s	227ms
	16	462	1m45s	229ms
	17	154	49s763ms	323ms
	18	48	14s725ms	306ms
	19	1,495	7m3s	283ms

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

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

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

Date: 2025-01-08 17:37:54 Duration: 437ms

17

24m18s

7,874

Details

149ms

421ms

185ms

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

Day	Hour	Count	Duration	Avg duration
Jan 08	06	632	1m46s	167ms
	07	37	6s229ms	168ms
	08	180	29s891ms	166ms
	09	295	50s442ms	170ms
	10	1,675	5m2s	180ms
	11	1,494	4m27s	179ms
	12	480	1m30s	188ms
	13	468	1m28s	189ms
	14	882	2m34s	175ms
	15	410	1m10s	172ms
	16	341	59s843ms	175ms
	17	158	41s191ms	260ms
	18	45	12s193ms	270ms
	19	777	2m57s	228ms

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

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

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

Date: 2025-01-08 17:37:57 Duration: 373ms

18

17m42s

22,964

Details

35ms

84ms

46ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 08	07	10	447ms	44ms
	08	315	13s862ms	44ms
	09	1,506	1m6s	44ms
	10	1,890	1m28s	46ms
	11	2,784	2m7s	45ms
	12	3,386	2m45s	48ms
	13	2,557	2m	47ms
	14	2,643	2m	45ms
	15	2,338	1m44s	44ms
	16	2,984	2m15s	45ms
	17	1,364	1m7s	49ms
	18	401	17s744ms	44ms
	19	786	34s462ms	43ms

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

Date: 2025-01-08 17:38:29 Duration: 84ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4219573) ORDER BY "collection_policy"."id";

Date: 2025-01-08 13:09:08 Duration: 82ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3800296) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:27:55 Duration: 81ms

19

14m50s

5,545

Details

121ms

789ms

160ms

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

Day	Hour	Count	Duration	Avg duration
Jan 08	00	25	3s629ms	145ms
	01	16	2s295ms	143ms
	08	68	9s919ms	145ms
	09	632	1m35s	150ms
	10	867	2m23s	165ms
	11	1,122	3m4s	164ms
	12	1,087	3m3s	168ms
	13	622	1m40s	160ms
	14	250	38s89ms	152ms
	15	177	26s855ms	151ms
	16	128	20s688ms	161ms
	17	179	30s838ms	172ms
	18	106	15s875ms	149ms
	19	65	9s134ms	140ms
	20	85	11s395ms	134ms
	21	66	9s108ms	138ms
	22	50	6s608ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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-01-08 18:01:46 Duration: 789ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 71)) 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-01-08 17:38:03 Duration: 702ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) 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-01-08 11:24:54 Duration: 312ms

20

12m32s

289

Details

0ms

4s919ms

2s603ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 08	07	18	53s356ms	2s964ms
	08	4	11s749ms	2s937ms
	09	19	17s851ms	939ms
	10	16	38s805ms	2s425ms
	11	13	10s881ms	837ms
	12	20	59s744ms	2s987ms
	13	16	19s528ms	1s220ms
	14	15	48s432ms	3s228ms
	15	32	1m24s	2s630ms
	16	34	1m40s	2s948ms
	17	44	2m18s	3s155ms
	18	14	51s243ms	3s660ms
	19	7	21s570ms	3s81ms
	20	15	31s801ms	2s120ms
	21	18	52s125ms	2s895ms
	22	4	11s966ms	2s991ms

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

Date: 2025-01-08 18:01:48 Duration: 4s919ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))) 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 (111)))))) 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 (111)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))))) 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 (111)))))))) AND ("policy_number"."name"::text ilike '%9577%')) ORDER BY "policy_number"."id" LIMIT 8;

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

Date: 2025-01-08 12:40:48 Duration: 4s415ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,494,867

Details

1m55s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 08	00	44,190	1s529ms	0ms
	01	45,692	1s612ms	0ms
	02	41,906	1s529ms	0ms
	03	40,643	1s564ms	0ms
	04	31,342	1s191ms	0ms
	05	23,624	800ms	0ms
	06	31,324	1s272ms	0ms
	07	31,998	1s200ms	0ms
	08	61,267	2s488ms	0ms
	09	146,974	6s751ms	0ms
	10	207,700	9s856ms	0ms
	11	217,430	11s25ms	0ms
	12	220,359	11s150ms	0ms
	13	219,593	10s90ms	0ms
	14	190,301	8s348ms	0ms
	15	184,964	8s658ms	0ms
	16	186,162	9s32ms	0ms
	17	164,570	8s55ms	0ms
	18	125,364	6s254ms	0ms
	19	105,032	4s934ms	0ms
	20	79,911	3s545ms	0ms
	21	58,767	2s743ms	0ms
	22	35,754	1s653ms	0ms

DISCARD ALL;

Date: 2025-01-08 19:14:33 Duration: 1ms
DISCARD ALL;

Date: 2025-01-08 16:07:14 Duration: 1ms
DISCARD ALL;

Date: 2025-01-08 16:36:21 Duration: 1ms

2

1,944,193

Details

26s825ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 08	00	31,761	413ms	0ms
	01	33,781	440ms	0ms
	02	30,797	403ms	0ms
	03	30,493	417ms	0ms
	04	22,457	319ms	0ms
	05	16,424	238ms	0ms
	06	24,107	353ms	0ms
	07	24,412	335ms	0ms
	08	47,756	640ms	0ms
	09	120,071	1s616ms	0ms
	10	169,257	2s344ms	0ms
	11	175,409	2s485ms	0ms
	12	177,248	2s499ms	0ms
	13	172,946	2s265ms	0ms
	14	145,086	1s851ms	0ms
	15	140,776	1s893ms	0ms
	16	143,872	1s983ms	0ms
	17	130,601	1s980ms	0ms
	18	96,980	1s395ms	0ms
	19	80,466	1s128ms	0ms
	20	60,466	820ms	0ms
	21	43,176	617ms	0ms
	22	25,851	381ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-08 16:37:53 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-08 12:36:35 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-08 17:03:43 Duration: 0ms

3

1,270,896

Details

12s228ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 08	00	22,838	197ms	0ms
	01	23,598	207ms	0ms
	02	21,530	197ms	0ms
	03	20,916	194ms	0ms
	04	16,266	142ms	0ms
	05	12,413	102ms	0ms
	06	16,350	150ms	0ms
	07	16,641	140ms	0ms
	08	31,452	269ms	0ms
	09	74,983	697ms	0ms
	10	105,482	1s38ms	0ms
	11	110,021	1s113ms	0ms
	12	111,898	1s151ms	0ms
	13	111,145	1s86ms	0ms
	14	96,375	878ms	0ms
	15	93,782	866ms	0ms
	16	94,551	872ms	0ms
	17	83,660	930ms	0ms
	18	63,708	623ms	0ms
	19	53,549	519ms	0ms
	20	41,001	383ms	0ms
	21	30,345	295ms	0ms
	22	18,392	167ms	0ms

ROLLBACK;

Date: 2025-01-08 12:23:13 Duration: 0ms
ROLLBACK;

Date: 2025-01-08 16:13:08 Duration: 0ms
ROLLBACK;

Date: 2025-01-08 12:04:19 Duration: 0ms

4

1,257,834

Details

3m23s

0ms

12ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 08	00	22,044	3s267ms	0ms
	01	22,941	3s573ms	0ms
	02	20,881	3s422ms	0ms
	03	20,280	3s299ms	0ms
	04	15,650	2s302ms	0ms
	05	11,771	1s525ms	0ms
	06	15,677	2s354ms	0ms
	07	15,977	2s163ms	0ms
	08	30,871	4s220ms	0ms
	09	74,509	11s704ms	0ms
	10	105,147	17s317ms	0ms
	11	109,959	18s720ms	0ms
	12	111,482	18s675ms	0ms
	13	110,855	18s56ms	0ms
	14	96,095	14s889ms	0ms
	15	93,171	14s430ms	0ms
	16	93,710	14s656ms	0ms
	17	82,874	15s165ms	0ms
	18	63,119	10s392ms	0ms
	19	52,875	8s816ms	0ms
	20	40,406	6s577ms	0ms
	21	29,593	5s233ms	0ms
	22	17,947	2s970ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'aa9c1c8d918773544160ecb915fcd28af45e1d0e';

Date: 2025-01-08 12:23:42 Duration: 12ms
SELECT payload FROM http_sessions WHERE sid = 'cc49eb3f557f939e45499705e853815c159ba4e2';

Date: 2025-01-08 10:44:56 Duration: 12ms
SELECT payload FROM http_sessions WHERE sid = '2c45fb06b37a6f32a9942f7a769b218ddfd57ed2';

Date: 2025-01-08 17:51:33 Duration: 8ms

5

1,247,614

Details

1m47s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 08	00	22,155	1s759ms	0ms
	01	22,904	1s807ms	0ms
	02	21,013	1s768ms	0ms
	03	20,401	1s759ms	0ms
	04	15,747	1s286ms	0ms
	05	11,881	910ms	0ms
	06	15,735	1s318ms	0ms
	07	16,080	1s242ms	0ms
	08	30,654	2s373ms	0ms
	09	73,398	6s40ms	0ms
	10	103,766	9s229ms	0ms
	11	108,701	9s766ms	0ms
	12	110,105	9s712ms	0ms
	13	109,753	9s676ms	0ms
	14	95,121	7s899ms	0ms
	15	92,452	7s798ms	0ms
	16	93,014	7s689ms	0ms
	17	82,244	8s34ms	0ms
	18	62,692	5s507ms	0ms
	19	52,492	4s557ms	0ms
	20	39,993	3s351ms	0ms
	21	29,398	2s683ms	0ms
	22	17,915	1s556ms	0ms

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

Date: 2025-01-08 13:49:46 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-08 17:21:59 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-08 12:32:51 Duration: 0ms

6

880,127

Details

2m9s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 08	00	12,686	1s623ms	0ms
	01	13,259	1s793ms	0ms
	02	11,068	1s605ms	0ms
	03	11,414	1s715ms	0ms
	04	6,901	1s171ms	0ms
	05	4,486	782ms	0ms
	06	9,604	1s529ms	0ms
	07	9,341	1s412ms	0ms
	08	23,094	3s31ms	0ms
	09	61,141	8s594ms	0ms
	10	84,738	12s38ms	0ms
	11	86,994	12s959ms	0ms
	12	86,098	12s975ms	0ms
	13	81,910	11s782ms	0ms
	14	64,598	9s865ms	0ms
	15	59,901	8s433ms	0ms
	16	65,020	9s585ms	0ms
	17	61,328	9s830ms	0ms
	18	43,273	6s382ms	0ms
	19	34,088	4s980ms	0ms
	20	24,402	3s391ms	0ms
	21	15,632	2s299ms	0ms
	22	9,151	1s426ms	0ms

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

Date: 2025-01-08 17:21:57 Duration: 10ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (886);

Date: 2025-01-08 17:21:57 Duration: 10ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (852);

Date: 2025-01-08 17:21:57 Duration: 10ms

7

672,604

Details

1m54s

0ms

38ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 08	00	8,898	1s476ms	0ms
	01	10,131	1s775ms	0ms
	02	9,254	1s701ms	0ms
	03	9,578	2s160ms	0ms
	04	6,190	1s280ms	0ms
	05	4,011	762ms	0ms
	06	7,758	1s357ms	0ms
	07	7,769	1s91ms	0ms
	08	16,302	2s337ms	0ms
	09	45,020	7s195ms	0ms
	10	63,709	9s660ms	0ms
	11	65,343	11s239ms	0ms
	12	65,336	12s132ms	0ms
	13	61,735	10s287ms	0ms
	14	48,614	7s809ms	0ms
	15	46,961	7s347ms	0ms
	16	49,265	7s776ms	0ms
	17	46,908	9s230ms	0ms
	18	33,277	6s9ms	0ms
	19	26,837	4s823ms	0ms
	20	19,439	3s269ms	0ms
	21	12,807	2s425ms	0ms
	22	7,462	1s347ms	0ms

COMMIT;

Date: 2025-01-08 11:09:27 Duration: 38ms
COMMIT;

Date: 2025-01-08 11:43:38 Duration: 36ms
COMMIT;

Date: 2025-01-08 16:34:22 Duration: 35ms

8

526,429

Details

1m9s

0ms

14ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 08	00	10,050	1s552ms	0ms
	01	8,449	1s640ms	0ms
	02	7,265	749ms	0ms
	03	6,036	728ms	0ms
	04	2,407	280ms	0ms
	05	1,675	238ms	0ms
	06	6,359	699ms	0ms
	07	4,225	510ms	0ms
	08	14,335	1s766ms	0ms
	09	38,564	4s669ms	0ms
	10	51,110	6s938ms	0ms
	11	53,663	7s830ms	0ms
	12	49,455	6s838ms	0ms
	13	45,008	6s16ms	0ms
	14	37,439	4s675ms	0ms
	15	31,828	3s844ms	0ms
	16	38,027	4s943ms	0ms
	17	37,558	5s659ms	0ms
	18	29,022	3s490ms	0ms
	19	21,788	2s492ms	0ms
	20	15,966	1s797ms	0ms
	21	10,480	1s69ms	0ms
	22	5,720	580ms	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 (5099356, 5099103, 5101122, 5099568, 5099636, 5100192, 5099128, 5100111, 5100477, 5102347, 5099523, 5141854, 5104711, 5101380, 5101901, 5099181, 5125624, 5099582, 5099014, 5099445, 5141951, 5099594, 5099458, 5099102, 5103853, 5099287, 5100883, 5105795, 5099867, 5099321, 5099224, 5099272, 5099430, 5131856, 5100714, 5099006, 5138699, 5099236, 5099251, 5100232, 5101424, 5115904, 5099677, 5141952, 5099577, 5099914, 5100677, 5139561, 5099254, 5099141, 5100901, 5141298, 5099187, 5100949, 5099540, 5099714, 5099420, 5099045, 5099727, 5099162, 5099609, 5108742, 5099192);

Date: 2025-01-08 13:25:11 Duration: 14ms
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 (5099872, 5099082, 5098996, 5099202, 5099456, 5130157, 5100384, 5099080, 5099092, 5101615, 5101345, 5100794, 5102909, 5099204, 5103909, 5099403, 5100514, 5102973, 5112127, 5102344, 5099248, 5101114, 5405160, 5136885, 5099329, 5099644, 5101219, 5365003, 5101865, 5099114, 5099186, 5103816, 5099141, 5102793, 5123579, 5102815, 5101079, 5099008, 5103379, 5099305, 5122971, 5099356, 5121551, 5099540, 5104282, 5100110, 5099821, 5100700, 5100420, 5099730, 5101297, 5148493, 5099128, 5141946, 5100554, 5100334, 5099240, 5099041, 5100181, 5101935, 5126396, 5108663, 5099420, 5099427, 5099550, 5198543, 5157862, 5103579, 5109066, 5200292, 5099521, 5099037, 5099415, 5099719, 5099216, 5099121, 5139592, 5105117, 5099119, 5100467, 5103431, 5121112, 5114343, 5233467, 5324217, 5101328, 5099246, 5099746, 5099287, 5099103, 5109915, 5122663, 5440692, 5111230, 5465122, 5104277, 5102390, 5111521, 5105141, 5099191, 5357648, 5464560, 5117660, 5101184, 5099236, 5099426, 5113265, 5100935, 5099045, 5100659);

Date: 2025-01-08 17:21:57 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 (5103279, 5105015, 5134271, 5099169, 5099724, 5099035, 5184098, 5167782, 5104497, 5099598, 5106861, 5100252, 5100059, 5101692, 5100450, 5257672, 5099111, 5099009, 5099568, 5099026, 5100124, 5099014, 5105993, 5099028, 5132293, 5099006, 5100832, 5099321, 5099010, 5099158, 5174966, 5101160, 5099102, 5099263, 5099296, 5099162, 5101304, 5099198, 5100074, 5100720, 5101815, 5099264, 5099244, 5103478, 5099013, 5099095, 5100883, 5099137, 5100421, 5099007, 5375294, 5099800, 5104864, 5100505, 5100352, 5116472, 5100881, 5099182, 5099515, 5101367, 5100800, 5100111, 5109207, 5101130, 5099243, 5373311, 5101169, 5099445, 5101531, 5101252, 5099727, 5099138, 5099430, 5101479, 5099130, 5101878, 5099272, 5101352, 5169825, 5100218, 5224050, 5468836, 5099181, 5099105, 5099228, 5352688, 5101193, 5103367, 5099590, 5099120, 5100714, 5105834, 5462630, 5100486, 5100212, 5099187, 5099333, 5100901, 5099046, 5264399, 5099921, 5113022, 5099348, 5099144, 5122228, 5464561, 5100148, 5099285, 5099500, 5099254, 5099815, 5099190);

Date: 2025-01-08 17:21:57 Duration: 7ms

9

524,701

Details

32s927ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 08	00	6,885	371ms	0ms
	01	6,063	344ms	0ms
	02	5,595	295ms	0ms
	03	4,810	261ms	0ms
	04	2,081	112ms	0ms
	05	1,512	79ms	0ms
	06	6,125	324ms	0ms
	07	5,103	253ms	0ms
	08	12,124	647ms	0ms
	09	36,298	2s53ms	0ms
	10	49,153	3s234ms	0ms
	11	52,779	3s456ms	0ms
	12	52,349	3s595ms	0ms
	13	47,457	3s100ms	0ms
	14	38,557	2s294ms	0ms
	15	35,412	2s65ms	0ms
	16	39,926	2s304ms	0ms
	17	37,919	2s997ms	0ms
	18	29,212	1s802ms	0ms
	19	22,387	1s365ms	0ms
	20	16,714	963ms	0ms
	21	10,857	666ms	0ms
	22	5,383	334ms	0ms

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

Date: 2025-01-08 11:15:46 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (5);

Date: 2025-01-08 15:15:39 Duration: 0ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (36, 39, 73, 19, 22, 27, 66);

Date: 2025-01-08 10:50:14 Duration: 0ms

10

373,078

Details

1m7s

0ms

13ms

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
Jan 08	00	5,057	784ms	0ms
	01	4,716	789ms	0ms
	02	3,325	631ms	0ms
	03	3,013	561ms	0ms
	04	1,597	298ms	0ms
	05	1,504	205ms	0ms
	06	3,485	601ms	0ms
	07	3,965	580ms	0ms
	08	11,869	1s655ms	0ms
	09	27,193	4s509ms	0ms
	10	36,913	6s889ms	0ms
	11	36,422	6s945ms	0ms
	12	36,111	6s998ms	0ms
	13	34,098	6s170ms	0ms
	14	28,319	4s914ms	0ms
	15	27,218	4s694ms	0ms
	16	28,356	4s918ms	0ms
	17	26,085	5s860ms	0ms
	18	18,846	3s426ms	0ms
	19	14,204	2s602ms	0ms
	20	10,489	1s839ms	0ms
	21	6,609	1s218ms	0ms
	22	3,684	630ms	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 (8007047);

Date: 2025-01-08 17:21:57 Duration: 13ms
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 (8006287);

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

Date: 2025-01-08 17:21:57 Duration: 12ms

11

336,026

Details

1m48s

0ms

2ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2,790	774ms	0ms
	01	3,489	1s1ms	0ms
	02	3,714	1s81ms	0ms
	03	1,632	525ms	0ms
	04	1,063	319ms	0ms
	05	583	168ms	0ms
	06	1,903	578ms	0ms
	07	1,914	552ms	0ms
	08	6,837	2s6ms	0ms
	09	19,002	5s772ms	0ms
	10	33,405	11s42ms	0ms
	11	28,743	9s661ms	0ms
	12	34,032	11s730ms	0ms
	13	36,533	11s873ms	0ms
	14	29,882	9s194ms	0ms
	15	26,399	8s400ms	0ms
	16	19,809	6s176ms	0ms
	17	31,558	11s556ms	0ms
	18	14,009	4s634ms	0ms
	19	16,513	4s981ms	0ms
	20	9,773	2s822ms	0ms
	21	8,888	2s601ms	0ms
	22	3,555	1s48ms	0ms

SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'daily.movement' 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 = 870) OR r.global) ORDER BY r.id;

Date: 2025-01-08 19:22:35 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'policy.number' 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 = 996) OR r.global) ORDER BY r.id;

Date: 2025-01-08 18:42:43 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.country.state' 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 = 988) OR r.global) ORDER BY r.id;

Date: 2025-01-08 11:23:47 Duration: 2ms

12

244,150

Details

42s922ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2,196	318ms	0ms
	01	3,192	450ms	0ms
	02	3,263	460ms	0ms
	03	1,796	237ms	0ms
	04	1,419	180ms	0ms
	05	1,092	137ms	0ms
	06	1,562	217ms	0ms
	07	2,055	277ms	0ms
	08	7,047	1s27ms	0ms
	09	15,002	2s411ms	0ms
	10	23,724	4s355ms	0ms
	11	19,729	3s654ms	0ms
	12	23,591	4s655ms	0ms
	13	25,380	4s592ms	0ms
	14	20,710	3s545ms	0ms
	15	17,833	3s100ms	0ms
	16	14,245	2s355ms	0ms
	17	22,147	4s668ms	0ms
	18	8,945	1s567ms	0ms
	19	12,529	2s104ms	0ms
	20	7,275	1s120ms	0ms
	21	6,488	1s46ms	0ms
	22	2,930	432ms	0ms

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

Date: 2025-01-08 02:35:52 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-01-08 12:41:30 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-08 17:38:45 Duration: 1ms

13

240,483

Details

58s583ms

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

Day	Hour	Count	Duration	Avg duration
Jan 08	00	4,596	1s317ms	0ms
	01	4,031	1s467ms	0ms
	02	3,735	925ms	0ms
	03	2,427	651ms	0ms
	04	980	274ms	0ms
	05	601	208ms	0ms
	06	3,120	771ms	0ms
	07	1,801	445ms	0ms
	08	5,737	1s361ms	0ms
	09	15,504	3s839ms	0ms
	10	20,677	5s348ms	0ms
	11	22,139	6s38ms	0ms
	12	22,034	5s455ms	0ms
	13	20,778	4s814ms	0ms
	14	17,475	3s772ms	0ms
	15	16,836	3s404ms	0ms
	16	17,533	3s974ms	0ms
	17	17,156	4s902ms	0ms
	18	14,253	3s105ms	0ms
	19	11,128	2s519ms	0ms
	20	8,153	1s858ms	0ms
	21	6,641	1s440ms	0ms
	22	3,148	683ms	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 (41762144, 41762153, 41920294, 41802867, 41570574, 41920301, 41762142, 41869753, 41815318, 41761408, 41762162, 41762995, 41815529, 41762992, 41869852, 41869932, 41762174, 41762996, 41920319, 41815476, 41570542, 41763047, 41761807, 41699809, 41570513, 41869851, 41870013, 41569977, 41597077, 41661265, 41761810, 41762158, 41870045, 41659168, 41570573, 41659167, 41440507, 41659170, 41372990, 41660186, 41763046, 41815224, 41762165, 41659161, 41762884, 41870007, 41763043, 41869779, 41869931, 41657091, 41657888, 41659169, 41815478, 41699820, 41570577, 41869754, 41815530, 41920293, 41762163, 41762157, 41814994, 41763157, 41815371, 41762993, 41597087, 41870012, 41762994, 41597086, 41868407, 41597079, 41657633, 41868504, 41570576, 41814828, 41868068, 41570585, 41868414, 41760940, 41597085, 41815425, 41868069, 41760554, 41814983, 41597080, 41815206, 41657622, 41814732, 41762147, 41569989, 41762143, 41762150, 41570588, 41814835, 41815203, 41761675, 41570586, 41814982, 41569958, 41814831, 41657634, 41570575, 41762642, 41814735, 41814737, 41814901, 41814730, 41570597, 41282699, 41815205, 41815149, 41761679, 41760939, 41814729, 41867756, 41570578, 41956304, 41814728, 41815204, 41700481, 41759673, 41597076, 41570545, 41570580, 41814734, 41814731, 41814738, 41570184, 41814739, 41868308, 41570560, 41814733, 41761292, 41570598, 41814660, 41761208, 41570561, 41569649, 41326929, 41570565, 41760432, 41569478, 41570567, 41761607, 41761145, 41868618, 41760396, 41868309, 41760279, 41597069, 41570179, 41597072, 41656141, 41759705, 41760284, 41657154, 41760280, 41760355, 41760285, 41570344, 41597067, 41570160, 41597071, 41737443, 41656400, 41441096, 41283391, 41657311, 41374068, 41759671, 41169698, 41441097, 41701919, 41658070, 41567028, 41441809, 41371088, 41568472, 41568208, 41568471, 41135108, 41440349, 41441075, 41439309, 41371982, 41438954, 41439103, 41439122, 41372144, 41371087, 41371261, 41017612, 40949244, 40913952, 40913228);

Date: 2025-01-08 18:21:57 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 (41923691, 41870749, 32652681, 41719487, 41923358, 41922647, 41919281, 41983177, 42014057, 41667884, 41985851, 41712861, 41951574, 42063648, 41901042, 42010143, 41832532, 41736627, 41934510, 41809513, 41905793, 32660811, 41995691, 41652133, 41932530, 41971450, 41945020, 41773509, 42068100, 41972683, 41773556, 41773009, 41800197, 41977149, 41951577, 41923371, 41854207, 41809853, 41947252, 41674248, 42064048, 42004489);

Date: 2025-01-08 17:21:58 Duration: 10ms
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 (42046667, 42046669, 42046668, 42046665, 42046666, 41999248, 41999276, 41999277, 41999275, 41999247, 41999246, 41999271, 41999244, 41999272, 41999266, 41590340, 41590338, 41907459, 41590341, 41999255, 41999268, 41943809, 41335087, 41999269, 41999257, 41943810, 41999267, 41590339, 41999270, 41943811, 41590337, 41999256, 41999274, 41999273, 41998550, 40761433, 41786774, 41786772, 41786773, 40761432, 40761431, 40761426, 42046940, 42046938, 42046937, 42046936, 42046935, 42046934, 42046933, 42046931, 42046930, 42046929, 42046928, 42046927, 40761428, 40761427, 42046941, 40761423, 40761424, 40761425, 40761430, 40761429, 41944720, 42021842, 42021843, 42021845, 42021848, 42021849, 42021852, 42021853, 42021829, 42021830, 42021831, 42021832, 42021833, 41621253, 42021834, 41621252, 42021835, 41891819, 42021836, 41891821, 42021837, 41891822, 42021838, 41891826, 42021839, 41891825, 42021840, 41694372, 41891827, 42049106, 42021841, 42049103, 41891774, 42049105, 42049095, 41891775, 41910629, 41891820);

Date: 2025-01-08 17:21:57 Duration: 9ms

14

228,157

Details

1d10h11m56s

445ms

4s11ms

539ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 08	00	5,795	49m18s	510ms
	01	7,903	1h6m40s	506ms
	02	8,267	1h9m46s	506ms
	03	10,365	1h25m48s	496ms
	04	5,808	47m5s	486ms
	05	2,713	21m42s	480ms
	06	4,970	41m39s	502ms
	07	2,839	22m46s	481ms
	08	3,325	26m55s	485ms
	09	11,594	1h37m	502ms
	10	15,600	2h19m19s	535ms
	11	17,392	2h37m37s	543ms
	12	18,759	2h54m58s	559ms
	13	11,951	1h46m6s	532ms
	14	10,503	1h31m9s	520ms
	15	9,247	1h20m11s	520ms
	16	10,301	1h30m19s	526ms
	17	21,072	3h36m25s	616ms
	18	13,774	2h11m7s	571ms
	19	13,533	2h7m44s	566ms
	20	9,491	1h28m39s	560ms
	21	8,649	1h20m31s	558ms
	22	4,306	39m2s	544ms

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

Date: 2025-01-08 17:39:26 Duration: 4s11ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310812)) AND (("shipping_track"."id" not in (35526792, 35526792)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:19 Duration: 3s588ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310832)) AND (("shipping_track"."id" not in (35527215, 35527215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:59 Duration: 3s361ms

15

182,296

Details

13s284ms

0ms

15ms

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
Jan 08	00	2,818	403ms	0ms
	01	2,427	368ms	0ms
	02	1,977	290ms	0ms
	03	1,963	305ms	0ms
	04	781	101ms	0ms
	05	588	29ms	0ms
	06	1,925	97ms	0ms
	07	1,539	74ms	0ms
	08	5,193	271ms	0ms
	09	13,778	751ms	0ms
	10	18,424	1s241ms	0ms
	11	19,365	1s372ms	0ms
	12	17,990	1s328ms	0ms
	13	16,458	1s175ms	0ms
	14	13,689	923ms	0ms
	15	11,430	764ms	0ms
	16	13,665	889ms	0ms
	17	12,765	1s29ms	0ms
	18	9,818	703ms	0ms
	19	6,643	482ms	0ms
	20	4,779	345ms	0ms
	21	2,747	212ms	0ms
	22	1,534	120ms	0ms

SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

Date: 2025-01-08 10:18:51 Duration: 15ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

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

Date: 2025-01-08 13:08:21 Duration: 0ms

16

149,542

Details

1m28s

0ms

45ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1,375	1s960ms	1ms
	01	1,025	2s102ms	2ms
	02	315	168ms	0ms
	03	207	125ms	0ms
	04	133	87ms	0ms
	05	71	43ms	0ms
	06	513	207ms	0ms
	07	1,330	505ms	0ms
	08	3,549	2s441ms	0ms
	09	6,780	4s184ms	0ms
	10	10,488	6s691ms	0ms
	11	12,043	8s663ms	0ms
	12	12,904	8s102ms	0ms
	13	13,338	8s553ms	0ms
	14	10,393	5s846ms	0ms
	15	10,184	5s137ms	0ms
	16	11,857	6s835ms	0ms
	17	24,113	12s821ms	0ms
	18	8,118	4s509ms	0ms
	19	4,492	2s439ms	0ms
	20	6,360	3s87ms	0ms
	21	5,337	2s456ms	0ms
	22	4,617	1s935ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4135965, 4161507, 4196682, 4300242, 4308209, 4270588, 4197468, 4275056, 4232993, 4265921, 4238848, 4277338, 4261101, 4138620, 4235628, 4190626, 4253292, 4157624, 4168761, 4251700, 4253885, 4262880, 4263279, 4198236, 4262223, 4276988, 4233403, 4162198, 4242044, 4215152, 4264372, 4195939, 4235000, 4260783, 4234646, 4272749, 4244085, 4260742, 4220329, 4219204, 4266464, 4272326, 4267086, 4265692, 4234859, 4202977, 4208321, 4278105, 4245650, 4224067, 4275990, 4257191, 4242651, 4251097, 4232928, 4272662, 4269871, 4238869, 4276970, 4228821, 4224060, 4262649, 4204185, 4265831, 4262371, 4256443, 4261334, 4260044, 4260878, 4250839, 4044526, 4237974, 4241905, 4265761, 4270541, 4190598, 4251786, 4218970, 4271556, 4197734, 4262747, 4123606, 4243913, 4253299, 4219798, 4261945, 4277373, 4266643, 3986658, 4270593, 4271798, 4049020, 4218313, 4262980, 4226630, 4277368, 4255130, 4262775, 4251068, 4261091, 4253198, 4272415, 4257280, 4133890, 4268846, 4272991, 4260809, 4256489, 4256645, 4208699, 4122573, 4287944, 4272694, 4261314, 4245232, 4278298, 4230335, 4267103, 4277354, 4281332, 3983900, 3983901, 4022249, 4059764, 4070382, 4088285, 4104504, 4124168, 4127085, 4127100, 4132418, 4137564, 4139910, 4148601, 4148759, 4149554, 4150662, 4151624, 4154600, 4156679, 4156698, 4157803, 4158452, 4158776, 4158939, 4159078, 4163965, 4164804, 4172446, 4277341, 4268517, 4258654, 4265821, 4154758, 4262227, 4260441, 4260727, 4260840, 4259091, 4260089, 4277347, 4206768, 4255015, 4239234, 4248418, 4223516, 4263348, 4255180, 4264685, 4142070, 4194555, 4238856, 4246919, 4230587, 4202232, 4266905, 4086240, 4266296, 4251194, 4264268, 4277394, 4261948, 4264601, 4249757, 4269874);

Date: 2025-01-08 17:21:57 Duration: 45ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4199192, 4266230, 4162397, 4244925, 4214801, 4088917, 4260931, 4269890, 4275926, 4265847, 4216059, 3357727, 4251347, 4276972, 4250355, 4244887, 4278111, 4272666, 4217166, 4266292, 4223516, 4199139, 4252127, 4206139, 4031853, 4207107, 4227486, 4252201, 4250332, 4258593, 4164007, 4245657, 4214906, 4260507, 3470367, 4219538, 4207703, 4239203, 4204195, 4203396, 3721335, 4239060, 4207711, 4223344, 4234955, 4215026, 4231929, 4231999, 4202184, 4156064, 4170448, 4194860, 4200098, 4191813, 4226155, 4183607, 4229447, 4233522, 4184071, 4184050, 4199197, 4092736, 4199159, 4224852, 4224851, 4199167, 4199149, 4199141, 4199150, 4199187, 4199198, 4118793, 4207100, 4224741, 4204648, 4239934, 4102733, 4231911, 4207310, 4269876, 4242771, 4247943, 4242284, 4217714, 4228220, 4199406, 4228244, 4247804, 4199975, 4226680, 4212681, 4156275, 4164934, 4233569, 4199160, 4150874, 4150876, 4199201, 4199165, 4199162, 4199172, 4199183, 4199180, 4203720, 4200073, 4167935, 4186236, 3933437, 4202679, 4181869, 4192792, 4203729, 4212411, 4115949, 3483843, 4219565, 4202555, 4211828, 4212049, 4195938, 4136585, 4209453, 4207102, 4208940, 4193997, 4199163, 4202482, 4216077, 4197726, 4199147, 4219523, 4168697, 4201421, 3743086, 4231917, 4199152, 4199189, 4199184, 4199643, 4218385, 4196619, 4125839, 4121097, 4158919, 4219545, 4152132, 3520948, 4212227, 4214303, 4206497, 3427866, 4209811, 4114604, 4191807, 4222375, 4172160, 4142388, 4156069, 4191346, 4156095, 4169945, 4190649, 4163362, 4182221, 4123831, 4149420, 4182410, 4190953, 4198152, 4124747, 4207731, 4198394, 4194807, 4157065, 4185274, 4172171, 4172146, 4138202, 3997850, 4184899, 4190643, 3442640, 4214218, 4031937, 4180626, 4212752, 4198207, 4177028, 3872490, 4062363, 4067505, 4128601, 4183156, 4022013, 4139691, 4186217);

Date: 2025-01-08 17:21:59 Duration: 25ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4018162, 4018289, 4018294, 4018285, 4018282, 4018287, 3797889, 4070939, 3967566, 3866740, 3898236, 4065122, 3927237, 4108562, 3716976, 4163197, 4163045, 4113397, 4023817, 4122566, 4083689, 4107213, 4073097, 4107206, 3837020, 4110534, 4048532, 4091010, 3837019, 4069904, 3719058, 3932160, 4105664, 3890606, 2968308, 3660956, 4007899, 4169966, 3878815, 3807824, 3807821, 4083335, 4083325, 4083336, 4083327, 4083330, 4083332, 4083337, 4083328, 4083326, 4155659, 3456612, 4072764, 4108483, 3350282, 4133935, 4025011, 4010950, 4110600, 4110572, 4110568, 3854050, 3967675, 3619170, 4003548, 3985725, 4118549, 3925067, 3925068, 3925070, 3927234, 4027887, 3558256, 3729716, 3978374, 3780818, 3762262, 3998199, 4131476, 3762261, 4138200, 3779723, 3779721, 3978371, 4027888, 3542559, 3698094, 3777374, 4083719, 3562122, 4078377, 4078373, 3779718, 3980804, 3486727, 3486732, 4162799, 3981307, 4026529, 3777372, 4017437, 4026528, 4153797, 4102076, 4118736, 3971814, 3992025, 4034813, 4034751, 4144209, 4136097, 4144976, 4144927, 1738392, 4027904, 4025987, 4163017, 4121610, 4138512, 4087435, 4113320, 4113309, 4087439, 4087436, 3903265, 3874873, 3903275, 3874870, 4129693, 4091901, 3596995, 4088866, 4086744, 3866827, 3870200, 3967414, 3935311, 4043925, 3764943, 3143904, 4018264, 3803566, 4061585, 3844013, 3551185, 4001570, 3722911, 4054895, 4117017, 4075344, 4011585, 3837711, 4013169, 4013050, 4013054, 4013056, 4024635, 4016506, 4108650, 3895872, 4016486, 4075351, 4096333, 4038860, 4096338, 3941831, 4118550, 3669686, 4079710, 4069933, 3637689, 4069938, 4016583, 4069929, 4070895, 3933625, 4074814, 4102099, 4083642, 4021230, 4031860, 4139369, 3437901, 3599421, 4031870, 3765261, 3282667, 3370454, 4031878, 4098723, 3370456, 4031862, 3144094, 3144093, 3144091, 4031854, 4123844, 4123833, 4123840, 4043964, 4155979, 4112967, 4155951, 4155957, 4164148, 4123843, 4112962, 3987469, 4117606, 4116493, 4001075, 4117231, 4023344, 3958705, 3900009, 4127081, 3900006, 3958703, 3244091, 4144882, 3854700, 4118156, 4144281, 4044110, 4044106, 4046967, 3866879, 3448753, 4013535, 3866860, 3715299, 3523358, 3715304, 3967462, 3967467, 3967458, 3838563, 3967450, 4013526, 3838538, 3487960, 3745322, 4152553, 4127584, 4073169, 3344927, 3797913, 3933687, 3933684, 3933686, 4013569, 3866891, 3933696, 3933689, 4098614, 4052734, 4110527, 2968312, 3805498, 3805490, 3805494, 4007826, 4007820, 4007806, 3535135, 4011077, 3992761, 2992826, 4144237, 4144236, 3146154, 4118132, 4144235, 4105694, 4110023, 3849031, 3903367, 3914321, 4110021, 4110029, 3903355, 3903364, 3903381, 4054905, 3973297, 3914322, 3914329, 4110018, 4110027, 4054906, 3903351, 3914333, 4091046, 4054898, 3903357, 3914323, 4054903, 4054894, 3903379, 3903362, 3973299, 4091043, 3914325, 3849068, 3914309, 4054784, 3977479, 4035506, 4054897, 3977472, 3903384, 3914335, 3903369, 3903353, 4110025, 4011073, 3967665, 4011068, 4061883, 3837008, 4081325, 4130339, 4106089, 3856446, 3990107, 3880522, 4144981, 4120513, 3835346, 4013572, 3799079, 4011035, 3837026, 4010941, 4090990, 3932169, 4049656, 4049660, 4011002, 3878823, 3603617, 4061882, 4080866, 4047419, 3967401, 4026408, 3661527, 3432726, 3778638, 3943699, 4037482, 3909605, 3695901, 3497653, 4049647, 4049634, 4038879, 3934968, 4038877, 3722021, 3934970, 4049629, 4049644, 4049651, 3615882, 4038878, 4049624, 3528066, 3855187, 3989899, 4073141, 4073159, 4073151, 4112920, 2695812, 3485028, 4094432, 4123797, 4123798, 3971255, 4104138, 3792044, 4069892, 3938450, 4038870, 4036829, 3815776, 4069887, 3752703, 4138515, 3929592, 4045117, 4095729, 4128437, 3898226, 3989826, 3873164, 3989712, 3875353, 3924557, 3938447, 4021521, 3935361, 4036095, 4023435, 3874946, 4123760, 3181620, 3971534, 4021209, 4128575, 4128592, 3960530, 3882496, 3633781, 4037528, 4122614, 3882472, 3882492, 3882470, 3882500, 3882489, 3882569, 4114354, 4114355, 4114353, 4083650, 3957197, 3777397, 3286378, 3882570, 4114357, 4114356, 3948867, 4026786, 3912781, 3912782, 4072771, 4127581, 4091389, 4144973, 4155874, 4112922, 4043967, 4072799, 4072800, 4092325, 3485017, 3691799, 4122511, 4011438, 4112987, 4070439, 4045166, 4011084, 4098690, 4070903, 4098689, 3971646, 3941024, 3941028, 3941033, 4045203, 3925064, 4021314, 3714971, 3744885, 4021299, 3935390, 4021318, 3805581, 3714976, 3805578, 3714982, 3971893, 3935398, 3971888, 4021309, 3905538, 3579864, 3865469, 4156146, 4112858, 4043993, 3744872, 3456845, 4126701, 4013543, 4013549, 4013552, 4013545, 3838567, 4073119, 4122598, 4073109, 4073124, 4073117, 4065112, 4134166);

Date: 2025-01-08 01:24:22 Duration: 18ms

17

142,823

Details

1h50m45s

35ms

226ms

46ms

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
Jan 08	00	2,792	2m1s	43ms
	01	2,551	1m51s	43ms
	02	3,108	2m16s	43ms
	03	1,868	1m23s	44ms
	04	2,068	1m30s	43ms
	05	680	30s95ms	44ms
	06	1,962	1m25s	43ms
	07	903	39s918ms	44ms
	08	1,969	1m26s	43ms
	09	9,138	6m51s	44ms
	10	11,107	8m46s	47ms
	11	14,307	11m27s	48ms
	12	15,270	12m33s	49ms
	13	9,839	7m45s	47ms
	14	9,119	6m59s	45ms
	15	7,957	6m3s	45ms
	16	8,641	6m40s	46ms
	17	9,070	7m47s	51ms
	18	7,268	5m28s	45ms
	19	9,356	7m3s	45ms
	20	6,273	4m40s	44ms
	21	4,754	3m28s	43ms
	22	2,823	2m2s	43ms

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

Date: 2025-01-08 10:36:01 Duration: 226ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4296109)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 10:36:01 Duration: 225ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4222504)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 17:37:38 Duration: 219ms

18

141,385

Details

8s319ms

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

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1,213	60ms	0ms
	01	1,493	72ms	0ms
	02	1,515	76ms	0ms
	03	623	32ms	0ms
	04	442	22ms	0ms
	05	279	13ms	0ms
	06	775	40ms	0ms
	07	810	41ms	0ms
	08	2,800	142ms	0ms
	09	7,979	438ms	0ms
	10	13,949	851ms	0ms
	11	11,784	730ms	0ms
	12	14,253	920ms	0ms
	13	15,254	909ms	0ms
	14	12,626	701ms	0ms
	15	11,206	638ms	0ms
	16	8,332	461ms	0ms
	17	13,264	917ms	0ms
	18	5,762	339ms	0ms
	19	7,160	395ms	0ms
	20	4,274	219ms	0ms
	21	4,039	212ms	0ms
	22	1,553	80ms	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 (99);

Date: 2025-01-08 12:57:50 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (89);

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

Date: 2025-01-08 11:35:14 Duration: 0ms

19

137,185

Details

17s124ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1,202	122ms	0ms
	01	1,477	150ms	0ms
	02	1,500	157ms	0ms
	03	616	66ms	0ms
	04	437	45ms	0ms
	05	262	26ms	0ms
	06	764	83ms	0ms
	07	804	86ms	0ms
	08	2,737	295ms	0ms
	09	7,866	906ms	0ms
	10	13,579	1s771ms	0ms
	11	11,452	1s498ms	0ms
	12	13,933	1s925ms	0ms
	13	14,528	1s829ms	0ms
	14	12,263	1s430ms	0ms
	15	10,927	1s311ms	0ms
	16	8,026	935ms	0ms
	17	12,855	1s939ms	0ms
	18	5,602	708ms	0ms
	19	6,826	795ms	0ms
	20	4,092	438ms	0ms
	21	3,940	436ms	0ms
	22	1,497	162ms	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 (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-08 19:09:08 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 (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-08 12:50:48 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (13) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-08 10:15:31 Duration: 0ms

20

135,688

Details

7h29m9s

146ms

1s495ms

198ms

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

Day	Hour	Count	Duration	Avg duration
Jan 08	00	881	2m26s	166ms
	01	1,756	4m53s	166ms
	02	2,372	6m36s	167ms
	03	2,851	7m58s	167ms
	04	2,545	7m2s	166ms
	05	995	2m44s	165ms
	06	1,820	5m3s	166ms
	07	2,364	6m33s	166ms
	08	1,883	5m11s	165ms
	09	4,825	13m41s	170ms
	10	9,512	29m3s	183ms
	11	8,208	25m30s	186ms
	12	9,416	29m57s	190ms
	13	9,263	27m57s	181ms
	14	6,128	18m7s	177ms
	15	7,822	22m48s	174ms
	16	10,434	31m12s	179ms
	17	19,789	1h14m29s	225ms
	18	3,256	12m32s	231ms
	19	4,000	15m11s	227ms
	20	8,582	35m25s	247ms
	21	8,664	33m1s	228ms
	22	8,322	31m38s	228ms

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

Date: 2025-01-08 17:38:17 Duration: 1s495ms
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" = '8640580')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 18:01:33 Duration: 500ms
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" = '9783066')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 17:39:24 Duration: 465ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

55m58s

3m36s

28

Details

1h41m

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1	55m58s	55m58s
	01	1	1ms	1ms
	08	2	2ms	1ms
	09	3	38m3s	12m41s
	10	1	0ms	0ms
	11	1	2ms	2ms
	12	5	2ms	0ms
	13	3	3ms	1ms
	14	3	4ms	1ms
	15	1	1ms	1ms
	16	2	2ms	1ms
	17	2	6m58s	3m29s
	18	2	0ms	0ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-07 23:37:21.808257', "last_update" = '2025-01-07 22:52:21.808293', "write_date" = '2025-01-07 22:52:21.478826', "write_uid" = 1 WHERE id IN (903);

Date: 2025-01-08 00:48:20 Duration: 55m58s
UPDATE "res_users" SET "exp_date" = '2025-01-08 08:55:16.834618', "last_update" = '2025-01-08 08:10:16.834640', "write_date" = '2025-01-08 08:10:16.476471', "write_uid" = 1 WHERE id IN (959);

Date: 2025-01-08 09:48:20 Duration: 38m3s
UPDATE "res_users" SET "exp_date" = '2025-01-08 16:42:22.288617', "last_update" = '2025-01-08 15:57:22.288649', "write_date" = '2025-01-08 15:57:21.782627', "write_uid" = 1 WHERE id IN (974);

Date: 2025-01-08 17:04:20 Duration: 6m58s

2

0ms

15m33s

11s502ms

326

Details

1h2m29s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2	4ms	2ms
	01	5	6ms	1ms
	02	1	1ms	1ms
	03	1	1ms	1ms
	04	1	1ms	1ms
	05	2	1ms	0ms
	06	3	1ms	0ms
	07	1	0ms	0ms
	08	9	4ms	0ms
	09	27	19ms	0ms
	10	38	9m21s	14s769ms
	11	26	26ms	1ms
	12	32	30ms	0ms
	13	31	56s167ms	1s811ms
	14	22	28m4s	1m16s
	15	24	19ms	0ms
	16	25	12m	28s800ms
	17	25	12m7s	29s104ms
	18	14	14ms	1ms
	19	14	10ms	0ms
	20	6	3ms	0ms
	21	13	11ms	0ms
	22	4	3ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-08 14:27:46.598949', "last_update" = '2025-01-08 13:42:46.598971', "sid" = '4eca1f5bd1c20b313a73b54e143c9ea59220cecb', "write_date" = '2025-01-08 13:42:46.272471', "write_uid" = 906 WHERE id IN (906);

Date: 2025-01-08 14:58:20 Duration: 15m33s
UPDATE "res_users" SET "exp_date" = '2025-01-08 14:36:01.004455', "last_update" = '2025-01-08 13:51:01.004478', "sid" = '4eca1f5bd1c20b313a73b54e143c9ea59220cecb', "write_date" = '2025-01-08 13:51:00.659627', "write_uid" = 906 WHERE id IN (906);

Date: 2025-01-08 14:58:20 Duration: 7m19s
UPDATE "res_users" SET "exp_date" = '2025-01-08 16:42:29.369897', "last_update" = '2025-01-08 15:57:29.369921', "sid" = '64731ef20f58a30a0a781503b46baa3a9cb453a8', "write_date" = '2025-01-08 15:57:29.041726', "write_uid" = 1 WHERE id IN (974);

Date: 2025-01-08 17:04:20 Duration: 6m51s

3

0ms

55m10s

3s380ms

72,472

Details

2d20h3m15s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 08	00	805	11h10m50s	50s
	01	858	4h9m37s	17s456ms
	02	964	6h24m28s	23s929ms
	03	1,184	1m51s	93ms
	04	712	150ms	0ms
	05	412	87ms	0ms
	06	617	134ms	0ms
	07	560	115ms	0ms
	08	1,440	304ms	0ms
	09	4,326	8h33m23s	7s120ms
	10	6,242	3h2m47s	1s757ms
	11	6,537	2h3m5s	1s129ms
	12	7,730	1h24m50s	658ms
	13	7,768	4h46m23s	2s212ms
	14	6,218	7h39m19s	4s432ms
	15	5,382	37m13s	414ms
	16	5,337	2h3m57s	1s393ms
	17	4,962	34m46s	420ms
	18	3,528	1m14s	21ms
	19	2,827	2h59m14s	3s804ms
	20	1,994	8h56m36s	16s146ms
	21	1,358	3h33m35s	9s437ms
	22	711	153ms	0ms

update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:09.810157', exp_date = '2025-01-07 23:38:09.810160', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m10s
update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:10.898690', exp_date = '2025-01-07 23:38:10.898693', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m9s
update res_users set sid = 'b713723253eeb5a07484c5d193dcfeeaf2505f0a', last_update = '2025-01-07 22:53:12.193133', exp_date = '2025-01-07 23:38:12.193137', logged_in = 'TRUE' where id = 903;

Date: 2025-01-08 00:48:20 Duration: 55m8s

4

0ms

4s919ms

2s603ms

289

Details

12m32s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 08	07	18	53s356ms	2s964ms
	08	4	11s749ms	2s937ms
	09	19	17s851ms	939ms
	10	16	38s805ms	2s425ms
	11	13	10s881ms	837ms
	12	20	59s744ms	2s987ms
	13	16	19s528ms	1s220ms
	14	15	48s432ms	3s228ms
	15	32	1m24s	2s630ms
	16	34	1m40s	2s948ms
	17	44	2m18s	3s155ms
	18	14	51s243ms	3s660ms
	19	7	21s570ms	3s81ms
	20	15	31s801ms	2s120ms
	21	18	52s125ms	2s895ms
	22	4	11s966ms	2s991ms

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

Date: 2025-01-08 18:01:48 Duration: 4s919ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))) 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 (111)))))) 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 (111)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))))) 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 (111)))))))) AND ("policy_number"."name"::text ilike '%9577%')) ORDER BY "policy_number"."id" LIMIT 8;

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

Date: 2025-01-08 12:40:48 Duration: 4s415ms

5

28ms

1s838ms

929ms

9,361

Details

2h25m1s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 08	00	227	3m23s	898ms
	01	355	5m17s	894ms
	02	374	5m34s	894ms
	04	1	925ms	925ms
	09	2	1s896ms	948ms
	10	26	25s943ms	997ms
	11	1	245ms	245ms
	12	60	59s254ms	987ms
	13	226	3m24s	904ms
	14	322	5m8s	956ms
	15	237	3m44s	947ms
	16	368	5m48s	946ms
	17	782	13m38s	1s46ms
	18	1,490	22m51s	920ms
	19	1,741	26m47s	923ms
	20	1,135	16m50s	890ms
	21	1,544	23m43s	921ms
	22	470	7m20s	936ms

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

Date: 2025-01-08 17:37:49 Duration: 1s838ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9795266')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-08 17:37:25 Duration: 1s628ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9795290')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-08 17:37:00 Duration: 1s617ms

6

452ms

3s637ms

553ms

43,544

Details

6h41m26s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 08	00	168	1m30s	537ms
	01	264	2m21s	534ms
	02	255	2m20s	551ms
	03	201	1m56s	580ms
	04	121	1m8s	566ms
	05	59	33s238ms	563ms
	06	203	1m48s	533ms
	07	501	4m7s	493ms
	08	1,064	8m45s	493ms
	09	3,277	28m2s	513ms
	10	3,005	27m44s	553ms
	11	4,306	40m10s	559ms
	12	5,197	49m36s	572ms
	13	3,588	32m49s	548ms
	14	2,917	25m39s	527ms
	15	3,130	27m23s	525ms
	16	2,971	26m22s	532ms
	17	3,521	37m24s	637ms
	18	3,349	31m57s	572ms
	19	2,325	21m35s	557ms
	20	1,666	15m8s	545ms
	21	892	8m3s	541ms
	22	564	4m58s	528ms

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

Date: 2025-01-08 17:37:26 Duration: 3s637ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4302247, 4299475, 4299466, 4295075, 4295030, 4292828, 4289461, 4286675, 4283955, 4282608, 4280864, 4279451, 4279389, 4277086, 4254157, 4252286, 4241610, 4239784, 4234411, 4176870)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:37:51 Duration: 3s430ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4134873)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:37:47 Duration: 3s19ms

7

445ms

4s11ms

539ms

228,157

Details

1d10h11m56s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 08	00	5,795	49m18s	510ms
	01	7,903	1h6m40s	506ms
	02	8,267	1h9m46s	506ms
	03	10,365	1h25m48s	496ms
	04	5,808	47m5s	486ms
	05	2,713	21m42s	480ms
	06	4,970	41m39s	502ms
	07	2,839	22m46s	481ms
	08	3,325	26m55s	485ms
	09	11,594	1h37m	502ms
	10	15,600	2h19m19s	535ms
	11	17,392	2h37m37s	543ms
	12	18,759	2h54m58s	559ms
	13	11,951	1h46m6s	532ms
	14	10,503	1h31m9s	520ms
	15	9,247	1h20m11s	520ms
	16	10,301	1h30m19s	526ms
	17	21,072	3h36m25s	616ms
	18	13,774	2h11m7s	571ms
	19	13,533	2h7m44s	566ms
	20	9,491	1h28m39s	560ms
	21	8,649	1h20m31s	558ms
	22	4,306	39m2s	544ms

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

Date: 2025-01-08 17:39:26 Duration: 4s11ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310812)) AND (("shipping_track"."id" not in (35526792, 35526792)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:19 Duration: 3s588ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4310832)) AND (("shipping_track"."id" not in (35527215, 35527215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-08 17:38:59 Duration: 3s361ms

8

190ms

1s592ms

298ms

16,897

Details

1h24m1s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 08	00	1,539	6m49s	266ms
	01	1,203	5m23s	269ms
	02	1,357	6m12s	274ms
	03	463	2m4s	269ms
	04	202	55s21ms	272ms
	05	6	1s555ms	259ms
	06	1,123	4m55s	262ms
	07	27	6s879ms	254ms
	08	9	2s327ms	258ms
	09	77	19s672ms	255ms
	10	132	38s771ms	293ms
	11	42	12s96ms	288ms
	12	227	1m11s	314ms
	13	80	21s330ms	266ms
	14	120	31s301ms	260ms
	15	766	3m27s	270ms
	16	615	2m47s	272ms
	17	1,547	9m2s	350ms
	18	1,354	7m18s	324ms
	19	1,685	9m8s	325ms
	20	1,535	8m8s	317ms
	21	1,865	9m46s	314ms
	22	923	4m35s	298ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9787871')) 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-01-08 17:39:00 Duration: 1s592ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9816866')) 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-01-08 17:38:08 Duration: 1s453ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9673746')) 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-01-08 17:37:47 Duration: 565ms

9

157ms

1s785ms

251ms

25,638

Details

1h47m20s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 08	07	781	2m49s	217ms
	08	365	1m36s	264ms
	09	1,460	5m31s	226ms
	10	2,990	12m15s	246ms
	11	2,083	8m37s	248ms
	12	3,068	12m40s	248ms
	13	3,748	16m11s	259ms
	14	1,879	7m52s	251ms
	15	3,595	14m51s	247ms
	16	3,085	12m6s	235ms
	17	1,172	5m57s	304ms
	18	419	2m3s	294ms
	19	993	4m45s	287ms

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

Date: 2025-01-08 17:02:01 Duration: 1s785ms
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" = '9688168')))) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:37:24 Duration: 716ms
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" = '9473451')))) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:37:29 Duration: 638ms

10

162ms

456ms

249ms

5,962

Details

24m46s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 08	10	425	1m39s	233ms
	11	1,096	4m15s	232ms
	12	434	1m50s	253ms
	13	446	1m47s	240ms
	14	896	3m24s	228ms
	15	506	1m55s	227ms
	16	462	1m45s	229ms
	17	154	49s763ms	323ms
	18	48	14s725ms	306ms
	19	1,495	7m3s	283ms

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

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

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

Date: 2025-01-08 17:37:54 Duration: 437ms

11

99ms

843ms

247ms

51,789

Details

3h33m28s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 08	00	3,478	14m31s	250ms
	01	3,060	12m11s	239ms
	02	3,396	12m52s	227ms
	03	900	3m56s	263ms
	04	392	1m39s	253ms
	05	10	2s120ms	212ms
	06	2,214	8m50s	239ms
	07	42	10s187ms	242ms
	08	16	4s189ms	261ms
	09	140	38s585ms	275ms
	10	308	1m10s	228ms
	11	84	24s717ms	294ms
	12	548	2m34s	281ms
	13	590	2m23s	243ms
	14	874	3m35s	246ms
	15	1,982	8m8s	246ms
	16	1,936	7m58s	247ms
	17	4,616	21m	273ms
	18	5,618	23m	245ms
	19	6,796	27m57s	246ms
	20	5,292	21m27s	243ms
	21	6,735	28m19s	252ms
	22	2,762	10m28s	227ms

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-01-08 19:26:32 Duration: 843ms
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-01-08 19:26:32 Duration: 839ms
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-01-08 19:49:35 Duration: 808ms

12

146ms

1s495ms

198ms

135,688

Details

7h29m9s

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
Jan 08	00	881	2m26s	166ms
	01	1,756	4m53s	166ms
	02	2,372	6m36s	167ms
	03	2,851	7m58s	167ms
	04	2,545	7m2s	166ms
	05	995	2m44s	165ms
	06	1,820	5m3s	166ms
	07	2,364	6m33s	166ms
	08	1,883	5m11s	165ms
	09	4,825	13m41s	170ms
	10	9,512	29m3s	183ms
	11	8,208	25m30s	186ms
	12	9,416	29m57s	190ms
	13	9,263	27m57s	181ms
	14	6,128	18m7s	177ms
	15	7,822	22m48s	174ms
	16	10,434	31m12s	179ms
	17	19,789	1h14m29s	225ms
	18	3,256	12m32s	231ms
	19	4,000	15m11s	227ms
	20	8,582	35m25s	247ms
	21	8,664	33m1s	228ms
	22	8,322	31m38s	228ms

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

Date: 2025-01-08 17:38:17 Duration: 1s495ms
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" = '8640580')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 18:01:33 Duration: 500ms
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" = '9783066')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-08 17:39:24 Duration: 465ms

13

149ms

421ms

185ms

7,874

Details

24m18s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 08	06	632	1m46s	167ms
	07	37	6s229ms	168ms
	08	180	29s891ms	166ms
	09	295	50s442ms	170ms
	10	1,675	5m2s	180ms
	11	1,494	4m27s	179ms
	12	480	1m30s	188ms
	13	468	1m28s	189ms
	14	882	2m34s	175ms
	15	410	1m10s	172ms
	16	341	59s843ms	175ms
	17	158	41s191ms	260ms
	18	45	12s193ms	270ms
	19	777	2m57s	228ms

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

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

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

Date: 2025-01-08 17:37:57 Duration: 373ms

14

149ms

285ms

180ms

11,731

Details

35m13s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 08	00	29	4s914ms	169ms
	03	31	5s246ms	169ms
	04	235	38s804ms	165ms
	05	81	13s516ms	166ms
	06	1,160	3m13s	166ms
	07	1,135	3m8s	166ms
	08	179	30s261ms	169ms
	09	922	2m39s	173ms
	10	1,110	3m18s	179ms
	11	1,699	5m11s	183ms
	12	1,626	5m12s	192ms
	13	1,071	3m10s	177ms
	14	394	1m6s	169ms
	15	521	1m30s	173ms
	16	680	1m59s	176ms
	17	37	7s663ms	207ms
	18	327	1m11s	217ms
	19	163	36s951ms	226ms
	20	70	14s989ms	214ms
	21	107	24s980ms	233ms
	22	154	32s952ms	213ms

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" = '9817420')) 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-01-08 21:09:30 Duration: 285ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9818375')) 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-01-08 19:52:56 Duration: 284ms
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" = '9661128')) 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-01-08 13:09:08 Duration: 279ms

15

146ms

260ms

167ms

10,535

Details

29m21s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 08	00	852	2m21s	166ms
	01	1,756	4m53s	167ms
	02	2,372	6m36s	167ms
	03	2,810	7m51s	167ms
	04	1,843	5m7s	166ms
	05	898	2m29s	165ms
	22	4	827ms	206ms

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

Date: 2025-01-08 22:39:15 Duration: 214ms

16

121ms

789ms

160ms

5,545

Details

14m50s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 08	00	25	3s629ms	145ms
	01	16	2s295ms	143ms
	08	68	9s919ms	145ms
	09	632	1m35s	150ms
	10	867	2m23s	165ms
	11	1,122	3m4s	164ms
	12	1,087	3m3s	168ms
	13	622	1m40s	160ms
	14	250	38s89ms	152ms
	15	177	26s855ms	151ms
	16	128	20s688ms	161ms
	17	179	30s838ms	172ms
	18	106	15s875ms	149ms
	19	65	9s134ms	140ms
	20	85	11s395ms	134ms
	21	66	9s108ms	138ms
	22	50	6s608ms	132ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) 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-01-08 18:01:46 Duration: 789ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 71)) 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-01-08 17:38:03 Duration: 702ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) 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-01-08 11:24:54 Duration: 312ms

17

87ms

673ms

109ms

17,719

Details

32m11s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 08	01	16	1s651ms	103ms
	07	71	7s518ms	105ms
	08	199	20s838ms	104ms
	09	892	1m33s	104ms
	10	1,186	2m9s	109ms
	11	1,714	3m11s	111ms
	12	2,480	4m44s	114ms
	13	2,294	4m11s	109ms
	14	2,212	3m48s	103ms
	15	2,534	4m28s	105ms
	16	1,141	2m	105ms
	17	672	1m25s	126ms
	18	919	1m42s	111ms
	19	579	1m1s	105ms
	20	376	39s185ms	104ms
	21	253	25s347ms	100ms
	22	181	18s194ms	100ms

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

Date: 2025-01-08 17:36:12 Duration: 673ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7955781)) AND (("cash_track"."id" not in (6751962)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-08 17:38:06 Duration: 498ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7955778)) AND (("cash_track"."id" not in (6751959)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-08 17:38:00 Duration: 221ms

18

38ms

283ms

51ms

58,286

Details

50m9s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 08	02	5	272ms	54ms
	06	3	155ms	51ms
	07	6	301ms	50ms
	08	752	35s982ms	47ms
	09	4,123	3m26s	50ms
	10	3,638	3m7s	51ms
	11	5,964	5m17s	53ms
	12	9,063	8m7s	53ms
	13	5,677	4m52s	51ms
	14	7,235	6m3s	50ms
	15	5,445	4m30s	49ms
	16	6,692	5m36s	50ms
	17	4,725	4m26s	56ms
	18	1,550	1m16s	49ms
	19	2,712	2m12s	48ms
	20	350	17s948ms	51ms
	21	261	12s705ms	48ms
	22	85	4s125ms	48ms

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

Date: 2025-01-08 17:37:55 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4188518) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:38:06 Duration: 283ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4278748) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:02:02 Duration: 280ms

19

35ms

226ms

46ms

142,823

Details

1h50m45s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 08	00	2,792	2m1s	43ms
	01	2,551	1m51s	43ms
	02	3,108	2m16s	43ms
	03	1,868	1m23s	44ms
	04	2,068	1m30s	43ms
	05	680	30s95ms	44ms
	06	1,962	1m25s	43ms
	07	903	39s918ms	44ms
	08	1,969	1m26s	43ms
	09	9,138	6m51s	44ms
	10	11,107	8m46s	47ms
	11	14,307	11m27s	48ms
	12	15,270	12m33s	49ms
	13	9,839	7m45s	47ms
	14	9,119	6m59s	45ms
	15	7,957	6m3s	45ms
	16	8,641	6m40s	46ms
	17	9,070	7m47s	51ms
	18	7,268	5m28s	45ms
	19	9,356	7m3s	45ms
	20	6,273	4m40s	44ms
	21	4,754	3m28s	43ms
	22	2,823	2m2s	43ms

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

Date: 2025-01-08 10:36:01 Duration: 226ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4296109)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 10:36:01 Duration: 225ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4222504)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-08 17:37:38 Duration: 219ms

20

35ms

84ms

46ms

22,964

Details

17m42s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 08	07	10	447ms	44ms
	08	315	13s862ms	44ms
	09	1,506	1m6s	44ms
	10	1,890	1m28s	46ms
	11	2,784	2m7s	45ms
	12	3,386	2m45s	48ms
	13	2,557	2m	47ms
	14	2,643	2m	45ms
	15	2,338	1m44s	44ms
	16	2,984	2m15s	45ms
	17	1,364	1m7s	49ms
	18	401	17s744ms	44ms
	19	786	34s462ms	43ms

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

Date: 2025-01-08 17:38:29 Duration: 84ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4219573) ORDER BY "collection_policy"."id";

Date: 2025-01-08 13:09:08 Duration: 82ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3800296) ORDER BY "collection_policy"."id";

Date: 2025-01-08 17:27:55 Duration: 81ms

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,439,132 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	17,520	0.10%
ERROR	6,495	0.04%
EVENTLOG	759	0.00%
FATAL	18,250	0.10%
HINT	4	0.00%
LOG	18,389,568	99.73%
STATEMENT	6,526	0.04%

Events distribution (except queries)

Key values

0 PANIC entries
18250 FATAL entries
6495 ERROR entries
0 WARNING entries
759 EVENTLOG entries

Most Frequent Errors/Events

Key values

17,504 Max number of times the same event was reported
25,504 Total events found

Rank

Times reported

Error

1

17,504

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 08	00	2,379
	01	2,253
	02	2,598
	03	108
	10	1,713
	11	2,527
	12	2,352
	13	2,088
	14	1,483
	16	3

FATAL: password authentication failed for user "postgres"

2

3,383

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 08	00	12
	01	13
	02	8
	03	10
	04	11
	05	6
	06	6
	07	19
	08	26
	09	110
	10	249
	11	203
	12	472
	13	428
	14	254
	15	227
	16	484
	17	403
	18	69
	19	149
	20	118
	21	78
	22	28

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

3

3,078

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 08	00	12
	01	12
	02	8
	03	6
	04	10
	05	5
	06	4
	07	19
	08	26
	09	102
	10	235
	11	196
	12	436
	13	391
	14	238
	15	211
	16	420
	17	354
	18	54
	19	125
	20	112
	21	75
	22	27

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

4

555

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 08	00	29
	01	31
	02	23
	09	57
	10	47
	11	29
	12	23
	13	58
	14	44
	15	29
	16	51
	17	28
	19	53
	20	30
	21	23

FATAL: connection to client lost

5

555

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 08	00	29
	01	31
	02	23
	09	57
	10	47
	11	29
	12	23
	13	58
	14	44
	15	29
	16	51
	17	28
	19	53
	20	30
	21	23

LOG: could not send data to client: Broken pipe

6

138

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 08	00	4
	01	1
	02	9
	09	7
	10	20
	11	3
	12	9
	13	7
	14	25
	15	3
	16	20
	17	8
	19	11
	20	2
	21	9

7

127

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 08	17	127

FATAL: terminating connection due to administrator command

8

65

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 08	00	3
	02	6
	09	3
	10	12
	11	1
	12	5
	13	3
	14	11
	16	6
	17	2
	19	6
	21	7

9

28

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 08	17	28

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

10

16

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 08	17	16

11

12

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 08	09	2
	10	1
	11	2
	12	2
	13	1
	14	3
	16	1

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

12

9

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 08	10	8
	13	1

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

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
Jan 08	08	1
	09	3
	14	1
	19	1

14

6

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 08	17	6

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

15

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 08	08	1
	09	1
	14	1
	19	1

16

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 08	08	1
	14	1
	15	1
	19	1

17

4

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 08	10	1
	16	1
	17	2

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

18

3

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 08	04	1
	11	2

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

19

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 08	11	2

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 08	10	1

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 08	17	1

22

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 08	17	1

23

1

Details

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

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 08	09	1

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Jan 08	05	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