pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jan 24 23:46:44 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 24,447,939 log entries in 1m43s
Log start from 2025-01-24 00:00:00 to 2025-01-24 22:45:01

Global Stats

12,398 Number of unique normalized queries
10,651,822 Number of queries
4d8h14m42s Total query duration
2025-01-24 00:00:00 First query
2025-01-24 22:45:01 Last query
3,742 queries/s at 2025-01-24 13:33:14 Query peak

4d8h14m42s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
4d8h14m42s Execute total duration

2,884 Number of events
23 Number of unique normalized events
771 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
10,651,822 Average queries per session
4d8h14m42s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

3,742 queries/s Query Peak
2025-01-24 13:33:14 Date

SELECT Traffic

Key values

2,204 queries/s Query Peak
2025-01-24 13:33:14 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,477 queries/s Query Peak
2025-01-24 13:33:14 Date

Queries duration

Key values

4d8h14m42s Total query duration

Prepared queries ratio

Key values

0.00 Ratio of bind vs prepare
0.00 % Ratio between prepared and "usual" statements

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 24	00	328,112	0ms	1m40s	23ms	3m48s	4m14s	4m28s
	01	274,774	0ms	16s986ms	25ms	3m9s	3m43s	5m3s
	02	261,006	0ms	39s571ms	27ms	4m11s	4m16s	6m25s
	03	308,027	0ms	41s133ms	31ms	4m31s	5m5s	6m27s
	04	203,812	0ms	790ms	24ms	2m20s	4m10s	4m25s
	05	116,116	0ms	727ms	17ms	1m12s	1m41s	2m14s
	06	133,701	0ms	814ms	23ms	2m9s	2m22s	2m30s
	07	83,963	0ms	957ms	10ms	38s34ms	47s311ms	1m16s
	08	219,931	0ms	976ms	8ms	1m24s	1m49s	2m45s
	09	448,188	0ms	1s938ms	12ms	2m53s	3m36s	4m19s
	10	664,955	0ms	59m59s	35ms	4m18s	52m8s	2h2m13s
	11	486,920	0ms	51m17s	18ms	3m55s	5m5s	51m31s
	12	824,469	0ms	16m57s	34ms	6m34s	9m18s	3h10m26s
	13	870,860	0ms	26m34s	48ms	5m10s	45m29s	5h26m13s
	14	835,887	0ms	39m25s	22ms	5m39s	6m40s	1h55m8s
	15	839,007	0ms	29m57s	70ms	5m36s	2h38m54s	6h27m9s
	16	918,779	0ms	20m24s	33ms	4m51s	7m39s	4h56s
	17	798,347	0ms	20m9s	30ms	3m38s	4m54s	4h23m19s
	18	630,885	0ms	24m54s	40ms	3m4s	4m14s	5h13m49s
	19	525,340	0ms	9m50s	19ms	3m23s	4m17s	58m6s
	20	366,752	0ms	30m55s	128ms	2m27s	3m7s	7h5m39s
	21	356,706	0ms	4s469ms	13ms	2m9s	2m27s	2m45s
	22	155,285	0ms	2s998ms	7ms	1m4s	1m7s	1m17s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 24	00	179,585	42ms	3m21s	3m47s	4m17s
	01	141,926	48ms	2m28s	3m9s	4m21s
	02	132,691	53ms	3m5s	4m11s	4m26s
	03	160,027	59ms	3m37s	4m31s	5m46s
	04	101,844	48ms	1m51s	2m20s	4m17s
	05	53,223	37ms	1m	1m11s	1m57s
	06	71,434	44ms	1m31s	2m9s	2m27s
	07	39,587	22ms	29s973ms	37s925ms	51s174ms
	08	124,549	14ms	52s128ms	1m24s	1m52s
	09	255,651	21ms	2m26s	2m53s	4m3s
	10	389,587	19ms	3m10s	3m55s	5m19s
	11	270,584	21ms	2m49s	3m36s	5m4s
	12	486,001	23ms	3m51s	4m53s	7m21s
	13	533,482	21ms	4m9s	4m43s	5m29s
	14	497,120	23ms	4m20s	4m50s	6m39s
	15	504,726	15ms	2m54s	3m58s	5m35s
	16	569,418	18ms	3m52s	4m26s	5m59s
	17	497,342	17ms	3m4s	3m25s	4m53s
	18	379,598	17ms	2m16s	2m53s	4m14s
	19	307,883	20ms	2m28s	3m3s	3m23s
	20	205,275	19ms	1m40s	2m12s	2m48s
	21	204,539	23ms	1m58s	2m9s	2m28s
	22	82,454	13ms	41s782ms	1m4s	1m17s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 24	00	32,736	6,040	158	0	4ms	192ms	235ms	14s544ms
	01	23,629	6,121	162	0	0ms	147ms	185ms	258ms
	02	22,208	6,112	150	0	1ms	141ms	191ms	298ms
	03	34,625	8,681	152	0	1ms	207ms	273ms	392ms
	04	12,730	5,101	133	0	0ms	85ms	110ms	189ms
	05	5,439	2,415	131	0	0ms	38ms	52ms	86ms
	06	12,059	3,308	236	0	0ms	80ms	139ms	200ms
	07	2,917	979	131	0	0ms	22ms	33ms	49ms
	08	6,972	2,462	182	0	0ms	49ms	68ms	149ms
	09	19,597	6,363	389	0	0ms	110ms	148ms	174ms
	10	27,222	8,639	438	0	446ms	171ms	221ms	51m39s
	11	21,468	6,535	312	0	109ms	136ms	182ms	351ms
	12	42,057	11,342	548	0	317ms	239ms	298ms	1m2s
	13	41,798	18,678	509	0	505ms	268ms	313ms	42m50s
	14	44,537	13,104	514	0	119ms	258ms	326ms	672ms
	15	28,568	10,402	549	1	1s295ms	207ms	253ms	2h38m16s
	16	38,332	13,021	568	0	393ms	212ms	272ms	639ms
	17	32,666	11,524	695	2	350ms	260ms	325ms	644ms
	18	27,515	11,947	415	0	474ms	174ms	205ms	300ms
	19	27,533	7,196	358	0	111ms	173ms	234ms	1m48s
	20	17,787	4,915	315	0	1s882ms	123ms	156ms	289ms
	21	24,250	5,203	211	0	0ms	132ms	190ms	286ms
	22	5,072	1,833	130	0	0ms	42ms	76ms	115ms

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

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

Day	Hour	Average Duration	Average idle time
Jan 24	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

42,996 buffers Checkpoint Peak
2025-01-24 13:36:27 Date
270.075 seconds Highest write time
0.034 seconds Sync time

Checkpoints Wal files

Key values

18 files Wal files usage Peak
2025-01-24 13:36:27 Date

Checkpoints distance

Key values

587.36 Mo Distance Peak
2025-01-24 13:36:27 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 24	00	174,714	3,239.541s	0.034s	3,239.627s
	01	136,057	3,239.599s	0.054s	3,239.692s
	02	144,640	3,239.532s	0.034s	3,239.614s
	03	153,984	3,239.498s	0.032s	3,239.591s
	04	115,917	3,239.594s	0.028s	3,239.669s
	05	67,098	3,088.572s	0.024s	3,088.632s
	06	61,984	2,940.419s	0.026s	2,940.484s
	07	21,490	1,614.186s	0.023s	1,614.241s
	08	68,425	2,489.209s	0.026s	2,489.269s
	09	150,087	3,239.567s	0.032s	3,239.645s
	10	243,429	3,239.573s	0.042s	3,239.665s
	11	185,074	3,239.608s	0.031s	3,239.699s
	12	318,015	3,239.577s	0.037s	3,239.679s
	13	343,331	3,239.461s	0.039s	3,239.563s
	14	327,498	3,239.531s	0.041s	3,239.639s
	15	263,744	3,239.534s	0.05s	3,239.637s
	16	218,342	3,239.546s	0.039s	3,239.637s
	17	236,523	2,883.98s	0.079s	2,884.113s
	18	167,675	3,239.594s	0.046s	3,239.69s
	19	147,417	3,239.518s	0.039s	3,239.603s
	20	113,966	3,239.509s	0.038s	3,239.587s
	21	118,645	3,239.645s	0.036s	3,239.725s
	22	43,814	2,317.519s	0.025s	2,317.576s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 24	00	72	4,127	0.002s	0.012s
	01	60	3,440	0.021s	0.012s
	02	66	3,159	0.002s	0.012s
	03	71	2,810	0.002s	0.012s
	04	56	2,157	0.002s	0.012s
	05	30	1,917	0.002s	0.012s
	06	26	3,043	0.002s	0.012s
	07	9	1,747	0.002s	0.012s
	08	26	2,390	0.002s	0.012s
	09	64	4,152	0.002s	0.012s
	10	102	4,454	0.002s	0.012s
	11	83	3,922	0.002s	0.012s
	12	137	4,723	0.002s	0.012s
	13	152	5,303	0.002s	0.012s
	14	142	5,112	0.002s	0.012s
	15	111	5,351	0.012s	0.012s
	16	91	5,302	0.002s	0.012s
	17	101	5,170	0.029s	0.012s
	18	72	4,975	0.004s	0.012s
	19	63	5,245	0.003s	0.012s
	20	50	4,325	0.002s	0.012s
	21	52	4,329	0.002s	0.012s
	22	20	2,698	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 24	00	99,215.25 kB	123,005.25 kB
	01	80,914.92 kB	107,894.42 kB
	02	91,126.42 kB	113,073.42 kB
	03	95,012.00 kB	136,063.00 kB
	04	75,946.83 kB	125,953.58 kB
	05	40,964.25 kB	73,316.00 kB
	06	36,407.08 kB	53,011.00 kB
	07	11,919.58 kB	39,272.83 kB
	08	38,926.36 kB	59,090.18 kB
	09	90,023.45 kB	101,982.73 kB
	10	139,814.92 kB	161,461.75 kB
	11	112,569.33 kB	163,973.83 kB
	12	187,188.75 kB	221,660.08 kB
	13	197,977.60 kB	266,905.10 kB
	14	193,311.45 kB	234,766.73 kB
	15	150,924.92 kB	224,649.75 kB
	16	126,609.82 kB	156,075.18 kB
	17	138,100.08 kB	179,047.83 kB
	18	97,508.00 kB	149,457.75 kB
	19	83,655.73 kB	121,366.64 kB
	20	67,995.83 kB	101,937.33 kB
	21	74,784.36 kB	91,411.91 kB
	22	35,994.67 kB	123,574.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

6,188,526 Total read queries
3,005,497 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	6,188,526	58.10%
INSERT	551,717	5.18%
UPDATE	171,921	1.61%
DELETE	7,386	0.07%
COPY FROM	3	0.00%
COPY TO	0	0.00%
CTE	18,010	0.17%
DDL	1,391	0.01%
TCL	2,255,069	21.17%
CURSOR	0	0.00%
OTHERS	1,457,799	13.69%

Queries by database

Key values

unknown Main database
10,651,822 Requests
4d8h14m42s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	10,651,822	4d8h14m42s
	copy from	3	3ms
	cte	18,010	3s556ms
	ddl	1,391	211ms
	delete	7,386	972ms
	insert	551,717	2m46s
	others	1,457,799	1m4s
	select	6,188,526	1d16h52m7s
	tcl	2,255,069	1m30s
	update	171,921	2d15h17m9s

Queries by user

Key values

unknown Main user
10,651,822 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	10,651,822	4d8h14m42s
	copy from	3	3ms
	cte	18,010	3s556ms
	ddl	1,391	211ms
	delete	7,386	972ms
	insert	551,717	2m46s
	others	1,457,799	1m4s
	select	6,188,526	1d16h52m7s
	tcl	2,255,069	1m30s
	update	171,921	2d15h17m9s

Duration by user

Key values

4d8h14m42s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	10,651,822	4d8h14m42s
	copy from	3	3ms
	cte	18,010	3s556ms
	ddl	1,391	211ms
	delete	7,386	972ms
	insert	551,717	2m46s
	others	1,457,799	1m4s
	select	6,188,526	1d16h52m7s
	tcl	2,255,069	1m30s
	update	171,921	2d15h17m9s

