pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Mon Jan 27 23:47:34 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 44,228,892 log entries in 2m33s
Log start from 2025-01-27 00:00:00 to 2025-01-27 22:45:01

Global Stats

16,956 Number of unique normalized queries
18,834,752 Number of queries
6d8h24m3s Total query duration
2025-01-27 00:00:00 First query
2025-01-27 22:45:01 Last query
7,154 queries/s at 2025-01-27 12:47:13 Query peak

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

15,976 Number of events
20 Number of unique normalized events
10,161 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
18,834,752 Average queries per session
6d8h24m3s 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

7,154 queries/s Query Peak
2025-01-27 12:47:13 Date

SELECT Traffic

Key values

4,984 queries/s Query Peak
2025-01-27 12:47:13 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,729 queries/s Query Peak
2025-01-27 11:55:13 Date

Queries duration

Key values

6d8h24m3s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 27	00	278,312	0ms	3s836ms	17ms	3m18s	3m51s	4m10s
	01	219,161	0ms	1s28ms	22ms	2m22s	2m43s	3m23s
	02	225,907	0ms	907ms	25ms	3m3s	3m40s	4m11s
	03	194,791	0ms	777ms	24ms	2m27s	2m41s	4m47s
	04	161,290	0ms	1s444ms	24ms	2m3s	2m41s	4m6s
	05	91,491	0ms	703ms	14ms	1m2s	1m46s	1m56s
	06	175,387	0ms	694ms	18ms	1m44s	2m58s	3m51s
	07	144,458	0ms	700ms	11ms	1m12s	1m41s	3m6s
	08	440,376	0ms	2s860ms	12ms	3m8s	4m4s	4m12s
	09	1,036,199	0ms	3s697ms	11ms	5m17s	6m2s	6m37s
	10	1,777,910	0ms	25m57s	37ms	15m12s	1h42m12s	6h24m54s
	11	2,138,217	0ms	32m29s	30ms	9m9s	1h15m21s	8h17m51s
	12	1,732,072	0ms	13m54s	20ms	7m29s	34m36s	3h44m55s
	13	1,599,776	0ms	22m46s	34ms	8m42s	1h46m7s	5h53m57s
	14	1,557,506	0ms	20m16s	22ms	11m38s	18m3s	2h46m54s
	15	1,365,422	0ms	9m32s	17ms	6m44s	9m2s	2h37m43s
	16	1,359,832	0ms	50m32s	46ms	9m26s	1h54m29s	6h41m45s
	17	1,221,496	0ms	9m19s	31ms	16m24s	58m30s	2h28m28s
	18	882,182	0ms	4s86ms	19ms	8m17s	8m47s	9m20s
	19	737,715	0ms	38m42s	80ms	8m30s	1h20m5s	8h7m53s
	20	659,433	0ms	3m5s	22ms	6m57s	9m58s	10m23s
	21	508,659	0ms	5m49s	29ms	6m33s	8m26s	9m37s
	22	327,160	0ms	7m22s	32ms	6m47s	8m8s	9m

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 27	00	154,028	32ms	2m14s	3m18s	4m9s
	01	111,253	43ms	2m4s	2m22s	3m2s
	02	113,152	50ms	2m22s	3m3s	4m1s
	03	96,190	49ms	1m52s	2m27s	3m26s
	04	78,418	50ms	1m32s	2m3s	2m59s
	05	44,351	30ms	39s22ms	1m2s	1m55s
	06	93,130	35ms	1m23s	1m44s	3m27s
	07	76,476	22ms	45s250ms	1m12s	2m14s
	08	253,141	21ms	2m14s	3m8s	4m10s
	09	596,403	20ms	4m38s	5m16s	6m30s
	10	1,047,186	23ms	10m10s	11m40s	16m26s
	11	1,221,243	17ms	8m8s	8m36s	9m14s
	12	1,044,058	17ms	6m35s	6m46s	8m14s
	13	964,612	18ms	6m24s	6m48s	8m41s
	14	945,352	19ms	8m10s	10m57s	13m26s
	15	802,967	18ms	5m26s	6m39s	9m
	16	823,069	24ms	7m18s	8m23s	10m3s
	17	749,868	30ms	8m46s	12m44s	16m21s
	18	522,233	33ms	7m1s	8m16s	9m1s
	19	438,422	41ms	7m4s	7m46s	8m39s
	20	389,177	37ms	5m58s	6m56s	10m5s
	21	298,645	48ms	5m28s	6m31s	8m26s
	22	191,080	53ms	5m1s	6m38s	8m7s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 27	00	18,776	4,485	157	0	0ms	113ms	172ms	276ms
	01	17,749	4,157	129	0	0ms	96ms	124ms	177ms
	02	17,654	5,803	140	0	0ms	105ms	148ms	239ms
	03	15,802	5,244	146	0	0ms	93ms	115ms	206ms
	04	11,253	4,442	136	0	0ms	72ms	103ms	160ms
	05	4,886	1,454	131	0	0ms	29ms	46ms	112ms
	06	11,397	2,394	136	0	0ms	68ms	85ms	140ms
	07	6,608	1,977	222	0	0ms	46ms	59ms	104ms
	08	20,242	7,281	425	0	0ms	114ms	156ms	226ms
	09	45,026	15,770	696	0	0ms	251ms	305ms	456ms
	10	79,890	24,448	827	0	398ms	549ms	713ms	1h38m27s
	11	62,227	20,725	801	0	511ms	419ms	506ms	1h13m54s
	12	70,557	24,103	984	0	191ms	451ms	529ms	21m41s
	13	66,824	23,640	1,029	0	401ms	422ms	532ms	1h43m25s
	14	64,798	22,223	680	0	184ms	458ms	738ms	11m41s
	15	55,264	21,946	873	1	117ms	345ms	419ms	640ms
	16	63,865	24,471	664	0	481ms	450ms	603ms	1h51m1s
	17	71,216	25,166	768	1	159ms	681ms	1s24ms	49m19s
	18	69,370	16,896	507	0	0ms	402ms	498ms	867ms
	19	59,970	17,310	412	0	534ms	401ms	493ms	1h14m3s
	20	52,258	16,009	386	0	5ms	333ms	456ms	1m4s
	21	50,167	14,499	273	0	7ms	292ms	369ms	549ms
	22	38,844	6,194	180	0	10ms	265ms	368ms	13s664ms

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

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

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

74,423 buffers Checkpoint Peak
2025-01-27 12:56:25 Date
270.076 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

32 files Wal files usage Peak
2025-01-27 12:56:25 Date

Checkpoints distance

Key values

1,008.13 Mo Distance Peak
2025-01-27 12:56:25 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 27	00	105,210	3,239.604s	0.036s	3,239.68s
	01	131,077	3,239.513s	0.028s	3,239.586s
	02	120,156	3,239.587s	0.036s	3,239.668s
	03	127,920	3,239.622s	0.027s	3,239.69s
	04	116,239	3,239.585s	0.024s	3,239.658s
	05	28,439	1,658.326s	0.029s	1,658.398s
	06	99,380	2,716.12s	0.023s	2,716.18s
	07	58,970	2,602.282s	0.027s	2,602.344s
	08	116,097	3,194.458s	0.033s	3,194.53s
	09	310,860	3,239.516s	0.039s	3,239.621s
	10	513,841	3,239.518s	0.051s	3,239.661s
	11	502,243	3,239.486s	0.053s	3,239.643s
	12	479,934	2,969.446s	0.06s	2,969.588s
	13	474,127	3,239.553s	0.046s	3,239.68s
	14	442,256	3,239.436s	0.046s	3,239.565s
	15	368,612	3,239.598s	0.054s	3,239.723s
	16	388,342	3,239.418s	0.06s	3,239.553s
	17	322,623	2,886.532s	0.081s	2,886.69s
	18	249,137	3,239.536s	0.051s	3,239.668s
	19	209,056	3,239.457s	0.046s	3,239.563s
	20	192,777	3,239.551s	0.043s	3,239.648s
	21	207,920	3,239.618s	0.038s	3,239.716s
	22	157,783	2,429.604s	0.031s	2,429.676s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 27	00	46	2,892	0.002s	0.012s
	01	58	2,745	0.002s	0.012s
	02	54	2,480	0.011s	0.012s
	03	58	2,640	0.002s	0.012s
	04	51	2,403	0.002s	0.012s
	05	12	1,763	0.006s	0.013s
	06	42	1,923	0.003s	0.011s
	07	25	2,335	0.002s	0.012s
	08	49	3,868	0.002s	0.012s
	09	137	5,037	0.002s	0.012s
	10	226	5,462	0.002s	0.012s
	11	225	5,378	0.002s	0.012s
	12	212	5,115	0.003s	0.011s
	13	214	5,352	0.003s	0.012s
	14	198	5,551	0.002s	0.012s
	15	163	5,638	0.003s	0.012s
	16	172	5,895	0.003s	0.012s
	17	138	5,576	0.011s	0.012s
	18	111	5,538	0.002s	0.012s
	19	91	5,260	0.003s	0.012s
	20	86	5,461	0.002s	0.012s
	21	88	5,036	0.002s	0.012s
	22	70	3,556	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 27	00	63,367.17 kB	107,855.83 kB
	01	78,918.42 kB	101,369.92 kB
	02	73,474.75 kB	99,057.25 kB
	03	79,126.00 kB	107,193.67 kB
	04	69,346.17 kB	92,274.33 kB
	05	16,026.38 kB	57,911.08 kB
	06	62,766.45 kB	96,562.82 kB
	07	33,148.42 kB	90,103.08 kB
	08	67,301.25 kB	82,240.58 kB
	09	186,707.25 kB	201,056.50 kB
	10	309,014.73 kB	372,601.82 kB
	11	305,885.75 kB	344,638.75 kB
	12	316,039.82 kB	354,477.27 kB
	13	293,220.25 kB	411,693.33 kB
	14	259,985.27 kB	345,990.00 kB
	15	222,353.83 kB	314,201.83 kB
	16	238,300.82 kB	301,636.45 kB
	17	188,953.10 kB	236,316.70 kB
	18	150,873.17 kB	249,926.50 kB
	19	125,429.83 kB	192,270.50 kB
	20	117,037.33 kB	154,034.17 kB
	21	119,759.08 kB	151,025.92 kB
	22	127,963.67 kB	208,420.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (271) Main checkpoint cause
272 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	271
shutdown immediate	1
Total	272

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

Day	Hour	VACUUMs	ANALYZEs
Jan 27	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

11,054,454 Total read queries
5,285,962 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	11,054,454	58.69%
INSERT	974,643	5.17%
UPDATE	310,637	1.65%
DELETE	10,702	0.06%
COPY FROM	2	0.00%
COPY TO	0	0.00%
CTE	25,256	0.13%
DDL	1,729	0.01%
TCL	3,962,993	21.04%
CURSOR	0	0.00%
OTHERS	2,494,336	13.24%

Queries by database

Key values

unknown Main database
18,834,752 Requests
6d8h24m3s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,834,752	6d8h24m3s
	copy from	2	5ms
	cte	25,256	5s765ms
	ddl	1,729	245ms
	delete	10,702	1s488ms
	insert	974,643	5m15s
	others	2,494,336	2m
	select	11,054,454	3d6h16m18s
	tcl	3,962,993	2m46s
	update	310,637	3d1h57m35s

Queries by user

Key values

unknown Main user
18,834,752 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,834,752	6d8h24m3s
	copy from	2	5ms
	cte	25,256	5s765ms
	ddl	1,729	245ms
	delete	10,702	1s488ms
	insert	974,643	5m15s
	others	2,494,336	2m
	select	11,054,454	3d6h16m18s
	tcl	3,962,993	2m46s
	update	310,637	3d1h57m35s

Duration by user

Key values

6d8h24m3s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,834,752	6d8h24m3s
	copy from	2	5ms
	cte	25,256	5s765ms
	ddl	1,729	245ms
	delete	10,702	1s488ms
	insert	974,643	5m15s
	others	2,494,336	2m
	select	11,054,454	3d6h16m18s
	tcl	3,962,993	2m46s
	update	310,637	3d1h57m35s

Queries by host

Key values

unknown Main host
18,834,752 Requests
6d8h24m3s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,834,752	6d8h24m3s
	copy from	2	5ms
	cte	25,256	5s765ms
	ddl	1,729	245ms
	delete	10,702	1s488ms
	insert	974,643	5m15s
	others	2,494,336	2m
	select	11,054,454	3d6h16m18s
	tcl	3,962,993	2m46s
	update	310,637	3d1h57m35s

Queries by application

Key values

unknown Main application
18,834,752 Requests
6d8h24m3s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,834,752	6d8h24m3s
	copy from	2	5ms
	cte	25,256	5s765ms
	ddl	1,729	245ms
	delete	10,702	1s488ms
	insert	974,643	5m15s
	others	2,494,336	2m
	select	11,054,454	3d6h16m18s
	tcl	3,962,993	2m46s
	update	310,637	3d1h57m35s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-27 09:14:31 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,530,808 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,530,808	93.08%
1-5ms	307,780	1.63%
5-10ms	15,244	0.08%
10-25ms	50,768	0.27%
25-50ms	115,699	0.61%
50-100ms	136,633	0.73%
100-500ms	379,839	2.02%
500-1000ms	293,086	1.56%
1000-10000ms	4,254	0.02%
> 10000ms	641	0.00%

Slowest individual queries

