pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sun Feb 2 23:47:20 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 40,198,972 log entries in 2m19s
Log start from 2025-02-02 00:00:00 to 2025-02-02 22:45:01

Global Stats

14,487 Number of unique normalized queries
17,234,282 Number of queries
6d12h54m Total query duration
2025-02-02 00:00:00 First query
2025-02-02 22:45:01 Last query
5,983 queries/s at 2025-02-02 12:50:12 Query peak

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

5,020 Number of events
20 Number of unique normalized events
1,838 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
17,234,282 Average queries per session
6d12h54m 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

5,983 queries/s Query Peak
2025-02-02 12:50:12 Date

SELECT Traffic

Key values

3,899 queries/s Query Peak
2025-02-02 12:50:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,410 queries/s Query Peak
2025-02-02 12:50:12 Date

Queries duration

Key values

6d12h54m 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)
Feb 02	00	290,261	0ms	1m26s	24ms	3m55s	4m59s	6m10s
	01	257,409	0ms	930ms	25ms	3m31s	4m6s	4m36s
	02	241,957	0ms	1s11ms	26ms	3m45s	4m8s	4m33s
	03	263,856	0ms	1m55s	28ms	3m38s	3m54s	6m9s
	04	229,927	0ms	35s567ms	27ms	3m7s	3m17s	3m56s
	05	163,346	0ms	4s357ms	27ms	2m27s	2m45s	4m18s
	06	166,610	0ms	745ms	20ms	2m5s	2m26s	2m55s
	07	151,109	0ms	712ms	12ms	1m8s	1m18s	1m40s
	08	475,897	0ms	4m10s	19ms	2m44s	4m19s	1h11m45s
	09	1,074,473	0ms	10m57s	21ms	5m52s	6m40s	2h45m55s
	10	1,577,355	0ms	13m57s	37ms	17m26s	2h13m	2h58m3s
	11	1,735,599	0ms	19m48s	32ms	16m18s	1h17m48s	3h37m32s
	12	1,677,403	0ms	24m5s	26ms	11m52s	55m42s	2h39m19s
	13	1,419,914	0ms	40m12s	40ms	10m50s	12m2s	7h59s
	14	1,257,489	0ms	9m3s	19ms	8m20s	11m1s	2h3m39s
	15	1,129,779	0ms	1m26s	12ms	5m55s	6m50s	7m36s
	16	1,187,332	0ms	40m26s	56ms	5m55s	3h26m5s	6h21m29s
	17	1,026,954	0ms	30m44s	42ms	5m24s	6m31s	8h50m18s
	18	776,552	0ms	3s641ms	19ms	7m5s	7m55s	9m6s
	19	842,758	0ms	39m2s	60ms	12m5s	15m8s	6h29m22s
	20	640,461	0ms	31m15s	67ms	7m32s	8m29s	7h41m54s
	21	366,522	0ms	2s991ms	17ms	3m9s	3m45s	4m57s
	22	281,319	0ms	2s926ms	23ms	3m54s	4m18s	5m37s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 02	00	155,414	44ms	2m51s	3m54s	4m59s
	01	135,049	48ms	2m51s	3m31s	4m12s
	02	121,138	52ms	2m51s	3m44s	4m10s
	03	137,703	53ms	2m47s	3m34s	4m1s
	04	118,884	52ms	2m37s	3m7s	3m30s
	05	85,086	53ms	1m58s	2m27s	3m24s
	06	88,567	37ms	1m35s	2m4s	2m37s
	07	81,295	22ms	1m	1m8s	1m38s
	08	286,739	17ms	2m8s	2m38s	4m19s
	09	637,626	20ms	5m22s	5m48s	6m39s
	10	978,710	20ms	8m11s	10m8s	16m41s
	11	1,044,591	26ms	10m36s	12m27s	15m19s
	12	1,014,272	25ms	9m23s	10m27s	11m39s
	13	846,623	25ms	7m50s	9m52s	10m41s
	14	743,298	22ms	6m10s	8m13s	10m18s
	15	645,574	21ms	4m42s	5m54s	7m27s
	16	696,954	18ms	4m40s	5m23s	6m19s
	17	607,044	19ms	4m19s	5m19s	6m30s
	18	441,981	33ms	5m32s	7m4s	8m37s
	19	502,017	55ms	9m57s	11m9s	15m6s
	20	378,040	39ms	5m59s	6m51s	8m3s
	21	205,732	31ms	2m40s	3m9s	3m49s
	22	160,642	41ms	3m30s	3m54s	5m36s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 02	00	26,553	5,597	137	0	3ms	165ms	224ms	313ms
	01	22,730	5,453	136	0	0ms	136ms	177ms	265ms
	02	20,096	5,710	131	0	0ms	119ms	155ms	244ms
	03	26,086	6,680	131	0	3ms	136ms	188ms	268ms
	04	20,665	5,686	130	0	1ms	109ms	155ms	220ms
	05	13,639	3,614	154	0	0ms	85ms	102ms	146ms
	06	12,173	2,660	132	0	0ms	67ms	106ms	161ms
	07	5,909	1,709	179	0	0ms	30ms	49ms	69ms
	08	15,542	6,799	313	0	189ms	98ms	142ms	256ms
	09	45,149	15,104	801	0	162ms	276ms	321ms	487ms
	10	64,549	23,411	978	0	433ms	506ms	673ms	2h10m44s
	11	93,969	26,031	869	1	241ms	753ms	1s130ms	1h14m21s
	12	82,860	25,612	1,066	0	171ms	628ms	976ms	48m7s
	13	71,975	24,884	774	0	363ms	557ms	24s977ms	5m3s
	14	59,605	20,040	923	0	93ms	409ms	485ms	1m3s
	15	55,721	18,568	837	0	1ms	283ms	371ms	864ms
	16	49,088	18,333	624	0	794ms	285ms	354ms	3h24m43s
	17	53,294	16,559	478	0	451ms	392ms	503ms	716ms
	18	55,426	16,950	570	0	0ms	360ms	435ms	541ms
	19	74,731	24,914	361	0	235ms	533ms	644ms	2m38s
	20	54,492	11,561	319	0	424ms	351ms	451ms	680ms
	21	28,315	6,299	237	0	0ms	168ms	235ms	301ms
	22	28,050	6,164	154	0	0ms	219ms	271ms	440ms

Day	Hour	Percentage of prepare
Feb 02	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
Feb 02	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
Feb 02	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

66,229 buffers Checkpoint Peak
2025-02-02 12:41:25 Date
270.054 seconds Highest write time
0.016 seconds Sync time

Checkpoints Wal files

Key values

27 files Wal files usage Peak
2025-02-02 11:56:25 Date

Checkpoints distance

Key values

880.80 Mo Distance Peak
2025-02-02 12:41:25 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 02	00	136,004	3,239.604s	0.039s	3,239.687s
	01	169,735	3,239.501s	0.031s	3,239.588s
	02	136,264	3,201.588s	0.031s	3,201.67s
	03	153,760	3,239.557s	0.045s	3,239.652s
	04	143,284	3,239.573s	0.031s	3,239.648s
	05	94,552	3,239.494s	0.029s	3,239.563s
	06	90,752	3,106.55s	0.026s	3,106.617s
	07	43,863	2,837.371s	0.034s	2,837.434s
	08	106,043	3,111.536s	0.031s	3,111.618s
	09	313,882	3,239.493s	0.044s	3,239.603s
	10	450,875	3,239.486s	0.052s	3,239.613s
	11	619,408	3,239.51s	0.069s	3,239.688s
	12	572,224	3,239.457s	0.071s	3,239.625s
	13	503,078	3,239.462s	0.052s	3,239.602s
	14	404,763	3,239.527s	0.047s	3,239.642s
	15	321,742	3,239.577s	0.047s	3,239.691s
	16	304,457	3,239.464s	0.056s	3,239.585s
	17	262,832	2,885.732s	0.064s	2,885.857s
	18	219,713	3,239.521s	0.046s	3,239.629s
	19	284,675	3,239.511s	0.047s	3,239.629s
	20	257,297	3,239.519s	0.041s	3,239.625s
	21	106,731	3,239.585s	0.04s	3,239.673s
	22	90,514	2,429.667s	0.031s	2,429.728s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Feb 02	00	58	3,483	0.002s	0.012s
	01	75	3,308	0.002s	0.012s
	02	59	2,457	0.002s	0.012s
	03	69	2,732	0.015s	0.012s
	04	61	2,569	0.002s	0.012s
	05	42	2,304	0.002s	0.012s
	06	39	2,319	0.002s	0.012s
	07	18	2,315	0.009s	0.012s
	08	43	3,602	0.003s	0.012s
	09	135	4,895	0.002s	0.012s
	10	193	5,203	0.004s	0.012s
	11	272	5,401	0.003s	0.012s
	12	252	5,532	0.004s	0.012s
	13	220	5,505	0.002s	0.012s
	14	174	5,324	0.003s	0.012s
	15	138	5,385	0.003s	0.012s
	16	130	5,684	0.003s	0.012s
	17	111	5,421	0.011s	0.012s
	18	97	5,191	0.003s	0.012s
	19	127	4,998	0.002s	0.012s
	20	116	5,031	0.002s	0.012s
	21	47	4,081	0.003s	0.012s
	22	41	3,200	0.002s	0.009s

Day	Hour	Avg time (sec)
Feb 02	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
Feb 02	00	79,364.75 kB	95,619.50 kB
	01	101,585.25 kB	133,248.00 kB
	02	81,423.33 kB	115,308.92 kB
	03	92,979.82 kB	119,865.00 kB
	04	84,265.42 kB	108,307.67 kB
	05	57,231.42 kB	91,744.83 kB
	06	53,323.08 kB	100,032.33 kB
	07	24,240.25 kB	53,601.50 kB
	08	57,207.45 kB	91,754.18 kB
	09	175,210.27 kB	195,906.18 kB
	10	264,308.17 kB	288,527.83 kB
	11	364,548.91 kB	416,922.00 kB
	12	344,829.67 kB	415,791.50 kB
	13	299,921.50 kB	369,775.83 kB
	14	241,585.18 kB	286,592.55 kB
	15	192,931.91 kB	241,139.91 kB
	16	177,154.08 kB	251,919.00 kB
	17	152,338.50 kB	186,232.92 kB
	18	132,002.08 kB	162,919.92 kB
	19	177,070.18 kB	210,779.82 kB
	20	158,321.83 kB	210,654.92 kB
	21	63,674.67 kB	128,355.00 kB
	22	76,179.78 kB	101,596.11 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
Feb 02	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
Feb 02	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,112,979 Total read queries
4,845,589 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,112,979	58.68%
INSERT	980,617	5.69%
UPDATE	298,338	1.73%
DELETE	10,434	0.06%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	23,116	0.13%
DDL	1,598	0.01%
TCL	3,531,485	20.49%
CURSOR	0	0.00%
OTHERS	2,275,714	13.20%

Queries by database

Key values