Queries by host

Key values

unknown Main host
10,651,822 Requests
4d8h14m42s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	10,651,822	4d8h14m42s
	copy from	3	3ms
	cte	18,010	3s556ms
	ddl	1,391	211ms
	delete	7,386	972ms
	insert	551,717	2m46s
	others	1,457,799	1m4s
	select	6,188,526	1d16h52m7s
	tcl	2,255,069	1m30s
	update	171,921	2d15h17m9s

Queries by application

Key values

unknown Main application
10,651,822 Requests
4d8h14m42s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	10,651,822	4d8h14m42s
	copy from	3	3ms
	cte	18,010	3s556ms
	ddl	1,391	211ms
	delete	7,386	972ms
	insert	551,717	2m46s
	others	1,457,799	1m4s
	select	6,188,526	1d16h52m7s
	tcl	2,255,069	1m30s
	update	171,921	2d15h17m9s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-24 17:07:49 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

9,955,399 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	9,955,399	93.46%
1-5ms	160,794	1.51%
5-10ms	6,750	0.06%
10-25ms	24,526	0.23%
25-50ms	90,284	0.85%
50-100ms	69,215	0.65%
100-500ms	170,318	1.60%
500-1000ms	173,646	1.63%
1000-10000ms	369	0.00%
> 10000ms	521	0.00%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629103', exp_date = '2025-01-24 08:55:16.629105', logged_in = 'TRUE' where id = 874; [ Date: 2025-01-24 10:10:16 ]
2	59m59s	update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629118', exp_date = '2025-01-24 08:55:16.629120', logged_in = 'TRUE' where id = 874; [ Date: 2025-01-24 10:10:16 ]
3	51m17s	update res_users set sid = '9eaad8c43c41c82d29698a566e165bcfdcf46db7', last_update = '2025-01-24 09:34:05.036001', exp_date = '2025-01-24 10:19:05.036005', logged_in = 'TRUE' where id = 826; [ Date: 2025-01-24 11:25:22 ]
4	39m25s	UPDATE "res_users" SET "exp_date" = '2025-01-24 13:53:54.604985', "last_update" = '2025-01-24 13:08:54.605016', "write_date" = '2025-01-24 13:08:54.108126', "write_uid" = 865 WHERE id IN (865); [ Date: 2025-01-24 14:48:20 ]
5	30m55s	update res_users set sid = '8572012d30124b04ba4c056846a48117a67a48bd', last_update = '2025-01-24 18:57:24.855310', exp_date = '2025-01-24 19:42:24.855313', logged_in = 'TRUE' where id = 892; [ Date: 2025-01-24 20:28:20 ]
6	30m55s	update res_users set sid = '8572012d30124b04ba4c056846a48117a67a48bd', last_update = '2025-01-24 18:57:24.854615', exp_date = '2025-01-24 19:42:24.854618', logged_in = 'TRUE' where id = 892; [ Date: 2025-01-24 20:28:20 ]
7	29m57s	update res_users set sid = '665ffe1784303bb13071c91d311f5419dda0fe72', last_update = '2025-01-24 14:11:23.208509', exp_date = '2025-01-24 14:56:23.208511', logged_in = 'TRUE' where id = 1220; [ Date: 2025-01-24 15:41:20 ]
8	29m24s	update res_users set sid = '665ffe1784303bb13071c91d311f5419dda0fe72', last_update = '2025-01-24 14:11:56.122228', exp_date = '2025-01-24 14:56:56.122232', logged_in = 'TRUE' where id = 1220; [ Date: 2025-01-24 15:41:20 ]
9	27m14s	update res_users set sid = '665ffe1784303bb13071c91d311f5419dda0fe72', last_update = '2025-01-24 14:14:05.736382', exp_date = '2025-01-24 14:59:05.736385', logged_in = 'TRUE' where id = 1220; [ Date: 2025-01-24 15:41:20 ]
10	26m34s	update res_users set sid = 'cb0075d3c9b9cb2399326f07e00f3e1ad670663d', last_update = '2025-01-24 12:03:28.565871', exp_date = '2025-01-24 12:48:28.565875', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-24 13:30:03 ]
11	26m25s	update res_users set sid = 'b6a47e7eb4f369158c947d2b1fad3c998b60be84', last_update = '2025-01-24 14:14:55.278043', exp_date = '2025-01-24 14:59:55.278046', logged_in = 'TRUE' where id = 1112; [ Date: 2025-01-24 15:41:20 ]
12	26m25s	update res_users set sid = 'b6a47e7eb4f369158c947d2b1fad3c998b60be84', last_update = '2025-01-24 14:14:55.277217', exp_date = '2025-01-24 14:59:55.277220', logged_in = 'TRUE' where id = 1112; [ Date: 2025-01-24 15:41:20 ]
13	26m13s	update res_users set sid = '665ffe1784303bb13071c91d311f5419dda0fe72', last_update = '2025-01-24 14:15:07.114661', exp_date = '2025-01-24 15:00:07.114665', logged_in = 'TRUE' where id = 1220; [ Date: 2025-01-24 15:41:20 ]
14	25m41s	update res_users set sid = 'b6a47e7eb4f369158c947d2b1fad3c998b60be84', last_update = '2025-01-24 14:15:39.103457', exp_date = '2025-01-24 15:00:39.103459', logged_in = 'TRUE' where id = 1112; [ Date: 2025-01-24 15:41:20 ]
15	24m54s	update res_users set sid = 'caf0163b1789af61315a21b30b19c7eaaf1337fe', last_update = '2025-01-24 16:41:26.791532', exp_date = '2025-01-24 17:26:26.791535', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-24 18:06:20 ]
16	24m54s	update res_users set sid = 'caf0163b1789af61315a21b30b19c7eaaf1337fe', last_update = '2025-01-24 16:41:26.792169', exp_date = '2025-01-24 17:26:26.792174', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-24 18:06:20 ]
17	24m48s	update res_users set sid = 'cb0075d3c9b9cb2399326f07e00f3e1ad670663d', last_update = '2025-01-24 12:05:14.860791', exp_date = '2025-01-24 12:50:14.860795', logged_in = 'TRUE' where id = 1294; [ Date: 2025-01-24 13:30:03 ]
18	24m28s	update res_users set sid = '97064e2d08969d5c207d0c271c546d8015328888', last_update = '2025-01-24 16:41:52.417129', exp_date = '2025-01-24 17:26:52.417133', logged_in = 'TRUE' where id = 1372; [ Date: 2025-01-24 18:06:20 ]
19	24m18s	UPDATE "res_users" SET "exp_date" = '2025-01-24 12:50:44.948657', "last_update" = '2025-01-24 12:05:44.948687', "sid" = '0be4b1cceef3d255491fffac49cfb42cd8286ed5', "write_date" = '2025-01-24 12:05:44.612946', "write_uid" = 1294 WHERE id IN (1294); [ Date: 2025-01-24 13:30:03 ]
20	24m15s	update res_users set sid = '665ffe1784303bb13071c91d311f5419dda0fe72', last_update = '2025-01-24 14:17:04.743966', exp_date = '2025-01-24 15:02:04.743970', logged_in = 'TRUE' where id = 1220; [ Date: 2025-01-24 15:41:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d12h24m52s

34,973

Details

0ms

59m59s

6s218ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 24	00	874	196ms	0ms
	01	1,058	17s223ms	16ms
	02	901	39s776ms	44ms
	03	984	230ms	0ms
	04	776	170ms	0ms
	05	463	99ms	0ms
	06	240	56ms	0ms
	07	211	50ms	0ms
	08	663	143ms	0ms
	09	1,501	331ms	0ms
	10	2,291	4h29m58s	7s70ms
	11	1,526	51m17s	2s16ms
	12	2,993	4h43m49s	5s689ms
	13	2,910	6h56m49s	8s594ms
	14	2,687	1h14m23s	1s661ms
	15	2,943	14h12m56s	17s389ms
	16	2,852	5h13m18s	6s591ms
	17	2,722	4h21m41s	5s768ms
	18	2,122	5h14m48s	8s901ms
	19	1,606	1h2m51s	2s348ms
	20	1,138	12h1m58s	38s65ms
	21	1,014	219ms	0ms
	22	498	104ms	0ms

update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629103', exp_date = '2025-01-24 08:55:16.629105', logged_in = 'TRUE' where id = 874;

Date: 2025-01-24 10:10:16 Duration: 59m59s
update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629118', exp_date = '2025-01-24 08:55:16.629120', logged_in = 'TRUE' where id = 874;

Date: 2025-01-24 10:10:16 Duration: 59m59s
update res_users set sid = '9eaad8c43c41c82d29698a566e165bcfdcf46db7', last_update = '2025-01-24 09:34:05.036001', exp_date = '2025-01-24 10:19:05.036005', logged_in = 'TRUE' where id = 826;

Date: 2025-01-24 11:25:22 Duration: 51m17s

2

21h50m34s

141,942

Details

371ms

857ms

553ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 24	00	7,894	1h13m55s	561ms
	01	7,779	1h11m41s	552ms
	02	8,429	1h17m55s	554ms
	03	10,984	1h42m41s	560ms
	04	5,889	53m2s	540ms
	05	2,165	19m11s	531ms
	06	2,892	27m18s	566ms
	07	1,048	9m19s	533ms
	08	1,593	14m18s	538ms
	09	5,168	46m42s	542ms
	10	7,189	1h5m27s	546ms
	11	5,698	52m7s	548ms
	12	11,021	1h43m48s	565ms
	13	10,242	1h35m5s	557ms
	14	10,150	1h35m28s	564ms
	15	5,889	54m2s	550ms
	16	7,977	1h15m42s	569ms
	17	7,617	1h10m4s	552ms
	18	6,080	54m46s	540ms
	19	6,163	56m19s	548ms
	20	4,025	36m23s	542ms
	21	4,938	45m8s	548ms
	22	1,112	10m1s	541ms

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

Date: 2025-01-24 16:53:11 Duration: 857ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748179)) AND (("shipping_track"."id" not in (39290438, 39290438)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:09 Duration: 855ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748188)) AND (("shipping_track"."id" not in (39290557, 39290557)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:24 Duration: 847ms

3

3h58m25s

25,402

Details

389ms

1s432ms

563ms

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
Jan 24	00	244	2m24s	590ms
	01	318	3m6s	587ms
	02	244	2m28s	610ms
	03	218	2m21s	649ms
	04	160	1m40s	625ms
	05	81	49s728ms	613ms
	06	511	4m40s	548ms
	07	111	1m1s	555ms
	08	276	2m32s	550ms
	09	1,207	11m7s	552ms
	10	1,768	16m36s	563ms
	11	1,418	13m15s	560ms
	12	2,560	24m54s	583ms
	13	2,456	23m26s	572ms
	14	2,313	22m26s	582ms
	15	1,594	15m1s	565ms
	16	2,322	22m	568ms
	17	2,955	26m50s	544ms
	18	1,509	13m33s	538ms
	19	1,196	10m44s	538ms
	20	816	7m20s	539ms
	21	809	7m16s	539ms
	22	316	2m47s	529ms

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

Date: 2025-01-24 17:21:59 Duration: 1s432ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3341580)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 14:27:41 Duration: 1s40ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4721644, 4724725, 4727813, 4727829, 4727919, 4729998, 4730203, 4730233, 4730051, 4732717, 4732257, 4732947, 4733933, 4733735, 4734735, 4734832, 4734776, 4735513, 4736521, 4736936, 4735800, 4736344, 4738813, 4738832, 4739221, 4739399, 4739504, 4739475, 4739795, 4739805, 4739981, 4739969, 4743725, 4738022, 4738297, 4736568, 4726643, 4739434, 4730636, 4744383, 4746325, 4746330)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 12:45:25 Duration: 954ms

4

3h54m4s

66,867

Details

173ms

321ms