Rank	Duration	Query
1	50m32s	UPDATE "res_users" SET "exp_date" = '2025-01-27 15:08:48.739827', "last_update" = '2025-01-27 14:23:48.739850', "write_date" = '2025-01-27 14:23:48.401321', "write_uid" = 1 WHERE id IN (1229); [ Date: 2025-01-27 16:14:20 ]
2	50m13s	update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:24:07.641656', exp_date = '2025-01-27 15:09:07.641660', logged_in = 'TRUE' where id = 1229; [ Date: 2025-01-27 16:14:20 ]
3	49m13s	update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:25:07.291897', exp_date = '2025-01-27 15:10:07.291901', logged_in = 'TRUE' where id = 1229; [ Date: 2025-01-27 16:14:20 ]
4	44m13s	UPDATE "res_users" SET "exp_date" = '2025-01-27 15:15:06.928239', "last_update" = '2025-01-27 14:30:06.928268', "write_date" = '2025-01-27 14:30:06.582246', "write_uid" = 1 WHERE id IN (965); [ Date: 2025-01-27 16:14:20 ]
5	38m42s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:38.853032', exp_date = '2025-01-27 18:49:38.853035', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
6	38m42s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:38.854300', exp_date = '2025-01-27 18:49:38.854304', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
7	38m36s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:44.965499', exp_date = '2025-01-27 18:49:44.965502', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
8	38m35s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:45.446976', exp_date = '2025-01-27 18:49:45.446980', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
9	38m35s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:45.515624', exp_date = '2025-01-27 18:49:45.515628', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
10	38m35s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:45.530177', exp_date = '2025-01-27 18:49:45.530180', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
11	38m35s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:45.555150', exp_date = '2025-01-27 18:49:45.555154', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
12	38m	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:05:21.005438', exp_date = '2025-01-27 18:50:21.005441', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
13	36m13s	update res_users set sid = 'b226c8db2bdf9659f122ac650025401e09388eb9', last_update = '2025-01-27 14:38:07.447613', exp_date = '2025-01-27 15:23:07.447618', logged_in = 'TRUE' where id = 965; [ Date: 2025-01-27 16:14:20 ]
14	33m33s	update res_users set sid = 'b226c8db2bdf9659f122ac650025401e09388eb9', last_update = '2025-01-27 14:40:47.894836', exp_date = '2025-01-27 15:25:47.894838', logged_in = 'TRUE' where id = 965; [ Date: 2025-01-27 16:14:20 ]
15	32m29s	update res_users set sid = '5c19daa7a5cd343a45dbc1b520baabe9f2f9f5c0', last_update = '2025-01-27 09:51:51.567775', exp_date = '2025-01-27 10:36:51.567778', logged_in = 'TRUE' where id = 1113; [ Date: 2025-01-27 11:24:21 ]
16	32m29s	update res_users set sid = '5c19daa7a5cd343a45dbc1b520baabe9f2f9f5c0', last_update = '2025-01-27 09:51:51.567775', exp_date = '2025-01-27 10:36:51.567778', logged_in = 'TRUE' where id = 1113; [ Date: 2025-01-27 11:24:21 ]
17	30m38s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:12:42.925585', exp_date = '2025-01-27 18:57:42.925590', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
18	30m34s	update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:12:46.748844', exp_date = '2025-01-27 18:57:46.748847', logged_in = 'TRUE' where id = 869; [ Date: 2025-01-27 19:43:21 ]
19	26m54s	update res_users set sid = '5c19daa7a5cd343a45dbc1b520baabe9f2f9f5c0', last_update = '2025-01-27 09:57:27.342723', exp_date = '2025-01-27 10:42:27.342727', logged_in = 'TRUE' where id = 1113; [ Date: 2025-01-27 11:24:21 ]
20	25m57s	update res_users set sid = '8ca4991254f364216dc7eea1fe6b6a26cd1a55c9', last_update = '2025-01-27 08:53:24.083099', exp_date = '2025-01-27 09:38:24.083101', logged_in = 'TRUE' where id = 822; [ Date: 2025-01-27 10:19:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

2d20h5m8s

64,773

Details

0ms

50m13s

3s784ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 27	00	983	212ms	0ms
	01	666	141ms	0ms
	02	774	169ms	0ms
	03	740	158ms	0ms
	04	723	151ms	0ms
	05	168	38ms	0ms
	06	516	108ms	0ms
	07	318	67ms	0ms
	08	1,583	336ms	0ms
	09	4,065	905ms	0ms
	10	6,244	10h14m22s	5s903ms
	11	6,574	11h21m33s	6s220ms
	12	6,801	5h5m23s	2s694ms
	13	6,389	9h23m45s	5s294ms
	14	5,611	4h8m28s	2s657ms
	15	5,084	2h33m1s	1s805ms
	16	4,851	9h42m45s	7s207ms
	17	3,858	4h5m51s	3s823ms
	18	2,667	617ms	0ms
	19	2,176	11h11m47s	18s523ms
	20	1,892	3m6s	98ms
	21	1,358	7m36s	336ms
	22	732	7m23s	605ms

update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:24:07.641656', exp_date = '2025-01-27 15:09:07.641660', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-27 16:14:20 Duration: 50m13s
update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:25:07.291897', exp_date = '2025-01-27 15:10:07.291901', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-27 16:14:20 Duration: 49m13s
update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:38.853032', exp_date = '2025-01-27 18:49:38.853035', logged_in = 'TRUE' where id = 869;

Date: 2025-01-27 19:43:21 Duration: 38m42s

2

1d16h6m7s

239,113

Details

493ms

5s95ms

603ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 27	00	5,998	54m48s	548ms
	01	6,599	59m15s	538ms
	02	7,069	1h3m26s	538ms
	03	5,932	53m28s	540ms
	04	4,544	41m19s	545ms
	05	1,583	14m22s	544ms
	06	4,806	42m26s	529ms
	07	1,936	17m3s	528ms
	08	5,443	48m55s	539ms
	09	10,697	1h40m10s	561ms
	10	19,595	3h31m56s	648ms
	11	14,614	2h30m39s	618ms
	12	15,158	2h30m11s	594ms
	13	13,361	2h10m57s	588ms
	14	13,464	2h22m32s	635ms
	15	10,604	1h43m17s	584ms
	16	16,904	2h53m5s	614ms
	17	16,841	3h5m9s	659ms
	18	15,708	2h47m13s	638ms
	19	15,086	2h38m3s	628ms
	20	10,091	1h44m2s	618ms
	21	12,598	2h6m45s	603ms
	22	10,482	1h46m56s	612ms

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

Date: 2025-01-27 17:48:32 Duration: 5s95ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819047)) AND (("shipping_track"."id" not in (39947186, 39947186)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:51 Duration: 5s29ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819045)) AND (("shipping_track"."id" not in (39947180, 39947180)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:50 Duration: 4s766ms

3

8h37m18s

145,768

Details

158ms

1s476ms

212ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 27	00	755	2m16s	180ms
	01	1,443	4m18s	179ms
	02	3,315	9m56s	180ms
	03	2,459	7m21s	179ms
	04	2,724	8m7s	178ms
	05	368	1m5s	179ms
	06	1,287	3m49s	178ms
	07	663	1m58s	179ms
	08	3,096	9m21s	181ms
	09	8,164	25m48s	189ms
	10	11,109	39m47s	214ms
	11	6,620	22m54s	207ms
	12	7,679	26m4s	203ms
	13	11,330	37m48s	200ms
	14	10,281	37m19s	217ms
	15	12,336	41m28s	201ms
	16	17,240	58m21s	203ms
	17	15,750	1h10m26s	268ms
	18	1,079	4m1s	223ms
	19	8,189	29m55s	219ms
	20	9,105	35m	230ms
	21	10,631	39m34s	223ms
	22	145	30s67ms	207ms

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

Date: 2025-01-27 17:34:35 Duration: 1s476ms
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" = '9891888')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 14:05:54 Duration: 1s458ms
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" = '18486')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 10:55:03 Duration: 1s452ms

4

7h13m56s

41,795

Details

495ms

4s432ms

622ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 27	00	148	1m30s	612ms
	01	162	1m41s	626ms
	02	214	2m12s	617ms
	03	167	1m43s	621ms
	04	120	1m14s	622ms
	05	62	38s393ms	619ms
	06	209	1m56s	559ms
	07	528	4m46s	543ms
	08	1,492	13m32s	544ms
	09	2,577	25m8s	585ms
	10	3,905	44m	676ms
	11	4,070	43m16s	637ms
	12	4,131	42m26s	616ms
	13	3,986	40m31s	610ms
	14	4,394	48m	655ms
	15	3,153	31m3s	590ms
	16	3,043	31m49s	627ms
	17	3,130	34m8s	654ms
	18	1,992	20m25s	615ms
	19	1,453	14m59s	618ms
	20	1,458	14m37s	601ms
	21	903	9m5s	603ms
	22	498	5m5s	613ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4785982, 4785675, 4785625, 4785596, 4785586, 4785581, 4782307, 4778579, 4777324, 4775115, 4774865, 4774843, 4773857, 4769050, 4768668, 4768147, 4767963, 4763477, 4762380, 4751880, 4722209, 4677413)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 10:53:55 Duration: 4s432ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4812853, 4730481, 4766502, 4767410, 4811031, 4811036, 4811340, 4812742, 4718372, 4780545, 4783977, 4789388, 4789891, 4790094, 4790166, 4790237, 4790643, 4791969, 4792611, 4794636, 4796245, 4796357, 4796992, 4798278, 4799677, 4799713, 4801015, 4801938, 4801953, 4803049, 4806218, 4806792, 4808143, 4808245, 4809000, 4809920, 4811030)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 14:06:59 Duration: 4s266ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4792246, 4792243, 4792241, 4792239, 4777128, 4774897, 4774889, 4774885, 4774883, 4774866, 4774864, 4774863, 4774838, 4774833, 4774832, 4774831, 4774830, 4774829, 4774053, 4773192, 4773189, 4773184, 4773178, 4773142, 4773121, 4773118, 4773117, 4773091, 4770591, 4770352, 4770315, 4770303, 4769879, 4769830, 4769818, 4769816, 4769815, 4768497, 4768474, 4767054, 4765986, 4765941, 4765907, 4765905, 4765890, 4765886, 4765016, 4765015, 4765013, 4765012, 4765009, 4764835, 4764509, 4763515, 4761775, 4761243)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 14:06:11 Duration: 4s252ms

5

3h43m49s

54,958

Details

90ms

963ms

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
Jan 27	00	1,947	7m13s	222ms
	01	1,105	4m23s	238ms
	02	1,042	3m56s	227ms
	03	1,202	4m31s	226ms
	04	922	3m45s	244ms
	05	644	2m14s	208ms
	06	20	5s699ms	284ms
	07	36	9s349ms	259ms
	08	228	58s612ms	257ms
	09	4	1s97ms	274ms
	10	412	1m35s	230ms
	11	250	1m7s	269ms
	12	482	1m51s	231ms
	13	412	1m48s	262ms
	14	670	2m23s	214ms
	15	1,654	6m13s	225ms
	16	3,142	13m17s	253ms
	17	5,712	27m5s	284ms
	18	8,671	36m30s	252ms
	19	8,645	35m59s	249ms
	20	6,812	26m58s	237ms
	21	5,746	21m51s	228ms
	22	5,200	19m46s	228ms

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

Date: 2025-01-27 18:24:52 Duration: 963ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-27 18:24:52 Duration: 962ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-27 19:53:34 Duration: 914ms

6

3h22m37s

13,029

Details

215ms

1s934ms

933ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 27	00	604	8m28s	841ms
	01	86	1m17s	899ms
	02	12	10s679ms	889ms
	10	24	26s45ms	1s85ms
	11	19	20s979ms	1s104ms
	12	41	36s100ms	880ms
	13	120	1m58s	987ms
	14	224	3m24s	914ms
	15	583	9m5s	935ms
	16	502	8m14s	984ms
	17	1,040	18m47s	1s83ms
	18	1,840	28m14s	920ms
	19	2,079	32m16s	931ms
	20	2,753	42m42s	930ms
	21	1,373	20m8s	880ms
	22	1,729	26m25s	916ms

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

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

Date: 2025-01-27 17:31:35 Duration: 1s898ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112583')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-27 17:31:46 Duration: 1s889ms

7

3h21m16s

65

Details

0ms

50m32s

3m5s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 27	00	1	0ms	0ms
	07	1	0ms	0ms
	08	2	0ms	0ms
	09	5	1ms	0ms
	10	9	14m15s	1m35s
	11	5	23m	4m36s
	12	4	5ms	1ms
	13	8	22m24s	2m48s
	14	8	20m16s	2m32s
	15	4	5ms	1ms
	16	8	1h53m9s	14m8s
	17	5	8m11s	1m38s
	18	2	1ms	0ms
	21	1	1ms	1ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-27 15:08:48.739827', "last_update" = '2025-01-27 14:23:48.739850', "write_date" = '2025-01-27 14:23:48.401321', "write_uid" = 1 WHERE id IN (1229);

Date: 2025-01-27 16:14:20 Duration: 50m32s
UPDATE "res_users" SET "exp_date" = '2025-01-27 15:15:06.928239', "last_update" = '2025-01-27 14:30:06.928268', "write_date" = '2025-01-27 14:30:06.582246', "write_uid" = 1 WHERE id IN (965);

Date: 2025-01-27 16:14:20 Duration: 44m13s
UPDATE "res_users" SET "exp_date" = '2025-01-27 10:46:21.339204', "last_update" = '2025-01-27 10:01:21.339235', "write_date" = '2025-01-27 10:01:20.881361', "write_uid" = 1 WHERE id IN (865);

Date: 2025-01-27 11:24:21 Duration: 23m

8

2h31m26s

31,873

Details

166ms

1s749ms

285ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 27	08	694	2m52s	249ms
	09	2,254	10m18s	274ms
	10	3,816	18m13s	286ms
	11	4,762	22m29s	283ms
	12	2,839	13m8s	277ms
	13	5,901	27m15s	277ms
	14	5,124	25m50s	302ms
	15	2,998	13m57s	279ms
	16	2,720	13m30s	298ms
	17	765	3m48s	299ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9852641')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:09 Duration: 1s749ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '129011')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:12 Duration: 1s289ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9970949')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:15 Duration: 802ms

9

2h15m14s

299

Details

0ms

22m23s