unknown Main database
17,234,282 Requests
6d12h54m (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	17,234,282	6d12h54m
	copy from	1	0ms
	cte	23,116	5s288ms
	ddl	1,598	214ms
	delete	10,434	1s369ms
	insert	980,617	5m16s
	others	2,275,714	1m48s
	select	10,112,979	3d6h32m51s
	tcl	3,531,485	2m29s
	update	298,338	3d6h11m27s

Queries by user

Key values

unknown Main user
17,234,282 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	17,234,282	6d12h54m
	copy from	1	0ms
	cte	23,116	5s288ms
	ddl	1,598	214ms
	delete	10,434	1s369ms
	insert	980,617	5m16s
	others	2,275,714	1m48s
	select	10,112,979	3d6h32m51s
	tcl	3,531,485	2m29s
	update	298,338	3d6h11m27s

Duration by user

Key values

6d12h54m (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	17,234,282	6d12h54m
	copy from	1	0ms
	cte	23,116	5s288ms
	ddl	1,598	214ms
	delete	10,434	1s369ms
	insert	980,617	5m16s
	others	2,275,714	1m48s
	select	10,112,979	3d6h32m51s
	tcl	3,531,485	2m29s
	update	298,338	3d6h11m27s

Queries by host

Key values

unknown Main host
17,234,282 Requests
6d12h54m (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	17,234,282	6d12h54m
	copy from	1	0ms
	cte	23,116	5s288ms
	ddl	1,598	214ms
	delete	10,434	1s369ms
	insert	980,617	5m16s
	others	2,275,714	1m48s
	select	10,112,979	3d6h32m51s
	tcl	3,531,485	2m29s
	update	298,338	3d6h11m27s

Queries by application

Key values

unknown Main application
17,234,282 Requests
6d12h54m (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	17,234,282	6d12h54m
	copy from	1	0ms
	cte	23,116	5s288ms
	ddl	1,598	214ms
	delete	10,434	1s369ms
	insert	980,617	5m16s
	others	2,275,714	1m48s
	select	10,112,979	3d6h32m51s
	tcl	3,531,485	2m29s
	update	298,338	3d6h11m27s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-02 03:38:30 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

16,018,918 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	16,018,918	92.95%
1-5ms	303,102	1.76%
5-10ms	14,898	0.09%
10-25ms	51,028	0.30%
25-50ms	48,267	0.28%
50-100ms	177,087	1.03%
100-500ms	313,951	1.82%
500-1000ms	302,979	1.76%
1000-10000ms	3,438	0.02%
> 10000ms	614	0.00%

Slowest individual queries

Rank	Duration	Query
1	40m26s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703804', exp_date = '2025-02-02 15:09:53.703808', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
2	40m26s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703717', exp_date = '2025-02-02 15:09:53.703721', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
3	40m12s	update res_users set sid = '9379f3c79c1ce45716db9801c5501408f7bc14bf', last_update = '2025-02-02 12:19:08.846300', exp_date = '2025-02-02 13:04:08.846303', logged_in = 'TRUE' where id = 867; [ Date: 2025-02-02 13:59:21 ]
4	40m12s	update res_users set sid = '9379f3c79c1ce45716db9801c5501408f7bc14bf', last_update = '2025-02-02 12:19:08.847045', exp_date = '2025-02-02 13:04:08.847050', logged_in = 'TRUE' where id = 867; [ Date: 2025-02-02 13:59:21 ]
5	39m2s	update res_users set sid = '31d171fa102dc6398f16a655488ac4a89188766c', last_update = '2025-02-02 17:41:18.219966', exp_date = '2025-02-02 18:26:18.219969', logged_in = 'TRUE' where id = 859; [ Date: 2025-02-02 19:20:20 ]
6	39m2s	update res_users set sid = '31d171fa102dc6398f16a655488ac4a89188766c', last_update = '2025-02-02 17:41:18.219809', exp_date = '2025-02-02 18:26:18.219813', logged_in = 'TRUE' where id = 859; [ Date: 2025-02-02 19:20:20 ]
7	37m59s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:27:21.023578', exp_date = '2025-02-02 15:12:21.023581', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
8	37m38s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:27:42.071175', exp_date = '2025-02-02 15:12:42.071180', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
9	37m37s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:27:43.470596', exp_date = '2025-02-02 15:12:43.470601', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
10	36m41s	update res_users set sid = '31d171fa102dc6398f16a655488ac4a89188766c', last_update = '2025-02-02 17:43:39.003705', exp_date = '2025-02-02 18:28:39.003709', logged_in = 'TRUE' where id = 859; [ Date: 2025-02-02 19:20:20 ]
11	35m53s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:29:27.625252', exp_date = '2025-02-02 15:14:27.625256', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
12	33m30s	update res_users set sid = '31d171fa102dc6398f16a655488ac4a89188766c', last_update = '2025-02-02 17:46:50.645007', exp_date = '2025-02-02 18:31:50.645012', logged_in = 'TRUE' where id = 859; [ Date: 2025-02-02 19:20:20 ]
13	31m50s	update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:33:29.706480', exp_date = '2025-02-02 15:18:29.706483', logged_in = 'TRUE' where id = 856; [ Date: 2025-02-02 16:05:20 ]
14	31m15s	update res_users set sid = '6e111202e75c91cd52aacdb12e53f9c35fb892a6', last_update = '2025-02-02 19:03:05.598564', exp_date = '2025-02-02 19:48:05.598568', logged_in = 'TRUE' where id = 928; [ Date: 2025-02-02 20:34:20 ]
15	31m15s	update res_users set sid = '6e111202e75c91cd52aacdb12e53f9c35fb892a6', last_update = '2025-02-02 19:03:05.597560', exp_date = '2025-02-02 19:48:05.597564', logged_in = 'TRUE' where id = 928; [ Date: 2025-02-02 20:34:20 ]
16	30m44s	update res_users set sid = '1ea4f685fa4703b520f98e22dbda49b4e41c975d', last_update = '2025-02-02 15:45:31.081245', exp_date = '2025-02-02 16:30:31.081248', logged_in = 'TRUE' where id = 1037; [ Date: 2025-02-02 17:16:15 ]
17	30m44s	update res_users set sid = '1ea4f685fa4703b520f98e22dbda49b4e41c975d', last_update = '2025-02-02 15:45:31.080782', exp_date = '2025-02-02 16:30:31.080785', logged_in = 'TRUE' where id = 1037; [ Date: 2025-02-02 17:16:15 ]
18	30m29s	update res_users set sid = '6e111202e75c91cd52aacdb12e53f9c35fb892a6', last_update = '2025-02-02 19:03:51.249821', exp_date = '2025-02-02 19:48:51.249825', logged_in = 'TRUE' where id = 928; [ Date: 2025-02-02 20:34:20 ]
19	30m24s	update res_users set sid = '6e111202e75c91cd52aacdb12e53f9c35fb892a6', last_update = '2025-02-02 19:03:56.563006', exp_date = '2025-02-02 19:48:56.563009', logged_in = 'TRUE' where id = 928; [ Date: 2025-02-02 20:34:20 ]
20	29m58s	update res_users set sid = '9379f3c79c1ce45716db9801c5501408f7bc14bf', last_update = '2025-02-02 12:29:23.192836', exp_date = '2025-02-02 13:14:23.192839', logged_in = 'TRUE' where id = 867; [ Date: 2025-02-02 13:59:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d2h25m10s

61,003

Details

0ms

40m26s

4s391ms

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
Feb 02	00	700	152ms	0ms
	01	712	153ms	0ms
	02	861	182ms	0ms
	03	938	1m56s	123ms
	04	893	186ms	0ms
	05	592	124ms	0ms
	06	410	90ms	0ms
	07	400	83ms	0ms
	08	1,595	1h7m11s	2s527ms
	09	4,111	2h44m55s	2s407ms
	10	6,866	10h5m10s	5s288ms
	11	6,977	8h2m24s	4s148ms
	12	6,612	4h50m35s	2s636ms
	13	5,191	9h47m36s	6s791ms
	14	4,530	1h54m58s	1s522ms
	15	4,266	1m39s	23ms
	16	3,993	14h42m48s	13s265ms
	17	3,452	8h35m32s	8s960ms
	18	2,357	566ms	0ms
	19	2,150	6h27m55s	10s825ms
	20	1,796	6h2m22s	12s106ms
	21	911	209ms	0ms
	22	690	164ms	0ms

update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703804', exp_date = '2025-02-02 15:09:53.703808', logged_in = 'TRUE' where id = 856;

Date: 2025-02-02 16:05:20 Duration: 40m26s
update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703717', exp_date = '2025-02-02 15:09:53.703721', logged_in = 'TRUE' where id = 856;

Date: 2025-02-02 16:05:20 Duration: 40m26s
update res_users set sid = '9379f3c79c1ce45716db9801c5501408f7bc14bf', last_update = '2025-02-02 12:19:08.846300', exp_date = '2025-02-02 13:04:08.846303', logged_in = 'TRUE' where id = 867;

Date: 2025-02-02 13:59:21 Duration: 40m12s

2

1d19h45m20s

249,588

Details

522ms

4s891ms

631ms

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
Feb 02	00	8,257	1h20m26s	584ms
	01	7,955	1h16m14s	574ms
	02	8,017	1h16m25s	572ms
	03	8,905	1h26m5s	580ms
	04	7,765	1h13m53s	570ms
	05	5,558	52m42s	568ms
	06	4,185	39m28s	566ms
	07	2,254	20m52s	555ms
	08	4,543	42m29s	561ms
	09	11,514	1h55m45s	603ms
	10	15,857	2h59m1s	677ms
	11	22,657	4h30m44s	716ms
	12	20,427	3h53m22s	685ms
	13	17,525	3h12m19s	658ms
	14	13,853	2h24m44s	626ms
	15	10,457	1h46m28s	610ms
	16	9,536	1h36m46s	608ms
	17	9,566	1h36m26s	604ms
	18	12,256	2h4m41s	610ms
	19	22,307	4h9m37s	671ms
	20	15,171	2h35m16s	614ms
	21	5,441	54m27s	600ms
	22	5,582	56m56s	612ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4952017)) AND (("shipping_track"."id" not in (41028900, 41029021, 41051794, 41051897, 41104725, 41105078, 41335171, 41335171)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:18 Duration: 4s891ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4971731)) AND (("shipping_track"."id" not in (41211462, 41237675, 41265102, 41265125, 41297854, 41313464, 41335025, 41335025)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:06 Duration: 4s862ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4951100)) AND (("shipping_track"."id" not in (41024968, 41025203, 41025347, 41055763, 41055798, 41166959, 41335379, 41335379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:36 Duration: 4s856ms

3

8h6m32s

44,703

Details

525ms

5s47ms

653ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 02	00	141	1m33s	661ms
	01	124	1m24s	678ms
	02	193	2m8s	664ms
	03	206	2m15s	657ms
	04	165	1m48s	658ms
	05	179	1m49s	609ms
	06	170	1m45s	617ms
	07	478	4m34s	573ms
	08	1,010	9m42s	576ms
	09	3,564	36m14s	610ms
	10	4,306	51m7s	712ms
	11	4,665	58m13s	748ms
	12	5,569	1h4m47s	698ms
	13	3,734	41m43s	670ms
	14	4,045	42m40s	633ms
	15	3,866	39m12s	608ms
	16	2,927	29m18s	600ms
	17	2,739	27m14s	596ms
	18	2,398	23m44s	594ms
	19	1,848	21m25s	695ms
	20	1,497	15m15s	611ms
	21	579	5m36s	581ms
	22	300	2m56s	586ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4943108, 4916378, 4909594, 4893629, 4886389, 4881560)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 12:34:26 Duration: 5s47ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4958542, 4955535, 4955532, 4955521, 4955517, 4955512, 4952873, 4951917, 4951202, 4950073, 4947326, 4941531, 4941522, 4941520, 4941494, 4941481, 4939389, 4938702, 4937446, 4937029, 4931964, 4928504, 4927805, 4927167, 4926793, 4926128, 4924694, 4922969, 4919699, 4919234, 4918324, 4917005, 4916538, 4911011)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:04 Duration: 4s967ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4989390, 4989389, 4989388, 4989387, 4989386, 4989385, 4989384, 4989383, 4989382, 4989381)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:05:16 Duration: 4s690ms

4

7h41m19s

125,778

Details

166ms

1s532ms

220ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 02	00	1,374	4m21s	190ms
	01	2,217	6m56s	187ms
	02	2,211	6m58s	189ms
	03	2,069	6m28s	187ms
	04	2,384	7m27s	187ms
	05	2,053	6m25s	187ms
	06	1,039	3m13s	186ms
	07	441	1m22s	188ms
	08	3,425	10m41s	187ms
	09	4,781	15m53s	199ms
	10	8,856	33m16s	225ms
	11	9,009	35m38s	237ms
	12	10,087	39m10s	233ms
	13	16,401	59m41s	218ms
	14	9,035	32m13s	214ms
	15	4,934	16m19s	198ms
	16	4,681	15m29s	198ms
	17	3,021	10m4s	200ms
	18	10,395	37m50s	218ms
	19	24,906	1h43m20s	248ms
	20	1,675	5m53s	210ms
	21	549	1m47s	195ms
	22	235	45s55ms	191ms

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

Date: 2025-02-02 19:21:20 Duration: 1s532ms
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" = '203256')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-02 11:00:59 Duration: 1s490ms
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" = '111652')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-02 19:21:35 Duration: 1s448ms

5

3h39m24s

54,673

Details

90ms

850ms

240ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,788	10m47s	232ms
	01	1,728	6m3s	210ms
	02	1,528	5m21s	210ms
	03	2,936	10m12s	208ms
	04	1,540	5m37s	219ms
	05	882	3m9s	214ms
	06	684	2m35s	227ms
	08	24	6s481ms	270ms
	09	320	1m10s	221ms
	10	258	1m9s	268ms
	11	840	3m31s	251ms
	12	394	1m52s	284ms
	13	728	3m9s	260ms
	14	1,121	4m14s	226ms
	15	2,532	9m57s	236ms
	16	3,680	15m26s	251ms
	17	4,046	16m29s	244ms
	18	5,648	23m48s	252ms
	19	7,081	31m33s	267ms
	20	6,325	25m24s	240ms
	21	4,290	16m8s	225ms
	22	5,300	21m33s	244ms

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-02-02 19:19:04 Duration: 850ms
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-02-02 19:19:04 Duration: 846ms
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-02-02 11:04:07 Duration: 840ms

6

3h2m28s

247

Details

0ms

27m1s

44s324ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 02	00	3	0ms	0ms
	01	2	0ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	06	4	0ms	0ms
	07	2	0ms	0ms
	08	15	4m10s	16s711ms
	09	20	16ms	0ms
	10	36	19m28s	32s461ms
	11	21	33ms	1ms
	12	22	11m19s	30s886ms
	13	15	20ms	1ms
	14	20	9m3s	27s161ms
	15	14	7ms	0ms
	16	11	18m21s	1m40s
	17	16	13m20s	50s48ms
	18	8	4ms	0ms
	19	10	12ms	1ms
	20	13	1h46m44s	8m12s
	21	3	1ms	0ms
	22	10	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 19:52:19.387441', "last_update" = '2025-02-02 19:07:19.387467', "sid" = '63ca13d4777217da4795fc4a82da26acdac57834', "write_date" = '2025-02-02 19:07:19.060311', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 27m1s
UPDATE "res_users" SET "exp_date" = '2025-02-02 19:52:59.026421', "last_update" = '2025-02-02 19:07:59.026440', "sid" = '63ca13d4777217da4795fc4a82da26acdac57834', "write_date" = '2025-02-02 19:07:58.691426', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 26m21s
UPDATE "res_users" SET "exp_date" = '2025-02-02 19:59:49.038166', "last_update" = '2025-02-02 19:14:49.038187', "sid" = 'cc6fa9ccb1e54e0b7903816ec46db8bcdbbc1f51', "write_date" = '2025-02-02 19:14:48.693428', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 19m31s

7

2h15m15s

10,959

Details

222ms

1s953ms

740ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 02	00	372	4m15s	686ms
	01	432	4m9s	577ms
	02	77	1m8s	890ms
	03	391	1m38s	252ms
	04	240	1m4s	268ms
	08	11	9s622ms	874ms
	09	21	19s943ms	949ms
	10	14	12s838ms	917ms
	11	164	2m48s	1s27ms
	12	107	1m24s	793ms
	13	144	2m9s	900ms
	14	450	2m37s	350ms
	15	482	6m13s	775ms
	16	722	9m40s	804ms
	17	512	5m25s	636ms
	18	1,098	14m53s	813ms
	19	1,500	23m24s	936ms
	20	1,950	23m36s	726ms
	21	1,149	15m4s	786ms
	22	1,123	14m56s	798ms

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

Date: 2025-02-02 11:44:44 Duration: 1s953ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '144762')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-02 19:21:18 Duration: 1s859ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '144768')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-02 19:21:38 Duration: 1s751ms

8

2h14m29s

142,094

Details

39ms

302ms

56ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,731	2m25s	53ms
	01	3,093	2m43s	52ms
	02	2,701	2m24s	53ms
	03	3,149	2m47s	53ms
	04	2,635	2m19s	52ms
	05	1,412	1m13s	52ms
	06	2,067	1m50s	53ms
	07	1,282	1m8s	53ms
	08	2,640	2m20s	53ms
	09	7,341	6m54s	56ms
	10	10,880	11m17s	62ms
	11	17,583	19m14s	65ms
	12	16,723	17m35s	63ms
	13	10,818	10m55s	60ms
	14	8,142	7m46s	57ms
	15	7,807	7m10s	55ms
	16	6,738	6m6s	54ms
	17	7,073	5m52s	49ms
	18	7,138	5m40s	47ms
	19	7,191	6m27s	53ms
	20	7,172	5m48s	48ms
	21	2,989	2m18s	46ms
	22	2,789	2m8s	46ms

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

Date: 2025-02-02 11:04:35 Duration: 302ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4700335)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 12:54:22 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4985148)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 19:21:29 Duration: 298ms

