pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Sat Dec 21 23:47:27 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 42,070,112 log entries in 2m26s
Log start from 2024-12-21 00:00:00 to 2024-12-21 22:45:01

Global Stats

18,809 Number of unique normalized queries
18,110,610 Number of queries
6d16h56m44s Total query duration
2024-12-21 00:00:00 First query
2024-12-21 22:45:01 Last query
6,044 queries/s at 2024-12-21 11:55:23 Query peak

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

11,491 Number of events
24 Number of unique normalized events
4,261 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,110,610 Average queries per session
6d16h56m44s Average queries duration per session
n/a Average idle time per session

0 Total number of connections
1 Total number of databases

SQL Traffic

Key values

6,044 queries/s Query Peak
2024-12-21 11:55:23 Date

SELECT Traffic

Key values

4,326 queries/s Query Peak
2024-12-21 11:55:23 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,174 queries/s Query Peak
2024-12-21 11:55:23 Date

Queries duration

Key values

6d16h56m44s 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)
Dec 21	00	302,062	0ms	16s787ms	24ms	3m48s	4m11s	4m51s
	01	205,029	0ms	14s929ms	16ms	1m50s	2m14s	2m37s
	02	265,465	0ms	1s526ms	22ms	3m12s	3m23s	3m42s
	03	141,806	0ms	11s479ms	16ms	1m44s	2m11s	3m40s
	04	124,252	0ms	581ms	18ms	1m25s	1m42s	2m22s
	05	89,858	0ms	562ms	21ms	1m3s	1m8s	1m18s
	06	153,359	0ms	3m50s	17ms	1m43s	2m27s	6m16s
	07	133,170	0ms	4s268ms	8ms	1m	1m15s	1m39s
	08	495,583	0ms	1s525ms	8ms	2m6s	2m47s	4m6s
	09	940,241	0ms	11m19s	23ms	4m53s	5m51s	3h14m35s
	10	1,392,516	0ms	14m18s	30ms	7m22s	1h48m44s	3h5m12s
	11	1,634,160	0ms	17m3s	34ms	1h6m29s	2h4m39s	2h56m20s
	12	1,647,351	0ms	9m57s	36ms	1h7m22s	1h55m19s	3h35m8s
	13	1,393,098	0ms	10m9s	21ms	22m5s	24m40s	2h34m33s
	14	1,303,711	0ms	59m59s	20ms	6m43s	38m28s	1h33m12s
	15	1,330,220	0ms	23m32s	34ms	29m11s	47m33s	5h6m52s
	16	1,274,295	0ms	14m44s	21ms	5m33s	42m30s	2h11m43s
	17	1,310,668	0ms	8m57s	23ms	5m34s	7m51s	2h48m20s
	18	1,156,236	0ms	35m27s	46ms	7m16s	2h21m58s	5h17m53s
	19	971,807	0ms	59m59s	57ms	8m24s	10m25s	8h26m4s
	20	953,750	0ms	24m25s	46ms	12m24s	14m48s	6h34m37s
	21	575,120	0ms	19m23s	53ms	5m39s	6m44s	5h45s
	22	316,853	0ms	21m33s	73ms	3m2s	4m9s	5h3m12s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 21	00	164,739	45ms	3m5s	3m48s	4m18s
	01	103,288	31ms	1m33s	1m50s	2m22s
	02	137,242	43ms	2m40s	3m12s	3m36s
	03	69,248	34ms	1m26s	1m44s	2m33s
	04	60,302	36ms	1m2s	1m25s	1m55s
	05	44,921	42ms	59s603ms	1m3s	1m10s
	06	83,602	29ms	1m8s	1m42s	2m27s
	07	71,232	16ms	38s309ms	1m	1m21s
	08	296,329	13ms	1m49s	2m5s	2m49s
	09	556,974	18ms	4m6s	4m49s	5m50s
	10	846,207	15ms	5m11s	6m40s	7m21s
	11	990,597	16ms	6m16s	7m10s	8m59s
	12	1,009,458	12ms	4m54s	5m48s	6m49s
	13	831,487	15ms	5m3s	5m48s	6m21s
	14	767,620	14ms	4m1s	5m3s	6m37s
	15	796,047	12ms	3m49s	4m16s	5m43s
	16	762,240	14ms	4m5s	4m48s	5m32s
	17	788,348	15ms	4m21s	5m16s	6m28s
	18	707,316	18ms	5m15s	6m17s	7m15s
	19	559,238	27ms	5m41s	7m28s	9m51s
	20	579,390	36ms	7m51s	10m6s	14m45s
	21	340,673	31ms	3m52s	4m58s	6m11s
	22	184,196	28ms	2m43s	3m	4m41s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 21	00	27,328	7,615	164	0	0ms	163ms	236ms	312ms
	01	12,721	3,796	147	0	0ms	88ms	126ms	182ms
	02	22,308	5,956	159	0	0ms	137ms	186ms	267ms
	03	10,954	2,474	129	0	1ms	71ms	114ms	228ms
	04	9,324	2,014	128	0	0ms	53ms	84ms	116ms
	05	8,838	1,563	130	0	0ms	58ms	102ms	112ms
	06	9,946	2,288	137	0	19ms	53ms	118ms	186ms
	07	4,732	2,153	137	0	0ms	33ms	54ms	116ms
	08	16,282	6,108	404	0	0ms	114ms	147ms	216ms
	09	40,754	15,957	655	0	203ms	256ms	288ms	356ms
	10	62,724	18,410	655	0	360ms	407ms	522ms	1h46m27s
	11	76,929	23,616	858	0	382ms	509ms	588ms	2h2m13s
	12	66,428	21,008	617	0	526ms	449ms	578ms	1h53m37s
	13	56,382	19,917	562	0	217ms	366ms	429ms	22m52s
	14	47,750	19,666	594	0	215ms	298ms	348ms	35m57s
	15	51,870	20,986	616	0	491ms	355ms	441ms	46m14s
	16	50,718	19,370	581	0	233ms	328ms	409ms	40m7s
	17	59,279	19,307	891	2	222ms	468ms	575ms	932ms
	18	61,040	18,021	723	1	507ms	436ms	551ms	2h20m24s
	19	79,385	21,687	598	0	400ms	460ms	635ms	8s113ms
	20	85,234	22,494	515	0	219ms	627ms	845ms	1m7s
	21	51,760	12,710	417	0	309ms	331ms	480ms	3m17s
	22	26,681	5,908	165	0	551ms	196ms	238ms	460ms

Day	Hour	Percentage of prepare
Dec 21	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
Dec 21	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
Dec 21	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

57,205 buffers Checkpoint Peak
2024-12-21 12:46:24 Date
270.055 seconds Highest write time
0.013 seconds Sync time

Checkpoints Wal files

Key values

23 files Wal files usage Peak
2024-12-21 20:06:21 Date

Checkpoints distance

Key values

730.76 Mo Distance Peak
2024-12-21 12:46:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 21	00	105,067	3,239.62s	0.032s	3,239.7s
	01	88,461	3,239.559s	0.027s	3,239.622s
	02	122,088	3,223.569s	0.031s	3,223.642s
	03	71,275	2,906.053s	0.032s	2,906.123s
	04	57,734	2,868.798s	0.027s	2,868.861s
	05	33,795	2,521.505s	0.026s	2,521.563s
	06	39,272	2,350.073s	0.038s	2,350.145s
	07	30,702	2,177.678s	0.023s	2,177.728s
	08	108,354	3,115.91s	0.035s	3,115.984s
	09	294,875	3,239.489s	0.041s	3,239.597s
	10	467,587	3,239.475s	0.048s	3,239.614s
	11	514,287	3,239.517s	0.053s	3,239.655s
	12	510,462	3,239.564s	0.052s	3,239.696s
	13	455,168	3,239.486s	0.052s	3,239.613s
	14	349,367	3,239.566s	0.047s	3,239.684s
	15	359,631	3,239.548s	0.046s	3,239.662s
	16	304,728	3,239.52s	0.049s	3,239.631s
	17	330,685	2,886.736s	0.073s	2,886.884s
	18	283,281	3,239.53s	0.047s	3,239.645s
	19	286,349	3,239.479s	0.051s	3,239.597s
	20	367,959	3,239.551s	0.056s	3,239.686s
	21	232,350	3,239.541s	0.054s	3,239.656s
	22	120,806	2,429.665s	0.035s	2,429.732s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 21	00	43	3,065	0.002s	0.012s
	01	37	2,528	0.002s	0.012s
	02	51	2,832	0.002s	0.012s
	03	30	2,288	0.009s	0.012s
	04	24	2,210	0.002s	0.012s
	05	14	2,058	0.002s	0.013s
	06	16	1,811	0.012s	0.011s
	07	13	2,440	0.002s	0.012s
	08	41	3,827	0.002s	0.012s
	09	114	4,619	0.002s	0.012s
	10	183	4,993	0.003s	0.012s
	11	210	5,248	0.003s	0.012s
	12	207	5,094	0.003s	0.012s
	13	188	5,319	0.003s	0.012s
	14	146	5,218	0.003s	0.012s
	15	151	5,528	0.004s	0.012s
	16	128	5,612	0.003s	0.012s
	17	140	5,703	0.010s	0.012s
	18	118	5,337	0.003s	0.012s
	19	129	5,353	0.003s	0.012s
	20	159	5,175	0.003s	0.012s
	21	101	4,800	0.002s	0.012s
	22	54	3,426	0.007s	0.009s

Day	Hour	Avg time (sec)
Dec 21	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
Dec 21	00	59,117.08 kB	87,532.17 kB
	01	49,983.45 kB	74,476.64 kB
	02	70,987.92 kB	83,934.08 kB
	03	40,675.00 kB	78,751.83 kB
	04	32,273.58 kB	50,001.67 kB
	05	18,074.00 kB	35,794.62 kB
	06	23,886.91 kB	31,309.36 kB
	07	17,092.92 kB	42,152.83 kB
	08	55,665.08 kB	66,414.83 kB
	09	155,894.67 kB	171,538.42 kB
	10	247,306.45 kB	271,058.82 kB
	11	286,291.42 kB	329,032.08 kB
	12	286,044.45 kB	332,932.82 kB
	13	250,053.36 kB	321,980.27 kB
	14	199,254.83 kB	281,328.00 kB
	15	206,150.17 kB	294,561.67 kB
	16	174,283.50 kB	225,298.08 kB
	17	190,953.67 kB	228,776.92 kB
	18	162,119.33 kB	233,656.33 kB
	19	176,424.25 kB	259,309.42 kB
	20	216,937.33 kB	306,018.75 kB
	21	138,081.25 kB	217,777.92 kB
	22	97,193.89 kB	181,204.56 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

Day	Hour	Count	Total size	Average size
Dec 21	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
Dec 21	00	0	0
	01	0	0
	02	0	0
	03	0	0
	04	0	0
	05	0	0
	06	0	0
	07	0	0
	08	0	0
	09	0	0
	10	0	0
	11	0	0
	12	0	0
	13	0	0
	14	0	0
	15	0	0
	16	0	0
	17	0	0
	18	0	0
	19	0	0
	20	0	0
	21	0	0
	22	0	0

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

10,750,694 Total read queries
4,988,100 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	10,750,694	59.36%
INSERT	939,367	5.19%
UPDATE	293,024	1.62%
DELETE	9,982	0.06%
COPY FROM	3	0.00%
COPY TO	0	0.00%
CTE	29,703	0.16%
DDL	3,244	0.02%
TCL	3,712,777	20.50%
CURSOR	0	0.00%
OTHERS	2,371,816	13.10%

Queries by database

Key values

unknown Main database
18,110,610 Requests
6d16h56m44s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	18,110,610	6d16h56m44s
	copy from	3	102ms
	cte	29,703	6s249ms
	ddl	3,244	455ms
	delete	9,982	1s345ms
	insert	939,367	4m51s
	others	2,371,816	1m47s
	select	10,750,694	2d9h40m51s
	tcl	3,712,777	2m29s
	update	293,024	4d7h6m36s

Queries by user

Key values

unknown Main user
18,110,610 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	18,110,610	6d16h56m44s
	copy from	3	102ms
	cte	29,703	6s249ms
	ddl	3,244	455ms
	delete	9,982	1s345ms
	insert	939,367	4m51s
	others	2,371,816	1m47s
	select	10,750,694	2d9h40m51s
	tcl	3,712,777	2m29s
	update	293,024	4d7h6m36s