27s138ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 27	00	6	5ms	0ms
	01	1	0ms	0ms
	02	1	0ms	0ms
	03	2	1ms	0ms
	04	1	0ms	0ms
	06	3	0ms	0ms
	07	2	0ms	0ms
	08	10	1ms	0ms
	09	28	5ms	0ms
	10	30	1h4m17s	2m8s
	11	32	8m57s	16s786ms
	12	24	22ms	0ms
	13	19	25m2s	1m19s
	14	25	33ms	1ms
	15	20	13ms	0ms
	16	18	16m36s	55s348ms
	17	23	37ms	1ms
	18	7	4ms	0ms
	19	16	20m21s	1m16s
	20	11	9ms	0ms
	21	10	6ms	0ms
	22	10	6ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-27 09:41:57.456021', "last_update" = '2025-01-27 08:56:57.456043', "sid" = 'ef2c559c12e6bedc71edfd03e2dcc3f64d5baf72', "write_date" = '2025-01-27 08:56:57.114967', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-27 10:19:21 Duration: 22m23s
UPDATE "res_users" SET "exp_date" = '2025-01-27 09:42:34.327135', "last_update" = '2025-01-27 08:57:34.327163', "sid" = '489394a31eef29149a7ce2204c1c039a44bcd5a2', "write_date" = '2025-01-27 08:57:33.933688', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-27 10:19:21 Duration: 21m47s
UPDATE "res_users" SET "exp_date" = '2025-01-27 19:13:14.538332', "last_update" = '2025-01-27 18:28:14.538359', "sid" = '278d944b7cb852db143f4e1ac999c9d3993a179b', "write_date" = '2025-01-27 18:28:14.132216', "write_uid" = 869 WHERE id IN (869);

Date: 2025-01-27 19:43:21 Duration: 15m6s

10

1h52m23s

138,095

Details

36ms

439ms

48ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	00	2,861	2m5s	43ms
	01	2,527	1m50s	43ms
	02	2,366	1m44s	44ms
	03	2,113	1m33s	44ms
	04	1,147	50s862ms	44ms
	05	525	23s263ms	44ms
	06	1,871	1m22s	43ms
	07	1,258	55s458ms	44ms
	08	3,326	2m27s	44ms
	09	7,533	5m46s	46ms
	10	15,014	13m17s	53ms
	11	11,899	9m55s	50ms
	12	11,877	9m33s	48ms
	13	11,377	9m3s	47ms
	14	10,911	9m11s	50ms
	15	8,342	6m34s	47ms
	16	7,948	6m31s	49ms
	17	7,746	6m47s	52ms
	18	6,578	5m26s	49ms
	19	6,390	5m18s	49ms
	20	5,956	4m48s	48ms
	21	4,510	3m39s	48ms
	22	4,020	3m15s	48ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4810136, 4763579, 4763578, 4763577, 4763576, 4763575, 4763574, 4763573)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:53:55 Duration: 439ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4746888, 4734379, 4729519, 4720553, 4717669)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:58:20 Duration: 369ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4767410)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 14:07:02 Duration: 271ms

11

1h38m48s

50,939

Details

75ms

581ms

116ms

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"."state" != ?) or "cash_policy"."state" is null) and ("cash_policy"."policy_name" = ?))) and (((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) and (("cash_policy"."state" not in (...)) or "cash_policy"."state" is null)) order by "cash_policy"."id" desc limit ?;

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 27	00	2	170ms	85ms
	08	9	844ms	93ms
	09	36	3s393ms	94ms
	10	13,617	32m9s	141ms
	11	36,347	1h4m58s	107ms
	12	256	26s	101ms
	13	194	19s837ms	102ms
	14	158	16s947ms	107ms
	15	107	10s334ms	96ms
	16	81	8s452ms	104ms
	17	47	5s712ms	121ms
	18	39	3s747ms	96ms
	19	21	1s993ms	94ms
	20	21	1s897ms	90ms
	21	2	181ms	90ms
	22	2	182ms	91ms

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

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

Date: 2025-01-27 10:58:03 Duration: 578ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND ("cash_policy"."policy_name" = '46774'))) AND (((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC LIMIT 200;

Date: 2025-01-27 10:54:56 Duration: 578ms

12

1h10m28s

14,808

Details

206ms

1s701ms

285ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	00	379	1m33s	247ms
	01	476	1m55s	241ms
	02	520	2m7s	245ms
	03	607	2m26s	241ms
	04	463	1m55s	250ms
	05	325	1m20s	248ms
	06	14	3s151ms	225ms
	07	18	4s707ms	261ms
	08	117	29s167ms	249ms
	09	3	788ms	262ms
	10	189	56s632ms	299ms
	11	109	31s641ms	290ms
	12	203	56s657ms	279ms
	13	94	25s748ms	273ms
	14	118	33s543ms	284ms
	15	255	1m8s	267ms
	16	1,101	5m8s	280ms
	17	1,841	10m5s	328ms
	18	2,542	12m44s	300ms
	19	2,291	11m4s	290ms
	20	702	3m20s	285ms
	21	1,538	7m12s	280ms
	22	903	4m22s	291ms

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

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

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

Date: 2025-01-27 17:32:12 Duration: 702ms

13

47m37s

47,991

Details

44ms

339ms

59ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	07	12	689ms	57ms
	08	1,124	1m	53ms
	09	3,567	3m18s	55ms
	10	7,000	7m40s	65ms
	11	3,871	3m50s	59ms
	12	5,448	5m15s	57ms
	13	8,834	8m26s	57ms
	14	6,383	6m33s	61ms
	15	4,794	4m33s	57ms
	16	4,546	4m30s	59ms
	17	2,152	2m12s	61ms
	18	156	9s710ms	62ms
	19	40	2s480ms	62ms
	20	52	3s124ms	60ms
	21	9	520ms	57ms
	22	3	178ms	59ms

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

Date: 2025-01-27 10:54:43 Duration: 339ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4735782) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:42 Duration: 329ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4665199) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:53:59 Duration: 302ms

14

44m56s

13,691

Details

164ms

1s390ms

196ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 27	00	180	32s265ms	179ms
	02	32	5s695ms	177ms
	03	10	1s833ms	183ms
	06	1,287	3m49s	178ms
	07	663	1m59s	179ms
	08	1,688	5m6s	181ms
	09	1,971	6m6s	186ms
	10	2,329	8m13s	211ms
	11	804	2m50s	211ms
	12	1,009	3m23s	201ms
	13	1,037	3m30s	203ms
	14	802	2m47s	208ms
	15	428	1m27s	203ms
	16	106	21s388ms	201ms
	17	370	1m14s	200ms
	18	279	58s481ms	209ms
	19	267	57s674ms	216ms
	20	165	34s847ms	211ms
	21	215	45s175ms	210ms
	22	49	10s154ms	207ms

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

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

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

Date: 2025-01-27 10:55:11 Duration: 982ms

15

37m31s

18,138

Details

95ms

760ms

124ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	01	71	7s426ms	104ms
	07	90	10s431ms	115ms
	08	330	38s14ms	115ms
	09	895	1m48s	121ms
	10	1,594	3m35s	135ms
	11	1,454	3m5s	127ms
	12	2,796	5m43s	122ms
	13	2,378	4m49s	121ms
	14	1,839	3m55s	128ms
	15	1,587	3m11s	120ms
	16	1,568	3m14s	124ms
	17	1,181	2m28s	125ms
	18	940	1m56s	124ms
	19	237	29s746ms	125ms
	20	706	1m20s	114ms
	21	407	47s462ms	116ms
	22	65	7s837ms	120ms

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

Date: 2025-01-27 17:33:16 Duration: 760ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8042272)) AND (("cash_track"."id" not in (7389157, 7392290, 7393230, 7410695, 7410709, 7410709)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-27 14:06:07 Duration: 746ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8042392)) AND (("cash_track"."id" not in (7389730, 7392261, 7393165, 7400229, 7400229)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-27 10:57:24 Duration: 738ms

16

28m11s

9,381

Details

160ms

221ms

180ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 27	00	575	1m44s	181ms
	01	1,373	4m7s	180ms
	02	2,720	8m13s	181ms
	03	2,271	6m49s	180ms
	04	2,241	6m40s	178ms
	05	201	35s837ms	178ms

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

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

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

Date: 2025-01-27 03:03:04 Duration: 220ms

17

18m58s

21,274

Details

39ms

157ms

53ms

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
Jan 27	08	655	31s567ms	48ms
	09	1,538	1m16s	49ms
	10	2,854	2m36s	54ms
	11	1,539	1m23s	54ms
	12	2,638	2m16s	51ms
	13	3,214	2m48s	52ms
	14	3,549	3m18s	55ms
	15	2,150	1m50s	51ms
	16	2,328	2m8s	55ms
	17	807	46s48ms	57ms
	19	2	113ms	56ms

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

Date: 2025-01-27 10:54:55 Duration: 157ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4715727) ORDER BY "collection_policy"."id";

Date: 2025-01-27 14:06:35 Duration: 119ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4691065) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:55 Duration: 114ms

18

15m18s

6,083

Details

119ms

1s192ms

151ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 27	00	5	634ms	126ms
	01	10	1s295ms	129ms
	06	10	1s291ms	129ms
	08	97	12s782ms	131ms
	09	553	1m17s	139ms
	10	1,232	3m24s	165ms
	11	1,130	2m53s	153ms
	12	860	2m6s	147ms
	13	505	1m14s	146ms
	14	682	1m41s	149ms
	15	328	45s35ms	137ms
	16	222	33s379ms	150ms
	17	132	22s698ms	171ms
	18	81	11s198ms	138ms
	19	70	10s9ms	142ms
	20	64	8s911ms	139ms
	21	55	7s559ms	137ms
	22	47	6s626ms	140ms

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

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

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

Date: 2025-01-27 10:55:17 Duration: 936ms

19

15m13s

1,765

Details

368ms

1s726ms

517ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	08	208	1m29s	430ms
	09	473	3m37s	459ms
	10	295	2m38s	538ms
	11	519	4m44s	547ms
	12	158	1m26s	545ms
	14	81	1m	746ms
	15	29	15s625ms	538ms
	16	2	976ms	488ms

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

Date: 2025-01-27 10:57:18 Duration: 1s726ms
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" = '9704280')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-27 14:05:57 Duration: 1s271ms
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" = '9805963')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-27 14:07:06 Duration: 891ms

20

12m34s

261

Details

31ms

4s567ms

2s891ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 27	08	1	2s860ms	2s860ms
	09	9	29s654ms	3s294ms
	10	6	282ms	47ms
	11	11	15s746ms	1s431ms
	12	14	52s150ms	3s725ms
	13	10	32s905ms	3s290ms
	14	10	36s586ms	3s658ms
	15	20	1m5s	3s288ms
	16	30	1m14s	2s467ms
	17	21	56s360ms	2s683ms
	18	21	1m6s	3s173ms
	19	61	3m21s	3s302ms
	20	13	39s782ms	3s60ms
	21	19	39s755ms	2s92ms
	22	15	40s730ms	2s715ms

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 (13))))))) 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 (13)))))) 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 (13)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) 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 (13))))))))) 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 (13)))))))) AND ("policy_number"."name"::text ilike '%9924913%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 17:32:36 Duration: 4s567ms
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 (2))))))) 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 (2)))))) 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 (2)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2)))))) 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 (2))))))))) 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 (2)))))))) AND ("policy_number"."name"::text ilike '%9683152%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 14:55:45 Duration: 4s315ms
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 (5))))))) 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 (5)))))) 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 (5)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (5)))))) 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 (5))))))))) 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 (5)))))))) AND ("policy_number"."name"::text ilike '%9688735%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 13:14:15 Duration: 4s240ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,493,341

Details

2m

0ms

16ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 27	00	40,542	1s738ms	0ms
	01	35,034	1s542ms	0ms
	02	35,810	1s654ms	0ms
	03	31,350	1s400ms	0ms
	04	27,086	1s182ms	0ms
	05	16,936	644ms	0ms
	06	26,403	1s228ms	0ms
	07	23,800	945ms	0ms
	08	62,111	2s998ms	0ms
	09	144,297	7s946ms	0ms
	10	231,106	12s438ms	0ms
	11	304,138	14s836ms	0ms
	12	225,440	10s416ms	0ms
	13	209,687	9s503ms	0ms
	14	203,125	10s46ms	0ms
	15	188,789	9s152ms	0ms
	16	175,308	8s279ms	0ms
	17	144,344	6s428ms	0ms
	18	108,077	5s543ms	0ms
	19	88,713	4s107ms	0ms
	20	78,937	3s601ms	0ms
	21	56,441	2s908ms	0ms
	22	35,867	1s841ms	0ms

DISCARD ALL;

Date: 2025-01-27 10:50:36 Duration: 16ms
DISCARD ALL;

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

Date: 2025-01-27 16:02:50 Duration: 1ms

2

1,981,921

Details

28s392ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 27	00	29,972	439ms	0ms
	01	25,376	386ms	0ms
	02	26,653	413ms	0ms
	03	23,005	353ms	0ms
	04	19,970	309ms	0ms
	05	11,866	187ms	0ms
	06	20,942	326ms	0ms
	07	17,627	258ms	0ms
	08	48,377	703ms	0ms
	09	116,776	1s713ms	0ms
	10	195,797	3s90ms	0ms
	11	263,160	3s577ms	0ms
	12	182,166	2s454ms	0ms
	13	165,556	2s168ms	0ms
	14	159,206	2s287ms	0ms
	15	146,955	2s56ms	0ms
	16	134,813	1s920ms	0ms
	17	113,495	1s628ms	0ms
	18	82,037	1s212ms	0ms
	19	65,774	940ms	0ms
	20	60,877	836ms	0ms
	21	44,115	692ms	0ms
	22	27,406	434ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-27 21:07:05 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

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

Date: 2025-01-27 10:12:10 Duration: 1ms

3

1,269,142

Details

12s775ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 27	00	20,896	182ms	0ms
	01	18,107	159ms	0ms
	02	18,520	167ms	0ms
	03	16,270	142ms	0ms
	04	14,146	123ms	0ms
	05	9,071	74ms	0ms
	06	13,836	127ms	0ms
	07	12,482	104ms	0ms
	08	31,903	294ms	0ms
	09	73,447	742ms	0ms
	10	116,956	1s332ms	0ms
	11	153,512	1s555ms	0ms
	12	114,144	1s144ms	0ms
	13	106,262	1s55ms	0ms
	14	102,923	1s76ms	0ms
	15	95,696	915ms	0ms
	16	89,049	906ms	0ms
	17	73,299	784ms	0ms
	18	55,049	562ms	0ms
	19	45,254	443ms	0ms
	20	40,429	392ms	0ms
	21	29,215	298ms	0ms
	22	18,676	190ms	0ms

ROLLBACK;

Date: 2025-01-27 10:02:56 Duration: 0ms
ROLLBACK;

Date: 2025-01-27 09:17:55 Duration: 0ms
ROLLBACK;

Date: 2025-01-27 10:57:35 Duration: 0ms

4

1,256,475

Details

3m33s

0ms

17ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 27	00	20,226	3s68ms	0ms
	01	17,501	2s720ms	0ms
	02	17,869	2s840ms	0ms
	03	15,635	2s456ms	0ms
	04	13,531	2s46ms	0ms
	05	8,447	1s22ms	0ms
	06	13,186	1s975ms	0ms
	07	11,923	1s552ms	0ms
	08	31,377	4s905ms	0ms
	09	73,007	12s46ms	0ms
	10	116,812	21s949ms	0ms
	11	153,385	25s814ms	0ms
	12	113,771	18s977ms	0ms
	13	105,637	17s640ms	0ms
	14	102,485	17s895ms	0ms
	15	95,236	15s561ms	0ms
	16	88,433	15s474ms	0ms
	17	72,737	13s463ms	0ms
	18	54,552	9s457ms	0ms
	19	44,499	7s656ms	0ms
	20	39,745	6s738ms	0ms
	21	28,446	5s127ms	0ms
	22	18,035	3s181ms	0ms

SELECT payload FROM http_sessions WHERE sid = '4be3cbf93c1af1add4a606a7b0264a761d27bd67';

Date: 2025-01-27 14:05:44 Duration: 17ms
SELECT payload FROM http_sessions WHERE sid = '65e7eb522b667f9959dcdf8e3b1819b738052b43';

Date: 2025-01-27 11:04:59 Duration: 15ms
SELECT payload FROM http_sessions WHERE sid = 'b926adf84ce48fe1922ca9aeb348c47db76ab13e';

Date: 2025-01-27 13:20:45 Duration: 13ms

5

1,246,590

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
Jan 27	00	20,319	1s669ms	0ms
	01	17,599	1s468ms	0ms
	02	17,974	1s544ms	0ms
	03	15,744	1s308ms	0ms
	04	13,616	1s124ms	0ms
	05	8,537	665ms	0ms
	06	13,263	1s145ms	0ms
	07	11,972	921ms	0ms
	08	31,067	2s628ms	0ms
	09	72,073	6s315ms	0ms
	10	115,429	11s315ms	0ms
	11	151,976	13s622ms	0ms
	12	112,626	9s949ms	0ms
	13	104,763	9s233ms	0ms
	14	101,501	9s656ms	0ms
	15	94,344	8s213ms	0ms
	16	87,598	7s969ms	0ms
	17	72,099	6s866ms	0ms
	18	54,067	4s803ms	0ms
	19	44,331	3s795ms	0ms
	20	39,518	3s468ms	0ms
	21	28,233	2s560ms	0ms
	22	17,941	1s605ms	0ms

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

Date: 2025-01-27 09:23:24 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-27 14:06:21 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-27 10:57:28 Duration: 1ms

6

905,861

Details

2m18s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 27	00	11,930	1s820ms	0ms
	01	8,674	1s479ms	0ms
	02	9,292	1s606ms	0ms
	03	7,485	1s348ms	0ms
	04	6,475	1s182ms	0ms
	05	3,112	635ms	0ms
	06	9,116	1s441ms	0ms
	07	6,071	1s20ms	0ms
	08	20,578	3s73ms	0ms
	09	56,637	8s335ms	0ms
	10	98,495	16s657ms	0ms
	11	135,253	20s976ms	0ms
	12	90,144	12s792ms	0ms
	13	77,096	10s547ms	0ms
	14	73,794	10s960ms	0ms
	15	67,186	9s887ms	0ms
	16	59,127	8s972ms	0ms
	17	50,558	7s652ms	0ms
	18	34,584	5s345ms	0ms
	19	25,773	3s872ms	0ms
	20	25,666	3s878ms	0ms
	21	18,110	3s96ms	0ms
	22	10,705	1s897ms	0ms

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

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

Date: 2025-01-27 17:21:54 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 (1111);

Date: 2025-01-27 17:21:54 Duration: 9ms

7

711,924

Details

2m4s

0ms

42ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 27	00	9,074	1s661ms	0ms
	01	7,271	1s494ms	0ms
	02	8,128	1s614ms	0ms
	03	6,740	1s528ms	0ms
	04	5,824	1s335ms	0ms
	05	2,795	418ms	0ms
	06	7,106	1s210ms	0ms
	07	5,145	768ms	0ms
	08	16,473	2s842ms	0ms
	09	43,307	6s736ms	0ms
	10	78,743	14s830ms	0ms
	11	109,555	16s980ms	0ms
	12	67,942	11s653ms	0ms
	13	59,169	10s115ms	0ms
	14	56,210	10s600ms	0ms
	15	51,203	8s296ms	0ms
	16	45,654	8s78ms	0ms
	17	40,105	7s393ms	0ms
	18	26,992	5s43ms	0ms
	19	20,417	3s849ms	0ms
	20	20,442	3s568ms	0ms
	21	14,894	3s36ms	0ms
	22	8,735	1s896ms	0ms

COMMIT;

Date: 2025-01-27 10:51:05 Duration: 42ms
COMMIT;

Date: 2025-01-27 11:24:25 Duration: 41ms
COMMIT;

Date: 2025-01-27 15:58:42 Duration: 40ms

8

514,781

Details

35s810ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 27	00	6,229	365ms	0ms
	01	3,842	224ms	0ms
	02	3,296	192ms	0ms
	03	2,318	137ms	0ms
	04	1,768	111ms	0ms
	05	1,572	98ms	0ms
	06	5,874	295ms	0ms
	07	3,799	188ms	0ms
	08	11,523	656ms	0ms
	09	31,414	2s45ms	0ms
	10	49,833	4s1ms	0ms
	11	61,935	4s490ms	0ms
	12	56,711	4s26ms	0ms
	13	46,907	3s304ms	0ms
	14	44,442	3s417ms	0ms
	15	40,836	2s643ms	0ms
	16	35,414	2s381ms	0ms
	17	31,585	2s337ms	0ms
	18	23,092	1s561ms	0ms
	19	17,012	1s149ms	0ms
	20	17,269	1s18ms	0ms
	21	11,330	724ms	0ms
	22	6,780	438ms	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 (9);

Date: 2025-01-27 15:10:44 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 (77, 30, 7, 71, 24, 19, 13, 70, 65, 119, 126, 17, 29, 10, 27, 127, 128, 32, 28, 35, 26, 49, 102, 36, 52, 61, 123, 9, 11, 113, 121, 64, 39, 60, 42, 2, 76, 22, 8, 14, 110, 78, 79, 48, 4, 41, 38, 16, 51, 5, 66, 3, 44, 6, 95, 115);

Date: 2025-01-27 12:03:24 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 (3, 10, 48, 30, 2);

Date: 2025-01-27 12:21:58 Duration: 0ms

9

509,293

Details

1m9s

0ms

5ms

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
Jan 27	00	8,357	984ms	0ms
	01	5,053	550ms	0ms
	02	4,427	474ms	0ms
	03	3,261	335ms	0ms
	04	2,435	268ms	0ms
	05	1,690	207ms	0ms
	06	6,111	792ms	0ms
	07	2,921	340ms	0ms
	08	10,564	1s302ms	0ms
	09	33,248	4s151ms	0ms
	10	50,053	7s725ms	0ms
	11	62,993	9s860ms	0ms
	12	54,133	7s403ms	0ms
	13	43,500	6s152ms	0ms
	14	41,103	6s244ms	0ms
	15	38,017	4s719ms	0ms
	16	34,131	4s541ms	0ms
	17	30,330	4s247ms	0ms
	18	23,698	2s612ms	0ms
	19	17,885	2s61ms	0ms
	20	16,885	1s911ms	0ms
	21	10,935	1s289ms	0ms
	22	7,563	929ms	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 (5099045, 5105759, 5099138, 5139190, 5103253, 5359622, 5112348, 5391935, 5102342, 5099009, 5099719, 5103721, 5101209, 5099007, 5281361, 5099008, 5099441, 5103701, 5492159, 5099206, 5099295, 5101865, 5099504, 5099010, 5103145, 5198278, 5365876, 5237422, 5102774, 5099121, 5099134, 5099264, 5099013, 5492777, 5104872, 5099224, 5102433, 5125655, 5099529, 5491996, 5099815, 5116698, 5099177, 5101379, 5100282, 5099644, 5146436, 5217345, 5099904, 5190252, 5101816, 5099120, 5185259, 5100919, 5117249, 5100181, 5099403, 5100111, 5104782, 5108122, 5099547, 5102054);

Date: 2025-01-27 17:21:54 Duration: 5ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099119, 5118326, 5153695, 5101122, 5099009, 5100624, 5099095, 5100564, 5294804, 5483258, 5104816, 5123711, 5490487, 5486092, 5099008, 5128224, 5157914, 5131940, 5100181, 5100220, 5145085, 5099636, 5122294, 5102552, 5490939, 5174948, 5100850, 5099007, 5404346, 5101408, 5100457, 5099321, 5099254, 5099010, 5101367, 5100070, 5105798, 5099159, 5114896, 5276675, 5490478, 5488866, 5099248, 5487608, 5488860, 5488879, 5104239, 5104537, 5099929, 5099727, 5099360, 5351328, 5328574, 5111448, 5251303, 5107347, 5099515, 5110521, 5103927, 5443484, 5145166, 5115653, 5109869, 5099224, 5104641, 5103598, 5099223, 5144803, 5099028, 5099867, 5099206, 5099758, 5103662, 5118372, 5101687, 5099204, 5105969, 5123408, 5099491, 5131078, 5102286, 5309761, 5177609, 5099243, 5485687, 5099642, 5486069, 5488609, 5099499, 5488599, 5099190, 5103217, 5116071, 5120980, 5180903, 5100542, 5101246, 5100111, 5399862, 5133230, 5100902, 5102148, 5118754, 5391607, 5114429, 5113856, 5099013, 5131378, 5486095, 5489924, 5099714, 5279063, 5099170, 5303934, 5171606, 5100204, 5099148, 5106994, 5099186, 5126252, 5099722, 5099014, 5100443, 5099413, 5128043, 5111118, 5106757, 5477205, 5486075, 5486089, 5099334, 5116472, 5483358, 5486087, 5099244, 5099011, 5104295, 5134295, 5488402, 5401348, 5483360, 5103936, 5099035, 5102288, 5482473, 5102221, 5488886, 5485057, 5488400, 5099815, 5099144, 5110922, 5244124, 5347479, 5106910, 5099158, 5487617, 5120118, 5102815, 5099138, 5099282, 5100725, 5209579, 5099037, 5391377, 5149282, 5099309, 5100628, 5099103, 5099027, 5099333, 5110560, 5107073);

Date: 2025-01-27 17:21:56 Duration: 4ms
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 (5107075, 5125662, 5099135, 5099389, 5099387, 5099296, 5099141, 5130162, 5100883, 5100062, 5189375, 5100322, 5099244, 5104047, 5100700, 5103766, 5100927, 5099117, 5099130, 5099623, 5241490, 5099295, 5491774, 5099441, 5474942, 5102079, 5104045, 5099643, 5099202, 5407184, 5100428, 5167676, 5099284, 5176801, 5100514, 5130136, 5103025, 5100296, 5099170, 5099090, 5125804, 5099504, 5105152, 5490796, 5103721, 5099194, 5102890, 5098972, 5116446, 5100302, 5126243, 5124563, 5101068, 5106772, 5108181, 5106516, 5133525, 5099727, 5100212, 5101185, 5100791, 5100386, 5099186, 5198148, 5100762, 5127411, 5099315, 5433513, 5100726, 5102367, 5116904, 5106286, 5453274, 5100067, 5099420, 5102390, 5099564, 5099364, 5099243, 5167573, 5100638, 5099442, 5206885, 5099720, 5107494, 5427376, 5100273, 5110518, 5104167, 5099282, 5102094, 5099254, 5106388, 5105206, 5100163, 5099039, 5099391);

Date: 2025-01-27 17:21:56 Duration: 3ms

10

380,146

Details

2m5s

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
Jan 27	00	3,286	980ms	0ms
	01	2,018	616ms	0ms
	02	1,801	563ms	0ms
	03	1,269	402ms	0ms
	04	635	201ms	0ms
	05	511	152ms	0ms
	06	1,386	428ms	0ms
	07	1,509	435ms	0ms
	08	8,771	2s633ms	0ms
	09	17,126	5s534ms	0ms
	10	37,215	13s560ms	0ms
	11	37,960	12s512ms	0ms
	12	39,701	13s170ms	0ms
	13	38,288	12s489ms	0ms
	14	40,634	13s916ms	0ms
	15	29,205	9s319ms	0ms
	16	32,696	10s809ms	0ms
	17	30,595	10s508ms	0ms
	18	18,057	5s817ms	0ms
	19	14,042	4s289ms	0ms
	20	11,593	3s485ms	0ms
	21	7,760	2s373ms	0ms
	22	4,088	1s255ms	0ms

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

Date: 2025-01-27 14:48:35 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 934) OR r.global) ORDER BY r.id;

Date: 2025-01-27 10:52:19 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1255) OR r.global) ORDER BY r.id;

Date: 2025-01-27 18:24:13 Duration: 3ms

11

357,607

Details

1m9s

0ms

11ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 27	00	4,421	722ms	0ms
	01	2,594	474ms	0ms
	02	2,255	422ms	0ms
	03	1,731	325ms	0ms
	04	1,318	255ms	0ms
	05	1,132	163ms	0ms
	06	3,233	533ms	0ms
	07	2,861	421ms	0ms
	08	8,496	1s372ms	0ms
	09	24,761	4s281ms	0ms
	10	34,248	7s471ms	0ms
	11	41,650	8s494ms	0ms
	12	37,244	7s244ms	0ms
	13	34,218	6s438ms	0ms
	14	31,920	6s397ms	0ms
	15	29,472	5s316ms	0ms
	16	26,335	5s125ms	0ms
	17	21,005	4s489ms	0ms
	18	15,047	2s840ms	0ms
	19	10,928	2s83ms	0ms
	20	10,290	1s890ms	0ms
	21	7,668	1s437ms	0ms
	22	4,780	858ms	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 (8006294);

Date: 2025-01-27 17:21:54 Duration: 11ms
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 (8006403);

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

Date: 2025-01-27 17:21:54 Duration: 10ms

12

292,452

Details

54s135ms

0ms

15ms

0ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 27	00	3,323	482ms	0ms
	01	1,846	258ms	0ms
	02	1,993	266ms	0ms
	03	1,894	237ms	0ms
	04	1,035	129ms	0ms
	05	662	86ms	0ms
	06	1,063	153ms	0ms
	07	1,704	234ms	0ms
	08	9,172	1s357ms	0ms
	09	15,589	2s522ms	0ms
	10	27,681	6s22ms	0ms
	11	27,663	5s204ms	0ms
	12	29,049	5s582ms	0ms
	13	28,187	5s297ms	0ms
	14	28,173	5s723ms	0ms
	15	21,799	3s756ms	0ms
	16	25,902	4s914ms	0ms
	17	23,333	4s738ms	0ms
	18	12,398	2s225ms	0ms
	19	11,379	1s923ms	0ms
	20	8,672	1s424ms	0ms
	21	5,704	941ms	0ms
	22	4,231	648ms	0ms

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

Date: 2025-01-27 14:44:32 Duration: 15ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-27 13:33:31 Duration: 4ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2025-01-27 17:31:23 Duration: 2ms

13

239,113

Details

1d16h6m7s

493ms

5s95ms

603ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 27	00	5,998	54m48s	548ms
	01	6,599	59m15s	538ms
	02	7,069	1h3m26s	538ms
	03	5,932	53m28s	540ms
	04	4,544	41m19s	545ms
	05	1,583	14m22s	544ms
	06	4,806	42m26s	529ms
	07	1,936	17m3s	528ms
	08	5,443	48m55s	539ms
	09	10,697	1h40m10s	561ms
	10	19,595	3h31m56s	648ms
	11	14,614	2h30m39s	618ms
	12	15,158	2h30m11s	594ms
	13	13,361	2h10m57s	588ms
	14	13,464	2h22m32s	635ms
	15	10,604	1h43m17s	584ms
	16	16,904	2h53m5s	614ms
	17	16,841	3h5m9s	659ms
	18	15,708	2h47m13s	638ms
	19	15,086	2h38m3s	628ms
	20	10,091	1h44m2s	618ms
	21	12,598	2h6m45s	603ms
	22	10,482	1h46m56s	612ms

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

Date: 2025-01-27 17:48:32 Duration: 5s95ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819047)) AND (("shipping_track"."id" not in (39947186, 39947186)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:51 Duration: 5s29ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819045)) AND (("shipping_track"."id" not in (39947180, 39947180)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:50 Duration: 4s766ms

14

235,156

Details

1m

0ms

20ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 27	00	3,576	833ms	0ms
	01	2,100	511ms	0ms
	02	1,864	474ms	0ms
	03	1,504	369ms	0ms
	04	1,276	593ms	0ms
	05	802	227ms	0ms
	06	2,219	673ms	0ms
	07	1,267	320ms	0ms
	08	4,399	1s103ms	0ms
	09	13,155	3s173ms	0ms
	10	20,556	6s14ms	0ms
	11	26,374	7s601ms	0ms
	12	24,257	6s36ms	0ms
	13	19,930	6s91ms	0ms
	14	19,066	5s56ms	0ms
	15	17,379	3s812ms	0ms
	16	16,401	3s944ms	0ms
	17	15,287	4s33ms	0ms
	18	13,333	2s923ms	0ms
	19	9,888	2s424ms	0ms
	20	9,087	2s76ms	0ms
	21	6,763	1s546ms	0ms
	22	4,673	1s131ms	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 (42078283, 32296180, 32212211, 42125150, 32291410, 32205351, 32221281, 32203070, 32324603, 32254930, 32254672, 41793567, 32200108, 32208404, 32200113, 32324040, 42070391, 32283157, 32294977, 41918885, 42054724, 42070386, 42080384, 32196395, 32293870, 41703561, 32280615, 32196392, 32246776, 32220741, 32280098, 32280809, 32296169, 41523234, 32236053, 32185049, 32234195, 42130917, 32239503, 42153184, 32182082, 32182081, 42070383, 32318748, 32299680, 32653664, 42069911, 32291412, 32256400, 32311056, 32320495, 32320319, 32272030, 32298320, 32237671, 42057482, 32283055, 32239460, 32306639, 32206051, 32295008, 32265237, 32210645, 42173402, 42093432, 42074571, 32222571, 32201029, 32261915, 42106269, 32263492, 32313313, 42172949, 41870934, 42074385, 32284759, 40959328, 41526749, 42072533, 42140531, 32279228, 42047336, 32206281, 41763932);

Date: 2025-01-27 17:21:54 Duration: 20ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (42160710, 32331816, 32331719, 32331811, 32331715, 32331745, 42085620, 42085039, 32332392, 32331810, 42160709, 32331795, 32331713, 32331721, 32331717, 42084818, 32331718, 32331806, 42084813, 32331801, 42084817, 42084815, 42084814, 32331796, 32331802, 32331807);

Date: 2025-01-27 17:21:54 Duration: 11ms
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (41911585, 41911584, 41911586, 42163462, 42146437, 42146452, 42146453, 42146451, 42146449, 42146450, 42146448, 42146446, 42146445, 42146444, 42146443, 42146447, 42146454, 42146503, 42146436, 42146435, 42146434, 42146430, 42146428, 42146429, 42146502, 42146501, 42146427, 42146426, 42146500, 42146499, 42146498, 42146497, 42146425, 42146492, 42146340, 42146339, 42146341, 42146321, 42146493, 42146494, 42146322, 42146495, 42146496, 42146323, 42146416, 42146423, 42146424, 42146417, 42146420, 42146421, 42146415, 42146419, 42146418, 42146414, 42146413, 42146422, 42146504, 32240608, 32239606, 38744812, 32206141, 32242785, 32254643, 32294181, 32293763, 32208457, 32294114, 32341661, 32242763, 32255529, 41843111, 32206286, 32208455, 32294124, 32294129, 32255535, 32294208, 32206319, 42153684, 42171415, 32294214, 32293944, 32294204, 32294121, 32208456, 32293912, 32293945, 41798368, 41843137, 32343743, 42089639, 42089611, 42089629, 42089623, 42089631, 42088326, 41932044, 41890170, 42042780, 40941581, 42089355, 32279231, 42089635, 42089637, 42089626, 42088277, 42089258, 42089616, 42175029, 42026620, 32279223, 32279241, 32279225, 41932049, 42042789, 42088317, 42088321, 42175561, 32279236, 32279216, 41575538, 41710865, 32339649, 42113585, 42089350, 32220910, 42175165, 42088537, 42089351, 42089260, 42089261, 42089342, 32279238, 32279214, 41932050, 41932057, 42042776, 42174998, 42089627, 42089625, 32248842, 41298144, 42175042, 42089602, 32270151, 32221008, 42049278, 32262770, 42002126, 32306413, 32275023, 32179593, 32179594, 41891869, 32273043, 32199612, 32272033, 32199615, 32272413, 32306922, 32306921, 32293946, 32206449, 32206320, 32210720, 32293910, 32294127, 32206285, 32294224, 32208404, 32221047, 42088900, 42089622, 42049289, 42089610, 42089262, 42089265, 42089264, 41890180, 32273047, 42042783, 32273051, 32199614, 32199611, 32221004, 32197431, 32266098, 42026289, 32237628, 42088534, 42175160, 41925691, 42042785, 32279212, 41932053, 42088279, 41615337, 42175158, 42042786, 32208405, 42042773, 42174677, 42042774, 41890174, 42042788, 41932052, 32206447, 41615338, 32206450, 42175575, 42042781, 32293943, 42088320, 42089613, 42175331, 42089620, 42089628, 41932043, 42088870, 42088328, 42089263, 42089257, 42089259, 42175032, 42089343, 42089352, 42026617, 42026618, 32294207, 32237634, 32237617, 41843439, 41843438, 42169696, 32353643, 32339650, 41848296, 42042784, 41932055, 41615340, 42175161, 42175200, 32279218, 41928318, 41932059, 41932054, 42175159, 42088538, 42175569, 42042779, 42088327, 42026379, 42088536, 32279224, 32279228, 42089266, 32189240, 42089619, 42034155, 42089633, 42026619, 42049281, 32279237, 32279213, 32279221, 42089601, 32339651, 42026622, 42026625, 38745447, 32294142, 32294143, 38745446, 32293767, 32254760, 32294095, 32206451, 32206322, 32294094, 32206453, 32294147, 41910054, 32294221, 32294119, 32294123, 32294173, 32220662, 32305842, 32306412, 32221010, 32306919, 32221191, 32221378, 32221048, 42038272, 32343659, 32353666, 32236695, 32353646, 32264799, 32236693, 32237621, 32236698, 32236700, 32353667, 32353665, 32299143, 42140529, 32236711, 32353645, 32237414, 32237638, 32353642, 32237630, 32237620, 42140531, 32237625, 32237632, 32236692, 32237622, 32237641, 32237639, 32237504, 32237624, 32237618, 32236712, 32236709, 32287934, 32304130, 32287688, 32269513, 42071457, 42071476, 32304114, 32287958, 32269538, 32304140, 32288008, 32277366, 32304123, 32287689, 32304139, 42021613, 32654098, 32654099, 32207530, 32206871, 32304510, 42072026, 32304127, 32300221, 32319393, 32269555, 32654137, 32654122, 42084147, 32187760, 32225449, 32276845, 32248797, 32217167, 41427529, 32318896, 42063458, 32299707, 32276747, 32287733, 42063298, 42178017, 32304108, 32304300, 32304135, 32287741, 32287931, 32269556, 32249201, 32287739, 42033834, 32299702, 42168773, 42169450, 32225211, 32287715, 32217214, 42169016, 32300249, 32179548, 32300245, 32653661, 42063255, 32290082, 42168798, 42063300, 42107249, 42107246, 32287992, 32304129, 32207493, 42072333, 32287713, 32289506, 42169060, 32225414, 32207041, 42063456, 32206666, 32290008, 32206801, 42071886, 32318962, 42083976, 42084441, 32207101, 41427532, 32654107, 32654094, 32318844, 32187771, 32225245, 32269499, 32304497, 32655124, 32178728, 32654136, 32187766, 42083984, 42083983, 32653682, 32318848, 41973016, 32207102, 32654203, 41703549, 32300250, 41681307, 42071885, 42143236, 41561188, 32290075, 32290011, 32304541, 32304122, 32653662, 41751845, 42169010, 32653663, 32290016, 41887265, 41416191, 42009192, 42169050, 32187769, 32248745, 42169446, 32289493, 32304513, 32287963, 32304137, 42071883, 32207179, 32277365, 39485132, 32304501, 32287718, 32287954, 32287703, 32269493, 32287691, 32304294, 32330056, 32207121, 42153399, 32299712, 42153055, 32288050, 41562540, 32304520, 32304343, 41562533, 32269521, 32269548, 42169445, 32319142, 42072257, 32318852, 42072027, 32300224, 32290081, 32299711, 32290078, 41703556, 32300256, 32225419, 32289079, 42169121, 32287974, 32304332, 32653677, 32248989, 32207079, 32207202, 32300257, 42063580, 32288001, 32287998, 42168724, 32287993, 32225204, 40920184, 41731649, 42072537, 42143323, 32654140, 42169012, 32188518, 32654208, 32300258, 42143116, 41561184, 32187944, 32187773, 41203211, 32654126, 32304326, 41331717, 32289941, 32207259, 42071815, 32653673, 32276967, 41792286, 32290015, 42063457, 32654205, 32654131, 41623710, 32304125, 32207290, 42169011, 32300248, 32304509, 32207533, 42072332, 32304124, 42152788, 32318743, 32304115, 32287902, 32304106, 32287964, 32304532, 32290350, 32287936, 32304512, 42153053, 32654243, 42143235, 32225206, 41752386, 32187942, 41751776, 32654139, 32318742, 32187761, 41929558, 42072029, 32653654, 42083985, 32289936, 32653679, 41711399, 41427530, 32187759, 32654121, 41752390, 41752389, 32276730, 41752387, 42078729, 41711394, 32304315, 32269550, 32289071, 32304132, 32287717, 32207531, 32269528, 32304104, 32269535, 32304539, 32287926, 32269495, 32269496, 32269497, 42078739, 42107244, 32654113, 32319458, 42178568, 42083755, 32188515, 42107250, 42168708, 32207080, 41703547, 42063459, 32248798, 32287976, 41416190, 42168861, 41331718, 32207098, 32290401, 41929560, 42063573, 32248746, 32300242, 42168735, 32300223, 32654108, 42063455, 32269526, 32269522, 32217400, 32269537, 32216668, 32269544, 32287943, 42084439, 32217212, 32287980, 32304316, 32304305, 32304317, 32265142, 32304493, 32289075, 32225200, 32207205, 41804291, 32654200, 42083991, 42063301, 32269557, 42153394, 42153401, 32300175, 32287923, 32287924, 32269516, 41711396, 42078731, 42078730, 32287692, 32287969, 32329897, 32287737, 42078732, 32300262, 32207582, 42063257, 32304511, 32329899, 32304297, 32304141, 42107243, 42033908, 42033910, 32304097, 32287706, 32304342, 32304344, 32188533, 32276844, 32654119, 32287932, 32653655, 32653680, 32653649, 32207519, 32653657, 32249546, 32217205, 32288042, 32289069, 32288044, 42168706, 32225203, 32318899, 32269523, 42168701, 32299709, 32287978, 32207099, 42072534, 32653651, 42143221, 32225417, 32248987, 42063569, 42168862, 42083987, 42071721, 41703550, 32207147, 32287738, 32207081, 32304325, 32319427, 32207180, 32329658, 42168827, 32329655, 32300253, 32289502, 32655127, 32277419, 42169443, 32300261, 32304518, 32304333, 32287986, 32269565, 32287720, 32269559, 32207529, 32289498, 32287957, 32248988, 32304112, 32287698, 32269515, 32304102, 32269525, 32269498, 32287938, 32287686, 32287712, 32289505, 32287965, 32287728, 32290077, 32269514, 32304503, 32287991, 32187653, 32329660, 32653669, 32207140, 32653688, 32304295, 32653681, 32287996, 32225208, 32287935, 32287727, 41804536, 32225412, 32304331, 32653647, 32304322, 32289504, 32304096, 32217249, 32304094, 32654141, 32304138, 32304514, 41427528, 32654206, 41508640, 42178570, 32304318, 32269252, 41427537, 41427536, 42072035, 32304099, 32290013, 32188405, 41427535, 32653674, 41561186, 32276745, 41703560, 32654135, 32187946, 32654210, 41427534, 32289076, 32287929, 42078735, 32207085, 32304502, 32225448, 32304133, 32318842, 32304529, 42178569, 32330195, 32276963, 32329902, 42169013, 42063570, 42169247, 32269554, 32654117, 32329898, 41427525, 42166087, 41427531, 32207106, 32287921, 41561179, 32289938, 42169015, 32300254, 42165927, 32329901, 32329904, 32287945, 32225202, 41561180, 32304517, 32304516, 32269564, 42153057, 42072336, 32287918, 32299698, 32269541, 32287920, 32329903, 32287961, 42169055, 32287925, 41479441, 32269536, 32304119, 32287705, 32287946, 42009195, 32300226, 42083982, 41647744, 32289495, 32225451, 32290076, 32290079, 32290014, 32188517, 32187763, 32299697, 32299699, 32304524, 32287955, 32207083, 32287930, 32287953, 32300225, 32304293, 32287988, 32207078, 32287999, 32653683, 32276958, 32654132, 32653676, 32217242, 32225421, 32304525, 32304526, 32206698, 32319432, 41929555, 32287710, 32304100, 32289074, 32318749, 32654101, 42071814, 42169123, 32300246, 32206700, 42107204, 42034521, 32653672, 41928448, 32269520, 42063256, 32289503, 32225212, 32299716, 41803714, 32287982, 32287721, 42155212, 42153682, 42153675, 42073977, 42154607, 42031104, 42031103, 42154098, 42154400, 42154108, 42155213, 41763328, 32249543, 41902469, 42071470, 42071493, 42071291, 41943641, 32654214, 41751773, 32304302, 42143321, 32653659, 32300240, 32287994, 32304299, 32225201, 42107356, 32269547, 32304101, 32269561, 32653646, 32287693, 32287987, 32269503, 32269510, 32269511, 32287719, 32304329, 32289960, 32319132, 32287973, 32216670, 32654123, 32299714, 42072354, 41562536, 32278992, 32300537, 32287950, 32654104, 32248742, 32655126, 41502178, 42169444, 32304328, 32279301, 32653675, 32290073, 32289940, 41427541, 32318963, 32318845, 41990087, 42168734, 32654103, 32206669, 41623902, 32319433, 41561189, 32300216, 32654114, 32300255, 32300252, 32300217, 32653658, 42078736, 32225420, 42072535, 32300220);

Date: 2025-01-27 10:20:29 Duration: 8ms

15

175,079

Details

14s894ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 27	00	2,561	210ms	0ms
	01	1,526	132ms	0ms
	02	1,327	126ms	0ms
	03	888	84ms	0ms
	04	721	71ms	0ms
	05	478	34ms	0ms
	06	2,151	167ms	0ms
	07	1,038	83ms	0ms
	08	3,585	322ms	0ms
	09	11,731	1s158ms	0ms
	10	17,882	1s351ms	0ms
	11	23,578	1s680ms	0ms
	12	19,749	1s625ms	0ms
	13	15,699	1s442ms	0ms
	14	14,982	1s593ms	0ms
	15	13,696	1s91ms	0ms
	16	11,963	893ms	0ms
	17	9,886	919ms	0ms
	18	7,056	613ms	0ms
	19	4,885	506ms	0ms
	20	4,831	406ms	0ms
	21	3,037	235ms	0ms
	22	1,829	141ms	0ms

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

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

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

Date: 2025-01-27 13:39:47 Duration: 1ms

16

173,762

Details

1m33s

0ms

31ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 27	00	574	394ms	0ms
	01	232	135ms	0ms
	02	314	163ms	0ms
	03	194	109ms	0ms
	04	187	100ms	0ms
	05	66	32ms	0ms
	06	427	185ms	0ms
	07	583	211ms	0ms
	08	2,101	1s19ms	0ms
	09	6,721	3s402ms	0ms
	10	11,496	7s706ms	0ms
	11	10,537	6s204ms	0ms
	12	11,705	7s182ms	0ms
	13	13,894	8s522ms	0ms
	14	13,588	8s594ms	0ms
	15	13,243	6s972ms	0ms
	16	22,528	11s500ms	0ms
	17	17,593	9s861ms	0ms
	18	8,207	4s61ms	0ms
	19	9,923	4s755ms	0ms
	20	6,703	3s252ms	0ms
	21	14,273	5s827ms	0ms
	22	8,673	3s132ms	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 (4775428, 4817911, 4813686, 4776647, 4703765, 4638630, 4586991, 4746008, 4734586, 4746022, 4787820, 4775533, 4752297, 4775726, 4701019, 4807401, 4713815, 4760821, 4776923, 4765346, 4762768, 4735770, 4782037, 4788368, 4775021, 4774745, 4766362, 4545666, 4703812, 4807580, 4787806, 4751877, 4419465, 4776578, 4787826, 4775472, 4787821, 4733078, 4787796, 4776662, 4775485, 4751828, 4776642, 4787818, 4775544, 4765366, 4758031, 4773279, 4760156, 4649595, 4760479, 4775402, 4677989, 4776904, 4776682, 4751846, 4788338, 4638716, 4787799, 4695513, 4746037, 4792401, 4763270, 4764624, 4776968, 4562629, 4774471, 4777162, 4775489, 4776644, 4776659, 4776594, 4775772, 4777298, 4760193, 4792393, 4786075, 4764201, 4720956, 4769025, 4777049, 4771577, 4769296, 4775479, 4775547, 4775463, 4638665, 4638810, 4776652, 4775465, 4787813, 4776575, 4701127, 4792341, 4776614, 4776622, 4701128, 4775432, 4734728, 4776649, 4775494, 4787803, 4776640, 4797748, 4787802, 4671320, 4695780, 4775529, 4695571, 4671369, 4733071, 4775441, 4701066, 4734739, 4733127, 4776687, 4775481, 4732971, 4746006, 4787816, 4776598, 4732986, 4751865, 4776620, 4732846, 4751878, 4763581, 4701124, 4733101, 4734647, 4701057, 4695549, 4695563, 4683625, 4671513, 4687599, 4694514, 4733986, 4634359, 4666594, 4693430, 4720976, 4720412, 4713686, 4711867, 4705709, 4702990, 4698990, 4701739, 4689376, 4688154, 4703420, 4730660, 4721864, 4699662, 4755841, 4752715, 4681847, 4752314, 4752324, 4665547, 4751108, 4730662, 4726356, 4742648, 4742593, 4672339, 4737485, 4736015, 4733457, 4732892, 4731440, 4731532, 4730638, 4722966, 4727564, 4726753, 4649704, 4724433, 4724872, 4723784, 4681839, 4670696, 4732019, 4717073, 4693364, 4684169, 4684162, 4735488, 4726601, 4602063, 4737502, 4694540, 4690137, 4671068, 4747027, 4733972, 4689026);

Date: 2025-01-27 17:21:56 Duration: 31ms
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 (4333902, 4595208, 4714130, 4492874, 4423148, 4597110, 4679197, 4525433, 4715460, 4742524, 4544849, 4742868, 4682241, 4494282, 4548752, 4621450, 4595072, 4423159, 4424089, 4422615, 4553128, 3953860, 4594986, 4486508, 4448225, 4714630, 4523501, 4595036, 4760297, 4492819, 3852100, 4525453, 4548307, 4451495, 4649639, 4649635, 4424099, 4553215, 4682754, 4448194, 4523419, 4681383, 4402128, 4786501, 4424360, 4361976, 4425847, 4710495, 4420933, 4448180, 4620054, 4597308, 4452291, 4452648, 4587711, 4174344, 4244562, 4221396, 4743570, 4715658, 4645932, 4622018, 4488603, 4451569, 4451357, 4297682, 4424377, 4714067, 4246142, 4488941, 4402010, 4682563, 4525502, 4450412, 4621438, 4551783, 4361782, 4621530, 4402007, 4587708, 4597494, 4744626, 4621893, 4742445, 4424457, 4707414, 4622295, 4554407, 4424295);

Date: 2025-01-27 14:05:44 Duration: 22ms
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 (4747106, 4727960, 4662293, 4795468, 4760933, 4721001, 4748621, 4747086, 4772623, 4598672, 4605023, 4694956, 4772628, 4763027, 4662324, 4727843, 4772590, 4772632, 4769262, 4698277, 4760334, 4727855, 4748646, 4762992, 4763005, 4772579, 4763012, 4285862, 4747100, 4746553, 4750410, 4760333, 4662211, 4760936, 4750415, 4760338, 4636310, 4769236, 4772642, 4747088, 4769212, 4746555, 4763007, 4727808, 4748625, 4698196, 4727797, 4727859, 4727962, 4722436, 4730718, 4736570, 4760126, 4766347, 4773060, 4775084, 4775717, 4777908, 4788427, 4699548, 4569879, 4502983, 4772634, 4763650, 4760927, 4769252, 4727815, 4727840, 4750412, 4720982, 4694994, 4746557, 4750405, 4750414, 4662247, 4717668, 4727949, 4747097, 4686435, 4555309, 4727866, 4727922, 4746558, 4727901, 4740291, 4694945, 4698302, 4721002, 4748644, 4721003, 4413957, 4609486, 4502969, 4744596, 4655127, 4747090, 4747092, 4750411, 4721004, 4386705, 4727852, 4720980, 4747094, 4720981, 4578583, 4717665, 4727863, 4754373, 4683617, 4746563, 4735707, 4662311, 4717670, 4686416, 4350735, 4727838, 4750417, 4727874, 4605047, 4627732, 4727841, 4662351, 4750407, 4687505, 4699213, 4730056, 4733361, 4727879, 4662353, 4358180, 4730867, 4286827, 4617855, 4760275, 4689682, 4721604, 4721636, 4730482, 4731845, 4698251, 4665256, 4468085, 4662239, 4662313, 4687950, 4728829, 4605032, 4599930, 4662305, 4741246, 4700484, 4727912, 4698304, 4717663, 4404237, 4599933, 4727906, 4744253, 4727953, 4337727, 4578520, 4698248, 4430552, 4727909, 4636291, 4717659, 4680274, 4708508, 4684853, 4698261, 4686420, 4605044, 4578621, 4694978, 4686413, 4698260, 4665226, 4261057, 4697783, 4655892, 4697925, 4724045, 4732390, 4738181, 4739979, 4717644, 4655128, 4664237, 4680321, 4702008, 4719614, 4722224, 4726536, 4727490, 4728330, 4694984);

Date: 2025-01-27 17:21:56 Duration: 20ms

17

164,435

Details

9s980ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 27	00	1,524	78ms	0ms
	01	855	43ms	0ms
	02	682	34ms	0ms
	03	518	25ms	0ms
	04	247	11ms	0ms
	05	219	11ms	0ms
	06	557	30ms	0ms
	07	636	32ms	0ms
	08	3,845	202ms	0ms
	09	7,324	418ms	0ms
	10	15,833	1s109ms	0ms
	11	16,031	977ms	0ms
	12	17,489	1s81ms	0ms
	13	16,541	1s3ms	0ms
	14	17,461	1s110ms	0ms
	15	12,328	699ms	0ms
	16	14,354	870ms	0ms
	17	13,525	874ms	0ms
	18	7,590	442ms	0ms
	19	6,156	343ms	0ms
	20	5,286	285ms	0ms
	21	3,632	195ms	0ms
	22	1,802	97ms	0ms

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

Date: 2025-01-27 17:32:07 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 (2, 10);

Date: 2025-01-27 17:25:52 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 (21);

Date: 2025-01-27 12:18:12 Duration: 0ms

18

157,211

Details

20s540ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 27	00	1,444	159ms	0ms
	01	852	91ms	0ms
	02	661	71ms	0ms
	03	496	53ms	0ms
	04	238	24ms	0ms
	05	210	22ms	0ms
	06	542	62ms	0ms
	07	600	65ms	0ms
	08	3,760	423ms	0ms
	09	6,949	856ms	0ms
	10	15,380	2s356ms	0ms
	11	15,322	1s988ms	0ms
	12	16,640	2s209ms	0ms
	13	15,770	2s47ms	0ms
	14	16,783	2s300ms	0ms
	15	11,736	1s421ms	0ms
	16	13,794	1s795ms	0ms
	17	12,986	1s825ms	0ms
	18	7,141	904ms	0ms
	19	5,737	684ms	0ms
	20	4,927	566ms	0ms
	21	3,491	404ms	0ms
	22	1,752	204ms	0ms

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

Date: 2025-01-27 17:31:50 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-27 14:20:44 Duration: 1ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2025-01-27 12:49:59 Duration: 1ms

19

145,768

Details

8h37m18s

158ms

1s476ms

212ms

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

Day	Hour	Count	Duration	Avg duration
Jan 27	00	755	2m16s	180ms
	01	1,443	4m18s	179ms
	02	3,315	9m56s	180ms
	03	2,459	7m21s	179ms
	04	2,724	8m7s	178ms
	05	368	1m5s	179ms
	06	1,287	3m49s	178ms
	07	663	1m58s	179ms
	08	3,096	9m21s	181ms
	09	8,164	25m48s	189ms
	10	11,109	39m47s	214ms
	11	6,620	22m54s	207ms
	12	7,679	26m4s	203ms
	13	11,330	37m48s	200ms
	14	10,281	37m19s	217ms
	15	12,336	41m28s	201ms
	16	17,240	58m21s	203ms
	17	15,750	1h10m26s	268ms
	18	1,079	4m1s	223ms
	19	8,189	29m55s	219ms
	20	9,105	35m	230ms
	21	10,631	39m34s	223ms
	22	145	30s67ms	207ms

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

Date: 2025-01-27 17:34:35 Duration: 1s476ms
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" = '9891888')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 14:05:54 Duration: 1s458ms
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" = '18486')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 10:55:03 Duration: 1s452ms

20

138,095

Details

1h52m23s

36ms

439ms

48ms

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
Jan 27	00	2,861	2m5s	43ms
	01	2,527	1m50s	43ms
	02	2,366	1m44s	44ms
	03	2,113	1m33s	44ms
	04	1,147	50s862ms	44ms
	05	525	23s263ms	44ms
	06	1,871	1m22s	43ms
	07	1,258	55s458ms	44ms
	08	3,326	2m27s	44ms
	09	7,533	5m46s	46ms
	10	15,014	13m17s	53ms
	11	11,899	9m55s	50ms
	12	11,877	9m33s	48ms
	13	11,377	9m3s	47ms
	14	10,911	9m11s	50ms
	15	8,342	6m34s	47ms
	16	7,948	6m31s	49ms
	17	7,746	6m47s	52ms
	18	6,578	5m26s	49ms
	19	6,390	5m18s	49ms
	20	5,956	4m48s	48ms
	21	4,510	3m39s	48ms
	22	4,020	3m15s	48ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4810136, 4763579, 4763578, 4763577, 4763576, 4763575, 4763574, 4763573)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:53:55 Duration: 439ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4746888, 4734379, 4729519, 4720553, 4717669)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:58:20 Duration: 369ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4767410)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 14:07:02 Duration: 271ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

50m32s

3m5s

65

Details

3h21m16s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 27	00	1	0ms	0ms
	07	1	0ms	0ms
	08	2	0ms	0ms
	09	5	1ms	0ms
	10	9	14m15s	1m35s
	11	5	23m	4m36s
	12	4	5ms	1ms
	13	8	22m24s	2m48s
	14	8	20m16s	2m32s
	15	4	5ms	1ms
	16	8	1h53m9s	14m8s
	17	5	8m11s	1m38s
	18	2	1ms	0ms
	21	1	1ms	1ms
	22	2	1ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-27 15:08:48.739827', "last_update" = '2025-01-27 14:23:48.739850', "write_date" = '2025-01-27 14:23:48.401321', "write_uid" = 1 WHERE id IN (1229);

Date: 2025-01-27 16:14:20 Duration: 50m32s
UPDATE "res_users" SET "exp_date" = '2025-01-27 15:15:06.928239', "last_update" = '2025-01-27 14:30:06.928268', "write_date" = '2025-01-27 14:30:06.582246', "write_uid" = 1 WHERE id IN (965);

Date: 2025-01-27 16:14:20 Duration: 44m13s
UPDATE "res_users" SET "exp_date" = '2025-01-27 10:46:21.339204', "last_update" = '2025-01-27 10:01:21.339235', "write_date" = '2025-01-27 10:01:20.881361', "write_uid" = 1 WHERE id IN (865);

Date: 2025-01-27 11:24:21 Duration: 23m

2

0ms

22m23s

27s138ms

299

Details

2h15m14s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 27	00	6	5ms	0ms
	01	1	0ms	0ms
	02	1	0ms	0ms
	03	2	1ms	0ms
	04	1	0ms	0ms
	06	3	0ms	0ms
	07	2	0ms	0ms
	08	10	1ms	0ms
	09	28	5ms	0ms
	10	30	1h4m17s	2m8s
	11	32	8m57s	16s786ms
	12	24	22ms	0ms
	13	19	25m2s	1m19s
	14	25	33ms	1ms
	15	20	13ms	0ms
	16	18	16m36s	55s348ms
	17	23	37ms	1ms
	18	7	4ms	0ms
	19	16	20m21s	1m16s
	20	11	9ms	0ms
	21	10	6ms	0ms
	22	10	6ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-27 09:41:57.456021', "last_update" = '2025-01-27 08:56:57.456043', "sid" = 'ef2c559c12e6bedc71edfd03e2dcc3f64d5baf72', "write_date" = '2025-01-27 08:56:57.114967', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-27 10:19:21 Duration: 22m23s
UPDATE "res_users" SET "exp_date" = '2025-01-27 09:42:34.327135', "last_update" = '2025-01-27 08:57:34.327163', "sid" = '489394a31eef29149a7ce2204c1c039a44bcd5a2', "write_date" = '2025-01-27 08:57:33.933688', "write_uid" = 1 WHERE id IN (822);

Date: 2025-01-27 10:19:21 Duration: 21m47s
UPDATE "res_users" SET "exp_date" = '2025-01-27 19:13:14.538332', "last_update" = '2025-01-27 18:28:14.538359', "sid" = '278d944b7cb852db143f4e1ac999c9d3993a179b', "write_date" = '2025-01-27 18:28:14.132216', "write_uid" = 869 WHERE id IN (869);

Date: 2025-01-27 19:43:21 Duration: 15m6s

3

0ms

50m13s

3s784ms

64,773

Details

2d20h5m8s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 27	00	983	212ms	0ms
	01	666	141ms	0ms
	02	774	169ms	0ms
	03	740	158ms	0ms
	04	723	151ms	0ms
	05	168	38ms	0ms
	06	516	108ms	0ms
	07	318	67ms	0ms
	08	1,583	336ms	0ms
	09	4,065	905ms	0ms
	10	6,244	10h14m22s	5s903ms
	11	6,574	11h21m33s	6s220ms
	12	6,801	5h5m23s	2s694ms
	13	6,389	9h23m45s	5s294ms
	14	5,611	4h8m28s	2s657ms
	15	5,084	2h33m1s	1s805ms
	16	4,851	9h42m45s	7s207ms
	17	3,858	4h5m51s	3s823ms
	18	2,667	617ms	0ms
	19	2,176	11h11m47s	18s523ms
	20	1,892	3m6s	98ms
	21	1,358	7m36s	336ms
	22	732	7m23s	605ms

update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:24:07.641656', exp_date = '2025-01-27 15:09:07.641660', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-27 16:14:20 Duration: 50m13s
update res_users set sid = '867e2c0dcde450486ade88cd9bf4ff3746621761', last_update = '2025-01-27 14:25:07.291897', exp_date = '2025-01-27 15:10:07.291901', logged_in = 'TRUE' where id = 1229;

Date: 2025-01-27 16:14:20 Duration: 49m13s
update res_users set sid = 'fe8f61d621125dd5e8444d1cb65079e03dbf43cf', last_update = '2025-01-27 18:04:38.853032', exp_date = '2025-01-27 18:49:38.853035', logged_in = 'TRUE' where id = 869;

Date: 2025-01-27 19:43:21 Duration: 38m42s

4

31ms

4s567ms

2s891ms

261

Details

12m34s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 27	08	1	2s860ms	2s860ms
	09	9	29s654ms	3s294ms
	10	6	282ms	47ms
	11	11	15s746ms	1s431ms
	12	14	52s150ms	3s725ms
	13	10	32s905ms	3s290ms
	14	10	36s586ms	3s658ms
	15	20	1m5s	3s288ms
	16	30	1m14s	2s467ms
	17	21	56s360ms	2s683ms
	18	21	1m6s	3s173ms
	19	61	3m21s	3s302ms
	20	13	39s782ms	3s60ms
	21	19	39s755ms	2s92ms
	22	15	40s730ms	2s715ms

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 (13))))))) 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 (13)))))) 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 (13)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) 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 (13))))))))) 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 (13)))))))) AND ("policy_number"."name"::text ilike '%9924913%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 17:32:36 Duration: 4s567ms
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 (2))))))) 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 (2)))))) 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 (2)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2)))))) 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 (2))))))))) 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 (2)))))))) AND ("policy_number"."name"::text ilike '%9683152%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 14:55:45 Duration: 4s315ms
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 (5))))))) 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 (5)))))) 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 (5)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (5)))))) 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 (5))))))))) 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 (5)))))))) AND ("policy_number"."name"::text ilike '%9688735%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-27 13:14:15 Duration: 4s240ms

5

215ms

1s934ms

933ms

13,029

Details

3h22m37s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 27	00	604	8m28s	841ms
	01	86	1m17s	899ms
	02	12	10s679ms	889ms
	10	24	26s45ms	1s85ms
	11	19	20s979ms	1s104ms
	12	41	36s100ms	880ms
	13	120	1m58s	987ms
	14	224	3m24s	914ms
	15	583	9m5s	935ms
	16	502	8m14s	984ms
	17	1,040	18m47s	1s83ms
	18	1,840	28m14s	920ms
	19	2,079	32m16s	931ms
	20	2,753	42m42s	930ms
	21	1,373	20m8s	880ms
	22	1,729	26m25s	916ms

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

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

Date: 2025-01-27 17:31:35 Duration: 1s898ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '112583')) 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 (13))))))) 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 (13)))))) 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 (13)))))) 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 (13))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-27 17:31:46 Duration: 1s889ms

6

495ms

4s432ms

622ms

41,795

Details

7h13m56s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 27	00	148	1m30s	612ms
	01	162	1m41s	626ms
	02	214	2m12s	617ms
	03	167	1m43s	621ms
	04	120	1m14s	622ms
	05	62	38s393ms	619ms
	06	209	1m56s	559ms
	07	528	4m46s	543ms
	08	1,492	13m32s	544ms
	09	2,577	25m8s	585ms
	10	3,905	44m	676ms
	11	4,070	43m16s	637ms
	12	4,131	42m26s	616ms
	13	3,986	40m31s	610ms
	14	4,394	48m	655ms
	15	3,153	31m3s	590ms
	16	3,043	31m49s	627ms
	17	3,130	34m8s	654ms
	18	1,992	20m25s	615ms
	19	1,453	14m59s	618ms
	20	1,458	14m37s	601ms
	21	903	9m5s	603ms
	22	498	5m5s	613ms

SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4785982, 4785675, 4785625, 4785596, 4785586, 4785581, 4782307, 4778579, 4777324, 4775115, 4774865, 4774843, 4773857, 4769050, 4768668, 4768147, 4767963, 4763477, 4762380, 4751880, 4722209, 4677413)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 10:53:55 Duration: 4s432ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4812853, 4730481, 4766502, 4767410, 4811031, 4811036, 4811340, 4812742, 4718372, 4780545, 4783977, 4789388, 4789891, 4790094, 4790166, 4790237, 4790643, 4791969, 4792611, 4794636, 4796245, 4796357, 4796992, 4798278, 4799677, 4799713, 4801015, 4801938, 4801953, 4803049, 4806218, 4806792, 4808143, 4808245, 4809000, 4809920, 4811030)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 14:06:59 Duration: 4s266ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4792246, 4792243, 4792241, 4792239, 4777128, 4774897, 4774889, 4774885, 4774883, 4774866, 4774864, 4774863, 4774838, 4774833, 4774832, 4774831, 4774830, 4774829, 4774053, 4773192, 4773189, 4773184, 4773178, 4773142, 4773121, 4773118, 4773117, 4773091, 4770591, 4770352, 4770315, 4770303, 4769879, 4769830, 4769818, 4769816, 4769815, 4768497, 4768474, 4767054, 4765986, 4765941, 4765907, 4765905, 4765890, 4765886, 4765016, 4765015, 4765013, 4765012, 4765009, 4764835, 4764509, 4763515, 4761775, 4761243)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 14:06:11 Duration: 4s252ms

7

493ms

5s95ms

603ms

239,113

Details

1d16h6m7s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 27	00	5,998	54m48s	548ms
	01	6,599	59m15s	538ms
	02	7,069	1h3m26s	538ms
	03	5,932	53m28s	540ms
	04	4,544	41m19s	545ms
	05	1,583	14m22s	544ms
	06	4,806	42m26s	529ms
	07	1,936	17m3s	528ms
	08	5,443	48m55s	539ms
	09	10,697	1h40m10s	561ms
	10	19,595	3h31m56s	648ms
	11	14,614	2h30m39s	618ms
	12	15,158	2h30m11s	594ms
	13	13,361	2h10m57s	588ms
	14	13,464	2h22m32s	635ms
	15	10,604	1h43m17s	584ms
	16	16,904	2h53m5s	614ms
	17	16,841	3h5m9s	659ms
	18	15,708	2h47m13s	638ms
	19	15,086	2h38m3s	628ms
	20	10,091	1h44m2s	618ms
	21	12,598	2h6m45s	603ms
	22	10,482	1h46m56s	612ms

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

Date: 2025-01-27 17:48:32 Duration: 5s95ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819047)) AND (("shipping_track"."id" not in (39947186, 39947186)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:51 Duration: 5s29ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4819045)) AND (("shipping_track"."id" not in (39947180, 39947180)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-27 17:34:50 Duration: 4s766ms

8

368ms

1s726ms

517ms

1,765

Details

15m13s

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
Jan 27	08	208	1m29s	430ms
	09	473	3m37s	459ms
	10	295	2m38s	538ms
	11	519	4m44s	547ms
	12	158	1m26s	545ms
	14	81	1m	746ms
	15	29	15s625ms	538ms
	16	2	976ms	488ms

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

Date: 2025-01-27 10:57:18 Duration: 1s726ms
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" = '9704280')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-27 14:05:57 Duration: 1s271ms
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" = '9805963')) ORDER BY "cash_policy"."id" DESC;

Date: 2025-01-27 14:07:06 Duration: 891ms

9

206ms

1s701ms

285ms

14,808

Details

1h10m28s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 27	00	379	1m33s	247ms
	01	476	1m55s	241ms
	02	520	2m7s	245ms
	03	607	2m26s	241ms
	04	463	1m55s	250ms
	05	325	1m20s	248ms
	06	14	3s151ms	225ms
	07	18	4s707ms	261ms
	08	117	29s167ms	249ms
	09	3	788ms	262ms
	10	189	56s632ms	299ms
	11	109	31s641ms	290ms
	12	203	56s657ms	279ms
	13	94	25s748ms	273ms
	14	118	33s543ms	284ms
	15	255	1m8s	267ms
	16	1,101	5m8s	280ms
	17	1,841	10m5s	328ms
	18	2,542	12m44s	300ms
	19	2,291	11m4s	290ms
	20	702	3m20s	285ms
	21	1,538	7m12s	280ms
	22	903	4m22s	291ms

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

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

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

Date: 2025-01-27 17:32:12 Duration: 702ms

10

166ms

1s749ms

285ms

31,873

Details

2h31m26s

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

Day	Hour	Count	Duration	Avg duration
Jan 27	08	694	2m52s	249ms
	09	2,254	10m18s	274ms
	10	3,816	18m13s	286ms
	11	4,762	22m29s	283ms
	12	2,839	13m8s	277ms
	13	5,901	27m15s	277ms
	14	5,124	25m50s	302ms
	15	2,998	13m57s	279ms
	16	2,720	13m30s	298ms
	17	765	3m48s	299ms

SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9852641')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:09 Duration: 1s749ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '129011')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:12 Duration: 1s289ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9970949')))) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:15 Duration: 802ms

11

90ms

963ms

244ms

54,958

Details

3h43m49s

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 27	00	1,947	7m13s	222ms
	01	1,105	4m23s	238ms
	02	1,042	3m56s	227ms
	03	1,202	4m31s	226ms
	04	922	3m45s	244ms
	05	644	2m14s	208ms
	06	20	5s699ms	284ms
	07	36	9s349ms	259ms
	08	228	58s612ms	257ms
	09	4	1s97ms	274ms
	10	412	1m35s	230ms
	11	250	1m7s	269ms
	12	482	1m51s	231ms
	13	412	1m48s	262ms
	14	670	2m23s	214ms
	15	1,654	6m13s	225ms
	16	3,142	13m17s	253ms
	17	5,712	27m5s	284ms
	18	8,671	36m30s	252ms
	19	8,645	35m59s	249ms
	20	6,812	26m58s	237ms
	21	5,746	21m51s	228ms
	22	5,200	19m46s	228ms

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

Date: 2025-01-27 18:24:52 Duration: 963ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-27 18:24:52 Duration: 962ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-27 19:53:34 Duration: 914ms

12

158ms

1s476ms

212ms

145,768

Details

8h37m18s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 27	00	755	2m16s	180ms
	01	1,443	4m18s	179ms
	02	3,315	9m56s	180ms
	03	2,459	7m21s	179ms
	04	2,724	8m7s	178ms
	05	368	1m5s	179ms
	06	1,287	3m49s	178ms
	07	663	1m58s	179ms
	08	3,096	9m21s	181ms
	09	8,164	25m48s	189ms
	10	11,109	39m47s	214ms
	11	6,620	22m54s	207ms
	12	7,679	26m4s	203ms
	13	11,330	37m48s	200ms
	14	10,281	37m19s	217ms
	15	12,336	41m28s	201ms
	16	17,240	58m21s	203ms
	17	15,750	1h10m26s	268ms
	18	1,079	4m1s	223ms
	19	8,189	29m55s	219ms
	20	9,105	35m	230ms
	21	10,631	39m34s	223ms
	22	145	30s67ms	207ms

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

Date: 2025-01-27 17:34:35 Duration: 1s476ms
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" = '9891888')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 14:05:54 Duration: 1s458ms
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" = '18486')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-27 10:55:03 Duration: 1s452ms

13

164ms

1s390ms

196ms

13,691

Details

44m56s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Jan 27	00	180	32s265ms	179ms
	02	32	5s695ms	177ms
	03	10	1s833ms	183ms
	06	1,287	3m49s	178ms
	07	663	1m59s	179ms
	08	1,688	5m6s	181ms
	09	1,971	6m6s	186ms
	10	2,329	8m13s	211ms
	11	804	2m50s	211ms
	12	1,009	3m23s	201ms
	13	1,037	3m30s	203ms
	14	802	2m47s	208ms
	15	428	1m27s	203ms
	16	106	21s388ms	201ms
	17	370	1m14s	200ms
	18	279	58s481ms	209ms
	19	267	57s674ms	216ms
	20	165	34s847ms	211ms
	21	215	45s175ms	210ms
	22	49	10s154ms	207ms

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

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

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

Date: 2025-01-27 10:55:11 Duration: 982ms

14

160ms

221ms

180ms

9,381

Details

28m11s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 27	00	575	1m44s	181ms
	01	1,373	4m7s	180ms
	02	2,720	8m13s	181ms
	03	2,271	6m49s	180ms
	04	2,241	6m40s	178ms
	05	201	35s837ms	178ms

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

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

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

Date: 2025-01-27 03:03:04 Duration: 220ms

15

119ms

1s192ms

151ms

6,083

Details

15m18s

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 27	00	5	634ms	126ms
	01	10	1s295ms	129ms
	06	10	1s291ms	129ms
	08	97	12s782ms	131ms
	09	553	1m17s	139ms
	10	1,232	3m24s	165ms
	11	1,130	2m53s	153ms
	12	860	2m6s	147ms
	13	505	1m14s	146ms
	14	682	1m41s	149ms
	15	328	45s35ms	137ms
	16	222	33s379ms	150ms
	17	132	22s698ms	171ms
	18	81	11s198ms	138ms
	19	70	10s9ms	142ms
	20	64	8s911ms	139ms
	21	55	7s559ms	137ms
	22	47	6s626ms	140ms

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

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

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

Date: 2025-01-27 10:55:17 Duration: 936ms

16

95ms

760ms

124ms

18,138

Details

37m31s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 27	01	71	7s426ms	104ms
	07	90	10s431ms	115ms
	08	330	38s14ms	115ms
	09	895	1m48s	121ms
	10	1,594	3m35s	135ms
	11	1,454	3m5s	127ms
	12	2,796	5m43s	122ms
	13	2,378	4m49s	121ms
	14	1,839	3m55s	128ms
	15	1,587	3m11s	120ms
	16	1,568	3m14s	124ms
	17	1,181	2m28s	125ms
	18	940	1m56s	124ms
	19	237	29s746ms	125ms
	20	706	1m20s	114ms
	21	407	47s462ms	116ms
	22	65	7s837ms	120ms

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

Date: 2025-01-27 17:33:16 Duration: 760ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8042272)) AND (("cash_track"."id" not in (7389157, 7392290, 7393230, 7410695, 7410709, 7410709)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-27 14:06:07 Duration: 746ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8042392)) AND (("cash_track"."id" not in (7389730, 7392261, 7393165, 7400229, 7400229)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-27 10:57:24 Duration: 738ms

17

75ms

581ms

116ms

50,939

Details

1h38m48s

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"."state" != ?) or "cash_policy"."state" is null) and ("cash_policy"."policy_name" = ?))) and (((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) and (("cash_policy"."state" not in (...)) or "cash_policy"."state" is null)) order by "cash_policy"."id" desc limit ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 27	00	2	170ms	85ms
	08	9	844ms	93ms
	09	36	3s393ms	94ms
	10	13,617	32m9s	141ms
	11	36,347	1h4m58s	107ms
	12	256	26s	101ms
	13	194	19s837ms	102ms
	14	158	16s947ms	107ms
	15	107	10s334ms	96ms
	16	81	8s452ms	104ms
	17	47	5s712ms	121ms
	18	39	3s747ms	96ms
	19	21	1s993ms	94ms
	20	21	1s897ms	90ms
	21	2	181ms	90ms
	22	2	182ms	91ms

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

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

Date: 2025-01-27 10:58:03 Duration: 578ms
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND ("cash_policy"."policy_name" = '46774'))) AND (((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC LIMIT 200;

Date: 2025-01-27 10:54:56 Duration: 578ms

18

44ms

339ms

59ms

47,991

Details

47m37s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 27	07	12	689ms	57ms
	08	1,124	1m	53ms
	09	3,567	3m18s	55ms
	10	7,000	7m40s	65ms
	11	3,871	3m50s	59ms
	12	5,448	5m15s	57ms
	13	8,834	8m26s	57ms
	14	6,383	6m33s	61ms
	15	4,794	4m33s	57ms
	16	4,546	4m30s	59ms
	17	2,152	2m12s	61ms
	18	156	9s710ms	62ms
	19	40	2s480ms	62ms
	20	52	3s124ms	60ms
	21	9	520ms	57ms
	22	3	178ms	59ms

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

Date: 2025-01-27 10:54:43 Duration: 339ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4735782) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:42 Duration: 329ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4665199) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:53:59 Duration: 302ms

19

39ms

157ms

53ms

21,274

Details

18m58s

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
Jan 27	08	655	31s567ms	48ms
	09	1,538	1m16s	49ms
	10	2,854	2m36s	54ms
	11	1,539	1m23s	54ms
	12	2,638	2m16s	51ms
	13	3,214	2m48s	52ms
	14	3,549	3m18s	55ms
	15	2,150	1m50s	51ms
	16	2,328	2m8s	55ms
	17	807	46s48ms	57ms
	19	2	113ms	56ms

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

Date: 2025-01-27 10:54:55 Duration: 157ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4715727) ORDER BY "collection_policy"."id";

Date: 2025-01-27 14:06:35 Duration: 119ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4691065) ORDER BY "collection_policy"."id";

Date: 2025-01-27 10:54:55 Duration: 114ms

20

36ms

439ms

48ms

138,095

Details

1h52m23s

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
Jan 27	00	2,861	2m5s	43ms
	01	2,527	1m50s	43ms
	02	2,366	1m44s	44ms
	03	2,113	1m33s	44ms
	04	1,147	50s862ms	44ms
	05	525	23s263ms	44ms
	06	1,871	1m22s	43ms
	07	1,258	55s458ms	44ms
	08	3,326	2m27s	44ms
	09	7,533	5m46s	46ms
	10	15,014	13m17s	53ms
	11	11,899	9m55s	50ms
	12	11,877	9m33s	48ms
	13	11,377	9m3s	47ms
	14	10,911	9m11s	50ms
	15	8,342	6m34s	47ms
	16	7,948	6m31s	49ms
	17	7,746	6m47s	52ms
	18	6,578	5m26s	49ms
	19	6,390	5m18s	49ms
	20	5,956	4m48s	48ms
	21	4,510	3m39s	48ms
	22	4,020	3m15s	48ms

SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4810136, 4763579, 4763578, 4763577, 4763576, 4763575, 4763574, 4763573)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:53:55 Duration: 439ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4746888, 4734379, 4729519, 4720553, 4717669)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 10:58:20 Duration: 369ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4767410)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-27 14:07:02 Duration: 271ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

18,865,656 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	10	0.00%
DETAIL	10,171	0.05%
ERROR	4,143	0.02%
EVENTLOG	950	0.01%
FATAL	10,883	0.06%
HINT	4	0.00%
LOG	18,835,324	99.84%
STATEMENT	4,171	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
10883 FATAL entries
4143 ERROR entries
0 WARNING entries
950 EVENTLOG entries

Most Frequent Errors/Events

Key values

10,161 Max number of times the same event was reported
15,976 Total events found

Rank

Times reported

Error

1

10,161

Details

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

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 27	04	740
	05	4,342
	06	4,341
	07	737
	13	1

FATAL: password authentication failed for user "postgres"

2

2,196

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 27	00	18
	01	6
	02	5
	03	6
	04	8
	05	2
	06	6
	07	7
	08	40
	09	109
	10	204
	11	354
	12	263
	13	264
	14	203
	15	95
	16	175
	17	146
	18	71
	19	54
	20	86
	21	56
	22	18

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

3

1,925

Details

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

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 27	00	18
	01	5
	02	4
	03	4
	04	5
	05	2
	06	6
	07	7
	08	37
	09	93
	10	189
	11	325
	12	250
	13	225
	14	182
	15	81
	16	127
	17	114
	18	60
	19	45
	20	79
	21	49
	22	18

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

4

594

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 27	10	74
	11	64
	12	56
	13	90
	14	72
	15	26
	16	69
	17	62
	19	81

5

594

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 27	10	74
	11	64
	12	56
	13	90
	14	72
	15	26
	16	69
	17	62
	19	81

6

238

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 27	10	27
	11	33
	12	8
	13	42
	14	25
	15	6
	16	34
	17	36
	19	19
	20	5
	21	2
	22	1

7

117

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 27	10	10
	11	15
	12	5
	13	26
	14	9
	15	5
	16	18
	17	21
	19	8

8

87

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 27	17	87

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

9

24

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 27	17	24

10

12

Details

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

Times Reported Most Frequent Error / Event #10

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

11

8

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 27	13	1
	16	5
	17	2

ERROR: syntax error at or near ")" at character 163
ERROR: syntax error at or near ")" at character 161
ERROR: syntax error at or near ")" at character 300

12

6

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 27	12	2
	13	2
	14	2

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

13

4

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 27	13	3
	14	1

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

14

2

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 27	05	1
	20	1

15

2

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 27	17	2

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

16

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 27	13	1
	14	1

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

17

1

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 27	04	1

18

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 27	17	1

19

1

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 27	20	1

20

1

Details

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

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 27	20	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