9

1h37m29s

19,554

Details

180ms

2s509ms

299ms

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
Feb 02	08	918	3m52s	253ms
	09	1,590	7m26s	281ms
	10	3,438	17m9s	299ms
	11	1,064	5m44s	323ms
	12	2,194	12m3s	329ms
	13	1,989	9m27s	285ms
	14	1,842	9m8s	297ms
	15	2,751	14m48s	323ms
	16	2,165	9m58s	276ms
	17	1,589	7m42s	291ms
	18	14	6s239ms	445ms

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

Date: 2025-02-02 11:04:45 Duration: 2s509ms
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" = '9974535')))) ORDER BY "collection_policy"."id";

Date: 2025-02-02 11:04:47 Duration: 2s173ms
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" = '93291')))) ORDER BY "collection_policy"."id";

Date: 2025-02-02 10:57:21 Duration: 1s750ms

10

1h21m30s

16,655

Details

215ms

2s18ms

293ms

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
Feb 02	00	1,032	4m43s	274ms
	01	440	2m4s	282ms
	02	691	3m4s	266ms
	03	1,086	4m56s	272ms
	04	537	2m26s	273ms
	05	444	2m	270ms
	06	346	1m34s	273ms
	08	2	527ms	263ms
	09	144	42s941ms	298ms
	10	122	38s974ms	319ms
	11	268	1m39s	369ms
	12	94	34s623ms	368ms
	13	222	1m7s	306ms
	14	122	37s515ms	307ms
	15	808	4m8s	307ms
	16	1,131	5m37s	298ms
	17	1,533	7m30s	293ms
	18	1,760	8m51s	301ms
	19	2,066	11m22s	330ms
	20	1,244	6m4s	292ms
	21	1,018	4m37s	272ms
	22	1,545	7m7s	276ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '109883')) 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-02-02 11:04:28 Duration: 2s18ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '180493')) 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-02-02 19:22:21 Duration: 1s945ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '171309')) 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-02-02 11:16:34 Duration: 1s458ms

11

55m54s

15,875

Details

170ms

1s496ms

211ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 02	00	37	7s17ms	189ms
	01	3	570ms	190ms
	04	9	1s709ms	189ms
	05	565	1m45s	186ms
	06	846	2m37s	186ms
	07	441	1m23s	188ms
	08	1,639	5m7s	187ms
	09	1,843	6m5s	198ms
	10	1,224	4m35s	225ms
	11	3,105	12m28s	240ms
	12	959	3m39s	228ms
	13	960	3m31s	220ms
	14	1,027	3m31s	205ms
	15	335	1m5s	195ms
	16	262	50s732ms	193ms
	17	67	13s425ms	200ms
	19	155	35s523ms	229ms
	20	1,662	5m51s	211ms
	21	548	1m47s	196ms
	22	188	36s103ms	192ms

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

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

Date: 2025-02-02 11:04:35 Duration: 1s31ms

12

40m8s

38,245

Details

47ms

350ms

62ms

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
Feb 02	06	56	3s105ms	55ms
	07	13	768ms	59ms
	08	1,344	1m15s	55ms
	09	2,213	2m13s	60ms
	10	3,240	3m32s	65ms
	11	2,667	3m19s	74ms
	12	8,693	9m29s	65ms
	13	4,128	4m21s	63ms
	14	5,212	5m23s	61ms
	15	3,943	3m55s	59ms
	16	3,637	3m35s	59ms
	17	2,646	2m32s	57ms
	18	345	20s127ms	58ms
	19	70	4s623ms	66ms
	20	21	1s258ms	59ms
	21	5	288ms	57ms
	22	12	680ms	56ms

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

Date: 2025-02-02 10:57:15 Duration: 350ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4872871) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-02 11:00:58 Duration: 333ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4890264) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-02 12:34:21 Duration: 328ms

13

35m54s

17,084

Details

96ms

831ms

126ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	69	7s368ms	106ms
	05	21	2s366ms	112ms
	07	45	5s248ms	116ms
	08	244	27s704ms	113ms
	09	1,162	2m21s	121ms
	10	1,628	3m36s	132ms
	11	1,817	4m17s	141ms
	12	2,201	4m55s	134ms
	13	2,331	4m55s	126ms
	14	2,058	4m13s	122ms
	15	1,883	3m41s	117ms
	16	1,053	2m2s	116ms
	17	1,166	2m13s	114ms
	18	503	1m1s	122ms
	19	396	52s567ms	132ms
	20	350	42s944ms	122ms
	21	121	13s924ms	115ms
	22	36	4s281ms	118ms

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

Date: 2025-02-02 10:57:11 Duration: 831ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8074028)) AND (("cash_track"."id" not in (7614426)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-02 11:04:06 Duration: 823ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8074045)) AND (("cash_track"."id" not in (7614445)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-02 11:05:11 Duration: 771ms

14

34m30s

10,988

Details

167ms

235ms

188ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 02	00	1,285	4m4s	190ms
	01	2,046	6m24s	187ms
	02	2,105	6m38s	189ms
	03	2,069	6m28s	187ms
	04	2,376	7m26s	187ms
	05	1,011	3m10s	188ms
	06	49	9s120ms	186ms
	22	47	9s8ms	191ms

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" = '72999')) 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-02-02 04:05:44 Duration: 235ms
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" = '251428')) 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-02-02 00:12:55 Duration: 232ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '268152')) 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-02-02 04:05:44 Duration: 231ms

15

22m51s

40

Details

0ms

13m4s

34s291ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 02	04	1	0ms	0ms
	08	3	1ms	0ms
	09	5	6ms	1ms
	10	7	17m2s	2m26s
	11	2	2ms	1ms
	12	3	5m49s	1m56s
	13	2	3ms	1ms
	14	4	7ms	1ms
	15	2	0ms	0ms
	16	2	1ms	0ms
	19	3	3ms	1ms
	21	3	1ms	0ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 10:14:16.266721', "last_update" = '2025-02-02 09:29:16.266751', "write_date" = '2025-02-02 09:29:15.918745', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-02 10:42:20 Duration: 13m4s
UPDATE "res_users" SET "exp_date" = '2025-02-02 12:38:31.312382', "last_update" = '2025-02-02 11:53:31.312405', "write_date" = '2025-02-02 11:53:30.934908', "write_uid" = 1 WHERE id IN (959);

Date: 2025-02-02 12:59:20 Duration: 5m49s
UPDATE "res_users" SET "exp_date" = '2025-02-02 10:09:22.421535', "last_update" = '2025-02-02 09:24:22.421558', "write_date" = '2025-02-02 09:24:22.095449', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-02 10:28:20 Duration: 3m57s

16

20m13s

6,222

Details

16ms

2s504ms

195ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 02	00	3	60ms	20ms
	01	1	18ms	18ms
	07	6	801ms	133ms
	08	53	11s718ms	221ms
	09	3,338	8m2s	144ms
	10	861	2m23s	166ms
	11	296	1m34s	317ms
	12	326	1m45s	324ms
	13	310	1m43s	335ms
	14	340	1m15s	222ms
	15	215	53s47ms	246ms
	16	139	39s75ms	281ms
	17	110	32s666ms	296ms
	18	88	23s149ms	263ms
	19	68	28s773ms	423ms
	20	47	14s152ms	301ms
	21	12	2s724ms	227ms
	22	9	2s283ms	253ms

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

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

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

Date: 2025-02-02 10:58:58 Duration: 2s13ms

17

20m4s

2,082

Details

407ms

995ms

578ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 02	08	2	881ms	440ms
	10	13	7s362ms	566ms
	11	464	4m40s	605ms
	12	691	6m49s	593ms
	13	300	2m43s	544ms
	14	398	3m46s	569ms
	15	152	1m23s	549ms
	16	62	31s840ms	513ms

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

Date: 2025-02-02 11:43:01 Duration: 995ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '29290')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-02 11:44:39 Duration: 904ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '29285')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-02 11:44:31 Duration: 885ms

18

16m12s

5,813

Details

121ms

1s190ms

167ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 02	00	10	1s303ms	130ms
	07	5	663ms	132ms
	08	85	11s336ms	133ms
	09	388	56s98ms	144ms
	10	870	2m25s	167ms
	11	1,498	4m42s	188ms
	12	1,264	3m38s	173ms
	13	498	1m19s	159ms
	14	289	42s741ms	147ms
	15	173	24s982ms	144ms
	16	131	18s542ms	141ms
	17	204	29s454ms	144ms
	18	79	11s913ms	150ms
	19	77	13s143ms	170ms
	20	73	11s422ms	156ms
	21	125	18s49ms	144ms
	22	44	6s413ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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-02-02 11:04:06 Duration: 1s190ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 127)) 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-02-02 11:04:33 Duration: 1s185ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-02 10:59:43 Duration: 1s184ms

19

15m1s

15,754

Details

42ms

114ms

57ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 02	08	629	32s172ms	51ms
	09	1,049	57s853ms	55ms
	10	2,101	2m13s	63ms
	11	1,219	1m14s	60ms
	12	1,998	1m59s	59ms
	13	1,878	1m50s	59ms
	14	1,906	1m47s	56ms
	15	2,115	1m54s	53ms
	16	1,734	1m34s	54ms
	17	1,112	57s179ms	51ms
	18	13	656ms	50ms

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

Date: 2025-02-02 11:00:52 Duration: 114ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4852564) ORDER BY "collection_policy"."id";

Date: 2025-02-02 10:57:57 Duration: 104ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4702070) ORDER BY "collection_policy"."id";

Date: 2025-02-02 12:31:54 Duration: 103ms

20

14m20s

3,734

Details

170ms

1s447ms

230ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 02	05	452	1m24s	187ms
	06	144	27s393ms	190ms
	10	1,292	5m7s	237ms
	11	1,812	7m12s	238ms
	12	34	8s400ms	247ms

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

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

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

Date: 2025-02-02 11:15:56 Duration: 1s114ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,274,803

Details

1m48s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 02	00	41,259	1s975ms	0ms
	01	37,709	1s864ms	0ms
	02	38,048	1s881ms	0ms
	03	36,552	1s889ms	0ms
	04	32,635	1s657ms	0ms
	05	23,885	1s178ms	0ms
	06	24,673	1s190ms	0ms
	07	24,514	1s111ms	0ms
	08	63,641	2s919ms	0ms
	09	142,450	7s3ms	0ms
	10	192,138	8s173ms	0ms
	11	216,016	10s344ms	0ms
	12	212,903	10s216ms	0ms
	13	187,159	9s82ms	0ms
	14	171,680	7s851ms	0ms
	15	162,356	8s304ms	0ms
	16	166,156	6s787ms	0ms
	17	136,052	6s201ms	0ms
	18	105,088	5s672ms	0ms
	19	95,298	5s91ms	0ms
	20	77,392	3s840ms	0ms
	21	52,355	2s389ms	0ms
	22	34,844	1s726ms	0ms

DISCARD ALL;

Date: 2025-02-02 20:06:24 Duration: 1ms
DISCARD ALL;

Date: 2025-02-02 15:33:34 Duration: 1ms
DISCARD ALL;

Date: 2025-02-02 18:28:44 Duration: 1ms

2

1,766,120

Details

25s646ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 02	00	30,580	457ms	0ms
	01	28,130	427ms	0ms
	02	28,406	429ms	0ms
	03	28,348	437ms	0ms
	04	25,954	393ms	0ms
	05	18,472	287ms	0ms
	06	19,178	292ms	0ms
	07	18,699	273ms	0ms
	08	51,085	670ms	0ms
	09	116,068	1s607ms	0ms
	10	156,784	2s138ms	0ms
	11	175,577	2s589ms	0ms
	12	168,885	2s456ms	0ms
	13	142,863	2s87ms	0ms
	14	129,800	1s787ms	0ms
	15	123,073	1s775ms	0ms
	16	127,006	1s580ms	0ms
	17	105,968	1s437ms	0ms
	18	78,033	1s270ms	0ms
	19	72,184	1s275ms	0ms
	20	58,837	946ms	0ms
	21	36,552	579ms	0ms
	22	25,638	445ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-02 10:42:47 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-02 12:33:43 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-02 15:25:31 Duration: 0ms

3

1,157,863

Details

11s916ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 02	00	21,252	196ms	0ms
	01	19,431	180ms	0ms
	02	19,613	181ms	0ms
	03	18,869	181ms	0ms
	04	16,873	161ms	0ms
	05	12,518	116ms	0ms
	06	12,953	120ms	0ms
	07	12,890	114ms	0ms
	08	32,620	295ms	0ms
	09	72,187	708ms	0ms
	10	97,571	1s22ms	0ms
	11	109,399	1s254ms	0ms
	12	107,795	1s202ms	0ms
	13	94,810	985ms	0ms
	14	87,126	883ms	0ms
	15	82,309	779ms	0ms
	16	84,049	760ms	0ms
	17	69,092	700ms	0ms
	18	53,423	593ms	0ms
	19	48,562	595ms	0ms
	20	39,562	430ms	0ms
	21	26,882	261ms	0ms
	22	18,077	188ms	0ms

ROLLBACK;

Date: 2025-02-02 10:00:03 Duration: 0ms
ROLLBACK;

Date: 2025-02-02 19:22:45 Duration: 0ms
ROLLBACK;

Date: 2025-02-02 11:14:06 Duration: 0ms

4

1,147,300

Details

3m22s

0ms

17ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 02	00	20,654	3s282ms	0ms
	01	18,818	3s26ms	0ms
	02	19,006	3s43ms	0ms
	03	18,243	3s57ms	0ms
	04	16,274	2s689ms	0ms
	05	11,907	1s885ms	0ms
	06	12,331	1s809ms	0ms
	07	12,354	1s670ms	0ms
	08	31,993	4s793ms	0ms
	09	71,882	12s136ms	0ms
	10	97,363	17s119ms	0ms
	11	109,177	20s248ms	0ms
	12	107,588	19s510ms	0ms
	13	94,580	16s693ms	0ms
	14	86,969	14s518ms	0ms
	15	82,096	13s72ms	0ms
	16	83,705	13s110ms	0ms
	17	68,542	12s169ms	0ms
	18	52,984	10s922ms	0ms
	19	47,958	10s923ms	0ms
	20	38,891	8s250ms	0ms
	21	26,358	4s926ms	0ms
	22	17,627	3s646ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'effd2d2088a7eba20a336d78276dd543ed5ad69c';

Date: 2025-02-02 11:49:20 Duration: 17ms
SELECT payload FROM http_sessions WHERE sid = '67d7172e77f4a72a9b95dd6fe78c3e67a69b1c52';

Date: 2025-02-02 10:33:41 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = 'bb92e1d5c6d2a9eaf175e2ac1559a219a2ba97e6';

Date: 2025-02-02 17:21:51 Duration: 10ms

5

1,137,797

Details

1m44s

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
Feb 02	00	20,691	1s731ms	0ms
	01	18,919	1s601ms	0ms
	02	19,098	1s620ms	0ms
	03	18,355	1s590ms	0ms
	04	16,398	1s399ms	0ms
	05	12,010	1s5ms	0ms
	06	12,405	1s28ms	0ms
	07	12,329	958ms	0ms
	08	31,809	2s508ms	0ms
	09	71,168	6s400ms	0ms
	10	95,972	8s759ms	0ms
	11	107,961	10s584ms	0ms
	12	106,388	10s274ms	0ms
	13	93,553	8s669ms	0ms
	14	85,834	7s817ms	0ms
	15	81,192	7s84ms	0ms
	16	83,057	6s907ms	0ms
	17	68,001	6s110ms	0ms
	18	52,580	5s169ms	0ms
	19	47,683	5s110ms	0ms
	20	38,706	3s749ms	0ms
	21	26,230	2s330ms	0ms
	22	17,458	1s616ms	0ms

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

Date: 2025-02-02 11:06:06 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-02 14:42:59 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-02 10:54:25 Duration: 1ms

6

789,274

Details

1m59s

0ms

11ms

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
Feb 02	00	12,482	1s885ms	0ms
	01	11,609	1s773ms	0ms
	02	10,393	1s746ms	0ms
	03	11,445	1s902ms	0ms
	04	11,150	1s824ms	0ms
	05	7,224	1s265ms	0ms
	06	7,701	1s262ms	0ms
	07	6,972	1s159ms	0ms
	08	23,345	3s184ms	0ms
	09	62,788	10s339ms	0ms
	10	78,444	11s334ms	0ms
	11	86,141	13s551ms	0ms
	12	79,231	12s170ms	0ms
	13	62,351	9s658ms	0ms
	14	56,920	8s7ms	0ms
	15	53,357	8s58ms	0ms
	16	54,148	6s896ms	0ms
	17	46,896	6s359ms	0ms
	18	31,319	4s834ms	0ms
	19	29,884	5s38ms	0ms
	20	24,159	3s775ms	0ms
	21	11,904	1s888ms	0ms
	22	9,411	1s584ms	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 (939);

Date: 2025-02-02 17:21:52 Duration: 11ms
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 (1258);

Date: 2025-02-02 17:21:52 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 (1307);

Date: 2025-02-02 17:21:52 Duration: 10ms

7

607,496

Details

1m52s

0ms

34ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 02	00	9,328	1s878ms	0ms
	01	8,700	1s750ms	0ms
	02	8,791	1s864ms	0ms
	03	9,480	2s17ms	0ms
	04	9,080	1s803ms	0ms
	05	5,955	1s196ms	0ms
	06	6,226	1s71ms	0ms
	07	5,809	874ms	0ms
	08	18,405	2s618ms	0ms
	09	43,843	7s89ms	0ms
	10	59,060	10s798ms	0ms
	11	66,057	12s940ms	0ms
	12	60,988	11s994ms	0ms
	13	48,002	9s220ms	0ms
	14	42,643	7s786ms	0ms
	15	40,756	7s165ms	0ms
	16	42,853	6s623ms	0ms
	17	36,850	6s214ms	0ms
	18	24,594	4s837ms	0ms
	19	23,604	5s304ms	0ms
	20	19,241	4s56ms	0ms
	21	9,670	1s859ms	0ms
	22	7,561	1s452ms	0ms

COMMIT;

Date: 2025-02-02 11:18:24 Duration: 34ms
COMMIT;

Date: 2025-02-02 17:01:47 Duration: 34ms
COMMIT;

Date: 2025-02-02 00:57:32 Duration: 33ms

8

483,916

Details

32s956ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	6,127	356ms	0ms
	01	5,633	328ms	0ms
	02	4,250	244ms	0ms
	03	5,151	293ms	0ms
	04	5,353	303ms	0ms
	05	3,370	184ms	0ms
	06	5,110	272ms	0ms
	07	4,659	216ms	0ms
	08	13,274	760ms	0ms
	09	37,203	2s529ms	0ms
	10	48,819	3s585ms	0ms
	11	54,129	4s305ms	0ms
	12	48,805	3s723ms	0ms
	13	39,235	2s811ms	0ms
	14	34,225	2s362ms	0ms
	15	33,212	2s54ms	0ms
	16	33,556	2s20ms	0ms
	17	30,428	1s776ms	0ms
	18	20,996	1s325ms	0ms
	19	19,514	1s569ms	0ms
	20	16,819	1s99ms	0ms
	21	8,046	468ms	0ms
	22	6,002	364ms	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 (51, 102, 17, 78, 52, 70, 79, 46, 60, 67, 7, 64, 123, 39, 40, 24, 27, 75, 77, 6, 22, 13, 26, 16, 9);

Date: 2025-02-02 22:14:11 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 (17, 27, 119, 19, 49, 65, 28, 78, 61, 73, 39, 11, 67, 24, 102);

Date: 2025-02-02 11:07:14 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 (78, 73, 39, 75, 22, 110, 14, 64, 46, 5, 27, 28, 80, 17, 52, 19, 128, 79);

Date: 2025-02-02 13:01:34 Duration: 1ms

9

479,426

Details

1m7s

0ms

6ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	8,052	1s21ms	0ms
	01	7,461	856ms	0ms
	02	5,903	652ms	0ms
	03	7,789	836ms	0ms
	04	7,246	865ms	0ms
	05	4,425	610ms	0ms
	06	4,964	575ms	0ms
	07	3,637	419ms	0ms
	08	11,636	1s360ms	0ms
	09	40,643	7s571ms	0ms
	10	48,344	7s607ms	0ms
	11	52,664	8s436ms	0ms
	12	45,691	7s137ms	0ms
	13	36,061	5s117ms	0ms
	14	33,667	4s759ms	0ms
	15	31,590	4s107ms	0ms
	16	28,966	3s337ms	0ms
	17	28,624	3s439ms	0ms
	18	20,890	2s555ms	0ms
	19	19,633	2s862ms	0ms
	20	16,024	1s963ms	0ms
	21	8,382	866ms	0ms
	22	7,134	755ms	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 (5099456, 5099082, 5101977, 5100384, 5099872, 5487354, 5194320, 5103868, 5099602, 5099037, 5106365, 5229646, 5110000, 5103025, 5099202, 5450584, 5103820, 5144305, 5260514, 5099141, 5100933, 5109251, 5100301, 5105002, 5113489, 5124273, 5101316, 5101120, 5105755, 5101092, 5126587, 5388544, 5100641, 5101563, 5155703, 5177102, 5099890, 5099282, 5099355, 5107075, 5496935, 5099694, 5099647, 5498540, 5100091, 5452760, 5110301, 5159711, 5100061, 5100476, 5099095, 5296305, 5099779, 5102638, 5127694, 5186769, 5099442, 5390185, 5100830, 5099504, 5116707, 5105759, 5099501, 5151963, 5104513, 5100202, 5102207, 5111961, 5171733, 5099546, 5101213, 5099119, 5486280, 5200721, 5467736, 5103640, 5099513, 5412934, 5170221, 5099431, 5148390, 5101006, 5189375, 5412770, 5099121, 5099967, 5201294, 5100163, 5101297, 5103145, 5499054, 5101304, 5099403, 5099299, 5104872, 5105954, 5098996, 5106211, 5119699, 5106857, 5099709, 5099585, 5102122, 5100935, 5100218, 5108236, 5104045, 5099272, 5499022, 5121085, 5099758, 5099014, 5099045, 5101009, 5104351, 5107494, 5109066, 5102921, 5099170, 5498146, 5101967, 5100688, 5102433, 5100838, 5100397);

Date: 2025-02-02 17:21:55 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099035, 5099737, 5100637, 5101345, 5099158, 5100802, 5099662, 5099275, 5099904, 5106118, 5099128, 5113512, 5099309, 5105753, 5101116, 5099008, 5100755, 5099590, 5100161, 5116973, 5100218, 5099921, 5099294, 5101592, 5099491, 5099329, 5099162, 5099802, 5100719, 5393331, 5100004, 5099873, 5205392, 5099264, 5101584, 5110373, 5303530, 5100184, 5100327, 5099206, 5099690, 5099089, 5099333, 5099010, 5101213, 5099204, 5101169, 5102626, 5108674, 5100786, 5099045, 5099137, 5099800, 5105058, 5104194, 5100132, 5100511, 5501421, 5115062, 5131484, 5115684, 5099280, 5105896, 5099102, 5102299, 5100457, 5170411);

Date: 2025-02-02 17:21:53 Duration: 5ms
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 (5099726, 5257672, 5100165, 5125438, 5111900, 5099554, 5101252, 5103279, 5099194, 5099009, 5111312, 5099179, 5099092, 5099244, 5099181, 5229643, 5469912, 5101413, 5099010, 5099013, 5099693, 5099007, 5101763, 5099819, 5099008, 5099590, 5127026, 5099430, 5101298, 5099489, 5106238, 5498706, 5099006, 5100118, 5099639, 5099102, 5099321, 5161865, 5171771, 5485238, 5099158, 5121704, 5099001, 5100274, 5102276, 5099724, 5100421, 5099427, 5100939, 5104173, 5100150, 5499798, 5100000, 5107359, 5099254, 5100563, 5251466, 5099798, 5099028, 5099434, 5099671, 5499376, 5099550, 5108374, 5401434, 5102265, 5099043, 5104971, 5306804, 5101891, 5099503, 5105862, 5099264, 5099677, 5099169, 5101173, 5099130, 5099329, 5103258, 5099581, 5103356, 5099144, 5107070, 5113851, 5099162, 5099035, 5099204, 5099807, 5100738, 5099573, 5105266, 5100006, 5103051, 5100511, 5099081, 5099120, 5139290, 5100962, 5416844, 5099167, 5099236, 5099138, 5099525, 5099309, 5100714, 5126865, 5099406, 5099958, 5100554, 5099348, 5100354, 5123408, 5099190, 5133272, 5099313, 5099128, 5099609, 5100132, 5099887);

Date: 2025-02-02 17:21:55 Duration: 5ms

10

340,619

Details

1m53s

0ms

4ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,346	729ms	0ms
	01	1,530	469ms	0ms
	02	1,320	430ms	0ms
	03	1,374	437ms	0ms
	04	879	273ms	0ms
	05	844	257ms	0ms
	06	1,406	425ms	0ms
	07	1,373	394ms	0ms
	08	10,394	3s	0ms
	09	17,618	5s651ms	0ms
	10	39,567	13s508ms	0ms
	11	40,622	14s822ms	0ms
	12	41,009	14s764ms	0ms
	13	35,346	12s192ms	0ms
	14	28,966	9s691ms	0ms
	15	20,551	6s622ms	0ms
	16	25,848	7s621ms	0ms
	17	22,109	6s870ms	0ms
	18	12,824	4s211ms	0ms
	19	14,612	5s312ms	0ms
	20	11,340	3s608ms	0ms
	21	5,577	1s613ms	0ms
	22	3,164	947ms	0ms

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

Date: 2025-02-02 12:25:12 Duration: 4ms
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 = 979) OR r.global) ORDER BY r.id;

Date: 2025-02-02 12:16:40 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.partner' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 851) OR r.global) ORDER BY r.id;

Date: 2025-02-02 09:24:58 Duration: 2ms

11

332,572

Details

1m4s

0ms

9ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	4,392	708ms	0ms
	01	4,049	666ms	0ms
	02	2,649	504ms	0ms
	03	3,080	596ms	0ms
	04	3,091	572ms	0ms
	05	2,294	377ms	0ms
	06	2,764	458ms	0ms
	07	2,999	467ms	0ms
	08	11,943	1s812ms	0ms
	09	27,618	5s94ms	0ms
	10	34,012	6s938ms	0ms
	11	35,881	7s983ms	0ms
	12	34,272	7s285ms	0ms
	13	26,877	5s467ms	0ms
	14	24,865	4s676ms	0ms
	15	23,901	4s213ms	0ms
	16	22,625	3s889ms	0ms
	17	19,551	3s540ms	0ms
	18	13,294	2s499ms	0ms
	19	13,095	2s917ms	0ms
	20	10,199	1s963ms	0ms
	21	5,346	891ms	0ms
	22	3,775	670ms	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 (8007444);

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

Date: 2025-02-02 18:30:08 Duration: 2ms
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 (8004708);

Date: 2025-02-02 12:52:02 Duration: 2ms

12

253,896

Details

46s803ms

0ms

2ms

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
Feb 02	00	2,629	375ms	0ms
	01	1,830	250ms	0ms
	02	1,773	225ms	0ms
	03	1,766	237ms	0ms
	04	1,288	160ms	0ms
	05	1,593	198ms	0ms
	06	1,057	150ms	0ms
	07	1,348	191ms	0ms
	08	9,893	1s438ms	0ms
	09	14,746	2s504ms	0ms
	10	29,927	5s987ms	0ms
	11	26,699	5s775ms	0ms
	12	28,448	5s971ms	0ms
	13	24,800	4s985ms	0ms
	14	21,030	3s976ms	0ms
	15	14,475	2s382ms	0ms
	16	18,044	2s981ms	0ms
	17	15,788	2s658ms	0ms
	18	8,864	1s492ms	0ms
	19	11,219	2s238ms	0ms
	20	8,879	1s483ms	0ms
	21	4,615	665ms	0ms
	22	3,185	470ms	0ms

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-02-02 19:21:22 Duration: 2ms
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-02-02 10:59:27 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');

Date: 2025-02-02 12:04:50 Duration: 1ms

13

249,588

Details

1d19h45m20s

522ms

4s891ms

631ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 02	00	8,257	1h20m26s	584ms
	01	7,955	1h16m14s	574ms
	02	8,017	1h16m25s	572ms
	03	8,905	1h26m5s	580ms
	04	7,765	1h13m53s	570ms
	05	5,558	52m42s	568ms
	06	4,185	39m28s	566ms
	07	2,254	20m52s	555ms
	08	4,543	42m29s	561ms
	09	11,514	1h55m45s	603ms
	10	15,857	2h59m1s	677ms
	11	22,657	4h30m44s	716ms
	12	20,427	3h53m22s	685ms
	13	17,525	3h12m19s	658ms
	14	13,853	2h24m44s	626ms
	15	10,457	1h46m28s	610ms
	16	9,536	1h36m46s	608ms
	17	9,566	1h36m26s	604ms
	18	12,256	2h4m41s	610ms
	19	22,307	4h9m37s	671ms
	20	15,171	2h35m16s	614ms
	21	5,441	54m27s	600ms
	22	5,582	56m56s	612ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4952017)) AND (("shipping_track"."id" not in (41028900, 41029021, 41051794, 41051897, 41104725, 41105078, 41335171, 41335171)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:18 Duration: 4s891ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4971731)) AND (("shipping_track"."id" not in (41211462, 41237675, 41265102, 41265125, 41297854, 41313464, 41335025, 41335025)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:06 Duration: 4s862ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4951100)) AND (("shipping_track"."id" not in (41024968, 41025203, 41025347, 41055763, 41055798, 41166959, 41335379, 41335379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:36 Duration: 4s856ms

14

221,932

Details

1m

0ms

11ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 02	00	3,823	891ms	0ms
	01	3,230	723ms	0ms
	02	2,522	608ms	0ms
	03	3,609	864ms	0ms
	04	3,043	792ms	0ms
	05	1,850	535ms	0ms
	06	2,059	540ms	0ms
	07	1,544	378ms	0ms
	08	4,953	1s189ms	0ms
	09	16,320	6s16ms	0ms
	10	19,951	6s180ms	0ms
	11	21,679	6s765ms	0ms
	12	20,201	6s398ms	0ms
	13	17,157	4s321ms	0ms
	14	16,744	4s110ms	0ms
	15	16,348	4s73ms	0ms
	16	13,999	3s180ms	0ms
	17	14,283	3s447ms	0ms
	18	10,403	2s599ms	0ms
	19	10,332	2s952ms	0ms
	20	8,520	2s182ms	0ms
	21	4,725	1s56ms	0ms
	22	4,637	1s122ms	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 (39668974, 39725177, 39697791, 39643805, 39554721, 39593654, 39669113, 39692894, 38781962, 39262141, 39599888, 39513675, 39683667, 39627815, 39603498, 39690379, 39658846, 39770595, 39570909, 39666164, 39612090, 39692933, 39482143, 39622973, 39689495, 39751554, 39603508, 39603504, 39603444, 39660735, 39683725, 39433226, 39687496, 39687492, 39707054, 39598886, 39683655, 39589324, 39699242, 39523821, 39697618, 39568339, 39734432, 39693149, 39693176, 39488727, 39724893, 39690510, 39651986, 39683327, 39589322, 39311601, 39703067, 39623083, 39711946, 39660727, 39743956, 39558332, 39675848, 39684855, 39613247, 39514853, 39607061, 39600801, 39747603, 39661435, 39516578, 39593306, 39779043, 39681463, 39366302, 39744314, 39719849, 39710947, 39547870, 39547799, 39516154, 39516569, 39692935, 39627244, 39692946, 39744599, 39681878, 39683300, 39613249, 39681346, 39768560, 39679324, 39442087, 39593254, 39679318, 39768293, 39442080, 39616921, 39744380, 39722175, 39455961, 39628833, 39619077, 39471440, 39556777, 39629617, 39551530, 38715569, 39661307, 39648571, 39681164, 39257921, 39666353, 39747583, 39767488, 39751512, 39692516, 39642107, 39592915, 39592654, 39609842, 39693534, 39657654, 39685502, 39676683, 39377979, 39261739, 39721787, 39644629, 39619549, 39642424, 39722198, 39702571, 39721645, 39593201, 39703225, 39704167, 39471437, 39658849, 39743733, 39696421, 39726796, 39661021, 39666167, 39592056, 39693354, 39437932, 39611244, 39712262, 39557340, 39379320, 39569405, 39627248, 39697727, 39697731, 39698156, 39684867, 39477003, 39258627, 39743997, 39707052, 39679797, 39709946, 39612645, 39747598, 39711261, 38945536, 39609978, 39612609, 39716070, 39762414, 39751213, 39789646, 39713679, 39704972, 39703029, 39681784, 39751145, 39657770, 39603489, 39603493, 39593607, 39735344, 39647664, 39482659, 39720346, 39636728, 39609986, 39694592, 39675791, 39660872, 39691716, 39592012, 39592018, 39437902, 39729003, 39714550, 39711950, 39644312, 39715530, 39658959, 39743104, 39592051, 39481789, 39553586, 39744660, 39532615, 39617038, 39751682, 39712100, 39727984, 39692472, 39632540, 39547769, 39598732, 39508773, 39716700, 39706752, 39689800, 39639033, 39615168, 39661334, 39615253, 39659810, 39684853, 39613294, 39261723, 39699447, 39669681, 39744627, 39570910, 39699456, 39660158, 39417120, 39683663, 39707695, 38962626, 39393922, 39768257, 39726412, 38462973, 39655712, 32589587, 39720094, 39709677, 39747543, 39625119, 39665988, 39743790, 39683827, 39694645, 39481659, 39728959, 39662992, 39456287, 39514670, 39740170, 39667760, 39713218, 39709770, 39610199, 39439635, 39311629, 39600755, 39643785, 39675768, 39547569, 39549669, 39762002, 39752091, 39589639, 39675890, 39780368, 39767120, 39696683, 39627441, 39598570, 39715042, 39573604, 39642313, 39360429, 39716698, 39683659, 39344610, 39737060, 39570166, 39722179, 39735294, 39652543, 39747092, 39596018, 39716408, 39721992, 39684901, 39743977, 39613221, 39798305, 39515522, 39393924, 39593188, 39762335, 39726360, 39744435, 39515774, 39725912, 39516304, 39377974, 39668966, 39698958, 39643551, 39747104, 39596005, 39604092, 39644548, 39515521, 39751732, 39657921, 39709511, 39365574, 39341479, 39668443, 39175478, 39454770, 39758370, 39514253, 39725838, 39716121, 39610201, 38588245, 39547877, 39720701, 39802186, 39600862, 39710447, 39708061, 39642055, 39595432, 39589451, 39648214, 39681356, 39747897, 39605005, 39728047, 39412267, 39644158, 39660731, 39734254, 39498192, 39704634, 39800347, 39800342, 39668246, 39756521, 39516362, 39596021, 39595611, 39774710, 39747204, 39386208, 39219010, 39138183, 39570832, 39770548, 39542704, 39684961, 39688876, 39595430, 39589873, 39658987, 39593019, 39781169, 39603659, 39765567, 39411771, 39762036, 39359188, 39218679, 39707517, 39548070, 39446969, 38899611, 39342434, 39270959, 39624229, 39366528, 32578929, 39519171, 39234547, 39801034, 39758418, 39548279, 39377235, 39692883, 39726240, 39548197, 39744744, 39551462, 39732995, 39663888, 39698062, 39794894, 39583254, 39366307, 39482277, 39666103, 39744839, 39766800, 39758417, 39758205, 39758202, 32589765, 39771017, 39751282, 39751347, 39685015, 39790035, 39667328, 39774683, 39744231, 39475577, 39761778, 39752094, 39503667, 38922011, 39696889, 39735621, 39548330, 39628340, 39626204, 38940790, 39657934, 39750853, 39753729, 39763697, 39712375, 39751345, 39779079, 39713595, 39453389, 39730547, 39700600, 32589479, 39700095, 39666246, 39711259, 39734390, 39548052, 39756537, 39668252, 39758201, 39518546, 39699661, 39613157, 39514648, 39779945, 39270957, 39735605, 39694571, 39683841, 39751805, 39589629, 39720893, 39711523, 39789852, 32596042, 39337931, 39475567, 39740058, 39548009, 39098405, 39663561, 39727918, 39695732, 39338583, 39781340, 39708356, 39612289, 39751278, 39763898, 39717011, 39689103, 39752762, 39777998, 39744760, 39764831, 39747827, 39587379, 39727958, 39771042, 39727914, 39656685, 39693957, 39693958, 39572561, 39761595, 39708551, 39752534, 39763877, 39763904, 39628384, 39716983, 39600599, 39730643, 39682390, 39516034, 39746715, 39780812, 38922676, 39777994, 39715679, 39657244, 39693615, 39780797, 39752057, 39780746, 39780693, 39647656, 39597712, 39513823, 39797754, 39797752, 39766919, 39798276, 39699621, 39398779, 39698300, 39718940, 39744745, 39687523, 39721410, 39737103, 39747895, 39520383, 39699297, 39399301, 39702393, 39736804, 39715973, 39651905, 39721481, 38962535, 39798210, 39650964, 39528733, 39797986, 39741813, 39777496, 39730587, 39781609, 39750850, 39798632, 39769925, 39774660, 39770925, 39800904, 39740593, 39700096, 38972167, 39732911, 39798185, 39740187, 39800993, 39702432, 39482881, 39747919, 39419265, 39721119, 39718846, 39736782, 39556519, 39589357, 39659003, 39665983, 39399901, 39569957, 39634581, 39769966, 39544624, 39603667, 39628117, 39634469, 39794697, 39778937, 39700497, 39733047, 39714033, 39736729, 39736723, 39660514, 39360361, 39693123, 39533111, 39719763, 39644569, 39373016, 39703080, 39695854, 39542618, 39622737, 39498039, 39733986, 39801704, 39798549, 39663974, 39691843, 39741733, 39645416, 39600812, 39689533, 39443887, 39422778, 39723083, 39768328, 39542596, 39767298, 39792674, 32596279, 39786672, 39662134, 39712876, 39726581, 39565027, 39726208, 39700610, 39700611, 39626307, 39728546, 39686987, 39802413, 39767300, 39780662, 39498040, 39767043, 39516380, 39763675, 39548395, 39625136, 39752621, 39787636, 39798223, 39693951, 39660013, 39753709, 32596201, 39781021, 39593226, 39639384, 39729324, 32579225, 39351513, 39747002, 39698329, 39744280, 39755940, 39681367, 39746996, 39780562, 39660493, 39360362, 39456333, 39734126, 39808764, 39219069, 39670398, 39817556, 39817555, 39570538, 39248741, 39793118, 39806419, 39777464, 38463469, 39660135, 39700177, 39790226, 39792664, 32596258, 39816695, 39547032, 39683127, 39590138, 39681360, 39393925, 39624290, 39741682, 39599710, 39666987, 39796658, 39792250, 39544516, 39741119, 39789241, 39758086, 39609781, 39752805, 39790256, 39423319, 39615415, 39540991, 39696634, 39770443, 39693648, 39667466, 39797729, 39751120, 39776831, 39802157, 39760246, 39752530, 39615396, 39739961, 39709743, 32588771, 39697074, 39734692, 39810346, 39797091, 39569412, 39797024, 39753893, 39510533, 39748782, 39746887, 32596293, 39797897, 39770421, 39698406, 39720365, 39721616, 39699698, 39737179, 39808994, 39548351, 39613446, 39666386, 39725906, 39656251, 39747219, 39723410, 39515777, 39748876, 39477012, 39764353, 39498087, 39548410, 39757914, 39685116, 32594058, 39767181, 39765510, 39728740, 39780956, 39548204, 39615482, 39756492, 39666385, 39789979, 39722841, 39721634, 39723033, 39797685, 39817298, 39802276, 39548491, 39625110, 39758082, 39548417, 39548376, 39758119, 39753945, 39712135, 39679879, 39790191, 39510572, 39746812, 39648236, 32588768, 39806155, 39761105, 39753188, 39507088, 39781699, 39732595, 39767182, 39717054, 39636786, 39501879, 39433232, 39692478, 39689104, 39255671, 39628466, 39433229, 39767137, 39716846, 39810533, 39737405, 39641522, 39446951, 39746646, 39746959, 39739815, 39746904, 39127870, 39638336, 39751793, 39687515, 39516245, 39751102, 39711283, 39679794, 39613326, 39366303, 39347430, 39729222, 39736688, 39711257, 39711580, 39547888, 39547814, 39399498, 39786960, 39503485, 39808666, 39595701, 39736878, 39756313, 39515677, 39589377, 39711528, 39684978, 39424468, 39750769, 39767123, 39752930, 39764702, 39764694, 39590541, 39644238, 38924277, 39475551, 39644494, 39707738, 39728759, 39662287, 39725442, 39747822, 39779754, 39619119, 39753512, 39374230, 39752946, 39711421, 39710782, 39680126, 39611245, 39709891, 39709870, 39712260, 39589417, 39615355, 39511040, 39691718, 39727949, 39657651, 39674529, 39679855, 39523827, 39800930, 39747056, 39728726, 39617291, 39209109, 39700608, 39750780, 39589625, 39589624, 39277258, 39716103, 39710956, 39751258, 39679695, 39639175, 39780615, 39764738, 39613365, 39410399, 39762466, 39743878, 39609968, 39713685, 39636936, 39787592, 39747805, 39678962, 39719865, 39729092, 39662066, 39780730, 39764898, 39779805, 39719710, 38962632, 39760752, 39716352, 39657884, 39716046, 39716095, 39716723, 39508772, 39690368, 39709537, 39728574, 39569012, 39610017, 39694508, 39752076, 39780789, 39716555, 39566363, 39628360, 39688874, 39767096, 39716798, 39716796, 39613360, 39513836, 39721805, 39770345, 39655931, 39751330, 39603252, 39734268, 39734279, 39733404, 39792996, 39685182, 39398733, 39482582, 32593193, 39834407, 39816862, 39796301, 39810550, 39735159, 39782335, 39596025, 39791754, 39594473, 39775946, 39667334, 39780380, 39721686, 39678739, 39424185, 39802472, 39802414, 32587704, 39638888, 39780905, 39728600, 39589070, 39752854, 39682553, 39795925, 39595728, 39816851, 39543159, 39796366, 39795918, 39834401, 39681490, 32578649, 39816692, 39769941, 39596020, 39570524, 39619452, 39721452, 39747101, 39642298, 32580292, 39621163, 39758263, 39645550, 39735163, 39648865, 39758482, 39758472, 39710462, 39663126, 39735149, 39645576, 39645623, 39717582, 39743415, 39710553, 39775265, 39532861, 39786659, 39630376, 39668001, 39514240, 39658871);

Date: 2025-02-02 17:27:00 Duration: 11ms
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 (41818948, 32236882, 32277622, 32294432, 32230374, 32253068, 32235041, 32220553, 42106433, 32307112, 32203015, 32324641, 32662054, 32262061, 32262957, 32343802, 32294230, 32331717, 32263771, 42173409, 32197551, 32197538, 32180674, 32284132, 41526761, 32206280, 42162323, 42157470, 41856013, 42126650, 32252853, 32195502, 32294992, 32219978, 32206157, 32272886, 32212531, 32211038, 32271833, 41709188, 42175305, 42162165, 32250170, 32271657, 32207385, 32208005, 32207734, 42142544, 42050588, 42144007, 42052900, 41788117, 41730000, 41788411);

Date: 2025-02-02 17:21:53 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 (32331979, 32332082, 32331986);

Date: 2025-02-02 17:21:52 Duration: 9ms

15

163,602

Details

14s527ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,378	164ms	0ms
	01	2,316	163ms	0ms
	02	1,750	124ms	0ms
	03	2,133	160ms	0ms
	04	2,273	166ms	0ms
	05	1,394	94ms	0ms
	06	1,646	103ms	0ms
	07	1,352	82ms	0ms
	08	4,276	288ms	0ms
	09	14,562	1s244ms	0ms
	10	17,316	1s694ms	0ms
	11	18,672	2s247ms	0ms
	12	16,351	1s481ms	0ms
	13	13,104	1s228ms	0ms
	14	12,047	1s103ms	0ms
	15	11,005	954ms	0ms
	16	10,006	869ms	0ms
	17	9,813	616ms	0ms
	18	6,540	448ms	0ms
	19	5,833	546ms	0ms
	20	4,773	388ms	0ms
	21	2,274	187ms	0ms
	22	1,788	166ms	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-02-02 15:13:30 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-02-02 10:54:38 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-02-02 12:58:43 Duration: 1ms

16

148,236

Details

1m25s

0ms

24ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 02	00	1,097	727ms	0ms
	01	938	542ms	0ms
	02	253	139ms	0ms
	03	225	132ms	0ms
	04	176	109ms	0ms
	05	115	72ms	0ms
	06	428	167ms	0ms
	07	802	297ms	0ms
	08	3,014	1s403ms	0ms
	09	8,218	8s447ms	1ms
	10	9,370	6s321ms	0ms
	11	9,866	6s835ms	0ms
	12	12,165	7s385ms	0ms
	13	18,155	9s609ms	0ms
	14	14,377	8s379ms	0ms
	15	8,605	4s571ms	0ms
	16	7,028	3s544ms	0ms
	17	6,108	3s160ms	0ms
	18	10,530	4s847ms	0ms
	19	28,349	14s601ms	0ms
	20	6,701	3s311ms	0ms
	21	906	592ms	0ms
	22	810	482ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4992502, 4690828, 4888034, 4884404, 4913527, 4806455, 4822841, 4834508, 4905387, 4789512, 4313104, 4462505, 4506764, 4636598, 4677421, 4734084, 4769090, 4823089, 4841985, 4850474, 4881354, 4883908, 4896322, 4905914, 4917028, 4888861, 4849729, 4795498, 4870087, 4858379, 4942132, 4512725, 4925236, 4881257, 4892319, 4952334, 4885149, 4965900, 4974291, 4937843, 4890923, 4917671, 4932679, 4937698, 4886801, 4928492, 4932784, 4956419, 4950152, 4882733, 4939541, 4941701, 4846586, 4949338, 4869672, 4913693, 4913786, 4920454, 4921349, 4922309, 4950386, 4950391, 4958272, 4812444, 4951199, 4954633, 4951203, 4956078, 4929699, 4914100, 4956067, 4954947, 4833589, 4903602, 4956073, 4951936, 4749078, 4918516, 4924794, 4776948, 4643509, 4936207, 4946556, 4968589, 4906054, 4929328, 4512729, 4708567, 4891034, 4944573, 4905406, 4928319, 4925795, 4949796, 4929769, 4881018, 4666840, 4926550, 4305287, 4946848, 4646318, 4181837, 4799284, 4536499, 4915911, 4934228, 4657473, 4844633, 4946850, 4905371, 4952125, 4901985, 4961591, 4974022, 4891453, 4924154, 4895142, 4947759, 4945793, 4886356, 4946667, 4887654, 4944613, 4939552, 4929230, 4934427, 4934426, 4905056, 4948576, 4901960, 4934224, 4950528, 4893205, 4926012, 4955383, 4917606, 4951633, 4951620, 4934297, 4939471, 4939433, 4937848, 4941281, 4929542, 4949507, 4937879, 4919235, 4944598, 4723673, 4956074, 4933532, 4930566, 4981358, 4904724, 4965269, 4968108, 4978625, 4916483, 4815129, 4963600, 4961816, 4979828, 4988773, 4965211, 4966319, 4773544, 4923149, 4941148, 4951182, 4951196, 4930456, 4926784, 4905072, 4930546, 4947281, 4946663, 4926845, 4922688, 4912268, 4951443, 4916623, 4914705, 4912868, 4893682, 4896695, 4932486, 4949468, 4939571);

Date: 2025-02-02 17:21:56 Duration: 24ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4888734, 4949501, 4726335, 4750067, 4750072, 4664112, 4664115, 4603379, 3291292, 4575589, 4882061, 4203640, 4749983, 4850689, 4818775, 4231678, 4288023, 4575547, 4818688, 4920802, 4888833, 1162070, 4920766, 4882095, 4826307, 4857237, 4920710, 4663868, 4726414, 4750070, 4750069, 4726413, 4826398, 4726337, 4850705, 4850704, 4726411, 4857193, 3684333, 3684331, 2063732, 3684332, 4949505, 4726313, 4798203, 4949503, 4631854, 4882090, 4818716, 4862569, 4888776, 4818718, 4818709, 4750025, 4750019, 4750022, 4750024, 4750017, 4750037, 4750027, 4750020, 4750039, 4750029, 4631915, 4631913, 4631931, 4631921, 4920663, 4922062, 4922065, 4830821, 4830827, 4432214, 4882051, 4764999, 4882053, 4432216, 4818804, 4949510, 4949507, 4888760, 4797682, 4920727, 4818851, 4882057, 4818799, 4818841, 4888720, 4818807, 4882056, 4882058, 4882055, 4857110, 4825948, 4749946, 4773678, 4773679, 4920752, 4797629, 4749991, 4151263, 4826294, 3835074, 4231675, 3966936, 4151260, 4826293, 3966935, 4862560, 4575556, 4575552, 4749992, 4862562, 4384659, 3607427, 4888730, 4850668, 4818707, 4344132, 4343818, 4726428, 4797674, 4857213, 4818787, 4691326, 4749996, 4749998, 4632202, 4691419, 4856610, 1762997, 4857052, 4857057, 4797634, 4153013, 4910713, 4603399, 4603401, 4857146, 4282230, 4920657, 4882073, 4814124, 4575491, 4862587, 4888795, 4888788, 4888793, 4798212, 4888800, 4888727, 4922034, 4922026, 4797720, 4862618, 4862598, 4862607, 4826318, 4888786, 4857101, 4922047, 4920717, 4797598, 4797593, 4882080, 4850657, 4882049, 4850665, 4882064, 4920807, 4857231, 4920813, 4920809);

Date: 2025-02-02 17:22:00 Duration: 18ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1220751, 2826085, 1761967, 1668548, 1354786, 1792279, 1489772, 1742868, 2026377, 3075330, 1830622, 1830452, 1429622, 1830545, 3712854, 1752859, 1957944, 1273797, 1801305, 1789877, 1810835, 1725383, 1710159, 1829106, 1469772, 1882294, 1802115, 1788759, 1573235, 1762660, 2099540, 2267554, 1612649, 1707730, 1740521, 1708525, 1705697, 1259357, 1722984, 1690398, 712346, 1830430, 1881612, 1343545, 1723914, 1748420, 1765301, 1282201, 1728103, 1758715, 1697778, 2338526, 1713548, 1881778, 4381300, 1593075, 1583362, 1762690, 1792621, 1755048, 1762681, 1926124, 2031805, 1762689, 1830560, 1828966, 1985122, 2153066, 2148602, 2195117, 2180359, 2197215, 1792805, 2133479, 2090657, 2121546, 2121804, 2194963, 2073874, 2122405, 2151834, 1835801, 1792914, 1824536, 1656962, 1761961, 1796429, 1614391, 1614445, 1051288, 1755066, 1755067, 1690102, 1668064, 1700082, 1985200, 1829064, 1835957, 1742552, 1692366, 1830572, 1835845, 1197354, 1835948, 1784091, 1470247, 1470108, 1470514, 1470101, 1527320, 1395035, 1333624, 1557444, 1566984, 1527419, 1570652, 1614928, 1792567, 1949042, 1761950, 1989527, 1761502, 1796342, 1830532, 1429773, 1795266, 1792581, 1663802, 1663818, 1830580, 1762713, 1659351, 1569376, 1659352, 1602906, 1794994, 4381411, 1742737, 1698585, 2188291, 1855444, 1527646, 1695496, 1796095, 1473449, 1667922, 2156644, 1836227, 1811418, 1855443, 1532652, 1791194, 1687921, 1555470, 1613776, 1806648, 1827975, 1863455, 1823071, 1767039, 1833132, 1845778, 1799675, 1830017, 1845568, 1742634, 1795264, 1761402, 1849445, 1821573, 1516744, 1857737, 1773716, 1729235, 2903709, 4377426, 3866804, 1273804, 1404953, 1337370, 4014278, 1611237, 1835841, 1796418, 1668069, 1796494, 1762769, 2956216, 1705315, 3251915, 3337405, 1527532, 1317742, 1684859, 1638186, 1616555, 1326852, 1391427, 4241368, 3549545);

Date: 2025-02-02 17:22:21 Duration: 18ms

17

146,412

Details

9s54ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	1,063	55ms	0ms
	01	659	33ms	0ms
	02	517	26ms	0ms
	03	490	25ms	0ms
	04	305	15ms	0ms
	05	342	17ms	0ms
	06	600	31ms	0ms
	07	548	27ms	0ms
	08	4,551	231ms	0ms
	09	7,543	434ms	0ms
	10	17,737	1s157ms	0ms
	11	17,161	1s190ms	0ms
	12	17,290	1s192ms	0ms
	13	15,075	980ms	0ms
	14	12,214	760ms	0ms
	15	8,469	474ms	0ms
	16	11,303	603ms	0ms
	17	9,511	536ms	0ms
	18	5,568	320ms	0ms
	19	6,368	436ms	0ms
	20	5,100	297ms	0ms
	21	2,534	128ms	0ms
	22	1,464	76ms	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-02-02 10:43:34 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-02-02 10:55:00 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-02-02 18:41:03 Duration: 0ms