Duration by user

Key values

6d16h56m44s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	18,110,610	6d16h56m44s
	copy from	3	102ms
	cte	29,703	6s249ms
	ddl	3,244	455ms
	delete	9,982	1s345ms
	insert	939,367	4m51s
	others	2,371,816	1m47s
	select	10,750,694	2d9h40m51s
	tcl	3,712,777	2m29s
	update	293,024	4d7h6m36s

Queries by host

Key values

unknown Main host
18,110,610 Requests
6d16h56m44s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	18,110,610	6d16h56m44s
	copy from	3	102ms
	cte	29,703	6s249ms
	ddl	3,244	455ms
	delete	9,982	1s345ms
	insert	939,367	4m51s
	others	2,371,816	1m47s
	select	10,750,694	2d9h40m51s
	tcl	3,712,777	2m29s
	update	293,024	4d7h6m36s

Queries by application

Key values

unknown Main application
18,110,610 Requests
6d16h56m44s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	18,110,610	6d16h56m44s
	copy from	3	102ms
	cte	29,703	6s249ms
	ddl	3,244	455ms
	delete	9,982	1s345ms
	insert	939,367	4m51s
	others	2,371,816	1m47s
	select	10,750,694	2d9h40m51s
	tcl	3,712,777	2m29s
	update	293,024	4d7h6m36s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-21 13:44:35 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

17,007,839 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	17,007,839	93.91%
1-5ms	266,946	1.47%
5-10ms	12,378	0.07%
10-25ms	52,231	0.29%
25-50ms	199,855	1.10%
50-100ms	44,041	0.24%
100-500ms	460,049	2.54%
500-1000ms	62,419	0.34%
1000-10000ms	3,502	0.02%
> 10000ms	1,350	0.01%

Slowest individual queries

Rank	Duration	Query
1	59m59s	update res_users set sid = '15b7e57df0412c5abf6f4517d56fa67b6746698b', last_update = '2024-12-21 12:37:36.315520', exp_date = '2024-12-21 13:22:36.315523', logged_in = 'TRUE' where id = 932; [ Date: 2024-12-21 14:37:36 ]
2	59m59s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.500804', exp_date = '2024-12-21 18:37:12.500807', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-21 19:52:12 ]
3	59m59s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.501195', exp_date = '2024-12-21 18:37:12.501199', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-21 19:52:12 ]
4	59m21s	update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:50.414332', exp_date = '2024-12-21 18:37:50.414335', logged_in = 'TRUE' where id = 1037; [ Date: 2024-12-21 19:52:12 ]
5	58m29s	update res_users set sid = 'a0e43cc7384271504ee6eac1f49e643d78c6c705', last_update = '2024-12-21 18:00:52.159107', exp_date = '2024-12-21 18:45:52.159110', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-21 19:59:21 ]
6	58m29s	update res_users set sid = 'a0e43cc7384271504ee6eac1f49e643d78c6c705', last_update = '2024-12-21 18:00:52.159003', exp_date = '2024-12-21 18:45:52.159006', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-21 19:59:21 ]
7	45m43s	update res_users set sid = 'a0e43cc7384271504ee6eac1f49e643d78c6c705', last_update = '2024-12-21 18:13:37.461495', exp_date = '2024-12-21 18:58:37.461500', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-21 19:59:21 ]
8	43m12s	UPDATE "res_users" SET "exp_date" = '2024-12-21 19:01:09.097318', "last_update" = '2024-12-21 18:16:09.097362', "logged_in" = true, "sid" = '3f370d79a34bb1175f367fb381ccd86e14021a08', "write_date" = '2024-12-21 18:16:08.653445', "write_uid" = 1 WHERE id IN (884); [ Date: 2024-12-21 19:59:21 ]
9	39m54s	UPDATE "res_users" SET "exp_date" = '2024-12-21 19:04:26.915343', "last_update" = '2024-12-21 18:19:26.915378', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:19:26.557711', "write_uid" = 1 WHERE id IN (884); [ Date: 2024-12-21 19:59:21 ]
10	35m27s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-21 16:25:45.278451', exp_date = '2024-12-21 17:10:45.278455', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-21 18:01:12 ]
11	35m27s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-21 16:25:45.278333', exp_date = '2024-12-21 17:10:45.278336', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-21 18:01:12 ]
12	35m3s	UPDATE "res_users" SET "exp_date" = '2024-12-21 19:09:18.305218', "last_update" = '2024-12-21 18:24:18.305251', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:24:17.981734', "write_uid" = 1 WHERE id IN (884); [ Date: 2024-12-21 19:59:21 ]
13	34m50s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-21 16:26:22.491873', exp_date = '2024-12-21 17:11:22.491875', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-21 18:01:12 ]
14	34m49s	update res_users set sid = '5a47b4c8b2dab70ad4a95a2e1879734feba5583b', last_update = '2024-12-21 18:24:32.091011', exp_date = '2024-12-21 19:09:32.091014', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-21 19:59:21 ]
15	34m40s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-21 16:26:32.594701', exp_date = '2024-12-21 17:11:32.594703', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-21 18:01:12 ]
16	32m16s	update res_users set sid = '62d4dd01772317ad57302ae6040d6ed9408b215b', last_update = '2024-12-21 16:28:55.924079', exp_date = '2024-12-21 17:13:55.924081', logged_in = 'TRUE' where id = 861; [ Date: 2024-12-21 18:01:12 ]
17	29m50s	update res_users set sid = '5a47b4c8b2dab70ad4a95a2e1879734feba5583b', last_update = '2024-12-21 18:29:31.139778', exp_date = '2024-12-21 19:14:31.139780', logged_in = 'TRUE' where id = 884; [ Date: 2024-12-21 19:59:21 ]
18	28m3s	update res_users set sid = '82148a1afa39a9c5469c24936fc4e28d53c2d2f0', last_update = '2024-12-21 17:01:16.267411', exp_date = '2024-12-21 17:46:16.267413', logged_in = 'TRUE' where id = 917; [ Date: 2024-12-21 18:29:20 ]
19	27m39s	UPDATE "res_users" SET "exp_date" = '2024-12-21 19:16:41.745451', "last_update" = '2024-12-21 18:31:41.745499', "logged_in" = true, "sid" = 'dcd68eb61908a6f84396f251eea3bcf37bba56f2', "write_date" = '2024-12-21 18:31:41.360020', "write_uid" = 1 WHERE id IN (884); [ Date: 2024-12-21 19:59:21 ]
20	26m40s	UPDATE "res_users" SET "exp_date" = '2024-12-21 19:17:40.525519', "last_update" = '2024-12-21 18:32:40.525551', "logged_in" = true, "sid" = 'dcd68eb61908a6f84396f251eea3bcf37bba56f2', "write_date" = '2024-12-21 18:32:40.203514', "write_uid" = 1 WHERE id IN (884); [ Date: 2024-12-21 19:59:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

4d52m19s

77,949

Details

0ms

59m59s

4s473ms

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
Dec 21	00	709	16s955ms	23ms
	01	571	122ms	0ms
	02	841	187ms	0ms
	03	341	73ms	0ms
	04	292	63ms	0ms
	05	94	20ms	0ms
	06	376	84ms	0ms
	07	291	64ms	0ms
	08	1,465	324ms	0ms
	09	3,944	3h12m35s	2s929ms
	10	6,682	7h45m15s	4s177ms
	11	7,809	9h54m7s	4s564ms
	12	8,007	12h32m35s	5s639ms
	13	7,384	4h37m35s	2s255ms
	14	7,257	4h3m18s	2s11ms
	15	7,220	9h57m50s	4s968ms
	16	6,339	4h32m29s	2s579ms
	17	5,547	4h51m19s	3s151ms
	18	4,005	11h2m50s	9s930ms
	19	3,278	7h37m1s	8s365ms
	20	2,909	6h32m18s	8s91ms
	21	1,742	5h11m59s	10s745ms
	22	846	5h43s	21s327ms

update res_users set sid = '15b7e57df0412c5abf6f4517d56fa67b6746698b', last_update = '2024-12-21 12:37:36.315520', exp_date = '2024-12-21 13:22:36.315523', logged_in = 'TRUE' where id = 932;

Date: 2024-12-21 14:37:36 Duration: 59m59s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.500804', exp_date = '2024-12-21 18:37:12.500807', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-21 19:52:12 Duration: 59m59s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.501195', exp_date = '2024-12-21 18:37:12.501199', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-21 19:52:12 Duration: 59m59s

2

1d3h51m34s

216,455

Details

385ms

1s429ms

463ms

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
Dec 21	00	9,200	1h9m17s	451ms
	01	4,506	33m26s	445ms
	02	7,890	58m38s	445ms
	03	3,627	26m50s	444ms
	04	3,181	23m12s	437ms
	05	2,224	17m11s	463ms
	06	2,698	20m19s	451ms
	07	844	6m40s	474ms
	08	4,237	31m3s	439ms
	09	8,980	1h7m53s	453ms
	10	16,431	2h9m55s	474ms
	11	18,778	2h32m23s	486ms
	12	14,176	1h51m29s	471ms
	13	12,285	1h36m14s	470ms
	14	10,136	1h18m28s	464ms
	15	8,230	1h3m4s	459ms
	16	9,779	1h16m56s	472ms
	17	12,021	1h31m57s	458ms
	18	13,167	1h40m4s	456ms
	19	14,804	1h54m1s	462ms
	20	22,828	3h1m18s	476ms
	21	10,873	1h20m10s	442ms
	22	5,560	40m56s	441ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3775920)) AND (("shipping_track"."id" not in (30823304, 30824733, 30825009, 30825183, 30930524, 30930629, 30930637, 30932274, 30932274)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 12:43:18 Duration: 1s429ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799843)) AND (("shipping_track"."id" not in (31018447, 31018447)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:59 Duration: 1s14ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799762)) AND (("shipping_track"."id" not in (31018134, 31018134)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:02 Duration: 999ms

3

5h44m51s

44,034

Details

386ms

2s530ms

469ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 21	00	269	2m6s	470ms
	01	116	57s468ms	495ms
	02	253	2m4s	490ms
	03	104	52s686ms	506ms
	04	85	43s226ms	508ms
	05	39	19s663ms	504ms
	06	156	1m11s	455ms
	07	126	55s442ms	440ms
	08	1,546	11m27s	444ms
	09	2,643	20m28s	464ms
	10	3,247	26m14s	485ms
	11	4,911	40m56s	500ms
	12	3,647	30m6s	495ms
	13	3,586	28m41s	480ms
	14	3,292	25m55s	472ms
	15	2,594	20m19s	469ms
	16	3,060	23m55s	469ms
	17	3,832	29m1s	454ms
	18	3,150	23m22s	445ms
	19	2,375	17m40s	446ms
	20	2,589	20m23s	472ms
	21	1,894	13m25s	425ms
	22	520	3m43s	429ms

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

Date: 2024-12-21 12:43:19 Duration: 2s530ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3785159, 3783422, 3774317, 3772116, 3768880, 3767586, 3767539, 3763741, 3763097, 3762226, 3751695, 3751238, 3751236, 3750696, 3745356, 3744288, 3744269, 3744192, 3742739, 3742588, 3742462, 3742454, 3742017, 3736072, 3733733, 3725026, 3724117, 3715009, 3710068, 3709766, 3699260, 3697907, 3684821, 3681316, 3642562, 3602033, 3574455, 3567305, 3489733)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 17:21:55 Duration: 1s377ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2068788, 3165676, 3658806, 3275376)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:28 Duration: 1s221ms

4

5h40m7s

87,106

Details

177ms

1s62ms

234ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 21	00	5,866	21m54s	224ms
	01	1,213	4m23s	217ms
	02	2,135	7m46s	218ms
	03	531	1m54s	214ms
	04	1,007	3m42s	220ms
	05	387	1m25s	219ms
	06	1,159	4m12s	217ms
	07	662	2m24s	218ms
	08	2,330	8m34s	220ms
	09	7,288	27m53s	229ms
	10	5,640	22m45s	242ms
	11	6,764	27m38s	245ms
	12	5,499	22m	240ms
	13	6,950	27m13s	235ms
	14	6,597	25m35s	232ms
	15	6,958	26m51s	231ms
	16	3,662	13m57s	228ms
	17	3,779	13m39s	216ms
	18	1,810	6m11s	205ms
	19	7,504	29m9s	233ms
	20	9,318	40m44s	262ms
	21	22	4s370ms	198ms
	22	25	4s918ms	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" = '9428578')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:01:20 Duration: 1s62ms
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" = '9375304')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:02:02 Duration: 1s15ms
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" = '9314548')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:02:26 Duration: 633ms

5

3h52m58s

61,056

Details

92ms

868ms

228ms

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
Dec 21	00	3,146	10m26s	199ms
	01	1,480	5m	202ms
	02	2,262	7m3s	187ms
	03	1,172	4m26s	227ms
	04	654	2m38s	241ms
	05	1,890	6m5s	193ms
	06	1,466	4m37s	189ms
	07	892	3m15s	219ms
	08	424	1m30s	214ms
	09	300	55s441ms	184ms
	10	74	15s105ms	204ms
	11	204	45s880ms	224ms
	12	198	33s138ms	167ms
	13	860	3m28s	242ms
	14	1,345	5m6s	227ms
	15	1,004	4m9s	248ms
	16	3,647	13m25s	220ms
	17	4,321	17m43s	246ms
	18	7,091	28m12s	238ms
	19	8,261	33m	239ms
	20	10,677	43m7s	242ms
	21	5,957	21m55s	220ms
	22	3,731	15m15s	245ms

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

Date: 2024-12-21 19:15:35 Duration: 868ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-21 19:15:35 Duration: 868ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-21 19:16:07 Duration: 859ms

6

3h41m31s

283

Details

0ms

43m12s

46s967ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 21	00	7	6ms	0ms
	01	6	2ms	0ms
	02	8	4ms	0ms
	06	2	0ms	0ms
	07	4	0ms	0ms
	08	14	2ms	0ms
	09	16	11ms	0ms
	10	16	22ms	1ms
	11	13	14ms	1ms
	12	13	19ms	1ms
	13	13	16ms	1ms
	14	12	12ms	1ms
	15	12	15ms	1ms
	16	21	23ms	1ms
	17	39	37ms	0ms
	18	42	38ms	0ms
	19	22	3h41m31s	10m4s
	20	13	16ms	1ms
	21	9	13ms	1ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 19:01:09.097318', "last_update" = '2024-12-21 18:16:09.097362', "logged_in" = true, "sid" = '3f370d79a34bb1175f367fb381ccd86e14021a08', "write_date" = '2024-12-21 18:16:08.653445', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 43m12s
UPDATE "res_users" SET "exp_date" = '2024-12-21 19:04:26.915343', "last_update" = '2024-12-21 18:19:26.915378', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:19:26.557711', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 39m54s
UPDATE "res_users" SET "exp_date" = '2024-12-21 19:09:18.305218', "last_update" = '2024-12-21 18:24:18.305251', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:24:17.981734', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 35m3s

7

2h42m16s

10,081

Details

233ms

2s37ms

965ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 21	00	357	5m45s	967ms
	01	65	1m2s	966ms
	02	741	11m48s	956ms
	08	3	2s874ms	958ms
	09	4	3s993ms	998ms
	10	5	5s202ms	1s40ms
	12	1	975ms	975ms
	13	66	1m8s	1s36ms
	14	33	33s323ms	1s9ms
	15	84	1m22s	984ms
	16	687	11m30s	1s4ms
	17	490	8m2s	984ms
	18	1,646	24m52s	906ms
	19	1,622	25m51s	956ms
	20	1,402	25m16s	1s81ms
	21	2,030	31m38s	935ms
	22	845	13m10s	934ms

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

Date: 2024-12-21 20:02:29 Duration: 2s37ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9438886')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-21 20:02:13 Duration: 1s906ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9554943')) 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 (55))))))) 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 (55)))))) 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 (55)))))) 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 (55))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-21 20:02:29 Duration: 1s873ms

8

2h5m3s

345

Details

0ms

19m23s

21s750ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 21	00	8	2ms	0ms
	01	3	0ms	0ms
	02	4	0ms	0ms
	06	4	2ms	0ms
	07	2	0ms	0ms
	08	16	3ms	0ms
	09	19	5ms	0ms
	10	29	25m32s	52s853ms
	11	37	39m31s	1m4s
	12	35	18m41s	32s40ms
	13	29	53s158ms	1s833ms
	14	25	36s891ms	1s475ms
	15	27	3m43s	8s288ms
	16	24	1m38s	4s114ms
	17	30	3m5s	6s169ms
	18	17	11m57s	42s201ms
	19	16	12ms	0ms
	20	14	19ms	1ms
	21	3	19m23s	6m27s
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 21:21:57.742764', "last_update" = '2024-12-21 20:36:57.742787', "sid" = 'e2b7a62d414695e8e6ef9aff340fb41f8744a9c6', "write_date" = '2024-12-21 20:36:57.408552', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-21 21:56:21 Duration: 19m23s
UPDATE "res_users" SET "exp_date" = '2024-12-21 10:16:48.938704', "last_update" = '2024-12-21 09:31:48.938739', "sid" = '2c5919c468edbab8e080145b75bcd4208a23d748', "write_date" = '2024-12-21 09:31:48.496516', "write_uid" = 1 WHERE id IN (841);

Date: 2024-12-21 10:45:21 Duration: 13m32s
UPDATE "res_users" SET "exp_date" = '2024-12-21 12:13:55.834712', "last_update" = '2024-12-21 11:28:55.834739', "sid" = '9d701320610541f97109ee45e014ad84588ba392', "write_date" = '2024-12-21 11:28:55.502696', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-21 12:36:20 Duration: 7m24s

9

1h48m50s

20,880

Details

222ms

512ms

312ms

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
Dec 21	00	1,232	6m24s	312ms
	01	685	3m31s	308ms
	02	401	2m3s	309ms
	03	598	3m3s	306ms
	04	333	1m41s	303ms
	05	955	4m47s	301ms
	06	739	3m47s	308ms
	07	452	2m17s	303ms
	08	215	1m6s	309ms
	09	151	48s617ms	321ms
	10	41	13s676ms	333ms
	11	103	36s427ms	353ms
	12	105	36s100ms	343ms
	13	379	2m6s	332ms
	14	652	3m30s	323ms
	15	430	2m21s	328ms
	16	1,177	6m21s	324ms
	17	1,705	8m55s	313ms
	18	1,932	9m58s	309ms
	19	2,546	13m37s	321ms
	20	4,000	21m5s	316ms
	21	990	4m51s	293ms
	22	1,059	5m4s	287ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477429')) 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: 2024-12-21 20:02:26 Duration: 512ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477447')) 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: 2024-12-21 20:02:16 Duration: 501ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477449')) 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: 2024-12-21 20:02:21 Duration: 492ms

10

1h35m39s

20,237

Details

185ms

546ms

283ms

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
Dec 21	08	874	3m48s	261ms
	09	1,865	8m39s	278ms
	10	1,600	7m57s	298ms
	11	1,407	7m16s	310ms
	12	2,239	10m50s	290ms
	13	3,497	16m36s	285ms
	14	2,639	12m38s	287ms
	15	2,259	10m23s	276ms
	16	1,311	6m9s	281ms
	17	1,330	6m	270ms
	18	804	3m32s	264ms
	19	412	1m44s	254ms

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

Date: 2024-12-21 12:43:24 Duration: 546ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9073247')))) ORDER BY "collection_policy"."id";

Date: 2024-12-21 12:43:21 Duration: 496ms
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" = '9331793')))) ORDER BY "collection_policy"."id";

Date: 2024-12-21 12:43:17 Duration: 488ms

11

1h28m5s

137,728

Details

28ms

200ms

38ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	2,435	1m28s	36ms
	01	1,236	45s215ms	36ms
	02	2,698	1m38s	36ms
	03	1,517	54s761ms	36ms
	04	1,032	37s914ms	36ms
	05	594	21s820ms	36ms
	06	789	28s993ms	36ms
	07	399	14s780ms	37ms
	08	3,178	1m56s	36ms
	09	7,137	4m29s	37ms
	10	11,975	7m50s	39ms
	11	14,536	9m46s	40ms
	12	12,197	7m58s	39ms
	13	10,435	6m44s	38ms
	14	8,065	5m7s	38ms
	15	7,150	4m30s	37ms
	16	6,977	4m25s	38ms
	17	8,708	5m30s	37ms
	18	8,627	5m23s	37ms
	19	9,576	6m4s	38ms
	20	8,974	6m1s	40ms
	21	5,986	3m38s	36ms
	22	3,507	2m7s	36ms

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

Date: 2024-12-21 20:02:27 Duration: 200ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2068788)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 20:02:27 Duration: 151ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3775920)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 12:43:17 Duration: 120ms

12

42m24s

11,047

Details

178ms

392ms

230ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	37	8s100ms	218ms
	01	89	19s415ms	218ms
	02	219	47s503ms	216ms
	03	61	13s85ms	214ms
	04	60	13s126ms	218ms
	06	581	2m7s	218ms
	07	225	49s211ms	218ms
	08	440	1m37s	221ms
	09	1,734	6m35s	227ms
	10	738	2m57s	240ms
	11	1,914	7m43s	241ms
	12	1,023	4m2s	236ms
	13	510	2m2s	239ms
	14	1,136	4m20s	229ms
	15	909	3m29s	230ms
	16	310	1m12s	233ms
	17	625	2m13s	213ms
	18	202	40s996ms	202ms
	19	80	16s156ms	201ms
	20	129	31s863ms	247ms
	21	17	3s375ms	198ms
	22	8	1s565ms	195ms

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" = '9149439')) 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 (128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) 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: 2024-12-21 12:43:24 Duration: 392ms
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" = '9539097')) 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 (128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) 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: 2024-12-21 12:43:20 Duration: 385ms
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" = '9456641')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-21 20:38:50 Duration: 367ms

13

30m35s

40,999

Details

34ms

113ms

44ms

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
Dec 21	00	9	399ms	44ms
	06	21	920ms	43ms
	07	9	412ms	45ms
	08	1,766	1m14s	41ms
	09	4,422	3m11s	43ms
	10	2,865	2m9s	45ms
	11	3,242	2m33s	47ms
	12	2,806	2m10s	46ms
	13	4,345	3m15s	44ms
	14	5,552	4m6s	44ms
	15	5,195	3m48s	44ms
	16	3,093	2m16s	44ms
	17	3,237	2m24s	44ms
	18	1,974	1m28s	44ms
	19	1,637	1m14s	45ms
	20	487	24s94ms	49ms
	21	257	11s409ms	44ms
	22	82	3s647ms	44ms

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

Date: 2024-12-21 17:21:56 Duration: 113ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3657823) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-21 17:36:21 Duration: 112ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3691282) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-21 20:39:41 Duration: 92ms

14

27m46s

17,855

Details

75ms

168ms

93ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1	95ms	95ms
	02	2	186ms	93ms
	08	286	26s65ms	91ms
	09	685	1m4s	93ms
	10	1,257	1m58s	94ms
	11	1,369	2m14s	98ms
	12	1,876	2m57s	94ms
	13	1,580	2m28s	93ms
	14	1,298	2m	93ms
	15	3,473	5m14s	90ms
	16	1,321	2m1s	91ms
	17	1,060	1m39s	93ms
	18	662	1m2s	94ms
	19	839	1m21s	96ms
	20	751	1m14s	99ms
	21	1,069	1m34s	88ms
	22	326	28s90ms	86ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7809025)) AND (("cash_track"."id" not in (5650781, 5661442, 5673949, 5999779, 6000791, 6000801, 6000801)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 12:43:19 Duration: 168ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7819687)) AND (("cash_track"."id" not in (5722807, 5728264, 5729083, 5999778, 6000790, 6000800, 6000800)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 12:43:19 Duration: 164ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7822778)) AND (("cash_track"."id" not in (5742662, 5764667, 5776021, 6007106, 6007106)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 15:12:12 Duration: 161ms

15

23m34s

5,988

Details

176ms

366ms

236ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 21	06	380	1m22s	217ms
	07	415	1m30s	218ms
	08	100	22s233ms	222ms
	09	1,794	6m53s	230ms
	10	1,366	5m41s	250ms
	11	1,440	5m52s	245ms
	13	62	14s436ms	232ms
	14	298	1m8s	230ms
	15	3	669ms	223ms
	16	44	9s781ms	222ms
	18	50	10s537ms	210ms
	19	18	3s358ms	186ms
	20	13	2s662ms	204ms
	21	5	980ms	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" = '9393353')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-21 11:03:11 Duration: 326ms

16

22m23s

388

Details

342ms

4s559ms

3s463ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	09	9	34s75ms	3s786ms
	10	13	53s186ms	4s91ms
	11	29	1m55s	3s972ms
	12	57	3m26s	3s619ms
	13	30	1m43s	3s435ms
	14	36	1m59s	3s323ms
	15	73	3m59s	3s281ms
	16	17	57s151ms	3s361ms
	17	30	1m42s	3s410ms
	18	25	1m23s	3s355ms
	19	13	37s578ms	2s890ms
	20	25	1m32s	3s680ms
	21	21	1m8s	3s250ms
	22	10	31s663ms	3s166ms

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

Date: 2024-12-21 20:38:49 Duration: 4s559ms
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 (30))))))) 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 (30)))))) 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 (30)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) 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 (30))))))))) 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 (30)))))))) AND ("policy_number"."name"::text ilike '%9485654%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-21 20:39:13 Duration: 4s546ms
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 (126))))))) 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 (126)))))) 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 (126)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (126)))))) 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 (126))))))))) 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 (126)))))))) AND ("policy_number"."name"::text ilike '%8548049%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-21 10:55:16 Duration: 4s502ms

17

18m56s

5,203

Details

182ms

255ms

218ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	808	2m55s	216ms
	01	988	3m35s	218ms
	02	1,648	6m	218ms
	03	210	45s352ms	215ms
	04	947	3m28s	220ms
	05	387	1m25s	219ms
	06	198	42s869ms	216ms
	22	17	3s372ms	198ms

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

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

Date: 2024-12-21 01:12:45 Duration: 254ms

18

15m14s

2,139

Details

345ms

543ms

427ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	09	745	5m16s	425ms
	14	172	1m15s	439ms
	15	260	1m56s	446ms
	16	22	10s501ms	477ms
	17	29	12s518ms	431ms
	21	761	5m19s	419ms
	22	150	1m3s	424ms

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

Date: 2024-12-21 21:59:47 Duration: 543ms
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" = '8833697')) ORDER BY "cash_policy"."id" DESC;

Date: 2024-12-21 16:01:39 Duration: 530ms
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" = '469782')) ORDER BY "cash_policy"."id" DESC;

Date: 2024-12-21 09:51:18 Duration: 520ms

19

14m28s

39

Details

0ms

6m25s

22s279ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 21	00	2	0ms	0ms
	07	1	0ms	0ms
	08	2	0ms	0ms
	09	5	2ms	0ms
	10	2	2ms	1ms
	11	8	12m48s	1m36s
	12	5	6ms	1ms
	13	3	4ms	1ms
	14	2	0ms	0ms
	16	1	0ms	0ms
	18	1	1ms	1ms
	21	6	1m40s	16s769ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 10:47:55.519103', "last_update" = '2024-12-21 10:02:55.519139', "write_date" = '2024-12-21 10:02:55.131762', "write_uid" = 1 WHERE id IN (1292);

Date: 2024-12-21 11:09:21 Duration: 6m25s
UPDATE "res_users" SET "exp_date" = '2024-12-21 10:48:23.223177', "last_update" = '2024-12-21 10:03:23.223221', "write_date" = '2024-12-21 10:03:22.775863', "write_uid" = 1 WHERE id IN (886);

Date: 2024-12-21 11:09:21 Duration: 5m57s
UPDATE "res_users" SET "exp_date" = '2024-12-21 20:47:39.679378', "last_update" = '2024-12-21 20:02:39.679400', "write_date" = '2024-12-21 20:02:39.345891', "write_uid" = 1223 WHERE id IN (1223);

Date: 2024-12-21 21:04:20 Duration: 1m40s

20

13m31s

5,615

Details

120ms

753ms

144ms

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	10	1s317ms	131ms
	02	20	2s633ms	131ms
	07	15	1s987ms	132ms
	08	21	2s819ms	134ms
	09	212	29s388ms	138ms
	10	734	1m46s	145ms
	11	1,174	2m57s	150ms
	12	1,190	2m53s	145ms
	13	596	1m24s	142ms
	14	370	51s438ms	139ms
	15	267	37s111ms	138ms
	16	169	23s669ms	140ms
	17	260	37s343ms	143ms
	18	167	23s469ms	140ms
	19	115	15s959ms	138ms
	20	134	20s833ms	155ms
	21	79	10s523ms	133ms
	22	82	10s789ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) 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: 2024-12-21 12:43:18 Duration: 753ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 4)) 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: 2024-12-21 11:10:20 Duration: 313ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-21 20:39:11 Duration: 282ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

2,369,807

Details

1m47s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 21	00	42,198	2s43ms	0ms
	01	35,535	1s514ms	0ms
	02	40,091	1s964ms	0ms
	03	24,828	1s15ms	0ms
	04	21,657	922ms	0ms
	05	15,029	599ms	0ms
	06	22,701	1s39ms	0ms
	07	22,693	918ms	0ms
	08	66,803	3s387ms	0ms
	09	124,472	6s894ms	0ms
	10	175,543	7s881ms	0ms
	11	205,638	9s108ms	0ms
	12	209,179	8s807ms	0ms
	13	188,082	8s380ms	0ms
	14	181,379	8s778ms	0ms
	15	179,354	7s177ms	0ms
	16	173,561	7s523ms	0ms
	17	169,362	8s94ms	0ms
	18	142,311	6s246ms	0ms
	19	121,104	5s863ms	0ms
	20	101,605	4s709ms	0ms
	21	66,652	2s653ms	0ms
	22	40,030	1s504ms	0ms

DISCARD ALL;

Date: 2024-12-21 19:44:01 Duration: 1ms
DISCARD ALL;

Date: 2024-12-21 19:38:12 Duration: 1ms
DISCARD ALL;

Date: 2024-12-21 15:17:34 Duration: 1ms

2

1,857,137

Details

26s65ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 21	00	29,904	503ms	0ms
	01	24,752	380ms	0ms
	02	29,828	485ms	0ms
	03	17,082	264ms	0ms
	04	15,405	247ms	0ms
	05	9,686	174ms	0ms
	06	17,322	281ms	0ms
	07	16,078	241ms	0ms
	08	54,463	825ms	0ms
	09	100,118	1s547ms	0ms
	10	142,962	1s994ms	0ms
	11	166,446	2s365ms	0ms
	12	168,332	2s246ms	0ms
	13	146,965	2s72ms	0ms
	14	142,323	2s79ms	0ms
	15	139,138	1s780ms	0ms
	16	132,574	1s846ms	0ms
	17	135,467	1s837ms	0ms
	18	111,975	1s444ms	0ms
	19	94,467	1s308ms	0ms
	20	81,448	1s128ms	0ms
	21	50,833	647ms	0ms
	22	29,569	362ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-21 09:46:53 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-21 09:30:20 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-21 15:08:54 Duration: 1ms

3

1,209,297

Details

11s904ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 21	00	21,858	213ms	0ms
	01	18,392	163ms	0ms
	02	20,653	201ms	0ms
	03	13,001	112ms	0ms
	04	11,415	100ms	0ms
	05	8,152	73ms	0ms
	06	12,020	111ms	0ms
	07	11,935	102ms	0ms
	08	34,497	338ms	0ms
	09	63,258	656ms	0ms
	10	89,171	918ms	0ms
	11	104,872	1s98ms	0ms
	12	106,334	1s50ms	0ms
	13	95,518	968ms	0ms
	14	92,397	927ms	0ms
	15	91,214	850ms	0ms
	16	88,206	855ms	0ms
	17	86,013	825ms	0ms
	18	72,215	686ms	0ms
	19	61,602	583ms	0ms
	20	51,787	551ms	0ms
	21	34,090	326ms	0ms
	22	20,697	187ms	0ms

ROLLBACK;

Date: 2024-12-21 14:38:16 Duration: 0ms
ROLLBACK;

Date: 2024-12-21 11:21:46 Duration: 0ms
ROLLBACK;

Date: 2024-12-21 13:54:24 Duration: 0ms

4

1,192,160

Details

3m32s

0ms

18ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 21	00	21,158	4s56ms	0ms
	01	17,740	2s896ms	0ms
	02	19,988	3s736ms	0ms
	03	12,380	1s850ms	0ms
	04	10,798	1s652ms	0ms
	05	7,487	1s168ms	0ms
	06	11,366	1s803ms	0ms
	07	11,319	1s464ms	0ms
	08	33,815	5s734ms	0ms
	09	62,882	11s950ms	0ms
	10	88,456	17s99ms	0ms
	11	103,737	19s952ms	0ms
	12	105,297	19s141ms	0ms
	13	94,548	17s737ms	0ms
	14	91,354	16s788ms	0ms
	15	90,191	15s700ms	0ms
	16	87,265	15s579ms	0ms
	17	85,154	14s278ms	0ms
	18	71,486	11s905ms	0ms
	19	60,757	9s895ms	0ms
	20	51,274	9s468ms	0ms
	21	33,510	5s492ms	0ms
	22	20,198	3s214ms	0ms

SELECT payload FROM http_sessions WHERE sid = '1e87669cea73abf8e23e3fc1a2503290dbdc76d7';

Date: 2024-12-21 12:44:01 Duration: 18ms
SELECT payload FROM http_sessions WHERE sid = 'd1a24b4b5f8760d6044314ee956fc9581ae15741';

Date: 2024-12-21 10:48:42 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '5fe28292c72bf0df877038554507d402cc44c864';

Date: 2024-12-21 15:09:48 Duration: 15ms

5

1,184,473

Details

1m45s

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
Dec 21	00	21,150	1s944ms	0ms
	01	17,835	1s468ms	0ms
	02	20,100	1s821ms	0ms
	03	12,504	1s6ms	0ms
	04	10,921	901ms	0ms
	05	7,592	632ms	0ms
	06	11,418	973ms	0ms
	07	11,424	899ms	0ms
	08	33,387	2s924ms	0ms
	09	62,208	5s731ms	0ms
	10	87,687	8s181ms	0ms
	11	102,630	9s463ms	0ms
	12	104,446	9s256ms	0ms
	13	93,944	8s562ms	0ms
	14	90,600	8s204ms	0ms
	15	89,570	7s660ms	0ms
	16	86,681	7s544ms	0ms
	17	84,565	7s468ms	0ms
	18	71,052	6s161ms	0ms
	19	60,541	5s128ms	0ms
	20	50,819	4s724ms	0ms
	21	33,350	2s836ms	0ms
	22	20,049	1s625ms	0ms

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

Date: 2024-12-21 15:51:42 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-21 16:11:12 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-21 03:22:02 Duration: 1ms

6

839,414

Details

1m58s

0ms

12ms

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
Dec 21	00	9,595	1s585ms	0ms
	01	7,564	1s202ms	0ms
	02	10,824	1s723ms	0ms
	03	4,948	819ms	0ms
	04	4,847	814ms	0ms
	05	1,625	389ms	0ms
	06	6,280	1s28ms	0ms
	07	4,964	818ms	0ms
	08	25,245	3s497ms	0ms
	09	49,219	6s916ms	0ms
	10	71,937	9s428ms	0ms
	11	80,374	11s49ms	0ms
	12	81,061	10s289ms	0ms
	13	67,804	9s452ms	0ms
	14	65,009	11s477ms	0ms
	15	62,653	8s5ms	0ms
	16	58,086	7s949ms	0ms
	17	65,336	9s20ms	0ms
	18	51,062	6s713ms	0ms
	19	41,768	6s683ms	0ms
	20	37,368	5s305ms	0ms
	21	20,891	2s720ms	0ms
	22	10,954	1s355ms	0ms

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

Date: 2024-12-21 17:14:50 Duration: 12ms
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 (916);

Date: 2024-12-21 17:21:52 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 (956);

Date: 2024-12-21 17:21:52 Duration: 9ms

7

646,182

Details

1m51s

0ms

32ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 21	00	8,047	1s533ms	0ms
	01	6,359	1s146ms	0ms
	02	9,176	1s636ms	0ms
	03	4,081	762ms	0ms
	04	3,989	770ms	0ms
	05	1,535	357ms	0ms
	06	5,300	852ms	0ms
	07	4,145	539ms	0ms
	08	19,965	3s27ms	0ms
	09	36,827	6s2ms	0ms
	10	53,629	9s433ms	0ms
	11	61,368	11s118ms	0ms
	12	61,785	10s710ms	0ms
	13	51,263	9s121ms	0ms
	14	49,783	8s454ms	0ms
	15	47,730	8s116ms	0ms
	16	44,238	7s558ms	0ms
	17	49,360	7s954ms	0ms
	18	39,646	6s320ms	0ms
	19	32,818	5s818ms	0ms
	20	29,631	5s879ms	0ms
	21	16,676	3s51ms	0ms
	22	8,831	1s648ms	0ms

COMMIT;

Date: 2024-12-21 14:39:23 Duration: 32ms
COMMIT;

Date: 2024-12-21 10:46:58 Duration: 29ms
COMMIT;

Date: 2024-12-21 09:47:24 Duration: 29ms

8

519,211

Details

31s229ms

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
Dec 21	00	5,788	346ms	0ms
	01	3,337	177ms	0ms
	02	4,808	271ms	0ms
	03	2,612	127ms	0ms
	04	2,355	112ms	0ms
	05	808	39ms	0ms
	06	3,755	179ms	0ms
	07	3,000	142ms	0ms
	08	15,559	838ms	0ms
	09	29,335	1s637ms	0ms
	10	44,145	2s660ms	0ms
	11	49,322	3s176ms	0ms
	12	49,212	2s979ms	0ms
	13	42,005	2s536ms	0ms
	14	38,421	2s321ms	0ms
	15	37,657	2s251ms	0ms
	16	36,706	2s194ms	0ms
	17	40,577	2s470ms	0ms
	18	33,159	1s998ms	0ms
	19	28,460	1s670ms	0ms
	20	26,605	1s804ms	0ms
	21	14,352	856ms	0ms
	22	7,233	434ms	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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 13, 14, 16, 17, 19, 22, 24, 26, 27, 29, 30, 32, 35, 36, 38, 39, 40, 41, 42, 44, 46, 48, 49, 51, 52, 53, 55, 60, 62, 64, 65, 66, 67, 70, 73, 76, 77, 78, 80, 85, 102, 110, 111, 113, 114, 119, 121, 123, 126, 127);

Date: 2024-12-21 15:39:48 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2024-12-21 13:56:17 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 (13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 119, 32, 6, 3, 80, 35, 7, 38, 121, 113, 44, 10, 2, 36, 42, 114, 71, 40, 111, 85, 60, 49, 70, 61, 46, 11, 79, 68, 95, 128, 83, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);

Date: 2024-12-21 14:44:22 Duration: 0ms

9

518,494

Details

1m7s

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
Dec 21	00	6,784	871ms	0ms
	01	4,475	516ms	0ms
	02	6,372	701ms	0ms
	03	3,585	365ms	0ms
	04	3,135	325ms	0ms
	05	2,038	184ms	0ms
	06	3,823	392ms	0ms
	07	2,869	325ms	0ms
	08	14,040	1s706ms	0ms
	09	32,736	4s243ms	0ms
	10	45,106	6s276ms	0ms
	11	46,347	6s929ms	0ms
	12	46,312	6s456ms	0ms
	13	40,722	5s325ms	0ms
	14	36,324	4s625ms	0ms
	15	36,093	4s602ms	0ms
	16	35,812	4s418ms	0ms
	17	41,877	5s465ms	0ms
	18	33,388	4s232ms	0ms
	19	28,336	3s280ms	0ms
	20	26,549	3s367ms	0ms
	21	14,526	1s650ms	0ms
	22	7,245	789ms	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 (5099920, 5105620, 5121937, 5099297, 5099727, 5105812, 5099009, 5103438, 5099443, 5133831, 5099837, 5111965, 5124219, 5108684, 5269832, 5099006, 5118685, 5288735, 5099007, 5107024, 5099356, 5100016, 5244293, 5099914, 5103860, 5099499, 5315408, 5101477, 5100009, 5099014, 5113322, 5193449, 5099965, 5099446, 5107063, 5099013, 5099296, 5099523, 5294390, 5099090, 5103222, 5099095, 5101808, 5099679, 5123579, 5108900, 5099114, 5115653, 5121857, 5099144, 5099103, 5153185, 5125434, 5100738, 5121659, 5101828, 5099684, 5100615, 5104081, 5099102, 5099181, 5099646, 5099360, 5268997, 5099092, 5114907, 5102119, 5099177, 5100230, 5163977, 5099170, 5099581, 5099254, 5101297, 5104276, 5164695, 5171879, 5099556, 5099002, 5298356, 5100111, 5099403, 5103299, 5099010);

Date: 2024-12-21 17:21:53 Duration: 5ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099920, 5113194, 5210632, 5102147, 5443003, 5099403, 5099814, 5109646, 5101380, 5099167, 5099010, 5100431, 5099501, 5100001, 5099662, 5100018, 5225900, 5101592, 5100833, 5099312, 5099007, 5124863, 5099948, 5099244, 5117728, 5101708, 5106211, 5100540, 5125009, 5099141, 5099263, 5099659, 5100163, 5099754, 5099684, 5100874, 5440310, 5102811, 5101166, 5099852, 5099321, 5102420, 5108339, 5115526, 5440258, 5099014, 5101665, 5099006, 5099560, 5345262, 5100936, 5101322, 5438985, 5099138, 5099914, 5178213, 5100801, 5103172, 5099137, 5112582, 5100021, 5101865, 5100654, 5201598, 5100024, 5416583);

Date: 2024-12-21 17:21:53 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 (5117756, 5103279, 5101119, 5099128, 5106276, 5099334, 5099013, 5099296, 5107065, 5099445, 5099007, 5099264, 5125438, 5099130, 5099921, 5099187, 5099006, 5099644, 5101313, 5100662, 5100742, 5098972, 5150988, 5099224, 5099144, 5433992, 5099598, 5099102, 5099009, 5101109, 5099333, 5230842, 5442829, 5101122, 5356808, 5099089, 5442830, 5442827, 5108786, 5442825, 5107470, 5112429, 5099137, 5257753, 5099904, 5099010, 5104848, 5241671, 5101238, 5099415, 5100827, 5099275, 5437369, 5099028, 5099300, 5099360, 5100738, 5099014, 5099807, 5099914, 5099206, 5099035, 5099190, 5099174, 5100238, 5101193, 5109641, 5102536, 5099250, 5147042, 5099329, 5099029, 5100624, 5438277, 5099549, 5101914, 5099169, 5101474, 5100916, 5099008, 5099867, 5099885, 5099947, 5099540, 5099111, 5207027, 5103882, 5440552, 5101521, 5170363, 5099271, 5100171, 5099724, 5100070, 5105834, 5334762, 5099162, 5105225, 5100027, 5116352, 5099382, 5100379, 5100376, 5100655, 5099167, 5099120, 5109721, 5099045, 5140569, 5220799, 5099646, 5110453, 5099577, 5101782, 5099782, 5099590, 5114876, 5099406, 5102250, 5099134, 5099176, 5297906, 5100874, 5099798, 5103799, 5100971, 5101463, 5434825, 5099609, 5099244, 5100181, 5105474);

Date: 2024-12-21 17:21:57 Duration: 4ms

10

371,731

Details

1m59s

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
Dec 21	00	3,321	1s40ms	0ms
	01	1,839	567ms	0ms
	02	2,196	708ms	0ms
	03	683	213ms	0ms
	04	468	144ms	0ms
	05	197	56ms	0ms
	06	1,653	515ms	0ms
	07	1,219	358ms	0ms
	08	9,363	2s874ms	0ms
	09	16,567	5s320ms	0ms
	10	31,629	10s365ms	0ms
	11	39,491	13s442ms	0ms
	12	43,063	13s887ms	0ms
	13	32,311	10s604ms	0ms
	14	26,381	8s586ms	0ms
	15	30,695	9s396ms	0ms
	16	29,956	9s414ms	0ms
	17	27,391	8s625ms	0ms
	18	26,275	8s58ms	0ms
	19	13,462	4s138ms	0ms
	20	17,176	5s894ms	0ms
	21	10,629	3s166ms	0ms
	22	5,766	1s622ms	0ms

SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.office' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 923) OR r.global) ORDER BY r.id;

Date: 2024-12-21 09:33:16 Duration: 3ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy.items' 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 = 1027) OR r.global) ORDER BY r.id;

Date: 2024-12-21 21:25:35 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1310) OR r.global) ORDER BY r.id;

Date: 2024-12-21 17:21:52 Duration: 2ms

11

355,087

Details

1m4s

0ms

17ms

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
Dec 21	00	3,443	645ms	0ms
	01	2,122	378ms	0ms
	02	2,965	541ms	0ms
	03	1,478	263ms	0ms
	04	1,404	253ms	0ms
	05	469	81ms	0ms
	06	2,299	388ms	0ms
	07	2,330	365ms	0ms
	08	11,541	1s784ms	0ms
	09	21,624	3s745ms	0ms
	10	30,101	5s667ms	0ms
	11	34,817	6s840ms	0ms
	12	34,215	6s438ms	0ms
	13	29,173	5s469ms	0ms
	14	28,920	5s227ms	0ms
	15	26,328	4s709ms	0ms
	16	24,846	4s492ms	0ms
	17	28,859	5s176ms	0ms
	18	22,173	3s861ms	0ms
	19	17,564	3s83ms	0ms
	20	15,925	3s166ms	0ms
	21	8,368	1s488ms	0ms
	22	4,123	711ms	0ms

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

Date: 2024-12-21 13:29:09 Duration: 17ms
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 (8006457);

Date: 2024-12-21 17:21:52 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 (8006595);

Date: 2024-12-21 17:21:52 Duration: 11ms

12

273,554

Details

47s237ms

0ms

1ms

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
Dec 21	00	2,994	428ms	0ms
	01	2,357	294ms	0ms
	02	2,424	322ms	0ms
	03	631	76ms	0ms
	04	465	55ms	0ms
	05	239	28ms	0ms
	06	1,052	154ms	0ms
	07	1,384	186ms	0ms
	08	8,705	1s318ms	0ms
	09	14,386	2s317ms	0ms
	10	23,170	4s196ms	0ms
	11	27,646	5s282ms	0ms
	12	30,122	5s511ms	0ms
	13	22,150	3s981ms	0ms
	14	19,431	3s311ms	0ms
	15	22,732	3s806ms	0ms
	16	21,646	3s688ms	0ms
	17	20,002	3s401ms	0ms
	18	18,927	3s194ms	0ms
	19	9,673	1s523ms	0ms
	20	11,876	2s320ms	0ms
	21	7,704	1s245ms	0ms
	22	3,838	588ms	0ms

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

Date: 2024-12-21 15:33:29 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-21 12:43:22 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');

Date: 2024-12-21 11:10:27 Duration: 1ms

13

238,984

Details

59s114ms

0ms

25ms

0ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 21	00	3,439	949ms	0ms
	01	2,059	508ms	0ms
	02	2,923	702ms	0ms
	03	1,638	387ms	0ms
	04	1,326	329ms	0ms
	05	1,252	314ms	0ms
	06	1,957	482ms	0ms
	07	1,488	372ms	0ms
	08	5,911	1s431ms	0ms
	09	13,036	3s407ms	0ms
	10	18,452	5s14ms	0ms
	11	19,477	5s435ms	0ms
	12	20,403	5s248ms	0ms
	13	18,226	4s265ms	0ms
	14	16,792	3s938ms	0ms
	15	17,414	3s742ms	0ms
	16	17,029	3s834ms	0ms
	17	18,876	4s856ms	0ms
	18	15,585	3s977ms	0ms
	19	14,370	3s366ms	0ms
	20	14,146	3s671ms	0ms
	21	8,826	1s902ms	0ms
	22	4,359	975ms	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 (41642642, 41643522, 41625524, 41386603, 41506125, 41467083, 41255802, 41357120, 41613660, 32639532, 32639178, 41240614, 41679419, 32634184, 41679512, 41467078, 41621896, 41621981, 41643281, 41622269, 41467071, 41686394, 41679182, 40792231, 32639794, 41680963, 41561339, 41679324, 41679213, 41623510, 41506341, 41625513, 41625619, 41680966, 41648615, 41561208, 32639793, 41256478, 41506620, 41256476, 41625195, 32633891, 41679150, 41411687, 32633896, 32640165, 41120306, 41698096, 41381172, 41332397, 41332436, 41680752, 41332406, 41622245, 41099728, 41643044, 41623269, 41623564, 41623584, 41623565, 40717831, 32639601, 41648549, 41597035, 40969139, 41585550, 41679003, 32638474, 32638575, 41678999, 32639623, 41566466, 41561977, 41681633, 41508537, 41332476, 32638682, 41680942, 41447785, 41369232, 41626218, 41623305, 32638375, 32640305, 32640297, 41539301, 41678918, 41504044, 32639200, 41506615, 41315916, 41523050, 41523045, 40930090, 32638688, 32638198, 41479403, 41678753, 41485130, 41381456);

Date: 2024-12-21 17:21:53 Duration: 25ms
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 (40574198, 40062914, 40322886, 40325732, 39844773, 40287968, 40100950, 40099253, 39836088, 40040175, 39837097, 40100949, 39866215, 40647930, 40262783, 40395445, 40172606, 40314821, 39708461, 39327829, 39900239, 39899676, 40193872, 32614496, 40147717, 39900399, 40698549, 40651086, 40188734, 40191362, 40438310, 40595657, 39866997, 40084862, 40351955, 39867242, 39867008, 39900404, 40171433, 40030410, 40547294, 41439953, 40564058, 40315105, 40473744, 40261298, 39936239, 40170744, 40135283, 40261371, 40361361, 40097440, 40325906, 40171441, 40492146, 40551697, 40314048, 40228923, 40521127, 40625447, 39871410, 40500047, 40536321, 40476384, 39647009, 39950772, 39882660, 39866739, 40564948, 40554192, 39647001, 40285108, 40388648, 40388647, 40551709, 40314354, 39883428, 39882017, 39883163, 39006591, 40534236, 39775218, 40183517, 39877778, 39877776, 39877817, 40911735, 39877816, 39877813, 40432405, 40358261, 40655471, 32598251, 39900403, 36878824, 40450335, 39877737, 39485584, 40458835, 39856824);

Date: 2024-12-21 17:21:53 Duration: 16ms
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 (39712315, 39715444, 39668343, 39600622, 39614023, 38907187, 39732927, 39801167, 39995651, 41504197, 39611922, 41620606, 39738412, 39385934, 40785513, 40795311, 39769709, 41701378, 39734930, 41373472, 41307090, 39838383, 38924920, 40537986, 39959732, 39795403, 41511144, 41608100, 39706708, 39648163, 40023025, 41541141, 41059354, 32646419, 41644643, 41654546, 41294933, 41616135, 41464290, 41280323, 41677172, 39670507, 41476326, 32634180, 32178642, 39978978, 32637062, 39539410, 39728696, 41358526, 41435098, 41730672, 39681256, 41563974, 39821050, 41119515, 39755741, 41322840, 39071114, 41620233, 41404176, 41373230, 41520086, 40660983, 41277352, 32634136, 41701797, 41541792, 41444971, 39734720, 39767356, 41620602, 39739697, 41624238, 41301312, 41615438, 41512783, 41661949, 41482898, 41483847, 38966547, 39202824, 32633773, 41369016, 39659823, 40385905, 32178644, 41351492, 40778888, 39542554, 32593116, 41546728, 38925865, 41616138, 41499327, 41701879, 41547341, 39708450, 40369476, 41487081);

Date: 2024-12-21 17:22:00 Duration: 14ms

14

216,455

Details

1d3h51m34s

385ms

1s429ms

463ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 21	00	9,200	1h9m17s	451ms
	01	4,506	33m26s	445ms
	02	7,890	58m38s	445ms
	03	3,627	26m50s	444ms
	04	3,181	23m12s	437ms
	05	2,224	17m11s	463ms
	06	2,698	20m19s	451ms
	07	844	6m40s	474ms
	08	4,237	31m3s	439ms
	09	8,980	1h7m53s	453ms
	10	16,431	2h9m55s	474ms
	11	18,778	2h32m23s	486ms
	12	14,176	1h51m29s	471ms
	13	12,285	1h36m14s	470ms
	14	10,136	1h18m28s	464ms
	15	8,230	1h3m4s	459ms
	16	9,779	1h16m56s	472ms
	17	12,021	1h31m57s	458ms
	18	13,167	1h40m4s	456ms
	19	14,804	1h54m1s	462ms
	20	22,828	3h1m18s	476ms
	21	10,873	1h20m10s	442ms
	22	5,560	40m56s	441ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3775920)) AND (("shipping_track"."id" not in (30823304, 30824733, 30825009, 30825183, 30930524, 30930629, 30930637, 30932274, 30932274)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 12:43:18 Duration: 1s429ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799843)) AND (("shipping_track"."id" not in (31018447, 31018447)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:59 Duration: 1s14ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799762)) AND (("shipping_track"."id" not in (31018134, 31018134)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:02 Duration: 999ms

15

177,395

Details

13s617ms

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
Dec 21	00	1,781	133ms	0ms
	01	1,302	90ms	0ms
	02	1,772	128ms	0ms
	03	1,038	67ms	0ms
	04	996	64ms	0ms
	05	302	18ms	0ms
	06	1,148	78ms	0ms
	07	940	59ms	0ms
	08	4,901	330ms	0ms
	09	11,503	884ms	0ms
	10	16,346	1s254ms	0ms
	11	16,758	1s415ms	0ms
	12	17,160	1s374ms	0ms
	13	15,050	1s280ms	0ms
	14	13,311	872ms	0ms
	15	13,256	852ms	0ms
	16	12,603	829ms	0ms
	17	14,460	1s69ms	0ms
	18	10,574	873ms	0ms
	19	8,596	726ms	0ms
	20	7,516	709ms	0ms
	21	4,048	329ms	0ms
	22	2,034	174ms	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: 2024-12-21 17:21:52 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: 2024-12-21 17:27:50 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: 2024-12-21 13:10:15 Duration: 0ms

16

159,545

Details

9s72ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1,441	75ms	0ms
	01	818	38ms	0ms
	02	933	48ms	0ms
	03	236	11ms	0ms
	04	147	7ms	0ms
	05	70	3ms	0ms
	06	654	34ms	0ms
	07	532	26ms	0ms
	08	3,974	209ms	0ms
	09	7,111	392ms	0ms
	10	13,681	807ms	0ms
	11	16,576	1s29ms	0ms
	12	18,594	1s87ms	0ms
	13	13,584	789ms	0ms
	14	10,998	623ms	0ms
	15	13,310	715ms	0ms
	16	13,107	729ms	0ms
	17	11,941	661ms	0ms
	18	11,393	628ms	0ms
	19	5,615	295ms	0ms
	20	7,467	475ms	0ms
	21	4,785	255ms	0ms
	22	2,578	128ms	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: 2024-12-21 14:10:28 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2024-12-21 12:53:42 Duration: 1ms
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);

Date: 2024-12-21 12:53:34 Duration: 0ms

17

154,357

Details

19s199ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1,398	160ms	0ms
	01	791	83ms	0ms
	02	899	101ms	0ms
	03	236	25ms	0ms
	04	147	14ms	0ms
	05	70	6ms	0ms
	06	636	71ms	0ms
	07	515	55ms	0ms
	08	3,874	448ms	0ms
	09	6,990	841ms	0ms
	10	13,309	1s713ms	0ms
	11	15,976	2s178ms	0ms
	12	17,958	2s281ms	0ms
	13	13,169	1s658ms	0ms
	14	10,766	1s336ms	0ms
	15	13,095	1s527ms	0ms
	16	12,678	1s536ms	0ms
	17	11,431	1s387ms	0ms
	18	10,991	1s335ms	0ms
	19	5,285	610ms	0ms
	20	7,078	1s22ms	0ms
	21	4,590	535ms	0ms
	22	2,475	267ms	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 (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-21 17:35:38 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (2, 10) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-21 10:46:25 Duration: 0ms
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-21 14:21:00 Duration: 0ms

18

137,728

Details

1h28m5s

28ms

200ms

38ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 21	00	2,435	1m28s	36ms
	01	1,236	45s215ms	36ms
	02	2,698	1m38s	36ms
	03	1,517	54s761ms	36ms
	04	1,032	37s914ms	36ms
	05	594	21s820ms	36ms
	06	789	28s993ms	36ms
	07	399	14s780ms	37ms
	08	3,178	1m56s	36ms
	09	7,137	4m29s	37ms
	10	11,975	7m50s	39ms
	11	14,536	9m46s	40ms
	12	12,197	7m58s	39ms
	13	10,435	6m44s	38ms
	14	8,065	5m7s	38ms
	15	7,150	4m30s	37ms
	16	6,977	4m25s	38ms
	17	8,708	5m30s	37ms
	18	8,627	5m23s	37ms
	19	9,576	6m4s	38ms
	20	8,974	6m1s	40ms
	21	5,986	3m38s	36ms
	22	3,507	2m7s	36ms

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

Date: 2024-12-21 20:02:27 Duration: 200ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2068788)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 20:02:27 Duration: 151ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3775920)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 12:43:17 Duration: 120ms

19

136,663

Details

42s209ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 21	00	7,745	2s368ms	0ms
	01	4,283	1s389ms	0ms
	02	6,599	2s183ms	0ms
	03	3,126	959ms	0ms
	04	2,235	769ms	0ms
	05	4,130	1s77ms	0ms
	06	3,627	1s75ms	0ms
	07	1,859	475ms	0ms
	08	1,341	443ms	0ms
	09	904	324ms	0ms
	10	1,687	864ms	0ms
	11	1,808	898ms	0ms
	12	1,235	562ms	0ms
	13	2,200	766ms	0ms
	14	2,945	918ms	0ms
	15	2,196	684ms	0ms
	16	7,473	2s194ms	0ms
	17	8,803	2s585ms	0ms
	18	14,305	4s144ms	0ms
	19	16,927	5s238ms	0ms
	20	21,654	6s876ms	0ms
	21	12,055	3s364ms	0ms
	22	7,526	2s44ms	0ms

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

Date: 2024-12-21 14:47:32 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 11) AND ("price_list"."to_office_id" = 26)) ORDER BY "price_list"."id";

Date: 2024-12-21 14:11:01 Duration: 2ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 65) AND ("price_list"."to_office_id" = 68)) ORDER BY "price_list"."id";

Date: 2024-12-21 17:22:13 Duration: 1ms

20

135,672

Details

27s6ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1,146	221ms	0ms
	01	693	121ms	0ms
	02	819	151ms	0ms
	03	267	47ms	0ms
	04	199	35ms	0ms
	05	83	14ms	0ms
	06	548	101ms	0ms
	07	452	80ms	0ms
	08	3,444	655ms	0ms
	09	6,451	1s261ms	0ms
	10	12,017	2s401ms	0ms
	11	14,319	2s994ms	0ms
	12	15,717	3s143ms	0ms
	13	11,524	2s346ms	0ms
	14	9,326	1s891ms	0ms
	15	11,355	2s173ms	0ms
	16	10,818	2s144ms	0ms
	17	9,847	1s948ms	0ms
	18	9,661	1s856ms	0ms
	19	5,011	963ms	0ms
	20	6,120	1s346ms	0ms
	21	3,860	742ms	0ms
	22	1,995	363ms	0ms

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

Date: 2024-12-21 17:21:52 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1111) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-21 17:21:52 Duration: 2ms
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (1078) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');

Date: 2024-12-21 17:21:52 Duration: 2ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

43m12s

46s967ms

283

Details

3h41m31s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 21	00	7	6ms	0ms
	01	6	2ms	0ms
	02	8	4ms	0ms
	06	2	0ms	0ms
	07	4	0ms	0ms
	08	14	2ms	0ms
	09	16	11ms	0ms
	10	16	22ms	1ms
	11	13	14ms	1ms
	12	13	19ms	1ms
	13	13	16ms	1ms
	14	12	12ms	1ms
	15	12	15ms	1ms
	16	21	23ms	1ms
	17	39	37ms	0ms
	18	42	38ms	0ms
	19	22	3h41m31s	10m4s
	20	13	16ms	1ms
	21	9	13ms	1ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 19:01:09.097318', "last_update" = '2024-12-21 18:16:09.097362', "logged_in" = true, "sid" = '3f370d79a34bb1175f367fb381ccd86e14021a08', "write_date" = '2024-12-21 18:16:08.653445', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 43m12s
UPDATE "res_users" SET "exp_date" = '2024-12-21 19:04:26.915343', "last_update" = '2024-12-21 18:19:26.915378', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:19:26.557711', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 39m54s
UPDATE "res_users" SET "exp_date" = '2024-12-21 19:09:18.305218', "last_update" = '2024-12-21 18:24:18.305251', "logged_in" = true, "sid" = '057a6dc7c7453302762659066ca436a9c4012d01', "write_date" = '2024-12-21 18:24:17.981734', "write_uid" = 1 WHERE id IN (884);

Date: 2024-12-21 19:59:21 Duration: 35m3s

2

0ms

6m25s

22s279ms

39

Details

14m28s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 21	00	2	0ms	0ms
	07	1	0ms	0ms
	08	2	0ms	0ms
	09	5	2ms	0ms
	10	2	2ms	1ms
	11	8	12m48s	1m36s
	12	5	6ms	1ms
	13	3	4ms	1ms
	14	2	0ms	0ms
	16	1	0ms	0ms
	18	1	1ms	1ms
	21	6	1m40s	16s769ms
	22	1	1ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 10:47:55.519103', "last_update" = '2024-12-21 10:02:55.519139', "write_date" = '2024-12-21 10:02:55.131762', "write_uid" = 1 WHERE id IN (1292);

Date: 2024-12-21 11:09:21 Duration: 6m25s
UPDATE "res_users" SET "exp_date" = '2024-12-21 10:48:23.223177', "last_update" = '2024-12-21 10:03:23.223221', "write_date" = '2024-12-21 10:03:22.775863', "write_uid" = 1 WHERE id IN (886);

Date: 2024-12-21 11:09:21 Duration: 5m57s
UPDATE "res_users" SET "exp_date" = '2024-12-21 20:47:39.679378', "last_update" = '2024-12-21 20:02:39.679400', "write_date" = '2024-12-21 20:02:39.345891', "write_uid" = 1223 WHERE id IN (1223);

Date: 2024-12-21 21:04:20 Duration: 1m40s

3

0ms

19m23s

21s750ms

345

Details

2h5m3s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 21	00	8	2ms	0ms
	01	3	0ms	0ms
	02	4	0ms	0ms
	06	4	2ms	0ms
	07	2	0ms	0ms
	08	16	3ms	0ms
	09	19	5ms	0ms
	10	29	25m32s	52s853ms
	11	37	39m31s	1m4s
	12	35	18m41s	32s40ms
	13	29	53s158ms	1s833ms
	14	25	36s891ms	1s475ms
	15	27	3m43s	8s288ms
	16	24	1m38s	4s114ms
	17	30	3m5s	6s169ms
	18	17	11m57s	42s201ms
	19	16	12ms	0ms
	20	14	19ms	1ms
	21	3	19m23s	6m27s
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-21 21:21:57.742764', "last_update" = '2024-12-21 20:36:57.742787', "sid" = 'e2b7a62d414695e8e6ef9aff340fb41f8744a9c6', "write_date" = '2024-12-21 20:36:57.408552', "write_uid" = 1 WHERE id IN (901);

Date: 2024-12-21 21:56:21 Duration: 19m23s
UPDATE "res_users" SET "exp_date" = '2024-12-21 10:16:48.938704', "last_update" = '2024-12-21 09:31:48.938739', "sid" = '2c5919c468edbab8e080145b75bcd4208a23d748', "write_date" = '2024-12-21 09:31:48.496516', "write_uid" = 1 WHERE id IN (841);

Date: 2024-12-21 10:45:21 Duration: 13m32s
UPDATE "res_users" SET "exp_date" = '2024-12-21 12:13:55.834712', "last_update" = '2024-12-21 11:28:55.834739', "sid" = '9d701320610541f97109ee45e014ad84588ba392', "write_date" = '2024-12-21 11:28:55.502696', "write_uid" = 1 WHERE id IN (959);

Date: 2024-12-21 12:36:20 Duration: 7m24s

4

0ms

59m59s

4s473ms

77,949

Details

4d52m19s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 21	00	709	16s955ms	23ms
	01	571	122ms	0ms
	02	841	187ms	0ms
	03	341	73ms	0ms
	04	292	63ms	0ms
	05	94	20ms	0ms
	06	376	84ms	0ms
	07	291	64ms	0ms
	08	1,465	324ms	0ms
	09	3,944	3h12m35s	2s929ms
	10	6,682	7h45m15s	4s177ms
	11	7,809	9h54m7s	4s564ms
	12	8,007	12h32m35s	5s639ms
	13	7,384	4h37m35s	2s255ms
	14	7,257	4h3m18s	2s11ms
	15	7,220	9h57m50s	4s968ms
	16	6,339	4h32m29s	2s579ms
	17	5,547	4h51m19s	3s151ms
	18	4,005	11h2m50s	9s930ms
	19	3,278	7h37m1s	8s365ms
	20	2,909	6h32m18s	8s91ms
	21	1,742	5h11m59s	10s745ms
	22	846	5h43s	21s327ms

update res_users set sid = '15b7e57df0412c5abf6f4517d56fa67b6746698b', last_update = '2024-12-21 12:37:36.315520', exp_date = '2024-12-21 13:22:36.315523', logged_in = 'TRUE' where id = 932;

Date: 2024-12-21 14:37:36 Duration: 59m59s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.500804', exp_date = '2024-12-21 18:37:12.500807', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-21 19:52:12 Duration: 59m59s
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-21 17:52:12.501195', exp_date = '2024-12-21 18:37:12.501199', logged_in = 'TRUE' where id = 1037;

Date: 2024-12-21 19:52:12 Duration: 59m59s

5

342ms

4s559ms

3s463ms

388

Details

22m23s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	09	9	34s75ms	3s786ms
	10	13	53s186ms	4s91ms
	11	29	1m55s	3s972ms
	12	57	3m26s	3s619ms
	13	30	1m43s	3s435ms
	14	36	1m59s	3s323ms
	15	73	3m59s	3s281ms
	16	17	57s151ms	3s361ms
	17	30	1m42s	3s410ms
	18	25	1m23s	3s355ms
	19	13	37s578ms	2s890ms
	20	25	1m32s	3s680ms
	21	21	1m8s	3s250ms
	22	10	31s663ms	3s166ms

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

Date: 2024-12-21 20:38:49 Duration: 4s559ms
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 (30))))))) 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 (30)))))) 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 (30)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30)))))) 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 (30))))))))) 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 (30)))))))) AND ("policy_number"."name"::text ilike '%9485654%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-21 20:39:13 Duration: 4s546ms
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 (126))))))) 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 (126)))))) 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 (126)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (126)))))) 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 (126))))))))) 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 (126)))))))) AND ("policy_number"."name"::text ilike '%8548049%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-21 10:55:16 Duration: 4s502ms

6

233ms

2s37ms

965ms

10,081

Details

2h42m16s

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
Dec 21	00	357	5m45s	967ms
	01	65	1m2s	966ms
	02	741	11m48s	956ms
	08	3	2s874ms	958ms
	09	4	3s993ms	998ms
	10	5	5s202ms	1s40ms
	12	1	975ms	975ms
	13	66	1m8s	1s36ms
	14	33	33s323ms	1s9ms
	15	84	1m22s	984ms
	16	687	11m30s	1s4ms
	17	490	8m2s	984ms
	18	1,646	24m52s	906ms
	19	1,622	25m51s	956ms
	20	1,402	25m16s	1s81ms
	21	2,030	31m38s	935ms
	22	845	13m10s	934ms

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

Date: 2024-12-21 20:02:29 Duration: 2s37ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9438886')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (110))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-21 20:02:13 Duration: 1s906ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9554943')) 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 (55))))))) 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 (55)))))) 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 (55)))))) 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 (55))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-21 20:02:29 Duration: 1s873ms

7

386ms

2s530ms

469ms

44,034

Details

5h44m51s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 21	00	269	2m6s	470ms
	01	116	57s468ms	495ms
	02	253	2m4s	490ms
	03	104	52s686ms	506ms
	04	85	43s226ms	508ms
	05	39	19s663ms	504ms
	06	156	1m11s	455ms
	07	126	55s442ms	440ms
	08	1,546	11m27s	444ms
	09	2,643	20m28s	464ms
	10	3,247	26m14s	485ms
	11	4,911	40m56s	500ms
	12	3,647	30m6s	495ms
	13	3,586	28m41s	480ms
	14	3,292	25m55s	472ms
	15	2,594	20m19s	469ms
	16	3,060	23m55s	469ms
	17	3,832	29m1s	454ms
	18	3,150	23m22s	445ms
	19	2,375	17m40s	446ms
	20	2,589	20m23s	472ms
	21	1,894	13m25s	425ms
	22	520	3m43s	429ms

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

Date: 2024-12-21 12:43:19 Duration: 2s530ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3785159, 3783422, 3774317, 3772116, 3768880, 3767586, 3767539, 3763741, 3763097, 3762226, 3751695, 3751238, 3751236, 3750696, 3745356, 3744288, 3744269, 3744192, 3742739, 3742588, 3742462, 3742454, 3742017, 3736072, 3733733, 3725026, 3724117, 3715009, 3710068, 3709766, 3699260, 3697907, 3684821, 3681316, 3642562, 3602033, 3574455, 3567305, 3489733)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 17:21:55 Duration: 1s377ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (2068788, 3165676, 3658806, 3275376)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:28 Duration: 1s221ms

8

385ms

1s429ms

463ms

216,455

Details

1d3h51m34s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	9,200	1h9m17s	451ms
	01	4,506	33m26s	445ms
	02	7,890	58m38s	445ms
	03	3,627	26m50s	444ms
	04	3,181	23m12s	437ms
	05	2,224	17m11s	463ms
	06	2,698	20m19s	451ms
	07	844	6m40s	474ms
	08	4,237	31m3s	439ms
	09	8,980	1h7m53s	453ms
	10	16,431	2h9m55s	474ms
	11	18,778	2h32m23s	486ms
	12	14,176	1h51m29s	471ms
	13	12,285	1h36m14s	470ms
	14	10,136	1h18m28s	464ms
	15	8,230	1h3m4s	459ms
	16	9,779	1h16m56s	472ms
	17	12,021	1h31m57s	458ms
	18	13,167	1h40m4s	456ms
	19	14,804	1h54m1s	462ms
	20	22,828	3h1m18s	476ms
	21	10,873	1h20m10s	442ms
	22	5,560	40m56s	441ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3775920)) AND (("shipping_track"."id" not in (30823304, 30824733, 30825009, 30825183, 30930524, 30930629, 30930637, 30932274, 30932274)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 12:43:18 Duration: 1s429ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799843)) AND (("shipping_track"."id" not in (31018447, 31018447)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:59 Duration: 1s14ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3799762)) AND (("shipping_track"."id" not in (31018134, 31018134)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-21 20:02:02 Duration: 999ms

9

345ms

543ms

427ms

2,139

Details

15m14s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	09	745	5m16s	425ms
	14	172	1m15s	439ms
	15	260	1m56s	446ms
	16	22	10s501ms	477ms
	17	29	12s518ms	431ms
	21	761	5m19s	419ms
	22	150	1m3s	424ms

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

Date: 2024-12-21 21:59:47 Duration: 543ms
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" = '8833697')) ORDER BY "cash_policy"."id" DESC;

Date: 2024-12-21 16:01:39 Duration: 530ms
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" = '469782')) ORDER BY "cash_policy"."id" DESC;

Date: 2024-12-21 09:51:18 Duration: 520ms

10

222ms

512ms

312ms

20,880

Details

1h48m50s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1,232	6m24s	312ms
	01	685	3m31s	308ms
	02	401	2m3s	309ms
	03	598	3m3s	306ms
	04	333	1m41s	303ms
	05	955	4m47s	301ms
	06	739	3m47s	308ms
	07	452	2m17s	303ms
	08	215	1m6s	309ms
	09	151	48s617ms	321ms
	10	41	13s676ms	333ms
	11	103	36s427ms	353ms
	12	105	36s100ms	343ms
	13	379	2m6s	332ms
	14	652	3m30s	323ms
	15	430	2m21s	328ms
	16	1,177	6m21s	324ms
	17	1,705	8m55s	313ms
	18	1,932	9m58s	309ms
	19	2,546	13m37s	321ms
	20	4,000	21m5s	316ms
	21	990	4m51s	293ms
	22	1,059	5m4s	287ms

SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477429')) 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: 2024-12-21 20:02:26 Duration: 512ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477447')) 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: 2024-12-21 20:02:16 Duration: 501ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9477449')) 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: 2024-12-21 20:02:21 Duration: 492ms

11

185ms

546ms

283ms

20,237

Details

1h35m39s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	08	874	3m48s	261ms
	09	1,865	8m39s	278ms
	10	1,600	7m57s	298ms
	11	1,407	7m16s	310ms
	12	2,239	10m50s	290ms
	13	3,497	16m36s	285ms
	14	2,639	12m38s	287ms
	15	2,259	10m23s	276ms
	16	1,311	6m9s	281ms
	17	1,330	6m	270ms
	18	804	3m32s	264ms
	19	412	1m44s	254ms

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

Date: 2024-12-21 12:43:24 Duration: 546ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_sender') AND ("collection_policy"."shipping_id" in ( SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE ("shipping_policy__policy_id"."name" = '9073247')))) ORDER BY "collection_policy"."id";

Date: 2024-12-21 12:43:21 Duration: 496ms
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" = '9331793')))) ORDER BY "collection_policy"."id";

Date: 2024-12-21 12:43:17 Duration: 488ms

12

176ms

366ms

236ms

5,988

Details

23m34s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 21	06	380	1m22s	217ms
	07	415	1m30s	218ms
	08	100	22s233ms	222ms
	09	1,794	6m53s	230ms
	10	1,366	5m41s	250ms
	11	1,440	5m52s	245ms
	13	62	14s436ms	232ms
	14	298	1m8s	230ms
	15	3	669ms	223ms
	16	44	9s781ms	222ms
	18	50	10s537ms	210ms
	19	18	3s358ms	186ms
	20	13	2s662ms	204ms
	21	5	980ms	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" = '9393353')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-21 11:03:11 Duration: 326ms

13

177ms

1s62ms

234ms

87,106

Details

5h40m7s

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 21	00	5,866	21m54s	224ms
	01	1,213	4m23s	217ms
	02	2,135	7m46s	218ms
	03	531	1m54s	214ms
	04	1,007	3m42s	220ms
	05	387	1m25s	219ms
	06	1,159	4m12s	217ms
	07	662	2m24s	218ms
	08	2,330	8m34s	220ms
	09	7,288	27m53s	229ms
	10	5,640	22m45s	242ms
	11	6,764	27m38s	245ms
	12	5,499	22m	240ms
	13	6,950	27m13s	235ms
	14	6,597	25m35s	232ms
	15	6,958	26m51s	231ms
	16	3,662	13m57s	228ms
	17	3,779	13m39s	216ms
	18	1,810	6m11s	205ms
	19	7,504	29m9s	233ms
	20	9,318	40m44s	262ms
	21	22	4s370ms	198ms
	22	25	4s918ms	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" = '9428578')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:01:20 Duration: 1s62ms
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" = '9375304')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:02:02 Duration: 1s15ms
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" = '9314548')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-21 20:02:26 Duration: 633ms

14

178ms

392ms

230ms

11,047

Details

42m24s

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
Dec 21	00	37	8s100ms	218ms
	01	89	19s415ms	218ms
	02	219	47s503ms	216ms
	03	61	13s85ms	214ms
	04	60	13s126ms	218ms
	06	581	2m7s	218ms
	07	225	49s211ms	218ms
	08	440	1m37s	221ms
	09	1,734	6m35s	227ms
	10	738	2m57s	240ms
	11	1,914	7m43s	241ms
	12	1,023	4m2s	236ms
	13	510	2m2s	239ms
	14	1,136	4m20s	229ms
	15	909	3m29s	230ms
	16	310	1m12s	233ms
	17	625	2m13s	213ms
	18	202	40s996ms	202ms
	19	80	16s156ms	201ms
	20	129	31s863ms	247ms
	21	17	3s375ms	198ms
	22	8	1s565ms	195ms

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" = '9149439')) 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 (128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) 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: 2024-12-21 12:43:24 Duration: 392ms
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" = '9539097')) 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 (128)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (128))))) 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: 2024-12-21 12:43:20 Duration: 385ms
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" = '9456641')) 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 (52)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (52))))) 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: 2024-12-21 20:38:50 Duration: 367ms

15

92ms

868ms

228ms

61,056

Details

3h52m58s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	3,146	10m26s	199ms
	01	1,480	5m	202ms
	02	2,262	7m3s	187ms
	03	1,172	4m26s	227ms
	04	654	2m38s	241ms
	05	1,890	6m5s	193ms
	06	1,466	4m37s	189ms
	07	892	3m15s	219ms
	08	424	1m30s	214ms
	09	300	55s441ms	184ms
	10	74	15s105ms	204ms
	11	204	45s880ms	224ms
	12	198	33s138ms	167ms
	13	860	3m28s	242ms
	14	1,345	5m6s	227ms
	15	1,004	4m9s	248ms
	16	3,647	13m25s	220ms
	17	4,321	17m43s	246ms
	18	7,091	28m12s	238ms
	19	8,261	33m	239ms
	20	10,677	43m7s	242ms
	21	5,957	21m55s	220ms
	22	3,731	15m15s	245ms

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

Date: 2024-12-21 19:15:35 Duration: 868ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالرحمن')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-21 19:15:35 Duration: 868ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-21 19:16:07 Duration: 859ms

16

182ms

255ms

218ms

5,203

Details

18m56s

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
Dec 21	00	808	2m55s	216ms
	01	988	3m35s	218ms
	02	1,648	6m	218ms
	03	210	45s352ms	215ms
	04	947	3m28s	220ms
	05	387	1m25s	219ms
	06	198	42s869ms	216ms
	22	17	3s372ms	198ms

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

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

Date: 2024-12-21 01:12:45 Duration: 254ms

17

120ms

753ms

144ms

5,615

Details

13m31s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	10	1s317ms	131ms
	02	20	2s633ms	131ms
	07	15	1s987ms	132ms
	08	21	2s819ms	134ms
	09	212	29s388ms	138ms
	10	734	1m46s	145ms
	11	1,174	2m57s	150ms
	12	1,190	2m53s	145ms
	13	596	1m24s	142ms
	14	370	51s438ms	139ms
	15	267	37s111ms	138ms
	16	169	23s669ms	140ms
	17	260	37s343ms	143ms
	18	167	23s469ms	140ms
	19	115	15s959ms	138ms
	20	134	20s833ms	155ms
	21	79	10s523ms	133ms
	22	82	10s789ms	131ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) 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: 2024-12-21 12:43:18 Duration: 753ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 4)) 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: 2024-12-21 11:10:20 Duration: 313ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-21 20:39:11 Duration: 282ms

18

75ms

168ms

93ms

17,855

Details

27m46s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	1	95ms	95ms
	02	2	186ms	93ms
	08	286	26s65ms	91ms
	09	685	1m4s	93ms
	10	1,257	1m58s	94ms
	11	1,369	2m14s	98ms
	12	1,876	2m57s	94ms
	13	1,580	2m28s	93ms
	14	1,298	2m	93ms
	15	3,473	5m14s	90ms
	16	1,321	2m1s	91ms
	17	1,060	1m39s	93ms
	18	662	1m2s	94ms
	19	839	1m21s	96ms
	20	751	1m14s	99ms
	21	1,069	1m34s	88ms
	22	326	28s90ms	86ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7809025)) AND (("cash_track"."id" not in (5650781, 5661442, 5673949, 5999779, 6000791, 6000801, 6000801)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 12:43:19 Duration: 168ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7819687)) AND (("cash_track"."id" not in (5722807, 5728264, 5729083, 5999778, 6000790, 6000800, 6000800)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 12:43:19 Duration: 164ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7822778)) AND (("cash_track"."id" not in (5742662, 5764667, 5776021, 6007106, 6007106)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-21 15:12:12 Duration: 161ms

19

34ms

113ms

44ms

40,999

Details

30m35s

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

Day	Hour	Count	Duration	Avg duration
Dec 21	00	9	399ms	44ms
	06	21	920ms	43ms
	07	9	412ms	45ms
	08	1,766	1m14s	41ms
	09	4,422	3m11s	43ms
	10	2,865	2m9s	45ms
	11	3,242	2m33s	47ms
	12	2,806	2m10s	46ms
	13	4,345	3m15s	44ms
	14	5,552	4m6s	44ms
	15	5,195	3m48s	44ms
	16	3,093	2m16s	44ms
	17	3,237	2m24s	44ms
	18	1,974	1m28s	44ms
	19	1,637	1m14s	45ms
	20	487	24s94ms	49ms
	21	257	11s409ms	44ms
	22	82	3s647ms	44ms

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

Date: 2024-12-21 17:21:56 Duration: 113ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3657823) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2024-12-21 17:36:21 Duration: 112ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3691282) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-21 20:39:41 Duration: 92ms

20

28ms

200ms

38ms

137,728

Details

1h28m5s

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
Dec 21	00	2,435	1m28s	36ms
	01	1,236	45s215ms	36ms
	02	2,698	1m38s	36ms
	03	1,517	54s761ms	36ms
	04	1,032	37s914ms	36ms
	05	594	21s820ms	36ms
	06	789	28s993ms	36ms
	07	399	14s780ms	37ms
	08	3,178	1m56s	36ms
	09	7,137	4m29s	37ms
	10	11,975	7m50s	39ms
	11	14,536	9m46s	40ms
	12	12,197	7m58s	39ms
	13	10,435	6m44s	38ms
	14	8,065	5m7s	38ms
	15	7,150	4m30s	37ms
	16	6,977	4m25s	38ms
	17	8,708	5m30s	37ms
	18	8,627	5m23s	37ms
	19	9,576	6m4s	38ms
	20	8,974	6m1s	40ms
	21	5,986	3m38s	36ms
	22	3,507	2m7s	36ms

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

Date: 2024-12-21 20:02:27 Duration: 200ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (2068788)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 20:02:27 Duration: 151ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3775920)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-21 12:43:17 Duration: 120ms

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

Chart
Table

Type	Count	Percentage
CONTEXT	15	0.00%
DETAIL	17	0.00%
ERROR	8,311	0.05%
EVENTLOG	1,823	0.01%
FATAL	1,357	0.01%
HINT	6	0.00%
LOG	18,111,194	99.89%
STATEMENT	8,345	0.05%

Events distribution (except queries)

Key values

0 PANIC entries
1357 FATAL entries
8311 ERROR entries
0 WARNING entries
1823 EVENTLOG entries

Most Frequent Errors/Events

Key values

4,261 Max number of times the same event was reported
11,491 Total events found

Rank

Times reported

Error

1

4,261

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 21	00	21
	01	9
	02	9
	03	1
	05	2
	06	8
	07	3
	08	37
	09	119
	10	304
	11	493
	12	576
	13	503
	14	635
	15	569
	16	368
	17	303
	18	94
	19	55
	20	68
	21	55
	22	29

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

2

4,018

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 21	00	17
	01	6
	02	7
	03	1
	05	1
	06	6
	07	2
	08	36
	09	104
	10	298
	11	453
	12	550
	13	486
	14	607
	15	534
	16	356
	17	287
	18	86
	19	50
	20	49
	21	53
	22	29

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

3

1,203

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 21	09	26
	10	95
	11	150
	12	145
	13	158
	14	115
	15	142
	16	100
	17	39
	18	88
	19	29
	20	29
	21	64
	22	23

4

1,203

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 21	09	26
	10	95
	11	150
	12	145
	13	158
	14	115
	15	142
	16	100
	17	39
	18	88
	19	29
	20	29
	21	64
	22	23

5

419

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 21	09	6
	10	36
	11	61
	12	82
	13	33
	14	15
	15	53
	16	29
	17	27
	18	45
	19	18
	20	3
	21	2
	22	9

6

200

Details

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

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 21	09	3
	10	20
	11	25
	12	53
	13	12
	14	6
	15	22
	16	12
	17	16
	18	18
	19	4
	20	2
	22	7

7

89

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 21	17	89

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

8

22

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 21	17	22

9

20

Details

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

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 21	17	20

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

10

8

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 21	10	1
	11	1
	12	2
	13	2
	14	1
	17	1

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

11

7

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 21	12	2
	13	1
	14	2
	17	2

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

12

6

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 21	03	1
	10	1
	12	1
	15	1
	17	1
	20	1

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

13

5

Details

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

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 21	00	1
	05	2
	18	1
	20	1

14

5

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 21	00	1
	05	2
	18	1
	20	1

15

5

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 21	00	1
	05	2
	18	1
	20	1

16

4

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 21	17	4

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

17

3

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 21	14	3

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

18

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 21	17	3

19

3

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 21	17	2
	20	1

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

20

3

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 21	05	1
	10	1
	12	1

21

1

Details

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

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Dec 21	14	1

22

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #22

Day	Hour	Count
Dec 21	17	1

23

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #23

Day	Hour	Count
Dec 21	12	1

ERROR: could not serialize access due to concurrent delete

24

1

Details

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

Times Reported Most Frequent Error / Event #24

Day	Hour	Count
Dec 21	15	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