210ms

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
Jan 24	00	1,284	4m26s	207ms
	01	1,851	6m18s	204ms
	02	2,661	9m9s	206ms
	03	3,837	13m16s	207ms
	04	3,445	11m43s	204ms
	05	1,645	5m37s	204ms
	06	849	2m52s	203ms
	07	455	1m33s	204ms
	08	1,589	5m24s	204ms
	09	4,136	14m21s	208ms
	10	4,469	15m41s	210ms
	11	3,468	12m1s	208ms
	12	5,440	19m49s	218ms
	13	6,927	24m51s	215ms
	14	7,066	25m15s	214ms
	15	5,349	18m55s	212ms
	16	6,431	22m43s	212ms
	17	2,803	9m33s	204ms
	18	2,363	7m51s	199ms
	19	305	59s897ms	196ms
	20	197	38s749ms	196ms
	21	154	30s282ms	196ms
	22	143	28s418ms	198ms

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

Date: 2025-01-24 14:44:40 Duration: 321ms
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" = '9985352')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-24 12:46:53 Duration: 305ms
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" = '9852932')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-24 12:47:00 Duration: 305ms

5

2h3m8s

160

Details

0ms

24m18s

46s177ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3	3ms	1ms
	01	2	1ms	0ms
	02	2	0ms	0ms
	03	5	1ms	0ms
	04	1	1ms	1ms
	05	1	0ms	0ms
	08	9	2ms	0ms
	09	5	0ms	0ms
	10	6	7ms	1ms
	11	7	5ms	0ms
	12	12	12ms	1ms
	13	19	1h36m17s	5m4s
	14	22	19ms	0ms
	15	10	14ms	1ms
	16	9	26m50s	2m58s
	17	21	21ms	1ms
	18	5	4ms	0ms
	19	8	8ms	1ms
	20	7	6ms	0ms
	21	4	3ms	0ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-24 12:50:44.948657', "last_update" = '2025-01-24 12:05:44.948687', "sid" = '0be4b1cceef3d255491fffac49cfb42cd8286ed5', "write_date" = '2025-01-24 12:05:44.612946', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 24m18s
UPDATE "res_users" SET "exp_date" = '2025-01-24 12:54:56.318368', "last_update" = '2025-01-24 12:09:56.318389', "sid" = '8d835220d5009413bff0f87a596acff65b16cecd', "write_date" = '2025-01-24 12:09:55.983440', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 20m7s
UPDATE "res_users" SET "exp_date" = '2025-01-24 12:56:09.412259', "last_update" = '2025-01-24 12:11:09.412298', "sid" = '803cf1856752136ca7a86137f17530f439aef529', "write_date" = '2025-01-24 12:11:09.055982', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 18m54s

6

1h48m58s

27,847

Details

91ms

814ms

234ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3,912	15m14s	233ms
	01	2,396	9m12s	230ms
	02	1,766	7m13s	245ms
	03	3,158	12m33s	238ms
	06	1,942	8m	247ms
	07	28	8s885ms	317ms
	08	120	20s475ms	170ms
	09	128	23s746ms	185ms
	10	24	5s50ms	210ms
	11	188	48s389ms	257ms
	12	154	30s24ms	194ms
	13	152	39s633ms	260ms
	14	384	1m38s	257ms
	15	216	52s163ms	241ms
	16	2,037	8m28s	249ms
	17	2,052	8m39s	253ms
	18	1,830	6m47s	222ms
	19	2,708	10m7s	224ms
	20	1,636	5m54s	216ms
	21	2,544	9m48s	231ms
	22	472	1m32s	194ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 06:26:53 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سيد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 06:26:53 Duration: 813ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 03:46:01 Duration: 807ms

7

1h45m21s

21,129

Details

183ms

601ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	08	506	2m40s	316ms
	09	1,533	7m15s	284ms
	10	3,098	14m55s	288ms
	11	1,455	7m12s	297ms
	12	1,549	8m3s	312ms
	13	2,422	12m40s	314ms
	14	2,987	14m30s	291ms
	15	3,352	17m1s	304ms
	16	2,849	14m43s	310ms
	17	810	3m40s	272ms
	18	568	2m37s	276ms

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

Date: 2025-01-24 12:47:02 Duration: 601ms
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" = '9910172')))) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:47:02 Duration: 596ms
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" = '9910904')))) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:46:58 Duration: 592ms

8

1h30m26s

6,013

Details

822ms

1s122ms

902ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,305	19m42s	905ms
	01	769	11m35s	905ms
	02	296	4m28s	906ms
	03	341	5m11s	913ms
	07	9	8s252ms	916ms
	08	31	28s156ms	908ms
	10	2	1s877ms	938ms
	11	4	3s670ms	917ms
	12	2	1s904ms	952ms
	13	31	29s176ms	941ms
	14	90	1m22s	913ms
	15	60	56s595ms	943ms
	16	71	1m5s	927ms
	17	201	3m3s	914ms
	18	742	11m8s	901ms
	19	1,024	15m16s	894ms
	20	446	6m37s	892ms
	21	586	8m41s	890ms
	22	3	2s618ms	872ms

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

Date: 2025-01-24 16:49:06 Duration: 1s122ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9896645')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 18:20:45 Duration: 1s121ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '31042')) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 15:18:17 Duration: 1s116ms

9

1h9m14s

90,684

Details

36ms

103ms

45ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3,526	2m37s	44ms
	01	3,375	2m32s	45ms
	02	3,038	2m20s	46ms
	03	4,361	3m18s	45ms
	04	1,883	1m25s	45ms
	05	626	28s490ms	45ms
	06	1,264	56s572ms	44ms
	07	640	28s921ms	45ms
	08	1,003	45s718ms	45ms
	09	3,993	3m1s	45ms
	10	5,455	4m10s	45ms
	11	4,384	3m20s	45ms
	12	9,265	7m17s	47ms
	13	7,594	5m54s	46ms
	14	8,514	6m39s	46ms
	15	4,991	3m50s	46ms
	16	6,385	4m58s	46ms
	17	5,206	3m56s	45ms
	18	4,403	3m14s	44ms
	19	3,940	2m54s	44ms
	20	2,868	2m6s	44ms
	21	3,241	2m23s	44ms
	22	729	32s422ms	44ms

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

Date: 2025-01-24 17:21:59 Duration: 103ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4696225)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 17:22:00 Duration: 80ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3353086)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 15:12:50 Duration: 78ms

10

41m24s

11,998

Details

179ms

275ms

207ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,044	3m35s	206ms
	01	1,603	5m28s	204ms
	02	2,303	8m1s	208ms
	03	2,879	10m4s	209ms
	04	3,269	11m9s	204ms
	05	900	3m5s	205ms

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

Date: 2025-01-24 03:50:46 Duration: 275ms
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" = '9656857')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 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, 115)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-24 03:50:40 Duration: 269ms

11

39m25s

24

Details

0ms

39m25s

1m38s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 24	03	2	3ms	1ms
	08	3	0ms	0ms
	09	1	0ms	0ms
	11	2	1ms	0ms
	12	3	3ms	1ms
	13	8	7ms	0ms
	14	1	39m25s	39m25s
	16	1	0ms	0ms
	18	1	1ms	1ms
	20	1	0ms	0ms
	21	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-24 13:53:54.604985', "last_update" = '2025-01-24 13:08:54.605016', "write_date" = '2025-01-24 13:08:54.108126', "write_uid" = 865 WHERE id IN (865);

Date: 2025-01-24 14:48:20 Duration: 39m25s
UPDATE "res_users" SET "exp_date" = '2025-01-24 13:16:37.931971', "last_update" = '2025-01-24 12:31:37.932000', "write_date" = '2025-01-24 12:31:37.563761', "write_uid" = 992 WHERE id IN (992);

Date: 2025-01-24 13:31:37 Duration: 1ms
UPDATE "res_users" SET "exp_date" = '2025-01-24 13:35:40.532914', "last_update" = '2025-01-24 12:50:40.532963', "write_date" = '2025-01-24 12:50:40.176891', "write_uid" = 1338 WHERE id IN (1338);

Date: 2025-01-24 13:50:40 Duration: 1ms

12

35m58s

33,659

Details

45ms

110ms

64ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 24	00	22	1s332ms	60ms
	02	3	194ms	64ms
	03	10	638ms	63ms
	04	16	1s33ms	64ms
	05	18	1s160ms	64ms
	06	35	2s214ms	63ms
	07	19	1s241ms	65ms
	08	427	27s128ms	63ms
	09	3,110	3m17s	63ms
	10	2,021	2m9s	64ms
	11	1,151	1m13s	64ms
	12	5,219	5m40s	65ms
	13	2,978	3m12s	64ms
	14	7,420	8m10s	66ms
	15	3,333	3m34s	64ms
	16	4,345	4m43s	65ms
	17	2,085	2m2s	58ms
	18	1,304	1m9s	53ms
	19	39	2s69ms	53ms
	20	44	2s392ms	54ms
	21	36	1s959ms	54ms
	22	24	1s303ms	54ms

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

Date: 2025-01-24 14:45:03 Duration: 110ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4702262) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:58:34 Duration: 100ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4575513) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-24 15:31:46 Duration: 100ms

13

35m49s

8,101

Details

224ms

431ms

265ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	682	3m2s	266ms
	01	442	1m57s	266ms
	02	602	2m42s	270ms
	03	1,253	5m39s	271ms
	06	976	4m15s	261ms
	07	5	1s272ms	254ms
	08	30	7s596ms	253ms
	09	69	17s742ms	257ms
	10	15	3s927ms	261ms
	11	93	24s756ms	266ms
	12	82	22s225ms	271ms
	13	51	15s449ms	302ms
	14	109	30s182ms	276ms
	15	50	13s624ms	272ms
	16	961	4m22s	272ms
	17	836	3m39s	262ms
	18	178	45s625ms	256ms
	19	349	1m30s	260ms
	20	382	1m39s	260ms
	21	703	2m59s	255ms
	22	233	57s796ms	248ms

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

Date: 2025-01-24 16:53:24 Duration: 431ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9947167')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 17:23:14 Duration: 419ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9726484')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 16:53:28 Duration: 418ms

14

24m21s

7,011

Details

178ms

295ms

208ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 24	00	11	2s264ms	205ms
	01	90	18s188ms	202ms
	02	108	22s826ms	211ms
	03	17	3s686ms	216ms
	04	164	33s969ms	207ms
	05	217	44s543ms	205ms
	06	193	39s445ms	204ms
	07	443	1m30s	205ms
	08	83	17s136ms	206ms
	09	196	41s344ms	210ms
	10	152	31s483ms	207ms
	11	541	1m53s	210ms
	12	544	1m55s	211ms
	13	1,008	3m35s	213ms
	14	737	2m42s	220ms
	15	430	1m29s	208ms
	16	373	1m18s	209ms
	17	431	1m28s	206ms
	18	621	2m3s	199ms
	19	305	1m	196ms
	20	193	38s88ms	197ms
	21	154	30s271ms	196ms

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

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

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

Date: 2025-01-24 14:44:40 Duration: 285ms

15

15m55s

16,218

Details

39ms

83ms

58ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 24	08	358	20s797ms	58ms
	09	1,618	1m34s	58ms
	10	1,010	59s771ms	59ms
	11	836	50s391ms	60ms
	12	2,503	2m30s	60ms
	13	2,056	2m4s	60ms
	14	2,213	2m13s	60ms
	15	2,333	2m18s	59ms
	16	1,828	1m49s	59ms
	17	895	47s10ms	52ms
	18	568	27s494ms	48ms

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

Date: 2025-01-24 16:53:16 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4683611) ORDER BY "collection_policy"."id";

Date: 2025-01-24 16:53:16 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4698943) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:28:50 Duration: 81ms

16

11m37s

5,998

Details

96ms

183ms

116ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 24	00	84	9s189ms	109ms
	01	24	2s761ms	115ms
	02	18	2s95ms	116ms
	06	91	10s542ms	115ms
	08	77	8s505ms	110ms
	09	262	30s235ms	115ms
	10	347	40s396ms	116ms
	11	171	20s31ms	117ms
	12	533	1m3s	119ms
	13	786	1m32s	117ms
	14	1,196	2m20s	117ms
	15	464	53s171ms	114ms
	16	525	1m1s	116ms
	17	548	1m3s	116ms
	18	331	37s617ms	113ms
	19	277	31s135ms	112ms
	20	157	18s129ms	115ms
	21	69	7s795ms	112ms
	22	38	4s400ms	115ms

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

Date: 2025-01-24 17:23:08 Duration: 183ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8031371)) AND (("cash_track"."id" not in (7315126)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-24 15:23:05 Duration: 160ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8030671)) AND (("cash_track"."id" not in (7311309)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-24 12:58:37 Duration: 157ms

17

10m20s

2,726

Details

197ms

302ms

227ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 24	00	120	27s199ms	226ms
	01	120	27s52ms	225ms
	02	120	27s338ms	227ms
	03	120	27s722ms	231ms
	04	120	26s944ms	224ms
	05	120	26s916ms	224ms
	06	120	26s883ms	224ms
	07	120	26s827ms	223ms
	08	120	26s790ms	223ms
	09	120	27s170ms	226ms
	10	120	27s498ms	229ms
	11	120	27s488ms	229ms
	12	120	28s397ms	236ms
	13	120	28s508ms	237ms
	14	120	28s884ms	240ms
	15	120	27s707ms	230ms
	16	120	27s944ms	232ms
	17	116	26s367ms	227ms
	18	120	26s838ms	223ms
	19	120	26s656ms	222ms
	20	120	26s647ms	222ms
	21	120	26s631ms	221ms
	22	90	19s940ms	221ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 14:45:02 Duration: 302ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 12:47:02 Duration: 296ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 12:47:02 Duration: 295ms

18

7m22s

2,943

Details

122ms

226ms

150ms

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
Jan 24	00	32	4s699ms	146ms
	01	15	2s186ms	145ms
	06	5	736ms	147ms
	07	11	1s637ms	148ms
	08	8	1s163ms	145ms
	09	75	10s987ms	146ms
	10	261	39s364ms	150ms
	11	291	44s211ms	151ms
	12	494	1m16s	154ms
	13	573	1m28s	153ms
	14	287	44s876ms	156ms
	15	269	40s711ms	151ms
	16	155	23s828ms	153ms
	17	144	20s511ms	142ms
	18	89	11s964ms	134ms
	19	106	14s202ms	133ms
	20	45	5s966ms	132ms
	21	59	7s757ms	131ms
	22	24	3s186ms	132ms

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

Date: 2025-01-24 12:58:37 Duration: 226ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-24 12:45:23 Duration: 208ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 73)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-24 12:28:47 Duration: 208ms

19

6m37s

142

Details

27ms

3s637ms

2s799ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 24	10	5	15s226ms	3s45ms
	12	11	34s561ms	3s141ms
	13	9	15s542ms	1s726ms
	14	6	18s377ms	3s62ms
	15	9	27s643ms	3s71ms
	16	22	1m8s	3s122ms
	17	3	9s84ms	3s28ms
	18	13	26s924ms	2s71ms
	19	46	2m17s	2s981ms
	20	9	17s673ms	1s963ms
	21	3	8s963ms	2s987ms
	22	6	17s635ms	2s939ms

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

Date: 2025-01-24 12:45:57 Duration: 3s637ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))) 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 (7)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))))) 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 (7)))))))) AND ("policy_number"."name"::text ilike '%59001%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-24 12:45:59 Duration: 3s524ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))))) AND ("policy_number"."name"::text ilike '%116050%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-24 16:11:53 Duration: 3s517ms

20

5m32s

14,272

Details

0ms

1m40s

23ms

update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,956	2m42s	82ms
	01	1,191	239ms	0ms
	02	884	190ms	0ms
	03	1,576	41s444ms	26ms
	06	981	205ms	0ms
	07	14	2ms	0ms
	08	63	14ms	0ms
	09	81	29ms	0ms
	10	34	16ms	0ms
	11	108	26ms	0ms
	12	110	30ms	0ms
	13	104	32ms	0ms
	14	221	55ms	0ms
	15	138	36ms	0ms
	16	1,056	253ms	0ms
	17	1,071	293ms	0ms
	18	947	232ms	0ms
	19	1,377	2m6s	92ms
	20	834	159ms	0ms
	21	1,281	290ms	0ms
	22	245	56ms	0ms

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-23 23:34:06.863260', "write_uid" = 975 WHERE id IN (32227942);

Date: 2025-01-24 00:35:49 Duration: 1m40s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-24 18:19:17.426810', "write_uid" = 868 WHERE id IN (32276248);

Date: 2025-01-24 19:20:48 Duration: 1m28s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-23 23:51:23.547900', "write_uid" = 1223 WHERE id IN (32227933);

Date: 2025-01-24 00:53:53 Duration: 1m1s

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

1,456,491

Details

1m4s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 24	00	44,217	2s58ms	0ms
	01	41,671	2s9ms	0ms
	02	39,958	1s918ms	0ms
	03	40,945	2s90ms	0ms
	04	33,593	1s611ms	0ms
	05	22,940	924ms	0ms
	06	19,360	849ms	0ms
	07	16,944	647ms	0ms
	08	33,800	1s480ms	0ms
	09	64,351	3s150ms	0ms
	10	90,481	4s56ms	0ms
	11	73,658	3s315ms	0ms
	12	106,867	5s27ms	0ms
	13	104,555	4s699ms	0ms
	14	108,711	4s949ms	0ms
	15	114,889	4s519ms	0ms
	16	115,382	5s10ms	0ms
	17	98,284	4s514ms	0ms
	18	82,106	3s417ms	0ms
	19	72,180	3s105ms	0ms
	20	55,770	2s97ms	0ms
	21	48,455	2s2ms	0ms
	22	27,374	951ms	0ms

DISCARD ALL;

Date: 2025-01-24 10:15:19 Duration: 1ms
DISCARD ALL;

Date: 2025-01-24 10:10:41 Duration: 1ms
DISCARD ALL;

Date: 2025-01-24 08:42:43 Duration: 1ms

2

1,127,773

Details

16s603ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 24	00	32,613	536ms	0ms
	01	30,606	517ms	0ms
	02	29,934	503ms	0ms
	03	31,788	554ms	0ms
	04	25,098	426ms	0ms
	05	15,956	259ms	0ms
	06	13,569	235ms	0ms
	07	11,670	192ms	0ms
	08	25,863	391ms	0ms
	09	50,783	775ms	0ms
	10	73,717	1s44ms	0ms
	11	57,034	847ms	0ms
	12	88,272	1s327ms	0ms
	13	84,442	1s272ms	0ms
	14	85,096	1s268ms	0ms
	15	88,704	1s151ms	0ms
	16	89,915	1s311ms	0ms
	17	77,673	1s108ms	0ms
	18	63,619	832ms	0ms
	19	54,577	759ms	0ms
	20	40,970	526ms	0ms
	21	36,735	505ms	0ms
	22	19,139	253ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-24 14:35:03 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-24 12:34:58 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-24 12:24:16 Duration: 0ms

3

746,140

Details

7s141ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 24	00	22,758	228ms	0ms
	01	21,431	213ms	0ms
	02	20,624	206ms	0ms
	03	21,076	223ms	0ms
	04	17,375	169ms	0ms
	05	12,040	105ms	0ms
	06	10,258	93ms	0ms
	07	9,086	78ms	0ms
	08	17,643	161ms	0ms
	09	32,887	317ms	0ms
	10	46,055	458ms	0ms
	11	37,563	353ms	0ms
	12	54,369	564ms	0ms
	13	53,658	547ms	0ms
	14	55,605	559ms	0ms
	15	58,265	534ms	0ms
	16	58,627	575ms	0ms
	17	50,183	477ms	0ms
	18	41,829	372ms	0ms
	19	36,997	327ms	0ms
	20	28,653	235ms	0ms
	21	24,983	225ms	0ms
	22	14,175	112ms	0ms

ROLLBACK;

Date: 2025-01-24 12:29:50 Duration: 0ms
ROLLBACK;

Date: 2025-01-24 19:39:54 Duration: 0ms
ROLLBACK;

Date: 2025-01-24 21:25:33 Duration: 0ms

4

731,909

Details

2m12s

0ms

10ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 24	00	22,102	4s483ms	0ms
	01	20,795	4s171ms	0ms
	02	19,982	3s999ms	0ms
	03	20,421	4s419ms	0ms
	04	16,760	3s176ms	0ms
	05	11,444	1s772ms	0ms
	06	9,705	1s605ms	0ms
	07	8,447	1s117ms	0ms
	08	16,949	2s533ms	0ms
	09	32,372	5s827ms	0ms
	10	45,448	8s870ms	0ms
	11	37,090	6s713ms	0ms
	12	53,876	11s14ms	0ms
	13	52,942	10s582ms	0ms
	14	54,805	10s621ms	0ms
	15	57,529	10s137ms	0ms
	16	57,954	11s265ms	0ms
	17	49,533	8s636ms	0ms
	18	41,261	6s729ms	0ms
	19	36,290	5s568ms	0ms
	20	27,968	3s853ms	0ms
	21	24,397	3s669ms	0ms
	22	13,839	1s715ms	0ms

SELECT payload FROM http_sessions WHERE sid = '065c1440207a87321827ac8b6b459edcf1e899ac';

Date: 2025-01-24 16:45:24 Duration: 10ms
SELECT payload FROM http_sessions WHERE sid = 'a67ebbb0cc0443ed275d900f38c48c2ebc93036b';

Date: 2025-01-24 18:22:51 Duration: 8ms
SELECT payload FROM http_sessions WHERE sid = '97c611f89a396971d0b48c5c126c54b00d4d51b2';

Date: 2025-01-24 17:21:52 Duration: 8ms

5

728,881

Details

1m3s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 24	00	22,180	1s961ms	0ms
	01	20,914	1s921ms	0ms
	02	20,044	1s806ms	0ms
	03	20,534	1s950ms	0ms
	04	16,864	1s513ms	0ms
	05	11,555	924ms	0ms
	06	9,757	816ms	0ms
	07	8,545	662ms	0ms
	08	16,920	1s359ms	0ms
	09	32,224	2s755ms	0ms
	10	45,243	4s21ms	0ms
	11	36,881	3s180ms	0ms
	12	53,438	4s938ms	0ms
	13	52,206	4s737ms	0ms
	14	54,326	4s908ms	0ms
	15	57,410	4s866ms	0ms
	16	57,656	5s122ms	0ms
	17	49,083	4s383ms	0ms
	18	41,069	3s439ms	0ms
	19	36,097	3s16ms	0ms
	20	27,900	2s145ms	0ms
	21	24,296	2s42ms	0ms
	22	13,739	1s4ms	0ms

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

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

Date: 2025-01-24 11:17:58 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-24 15:11:22 Duration: 0ms

6

485,885

Details

1m10s

0ms

9ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 24	00	13,759	2s61ms	0ms
	01	11,507	1s929ms	0ms
	02	11,245	1s907ms	0ms
	03	12,963	2s234ms	0ms
	04	8,531	1s560ms	0ms
	05	4,273	869ms	0ms
	06	3,784	778ms	0ms
	07	3,017	615ms	0ms
	08	11,050	1s605ms	0ms
	09	23,975	3s432ms	0ms
	10	36,013	5s43ms	0ms
	11	24,821	3s677ms	0ms
	12	44,288	6s205ms	0ms
	13	38,758	5s708ms	0ms
	14	38,338	5s498ms	0ms
	15	39,439	4s968ms	0ms
	16	40,193	5s782ms	0ms
	17	34,573	4s950ms	0ms
	18	26,857	3s663ms	0ms
	19	21,954	3s148ms	0ms
	20	15,478	2s63ms	0ms
	21	14,919	2s139ms	0ms
	22	6,150	943ms	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 (1044);

Date: 2025-01-24 17:21:53 Duration: 9ms
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 (915);

Date: 2025-01-24 17:21:53 Duration: 9ms
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 (1077);

Date: 2025-01-24 17:21:53 Duration: 9ms

7

381,018

Details

1m6s

0ms

36ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 24	00	9,855	1s847ms	0ms
	01	9,178	1s879ms	0ms
	02	9,310	1s944ms	0ms
	03	10,711	2s172ms	0ms
	04	7,725	1s641ms	0ms
	05	3,916	822ms	0ms
	06	3,311	617ms	0ms
	07	2,584	404ms	0ms
	08	8,220	1s198ms	0ms
	09	17,883	2s821ms	0ms
	10	27,599	4s368ms	0ms
	11	19,473	3s77ms	0ms
	12	33,836	5s769ms	0ms
	13	30,681	5s521ms	0ms
	14	29,448	5s363ms	0ms
	15	30,315	4s833ms	0ms
	16	31,231	5s364ms	0ms
	17	27,448	4s766ms	0ms
	18	21,754	3s724ms	0ms
	19	17,576	2s963ms	0ms
	20	12,256	2s38ms	0ms
	21	11,753	2s274ms	0ms
	22	4,955	889ms	0ms

COMMIT;

Date: 2025-01-24 10:20:41 Duration: 36ms
COMMIT;

Date: 2025-01-24 14:54:53 Duration: 30ms
COMMIT;

Date: 2025-01-24 12:08:22 Duration: 28ms

8

290,043

Details

34s887ms

0ms

8ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 24	00	10,199	1s263ms	0ms
	01	8,269	926ms	0ms
	02	6,415	727ms	0ms
	03	8,674	966ms	0ms
	04	2,529	335ms	0ms
	05	1,360	183ms	0ms
	06	2,692	262ms	0ms
	07	1,440	181ms	0ms
	08	5,656	662ms	0ms
	09	15,824	1s928ms	0ms
	10	22,482	2s834ms	0ms
	11	14,707	1s841ms	0ms
	12	27,358	3s752ms	0ms
	13	20,913	2s869ms	0ms
	14	21,485	2s652ms	0ms
	15	22,319	2s672ms	0ms
	16	22,886	2s737ms	0ms
	17	20,135	2s267ms	0ms
	18	16,544	1s842ms	0ms
	19	14,299	1s554ms	0ms
	20	10,299	1s24ms	0ms
	21	9,717	974ms	0ms
	22	3,841	426ms	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 (5111448, 5099648, 5487618, 5480346, 5253070, 5099009, 5100294, 5113124, 5121221, 5486256, 5099709, 5100881, 5109825, 5486067, 5312897, 5099714, 5486523, 5132558, 5099119, 5099413, 5153262, 5099007, 5482478, 5099947, 5164982, 5100738, 5099008, 5100443, 5449136, 5101291, 5099129, 5276675, 5099035, 5486522, 5102004, 5322972, 5228115, 5116506, 5100511, 5099169, 5407864, 5108942, 5099646, 5482493, 5100110, 5099137, 5100774, 5099558, 5099010, 5099162, 5100432, 5099403, 5131467, 5099585, 5117072, 5108177, 5099111, 5477198, 5312886, 5119815, 5099013, 5486093, 5485738, 5485689, 5486094, 5122119, 5099296, 5100204, 5099187, 5099503, 5105697, 5115285, 5099873, 5486096, 5102476, 5100796, 5103299, 5480345, 5208059, 5101114, 5101468, 5302060, 5113109, 5427963, 5410750, 5101173, 5102785, 5164984, 5148945, 5486086, 5117613, 5486069, 5099285, 5118818, 5485688, 5481324, 5485740, 5483361, 5099426, 5112624, 5277198, 5099103, 5099236, 5476500, 5108561, 5486198, 5486066, 5112342, 5099924, 5486071, 5108675, 5131953, 5112487, 5099885, 5102257, 5100563, 5204092, 5099006, 5117278, 5485741, 5220077, 5242851, 5331386, 5099581, 5099334, 5099190, 5412458, 5483859, 5130723, 5305989, 5485739, 5485058, 5110171, 5099647, 5100148, 5118354, 5100714, 5099815, 5100471, 5099855, 5485062, 5113465, 5099356, 5351307, 5099037, 5099348, 5099271, 5446752, 5102552, 5099243, 5479020, 5107238, 5396451, 5106654, 5483329, 5134295, 5481328, 5099161, 5485345, 5353342, 5334154, 5482474, 5188095, 5151838, 5131812, 5273866, 5481881, 5264286, 5106305);

Date: 2025-01-24 17:21:57 Duration: 8ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5311642, 5113931, 5321548, 5099013, 5234120, 5182321, 5099005, 5291817, 5193920, 5112860, 5316776, 5359668, 5234790, 5210147, 5106122, 5099007, 5099533, 5417508, 5337614, 5099009, 5115849, 5099392, 5266065, 5417503, 5417504, 5099024, 5118711, 5099102, 5253395, 5149370, 5171438, 5106822, 5099712, 5103217, 5120051, 5203701, 5176426, 5101982, 5099254, 5106396);

Date: 2025-01-24 18:03:15 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 (5099503, 5099248, 5101592, 5229368, 5102203, 5099182, 5099722, 5100907, 5099646, 5099194, 5113923, 5442575, 5099244, 5112657, 5101992, 5489866, 5099128, 5100457, 5099333, 5099321, 5100628, 5113543, 5127516, 5202687, 5100564, 5103478, 5099010, 5489864, 5112237, 5099170, 5431020, 5101238, 5112321, 5193329, 5099129, 5114743, 5100901, 5099008, 5099224, 5099590, 5105698, 5258779, 5114693, 5102341, 5099014, 5099095, 5099027, 5102347, 5104705, 5100540, 5101423, 5489858, 5099360, 5489857, 5099540, 5099515, 5101207, 5169447, 5099246, 5099038, 5099401, 5099003, 5099853, 5100883, 5100952, 5099896, 5128326, 5106088, 5100148);

Date: 2025-01-24 17:21:54 Duration: 6ms

9

285,736

Details

16s362ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 24	00	7,581	443ms	0ms
	01	6,421	372ms	0ms
	02	5,232	318ms	0ms
	03	5,919	360ms	0ms
	04	2,285	135ms	0ms
	05	1,358	78ms	0ms
	06	2,287	143ms	0ms
	07	1,485	83ms	0ms
	08	5,030	276ms	0ms
	09	14,026	761ms	0ms
	10	21,527	1s241ms	0ms
	11	15,219	829ms	0ms
	12	26,027	1s606ms	0ms
	13	22,200	1s358ms	0ms
	14	22,416	1s339ms	0ms
	15	22,336	1s233ms	0ms
	16	24,804	1s477ms	0ms
	17	22,204	1s248ms	0ms
	18	17,934	972ms	0ms
	19	15,184	851ms	0ms
	20	10,686	506ms	0ms
	21	9,844	528ms	0ms
	22	3,731	194ms	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 (35);

Date: 2025-01-24 11:17:48 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 (1, 126, 17);

Date: 2025-01-24 18:56:30 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 (35);

Date: 2025-01-24 17:21:53 Duration: 0ms

10

197,363

Details

58s733ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 24	00	2,924	897ms	0ms
	01	1,765	573ms	0ms
	02	1,573	516ms	0ms
	03	1,425	467ms	0ms
	04	1,811	580ms	0ms
	05	606	191ms	0ms
	06	1,029	310ms	0ms
	07	532	158ms	0ms
	08	3,897	1s116ms	0ms
	09	6,406	1s890ms	0ms
	10	12,221	3s737ms	0ms
	11	6,172	1s860ms	0ms
	12	14,412	4s573ms	0ms
	13	20,212	6s205ms	0ms
	14	17,898	5s479ms	0ms
	15	19,320	5s478ms	0ms
	16	25,606	7s572ms	0ms
	17	21,346	6s247ms	0ms
	18	14,130	4s49ms	0ms
	19	10,771	3s97ms	0ms
	20	5,074	1s378ms	0ms
	21	6,069	1s747ms	0ms
	22	2,164	602ms	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 = 1072) OR r.global) ORDER BY r.id;

Date: 2025-01-24 00:04:48 Duration: 2ms
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 = 835) OR r.global) ORDER BY r.id;

Date: 2025-01-24 12:28:47 Duration: 1ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1251) OR r.global) ORDER BY r.id;

Date: 2025-01-24 14:38:12 Duration: 1ms

11

193,672

Details

33s374ms

0ms

6ms

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
Jan 24	00	5,452	889ms	0ms
	01	3,447	663ms	0ms
	02	2,949	579ms	0ms
	03	3,548	723ms	0ms
	04	1,764	343ms	0ms
	05	864	159ms	0ms
	06	1,303	215ms	0ms
	07	1,020	156ms	0ms
	08	5,149	714ms	0ms
	09	10,702	1s685ms	0ms
	10	14,000	2s461ms	0ms
	11	9,794	1s658ms	0ms
	12	16,733	3s98ms	0ms
	13	16,626	2s959ms	0ms
	14	16,427	2s870ms	0ms
	15	16,574	2s714ms	0ms
	16	17,173	3s56ms	0ms
	17	15,138	2s590ms	0ms
	18	10,957	1s851ms	0ms
	19	9,088	1s533ms	0ms
	20	6,506	1s65ms	0ms
	21	6,103	997ms	0ms
	22	2,355	386ms	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 (8007032);

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

Date: 2025-01-24 17:21:53 Duration: 6ms
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 (8007442);

Date: 2025-01-24 17:21:53 Duration: 6ms

12

154,326

Details

25s169ms

0ms

3ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 24	00	2,629	402ms	0ms
	01	1,463	209ms	0ms
	02	1,626	229ms	0ms
	03	1,865	257ms	0ms
	04	2,541	336ms	0ms
	05	939	117ms	0ms
	06	940	140ms	0ms
	07	585	83ms	0ms
	08	4,704	686ms	0ms
	09	5,850	869ms	0ms
	10	8,301	1s427ms	0ms
	11	4,643	715ms	0ms
	12	11,053	1s976ms	0ms
	13	15,201	2s705ms	0ms
	14	14,331	2s476ms	0ms
	15	15,277	2s468ms	0ms
	16	16,947	2s933ms	0ms
	17	16,059	2s646ms	0ms
	18	11,079	1s731ms	0ms
	19	7,761	1s208ms	0ms
	20	4,301	623ms	0ms
	21	4,196	642ms	0ms
	22	2,035	282ms	0ms

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

Date: 2025-01-24 17:26:34 Duration: 3ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-24 17:48:06 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-24 15:54:29 Duration: 1ms

13

141,942

Details

21h50m34s

371ms

857ms

553ms

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
Jan 24	00	7,894	1h13m55s	561ms
	01	7,779	1h11m41s	552ms
	02	8,429	1h17m55s	554ms
	03	10,984	1h42m41s	560ms
	04	5,889	53m2s	540ms
	05	2,165	19m11s	531ms
	06	2,892	27m18s	566ms
	07	1,048	9m19s	533ms
	08	1,593	14m18s	538ms
	09	5,168	46m42s	542ms
	10	7,189	1h5m27s	546ms
	11	5,698	52m7s	548ms
	12	11,021	1h43m48s	565ms
	13	10,242	1h35m5s	557ms
	14	10,150	1h35m28s	564ms
	15	5,889	54m2s	550ms
	16	7,977	1h15m42s	569ms
	17	7,617	1h10m4s	552ms
	18	6,080	54m46s	540ms
	19	6,163	56m19s	548ms
	20	4,025	36m23s	542ms
	21	4,938	45m8s	548ms
	22	1,112	10m1s	541ms

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

Date: 2025-01-24 16:53:11 Duration: 857ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748179)) AND (("shipping_track"."id" not in (39290438, 39290438)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:09 Duration: 855ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748188)) AND (("shipping_track"."id" not in (39290557, 39290557)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:24 Duration: 847ms

14

124,937

Details

31s440ms

0ms

36ms

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
Jan 24	00	4,915	1s227ms	0ms
	01	3,726	945ms	0ms
	02	2,901	746ms	0ms
	03	4,004	1s60ms	0ms
	04	892	273ms	0ms
	05	485	159ms	0ms
	06	1,668	433ms	0ms
	07	534	157ms	0ms
	08	2,278	515ms	0ms
	09	6,237	1s648ms	0ms
	10	8,644	2s323ms	0ms
	11	5,776	1s529ms	0ms
	12	10,730	2s945ms	0ms
	13	8,928	2s530ms	0ms
	14	9,991	2s356ms	0ms
	15	9,312	2s310ms	0ms
	16	10,151	2s525ms	0ms
	17	9,097	2s196ms	0ms
	18	7,216	1s661ms	0ms
	19	6,700	1s504ms	0ms
	20	4,527	1s18ms	0ms
	21	4,593	996ms	0ms
	22	1,632	373ms	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 (32653961, 42174864, 32230540, 32230077, 32191542, 32206720, 32207454, 32269331, 42083846, 32179179, 42071712, 41929154, 42168689, 32276794, 32268681, 32269312, 32629890, 32629860, 32653889, 32656635, 32269214, 32269313, 32249025, 32630040, 32217625, 32276795, 32278306, 42088971, 32242675, 32242680, 32227779, 32267160, 32230693, 42042746, 32240224, 32227082, 32661617, 42105635, 42170283, 42121531, 32266317, 32265685, 42057233, 42150024, 42142701, 41664340, 32265643, 32240919, 32182807, 32212412, 42056028, 32242738, 32195155, 42103930, 42023017, 41905610, 42171371, 32203703, 42081340, 32183865, 32204460, 32662849, 42141474, 32198327, 42139418, 32235307, 32235471, 32264154, 42163923, 32255950, 32227394, 32215709, 32218289, 42073804, 32205874, 42049964, 42085501, 32196884, 42102996, 42092391, 42095861, 32219052, 32661968, 42054137, 32198367, 32193217, 32198366, 32259582, 41801986, 32222224, 41822332, 42163671, 32220994, 42161838, 32259784, 32259738, 32263845, 32184319, 42088411, 32230040, 32229968, 32190304, 42155907, 32652140, 42145707, 32229565, 42134176, 42134369, 41994454, 32246504, 32245868, 32219184, 32218857, 32216635, 42127147, 42021000, 42000724, 32246258, 32246257, 32245748, 42085450, 32255748, 41473164, 42103450, 32259666, 42102686, 32259648, 42170107, 42075870, 42002384, 40518883, 42167495, 41801027, 41654406, 32184781, 42137859, 32188026, 42128942);

Date: 2025-01-24 17:21:54 Duration: 36ms
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 (32247861, 32201442, 32201009, 32201004, 32201010, 32201008, 32201006, 32201011, 32201005, 32201007, 32201012, 32201013, 32201591, 32201589, 32200726, 32200725, 32200727, 32200724, 32200723, 32201590, 32200771, 32200754, 32200766, 32200761, 32200764, 32200757, 32200756, 32200765, 32200763, 32200760, 32200758, 32200755, 32200762, 32200759, 32200753, 32201585, 32201584, 32201588, 32201587, 32201586, 42134884, 42135141, 41905106, 41905139, 32247041, 32247333, 42134889, 41905112, 41905134, 41905116, 42134882, 41905122, 32247863, 32247862, 42080681, 42080680, 42081410, 42081411, 42081408, 42081407, 42081406, 42081405, 42081404, 42081402, 42081403, 42080682, 42080683, 42080684, 42080685, 42080686, 42080687, 42080688, 32183246, 32183247, 32183248, 32183249, 32183250, 32183251, 32183253, 32181800, 32181799, 32181798, 42132567, 32183252, 32247350, 32183254, 42131655, 42132568, 32183256, 32246012, 32183255, 32248298, 32247353, 42134589, 42131662, 42131661, 32248294, 32248303, 32200568, 32248566);

Date: 2025-01-24 17:21:54 Duration: 9ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (32184325, 32277952, 32277231, 42032966, 32213970, 32217480, 32656841, 32213824, 41991626, 42058290);

Date: 2025-01-24 17:21:53 Duration: 9ms

15

98,543

Details

7s896ms

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
Jan 24	00	2,894	216ms	0ms
	01	2,474	195ms	0ms
	02	1,994	161ms	0ms
	03	2,435	212ms	0ms
	04	887	73ms	0ms
	05	485	41ms	0ms
	06	594	43ms	0ms
	07	516	38ms	0ms
	08	2,002	147ms	0ms
	09	5,611	415ms	0ms
	10	7,871	624ms	0ms
	11	5,121	388ms	0ms
	12	9,542	830ms	0ms
	13	7,491	671ms	0ms
	14	7,797	692ms	0ms
	15	8,032	686ms	0ms
	16	7,871	763ms	0ms
	17	6,883	602ms	0ms
	18	5,554	397ms	0ms
	19	4,712	261ms	0ms
	20	3,439	185ms	0ms
	21	3,091	173ms	0ms
	22	1,247	72ms	0ms

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

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

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

Date: 2025-01-24 17:21:53 Duration: 1ms

16

90,684

Details

1h9m14s

36ms

103ms

45ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3,526	2m37s	44ms
	01	3,375	2m32s	45ms
	02	3,038	2m20s	46ms
	03	4,361	3m18s	45ms
	04	1,883	1m25s	45ms
	05	626	28s490ms	45ms
	06	1,264	56s572ms	44ms
	07	640	28s921ms	45ms
	08	1,003	45s718ms	45ms
	09	3,993	3m1s	45ms
	10	5,455	4m10s	45ms
	11	4,384	3m20s	45ms
	12	9,265	7m17s	47ms
	13	7,594	5m54s	46ms
	14	8,514	6m39s	46ms
	15	4,991	3m50s	46ms
	16	6,385	4m58s	46ms
	17	5,206	3m56s	45ms
	18	4,403	3m14s	44ms
	19	3,940	2m54s	44ms
	20	2,868	2m6s	44ms
	21	3,241	2m23s	44ms
	22	729	32s422ms	44ms

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

Date: 2025-01-24 17:21:59 Duration: 103ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4696225)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 17:22:00 Duration: 80ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3353086)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 15:12:50 Duration: 78ms

17

84,100

Details

4s462ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,273	65ms	0ms
	01	631	32ms	0ms
	02	582	30ms	0ms
	03	554	28ms	0ms
	04	752	36ms	0ms
	05	235	11ms	0ms
	06	398	20ms	0ms
	07	211	10ms	0ms
	08	1,708	84ms	0ms
	09	2,575	127ms	0ms
	10	4,971	268ms	0ms
	11	2,348	123ms	0ms
	12	5,990	340ms	0ms
	13	8,299	460ms	0ms
	14	7,494	407ms	0ms
	15	8,330	423ms	0ms
	16	10,745	585ms	0ms
	17	9,452	505ms	0ms
	18	6,417	334ms	0ms
	19	4,981	255ms	0ms
	20	2,421	120ms	0ms
	21	2,715	138ms	0ms
	22	1,018	49ms	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 (21);

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

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

Date: 2025-01-24 16:10:30 Duration: 0ms

18

80,758

Details

8s983ms

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,258	137ms	0ms
	01	628	68ms	0ms
	02	570	63ms	0ms
	03	529	58ms	0ms
	04	743	77ms	0ms
	05	232	23ms	0ms
	06	392	42ms	0ms
	07	211	22ms	0ms
	08	1,657	174ms	0ms
	09	2,539	266ms	0ms
	10	4,903	555ms	0ms
	11	2,207	246ms	0ms
	12	5,815	700ms	0ms
	13	7,865	912ms	0ms
	14	7,089	810ms	0ms
	15	7,987	836ms	0ms
	16	9,773	1s114ms	0ms
	17	9,250	1s39ms	0ms
	18	6,255	681ms	0ms
	19	4,879	524ms	0ms
	20	2,342	239ms	0ms
	21	2,638	285ms	0ms
	22	996	101ms	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 (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-24 13:39:20 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 (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-24 12:28:47 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-24 13:03:43 Duration: 0ms

19

78,647

Details

5s204ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 24	00	2,242	117ms	0ms
	01	2,757	123ms	0ms
	02	2,498	109ms	0ms
	03	2,903	131ms	0ms
	04	1,550	92ms	0ms
	05	763	35ms	0ms
	06	777	40ms	0ms
	07	527	21ms	0ms
	08	1,345	76ms	0ms
	09	3,671	186ms	0ms
	10	6,222	382ms	0ms
	11	3,487	192ms	0ms
	12	6,239	427ms	0ms
	13	5,966	463ms	0ms
	14	5,494	405ms	0ms
	15	5,662	417ms	0ms
	16	6,069	503ms	0ms
	17	6,249	526ms	0ms
	18	4,555	357ms	0ms
	19	3,659	238ms	0ms
	20	2,916	159ms	0ms
	21	2,257	148ms	0ms
	22	839	45ms	0ms

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

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

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

Date: 2025-01-24 17:18:48 Duration: 0ms

20

73,953

Details

19s711ms

0ms

26ms

0ms

insert into "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") values (?, ?, ?, ?, ?, false, null, true, ?, ?, ?, null, null, ?, null, ?, ?, ?) returning "id";

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 24	00	4,939	1s228ms	0ms
	01	4,476	1s103ms	0ms
	02	3,406	817ms	0ms
	03	5,788	1s377ms	0ms
	04	1,524	344ms	0ms
	05	696	142ms	0ms
	06	1,758	475ms	0ms
	07	223	51ms	0ms
	08	737	168ms	0ms
	09	3,026	803ms	0ms
	10	3,911	1s138ms	0ms
	11	3,072	839ms	0ms
	12	5,620	1s523ms	0ms
	13	3,837	1s37ms	0ms
	14	5,622	1s392ms	0ms
	15	3,163	898ms	0ms
	16	5,526	1s485ms	0ms
	17	3,184	1s153ms	0ms
	18	3,156	946ms	0ms
	19	3,560	1s3ms	0ms
	20	2,677	703ms	0ms
	21	3,453	921ms	0ms
	22	599	154ms	0ms

INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8006294, '', '2025-01-24 20:46:42.965690', 931, '2025-01-24 20:47:16', false, NULL, true, '<608107362288103.1737751636.573811054229736-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4667030, NULL, 2, '2025-01-24 20:46:42.965690', 931) RETURNING "id";

Date: 2025-01-24 21:47:16 Duration: 26ms
INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8007030, '', '2025-01-23 23:26:57.960569', 1212, '2025-01-23 23:28:03', false, NULL, true, '<445329838044141.1737674883.394310712814331-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4732464, NULL, 2, '2025-01-23 23:26:57.960569', 1212) RETURNING "id";

Date: 2025-01-24 00:28:03 Duration: 26ms
INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8006444, '', '2025-01-24 00:19:23.296968', 1072, '2025-01-24 00:20:50', false, NULL, true, '<675496162095791.1737678050.932697534561157-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4724262, NULL, 2, '2025-01-24 00:19:23.296968', 1072) RETURNING "id";

Date: 2025-01-24 01:20:50 Duration: 23ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

39m25s

1m38s

24

Details

39m25s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 24	03	2	3ms	1ms
	08	3	0ms	0ms
	09	1	0ms	0ms
	11	2	1ms	0ms
	12	3	3ms	1ms
	13	8	7ms	0ms
	14	1	39m25s	39m25s
	16	1	0ms	0ms
	18	1	1ms	1ms
	20	1	0ms	0ms
	21	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2025-01-24 13:53:54.604985', "last_update" = '2025-01-24 13:08:54.605016', "write_date" = '2025-01-24 13:08:54.108126', "write_uid" = 865 WHERE id IN (865);

Date: 2025-01-24 14:48:20 Duration: 39m25s
UPDATE "res_users" SET "exp_date" = '2025-01-24 13:16:37.931971', "last_update" = '2025-01-24 12:31:37.932000', "write_date" = '2025-01-24 12:31:37.563761', "write_uid" = 992 WHERE id IN (992);

Date: 2025-01-24 13:31:37 Duration: 1ms
UPDATE "res_users" SET "exp_date" = '2025-01-24 13:35:40.532914', "last_update" = '2025-01-24 12:50:40.532963', "write_date" = '2025-01-24 12:50:40.176891', "write_uid" = 1338 WHERE id IN (1338);

Date: 2025-01-24 13:50:40 Duration: 1ms

2

0ms

24m18s

46s177ms

160

Details

2h3m8s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3	3ms	1ms
	01	2	1ms	0ms
	02	2	0ms	0ms
	03	5	1ms	0ms
	04	1	1ms	1ms
	05	1	0ms	0ms
	08	9	2ms	0ms
	09	5	0ms	0ms
	10	6	7ms	1ms
	11	7	5ms	0ms
	12	12	12ms	1ms
	13	19	1h36m17s	5m4s
	14	22	19ms	0ms
	15	10	14ms	1ms
	16	9	26m50s	2m58s
	17	21	21ms	1ms
	18	5	4ms	0ms
	19	8	8ms	1ms
	20	7	6ms	0ms
	21	4	3ms	0ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-24 12:50:44.948657', "last_update" = '2025-01-24 12:05:44.948687', "sid" = '0be4b1cceef3d255491fffac49cfb42cd8286ed5', "write_date" = '2025-01-24 12:05:44.612946', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 24m18s
UPDATE "res_users" SET "exp_date" = '2025-01-24 12:54:56.318368', "last_update" = '2025-01-24 12:09:56.318389', "sid" = '8d835220d5009413bff0f87a596acff65b16cecd', "write_date" = '2025-01-24 12:09:55.983440', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 20m7s
UPDATE "res_users" SET "exp_date" = '2025-01-24 12:56:09.412259', "last_update" = '2025-01-24 12:11:09.412298', "sid" = '803cf1856752136ca7a86137f17530f439aef529', "write_date" = '2025-01-24 12:11:09.055982', "write_uid" = 1294 WHERE id IN (1294);

Date: 2025-01-24 13:30:03 Duration: 18m54s

3

0ms

59m59s

6s218ms

34,973

Details

2d12h24m52s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 24	00	874	196ms	0ms
	01	1,058	17s223ms	16ms
	02	901	39s776ms	44ms
	03	984	230ms	0ms
	04	776	170ms	0ms
	05	463	99ms	0ms
	06	240	56ms	0ms
	07	211	50ms	0ms
	08	663	143ms	0ms
	09	1,501	331ms	0ms
	10	2,291	4h29m58s	7s70ms
	11	1,526	51m17s	2s16ms
	12	2,993	4h43m49s	5s689ms
	13	2,910	6h56m49s	8s594ms
	14	2,687	1h14m23s	1s661ms
	15	2,943	14h12m56s	17s389ms
	16	2,852	5h13m18s	6s591ms
	17	2,722	4h21m41s	5s768ms
	18	2,122	5h14m48s	8s901ms
	19	1,606	1h2m51s	2s348ms
	20	1,138	12h1m58s	38s65ms
	21	1,014	219ms	0ms
	22	498	104ms	0ms

update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629103', exp_date = '2025-01-24 08:55:16.629105', logged_in = 'TRUE' where id = 874;

Date: 2025-01-24 10:10:16 Duration: 59m59s
update res_users set sid = '920efcc7fb6e3c80bc3ecd3cccb006d7066f55e2', last_update = '2025-01-24 08:10:16.629118', exp_date = '2025-01-24 08:55:16.629120', logged_in = 'TRUE' where id = 874;

Date: 2025-01-24 10:10:16 Duration: 59m59s
update res_users set sid = '9eaad8c43c41c82d29698a566e165bcfdcf46db7', last_update = '2025-01-24 09:34:05.036001', exp_date = '2025-01-24 10:19:05.036005', logged_in = 'TRUE' where id = 826;

Date: 2025-01-24 11:25:22 Duration: 51m17s

4

27ms

3s637ms

2s799ms

142

Details

6m37s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 24	10	5	15s226ms	3s45ms
	12	11	34s561ms	3s141ms
	13	9	15s542ms	1s726ms
	14	6	18s377ms	3s62ms
	15	9	27s643ms	3s71ms
	16	22	1m8s	3s122ms
	17	3	9s84ms	3s28ms
	18	13	26s924ms	2s71ms
	19	46	2m17s	2s981ms
	20	9	17s673ms	1s963ms
	21	3	8s963ms	2s987ms
	22	6	17s635ms	2s939ms

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

Date: 2025-01-24 12:45:57 Duration: 3s637ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))) 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 (7)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (7))))))))) 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 (7)))))))) AND ("policy_number"."name"::text ilike '%59001%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-24 12:45:59 Duration: 3s524ms
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))))))) AND ("policy_number"."name"::text ilike '%116050%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-24 16:11:53 Duration: 3s517ms

5

822ms

1s122ms

902ms

6,013

Details

1h30m26s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,305	19m42s	905ms
	01	769	11m35s	905ms
	02	296	4m28s	906ms
	03	341	5m11s	913ms
	07	9	8s252ms	916ms
	08	31	28s156ms	908ms
	10	2	1s877ms	938ms
	11	4	3s670ms	917ms
	12	2	1s904ms	952ms
	13	31	29s176ms	941ms
	14	90	1m22s	913ms
	15	60	56s595ms	943ms
	16	71	1m5s	927ms
	17	201	3m3s	914ms
	18	742	11m8s	901ms
	19	1,024	15m16s	894ms
	20	446	6m37s	892ms
	21	586	8m41s	890ms
	22	3	2s618ms	872ms

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

Date: 2025-01-24 16:49:06 Duration: 1s122ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9896645')) 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 (77))))))) 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 (77)))))) 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 (77)))))) 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 (77))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 18:20:45 Duration: 1s121ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '31042')) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 15:18:17 Duration: 1s116ms

6

389ms

1s432ms

563ms

25,402

Details

3h58m25s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 24	00	244	2m24s	590ms
	01	318	3m6s	587ms
	02	244	2m28s	610ms
	03	218	2m21s	649ms
	04	160	1m40s	625ms
	05	81	49s728ms	613ms
	06	511	4m40s	548ms
	07	111	1m1s	555ms
	08	276	2m32s	550ms
	09	1,207	11m7s	552ms
	10	1,768	16m36s	563ms
	11	1,418	13m15s	560ms
	12	2,560	24m54s	583ms
	13	2,456	23m26s	572ms
	14	2,313	22m26s	582ms
	15	1,594	15m1s	565ms
	16	2,322	22m	568ms
	17	2,955	26m50s	544ms
	18	1,509	13m33s	538ms
	19	1,196	10m44s	538ms
	20	816	7m20s	539ms
	21	809	7m16s	539ms
	22	316	2m47s	529ms

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

Date: 2025-01-24 17:21:59 Duration: 1s432ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3341580)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 14:27:41 Duration: 1s40ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4721644, 4724725, 4727813, 4727829, 4727919, 4729998, 4730203, 4730233, 4730051, 4732717, 4732257, 4732947, 4733933, 4733735, 4734735, 4734832, 4734776, 4735513, 4736521, 4736936, 4735800, 4736344, 4738813, 4738832, 4739221, 4739399, 4739504, 4739475, 4739795, 4739805, 4739981, 4739969, 4743725, 4738022, 4738297, 4736568, 4726643, 4739434, 4730636, 4744383, 4746325, 4746330)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 12:45:25 Duration: 954ms

7

371ms

857ms

553ms

141,942

Details

21h50m34s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 24	00	7,894	1h13m55s	561ms
	01	7,779	1h11m41s	552ms
	02	8,429	1h17m55s	554ms
	03	10,984	1h42m41s	560ms
	04	5,889	53m2s	540ms
	05	2,165	19m11s	531ms
	06	2,892	27m18s	566ms
	07	1,048	9m19s	533ms
	08	1,593	14m18s	538ms
	09	5,168	46m42s	542ms
	10	7,189	1h5m27s	546ms
	11	5,698	52m7s	548ms
	12	11,021	1h43m48s	565ms
	13	10,242	1h35m5s	557ms
	14	10,150	1h35m28s	564ms
	15	5,889	54m2s	550ms
	16	7,977	1h15m42s	569ms
	17	7,617	1h10m4s	552ms
	18	6,080	54m46s	540ms
	19	6,163	56m19s	548ms
	20	4,025	36m23s	542ms
	21	4,938	45m8s	548ms
	22	1,112	10m1s	541ms

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

Date: 2025-01-24 16:53:11 Duration: 857ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748179)) AND (("shipping_track"."id" not in (39290438, 39290438)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:09 Duration: 855ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4748188)) AND (("shipping_track"."id" not in (39290557, 39290557)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-24 16:53:24 Duration: 847ms

8

183ms

601ms

299ms

21,129

Details

1h45m21s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 24	08	506	2m40s	316ms
	09	1,533	7m15s	284ms
	10	3,098	14m55s	288ms
	11	1,455	7m12s	297ms
	12	1,549	8m3s	312ms
	13	2,422	12m40s	314ms
	14	2,987	14m30s	291ms
	15	3,352	17m1s	304ms
	16	2,849	14m43s	310ms
	17	810	3m40s	272ms
	18	568	2m37s	276ms

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

Date: 2025-01-24 12:47:02 Duration: 601ms
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" = '9910172')))) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:47:02 Duration: 596ms
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" = '9910904')))) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:46:58 Duration: 592ms

9

224ms

431ms

265ms

8,101

Details

35m49s

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
Jan 24	00	682	3m2s	266ms
	01	442	1m57s	266ms
	02	602	2m42s	270ms
	03	1,253	5m39s	271ms
	06	976	4m15s	261ms
	07	5	1s272ms	254ms
	08	30	7s596ms	253ms
	09	69	17s742ms	257ms
	10	15	3s927ms	261ms
	11	93	24s756ms	266ms
	12	82	22s225ms	271ms
	13	51	15s449ms	302ms
	14	109	30s182ms	276ms
	15	50	13s624ms	272ms
	16	961	4m22s	272ms
	17	836	3m39s	262ms
	18	178	45s625ms	256ms
	19	349	1m30s	260ms
	20	382	1m39s	260ms
	21	703	2m59s	255ms
	22	233	57s796ms	248ms

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

Date: 2025-01-24 16:53:24 Duration: 431ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9947167')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 17:23:14 Duration: 419ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9726484')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-01-24 16:53:28 Duration: 418ms

10

91ms

814ms

234ms

27,847

Details

1h48m58s

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
Jan 24	00	3,912	15m14s	233ms
	01	2,396	9m12s	230ms
	02	1,766	7m13s	245ms
	03	3,158	12m33s	238ms
	06	1,942	8m	247ms
	07	28	8s885ms	317ms
	08	120	20s475ms	170ms
	09	128	23s746ms	185ms
	10	24	5s50ms	210ms
	11	188	48s389ms	257ms
	12	154	30s24ms	194ms
	13	152	39s633ms	260ms
	14	384	1m38s	257ms
	15	216	52s163ms	241ms
	16	2,037	8m28s	249ms
	17	2,052	8m39s	253ms
	18	1,830	6m47s	222ms
	19	2,708	10m7s	224ms
	20	1,636	5m54s	216ms
	21	2,544	9m48s	231ms
	22	472	1m32s	194ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 06:26:53 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سيد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 06:26:53 Duration: 813ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'بدون')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-24 03:46:01 Duration: 807ms

11

197ms

302ms

227ms

2,726

Details

10m20s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 24	00	120	27s199ms	226ms
	01	120	27s52ms	225ms
	02	120	27s338ms	227ms
	03	120	27s722ms	231ms
	04	120	26s944ms	224ms
	05	120	26s916ms	224ms
	06	120	26s883ms	224ms
	07	120	26s827ms	223ms
	08	120	26s790ms	223ms
	09	120	27s170ms	226ms
	10	120	27s498ms	229ms
	11	120	27s488ms	229ms
	12	120	28s397ms	236ms
	13	120	28s508ms	237ms
	14	120	28s884ms	240ms
	15	120	27s707ms	230ms
	16	120	27s944ms	232ms
	17	116	26s367ms	227ms
	18	120	26s838ms	223ms
	19	120	26s656ms	222ms
	20	120	26s647ms	222ms
	21	120	26s631ms	221ms
	22	90	19s940ms	221ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 14:45:02 Duration: 302ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 12:47:02 Duration: 296ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-24 12:47:02 Duration: 295ms

12

173ms

321ms

210ms

66,867

Details

3h54m4s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,284	4m26s	207ms
	01	1,851	6m18s	204ms
	02	2,661	9m9s	206ms
	03	3,837	13m16s	207ms
	04	3,445	11m43s	204ms
	05	1,645	5m37s	204ms
	06	849	2m52s	203ms
	07	455	1m33s	204ms
	08	1,589	5m24s	204ms
	09	4,136	14m21s	208ms
	10	4,469	15m41s	210ms
	11	3,468	12m1s	208ms
	12	5,440	19m49s	218ms
	13	6,927	24m51s	215ms
	14	7,066	25m15s	214ms
	15	5,349	18m55s	212ms
	16	6,431	22m43s	212ms
	17	2,803	9m33s	204ms
	18	2,363	7m51s	199ms
	19	305	59s897ms	196ms
	20	197	38s749ms	196ms
	21	154	30s282ms	196ms
	22	143	28s418ms	198ms

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

Date: 2025-01-24 14:44:40 Duration: 321ms
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" = '9985352')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-24 12:46:53 Duration: 305ms
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" = '9852932')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-24 12:47:00 Duration: 305ms

13

178ms

295ms

208ms

7,011

Details

24m21s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 24	00	11	2s264ms	205ms
	01	90	18s188ms	202ms
	02	108	22s826ms	211ms
	03	17	3s686ms	216ms
	04	164	33s969ms	207ms
	05	217	44s543ms	205ms
	06	193	39s445ms	204ms
	07	443	1m30s	205ms
	08	83	17s136ms	206ms
	09	196	41s344ms	210ms
	10	152	31s483ms	207ms
	11	541	1m53s	210ms
	12	544	1m55s	211ms
	13	1,008	3m35s	213ms
	14	737	2m42s	220ms
	15	430	1m29s	208ms
	16	373	1m18s	209ms
	17	431	1m28s	206ms
	18	621	2m3s	199ms
	19	305	1m	196ms
	20	193	38s88ms	197ms
	21	154	30s271ms	196ms

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

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

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

Date: 2025-01-24 14:44:40 Duration: 285ms

14

179ms

275ms

207ms

11,998

Details

41m24s

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
Jan 24	00	1,044	3m35s	206ms
	01	1,603	5m28s	204ms
	02	2,303	8m1s	208ms
	03	2,879	10m4s	209ms
	04	3,269	11m9s	204ms
	05	900	3m5s	205ms

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

Date: 2025-01-24 03:50:46 Duration: 275ms
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" = '9656857')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 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, 115)))) ORDER BY "shipping_policy"."id" DESC;

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

Date: 2025-01-24 03:50:40 Duration: 269ms

15

122ms

226ms

150ms

2,943

Details

7m22s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 24	00	32	4s699ms	146ms
	01	15	2s186ms	145ms
	06	5	736ms	147ms
	07	11	1s637ms	148ms
	08	8	1s163ms	145ms
	09	75	10s987ms	146ms
	10	261	39s364ms	150ms
	11	291	44s211ms	151ms
	12	494	1m16s	154ms
	13	573	1m28s	153ms
	14	287	44s876ms	156ms
	15	269	40s711ms	151ms
	16	155	23s828ms	153ms
	17	144	20s511ms	142ms
	18	89	11s964ms	134ms
	19	106	14s202ms	133ms
	20	45	5s966ms	132ms
	21	59	7s757ms	131ms
	22	24	3s186ms	132ms

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

Date: 2025-01-24 12:58:37 Duration: 226ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 39)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-24 12:45:23 Duration: 208ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 73)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2025-01-24 12:28:47 Duration: 208ms

16

96ms

183ms

116ms

5,998

Details

11m37s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 24	00	84	9s189ms	109ms
	01	24	2s761ms	115ms
	02	18	2s95ms	116ms
	06	91	10s542ms	115ms
	08	77	8s505ms	110ms
	09	262	30s235ms	115ms
	10	347	40s396ms	116ms
	11	171	20s31ms	117ms
	12	533	1m3s	119ms
	13	786	1m32s	117ms
	14	1,196	2m20s	117ms
	15	464	53s171ms	114ms
	16	525	1m1s	116ms
	17	548	1m3s	116ms
	18	331	37s617ms	113ms
	19	277	31s135ms	112ms
	20	157	18s129ms	115ms
	21	69	7s795ms	112ms
	22	38	4s400ms	115ms

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

Date: 2025-01-24 17:23:08 Duration: 183ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8031371)) AND (("cash_track"."id" not in (7315126)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-24 15:23:05 Duration: 160ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8030671)) AND (("cash_track"."id" not in (7311309)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-24 12:58:37 Duration: 157ms

17

45ms

110ms

64ms

33,659

Details

35m58s

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

Day	Hour	Count	Duration	Avg duration
Jan 24	00	22	1s332ms	60ms
	02	3	194ms	64ms
	03	10	638ms	63ms
	04	16	1s33ms	64ms
	05	18	1s160ms	64ms
	06	35	2s214ms	63ms
	07	19	1s241ms	65ms
	08	427	27s128ms	63ms
	09	3,110	3m17s	63ms
	10	2,021	2m9s	64ms
	11	1,151	1m13s	64ms
	12	5,219	5m40s	65ms
	13	2,978	3m12s	64ms
	14	7,420	8m10s	66ms
	15	3,333	3m34s	64ms
	16	4,345	4m43s	65ms
	17	2,085	2m2s	58ms
	18	1,304	1m9s	53ms
	19	39	2s69ms	53ms
	20	44	2s392ms	54ms
	21	36	1s959ms	54ms
	22	24	1s303ms	54ms

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

Date: 2025-01-24 14:45:03 Duration: 110ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4702262) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:58:34 Duration: 100ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4575513) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-24 15:31:46 Duration: 100ms

18

39ms

83ms

58ms

16,218

Details

15m55s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 24	08	358	20s797ms	58ms
	09	1,618	1m34s	58ms
	10	1,010	59s771ms	59ms
	11	836	50s391ms	60ms
	12	2,503	2m30s	60ms
	13	2,056	2m4s	60ms
	14	2,213	2m13s	60ms
	15	2,333	2m18s	59ms
	16	1,828	1m49s	59ms
	17	895	47s10ms	52ms
	18	568	27s494ms	48ms

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

Date: 2025-01-24 16:53:16 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4683611) ORDER BY "collection_policy"."id";

Date: 2025-01-24 16:53:16 Duration: 83ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4698943) ORDER BY "collection_policy"."id";

Date: 2025-01-24 12:28:50 Duration: 81ms

19

36ms

103ms

45ms

90,684

Details

1h9m14s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 24	00	3,526	2m37s	44ms
	01	3,375	2m32s	45ms
	02	3,038	2m20s	46ms
	03	4,361	3m18s	45ms
	04	1,883	1m25s	45ms
	05	626	28s490ms	45ms
	06	1,264	56s572ms	44ms
	07	640	28s921ms	45ms
	08	1,003	45s718ms	45ms
	09	3,993	3m1s	45ms
	10	5,455	4m10s	45ms
	11	4,384	3m20s	45ms
	12	9,265	7m17s	47ms
	13	7,594	5m54s	46ms
	14	8,514	6m39s	46ms
	15	4,991	3m50s	46ms
	16	6,385	4m58s	46ms
	17	5,206	3m56s	45ms
	18	4,403	3m14s	44ms
	19	3,940	2m54s	44ms
	20	2,868	2m6s	44ms
	21	3,241	2m23s	44ms
	22	729	32s422ms	44ms

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

Date: 2025-01-24 17:21:59 Duration: 103ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4696225)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 17:22:00 Duration: 80ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3353086)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-24 15:12:50 Duration: 78ms

20

0ms

1m40s

23ms

14,272

Details

5m32s

update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 24	00	1,956	2m42s	82ms
	01	1,191	239ms	0ms
	02	884	190ms	0ms
	03	1,576	41s444ms	26ms
	06	981	205ms	0ms
	07	14	2ms	0ms
	08	63	14ms	0ms
	09	81	29ms	0ms
	10	34	16ms	0ms
	11	108	26ms	0ms
	12	110	30ms	0ms
	13	104	32ms	0ms
	14	221	55ms	0ms
	15	138	36ms	0ms
	16	1,056	253ms	0ms
	17	1,071	293ms	0ms
	18	947	232ms	0ms
	19	1,377	2m6s	92ms
	20	834	159ms	0ms
	21	1,281	290ms	0ms
	22	245	56ms	0ms

UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-23 23:34:06.863260', "write_uid" = 975 WHERE id IN (32227942);

Date: 2025-01-24 00:35:49 Duration: 1m40s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-24 18:19:17.426810', "write_uid" = 868 WHERE id IN (32276248);

Date: 2025-01-24 19:20:48 Duration: 1m28s
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-23 23:51:23.547900', "write_uid" = 1223 WHERE id IN (32227933);

Date: 2025-01-24 00:53:53 Duration: 1m1s

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

10,656,943 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	5	0.00%
DETAIL	193	0.00%
ERROR	1,459	0.01%
EVENTLOG	677	0.01%
FATAL	748	0.01%
HINT	5	0.00%
LOG	10,652,392	99.96%
STATEMENT	1,464	0.01%

Events distribution (except queries)

Key values

0 PANIC entries
748 FATAL entries
1459 ERROR entries
0 WARNING entries
677 EVENTLOG entries

Most Frequent Errors/Events

Key values

771 Max number of times the same event was reported
2,884 Total events found

Rank

Times reported

Error

1

771

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 24	00	6
	01	8
	02	17
	03	14
	04	11
	05	1
	06	2
	07	3
	08	27
	09	35
	10	55
	11	38
	12	46
	13	80
	14	85
	15	62
	16	91
	17	60
	18	35
	19	46
	20	19
	21	16
	22	14

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

634

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 24	00	3
	01	4
	02	4
	03	4
	04	6
	05	1
	06	2
	07	2
	08	22
	09	28
	10	47
	11	28
	12	38
	13	61
	14	72
	15	58
	16	77
	17	58
	18	32
	19	38
	20	19
	21	16
	22	14

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

461

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 24	10	56
	12	48
	13	67
	14	31
	15	91
	16	53
	17	28
	18	31
	19	7
	20	49

4

461

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 24	10	56
	12	48
	13	67
	14	31
	15	91
	16	53
	17	28
	18	31
	19	7
	20	49

5

166

Details

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

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 24	06	6
	17	3
	18	81
	19	76

FATAL: password authentication failed for user "postgres"
FATAL: password authentication failed for user "root"
FATAL: password authentication failed for user "admin"

6

149

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 24	10	9
	11	5
	12	16
	13	31
	14	2
	15	37
	16	15
	17	4
	18	7
	19	8
	20	15

7

83

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 24	17	83

FATAL: terminating connection due to administrator command

8

66

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 24	04	1
	10	5
	12	9
	13	10
	15	16
	16	8
	17	3
	18	3
	19	4
	20	7

9

19

Details

ERROR: could not create unique index "..."

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 24	13	15
	18	4

ERROR: could not create unique index "bank_deposit_deposite_2_name"
ERROR: could not create unique index "urgent_phone_mobile_urgent_name"

10

18

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 24	17	18

11

15

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 24	00	3
	01	2
	02	2
	03	2
	04	1
	05	1
	14	2
	16	1
	21	1

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

12

10

Details

ERROR: column "..." does not exist

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 24	13	10

ERROR: column "is_editable" of relation "money_collection_wizard" does not exist at character 94
ERROR: column "is_editable" of relation "money_collection_wizard" does not exist at character 94
ERROR: column "is_editable" of relation "money_collection_wizard" does not exist at character 94

13

6

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 24	04	3
	14	1
	16	1
	17	1

14

5

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 24	00	1
	12	1
	13	2
	14	1

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

15

4

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 24	04	1
	14	1
	16	1
	17	1

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 24	17	4

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

17

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 24	14	1
	16	1
	17	1

18

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 24	12	1
	17	1

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

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 24	12	1
	16	1

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

20

2

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 24	04	1
	21	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 24	14	1

ERROR: duplicate key value violates unique constraint "res_users_login_key"

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Jan 24	17	1

23

1

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Jan 24	21	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