18

142,094

Details

2h14m29s

39ms

302ms

56ms

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,731	2m25s	53ms
	01	3,093	2m43s	52ms
	02	2,701	2m24s	53ms
	03	3,149	2m47s	53ms
	04	2,635	2m19s	52ms
	05	1,412	1m13s	52ms
	06	2,067	1m50s	53ms
	07	1,282	1m8s	53ms
	08	2,640	2m20s	53ms
	09	7,341	6m54s	56ms
	10	10,880	11m17s	62ms
	11	17,583	19m14s	65ms
	12	16,723	17m35s	63ms
	13	10,818	10m55s	60ms
	14	8,142	7m46s	57ms
	15	7,807	7m10s	55ms
	16	6,738	6m6s	54ms
	17	7,073	5m52s	49ms
	18	7,138	5m40s	47ms
	19	7,191	6m27s	53ms
	20	7,172	5m48s	48ms
	21	2,989	2m18s	46ms
	22	2,789	2m8s	46ms

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

Date: 2025-02-02 11:04:35 Duration: 302ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4700335)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 12:54:22 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4985148)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 19:21:29 Duration: 298ms

19

140,660

Details

18s667ms

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
Feb 02	00	1,006	112ms	0ms
	01	646	69ms	0ms
	02	506	55ms	0ms
	03	484	52ms	0ms
	04	302	31ms	0ms
	05	332	35ms	0ms
	06	588	64ms	0ms
	07	542	56ms	0ms
	08	4,464	481ms	0ms
	09	7,420	908ms	0ms
	10	17,189	2s445ms	0ms
	11	16,360	2s474ms	0ms
	12	16,670	2s493ms	0ms
	13	14,335	1s999ms	0ms
	14	11,478	1s528ms	0ms
	15	8,196	978ms	0ms
	16	10,906	1s226ms	0ms
	17	9,200	1s95ms	0ms
	18	5,429	659ms	0ms
	19	6,134	912ms	0ms
	20	4,656	570ms	0ms
	21	2,393	255ms	0ms
	22	1,424	158ms	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 (97) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-02 11:14:39 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-02 11:06:12 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-02 16:20:16 Duration: 1ms

20

131,563

Details

43s307ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 02	00	7,694	2s499ms	0ms
	01	5,447	1s860ms	0ms
	02	5,374	1s864ms	0ms
	03	8,059	2s562ms	0ms
	04	5,332	1s835ms	0ms
	05	3,670	1s324ms	0ms
	06	2,225	754ms	0ms
	07	580	265ms	0ms
	08	930	429ms	0ms
	09	1,653	731ms	0ms
	10	1,861	1s5ms	0ms
	11	3,526	1s809ms	0ms
	12	1,619	799ms	0ms
	13	2,545	1s108ms	0ms
	14	2,499	844ms	0ms
	15	5,152	1s611ms	0ms
	16	7,502	2s274ms	0ms
	17	8,152	2s408ms	0ms
	18	11,351	3s424ms	0ms
	19	14,342	4s881ms	0ms
	20	12,759	3s790ms	0ms
	21	8,621	2s340ms	0ms
	22	10,670	2s879ms	0ms

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

Date: 2025-02-02 18:37:04 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 22) AND ("price_list"."to_office_id" = 8)) ORDER BY "price_list"."id";

Date: 2025-02-02 17:45:52 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 3) AND ("price_list"."to_office_id" = 46)) ORDER BY "price_list"."id";

Date: 2025-02-02 17:22:20 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

27m1s

44s324ms

247

Details

3h2m28s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 02	00	3	0ms	0ms
	01	2	0ms	0ms
	02	1	0ms	0ms
	03	1	0ms	0ms
	06	4	0ms	0ms
	07	2	0ms	0ms
	08	15	4m10s	16s711ms
	09	20	16ms	0ms
	10	36	19m28s	32s461ms
	11	21	33ms	1ms
	12	22	11m19s	30s886ms
	13	15	20ms	1ms
	14	20	9m3s	27s161ms
	15	14	7ms	0ms
	16	11	18m21s	1m40s
	17	16	13m20s	50s48ms
	18	8	4ms	0ms
	19	10	12ms	1ms
	20	13	1h46m44s	8m12s
	21	3	1ms	0ms
	22	10	2ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 19:52:19.387441', "last_update" = '2025-02-02 19:07:19.387467', "sid" = '63ca13d4777217da4795fc4a82da26acdac57834', "write_date" = '2025-02-02 19:07:19.060311', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 27m1s
UPDATE "res_users" SET "exp_date" = '2025-02-02 19:52:59.026421', "last_update" = '2025-02-02 19:07:59.026440', "sid" = '63ca13d4777217da4795fc4a82da26acdac57834', "write_date" = '2025-02-02 19:07:58.691426', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 26m21s
UPDATE "res_users" SET "exp_date" = '2025-02-02 19:59:49.038166', "last_update" = '2025-02-02 19:14:49.038187', "sid" = 'cc6fa9ccb1e54e0b7903816ec46db8bcdbbc1f51', "write_date" = '2025-02-02 19:14:48.693428', "write_uid" = 1 WHERE id IN (928);

Date: 2025-02-02 20:34:20 Duration: 19m31s

2

0ms

13m4s

34s291ms

40

Details

22m51s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 02	04	1	0ms	0ms
	08	3	1ms	0ms
	09	5	6ms	1ms
	10	7	17m2s	2m26s
	11	2	2ms	1ms
	12	3	5m49s	1m56s
	13	2	3ms	1ms
	14	4	7ms	1ms
	15	2	0ms	0ms
	16	2	1ms	0ms
	19	3	3ms	1ms
	21	3	1ms	0ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 10:14:16.266721', "last_update" = '2025-02-02 09:29:16.266751', "write_date" = '2025-02-02 09:29:15.918745', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-02 10:42:20 Duration: 13m4s
UPDATE "res_users" SET "exp_date" = '2025-02-02 12:38:31.312382', "last_update" = '2025-02-02 11:53:31.312405', "write_date" = '2025-02-02 11:53:30.934908', "write_uid" = 1 WHERE id IN (959);

Date: 2025-02-02 12:59:20 Duration: 5m49s
UPDATE "res_users" SET "exp_date" = '2025-02-02 10:09:22.421535', "last_update" = '2025-02-02 09:24:22.421558', "write_date" = '2025-02-02 09:24:22.095449', "write_uid" = 965 WHERE id IN (965);

Date: 2025-02-02 10:28:20 Duration: 3m57s

3

0ms

40m26s

4s391ms

61,003

Details

3d2h25m10s

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
Feb 02	00	700	152ms	0ms
	01	712	153ms	0ms
	02	861	182ms	0ms
	03	938	1m56s	123ms
	04	893	186ms	0ms
	05	592	124ms	0ms
	06	410	90ms	0ms
	07	400	83ms	0ms
	08	1,595	1h7m11s	2s527ms
	09	4,111	2h44m55s	2s407ms
	10	6,866	10h5m10s	5s288ms
	11	6,977	8h2m24s	4s148ms
	12	6,612	4h50m35s	2s636ms
	13	5,191	9h47m36s	6s791ms
	14	4,530	1h54m58s	1s522ms
	15	4,266	1m39s	23ms
	16	3,993	14h42m48s	13s265ms
	17	3,452	8h35m32s	8s960ms
	18	2,357	566ms	0ms
	19	2,150	6h27m55s	10s825ms
	20	1,796	6h2m22s	12s106ms
	21	911	209ms	0ms
	22	690	164ms	0ms

update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703804', exp_date = '2025-02-02 15:09:53.703808', logged_in = 'TRUE' where id = 856;

Date: 2025-02-02 16:05:20 Duration: 40m26s
update res_users set sid = 'a357c2557e5bcc29705fc501641e2556f3319e2c', last_update = '2025-02-02 14:24:53.703717', exp_date = '2025-02-02 15:09:53.703721', logged_in = 'TRUE' where id = 856;

Date: 2025-02-02 16:05:20 Duration: 40m26s
update res_users set sid = '9379f3c79c1ce45716db9801c5501408f7bc14bf', last_update = '2025-02-02 12:19:08.846300', exp_date = '2025-02-02 13:04:08.846303', logged_in = 'TRUE' where id = 867;

Date: 2025-02-02 13:59:21 Duration: 40m12s

4

222ms

1s953ms

740ms

10,959

Details

2h15m15s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 02	00	372	4m15s	686ms
	01	432	4m9s	577ms
	02	77	1m8s	890ms
	03	391	1m38s	252ms
	04	240	1m4s	268ms
	08	11	9s622ms	874ms
	09	21	19s943ms	949ms
	10	14	12s838ms	917ms
	11	164	2m48s	1s27ms
	12	107	1m24s	793ms
	13	144	2m9s	900ms
	14	450	2m37s	350ms
	15	482	6m13s	775ms
	16	722	9m40s	804ms
	17	512	5m25s	636ms
	18	1,098	14m53s	813ms
	19	1,500	23m24s	936ms
	20	1,950	23m36s	726ms
	21	1,149	15m4s	786ms
	22	1,123	14m56s	798ms

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

Date: 2025-02-02 11:44:44 Duration: 1s953ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '144762')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-02 19:21:18 Duration: 1s859ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '144768')) 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 (41))))))) 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 (41)))))) 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 (41)))))) 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 (41))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-02 19:21:38 Duration: 1s751ms

5

525ms

5s47ms

653ms

44,703

Details

8h6m32s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 02	00	141	1m33s	661ms
	01	124	1m24s	678ms
	02	193	2m8s	664ms
	03	206	2m15s	657ms
	04	165	1m48s	658ms
	05	179	1m49s	609ms
	06	170	1m45s	617ms
	07	478	4m34s	573ms
	08	1,010	9m42s	576ms
	09	3,564	36m14s	610ms
	10	4,306	51m7s	712ms
	11	4,665	58m13s	748ms
	12	5,569	1h4m47s	698ms
	13	3,734	41m43s	670ms
	14	4,045	42m40s	633ms
	15	3,866	39m12s	608ms
	16	2,927	29m18s	600ms
	17	2,739	27m14s	596ms
	18	2,398	23m44s	594ms
	19	1,848	21m25s	695ms
	20	1,497	15m15s	611ms
	21	579	5m36s	581ms
	22	300	2m56s	586ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4943108, 4916378, 4909594, 4893629, 4886389, 4881560)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 12:34:26 Duration: 5s47ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4958542, 4955535, 4955532, 4955521, 4955517, 4955512, 4952873, 4951917, 4951202, 4950073, 4947326, 4941531, 4941522, 4941520, 4941494, 4941481, 4939389, 4938702, 4937446, 4937029, 4931964, 4928504, 4927805, 4927167, 4926793, 4926128, 4924694, 4922969, 4919699, 4919234, 4918324, 4917005, 4916538, 4911011)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:04 Duration: 4s967ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4989390, 4989389, 4989388, 4989387, 4989386, 4989385, 4989384, 4989383, 4989382, 4989381)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:05:16 Duration: 4s690ms

6

522ms

4s891ms

631ms

249,588

Details

1d19h45m20s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Feb 02	00	8,257	1h20m26s	584ms
	01	7,955	1h16m14s	574ms
	02	8,017	1h16m25s	572ms
	03	8,905	1h26m5s	580ms
	04	7,765	1h13m53s	570ms
	05	5,558	52m42s	568ms
	06	4,185	39m28s	566ms
	07	2,254	20m52s	555ms
	08	4,543	42m29s	561ms
	09	11,514	1h55m45s	603ms
	10	15,857	2h59m1s	677ms
	11	22,657	4h30m44s	716ms
	12	20,427	3h53m22s	685ms
	13	17,525	3h12m19s	658ms
	14	13,853	2h24m44s	626ms
	15	10,457	1h46m28s	610ms
	16	9,536	1h36m46s	608ms
	17	9,566	1h36m26s	604ms
	18	12,256	2h4m41s	610ms
	19	22,307	4h9m37s	671ms
	20	15,171	2h35m16s	614ms
	21	5,441	54m27s	600ms
	22	5,582	56m56s	612ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4952017)) AND (("shipping_track"."id" not in (41028900, 41029021, 41051794, 41051897, 41104725, 41105078, 41335171, 41335171)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:18 Duration: 4s891ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4971731)) AND (("shipping_track"."id" not in (41211462, 41237675, 41265102, 41265125, 41297854, 41313464, 41335025, 41335025)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:06 Duration: 4s862ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4951100)) AND (("shipping_track"."id" not in (41024968, 41025203, 41025347, 41055763, 41055798, 41166959, 41335379, 41335379)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-02 11:04:36 Duration: 4s856ms

7

407ms

995ms

578ms

2,082

Details

20m4s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 02	08	2	881ms	440ms
	10	13	7s362ms	566ms
	11	464	4m40s	605ms
	12	691	6m49s	593ms
	13	300	2m43s	544ms
	14	398	3m46s	569ms
	15	152	1m23s	549ms
	16	62	31s840ms	513ms

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

Date: 2025-02-02 11:43:01 Duration: 995ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '29290')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-02 11:44:39 Duration: 904ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '29285')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-02 11:44:31 Duration: 885ms

8

180ms

2s509ms

299ms

19,554

Details

1h37m29s

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
Feb 02	08	918	3m52s	253ms
	09	1,590	7m26s	281ms
	10	3,438	17m9s	299ms
	11	1,064	5m44s	323ms
	12	2,194	12m3s	329ms
	13	1,989	9m27s	285ms
	14	1,842	9m8s	297ms
	15	2,751	14m48s	323ms
	16	2,165	9m58s	276ms
	17	1,589	7m42s	291ms
	18	14	6s239ms	445ms

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

Date: 2025-02-02 11:04:45 Duration: 2s509ms
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" = '9974535')))) ORDER BY "collection_policy"."id";

Date: 2025-02-02 11:04:47 Duration: 2s173ms
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" = '93291')))) ORDER BY "collection_policy"."id";

Date: 2025-02-02 10:57:21 Duration: 1s750ms

9

215ms

2s18ms

293ms

16,655

Details

1h21m30s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 02	00	1,032	4m43s	274ms
	01	440	2m4s	282ms
	02	691	3m4s	266ms
	03	1,086	4m56s	272ms
	04	537	2m26s	273ms
	05	444	2m	270ms
	06	346	1m34s	273ms
	08	2	527ms	263ms
	09	144	42s941ms	298ms
	10	122	38s974ms	319ms
	11	268	1m39s	369ms
	12	94	34s623ms	368ms
	13	222	1m7s	306ms
	14	122	37s515ms	307ms
	15	808	4m8s	307ms
	16	1,131	5m37s	298ms
	17	1,533	7m30s	293ms
	18	1,760	8m51s	301ms
	19	2,066	11m22s	330ms
	20	1,244	6m4s	292ms
	21	1,018	4m37s	272ms
	22	1,545	7m7s	276ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '109883')) 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-02-02 11:04:28 Duration: 2s18ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '180493')) 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-02-02 19:22:21 Duration: 1s945ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '171309')) 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-02-02 11:16:34 Duration: 1s458ms

10

90ms

850ms

240ms

54,673

Details

3h39m24s

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

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,788	10m47s	232ms
	01	1,728	6m3s	210ms
	02	1,528	5m21s	210ms
	03	2,936	10m12s	208ms
	04	1,540	5m37s	219ms
	05	882	3m9s	214ms
	06	684	2m35s	227ms
	08	24	6s481ms	270ms
	09	320	1m10s	221ms
	10	258	1m9s	268ms
	11	840	3m31s	251ms
	12	394	1m52s	284ms
	13	728	3m9s	260ms
	14	1,121	4m14s	226ms
	15	2,532	9m57s	236ms
	16	3,680	15m26s	251ms
	17	4,046	16m29s	244ms
	18	5,648	23m48s	252ms
	19	7,081	31m33s	267ms
	20	6,325	25m24s	240ms
	21	4,290	16m8s	225ms
	22	5,300	21m33s	244ms

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-02-02 19:19:04 Duration: 850ms
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-02-02 19:19:04 Duration: 846ms
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-02-02 11:04:07 Duration: 840ms

11

170ms

1s447ms

230ms

3,734

Details

14m20s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 02	05	452	1m24s	187ms
	06	144	27s393ms	190ms
	10	1,292	5m7s	237ms
	11	1,812	7m12s	238ms
	12	34	8s400ms	247ms

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

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

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

Date: 2025-02-02 11:15:56 Duration: 1s114ms

12

166ms

1s532ms

220ms

125,778

Details

7h41m19s

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
Feb 02	00	1,374	4m21s	190ms
	01	2,217	6m56s	187ms
	02	2,211	6m58s	189ms
	03	2,069	6m28s	187ms
	04	2,384	7m27s	187ms
	05	2,053	6m25s	187ms
	06	1,039	3m13s	186ms
	07	441	1m22s	188ms
	08	3,425	10m41s	187ms
	09	4,781	15m53s	199ms
	10	8,856	33m16s	225ms
	11	9,009	35m38s	237ms
	12	10,087	39m10s	233ms
	13	16,401	59m41s	218ms
	14	9,035	32m13s	214ms
	15	4,934	16m19s	198ms
	16	4,681	15m29s	198ms
	17	3,021	10m4s	200ms
	18	10,395	37m50s	218ms
	19	24,906	1h43m20s	248ms
	20	1,675	5m53s	210ms
	21	549	1m47s	195ms
	22	235	45s55ms	191ms

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

Date: 2025-02-02 19:21:20 Duration: 1s532ms
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" = '203256')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-02 11:00:59 Duration: 1s490ms
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" = '111652')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-02 19:21:35 Duration: 1s448ms

13

170ms

1s496ms

211ms

15,875

Details

55m54s

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
Feb 02	00	37	7s17ms	189ms
	01	3	570ms	190ms
	04	9	1s709ms	189ms
	05	565	1m45s	186ms
	06	846	2m37s	186ms
	07	441	1m23s	188ms
	08	1,639	5m7s	187ms
	09	1,843	6m5s	198ms
	10	1,224	4m35s	225ms
	11	3,105	12m28s	240ms
	12	959	3m39s	228ms
	13	960	3m31s	220ms
	14	1,027	3m31s	205ms
	15	335	1m5s	195ms
	16	262	50s732ms	193ms
	17	67	13s425ms	200ms
	19	155	35s523ms	229ms
	20	1,662	5m51s	211ms
	21	548	1m47s	196ms
	22	188	36s103ms	192ms

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

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

Date: 2025-02-02 11:04:35 Duration: 1s31ms

14

16ms

2s504ms

195ms

6,222

Details

20m13s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 02	00	3	60ms	20ms
	01	1	18ms	18ms
	07	6	801ms	133ms
	08	53	11s718ms	221ms
	09	3,338	8m2s	144ms
	10	861	2m23s	166ms
	11	296	1m34s	317ms
	12	326	1m45s	324ms
	13	310	1m43s	335ms
	14	340	1m15s	222ms
	15	215	53s47ms	246ms
	16	139	39s75ms	281ms
	17	110	32s666ms	296ms
	18	88	23s149ms	263ms
	19	68	28s773ms	423ms
	20	47	14s152ms	301ms
	21	12	2s724ms	227ms
	22	9	2s283ms	253ms

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

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

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

Date: 2025-02-02 10:58:58 Duration: 2s13ms

15

167ms

235ms

188ms

10,988

Details

34m30s

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
Feb 02	00	1,285	4m4s	190ms
	01	2,046	6m24s	187ms
	02	2,105	6m38s	189ms
	03	2,069	6m28s	187ms
	04	2,376	7m26s	187ms
	05	1,011	3m10s	188ms
	06	49	9s120ms	186ms
	22	47	9s8ms	191ms

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" = '72999')) 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-02-02 04:05:44 Duration: 235ms
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" = '251428')) 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-02-02 00:12:55 Duration: 232ms
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '268152')) 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-02-02 04:05:44 Duration: 231ms

16

121ms

1s190ms

167ms

5,813

Details

16m12s

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
Feb 02	00	10	1s303ms	130ms
	07	5	663ms	132ms
	08	85	11s336ms	133ms
	09	388	56s98ms	144ms
	10	870	2m25s	167ms
	11	1,498	4m42s	188ms
	12	1,264	3m38s	173ms
	13	498	1m19s	159ms
	14	289	42s741ms	147ms
	15	173	24s982ms	144ms
	16	131	18s542ms	141ms
	17	204	29s454ms	144ms
	18	79	11s913ms	150ms
	19	77	13s143ms	170ms
	20	73	11s422ms	156ms
	21	125	18s49ms	144ms
	22	44	6s413ms	145ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) 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-02-02 11:04:06 Duration: 1s190ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 127)) 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-02-02 11:04:33 Duration: 1s185ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-02-02 10:59:43 Duration: 1s184ms

17

96ms

831ms

126ms

17,084

Details

35m54s

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
Feb 02	00	69	7s368ms	106ms
	05	21	2s366ms	112ms
	07	45	5s248ms	116ms
	08	244	27s704ms	113ms
	09	1,162	2m21s	121ms
	10	1,628	3m36s	132ms
	11	1,817	4m17s	141ms
	12	2,201	4m55s	134ms
	13	2,331	4m55s	126ms
	14	2,058	4m13s	122ms
	15	1,883	3m41s	117ms
	16	1,053	2m2s	116ms
	17	1,166	2m13s	114ms
	18	503	1m1s	122ms
	19	396	52s567ms	132ms
	20	350	42s944ms	122ms
	21	121	13s924ms	115ms
	22	36	4s281ms	118ms

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

Date: 2025-02-02 10:57:11 Duration: 831ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8074028)) AND (("cash_track"."id" not in (7614426)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-02 11:04:06 Duration: 823ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8074045)) AND (("cash_track"."id" not in (7614445)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-02 11:05:11 Duration: 771ms

18

47ms

350ms

62ms

38,245

Details

40m8s

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
Feb 02	06	56	3s105ms	55ms
	07	13	768ms	59ms
	08	1,344	1m15s	55ms
	09	2,213	2m13s	60ms
	10	3,240	3m32s	65ms
	11	2,667	3m19s	74ms
	12	8,693	9m29s	65ms
	13	4,128	4m21s	63ms
	14	5,212	5m23s	61ms
	15	3,943	3m55s	59ms
	16	3,637	3m35s	59ms
	17	2,646	2m32s	57ms
	18	345	20s127ms	58ms
	19	70	4s623ms	66ms
	20	21	1s258ms	59ms
	21	5	288ms	57ms
	22	12	680ms	56ms

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

Date: 2025-02-02 10:57:15 Duration: 350ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4872871) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-02-02 11:00:58 Duration: 333ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4890264) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-02 12:34:21 Duration: 328ms

19

42ms

114ms

57ms

15,754

Details

15m1s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 02	08	629	32s172ms	51ms
	09	1,049	57s853ms	55ms
	10	2,101	2m13s	63ms
	11	1,219	1m14s	60ms
	12	1,998	1m59s	59ms
	13	1,878	1m50s	59ms
	14	1,906	1m47s	56ms
	15	2,115	1m54s	53ms
	16	1,734	1m34s	54ms
	17	1,112	57s179ms	51ms
	18	13	656ms	50ms

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

Date: 2025-02-02 11:00:52 Duration: 114ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4852564) ORDER BY "collection_policy"."id";

Date: 2025-02-02 10:57:57 Duration: 104ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4702070) ORDER BY "collection_policy"."id";

Date: 2025-02-02 12:31:54 Duration: 103ms

20

39ms

302ms

56ms

142,094

Details

2h14m29s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 02	00	2,731	2m25s	53ms
	01	3,093	2m43s	52ms
	02	2,701	2m24s	53ms
	03	3,149	2m47s	53ms
	04	2,635	2m19s	52ms
	05	1,412	1m13s	52ms
	06	2,067	1m50s	53ms
	07	1,282	1m8s	53ms
	08	2,640	2m20s	53ms
	09	7,341	6m54s	56ms
	10	10,880	11m17s	62ms
	11	17,583	19m14s	65ms
	12	16,723	17m35s	63ms
	13	10,818	10m55s	60ms
	14	8,142	7m46s	57ms
	15	7,807	7m10s	55ms
	16	6,738	6m6s	54ms
	17	7,073	5m52s	49ms
	18	7,138	5m40s	47ms
	19	7,191	6m27s	53ms
	20	7,172	5m48s	48ms
	21	2,989	2m18s	46ms
	22	2,789	2m8s	46ms

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

Date: 2025-02-02 11:04:35 Duration: 302ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4700335)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 12:54:22 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4985148)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-02 19:21:29 Duration: 298ms

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

17,243,416 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	5	0.00%
DETAIL	11	0.00%
ERROR	3,501	0.02%
EVENTLOG	847	0.00%
FATAL	672	0.00%
HINT	3	0.00%
LOG	17,234,855	99.95%
STATEMENT	3,522	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
672 FATAL entries
3501 ERROR entries
0 WARNING entries
847 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,838 Max number of times the same event was reported
5,020 Total events found

Rank

Times reported

Error

1

1,838

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 02	00	5
	01	7
	02	3
	03	4
	04	2
	05	14
	06	2
	07	9
	08	55
	09	106
	10	235
	11	236
	12	252
	13	202
	14	178
	15	100
	16	87
	17	66
	18	54
	19	129
	20	65
	21	16
	22	11

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

2

1,633

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 02	00	5
	01	2
	02	2
	03	3
	04	1
	05	12
	06	2
	07	9
	08	52
	09	99
	10	225
	11	211
	12	224
	13	169
	14	151
	15	89
	16	82
	17	63
	18	44
	19	105
	20	56
	21	16
	22	11

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

3

560

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 02	08	31
	09	25
	10	134
	11	84
	12	70
	13	51
	14	21
	16	65
	17	28
	19	24
	20	27

LOG: could not send data to client: Broken pipe

4

560

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 02	08	31
	09	25
	10	134
	11	84
	12	70
	13	51
	14	21
	16	65
	17	28
	19	24
	20	27

FATAL: connection to client lost

5

189

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 02	08	2
	09	7
	10	35
	11	37
	12	32
	13	13
	14	7
	16	32
	17	6
	19	7
	20	11

6

97

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 02	08	1
	09	3
	10	16
	11	18
	12	15
	13	8
	14	5
	16	20
	17	2
	19	5
	20	4

7

76

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 02	17	76

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

8

13

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 02	05	2
	10	6
	12	1
	17	2
	21	2

ERROR: syntax error at or near ")" at character 241
ERROR: syntax error at or near ")" at character 162
ERROR: syntax error at or near ")" at character 163

9

12

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 02	17	12

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

9

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 02	14	1
	17	8

11

8

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 02	09	2
	10	2
	11	1
	12	1
	13	2

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

12

6

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 02	17	6

13

4

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Feb 02	09	1
	12	1
	19	1
	22	1

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

14

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 02	11	1
	12	1
	17	1

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

15

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Feb 02	00	1
	07	1
	10	1

16

2

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 02	07	1
	10	1

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 02	17	2

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

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 02	07	1
	10	1

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 02	00	1
	16	1

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Feb 02	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables