pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Feb 3 23:47:26 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 41,754,616 log entries in 2m25s
Log start from 2025-02-03 00:00:00 to 2025-02-03 22:44:42

Global Stats

17,172 Number of unique normalized queries
17,891,368 Number of queries
6d7h32m29s Total query duration
2025-02-03 00:00:00 First query
2025-02-03 22:44:42 Last query
3,047 queries/s at 2025-02-03 12:39:13 Query peak

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

4,686 Number of events
21 Number of unique normalized events
1,696 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
17,891,368 Average queries per session
6d7h32m29s 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,047 queries/s Query Peak
2025-02-03 12:39:13 Date

SELECT Traffic

Key values

2,199 queries/s Query Peak
2025-02-03 12:39:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,199 queries/s Query Peak
2025-02-03 14:56:18 Date

Queries duration

Key values

6d7h32m29s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 03	00	215,027	0ms	23m	27ms	2m40s	3m	24m26s
	01	230,338	0ms	7s910ms	22ms	2m39s	3m8s	3m22s
	02	245,856	0ms	789ms	23ms	3m15s	3m42s	3m45s
	03	246,038	0ms	5s121ms	28ms	4m14s	4m41s	4m53s
	04	151,152	0ms	724ms	23ms	1m51s	2m27s	2m45s
	05	140,002	0ms	4s266ms	23ms	2m28s	3m21s	3m29s
	06	205,544	0ms	3m55s	19ms	2m41s	4m15s	4m57s
	07	213,426	0ms	735ms	12ms	1m39s	2m	2m4s
	08	411,071	0ms	1s139ms	10ms	2m48s	3m33s	3m51s
	09	1,026,430	0ms	19m43s	16ms	6m29s	7m53s	1h4m44s
	10	1,635,001	0ms	11m31s	26ms	11m37s	1h17m25s	1h41m35s
	11	1,610,059	0ms	20m10s	35ms	9m26s	1h34m47s	5h5m
	12	1,582,264	0ms	31m34s	26ms	7m36s	10m22s	6h21m5s
	13	1,519,684	0ms	18m58s	37ms	9m31s	1h11m59s	4h55m50s
	14	1,350,259	0ms	32m31s	19ms	5m51s	6m12s	3h50m58s
	15	1,323,244	0ms	30m40s	34ms	8m32s	9m8s	7h46m11s
	16	1,351,859	0ms	41m32s	34ms	8m19s	8m43s	4h32m6s
	17	1,137,949	0ms	32m39s	34ms	6m29s	7m54s	6h59m21s
	18	958,803	0ms	32m27s	56ms	13m23s	17m12s	5h16m59s
	19	863,213	0ms	16m48s	36ms	10m32s	12m24s	1h53m33s
	20	680,790	0ms	5m18s	35ms	10m11s	11m23s	1h14m44s
	21	520,406	0ms	1m16s	18ms	4m53s	5m15s	5m17s
	22	272,953	0ms	3s814ms	30ms	4m21s	4m35s	5m29s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 03	00	108,786	41ms	2m14s	2m38s	3m
	01	114,692	46ms	2m5s	2m38s	3m11s
	02	123,698	46ms	2m30s	3m15s	3m42s
	03	127,351	55ms	3m39s	4m13s	4m51s
	04	69,874	50ms	1m29s	1m51s	2m42s
	05	68,644	48ms	1m26s	2m28s	3m26s
	06	107,481	33ms	1m38s	2m25s	3m44s
	07	107,842	25ms	1m7s	1m39s	2m2s
	08	239,877	18ms	2m2s	2m48s	3m38s
	09	610,915	20ms	5m15s	6m4s	7m52s
	10	990,703	25ms	9m2s	10m18s	11m35s
	11	981,856	18ms	6m46s	7m45s	9m25s
	12	940,346	20ms	6m22s	7m30s	10m20s
	13	923,857	20ms	7m11s	7m47s	9m40s
	14	818,690	16ms	4m57s	5m50s	6m11s
	15	776,161	22ms	6m32s	7m57s	9m7s
	16	807,524	21ms	6m24s	7m5s	8m39s
	17	688,008	19ms	5m15s	6m9s	7m53s
	18	584,025	44ms	9m56s	12m22s	13m26s
	19	511,101	47ms	8m47s	9m33s	12m21s
	20	402,607	48ms	8m34s	10m9s	11m22s
	21	304,473	32ms	3m50s	4m12s	5m16s
	22	156,865	52ms	4m5s	4m21s	5m29s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Feb 03	00	14,650	4,601	140	0	71ms	106ms	146ms	237ms
	01	17,786	5,364	128	0	0ms	104ms	148ms	188ms
	02	18,482	5,339	127	0	0ms	117ms	170ms	224ms
	03	23,661	6,481	134	0	0ms	188ms	269ms	322ms
	04	9,310	3,872	135	0	0ms	65ms	80ms	132ms
	05	10,263	2,815	201	0	0ms	47ms	88ms	208ms
	06	13,472	3,333	142	0	26ms	86ms	135ms	235ms
	07	7,870	3,609	173	0	0ms	52ms	66ms	118ms
	08	14,061	5,467	265	0	0ms	83ms	112ms	164ms
	09	45,170	15,453	884	0	62ms	316ms	377ms	638ms
	10	83,063	24,563	889	0	168ms	609ms	754ms	1h12m25s
	11	67,988	20,787	834	0	435ms	449ms	579ms	1h32m7s
	12	72,162	22,415	875	0	237ms	448ms	594ms	813ms
	13	65,981	22,995	803	0	429ms	436ms	516ms	1h9m20s
	14	50,467	17,302	646	1	201ms	306ms	373ms	614ms
	15	59,248	21,993	863	0	339ms	382ms	466ms	729ms
	16	62,044	20,922	969	5	350ms	386ms	505ms	652ms
	17	58,026	19,151	652	0	323ms	485ms	630ms	23s381ms
	18	66,262	21,673	518	0	324ms	477ms	665ms	2m23s
	19	77,679	24,715	522	0	69ms	542ms	742ms	2m2s
	20	64,937	14,005	511	0	58ms	428ms	631ms	1m29s
	21	42,894	9,749	290	0	2ms	283ms	357ms	3s664ms
	22	32,498	6,650	117	0	0ms	240ms	321ms	382ms

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

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

Day	Hour	Average Duration	Average idle time
Feb 03	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

55,023 buffers Checkpoint Peak
2025-02-03 12:16:22 Date
270.059 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

26 files Wal files usage Peak
2025-02-03 12:16:22 Date

Checkpoints distance

Key values

830.53 Mo Distance Peak
2025-02-03 12:16:22 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Feb 03	00	90,069	3,179.503s	0.03s	3,179.57s
	01	124,456	3,239.647s	0.028s	3,239.72s
	02	141,558	3,239.501s	0.029s	3,239.578s
	03	146,782	3,239.609s	0.029s	3,239.689s
	04	85,031	3,221.633s	0.033s	3,221.7s
	05	66,682	3,148.46s	0.028s	3,148.529s
	06	98,197	2,935.48s	0.026s	2,935.548s
	07	69,517	2,957.364s	0.025s	2,957.427s
	08	98,920	3,046.484s	0.03s	3,046.556s
	09	288,918	3,239.508s	0.044s	3,239.621s
	10	496,758	3,239.538s	0.051s	3,239.682s
	11	476,295	3,239.427s	0.048s	3,239.566s
	12	503,493	3,239.539s	0.047s	3,239.679s
	13	456,772	3,239.533s	0.055s	3,239.678s
	14	365,481	3,239.452s	0.046s	3,239.572s
	15	340,354	3,239.561s	0.047s	3,239.671s
	16	383,931	3,239.501s	0.064s	3,239.642s
	17	313,848	2,890.498s	0.072s	2,890.646s
	18	251,628	3,239.552s	0.068s	3,239.685s
	19	329,264	3,239.44s	0.052s	3,239.573s
	20	286,768	3,239.533s	0.045s	3,239.648s
	21	159,761	3,239.593s	0.037s	3,239.681s
	22	88,974	2,429.643s	0.034s	2,429.713s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Feb 03	00	39	2,989	0.002s	0.012s
	01	54	2,656	0.002s	0.012s
	02	66	2,480	0.002s	0.012s
	03	69	2,681	0.002s	0.012s
	04	39	1,884	0.007s	0.012s
	05	30	2,224	0.003s	0.012s
	06	45	2,487	0.002s	0.012s
	07	30	2,348	0.002s	0.012s
	08	41	3,224	0.002s	0.012s
	09	126	4,874	0.002s	0.012s
	10	225	5,266	0.003s	0.012s
	11	217	5,369	0.003s	0.012s
	12	236	5,224	0.003s	0.012s
	13	207	5,221	0.005s	0.012s
	14	163	5,285	0.003s	0.012s
	15	149	5,454	0.003s	0.012s
	16	172	5,933	0.002s	0.012s
	17	141	5,745	0.017s	0.012s
	18	112	5,420	0.011s	0.012s
	19	145	5,305	0.003s	0.012s
	20	129	5,363	0.002s	0.012s
	21	72	4,807	0.002s	0.012s
	22	41	3,148	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Feb 03	00	52,670.08 kB	90,138.33 kB
	01	74,370.08 kB	101,786.33 kB
	02	89,475.42 kB	108,551.83 kB
	03	93,945.00 kB	130,358.17 kB
	04	53,456.17 kB	84,304.50 kB
	05	41,471.50 kB	69,343.58 kB
	06	60,765.42 kB	76,612.92 kB
	07	42,095.00 kB	99,093.50 kB
	08	55,372.83 kB	81,094.00 kB
	09	170,567.64 kB	198,493.45 kB
	10	306,443.67 kB	344,509.67 kB
	11	296,806.67 kB	347,188.92 kB
	12	319,892.60 kB	376,806.10 kB
	13	283,068.08 kB	332,694.83 kB
	14	222,712.33 kB	305,768.33 kB
	15	203,896.08 kB	249,672.75 kB
	16	234,364.08 kB	287,663.75 kB
	17	192,091.83 kB	238,208.17 kB
	18	149,063.82 kB	197,960.00 kB
	19	197,660.75 kB	251,019.67 kB
	20	175,887.92 kB	236,498.58 kB
	21	98,888.17 kB	156,039.67 kB
	22	74,070.11 kB	109,334.78 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

10,565,376 Total read queries
4,975,745 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,565,376	59.05%
INSERT	977,974	5.47%
UPDATE	303,254	1.69%
DELETE	10,818	0.06%
COPY FROM	6	0.00%
COPY TO	0	0.00%
CTE	27,100	0.15%
DDL	1,541	0.01%
TCL	3,655,052	20.43%
CURSOR	0	0.00%
OTHERS	2,350,247	13.14%

Queries by database

Key values

unknown Main database
17,891,368 Requests
6d7h32m29s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	17,891,368	6d7h32m29s
	copy from	6	4ms
	cte	27,100	6s313ms
	ddl	1,541	214ms
	delete	10,818	52s500ms
	insert	977,974	5m26s
	others	2,350,246	1m56s
	select	10,565,376	3d6h54m52s
	tcl	3,655,052	2m40s
	update	303,254	3d26m34s

Queries by user

Key values

unknown Main user
17,891,368 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	17,891,368	6d7h32m29s
	copy from	6	4ms
	cte	27,100	6s313ms
	ddl	1,541	214ms
	delete	10,818	52s500ms
	insert	977,974	5m26s
	others	2,350,246	1m56s
	select	10,565,376	3d6h54m52s
	tcl	3,655,052	2m40s
	update	303,254	3d26m34s

Duration by user

Key values

6d7h32m29s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	17,891,368	6d7h32m29s
	copy from	6	4ms
	cte	27,100	6s313ms
	ddl	1,541	214ms
	delete	10,818	52s500ms
	insert	977,974	5m26s
	others	2,350,246	1m56s
	select	10,565,376	3d6h54m52s
	tcl	3,655,052	2m40s
	update	303,254	3d26m34s

Queries by host

Key values

unknown Main host
17,891,368 Requests
6d7h32m29s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	17,891,368	6d7h32m29s
	copy from	6	4ms
	cte	27,100	6s313ms
	ddl	1,541	214ms
	delete	10,818	52s500ms
	insert	977,974	5m26s
	others	2,350,246	1m56s
	select	10,565,376	3d6h54m52s
	tcl	3,655,052	2m40s
	update	303,254	3d26m34s

Queries by application

Key values

unknown Main application
17,891,368 Requests
6d7h32m29s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	17,891,368	6d7h32m29s
	copy from	6	4ms
	cte	27,100	6s313ms
	ddl	1,541	214ms
	delete	10,818	52s500ms
	insert	977,974	5m26s
	others	2,350,246	1m56s
	select	10,565,376	3d6h54m52s
	tcl	3,655,052	2m40s
	update	303,254	3d26m34s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-02-03 10:25:45 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

16,650,451 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	16,650,451	93.06%
1-5ms	302,856	1.69%
5-10ms	16,049	0.09%
10-25ms	50,112	0.28%
25-50ms	95,421	0.53%
50-100ms	158,447	0.89%
100-500ms	314,362	1.76%
500-1000ms	299,543	1.67%
1000-10000ms	3,527	0.02%
> 10000ms	600	0.00%

Slowest individual queries

Rank	Duration	Query
1	41m32s	update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.021041', exp_date = '2025-02-03 15:11:48.021046', logged_in = 'TRUE' where id = 905; [ Date: 2025-02-03 16:08:20 ]
2	41m32s	update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.019084', exp_date = '2025-02-03 15:11:48.019089', logged_in = 'TRUE' where id = 905; [ Date: 2025-02-03 16:08:20 ]
3	32m39s	update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-02-03 15:34:41.961322', exp_date = '2025-02-03 16:19:41.961327', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-03 17:07:21 ]
4	32m39s	update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-02-03 15:34:41.962139', exp_date = '2025-02-03 16:19:41.962142', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-03 17:07:21 ]
5	32m31s	update res_users set sid = 'e01286a67f4018f824f4a5a1f28b0c23d5b33f9f', last_update = '2025-02-03 12:43:49.001641', exp_date = '2025-02-03 13:28:49.001644', logged_in = 'TRUE' where id = 1029; [ Date: 2025-02-03 14:16:20 ]
6	32m31s	update res_users set sid = 'e01286a67f4018f824f4a5a1f28b0c23d5b33f9f', last_update = '2025-02-03 12:43:49.001376', exp_date = '2025-02-03 13:28:49.001380', logged_in = 'TRUE' where id = 1029; [ Date: 2025-02-03 14:16:20 ]
7	32m27s	update res_users set sid = 'e01286a67f4018f824f4a5a1f28b0c23d5b33f9f', last_update = '2025-02-03 12:43:53.339867', exp_date = '2025-02-03 13:28:53.339871', logged_in = 'TRUE' where id = 1029; [ Date: 2025-02-03 14:16:20 ]
8	32m27s	UPDATE "res_users" SET "exp_date" = '2025-02-03 18:06:53.845208', "last_update" = '2025-02-03 17:21:53.845237', "write_date" = '2025-02-03 17:21:53.515638', "write_uid" = 865 WHERE id IN (865); [ Date: 2025-02-03 18:54:20 ]
9	32m1s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-03 15:35:19.861855', exp_date = '2025-02-03 16:20:19.861858', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-03 17:07:21 ]
10	31m34s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-02-03 11:08:46.552602', exp_date = '2025-02-03 11:53:46.552607', logged_in = 'TRUE' where id = 862; [ Date: 2025-02-03 12:40:21 ]
11	31m34s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-02-03 11:08:46.552548', exp_date = '2025-02-03 11:53:46.552552', logged_in = 'TRUE' where id = 862; [ Date: 2025-02-03 12:40:21 ]
12	31m4s	update res_users set sid = '0209c22cbc567d1123dc0fd0b878a81521e8926f', last_update = '2025-02-03 15:36:16.730123', exp_date = '2025-02-03 16:21:16.730128', logged_in = 'TRUE' where id = 835; [ Date: 2025-02-03 17:07:21 ]
13	30m44s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-02-03 11:09:36.603917', exp_date = '2025-02-03 11:54:36.603920', logged_in = 'TRUE' where id = 862; [ Date: 2025-02-03 12:40:21 ]
14	30m40s	UPDATE "res_users" SET "exp_date" = '2025-02-03 14:29:40.315562', "last_update" = '2025-02-03 13:44:40.315588', "write_date" = '2025-02-03 13:44:39.970989', "write_uid" = 1 WHERE id IN (865); [ Date: 2025-02-03 15:15:20 ]
15	30m40s	update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-02-03 11:09:40.594181', exp_date = '2025-02-03 11:54:40.594185', logged_in = 'TRUE' where id = 862; [ Date: 2025-02-03 12:40:21 ]
16	30m37s	update res_users set sid = '186b2b49902caf6fac399aff2af73e95d2d7920c', last_update = '2025-02-03 16:39:43.588793', exp_date = '2025-02-03 17:24:43.588797', logged_in = 'TRUE' where id = 857; [ Date: 2025-02-03 18:10:20 ]
17	30m37s	update res_users set sid = '186b2b49902caf6fac399aff2af73e95d2d7920c', last_update = '2025-02-03 16:39:43.588794', exp_date = '2025-02-03 17:24:43.588798', logged_in = 'TRUE' where id = 857; [ Date: 2025-02-03 18:10:20 ]
18	30m32s	update res_users set sid = '245793197ad0516abe6239095238b56d34df5d98', last_update = '2025-02-03 17:23:48.649307', exp_date = '2025-02-03 18:08:48.649311', logged_in = 'TRUE' where id = 865; [ Date: 2025-02-03 18:54:20 ]
19	30m23s	update res_users set sid = 'd921069b480b3c5a2a84df58490f615972e0e691', last_update = '2025-02-03 13:44:57.704293', exp_date = '2025-02-03 14:29:57.704296', logged_in = 'TRUE' where id = 865; [ Date: 2025-02-03 15:15:20 ]
20	30m3s	update res_users set sid = 'e01286a67f4018f824f4a5a1f28b0c23d5b33f9f', last_update = '2025-02-03 12:46:17.334549', exp_date = '2025-02-03 13:31:17.334553', logged_in = 'TRUE' where id = 1029; [ Date: 2025-02-03 14:16:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d20h31m2s

62,549

Details

0ms

41m32s

3s943ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 03	00	640	145ms	0ms
	01	696	154ms	0ms
	02	844	186ms	0ms
	03	703	159ms	0ms
	04	517	113ms	0ms
	05	332	72ms	0ms
	06	983	3m35s	219ms
	07	734	156ms	0ms
	08	1,289	282ms	0ms
	09	4,038	43m50s	651ms
	10	6,204	4h58m23s	2s885ms
	11	6,300	10h47m52s	6s170ms
	12	6,484	6h16m51s	3s487ms
	13	5,681	10h28m35s	6s638ms
	14	4,867	3h48m55s	2s822ms
	15	4,991	7h4m31s	5s103ms
	16	4,845	7h9m42s	5s321ms
	17	3,664	6h58m9s	6s847ms
	18	2,699	7h3m11s	9s407ms
	19	2,254	1h48m29s	2s888ms
	20	1,755	1h17m35s	2s652ms
	21	1,494	1m16s	51ms
	22	535	122ms	0ms

update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.021041', exp_date = '2025-02-03 15:11:48.021046', logged_in = 'TRUE' where id = 905;

Date: 2025-02-03 16:08:20 Duration: 41m32s
update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.019084', exp_date = '2025-02-03 15:11:48.019089', logged_in = 'TRUE' where id = 905;

Date: 2025-02-03 16:08:20 Duration: 41m32s
update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-02-03 15:34:41.961322', exp_date = '2025-02-03 16:19:41.961327', logged_in = 'TRUE' where id = 835;

Date: 2025-02-03 17:07:21 Duration: 32m39s

2

1d20h5m38s

247,406

Details

522ms

4s496ms

641ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 03	00	4,899	47m9s	577ms
	01	6,202	58m40s	567ms
	02	7,058	1h6m54s	568ms
	03	8,136	1h18m44s	580ms
	04	4,201	38m41s	552ms
	05	3,754	35m29s	567ms
	06	4,647	43m43s	564ms
	07	3,421	31m32s	553ms
	08	4,055	37m46s	558ms
	09	11,588	1h56m44s	604ms
	10	20,765	3h56m28s	683ms
	11	15,477	2h45m51s	642ms
	12	16,315	2h51m16s	629ms
	13	13,843	2h27m9s	637ms
	14	10,398	1h44m46s	604ms
	15	12,791	2h16m50s	641ms
	16	12,920	2h16m19s	633ms
	17	10,094	1h46m48s	634ms
	18	22,140	4h25m12s	718ms
	19	19,992	3h52m24s	697ms
	20	19,163	3h40m	688ms
	21	8,933	1h35m16s	639ms
	22	6,614	1h11m46s	651ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4857243)) AND (("shipping_track"."id" not in (40236687, 40247111, 40248538, 40396279, 40584028, 40584296, 40745419, 40772895, 40772909, 40784778, 40784793, 41289266, 41289449, 41435138, 41595880, 41676780, 41676780)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:51 Duration: 4s496ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022346)) AND (("shipping_track"."id" not in (41676799, 41676799)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:54 Duration: 4s423ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022352)) AND (("shipping_track"."id" not in (41676827, 41676827)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:12:01 Duration: 4s345ms

3

7h48m47s

43,042

Details

526ms

4s841ms

653ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 03	00	125	1m20s	645ms
	01	133	1m28s	661ms
	02	205	2m14s	654ms
	03	245	2m40s	653ms
	04	102	1m6s	650ms
	05	293	2m49s	578ms
	06	162	1m39s	616ms
	07	490	4m38s	567ms
	08	613	5m55s	580ms
	09	3,184	32m49s	618ms
	10	4,485	53m15s	712ms
	11	3,996	43m57s	660ms
	12	4,094	44m50s	657ms
	13	4,164	45m9s	650ms
	14	3,068	31m47s	621ms
	15	3,482	36m51s	635ms
	16	3,723	39m17s	633ms
	17	3,161	33m11s	630ms
	18	2,306	27m38s	719ms
	19	2,014	23m41s	705ms
	20	1,549	17m23s	673ms
	21	1,022	10m39s	625ms
	22	426	4m20s	611ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4986871, 4986847, 4986814, 4986725, 4968641, 4962186)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 10:13:33 Duration: 4s841ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5008368, 5008363, 5008276, 5008246, 5002566, 5001991, 5001983, 5001971, 5001835, 5000244, 5000236, 5000234, 5000225, 4997949, 4997927, 4997886, 4997882, 4997881, 4997827, 4995912, 4995896, 4995880, 4995059, 4973627, 4973625, 4973624, 4973598, 4919018)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 10:13:54 Duration: 4s601ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5024854, 5024852, 5024850, 5024848, 5024846, 5024844, 5024842, 5024840, 5024838, 5024837, 5024834, 5024831, 5024829, 5024826, 5024823, 5024820, 5024818, 5024815, 5024812)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 19:19:04 Duration: 4s448ms

4

7h25m16s

129,755

Details

142ms

1s337ms

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" = ?)) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,620	5m11s	192ms
	01	2,219	7m5s	191ms
	02	2,502	8m7s	194ms
	03	2,550	8m18s	195ms
	04	2,700	8m39s	192ms
	05	1,413	4m33s	193ms
	06	1,128	3m41s	195ms
	07	1,040	3m21s	193ms
	08	3,471	11m12s	193ms
	09	6,239	21m27s	206ms
	10	10,005	38m50s	232ms
	11	5,765	21m11s	220ms
	12	8,066	29m12s	217ms
	13	11,050	41m14s	223ms
	14	6,073	20m27s	202ms
	15	9,501	34m35s	218ms
	16	7,369	26m25s	215ms
	17	6,946	21m55s	189ms
	18	16,818	57m36s	205ms
	19	21,745	1h7m56s	187ms
	20	862	2m29s	173ms
	21	219	34s687ms	158ms
	22	454	1m11s	157ms

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

Date: 2025-02-03 10:13:30 Duration: 1s337ms
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" = '139157')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 18:11:47 Duration: 1s249ms
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" = '139789')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 18:11:45 Duration: 1s135ms

5

3h28m59s

51,197

Details

93ms

836ms

244ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,838	7m15s	237ms
	01	1,524	5m51s	230ms
	02	1,030	3m56s	229ms
	03	2,456	9m27s	231ms
	05	812	3m21s	248ms
	06	574	2m24s	251ms
	08	38	9s39ms	237ms
	09	386	1m24s	218ms
	10	498	2m1s	243ms
	11	330	1m25s	257ms
	12	358	1m40s	281ms
	13	287	1m25s	296ms
	14	718	3m3s	255ms
	15	2,608	10m58s	252ms
	16	2,890	12m4s	250ms
	17	3,779	15m6s	239ms
	18	5,785	24m53s	258ms
	19	6,102	26m43s	262ms
	20	6,938	29m21s	253ms
	21	5,896	21m20s	217ms
	22	6,350	25m4s	236ms

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

Date: 2025-02-03 19:39:01 Duration: 836ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مجدي')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-03 19:39:01 Duration: 836ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-03 15:41:31 Duration: 831ms

6

2h29m15s

30,073

Details

179ms

703ms

297ms

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

Day	Hour	Count	Duration	Avg duration
Feb 03	08	1,064	4m36s	259ms
	09	1,991	9m46s	294ms
	10	3,385	17m42s	313ms
	11	3,189	16m17s	306ms
	12	4,394	21m30s	293ms
	13	5,332	26m43s	300ms
	14	2,928	14m22s	294ms
	15	3,360	16m41s	298ms
	16	3,976	19m4s	287ms
	17	454	2m30s	330ms

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

Date: 2025-02-03 13:16:41 Duration: 703ms
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" = '9890605')))) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:16:43 Duration: 644ms
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" = '9890314')))) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:16:43 Duration: 640ms

7

2h25m41s

11,010

Details

190ms

1s937ms

793ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 03	00	406	2m53s	427ms
	01	102	25s84ms	245ms
	08	15	13s174ms	878ms
	09	2	1s763ms	881ms
	10	3	937ms	312ms
	11	57	55s188ms	968ms
	12	51	47s384ms	929ms
	13	25	16s346ms	653ms
	14	245	2m23s	586ms
	15	497	6m50s	826ms
	16	507	6m36s	782ms
	17	1,421	15m45s	665ms
	18	1,845	26m32s	863ms
	19	1,234	18m37s	905ms
	20	1,842	26m39s	868ms
	21	1,177	15m16s	778ms
	22	1,581	21m26s	813ms

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

Date: 2025-02-03 19:18:59 Duration: 1s937ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '277701')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:12:12 Duration: 1s752ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '278000')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:12:01 Duration: 1s721ms

8

2h1m52s

144,707

Details

37ms

298ms

50ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 03	00	2,024	1m34s	46ms
	01	2,463	1m53s	46ms
	02	2,619	2m2s	46ms
	03	2,983	2m21s	47ms
	04	1,184	55s118ms	46ms
	05	1,016	47s72ms	46ms
	06	2,110	1m38s	46ms
	07	1,240	57s676ms	46ms
	08	2,879	2m14s	46ms
	09	7,763	6m25s	49ms
	10	14,758	13m44s	55ms
	11	12,859	11m17s	52ms
	12	13,686	11m45s	51ms
	13	11,183	9m42s	52ms
	14	9,024	7m24s	49ms
	15	7,793	6m37s	50ms
	16	10,077	8m31s	50ms
	17	7,439	5m57s	47ms
	18	7,057	6m16s	53ms
	19	6,498	5m36s	51ms
	20	8,930	7m16s	48ms
	21	5,596	4m14s	45ms
	22	3,526	2m38s	44ms

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

Date: 2025-02-03 19:19:00 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020000)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 18:11:55 Duration: 272ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4986871)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 10:13:28 Duration: 270ms

9

1h55m53s

47

Details

0ms

32m27s

2m27s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1	0ms	0ms
	04	1	0ms	0ms
	05	1	0ms	0ms
	06	5	0ms	0ms
	08	2	0ms	0ms
	09	8	19m43s	2m27s
	10	4	2m40s	40s143ms
	11	3	3ms	1ms
	12	1	0ms	0ms
	14	1	2ms	2ms
	15	3	30m40s	10m13s
	16	3	3ms	1ms
	17	4	5ms	1ms
	18	3	53m56s	17m58s
	19	2	8m52s	4m26s
	20	2	2ms	1ms
	21	3	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-03 18:06:53.845208', "last_update" = '2025-02-03 17:21:53.845237', "write_date" = '2025-02-03 17:21:53.515638', "write_uid" = 865 WHERE id IN (865);

Date: 2025-02-03 18:54:20 Duration: 32m27s
UPDATE "res_users" SET "exp_date" = '2025-02-03 14:29:40.315562', "last_update" = '2025-02-03 13:44:40.315588', "write_date" = '2025-02-03 13:44:39.970989', "write_uid" = 1 WHERE id IN (865);

Date: 2025-02-03 15:15:20 Duration: 30m40s
UPDATE "res_users" SET "exp_date" = '2025-02-03 17:33:51.958525', "last_update" = '2025-02-03 16:48:51.958545', "write_date" = '2025-02-03 16:48:51.627244', "write_uid" = 1 WHERE id IN (1231);

Date: 2025-02-03 18:10:20 Duration: 21m29s

10

1h51m3s

277

Details

0ms

23m

24s57ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 03	00	3	23m	7m40s
	02	1	0ms	0ms
	05	1	0ms	0ms
	06	4	0ms	0ms
	08	9	1ms	0ms
	09	31	20ms	0ms
	10	29	3m29s	7s208ms
	11	26	2m27s	5s680ms
	12	27	23ms	0ms
	13	29	13m42s	28s363ms
	14	17	21ms	1ms
	15	22	8m39s	23s624ms
	16	38	59m44s	1m34s
	17	13	13ms	1ms
	18	8	12ms	1ms
	19	6	11ms	1ms
	20	4	9ms	2ms
	21	8	10ms	1ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 23:45:05.410478', "last_update" = '2025-02-02 23:00:05.410494', "sid" = '0c05a2909a60a904baa5a7ed857619cde4fe2e65', "write_date" = '2025-02-02 23:00:05.093831', "write_uid" = 1 WHERE id IN (1390);

Date: 2025-02-03 00:23:05 Duration: 23m
UPDATE "res_users" SET "exp_date" = '2025-02-03 15:31:56.580061', "last_update" = '2025-02-03 14:46:56.580085', "sid" = 'c0b3cb2a2774eea1638aca3f8906c4641fe00596', "write_date" = '2025-02-03 14:46:56.142722', "write_uid" = 1 WHERE id IN (905);

Date: 2025-02-03 16:08:20 Duration: 21m24s
UPDATE "res_users" SET "exp_date" = '2025-02-03 15:38:59.361487', "last_update" = '2025-02-03 14:53:59.361515', "sid" = '0c694fa531c7af6cf95ec032884fb1556af07a50', "write_date" = '2025-02-03 14:53:58.961499', "write_uid" = 1 WHERE id IN (905);

Date: 2025-02-03 16:08:20 Duration: 14m21s

11

1h10m5s

14,872

Details

186ms

1s389ms

282ms

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	524	2m23s	273ms
	01	666	3m3s	276ms
	02	521	2m24s	276ms
	03	1,235	5m48s	281ms
	05	408	1m54s	279ms
	06	290	1m18s	269ms
	07	1	235ms	235ms
	08	6	1s798ms	299ms
	09	193	59s143ms	306ms
	10	254	1m23s	327ms
	11	111	35s900ms	323ms
	12	133	43s777ms	329ms
	13	124	41s189ms	332ms
	14	117	35s211ms	300ms
	15	821	4m14s	310ms
	16	972	5m6s	315ms
	17	492	2m15s	274ms
	18	1,084	5m11s	287ms
	19	1,838	8m53s	289ms
	20	1,659	8m5s	292ms
	21	1,810	7m37s	252ms
	22	1,613	6m48s	253ms

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

Date: 2025-02-03 18:12:10 Duration: 1s389ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '199565')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 19:18:57 Duration: 550ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9949235')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:33:03 Duration: 538ms

12

50m18s

49,291

Details

46ms

334ms

61ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 03	08	1,772	1m38s	55ms
	09	3,340	3m18s	59ms
	10	5,813	6m20s	65ms
	11	4,565	4m45s	62ms
	12	5,392	5m29s	61ms
	13	6,151	6m19s	61ms
	14	6,573	6m29s	59ms
	15	4,140	4m12s	61ms
	16	8,391	8m34s	61ms
	17	2,952	2m55s	59ms
	18	83	6s160ms	74ms
	19	71	4s955ms	69ms
	20	22	1s346ms	61ms
	21	24	1s429ms	59ms
	22	2	114ms	57ms

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

Date: 2025-02-03 10:13:50 Duration: 334ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4919627) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-03 10:13:26 Duration: 187ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4996679) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-03 15:26:00 Duration: 119ms

13

40m35s

11,830

Details

147ms

378ms

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" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 03	00	141	26s904ms	190ms
	03	7	1s374ms	196ms
	04	81	15s733ms	194ms
	05	138	26s416ms	191ms
	06	1,024	3m21s	196ms
	07	1,040	3m21s	194ms
	08	1,017	3m16s	193ms
	09	912	3m5s	202ms
	10	1,938	7m30s	232ms
	11	808	2m53s	214ms
	12	896	3m11s	213ms
	13	1,650	6m3s	220ms
	14	415	1m23s	200ms
	15	185	37s234ms	201ms
	16	228	48s81ms	210ms
	17	265	48s966ms	184ms
	18	196	35s561ms	181ms
	19	192	35s856ms	186ms
	20	192	32s639ms	169ms
	21	219	34s844ms	159ms
	22	286	45s126ms	157ms

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" = '215860')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:28:16 Duration: 378ms
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" = '111551')) 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 (123)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:45:42 Duration: 370ms
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" = '241674')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:45:43 Duration: 358ms

14

39m4s

18,415

Details

97ms

606ms

127ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 03	05	48	5s741ms	119ms
	07	38	4s603ms	121ms
	08	97	11s454ms	118ms
	09	1,002	2m5s	124ms
	10	1,990	4m34s	137ms
	11	1,958	4m7s	126ms
	12	1,908	4m5s	128ms
	13	1,947	4m8s	127ms
	14	1,489	3m	120ms
	15	2,130	4m26s	125ms
	16	1,582	3m17s	125ms
	17	1,413	2m49s	120ms
	18	484	1m6s	136ms
	19	1,189	2m38s	133ms
	20	856	1m48s	126ms
	21	273	31s369ms	114ms
	22	11	1s313ms	119ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067012)) AND (("cash_track"."id" not in (7567951, 7574537, 7574789, 7646692, 7646773, 7646886, 7646886)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:47 Duration: 606ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8063752)) AND (("cash_track"."id" not in (7546663, 7548024, 7551701, 7646699, 7646780, 7646900, 7646900)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:50 Duration: 600ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8062974)) AND (("cash_track"."id" not in (7540794, 7541547, 7545877, 7646700, 7646782, 7646901, 7646901)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:50 Duration: 500ms

15

36m22s

11,316

Details

146ms

242ms

192ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,479	4m44s	192ms
	01	2,213	7m4s	191ms
	02	2,502	8m6s	194ms
	03	1,976	6m25s	195ms
	04	2,299	7m22s	192ms
	05	704	2m16s	193ms
	22	143	22s413ms	156ms

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

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

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

Date: 2025-02-03 03:14:02 Duration: 237ms

16

20m13s

2,247

Details

394ms

853ms

540ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 03	09	155	1m23s	539ms
	10	587	5m44s	586ms
	11	788	6m56s	528ms
	12	195	1m49s	560ms
	13	134	1m8s	510ms
	14	282	2m22s	504ms
	15	96	44s545ms	464ms
	17	10	5s678ms	567ms

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

Date: 2025-02-03 11:06:04 Duration: 853ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '28046')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-03 10:23:02 Duration: 790ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '142665')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-03 11:06:02 Duration: 786ms

17

19m40s

21,192

Details

41ms

96ms

55ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 03	08	905	45s747ms	50ms
	09	1,616	1m25s	53ms
	10	2,849	2m50s	59ms
	11	1,736	1m39s	57ms
	12	2,472	2m15s	54ms
	13	3,113	2m57s	56ms
	14	2,794	2m30s	53ms
	15	2,447	2m15s	55ms
	16	2,531	2m20s	55ms
	17	729	39s237ms	53ms

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

Date: 2025-02-03 11:04:46 Duration: 96ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4908778) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:39:08 Duration: 95ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4942395) ORDER BY "collection_policy"."id";

Date: 2025-02-03 10:21:02 Duration: 89ms

18

14m55s

5,347

Details

121ms

1s164ms

167ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 03	02	15	2s220ms	148ms
	03	20	2s990ms	149ms
	07	20	2s854ms	142ms
	08	75	10s828ms	144ms
	09	303	48s497ms	160ms
	10	1,083	3m16s	181ms
	11	1,182	3m22s	171ms
	12	995	2m45s	166ms
	13	567	1m34s	166ms
	14	329	51s28ms	155ms
	15	204	32s636ms	159ms
	16	163	26s745ms	164ms
	17	115	17s448ms	151ms
	18	69	10s947ms	158ms
	19	80	12s78ms	150ms
	20	83	11s950ms	143ms
	21	38	5s33ms	132ms
	22	6	820ms	136ms

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

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

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

Date: 2025-02-03 10:13:28 Duration: 427ms

19

13m29s

272

Details

667ms

4s401ms

2s975ms

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
Feb 03	00	1	2s898ms	2s898ms
	09	3	12s870ms	4s290ms
	10	2	6s482ms	3s241ms
	11	7	23s487ms	3s355ms
	12	13	43s724ms	3s363ms
	13	12	39s350ms	3s279ms
	14	7	13s62ms	1s866ms
	15	78	3m45s	2s895ms
	16	17	55s279ms	3s251ms
	17	35	1m44s	2s981ms
	18	27	1m4s	2s374ms
	19	27	1m27s	3s232ms
	20	21	1m6s	3s162ms
	21	12	35s59ms	2s921ms
	22	10	29s47ms	2s904ms

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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 09:42:53 Duration: 4s401ms
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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%2%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 15:26:43 Duration: 4s288ms
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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%265%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 15:26:47 Duration: 4s274ms

20

11m45s

2,722

Details

210ms

1s787ms

259ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 03	00	120	28s100ms	234ms
	01	120	27s958ms	232ms
	02	120	28s32ms	233ms
	03	120	28s443ms	237ms
	04	120	27s841ms	232ms
	05	120	27s905ms	232ms
	06	120	27s969ms	233ms
	07	120	27s855ms	232ms
	08	120	27s967ms	233ms
	09	120	29s807ms	248ms
	10	120	33s561ms	279ms
	11	120	33s115ms	275ms
	12	120	31s524ms	262ms
	13	120	31s827ms	265ms
	14	120	29s662ms	247ms
	15	120	30s501ms	254ms
	16	118	30s271ms	256ms
	17	115	32s92ms	279ms
	18	120	39s645ms	330ms
	19	119	37s45ms	311ms
	20	120	36s317ms	302ms
	21	120	33s280ms	277ms
	22	90	24s967ms	277ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 18:12:03 Duration: 1s787ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 11:06:03 Duration: 1s137ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 11:06:04 Duration: 1s133ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,349,271

Details

1m56s

0ms

16ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Feb 03	00	36,338	1s576ms	0ms
	01	38,162	1s814ms	0ms
	02	39,141	1s945ms	0ms
	03	34,860	1s764ms	0ms
	04	27,518	1s295ms	0ms
	05	24,095	1s9ms	0ms
	06	31,714	1s515ms	0ms
	07	35,505	1s773ms	0ms
	08	59,182	2s907ms	0ms
	09	134,420	7s776ms	0ms
	10	203,658	9s960ms	0ms
	11	205,692	9s652ms	0ms
	12	209,618	10s879ms	0ms
	13	195,704	9s511ms	0ms
	14	181,536	9s131ms	0ms
	15	182,606	9s94ms	0ms
	16	180,077	9s12ms	0ms
	17	144,473	7s41ms	0ms
	18	112,185	5s845ms	0ms
	19	98,703	4s752ms	0ms
	20	78,770	3s774ms	0ms
	21	63,724	3s81ms	0ms
	22	31,590	1s604ms	0ms

DISCARD ALL;

Date: 2025-02-03 16:34:34 Duration: 16ms
DISCARD ALL;

Date: 2025-02-03 09:37:10 Duration: 1ms
DISCARD ALL;

Date: 2025-02-03 03:13:15 Duration: 1ms

2

1,827,887

Details

28s713ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Feb 03	00	25,216	400ms	0ms
	01	27,090	452ms	0ms
	02	29,532	493ms	0ms
	03	26,766	450ms	0ms
	04	20,220	337ms	0ms
	05	16,972	269ms	0ms
	06	24,686	393ms	0ms
	07	29,193	452ms	0ms
	08	45,989	699ms	0ms
	09	108,964	1s785ms	0ms
	10	164,405	2s635ms	0ms
	11	164,532	2s455ms	0ms
	12	167,381	2s576ms	0ms
	13	153,584	2s315ms	0ms
	14	139,295	2s134ms	0ms
	15	140,393	2s160ms	0ms
	16	138,939	2s151ms	0ms
	17	112,689	1s689ms	0ms
	18	86,057	1s528ms	0ms
	19	74,542	1s232ms	0ms
	20	59,432	958ms	0ms
	21	49,447	752ms	0ms
	22	22,563	388ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-03 09:50:19 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-03 20:15:24 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-02-03 16:40:55 Duration: 1ms

3

1,195,169

Details

12s972ms

0ms

10ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 03	00	18,767	175ms	0ms
	01	19,670	193ms	0ms
	02	20,152	205ms	0ms
	03	18,009	186ms	0ms
	04	14,320	137ms	0ms
	05	12,635	112ms	0ms
	06	16,482	159ms	0ms
	07	18,384	181ms	0ms
	08	30,419	294ms	0ms
	09	68,352	764ms	0ms
	10	103,201	1s250ms	0ms
	11	104,200	1s141ms	0ms
	12	106,003	1s154ms	0ms
	13	99,093	1s102ms	0ms
	14	91,945	963ms	0ms
	15	92,364	987ms	0ms
	16	91,239	974ms	0ms
	17	73,262	758ms	0ms
	18	57,082	687ms	0ms
	19	50,313	593ms	0ms
	20	40,286	444ms	0ms
	21	32,689	336ms	0ms
	22	16,302	165ms	0ms

ROLLBACK;

Date: 2025-02-03 19:56:49 Duration: 10ms
ROLLBACK;

Date: 2025-02-03 12:14:28 Duration: 1ms
ROLLBACK;

Date: 2025-02-03 15:36:04 Duration: 1ms

4

1,183,872

Details

3m57s

0ms

12ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Feb 03	00	18,129	3s205ms	0ms
	01	19,056	3s742ms	0ms
	02	19,546	3s904ms	0ms
	03	17,386	3s511ms	0ms
	04	13,713	2s483ms	0ms
	05	12,020	1s961ms	0ms
	06	15,833	2s798ms	0ms
	07	17,762	3s146ms	0ms
	08	29,752	5s185ms	0ms
	09	67,902	13s860ms	0ms
	10	103,131	22s101ms	0ms
	11	103,972	20s673ms	0ms
	12	105,903	20s805ms	0ms
	13	98,947	20s29ms	0ms
	14	91,583	17s552ms	0ms
	15	92,006	18s43ms	0ms
	16	90,715	17s781ms	0ms
	17	72,762	14s127ms	0ms
	18	56,502	12s904ms	0ms
	19	49,714	11s275ms	0ms
	20	39,646	8s640ms	0ms
	21	32,004	6s338ms	0ms
	22	15,888	3s322ms	0ms

SELECT payload FROM http_sessions WHERE sid = 'c59b96cc7582d24ff6fc97f8380fdb46de26f6f3';

Date: 2025-02-03 16:34:34 Duration: 12ms
SELECT payload FROM http_sessions WHERE sid = 'ad265f20ab5e331e075c918535f901c7ec527317';

Date: 2025-02-03 17:21:55 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = '3a0addc8b61ba92566a06ce08e5f7ca0e8fc04e4';

Date: 2025-02-03 11:27:15 Duration: 11ms

5

1,174,823

Details

1m51s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Feb 03	00	18,239	1s523ms	0ms
	01	19,158	1s695ms	0ms
	02	19,647	1s813ms	0ms
	03	17,507	1s612ms	0ms
	04	13,836	1s212ms	0ms
	05	12,112	983ms	0ms
	06	15,925	1s371ms	0ms
	07	17,834	1s553ms	0ms
	08	29,591	2s502ms	0ms
	09	67,127	6s427ms	0ms
	10	101,726	10s384ms	0ms
	11	102,738	9s794ms	0ms
	12	104,773	9s738ms	0ms
	13	97,802	9s557ms	0ms
	14	90,730	8s487ms	0ms
	15	91,284	8s603ms	0ms
	16	89,971	8s448ms	0ms
	17	72,188	6s757ms	0ms
	18	56,083	5s936ms	0ms
	19	49,377	5s26ms	0ms
	20	39,410	3s909ms	0ms
	21	31,907	2s960ms	0ms
	22	15,858	1s501ms	0ms

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

Date: 2025-02-03 10:45:38 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-03 18:16:29 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-02-03 09:34:23 Duration: 1ms

6

808,639

Details

2m8s

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
Feb 03	00	7,580	1s303ms	0ms
	01	8,790	1s566ms	0ms
	02	11,315	1s909ms	0ms
	03	10,064	1s747ms	0ms
	04	6,491	1s201ms	0ms
	05	4,843	909ms	0ms
	06	10,401	1s718ms	0ms
	07	12,089	1s950ms	0ms
	08	19,699	2s960ms	0ms
	09	52,955	8s472ms	0ms
	10	79,370	12s551ms	0ms
	11	78,483	11s742ms	0ms
	12	80,948	13s318ms	0ms
	13	70,230	10s518ms	0ms
	14	62,157	9s520ms	0ms
	15	62,004	9s819ms	0ms
	16	61,627	9s502ms	0ms
	17	50,183	7s414ms	0ms
	18	36,768	6s445ms	0ms
	19	30,572	5s123ms	0ms
	20	24,047	4s25ms	0ms
	21	20,362	3s156ms	0ms
	22	7,661	1s323ms	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 (1300);

Date: 2025-02-03 17:21:55 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 (977);

Date: 2025-02-03 17:21:55 Duration: 7ms
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 (853);

Date: 2025-02-03 17:21:55 Duration: 7ms

7

631,957

Details

1m58s

0ms

40ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Feb 03	00	6,462	1s155ms	0ms
	01	7,421	1s455ms	0ms
	02	9,377	1s875ms	0ms
	03	8,759	1s897ms	0ms
	04	5,900	1s112ms	0ms
	05	4,335	890ms	0ms
	06	8,207	1s532ms	0ms
	07	10,809	1s657ms	0ms
	08	15,568	2s391ms	0ms
	09	40,572	7s176ms	0ms
	10	61,051	12s73ms	0ms
	11	60,217	10s880ms	0ms
	12	61,330	11s387ms	0ms
	13	54,411	10s546ms	0ms
	14	47,310	8s289ms	0ms
	15	47,992	8s574ms	0ms
	16	47,617	8s452ms	0ms
	17	39,378	7s31ms	0ms
	18	28,913	6s124ms	0ms
	19	24,192	5s485ms	0ms
	20	19,119	4s223ms	0ms
	21	16,758	3s344ms	0ms
	22	6,259	1s183ms	0ms

COMMIT;

Date: 2025-02-03 15:29:32 Duration: 40ms
COMMIT;

Date: 2025-02-03 13:14:15 Duration: 39ms
COMMIT;

Date: 2025-02-03 15:58:16 Duration: 38ms

8

488,615

Details

33s554ms

0ms

16ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 03	00	3,253	185ms	0ms
	01	3,441	202ms	0ms
	02	4,865	282ms	0ms
	03	4,235	262ms	0ms
	04	1,726	100ms	0ms
	05	1,738	100ms	0ms
	06	6,425	338ms	0ms
	07	6,688	377ms	0ms
	08	10,309	581ms	0ms
	09	30,700	2s3ms	0ms
	10	48,256	3s850ms	0ms
	11	46,149	3s235ms	0ms
	12	49,211	3s311ms	0ms
	13	43,165	3s28ms	0ms
	14	37,740	2s502ms	0ms
	15	39,104	2s650ms	0ms
	16	38,632	2s620ms	0ms
	17	32,045	2s47ms	0ms
	18	24,737	1s931ms	0ms
	19	19,949	1s521ms	0ms
	20	16,660	1s228ms	0ms
	21	13,906	832ms	0ms
	22	5,681	361ms	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 (74);

Date: 2025-02-03 10:08:50 Duration: 16ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (51, 102, 17, 28, 4, 24, 26, 16, 40, 119, 60, 39, 75, 9, 11, 48);

Date: 2025-02-03 09:21:59 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (78, 27, 64, 19, 28, 39, 6, 3, 22, 32, 75, 70, 51, 14, 26, 121);

Date: 2025-02-03 13:09:14 Duration: 1ms

9

476,411

Details

1m4s

0ms

7ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 03	00	4,094	417ms	0ms
	01	5,039	641ms	0ms
	02	6,341	817ms	0ms
	03	5,523	585ms	0ms
	04	1,992	281ms	0ms
	05	2,158	238ms	0ms
	06	6,686	852ms	0ms
	07	3,609	418ms	0ms
	08	9,559	1s194ms	0ms
	09	32,274	4s240ms	0ms
	10	47,240	7s669ms	0ms
	11	46,174	6s684ms	0ms
	12	47,055	6s224ms	0ms
	13	39,287	5s389ms	0ms
	14	35,892	4s988ms	0ms
	15	37,600	5s67ms	0ms
	16	37,888	4s965ms	0ms
	17	28,870	3s573ms	0ms
	18	23,603	3s450ms	0ms
	19	20,196	2s845ms	0ms
	20	16,264	2s237ms	0ms
	21	12,736	1s452ms	0ms
	22	6,331	628ms	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 (5099010, 5316227, 5102849, 5099009, 5189280, 5499823, 5127194, 5101327, 5105078, 5100957, 5099236, 5099037, 5100112, 5099167, 5118073, 5099248, 5132309, 5100552, 5100443, 5099294, 5100726, 5103863, 5397506, 5099102, 5136297, 5105186, 5099224, 5122785, 5234240, 5099333, 5099788, 5099013, 5099904, 5099958, 5099007, 5112921, 5127113, 5099194, 5116518, 5099141, 5102190);

Date: 2025-02-03 17:21:56 Duration: 7ms
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 (5099264, 5100246, 5099651, 5197499, 5118664, 5116614, 5130796, 5137058, 5129857, 5103145, 5098976, 5107839, 5146758, 5172712, 5108030, 5100765, 5101567, 5137147, 5099296, 5106354, 5099488, 5099547, 5163349, 5099857, 5099009, 5139691, 5103909, 5099141, 5099761, 5177701, 5099006, 5099010, 5100302, 5105761, 5099045, 5099137, 5154951, 5134698, 5100836, 5102821, 5100205, 5099007, 5099263, 5106172, 5100232, 5099092, 5101169, 5104250, 5099119, 5099724, 5100207, 5107762, 5100001, 5113127, 5099415, 5099920, 5101865, 5433371, 5098978, 5100476, 5105750, 5117663, 5099814, 5099013, 5117645, 5099130, 5101969, 5109050, 5108333, 5107697, 5112342, 5099430, 5121944);

Date: 2025-02-03 17:21:57 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 (5416516, 5415856, 5416330, 5415514, 5497693, 5390043, 5228591, 5263477, 5172985, 5383300, 5250172, 5489938, 5484741, 5462598, 5106124, 5501350, 5145660, 5440141, 5252764, 5118071, 5104145, 5185737, 5128341, 5106608, 5121974, 5399499, 5106547, 5168357, 5392048, 5430976, 5187565, 5104116, 5431353, 5349530, 5107286, 5123664, 5219362, 5442312, 5172508, 5115104, 5405274, 5456144, 5116523, 5166323, 5148798, 5102919, 5100650, 5335458, 5488015, 5370439, 5107646, 5394897, 5288936, 5118670, 5209324, 5383152, 5105071, 5122294, 5216047, 5492616, 5119974, 5159476, 5099163, 5285429, 5185996, 5106729, 5275165, 5334006, 5113849, 5390596, 5106747, 5105914, 5119566, 5332953, 5354035, 5303456, 5263181, 5126766, 5397010, 5124612, 5443929, 5278034, 5233096, 5322990, 5354767, 5102005, 5425353, 5404852, 5119042, 5157883, 5320458, 5125072, 5110882, 5103521, 5476521, 5334701, 5402437, 5124929, 5206714);

Date: 2025-02-03 11:10:50 Duration: 5ms

10

378,653

Details

2m7s

0ms

3ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,837	544ms	0ms
	01	1,758	577ms	0ms
	02	1,439	479ms	0ms
	03	1,510	496ms	0ms
	04	580	190ms	0ms
	05	780	229ms	0ms
	06	1,498	455ms	0ms
	07	1,072	318ms	0ms
	08	8,027	2s352ms	0ms
	09	20,623	6s748ms	0ms
	10	39,479	14s471ms	0ms
	11	41,396	14s2ms	0ms
	12	34,366	11s701ms	0ms
	13	40,174	13s689ms	0ms
	14	37,038	12s9ms	0ms
	15	29,237	9s970ms	0ms
	16	31,637	10s369ms	0ms
	17	27,831	8s844ms	0ms
	18	20,836	7s593ms	0ms
	19	15,564	5s533ms	0ms
	20	12,632	4s137ms	0ms
	21	6,599	2s34ms	0ms
	22	2,740	828ms	0ms

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

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

Date: 2025-02-03 17:21:55 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.office' 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 = 861) OR r.global) ORDER BY r.id;

Date: 2025-02-03 17:10:28 Duration: 2ms

11

332,856

Details

1m5s

0ms

9ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 03	00	2,439	413ms	0ms
	01	2,320	452ms	0ms
	02	2,915	578ms	0ms
	03	2,656	538ms	0ms
	04	1,267	247ms	0ms
	05	1,352	238ms	0ms
	06	3,949	653ms	0ms
	07	2,706	443ms	0ms
	08	9,653	1s497ms	0ms
	09	22,174	4s110ms	0ms
	10	32,621	7s255ms	0ms
	11	31,518	6s434ms	0ms
	12	34,029	6s601ms	0ms
	13	29,552	5s928ms	0ms
	14	27,239	5s100ms	0ms
	15	26,943	5s239ms	0ms
	16	26,391	5s199ms	0ms
	17	22,588	4s223ms	0ms
	18	15,276	3s539ms	0ms
	19	12,570	2s736ms	0ms
	20	9,999	2s120ms	0ms
	21	9,385	1s707ms	0ms
	22	3,314	603ms	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 (8007496);

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

Date: 2025-02-03 17:21:56 Duration: 8ms
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 (8004683, 3);

Date: 2025-02-03 18:12:15 Duration: 2ms

12

287,604

Details

53s389ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,790	233ms	0ms
	01	2,043	266ms	0ms
	02	1,544	199ms	0ms
	03	1,780	223ms	0ms
	04	1,224	144ms	0ms
	05	984	124ms	0ms
	06	1,303	179ms	0ms
	07	1,243	164ms	0ms
	08	9,186	1s281ms	0ms
	09	18,565	3s155ms	0ms
	10	29,655	6s160ms	0ms
	11	29,741	5s852ms	0ms
	12	24,204	4s659ms	0ms
	13	29,278	5s765ms	0ms
	14	25,431	4s679ms	0ms
	15	20,959	3s848ms	0ms
	16	22,815	4s180ms	0ms
	17	20,377	3s569ms	0ms
	18	16,268	3s415ms	0ms
	19	12,216	2s420ms	0ms
	20	9,360	1s699ms	0ms
	21	5,068	794ms	0ms
	22	2,570	368ms	0ms

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

Date: 2025-02-03 18:11:24 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-02-03 18:36:22 Duration: 2ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');

Date: 2025-02-03 18:36:21 Duration: 1ms

13

247,406

Details

1d20h5m38s

522ms

4s496ms

641ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Feb 03	00	4,899	47m9s	577ms
	01	6,202	58m40s	567ms
	02	7,058	1h6m54s	568ms
	03	8,136	1h18m44s	580ms
	04	4,201	38m41s	552ms
	05	3,754	35m29s	567ms
	06	4,647	43m43s	564ms
	07	3,421	31m32s	553ms
	08	4,055	37m46s	558ms
	09	11,588	1h56m44s	604ms
	10	20,765	3h56m28s	683ms
	11	15,477	2h45m51s	642ms
	12	16,315	2h51m16s	629ms
	13	13,843	2h27m9s	637ms
	14	10,398	1h44m46s	604ms
	15	12,791	2h16m50s	641ms
	16	12,920	2h16m19s	633ms
	17	10,094	1h46m48s	634ms
	18	22,140	4h25m12s	718ms
	19	19,992	3h52m24s	697ms
	20	19,163	3h40m	688ms
	21	8,933	1h35m16s	639ms
	22	6,614	1h11m46s	651ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4857243)) AND (("shipping_track"."id" not in (40236687, 40247111, 40248538, 40396279, 40584028, 40584296, 40745419, 40772895, 40772909, 40784778, 40784793, 41289266, 41289449, 41435138, 41595880, 41676780, 41676780)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:51 Duration: 4s496ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022346)) AND (("shipping_track"."id" not in (41676799, 41676799)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:54 Duration: 4s423ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022352)) AND (("shipping_track"."id" not in (41676827, 41676827)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:12:01 Duration: 4s345ms

14

223,711

Details

1m2s

0ms

24ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Feb 03	00	2,100	511ms	0ms
	01	2,234	764ms	0ms
	02	2,566	754ms	0ms
	03	2,740	722ms	0ms
	04	725	232ms	0ms
	05	1,073	287ms	0ms
	06	2,633	809ms	0ms
	07	1,482	385ms	0ms
	08	3,928	1s51ms	0ms
	09	12,983	3s495ms	0ms
	10	20,003	9s716ms	0ms
	11	19,413	6s319ms	0ms
	12	20,795	5s135ms	0ms
	13	17,960	4s645ms	0ms
	14	16,892	4s210ms	0ms
	15	18,276	4s391ms	0ms
	16	17,524	4s516ms	0ms
	17	14,491	3s376ms	0ms
	18	11,466	3s337ms	0ms
	19	11,029	2s893ms	0ms
	20	9,776	2s568ms	0ms
	21	8,926	1s757ms	0ms
	22	4,696	1s88ms	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 (41025964, 39970046, 39423184, 40988019, 41504197, 41504196, 32258019, 42130752, 32600099, 32257744, 41791189, 41935711, 40389462, 32217086, 42041244, 42041242, 37854822, 37855132, 39705159, 39778792, 38907190, 39514906, 34766372, 39847214, 39208982, 39687508, 39832858, 39810428, 39721386, 39667895, 39798260, 39740075, 40385905, 39718707, 39281194, 39648163, 39516078, 39414557, 42088210, 40301233, 39868153, 41790852, 42058555, 41131925, 42057730, 41136270, 41839842, 41791181, 40719641, 41574940, 41790798, 41936434, 32347166, 41618452, 41792533, 40357924, 40357922, 41791138, 41839650, 41936300, 40675170, 41804121, 42058499, 40786694, 39788717, 41084280, 40930292, 40517115, 40937769, 40133154, 41035019, 40508450, 41523625, 39798263, 41936599, 41903471, 41903050, 42082359, 41183775, 41711621, 41903585, 42039579, 41889106, 41758752, 41874721, 41152875, 40852090, 41330181, 41255815, 41625173, 41973481, 40090720, 41743467, 41932196, 41547387, 41444247, 40591295, 39913856, 40213335, 39797866);

Date: 2025-02-03 17:21:57 Duration: 24ms
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 (42009188, 32352757, 32401013, 32296524, 32343627, 32381746, 32401014, 32462130, 32461917, 32390136, 42154648, 42154649, 32346012, 32401627, 32209021, 32368396, 32409222, 32312471, 32306072, 32331455, 32364705, 32328028, 32224203, 32285407, 32388594, 32307233, 32378246, 32453685, 32308426, 32364616, 42024182, 32331490, 32327665, 32327245, 32367538, 32351434, 32663211, 32663212, 32386614, 32397864, 32312476, 42024183, 32398725, 32222945, 32328432, 32666767, 42154067, 32331481, 32310483, 42001920, 32420203);

Date: 2025-02-03 17:21:56 Duration: 12ms
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 (32364971, 32398904, 32367898, 32284363, 41527421, 32372925, 32274819, 32221227, 32349726, 32450093, 32224796, 32249175, 41848047, 42178030, 32393410, 41848048, 32296303, 32224798, 32279032, 42008884, 41381634, 32266246, 32339847, 41199928, 41840439, 42058369, 32266476, 32354611, 32354613, 32320786, 41889183, 42089383, 32251843, 32400250, 32400286, 32305362, 32406065, 32406102, 32406138, 42069203);

Date: 2025-02-03 17:21:56 Duration: 11ms

15

164,428

Details

10s244ms

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	767	37ms	0ms
	01	712	37ms	0ms
	02	530	27ms	0ms
	03	532	27ms	0ms
	04	255	12ms	0ms
	05	316	15ms	0ms
	06	646	33ms	0ms
	07	449	21ms	0ms
	08	3,489	174ms	0ms
	09	9,210	544ms	0ms
	10	16,645	1s165ms	0ms
	11	18,086	1s161ms	0ms
	12	14,719	935ms	0ms
	13	17,814	1s138ms	0ms
	14	16,179	956ms	0ms
	15	12,156	748ms	0ms
	16	13,318	798ms	0ms
	17	12,189	699ms	0ms
	18	9,547	670ms	0ms
	19	7,047	469ms	0ms
	20	5,665	344ms	0ms
	21	2,919	159ms	0ms
	22	1,238	65ms	0ms

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

Date: 2025-02-03 22:21:37 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 (83);

Date: 2025-02-03 19:57:40 Duration: 0ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);

Date: 2025-02-03 16:59:27 Duration: 0ms

16

162,919

Details

14s975ms

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,128	96ms	0ms
	01	1,419	125ms	0ms
	02	2,042	181ms	0ms
	03	1,491	142ms	0ms
	04	723	62ms	0ms
	05	607	47ms	0ms
	06	2,280	169ms	0ms
	07	1,325	100ms	0ms
	08	3,477	286ms	0ms
	09	11,210	1s98ms	0ms
	10	16,368	1s835ms	0ms
	11	16,215	1s182ms	0ms
	12	17,361	1s422ms	0ms
	13	14,288	1s377ms	0ms
	14	12,916	1s132ms	0ms
	15	13,349	1s289ms	0ms
	16	13,355	1s265ms	0ms
	17	9,881	725ms	0ms
	18	7,572	848ms	0ms
	19	6,136	763ms	0ms
	20	4,730	429ms	0ms
	21	3,696	275ms	0ms
	22	1,350	116ms	0ms

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

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

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

Date: 2025-02-03 18:33:39 Duration: 0ms

17

157,848

Details

20s955ms

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	748	76ms	0ms
	01	709	79ms	0ms
	02	527	58ms	0ms
	03	523	57ms	0ms
	04	243	25ms	0ms
	05	294	30ms	0ms
	06	623	67ms	0ms
	07	446	44ms	0ms
	08	3,407	358ms	0ms
	09	9,055	1s141ms	0ms
	10	16,039	2s409ms	0ms
	11	17,164	2s349ms	0ms
	12	14,125	1s920ms	0ms
	13	17,079	2s313ms	0ms
	14	15,520	1s937ms	0ms
	15	11,781	1s540ms	0ms
	16	12,765	1s626ms	0ms
	17	11,710	1s424ms	0ms
	18	8,964	1s370ms	0ms
	19	6,791	976ms	0ms
	20	5,480	707ms	0ms
	21	2,643	305ms	0ms
	22	1,212	133ms	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-02-03 18:50:21 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-03 17:19:47 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 (13) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-03 11:23:30 Duration: 1ms

18

157,038

Details

1m27s

0ms

11ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 03	00	257	156ms	0ms
	01	222	374ms	1ms
	02	226	139ms	0ms
	03	285	172ms	0ms
	04	214	112ms	0ms
	05	124	69ms	0ms
	06	401	178ms	0ms
	07	698	274ms	0ms
	08	2,626	1s239ms	0ms
	09	6,546	3s671ms	0ms
	10	9,863	6s165ms	0ms
	11	8,945	5s398ms	0ms
	12	11,805	7s98ms	0ms
	13	12,289	7s603ms	0ms
	14	10,204	5s946ms	0ms
	15	13,255	7s216ms	0ms
	16	9,527	5s228ms	0ms
	17	8,141	4s249ms	0ms
	18	23,124	12s564ms	0ms
	19	25,442	12s796ms	0ms
	20	9,964	5s124ms	0ms
	21	1,982	1s448ms	0ms
	22	898	432ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (5018495, 5018496, 4980161, 4937601, 4968694, 4858026, 4975740, 4981619, 4780097, 4905070, 4907447, 4914991, 4961903, 4963534, 4810349, 4964930, 4897751, 4936568, 4964648, 4976365, 4941732, 4971506, 4930531, 4933496, 4719497, 4889959, 4974887, 4912406, 4939566, 4894182, 4927960, 4982672, 4968791, 4972732, 4883451, 4833686, 4982636, 4980708, 4972948, 4945561, 4783886, 4920679, 4839878, 4920496, 4872599, 4970891, 4968761, 4960399, 4960509, 5006333, 5000357, 4902640, 4990031, 4895246, 4872900, 4727514, 4853423, 4860042, 4900091, 4913127, 4938383, 4964068, 4974591, 4983924, 4972777, 4702928, 4810017, 4887766, 4901657, 4938400, 4938421, 4957002, 4957004, 4957008, 4957010, 4957020, 4958945, 4959732, 4960320, 4961916, 4961982, 4963691, 4965125, 4968919, 4969325, 4971406, 4971860, 4972173, 4972845, 4973125, 4973298, 4973483, 4974265, 4975647, 4976285, 4976531, 4980155, 4980745, 4981761, 4983915, 4983917, 4983932, 4985284, 4989019, 4989020, 4968491, 4974734, 4959884, 4966000, 4986153, 4987212, 4927662, 4969248, 4967718, 4982634, 4979941, 4933545, 4868172, 4886769, 4988441, 4988440, 4966975, 4925680, 4984359, 4939455, 4958599, 4986305, 4928846, 4852339, 4849054, 4973129, 4973296, 4943131, 4926243, 4961021, 4897677, 4982091, 4982666, 4984310, 4974835, 4834191, 4918966, 4913003, 4927962, 4897210, 4955306, 4952793, 4952340, 4961974, 4777606, 4958257, 4944635, 4982676, 4982675, 4929492, 4916628, 4982650, 4974571, 4982629, 4963636, 4968345, 4977292, 4971375, 4961921, 4958259, 4945556, 4983535, 4893792, 4986747, 4972307, 4472369, 4700326, 4707166, 4808508, 4857854, 4862094, 4873292, 4889207, 4881790, 4899520, 4865877, 4869494, 4906949, 4807090, 4906987);

Date: 2025-02-03 17:22:09 Duration: 11ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1208771, 1626361, 2115046, 4068542, 3279077, 4778676, 2971607, 1846971, 3749191, 4805503, 4048306, 2664384, 4311848, 3937569, 1455078, 1237786, 1159165, 3493014, 4168106, 4611812, 3709630, 2724906, 3979627, 1170998, 3504139, 4158732, 4759887, 1749481, 3080622, 4687888, 4802722, 2030341, 1000168, 4070901, 4579245, 4680898, 1737861, 2294042, 2161083, 1732859, 2897184, 2834807, 510469, 2239789, 4157465, 3419378, 3741094, 4057043, 1157386, 1066221, 2416977, 3225895, 4287621, 2070212, 2324746, 3904244, 4512939, 4544442, 2112367, 2505234, 1109113, 3206215, 1290059, 1364963, 4311707, 1478720, 1328233, 1877610, 3440475, 2353707, 1412491, 2560919, 2950528, 4424128, 1831988, 4886733, 2335824, 4356745, 1835007, 1834865, 1795879, 1193185, 3774623, 1414154, 1187128, 1412253, 4576219, 1920450, 1399471, 2093766, 3448642, 3104250, 3161089, 3450410, 3422655, 3584423, 3061932, 1302866, 3611226, 1402512, 2154706, 1412089, 4088920, 1062631, 1601574, 3426923, 2705784, 2465845, 1042307, 4015879, 4687097, 4012361, 1993533, 4753555, 4512944, 4370822, 2925117, 1567964, 4798989, 3342433, 2193881, 3870630, 4948148, 1552532, 3345636, 3623469, 3230092, 1579849, 2193887, 1769155, 1719247, 2089022, 981819, 2595871, 3169210, 1567975, 2511036, 2522105, 2494399, 1941199, 1839266, 4730715, 3132260, 1189069, 1895882, 3280444, 1256910, 1534570, 1436168, 4582453, 1998918, 2980023, 4664827, 1259158, 4611685, 4637160, 1861080, 1289446, 4016968, 864641, 2049973, 4084298, 3904292, 4651689, 1449584, 3680225, 4409909, 4797032, 2290523, 4379497, 4088335, 1797852, 3864875, 4798804, 3042470, 1347205, 1295500, 4833891, 3799363, 3808439, 4418464, 1475023, 1179602, 1687394, 3692691);

Date: 2025-02-03 11:31:02 Duration: 8ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4970949, 4969983, 4969966, 4969957, 4969326, 4968865, 4967859, 4967807, 4964056, 4963879, 4963130, 4968523, 4968413, 4968412, 4968237, 4968206, 4968019, 4967766, 4967761, 4967559, 4967173, 4967121, 4966912, 4964682, 4963633, 4963599, 4963294, 4962404, 4960359, 4960334, 4960312, 4958549, 4956860, 4956726, 4952840, 4950635, 4950464, 4950453, 4950267, 4950146, 4949171, 4947189, 4943132, 4942776, 4941030, 4931267, 4894514, 4882240, 4880429, 4879802, 4988517, 4988281, 4988095, 4987287, 4985541, 4985276, 4985274, 4984330, 4983131, 4982601, 4976903, 4976898, 4976883, 4976608, 4975921, 4975730, 4973157, 4971845, 4971239, 4969975, 4969198, 4968586, 4968512, 4967614, 4967126, 4966015, 4961529, 4960827, 4960335, 4959630, 4950394, 4942826, 4934564, 4889074, 4985582, 4985552, 4985522, 4985512, 4985489, 4984583, 4983631, 4983076, 4982321, 4982311, 4982245, 4981803, 4980140, 4977855, 4977281, 4976194, 4975452, 4975320, 4972573, 4972566, 4971943, 4965915, 4965184, 4965179, 4964214, 4950316, 4988194, 4986384, 4986211, 4986164, 4985589, 4985526, 4984753, 4982270, 4979783, 4977411, 4976205, 4975344, 4975342, 4975339, 4973861, 4972597, 4972114, 4970867, 4969990, 4969981, 4969978, 4969740, 4968906, 4965978, 4963168, 4962411, 4960299, 4955596, 4955395, 4955031, 4951075, 4988956, 4988949, 4985508, 4979620, 4978512, 4977319, 4977075, 4996971, 4994357, 4994341, 4964072, 4963982, 4956788, 4955402, 4955334, 4950571, 4947687, 4906218, 4890977, 4872955, 4840508, 4830255, 4988965, 4988964, 4988948, 4988530, 4988528, 4988518, 4988275, 4988265, 4988196, 4987231, 4987226, 4985568, 4985564, 4985515, 4985502, 4984897, 4984292, 4983855, 4982599, 4982306, 4982243, 4982047, 4981370, 4980881, 4980871, 4980712, 4978178, 4977752, 4976911, 4976909, 4976353, 4975469, 4975337, 4974885, 4974750, 4974744, 4974742, 4974736, 4974702, 4973894, 4973249, 4972630, 4972620, 4972588, 4972298, 4971965, 4971938, 4971811, 4971799, 4971568, 4970859, 4970792, 4970789, 4988950, 4988523, 4985558, 4985527, 4983630, 4982426, 4981928, 4978988, 4978909, 4976921, 4976611, 4976198, 4976193, 4975922, 4972617, 4972582, 4971234, 4970928, 4969738, 4967149, 4966580, 4966494, 4965917, 4964955, 4962283, 4961972, 4959737, 4959310, 4955728, 4950262, 4948659, 4948439, 4936522, 4932651, 4929992, 4926286, 4925841, 4922089, 4916155, 4897133, 4821626, 4765572, 4988532, 4988525, 4988524, 4988516, 4988157, 4988093, 4985485, 4984782, 4983582, 4983433, 4983093, 4980877, 4979824, 4979013, 4977704, 4976621, 4974470, 4973938, 4972669, 4972524, 4972208, 4971886, 4971757, 4980879, 4959543, 4978908, 4955012, 4978349, 4954993, 4976236, 4954969, 4974514, 4950518, 4973873, 4943230, 4972921, 4923517, 4972643, 4914646, 4969970, 4867102, 4968171, 4744130, 4967686, 4967651, 4967160, 4967087, 4963544, 4961208, 4959723, 4956813, 4895621, 4988944, 4988285, 4985570, 4985551, 4981723, 4976946, 4976320, 4972580, 4972577, 4972570, 4972039, 4970896, 4969685, 4968789, 4967296, 4963603, 4963587, 4959093, 4949916, 4943219, 4937072, 4930666, 4929624, 4927609, 4923002, 4920714, 4918157, 4918040, 4987194, 4986201, 4986149, 4984779, 4980637, 4978048, 4976895, 4975857, 4918191, 4914791, 4891901, 4854584, 4984313, 4984307, 4984303, 4983842, 4983663, 4982125, 4981811, 4981763, 4981588, 4981347, 4981314, 4980809, 4980796, 4978281, 4977715, 4976941, 4976939, 4976917, 4976199, 4973995, 4972645, 4972627, 4972591, 4972470, 4972465, 4972186, 4972129, 4971931, 4971553, 4970869, 4969687, 4968503, 4968055, 4967988, 4967573, 4966275, 4964612, 4963540, 4962884, 4962395, 4962270, 4960415, 4952784, 4951627, 4950517, 4950077, 4948702, 4944820, 4930969, 4930406, 4928866, 4922322, 4894005, 4892737, 4865496, 4781785, 4755623, 4678145, 4998259, 4988984, 4988283, 4988282, 4988263, 4984773, 4983846, 4971677, 4971048, 4970059, 4969961, 4969676, 4969421, 4969344, 4967694, 4967639, 4966626, 4962561, 4962111, 4962078, 4961517, 4959130, 4931278, 4928794, 4907076, 4895899, 4988271, 4985563, 4984790, 4984339, 4977695, 4977347, 4976948, 4976902, 4974028, 4973853, 4973676, 4972578, 4971914, 4970361, 4969958, 4969570, 4969442, 4968811, 4967732, 4967676, 4967066, 4965916, 4963388, 4963367, 4962391, 4960978, 4956736, 4942629, 4939623, 4988260, 4985560, 4985525, 4985510, 4985500, 4985496, 4985488, 4985483, 4983839, 4981662, 4980197, 4980114, 4979811, 4977697, 4977421, 4976689, 4974539, 5001102, 4988270, 4985470, 4984784, 4984600, 4983120, 4982223, 4981972, 4978904, 4978350, 4978195, 4977873, 4977798, 4975498, 4975107, 4974725, 4974613, 4974527, 4973862, 4973492, 4972644, 4972126, 4971528, 4968870, 4968003, 4966098, 4965790, 4964269, 4962272, 4961542, 4956785, 4955374, 4950488, 4947327, 4936550, 4928796, 4925442, 4921437, 4890629, 4874010, 4850022, 4988521, 4988519, 4988279, 4985555, 4985513, 4985491, 4982371, 4979626, 4979022, 4977795, 4976889, 4976739, 4976287, 4976270, 4975830, 4975005, 4974937, 4972610, 4970882, 4970874, 4970863, 4968581, 4974537, 4972203, 4972124, 4971706, 4971367, 4971058, 4966273, 4964245, 4963542, 4962421, 4961814, 4959725, 4959349, 4943196, 4942803, 4935816, 4926075, 4902869, 4898857, 4891041, 4774826, 4989063, 4988970, 4988276, 4988274, 4988267, 4988264, 4987362, 4985569, 4985549, 4985514, 4985504, 4985484, 4985482, 4985478, 4980178, 4979440, 4978488, 4976943, 4975522, 4972583, 4972508, 4971911, 4971381, 4971379, 4956812, 4944844, 4935442, 4930599, 4928950, 4927221, 4891795, 4811418, 4976413, 4976283, 4976184, 4975907, 4975058, 4972048, 4968609, 4968600, 4968122, 4967408, 4967260, 4963585, 4974322, 4972596, 4969955, 4967483, 4959743, 4959301, 4958615, 4955791, 4955761, 4952555, 4951787, 4947381, 4939108, 4931940, 4927332, 4918287, 4893363, 4888941, 4854427, 4852028, 4988269, 4986126, 4979816, 4976720, 4974718, 4969972, 4969632, 4969370, 4968727, 4968495, 4968475, 4968426, 4967971, 4967012, 4966534, 4966523, 4963666, 4963583, 4963543, 4963391, 4963136, 4962970, 4962352, 4962284, 4962073, 4961605, 4960418, 4960416, 4960168, 4959865, 4959568, 4959522, 4959441, 4958607, 4955570, 4955568, 4948458, 4943224, 4942737, 4941074, 4939498, 4931253, 4926214, 4833271, 4777193, 4610443, 4896597, 4993846, 4988983, 4988954, 4988529, 4988010, 4987149, 4985585, 4985574, 4985559, 4985556, 4985546, 4985538, 4985528, 4985520, 4985519, 4985506, 4985501, 4985486, 4985475, 4985473, 4985472, 4984796, 4984373, 4983520, 4982310, 4982285, 4981765, 4978324, 4977073, 4974888, 4973793, 4973424, 4972035, 4971719, 4971447, 4969313, 4967560, 4964764, 4963382, 4963240, 4962512, 4961551, 4956027, 4950188, 4931271, 4913308, 4912630, 4834828, 4973145, 4956862, 4930354, 4913956, 4912312, 4912094, 4908255, 4996200, 4988952, 4988287, 4988278, 4985548, 4985505, 4985477, 4984812, 4981307, 4978035, 4976925, 4976247, 4975077, 4974133, 4973885, 4973175, 4971417, 4971170, 4971139, 4967754, 4965997, 4965283, 4963589, 4963334, 4961755, 4959740, 4959659, 4959103, 4958420, 4958418, 4954985, 4932632, 4912263, 4937119, 4932037, 4921079, 4934530, 4988261, 4985587, 4985577, 4985571, 4985530, 4985529, 4985516, 4985509, 4985493, 4985471, 4985229, 4984982, 4984577, 4983200, 4982207, 4982161, 4982089, 4981669, 4981374, 4981343, 4981203, 4980181, 4979445, 4978855, 4978075, 4976935, 4976900, 4976885, 4976713, 4976382, 4975881, 4975866, 4975369, 4974884, 4972280, 4972140, 4972053, 4971922, 4971616, 4971413, 4971064, 4971029, 4970880, 4970876, 4969417, 4968872, 4968606, 4967684, 4966936, 4987123, 4964393, 4985511, 4964069, 4985492, 4964023, 4985481, 4963883, 4985267, 4962102, 4983584, 4959921);

Date: 2025-02-03 10:53:05 Duration: 8ms

19

144,707

Details

2h1m52s

37ms

298ms

50ms

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
Feb 03	00	2,024	1m34s	46ms
	01	2,463	1m53s	46ms
	02	2,619	2m2s	46ms
	03	2,983	2m21s	47ms
	04	1,184	55s118ms	46ms
	05	1,016	47s72ms	46ms
	06	2,110	1m38s	46ms
	07	1,240	57s676ms	46ms
	08	2,879	2m14s	46ms
	09	7,763	6m25s	49ms
	10	14,758	13m44s	55ms
	11	12,859	11m17s	52ms
	12	13,686	11m45s	51ms
	13	11,183	9m42s	52ms
	14	9,024	7m24s	49ms
	15	7,793	6m37s	50ms
	16	10,077	8m31s	50ms
	17	7,439	5m57s	47ms
	18	7,057	6m16s	53ms
	19	6,498	5m36s	51ms
	20	8,930	7m16s	48ms
	21	5,596	4m14s	45ms
	22	3,526	2m38s	44ms

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

Date: 2025-02-03 19:19:00 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020000)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 18:11:55 Duration: 272ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4986871)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 10:13:28 Duration: 270ms

20

135,706

Details

29s330ms

0ms

3ms

0ms

select res_groups_users_rel.uid, res_groups_users_rel.gid from res_groups_users_rel, "res_groups" where ? = ? and res_groups_users_rel.uid in (...) and res_groups_users_rel.gid = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 03	00	665	120ms	0ms
	01	685	131ms	0ms
	02	602	115ms	0ms
	03	608	118ms	0ms
	04	279	51ms	0ms
	05	325	59ms	0ms
	06	587	110ms	0ms
	07	441	80ms	0ms
	08	2,833	523ms	0ms
	09	8,039	1s672ms	0ms
	10	14,111	3s282ms	0ms
	11	14,861	3s223ms	0ms
	12	12,560	2s715ms	0ms
	13	14,713	3s216ms	0ms
	14	13,064	2s710ms	0ms
	15	9,961	2s157ms	0ms
	16	10,923	2s297ms	0ms
	17	9,739	2s16ms	0ms
	18	7,440	1s776ms	0ms
	19	5,654	1s327ms	0ms
	20	4,410	970ms	0ms
	21	2,301	468ms	0ms
	22	905	181ms	0ms

SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (977) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-03 19:57:40 Duration: 3ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (852) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-03 17:21:55 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1304) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-02-03 17:21:55 Duration: 2ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

32m27s

2m27s

47

Details

1h55m53s

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
Feb 03	00	1	0ms	0ms
	04	1	0ms	0ms
	05	1	0ms	0ms
	06	5	0ms	0ms
	08	2	0ms	0ms
	09	8	19m43s	2m27s
	10	4	2m40s	40s143ms
	11	3	3ms	1ms
	12	1	0ms	0ms
	14	1	2ms	2ms
	15	3	30m40s	10m13s
	16	3	3ms	1ms
	17	4	5ms	1ms
	18	3	53m56s	17m58s
	19	2	8m52s	4m26s
	20	2	2ms	1ms
	21	3	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-03 18:06:53.845208', "last_update" = '2025-02-03 17:21:53.845237', "write_date" = '2025-02-03 17:21:53.515638', "write_uid" = 865 WHERE id IN (865);

Date: 2025-02-03 18:54:20 Duration: 32m27s
UPDATE "res_users" SET "exp_date" = '2025-02-03 14:29:40.315562', "last_update" = '2025-02-03 13:44:40.315588', "write_date" = '2025-02-03 13:44:39.970989', "write_uid" = 1 WHERE id IN (865);

Date: 2025-02-03 15:15:20 Duration: 30m40s
UPDATE "res_users" SET "exp_date" = '2025-02-03 17:33:51.958525', "last_update" = '2025-02-03 16:48:51.958545', "write_date" = '2025-02-03 16:48:51.627244', "write_uid" = 1 WHERE id IN (1231);

Date: 2025-02-03 18:10:20 Duration: 21m29s

2

0ms

23m

24s57ms

277

Details

1h51m3s

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
Feb 03	00	3	23m	7m40s
	02	1	0ms	0ms
	05	1	0ms	0ms
	06	4	0ms	0ms
	08	9	1ms	0ms
	09	31	20ms	0ms
	10	29	3m29s	7s208ms
	11	26	2m27s	5s680ms
	12	27	23ms	0ms
	13	29	13m42s	28s363ms
	14	17	21ms	1ms
	15	22	8m39s	23s624ms
	16	38	59m44s	1m34s
	17	13	13ms	1ms
	18	8	12ms	1ms
	19	6	11ms	1ms
	20	4	9ms	2ms
	21	8	10ms	1ms
	22	1	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-02-02 23:45:05.410478', "last_update" = '2025-02-02 23:00:05.410494', "sid" = '0c05a2909a60a904baa5a7ed857619cde4fe2e65', "write_date" = '2025-02-02 23:00:05.093831', "write_uid" = 1 WHERE id IN (1390);

Date: 2025-02-03 00:23:05 Duration: 23m
UPDATE "res_users" SET "exp_date" = '2025-02-03 15:31:56.580061', "last_update" = '2025-02-03 14:46:56.580085', "sid" = 'c0b3cb2a2774eea1638aca3f8906c4641fe00596', "write_date" = '2025-02-03 14:46:56.142722', "write_uid" = 1 WHERE id IN (905);

Date: 2025-02-03 16:08:20 Duration: 21m24s
UPDATE "res_users" SET "exp_date" = '2025-02-03 15:38:59.361487', "last_update" = '2025-02-03 14:53:59.361515', "sid" = '0c694fa531c7af6cf95ec032884fb1556af07a50', "write_date" = '2025-02-03 14:53:58.961499', "write_uid" = 1 WHERE id IN (905);

Date: 2025-02-03 16:08:20 Duration: 14m21s

3

0ms

41m32s

3s943ms

62,549

Details

2d20h31m2s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Feb 03	00	640	145ms	0ms
	01	696	154ms	0ms
	02	844	186ms	0ms
	03	703	159ms	0ms
	04	517	113ms	0ms
	05	332	72ms	0ms
	06	983	3m35s	219ms
	07	734	156ms	0ms
	08	1,289	282ms	0ms
	09	4,038	43m50s	651ms
	10	6,204	4h58m23s	2s885ms
	11	6,300	10h47m52s	6s170ms
	12	6,484	6h16m51s	3s487ms
	13	5,681	10h28m35s	6s638ms
	14	4,867	3h48m55s	2s822ms
	15	4,991	7h4m31s	5s103ms
	16	4,845	7h9m42s	5s321ms
	17	3,664	6h58m9s	6s847ms
	18	2,699	7h3m11s	9s407ms
	19	2,254	1h48m29s	2s888ms
	20	1,755	1h17m35s	2s652ms
	21	1,494	1m16s	51ms
	22	535	122ms	0ms

update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.021041', exp_date = '2025-02-03 15:11:48.021046', logged_in = 'TRUE' where id = 905;

Date: 2025-02-03 16:08:20 Duration: 41m32s
update res_users set sid = '4d3f3c168a08fef20a690a131b4ecd684c13f0c5', last_update = '2025-02-03 14:26:48.019084', exp_date = '2025-02-03 15:11:48.019089', logged_in = 'TRUE' where id = 905;

Date: 2025-02-03 16:08:20 Duration: 41m32s
update res_users set sid = '86d07bb14fa13de484ce93dfa0b7cfbe40627423', last_update = '2025-02-03 15:34:41.961322', exp_date = '2025-02-03 16:19:41.961327', logged_in = 'TRUE' where id = 835;

Date: 2025-02-03 17:07:21 Duration: 32m39s

4

667ms

4s401ms

2s975ms

272

Details

13m29s

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
Feb 03	00	1	2s898ms	2s898ms
	09	3	12s870ms	4s290ms
	10	2	6s482ms	3s241ms
	11	7	23s487ms	3s355ms
	12	13	43s724ms	3s363ms
	13	12	39s350ms	3s279ms
	14	7	13s62ms	1s866ms
	15	78	3m45s	2s895ms
	16	17	55s279ms	3s251ms
	17	35	1m44s	2s981ms
	18	27	1m4s	2s374ms
	19	27	1m27s	3s232ms
	20	21	1m6s	3s162ms
	21	12	35s59ms	2s921ms
	22	10	29s47ms	2s904ms

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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 09:42:53 Duration: 4s401ms
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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%2%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 15:26:43 Duration: 4s288ms
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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))))) AND ("policy_number"."name"::text ilike '%265%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-02-03 15:26:47 Duration: 4s274ms

5

190ms

1s937ms

793ms

11,010

Details

2h25m41s

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
Feb 03	00	406	2m53s	427ms
	01	102	25s84ms	245ms
	08	15	13s174ms	878ms
	09	2	1s763ms	881ms
	10	3	937ms	312ms
	11	57	55s188ms	968ms
	12	51	47s384ms	929ms
	13	25	16s346ms	653ms
	14	245	2m23s	586ms
	15	497	6m50s	826ms
	16	507	6m36s	782ms
	17	1,421	15m45s	665ms
	18	1,845	26m32s	863ms
	19	1,234	18m37s	905ms
	20	1,842	26m39s	868ms
	21	1,177	15m16s	778ms
	22	1,581	21m26s	813ms

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

Date: 2025-02-03 19:18:59 Duration: 1s937ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '277701')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:12:12 Duration: 1s752ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '278000')) 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 (75))))))) 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 (75)))))) 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 (75)))))) 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 (75))))))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:12:01 Duration: 1s721ms

6

526ms

4s841ms

653ms

43,042

Details

7h48m47s

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
Feb 03	00	125	1m20s	645ms
	01	133	1m28s	661ms
	02	205	2m14s	654ms
	03	245	2m40s	653ms
	04	102	1m6s	650ms
	05	293	2m49s	578ms
	06	162	1m39s	616ms
	07	490	4m38s	567ms
	08	613	5m55s	580ms
	09	3,184	32m49s	618ms
	10	4,485	53m15s	712ms
	11	3,996	43m57s	660ms
	12	4,094	44m50s	657ms
	13	4,164	45m9s	650ms
	14	3,068	31m47s	621ms
	15	3,482	36m51s	635ms
	16	3,723	39m17s	633ms
	17	3,161	33m11s	630ms
	18	2,306	27m38s	719ms
	19	2,014	23m41s	705ms
	20	1,549	17m23s	673ms
	21	1,022	10m39s	625ms
	22	426	4m20s	611ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4986871, 4986847, 4986814, 4986725, 4968641, 4962186)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 10:13:33 Duration: 4s841ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5008368, 5008363, 5008276, 5008246, 5002566, 5001991, 5001983, 5001971, 5001835, 5000244, 5000236, 5000234, 5000225, 4997949, 4997927, 4997886, 4997882, 4997881, 4997827, 4995912, 4995896, 4995880, 4995059, 4973627, 4973625, 4973624, 4973598, 4919018)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 10:13:54 Duration: 4s601ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (5024854, 5024852, 5024850, 5024848, 5024846, 5024844, 5024842, 5024840, 5024838, 5024837, 5024834, 5024831, 5024829, 5024826, 5024823, 5024820, 5024818, 5024815, 5024812)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 19:19:04 Duration: 4s448ms

7

522ms

4s496ms

641ms

247,406

Details

1d20h5m38s

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
Feb 03	00	4,899	47m9s	577ms
	01	6,202	58m40s	567ms
	02	7,058	1h6m54s	568ms
	03	8,136	1h18m44s	580ms
	04	4,201	38m41s	552ms
	05	3,754	35m29s	567ms
	06	4,647	43m43s	564ms
	07	3,421	31m32s	553ms
	08	4,055	37m46s	558ms
	09	11,588	1h56m44s	604ms
	10	20,765	3h56m28s	683ms
	11	15,477	2h45m51s	642ms
	12	16,315	2h51m16s	629ms
	13	13,843	2h27m9s	637ms
	14	10,398	1h44m46s	604ms
	15	12,791	2h16m50s	641ms
	16	12,920	2h16m19s	633ms
	17	10,094	1h46m48s	634ms
	18	22,140	4h25m12s	718ms
	19	19,992	3h52m24s	697ms
	20	19,163	3h40m	688ms
	21	8,933	1h35m16s	639ms
	22	6,614	1h11m46s	651ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4857243)) AND (("shipping_track"."id" not in (40236687, 40247111, 40248538, 40396279, 40584028, 40584296, 40745419, 40772895, 40772909, 40784778, 40784793, 41289266, 41289449, 41435138, 41595880, 41676780, 41676780)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:51 Duration: 4s496ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022346)) AND (("shipping_track"."id" not in (41676799, 41676799)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:11:54 Duration: 4s423ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (5022352)) AND (("shipping_track"."id" not in (41676827, 41676827)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-02-03 18:12:01 Duration: 4s345ms

8

394ms

853ms

540ms

2,247

Details

20m13s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Feb 03	09	155	1m23s	539ms
	10	587	5m44s	586ms
	11	788	6m56s	528ms
	12	195	1m49s	560ms
	13	134	1m8s	510ms
	14	282	2m22s	504ms
	15	96	44s545ms	464ms
	17	10	5s678ms	567ms

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

Date: 2025-02-03 11:06:04 Duration: 853ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '28046')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-03 10:23:02 Duration: 790ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '142665')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-02-03 11:06:02 Duration: 786ms

9

179ms

703ms

297ms

30,073

Details

2h29m15s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Feb 03	08	1,064	4m36s	259ms
	09	1,991	9m46s	294ms
	10	3,385	17m42s	313ms
	11	3,189	16m17s	306ms
	12	4,394	21m30s	293ms
	13	5,332	26m43s	300ms
	14	2,928	14m22s	294ms
	15	3,360	16m41s	298ms
	16	3,976	19m4s	287ms
	17	454	2m30s	330ms

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

Date: 2025-02-03 13:16:41 Duration: 703ms
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" = '9890605')))) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:16:43 Duration: 644ms
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" = '9890314')))) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:16:43 Duration: 640ms

10

186ms

1s389ms

282ms

14,872

Details

1h10m5s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Feb 03	00	524	2m23s	273ms
	01	666	3m3s	276ms
	02	521	2m24s	276ms
	03	1,235	5m48s	281ms
	05	408	1m54s	279ms
	06	290	1m18s	269ms
	07	1	235ms	235ms
	08	6	1s798ms	299ms
	09	193	59s143ms	306ms
	10	254	1m23s	327ms
	11	111	35s900ms	323ms
	12	133	43s777ms	329ms
	13	124	41s189ms	332ms
	14	117	35s211ms	300ms
	15	821	4m14s	310ms
	16	972	5m6s	315ms
	17	492	2m15s	274ms
	18	1,084	5m11s	287ms
	19	1,838	8m53s	289ms
	20	1,659	8m5s	292ms
	21	1,810	7m37s	252ms
	22	1,613	6m48s	253ms

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

Date: 2025-02-03 18:12:10 Duration: 1s389ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '199565')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 19:18:57 Duration: 550ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9949235')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2025-02-03 18:33:03 Duration: 538ms

11

210ms

1s787ms

259ms

2,722

Details

11m45s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Feb 03	00	120	28s100ms	234ms
	01	120	27s958ms	232ms
	02	120	28s32ms	233ms
	03	120	28s443ms	237ms
	04	120	27s841ms	232ms
	05	120	27s905ms	232ms
	06	120	27s969ms	233ms
	07	120	27s855ms	232ms
	08	120	27s967ms	233ms
	09	120	29s807ms	248ms
	10	120	33s561ms	279ms
	11	120	33s115ms	275ms
	12	120	31s524ms	262ms
	13	120	31s827ms	265ms
	14	120	29s662ms	247ms
	15	120	30s501ms	254ms
	16	118	30s271ms	256ms
	17	115	32s92ms	279ms
	18	120	39s645ms	330ms
	19	119	37s45ms	311ms
	20	120	36s317ms	302ms
	21	120	33s280ms	277ms
	22	90	24s967ms	277ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 18:12:03 Duration: 1s787ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 11:06:03 Duration: 1s137ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-02-03 11:06:04 Duration: 1s133ms

12

93ms

836ms

244ms

51,197

Details

3h28m59s

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,838	7m15s	237ms
	01	1,524	5m51s	230ms
	02	1,030	3m56s	229ms
	03	2,456	9m27s	231ms
	05	812	3m21s	248ms
	06	574	2m24s	251ms
	08	38	9s39ms	237ms
	09	386	1m24s	218ms
	10	498	2m1s	243ms
	11	330	1m25s	257ms
	12	358	1m40s	281ms
	13	287	1m25s	296ms
	14	718	3m3s	255ms
	15	2,608	10m58s	252ms
	16	2,890	12m4s	250ms
	17	3,779	15m6s	239ms
	18	5,785	24m53s	258ms
	19	6,102	26m43s	262ms
	20	6,938	29m21s	253ms
	21	5,896	21m20s	217ms
	22	6,350	25m4s	236ms

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

Date: 2025-02-03 19:39:01 Duration: 836ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مجدي')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-03 19:39:01 Duration: 836ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-02-03 15:41:31 Duration: 831ms

13

142ms

1s337ms

205ms

129,755

Details

7h25m16s

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

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,620	5m11s	192ms
	01	2,219	7m5s	191ms
	02	2,502	8m7s	194ms
	03	2,550	8m18s	195ms
	04	2,700	8m39s	192ms
	05	1,413	4m33s	193ms
	06	1,128	3m41s	195ms
	07	1,040	3m21s	193ms
	08	3,471	11m12s	193ms
	09	6,239	21m27s	206ms
	10	10,005	38m50s	232ms
	11	5,765	21m11s	220ms
	12	8,066	29m12s	217ms
	13	11,050	41m14s	223ms
	14	6,073	20m27s	202ms
	15	9,501	34m35s	218ms
	16	7,369	26m25s	215ms
	17	6,946	21m55s	189ms
	18	16,818	57m36s	205ms
	19	21,745	1h7m56s	187ms
	20	862	2m29s	173ms
	21	219	34s687ms	158ms
	22	454	1m11s	157ms

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

Date: 2025-02-03 10:13:30 Duration: 1s337ms
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" = '139157')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 18:11:47 Duration: 1s249ms
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" = '139789')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 18:11:45 Duration: 1s135ms

14

147ms

378ms

205ms

11,830

Details

40m35s

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
Feb 03	00	141	26s904ms	190ms
	03	7	1s374ms	196ms
	04	81	15s733ms	194ms
	05	138	26s416ms	191ms
	06	1,024	3m21s	196ms
	07	1,040	3m21s	194ms
	08	1,017	3m16s	193ms
	09	912	3m5s	202ms
	10	1,938	7m30s	232ms
	11	808	2m53s	214ms
	12	896	3m11s	213ms
	13	1,650	6m3s	220ms
	14	415	1m23s	200ms
	15	185	37s234ms	201ms
	16	228	48s81ms	210ms
	17	265	48s966ms	184ms
	18	196	35s561ms	181ms
	19	192	35s856ms	186ms
	20	192	32s639ms	169ms
	21	219	34s844ms	159ms
	22	286	45s126ms	157ms

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" = '215860')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:28:16 Duration: 378ms
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" = '111551')) 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 (123)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:45:42 Duration: 370ms
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" = '241674')) 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 (65)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (65))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-02-03 10:45:43 Duration: 358ms

15

146ms

242ms

192ms

11,316

Details

36m22s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Feb 03	00	1,479	4m44s	192ms
	01	2,213	7m4s	191ms
	02	2,502	8m6s	194ms
	03	1,976	6m25s	195ms
	04	2,299	7m22s	192ms
	05	704	2m16s	193ms
	22	143	22s413ms	156ms

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

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

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

Date: 2025-02-03 03:14:02 Duration: 237ms

16

121ms

1s164ms

167ms

5,347

Details

14m55s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Feb 03	02	15	2s220ms	148ms
	03	20	2s990ms	149ms
	07	20	2s854ms	142ms
	08	75	10s828ms	144ms
	09	303	48s497ms	160ms
	10	1,083	3m16s	181ms
	11	1,182	3m22s	171ms
	12	995	2m45s	166ms
	13	567	1m34s	166ms
	14	329	51s28ms	155ms
	15	204	32s636ms	159ms
	16	163	26s745ms	164ms
	17	115	17s448ms	151ms
	18	69	10s947ms	158ms
	19	80	12s78ms	150ms
	20	83	11s950ms	143ms
	21	38	5s33ms	132ms
	22	6	820ms	136ms

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

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

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

Date: 2025-02-03 10:13:28 Duration: 427ms

17

97ms

606ms

127ms

18,415

Details

39m4s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Feb 03	05	48	5s741ms	119ms
	07	38	4s603ms	121ms
	08	97	11s454ms	118ms
	09	1,002	2m5s	124ms
	10	1,990	4m34s	137ms
	11	1,958	4m7s	126ms
	12	1,908	4m5s	128ms
	13	1,947	4m8s	127ms
	14	1,489	3m	120ms
	15	2,130	4m26s	125ms
	16	1,582	3m17s	125ms
	17	1,413	2m49s	120ms
	18	484	1m6s	136ms
	19	1,189	2m38s	133ms
	20	856	1m48s	126ms
	21	273	31s369ms	114ms
	22	11	1s313ms	119ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067012)) AND (("cash_track"."id" not in (7567951, 7574537, 7574789, 7646692, 7646773, 7646886, 7646886)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:47 Duration: 606ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8063752)) AND (("cash_track"."id" not in (7546663, 7548024, 7551701, 7646699, 7646780, 7646900, 7646900)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:50 Duration: 600ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8062974)) AND (("cash_track"."id" not in (7540794, 7541547, 7545877, 7646700, 7646782, 7646901, 7646901)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-02-03 10:13:50 Duration: 500ms

18

46ms

334ms

61ms

49,291

Details

50m18s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Feb 03	08	1,772	1m38s	55ms
	09	3,340	3m18s	59ms
	10	5,813	6m20s	65ms
	11	4,565	4m45s	62ms
	12	5,392	5m29s	61ms
	13	6,151	6m19s	61ms
	14	6,573	6m29s	59ms
	15	4,140	4m12s	61ms
	16	8,391	8m34s	61ms
	17	2,952	2m55s	59ms
	18	83	6s160ms	74ms
	19	71	4s955ms	69ms
	20	22	1s346ms	61ms
	21	24	1s429ms	59ms
	22	2	114ms	57ms

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

Date: 2025-02-03 10:13:50 Duration: 334ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4919627) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-03 10:13:26 Duration: 187ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4996679) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2025-02-03 15:26:00 Duration: 119ms

19

41ms

96ms

55ms

21,192

Details

19m40s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Feb 03	08	905	45s747ms	50ms
	09	1,616	1m25s	53ms
	10	2,849	2m50s	59ms
	11	1,736	1m39s	57ms
	12	2,472	2m15s	54ms
	13	3,113	2m57s	56ms
	14	2,794	2m30s	53ms
	15	2,447	2m15s	55ms
	16	2,531	2m20s	55ms
	17	729	39s237ms	53ms

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

Date: 2025-02-03 11:04:46 Duration: 96ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4908778) ORDER BY "collection_policy"."id";

Date: 2025-02-03 13:39:08 Duration: 95ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4942395) ORDER BY "collection_policy"."id";

Date: 2025-02-03 10:21:02 Duration: 89ms

20

37ms

298ms

50ms

144,707

Details

2h1m52s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Feb 03	00	2,024	1m34s	46ms
	01	2,463	1m53s	46ms
	02	2,619	2m2s	46ms
	03	2,983	2m21s	47ms
	04	1,184	55s118ms	46ms
	05	1,016	47s72ms	46ms
	06	2,110	1m38s	46ms
	07	1,240	57s676ms	46ms
	08	2,879	2m14s	46ms
	09	7,763	6m25s	49ms
	10	14,758	13m44s	55ms
	11	12,859	11m17s	52ms
	12	13,686	11m45s	51ms
	13	11,183	9m42s	52ms
	14	9,024	7m24s	49ms
	15	7,793	6m37s	50ms
	16	10,077	8m31s	50ms
	17	7,439	5m57s	47ms
	18	7,057	6m16s	53ms
	19	6,498	5m36s	51ms
	20	8,930	7m16s	48ms
	21	5,596	4m14s	45ms
	22	3,526	2m38s	44ms

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

Date: 2025-02-03 19:19:00 Duration: 298ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (5020000)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 18:11:55 Duration: 272ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4986871)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-02-03 10:13:28 Duration: 270ms

Time consuming prepare

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Time consuming bind

Rank	Total duration	Times executed	Min duration	Max duration	Avg duration	Query
NO DATASET

Log levels

Key values

17,899,820 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	7	0.00%
DETAIL	5	0.00%
ERROR	3,136	0.02%
EVENTLOG	821	0.00%
FATAL	729	0.00%
HINT	2	0.00%
LOG	17,891,957	99.96%
STATEMENT	3,163	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
729 FATAL entries
3136 ERROR entries
0 WARNING entries
821 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,696 Max number of times the same event was reported
4,686 Total events found

Rank

Times reported

Error

1

1,696

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Feb 03	00	27
	01	9
	02	4
	03	8
	04	4
	05	7
	06	7
	07	12
	08	62
	09	81
	10	154
	11	167
	12	129
	13	117
	14	70
	15	116
	16	92
	17	100
	18	125
	19	130
	20	142
	21	113
	22	20

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

2

1,421

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Feb 03	00	19
	01	5
	02	3
	03	6
	04	1
	05	4
	06	5
	07	11
	08	58
	09	71
	10	125
	11	152
	12	115
	13	102
	14	62
	15	93
	16	84
	17	84
	18	87
	19	95
	20	108
	21	112
	22	19

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

555

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Feb 03	00	2
	09	32
	10	102
	11	91
	12	28
	13	72
	14	25
	15	28
	16	50
	17	27
	18	48
	19	21
	20	29

4

555

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Feb 03	00	2
	09	32
	10	102
	11	91
	12	28
	13	72
	14	25
	15	28
	16	50
	17	27
	18	48
	19	21
	20	29

LOG: could not send data to client: Broken pipe
LOG: could not send data to client: Broken pipe

5

181

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Feb 03	00	1
	09	1
	10	30
	11	39
	12	3
	13	28
	14	7
	15	7
	16	24
	17	5
	18	18
	19	13
	20	5

6

97

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Feb 03	17	97

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

7

84

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Feb 03	10	13
	11	21
	12	1
	13	13
	14	5
	15	3
	16	6
	17	3
	18	11
	19	6
	20	2

8

40

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Feb 03	17	40

9

12

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Feb 03	17	12

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

10

6

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Feb 03	11	3
	13	1
	14	2

11

6

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Feb 03	14	1
	16	2
	17	2
	18	1

ERROR: syntax error at or near ")" at character 300
ERROR: syntax error at or near ")" at character 300
ERROR: syntax error at or near ")" at character 157

12

6

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Feb 03	09	1
	11	2
	17	1
	19	2

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

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
Feb 03	05	1
	10	1
	20	4

14

5

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Feb 03	17	5

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
Feb 03	05	1
	10	1
	20	2

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Feb 03	11	2
	13	1

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

17

3

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Feb 03	05	1
	10	1
	20	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Feb 03	17	2

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

19

2

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Feb 03	03	1
	21	1

ERROR: deadlock detected
ERROR: deadlock detected

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Feb 03	20	1

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Feb 03	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables