pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Jan 31 23:46:42 2025
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 24,381,469 log entries in 1m41s
Log start from 2025-01-31 00:00:00 to 2025-01-31 22:45:01

Global Stats

10,743 Number of unique normalized queries
10,615,177 Number of queries
5d17h1m28s Total query duration
2025-01-31 00:00:00 First query
2025-01-31 22:45:01 Last query
1,826 queries/s at 2025-01-31 18:56:17 Query peak

5d17h1m28s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
5d17h1m28s Execute total duration

2,892 Number of events
21 Number of unique normalized events
927 Max number of times the same event was reported
0 Number of cancellation

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

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

0 Total number of sessions
0 sessions at Session peak
0ms Total duration of sessions
0ms Average duration of sessions
10,615,177 Average queries per session
5d17h1m28s 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

1,826 queries/s Query Peak
2025-01-31 18:56:17 Date

SELECT Traffic

Key values

964 queries/s Query Peak
2025-01-31 18:56:17 Date

INSERT/UPDATE/DELETE Traffic

Key values

1,006 queries/s Query Peak
2025-01-31 15:19:55 Date

Queries duration

Key values

5d17h1m28s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 31	00	274,021	0ms	45m2s	228ms	2m48s	3m47s	12h34m40s
	01	404,310	0ms	55m57s	116ms	4m25s	5m6s	10h24m5s
	02	281,534	0ms	3s8ms	24ms	3m24s	3m47s	4m58s
	03	284,093	0ms	2s427ms	30ms	4m20s	4m59s	5m29s
	04	183,224	0ms	2s685ms	26ms	2m12s	3m4s	5m9s
	05	145,229	0ms	4s518ms	27ms	1m51s	2m16s	3m59s
	06	132,978	0ms	4s521ms	31ms	2m2s	2m10s	2m51s
	07	58,808	0ms	749ms	13ms	38s501ms	51s81ms	1m4s
	08	209,943	0ms	933ms	10ms	1m24s	1m50s	2m17s
	09	523,543	0ms	15m41s	44ms	4m38s	7m20s	4h30m12s
	10	751,893	0ms	59m59s	45ms	5m16s	1h26m57s	2h7m58s
	11	578,938	0ms	59m59s	27ms	4m50s	6m2s	2h1m9s
	12	766,837	0ms	7m26s	21ms	5m11s	6m59s	1h31m44s
	13	975,641	0ms	23m18s	35ms	6m36s	7m29s	3h56m16s
	14	768,430	0ms	32m31s	55ms	5m26s	8m30s	6h27m20s
	15	928,293	0ms	22m56s	40ms	6m32s	7m1s	6h24m20s
	16	799,184	0ms	40m7s	72ms	7m35s	11m40s	8h16m38s
	17	729,966	0ms	26m25s	44ms	5m32s	6m3s	5h49m11s
	18	556,315	0ms	5m12s	22ms	6m32s	7m9s	8m21s
	19	532,627	0ms	1h2s	45ms	6m33s	8m41s	3h8m35s
	20	329,486	0ms	3s280ms	19ms	2m55s	3m23s	4m11s
	21	237,552	0ms	59m59s	46ms	1m57s	2m11s	2h11m9s
	22	162,332	0ms	2s962ms	13ms	1m49s	2m2s	2m5s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 31	00	156,013	31ms	1m56s	2m40s	3m29s
	01	230,625	42ms	3m40s	4m13s	5m5s
	02	148,335	46ms	2m54s	3m24s	4m4s
	03	149,988	57ms	3m24s	4m19s	5m12s
	04	88,526	53ms	1m57s	2m12s	3m45s
	05	76,099	52ms	1m33s	1m51s	2m42s
	06	74,286	55ms	1m52s	2m1s	2m13s
	07	25,337	31ms	29s908ms	38s436ms	59s921ms
	08	117,228	18ms	1m7s	1m24s	2m3s
	09	307,059	23ms	3m10s	4m25s	7m19s
	10	447,084	18ms	3m25s	3m47s	4m26s
	11	323,921	26ms	3m6s	4m34s	5m55s
	12	450,391	23ms	4m5s	4m59s	6m58s
	13	594,474	25ms	5m29s	6m27s	6m36s
	14	444,523	26ms	4m24s	5m15s	6m43s
	15	553,368	26ms	5m6s	5m58s	6m38s
	16	476,776	25ms	4m41s	5m44s	10m55s
	17	440,223	25ms	4m23s	5m3s	5m32s
	18	327,403	35ms	4m43s	5m45s	6m47s
	19	306,560	40ms	4m51s	5m27s	8m40s
	20	180,213	35ms	2m24s	2m54s	3m31s
	21	130,850	24ms	1m28s	1m49s	2m11s
	22	89,535	24ms	1m25s	1m49s	2m4s

Day	Hour	INSERT	UPDATE	DELETE	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Jan 31	00	18,321	4,647	144	2s502ms	113ms	168ms	281ms
	01	36,071	8,925	168	826ms	231ms	260ms	378ms
	02	22,634	6,269	132	0ms	135ms	175ms	244ms
	03	28,800	7,164	132	0ms	175ms	228ms	317ms
	04	13,045	4,385	145	0ms	89ms	106ms	157ms
	05	13,607	3,247	154	0ms	76ms	102ms	150ms
	06	16,461	3,522	132	0ms	105ms	131ms	184ms
	07	2,553	880	128	0ms	19ms	31ms	42ms
	08	7,906	2,646	263	0ms	52ms	68ms	107ms
	09	23,281	7,194	407	524ms	145ms	226ms	414ms
	10	32,512	8,726	501	631ms	210ms	273ms	1h25m32s
	11	30,450	8,988	369	181ms	171ms	220ms	477ms
	12	39,720	10,399	623	108ms	242ms	287ms	453ms
	13	51,440	14,826	486	286ms	306ms	377ms	5s519ms
	14	37,424	12,991	559	606ms	228ms	267ms	22s867ms
	15	52,634	16,641	900	328ms	291ms	381ms	54s495ms
	16	37,586	15,428	467	865ms	267ms	353ms	2m51s
	17	42,268	14,095	532	372ms	314ms	380ms	2m7s
	18	34,692	9,225	428	20ms	250ms	341ms	2m28s
	19	35,686	11,388	365	246ms	225ms	311ms	3m10s
	20	21,984	7,121	263	0ms	120ms	147ms	223ms
	21	14,133	3,630	203	435ms	81ms	116ms	240ms
	22	10,155	2,258	140	0ms	75ms	113ms	182ms

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

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

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

114,766 buffers Checkpoint Peak
2025-01-31 20:56:25 Date
270.065 seconds Highest write time
0.020 seconds Sync time

Checkpoints Wal files

Key values

72 files Wal files usage Peak
2025-01-31 20:56:25 Date

Checkpoints distance

Key values

2,291.69 Mo Distance Peak
2025-01-31 20:56:25 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Jan 31	00	98,879	3,239.57s	0.029s	3,239.64s
	01	206,545	3,239.468s	0.04s	3,239.565s
	02	167,409	3,239.642s	0.038s	3,239.728s
	03	159,732	3,239.567s	0.033s	3,239.653s
	04	112,574	3,239.578s	0.026s	3,239.65s
	05	79,374	3,390.075s	0.029s	3,390.143s
	06	56,322	3,083.524s	0.028s	3,083.583s
	07	12,846	1,274.721s	0.028s	1,274.774s
	08	70,406	2,946.088s	0.035s	2,946.161s
	09	167,290	3,239.619s	0.04s	3,239.702s
	10	254,436	3,239.486s	0.041s	3,239.597s
	11	235,180	3,239.566s	0.038s	3,239.672s
	12	301,227	3,239.535s	0.045s	3,239.643s
	13	342,605	3,239.543s	0.047s	3,239.653s
	14	304,619	3,239.513s	0.038s	3,239.623s
	15	332,839	3,239.562s	0.046s	3,239.673s
	16	249,146	3,239.529s	0.042s	3,239.629s
	17	209,366	2,885.695s	0.077s	2,885.828s
	18	189,365	3,239.566s	0.051s	3,239.668s
	19	219,535	3,239.461s	0.058s	3,239.579s
	20	226,721	3,239.633s	0.035s	3,239.726s
	21	84,889	3,239.549s	0.032s	3,239.616s
	22	57,634	2,429.659s	0.024s	2,429.712s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Jan 31	00	44	3,140	0.002s	0.012s
	01	93	4,305	0.002s	0.012s
	02	75	3,221	0.006s	0.012s
	03	76	2,808	0.002s	0.012s
	04	55	2,117	0.002s	0.012s
	05	37	2,839	0.002s	0.013s
	06	26	2,939	0.002s	0.012s
	07	5	1,352	0.009s	0.011s
	08	29	2,683	0.010s	0.012s
	09	72	3,854	0.002s	0.012s
	10	111	4,410	0.002s	0.012s
	11	106	4,430	0.002s	0.012s
	12	136	4,772	0.002s	0.012s
	13	151	4,882	0.002s	0.012s
	14	137	4,671	0.002s	0.012s
	15	146	5,107	0.003s	0.012s
	16	106	5,239	0.002s	0.012s
	17	90	5,091	0.014s	0.012s
	18	85	4,809	0.003s	0.012s
	19	96	4,986	0.019s	0.012s
	20	122	4,145	0.002s	0.012s
	21	30	4,152	0.002s	0.012s
	22	18	2,595	0.002s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Jan 31	00	60,618.67 kB	88,819.42 kB
	01	126,430.25 kB	150,455.00 kB
	02	102,720.33 kB	140,094.25 kB
	03	104,315.83 kB	127,754.83 kB
	04	74,571.50 kB	116,396.00 kB
	05	47,158.31 kB	76,544.92 kB
	06	34,599.75 kB	56,337.17 kB
	07	7,981.91 kB	33,229.91 kB
	08	40,108.67 kB	43,045.17 kB
	09	98,501.83 kB	135,532.75 kB
	10	153,678.82 kB	211,107.82 kB
	11	144,907.42 kB	220,442.08 kB
	12	186,070.42 kB	204,124.58 kB
	13	206,282.33 kB	252,068.08 kB
	14	186,704.33 kB	229,794.75 kB
	15	199,640.08 kB	233,064.58 kB
	16	144,118.42 kB	213,600.50 kB
	17	122,128.55 kB	153,596.27 kB
	18	115,295.08 kB	139,937.75 kB
	19	131,672.17 kB	215,499.42 kB
	20	165,848.83 kB	210,870.33 kB
	21	42,592.45 kB	662,746.64 kB
	22	32,655.11 kB	232,382.67 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

6,138,817 Total read queries
3,057,586 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	6,138,817	57.83%
INSERT	623,363	5.87%
UPDATE	184,595	1.74%
DELETE	7,641	0.07%
COPY FROM	0	0.00%
COPY TO	0	0.00%
CTE	13,602	0.13%
DDL	1,197	0.01%
TCL	2,227,188	20.98%
CURSOR	0	0.00%
OTHERS	1,418,774	13.37%

Queries by database

Key values

unknown Main database
10,615,177 Requests
5d17h1m28s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	10,615,177	5d17h1m28s
	cte	13,602	2s804ms
	ddl	1,197	159ms
	delete	7,641	1s35ms
	insert	623,363	3m7s
	others	1,418,774	1m4s
	select	6,138,817	2d2h26m36s
	tcl	2,227,188	1m33s
	update	184,595	3d14h29m2s

Queries by user

Key values

unknown Main user
10,615,177 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	10,615,177	5d17h1m28s
	cte	13,602	2s804ms
	ddl	1,197	159ms
	delete	7,641	1s35ms
	insert	623,363	3m7s
	others	1,418,774	1m4s
	select	6,138,817	2d2h26m36s
	tcl	2,227,188	1m33s
	update	184,595	3d14h29m2s

Duration by user

Key values

5d17h1m28s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	10,615,177	5d17h1m28s
	cte	13,602	2s804ms
	ddl	1,197	159ms
	delete	7,641	1s35ms
	insert	623,363	3m7s
	others	1,418,774	1m4s
	select	6,138,817	2d2h26m36s
	tcl	2,227,188	1m33s
	update	184,595	3d14h29m2s

Queries by host

Key values

unknown Main host
10,615,177 Requests
5d17h1m28s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	10,615,177	5d17h1m28s
	cte	13,602	2s804ms
	ddl	1,197	159ms
	delete	7,641	1s35ms
	insert	623,363	3m7s
	others	1,418,774	1m4s
	select	6,138,817	2d2h26m36s
	tcl	2,227,188	1m33s
	update	184,595	3d14h29m2s

Queries by application

Key values

unknown Main application
10,615,177 Requests
5d17h1m28s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	10,615,177	5d17h1m28s
	cte	13,602	2s804ms
	ddl	1,197	159ms
	delete	7,641	1s35ms
	insert	623,363	3m7s
	others	1,418,774	1m4s
	select	6,138,817	2d2h26m36s
	tcl	2,227,188	1m33s
	update	184,595	3d14h29m2s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2025-01-31 21:16:38 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

9,813,893 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	9,813,893	92.45%
1-5ms	172,132	1.62%
5-10ms	6,569	0.06%
10-25ms	26,473	0.25%
25-50ms	81,100	0.76%
50-100ms	94,302	0.89%
100-500ms	213,654	2.01%
500-1000ms	206,097	1.94%
1000-10000ms	446	0.00%
> 10000ms	511	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h2s	update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.283221', exp_date = '2025-01-31 17:51:07.283225', logged_in = 'TRUE' where id = 854; [ Date: 2025-01-31 19:06:10 ]
2	1h2s	update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.282693', exp_date = '2025-01-31 17:51:07.282696', logged_in = 'TRUE' where id = 854; [ Date: 2025-01-31 19:06:10 ]
3	59m59s	update res_users set sid = '1943a91668cba1c065cc59ee914a053e8f14a119', last_update = '2025-01-31 09:51:56.523527', exp_date = '2025-01-31 10:36:56.523530', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-31 11:51:56 ]
4	59m59s	update res_users set sid = '186b2b49902caf6fac399aff2af73e95d2d7920c', last_update = '2025-01-31 19:10:29.068989', exp_date = '2025-01-31 19:55:29.068992', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-31 21:10:28 ]
5	59m59s	update res_users set sid = '186b2b49902caf6fac399aff2af73e95d2d7920c', last_update = '2025-01-31 19:10:29.069405', exp_date = '2025-01-31 19:55:29.069408', logged_in = 'TRUE' where id = 857; [ Date: 2025-01-31 21:10:28 ]
6	59m59s	update res_users set sid = '6f9ec9f9c894b04651341d227584941fe27476fc', last_update = '2025-01-31 09:51:45.426456', exp_date = '2025-01-31 10:36:45.426460', logged_in = 'TRUE' where id = 1423; [ Date: 2025-01-31 11:51:45 ]
7	59m59s	UPDATE "res_users" SET "exp_date" = '2025-01-31 08:52:19.516591', "last_update" = '2025-01-31 08:07:19.516613', "write_date" = '2025-01-31 08:07:19.182770', "write_uid" = 965 WHERE id IN (965); [ Date: 2025-01-31 10:07:19 ]
8	59m3s	update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:07:06.245929', exp_date = '2025-01-31 17:52:06.245933', logged_in = 'TRUE' where id = 854; [ Date: 2025-01-31 19:06:10 ]
9	55m57s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:43:23.947749', exp_date = '2025-01-31 00:28:23.947752', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
10	50m18s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:49:03.311156', exp_date = '2025-01-31 00:34:03.311160', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
11	48m57s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:50:23.505574', exp_date = '2025-01-31 00:35:23.505579', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
12	48m13s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:51:08.155908', exp_date = '2025-01-31 00:36:08.155912', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
13	45m2s	update res_users set sid = '7d2fab061dcc04e588b309306d576e818eaaf7c8', last_update = '2025-01-30 22:39:18.587847', exp_date = '2025-01-30 23:24:18.587850', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-31 00:24:21 ]
14	45m2s	update res_users set sid = '7d2fab061dcc04e588b309306d576e818eaaf7c8', last_update = '2025-01-30 22:39:18.587427', exp_date = '2025-01-30 23:24:18.587431', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-31 00:24:21 ]
15	44m21s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:54:59.553957', exp_date = '2025-01-31 00:39:59.553959', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
16	43m59s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:55:21.569166', exp_date = '2025-01-31 00:40:21.569171', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
17	43m20s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:56:01.055182', exp_date = '2025-01-31 00:41:01.055186', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
18	42m49s	update res_users set sid = '7d2fab061dcc04e588b309306d576e818eaaf7c8', last_update = '2025-01-30 22:41:31.207340', exp_date = '2025-01-30 23:26:31.207345', logged_in = 'TRUE' where id = 847; [ Date: 2025-01-31 00:24:21 ]
19	42m39s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:56:41.534651', exp_date = '2025-01-31 00:41:41.534654', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]
20	42m19s	update res_users set sid = 'ec41230570c7299c83efb8bfb236b74b0d9d77b6', last_update = '2025-01-30 23:57:01.384014', exp_date = '2025-01-31 00:42:01.384022', logged_in = 'TRUE' where id = 1211; [ Date: 2025-01-31 01:39:21 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

3d8h59m32s

34,823

Details

0ms

1h2s

8s372ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 31	00	893	16h3m46s	1m4s
	01	1,275	8h23m8s	23s677ms
	02	1,089	244ms	0ms
	03	1,051	239ms	0ms
	04	675	146ms	0ms
	05	407	91ms	0ms
	06	219	49ms	0ms
	07	140	31ms	0ms
	08	566	123ms	0ms
	09	1,589	4h29m38s	10s181ms
	10	2,424	6h8m	9s109ms
	11	1,684	2h	4s275ms
	12	2,650	1h31m16s	2s66ms
	13	3,242	5h18m39s	5s897ms
	14	2,798	8h13m33s	10s583ms
	15	3,295	6h21m52s	6s953ms
	16	2,662	10h57m53s	14s828ms
	17	2,329	5h51m39s	9s59ms
	18	1,880	15m8s	483ms
	19	1,842	3h14m42s	6s342ms
	20	997	212ms	0ms
	21	627	2h10m10s	12s456ms
	22	489	99ms	0ms

update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.283221', exp_date = '2025-01-31 17:51:07.283225', logged_in = 'TRUE' where id = 854;

Date: 2025-01-31 19:06:10 Duration: 1h2s
update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.282693', exp_date = '2025-01-31 17:51:07.282696', logged_in = 'TRUE' where id = 854;

Date: 2025-01-31 19:06:10 Duration: 1h2s
update res_users set sid = '1943a91668cba1c065cc59ee914a053e8f14a119', last_update = '2025-01-31 09:51:56.523527', exp_date = '2025-01-31 10:36:56.523530', logged_in = 'TRUE' where id = 847;

Date: 2025-01-31 11:51:56 Duration: 59m59s

2

1d4h47m51s

174,642

Details

520ms

1s224ms

593ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5,545	54m32s	590ms
	01	10,329	1h43m2s	598ms
	02	8,508	1h22m11s	579ms
	03	10,388	1h41m59s	589ms
	04	6,057	57m35s	570ms
	05	4,258	41m39s	587ms
	06	3,897	39m34s	609ms
	07	893	8m22s	562ms
	08	1,964	18m33s	567ms
	09	6,329	1h2m37s	593ms
	10	8,374	1h21m20s	582ms
	11	7,428	1h13m4s	590ms
	12	10,335	1h43m	598ms
	13	12,224	2h5m8s	614ms
	14	8,924	1h28m15s	593ms
	15	12,378	2h5m47s	609ms
	16	7,881	1h21m2s	617ms
	17	9,447	1h33m24s	593ms
	18	13,202	2h10m27s	592ms
	19	13,989	2h18m22s	593ms
	20	6,725	1h3m53s	570ms
	21	3,353	32m21s	579ms
	22	2,214	21m32s	583ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4913939)) AND (("shipping_track"."id" not in (40736981, 40739407, 40739938, 40885946, 40886103, 40912614, 40913559, 40926922, 40978707, 40978707)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:50 Duration: 1s224ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947038)) AND (("shipping_track"."id" not in (40978713, 40978713)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:51 Duration: 1s97ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947036)) AND (("shipping_track"."id" not in (40978685, 40978685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:46 Duration: 1s94ms

3

5h40m20s

99,820

Details

162ms

388ms

204ms

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 31	00	938	3m5s	198ms
	01	2,933	9m46s	200ms
	02	2,939	9m42s	198ms
	03	2,682	9m2s	202ms
	04	2,612	8m37s	198ms
	05	1,557	5m7s	197ms
	06	665	2m12s	199ms
	07	475	1m36s	203ms
	08	1,312	4m20s	198ms
	09	5,069	17m20s	205ms
	10	2,340	7m54s	202ms
	11	6,925	23m48s	206ms
	12	3,817	13m6s	206ms
	13	10,162	35m38s	210ms
	14	8,795	30m31s	208ms
	15	7,346	25m40s	209ms
	16	13,963	51m20s	220ms
	17	9,190	31m9s	203ms
	18	4,969	15m25s	186ms
	19	7,268	23m	189ms
	20	3,678	11m18s	184ms
	21	168	30s452ms	181ms
	22	17	3s84ms	181ms

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

Date: 2025-01-31 16:33:52 Duration: 388ms
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" = '123487')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:34:56 Duration: 375ms
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" = '124593')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:35:01 Duration: 369ms

4

4h38m49s

27,470

Details

520ms

1s784ms

609ms

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 31	00	154	1m40s	650ms
	01	339	3m39s	646ms
	02	189	2m7s	676ms
	03	236	2m40s	680ms
	04	170	1m51s	656ms
	05	151	1m31s	604ms
	06	140	1m26s	617ms
	07	35	22s904ms	654ms
	08	603	5m47s	576ms
	09	1,601	16m8s	604ms
	10	2,044	20m31s	602ms
	11	1,470	14m46s	603ms
	12	2,947	30m4s	612ms
	13	2,411	25m29s	634ms
	14	2,592	26m22s	610ms
	15	3,679	37m54s	618ms
	16	1,990	20m19s	612ms
	17	2,041	20m11s	593ms
	18	2,062	20m16s	589ms
	19	1,287	12m50s	599ms
	20	731	6m59s	574ms
	21	349	3m22s	579ms
	22	249	2m22s	570ms

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

Date: 2025-01-31 17:22:11 Duration: 1s784ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4822827, 4808277, 4806181, 4803919, 4803205, 4797904, 4797014, 4796018, 4793626, 4792605, 4791037, 4790921, 4790097, 4789064, 4753887, 4687466)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 17:22:11 Duration: 1s323ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4940196, 4940057, 4924323, 4926325, 4927463, 4940028, 4916492, 4919220, 4808278, 4918150, 4917091, 4912407, 4914491, 4945432, 4914606, 4923526)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:41 Duration: 1s266ms

5

3h56m12s

144

Details

0ms

22m22s

1m38s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5	3ms	0ms
	01	16	1h45m33s	6m35s
	02	1	1ms	1ms
	03	1	1ms	1ms
	04	2	3ms	1ms
	08	3	1ms	0ms
	09	6	7ms	1ms
	10	10	2m39s	15s981ms
	11	3	4ms	1ms
	12	9	7ms	0ms
	13	8	10ms	1ms
	14	13	14m22s	1m6s
	15	18	18ms	1ms
	16	19	1h53m36s	5m58s
	17	9	10ms	1ms
	18	6	6ms	1ms
	19	3	2ms	0ms
	20	3	3ms	1ms
	21	6	3ms	0ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 01:01:58.533012', "last_update" = '2025-01-31 00:16:58.533032', "sid" = 'ab6ed4a88a72cd7cefb4c73299c469e23cc551da', "write_date" = '2025-01-31 00:16:58.207160', "write_uid" = 1 WHERE id IN (1211);

Date: 2025-01-31 01:39:21 Duration: 22m22s
UPDATE "res_users" SET "exp_date" = '2025-01-31 16:19:23.668331', "last_update" = '2025-01-31 15:34:23.668365', "sid" = 'a83618e54c78abd1c0265095e1012ad345560503', "write_date" = '2025-01-31 15:34:23.198288', "write_uid" = 1 WHERE id IN (861);

Date: 2025-01-31 16:55:21 Duration: 20m57s
UPDATE "res_users" SET "exp_date" = '2025-01-31 01:03:36.151896', "last_update" = '2025-01-31 00:18:36.151916', "sid" = 'ab6ed4a88a72cd7cefb4c73299c469e23cc551da', "write_date" = '2025-01-31 00:18:35.820222', "write_uid" = 1 WHERE id IN (1211);

Date: 2025-01-31 01:39:21 Duration: 20m45s

6

1h57m45s

24,159

Details

186ms

636ms

292ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 31	08	431	1m49s	254ms
	09	2,241	10m18s	275ms
	10	1,313	6m17s	287ms
	11	2,797	13m19s	285ms
	12	2,211	10m43s	291ms
	13	4,896	23m48s	291ms
	14	4,033	20m50s	309ms
	15	2,691	13m9s	293ms
	16	2,849	13m54s	292ms
	17	697	3m35s	309ms

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

Date: 2025-01-31 12:04:55 Duration: 636ms
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" = '31863')))) ORDER BY "collection_policy"."id";

Date: 2025-01-31 12:05:19 Duration: 620ms
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" = '137444')))) ORDER BY "collection_policy"."id";

Date: 2025-01-31 14:34:19 Duration: 612ms

7

1h52m59s

29,143

Details

97ms

814ms

232ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,380	9m9s	230ms
	01	3,768	13m57s	222ms
	02	1,120	4m47s	256ms
	03	2,718	10m48s	238ms
	05	1,742	6m36s	227ms
	06	3,344	12m49s	230ms
	07	4	930ms	232ms
	08	70	12s44ms	172ms
	09	2	477ms	238ms
	10	144	34s135ms	237ms
	11	168	34s220ms	203ms
	12	82	17s779ms	216ms
	13	208	49s766ms	239ms
	14	140	35s907ms	256ms
	15	1,094	4m39s	255ms
	16	1,382	6m9s	267ms
	17	3,172	12m31s	237ms
	18	1,456	5m26s	224ms
	19	1,650	6m48s	247ms
	20	1,564	5m28s	210ms
	21	1,603	5m49s	218ms
	22	1,332	4m50s	217ms

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

Date: 2025-01-31 06:09:04 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-31 06:09:04 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محل')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-31 06:07:19 Duration: 796ms

8

1h27m4s

40

Details

0ms

59m59s

2m10s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 31	00	4	2ms	0ms
	01	3	11m59s	3m59s
	08	1	1ms	1ms
	09	1	1ms	1ms
	10	7	1h8m12s	9m44s
	11	3	2ms	0ms
	12	3	4ms	1ms
	13	4	6ms	1ms
	14	3	6m52s	2m17s
	15	3	4ms	1ms
	17	3	4ms	1ms
	19	2	0ms	0ms
	21	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 08:52:19.516591', "last_update" = '2025-01-31 08:07:19.516613', "write_date" = '2025-01-31 08:07:19.182770', "write_uid" = 965 WHERE id IN (965);

Date: 2025-01-31 10:07:19 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 01:12:22.033870', "last_update" = '2025-01-31 00:27:22.033891', "write_date" = '2025-01-31 00:27:21.716855', "write_uid" = 1 WHERE id IN (1295);

Date: 2025-01-31 01:39:21 Duration: 11m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 10:12:08.146853', "last_update" = '2025-01-31 09:27:08.146876', "write_date" = '2025-01-31 09:27:07.813715', "write_uid" = 1 WHERE id IN (865);

Date: 2025-01-31 10:35:21 Duration: 8m13s

9

1h17m50s

97,277

Details

37ms

194ms

48ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,823	2m8s	45ms
	01	4,898	3m45s	46ms
	02	2,960	2m14s	45ms
	03	3,444	2m36s	45ms
	04	1,451	1m6s	45ms
	05	1,174	53s413ms	45ms
	06	1,089	49s231ms	45ms
	07	570	26s92ms	45ms
	08	1,526	1m9s	45ms
	09	4,924	3m53s	47ms
	10	6,332	4m52s	46ms
	11	6,621	5m7s	46ms
	12	7,577	5m58s	47ms
	13	10,652	8m35s	48ms
	14	6,990	5m29s	47ms
	15	9,252	7m21s	47ms
	16	6,480	5m12s	48ms
	17	4,779	4m4s	51ms
	18	4,322	3m50s	53ms
	19	3,504	3m9s	54ms
	20	2,479	2m8s	51ms
	21	2,185	1m53s	51ms
	22	1,245	1m4s	51ms

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

Date: 2025-01-31 17:22:10 Duration: 194ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4941421)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 17:22:11 Duration: 112ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4940196)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 16:33:39 Duration: 106ms

10

53m37s

5,038

Details

213ms

1s211ms

638ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	476	2m55s	368ms
	01	921	10m36s	691ms
	02	169	43s578ms	257ms
	05	123	30s684ms	249ms
	08	15	13s135ms	875ms
	09	1	863ms	863ms
	10	32	26s205ms	818ms
	11	43	41s562ms	966ms
	13	23	22s396ms	973ms
	14	47	37s510ms	798ms
	15	78	1m13s	936ms
	16	85	1m19s	934ms
	17	356	5m18s	895ms
	18	422	5m53s	836ms
	19	517	6m36s	767ms
	20	590	6m57s	707ms
	21	575	5m39s	590ms
	22	565	3m31s	374ms

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

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

Date: 2025-01-31 19:24:54 Duration: 1s159ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '260670')) 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 (70))))))) 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 (70)))))) 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 (70)))))) 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 (70))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-31 19:09:25 Duration: 1s116ms

11

45m34s

9,700

Details

212ms

501ms

281ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 31	00	725	3m19s	275ms
	01	979	4m35s	281ms
	02	399	1m49s	273ms
	03	1,380	6m23s	277ms
	05	755	3m29s	277ms
	06	1,679	7m44s	276ms
	07	2	531ms	265ms
	08	21	5s613ms	267ms
	10	47	13s177ms	280ms
	11	43	11s913ms	277ms
	12	45	13s778ms	306ms
	13	83	25s487ms	307ms
	14	24	7s472ms	311ms
	15	477	2m28s	311ms
	16	615	3m9s	308ms
	17	1,252	6m	287ms
	18	319	1m24s	266ms
	19	315	1m33s	296ms
	20	197	50s880ms	258ms
	21	235	58s847ms	250ms
	22	108	28s868ms	267ms

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

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

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

Date: 2025-01-31 16:33:49 Duration: 462ms

12

39m1s

40,372

Details

44ms

131ms

57ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 31	08	640	35s637ms	55ms
	09	3,655	3m32s	58ms
	10	1,896	1m47s	56ms
	11	4,839	4m34s	56ms
	12	2,998	2m55s	58ms
	13	8,169	8m7s	59ms
	14	4,819	4m36s	57ms
	15	7,273	7m2s	58ms
	16	3,591	3m30s	58ms
	17	2,255	2m5s	55ms
	18	103	5s459ms	53ms
	19	45	2s444ms	54ms
	20	64	3s354ms	52ms
	21	15	800ms	53ms
	22	10	544ms	54ms

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

Date: 2025-01-31 16:33:41 Duration: 131ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4858775) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:42 Duration: 103ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4858267) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:42 Duration: 95ms

13

38m47s

11,599

Details

176ms

271ms

200ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	640	2m8s	200ms
	01	2,674	8m54s	199ms
	02	2,841	9m27s	199ms
	03	2,086	7m14s	208ms
	04	2,217	7m17s	197ms
	05	1,134	3m44s	197ms
	22	7	1s274ms	182ms

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

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

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

Date: 2025-01-31 03:40:18 Duration: 262ms

14

29m16s

8,894

Details

165ms

293ms

197ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 31	00	138	27s68ms	196ms
	01	239	48s431ms	202ms
	03	11	2s161ms	196ms
	05	119	23s444ms	197ms
	06	139	27s692ms	199ms
	07	458	1m33s	203ms
	08	368	1m14s	201ms
	09	95	18s871ms	198ms
	10	241	49s367ms	204ms
	11	110	21s727ms	197ms
	12	265	55s115ms	207ms
	13	1,066	3m46s	212ms
	14	765	2m37s	205ms
	15	332	1m10s	212ms
	16	172	35s647ms	207ms
	17	379	1m13s	194ms
	18	1,057	3m20s	189ms
	19	1,814	5m44s	189ms
	20	986	3m	183ms
	21	132	24s5ms	181ms
	22	8	1s459ms	182ms

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

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

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

Date: 2025-01-31 19:06:20 Duration: 276ms

15

16m48s

19,354

Details

39ms

98ms

52ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 31	08	324	16s127ms	49ms
	09	1,927	1m39s	51ms
	10	915	46s547ms	50ms
	11	2,438	2m6s	51ms
	12	1,714	1m28s	51ms
	13	3,880	3m27s	53ms
	14	3,151	2m44s	52ms
	15	2,426	2m5s	51ms
	16	1,832	1m36s	52ms
	17	742	37s428ms	50ms
	18	5	258ms	51ms

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

Date: 2025-01-31 16:34:13 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4860509) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:31 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4859936) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:31 Duration: 85ms

16

14m17s

7,229

Details

96ms

178ms

118ms

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 31	00	67	7s425ms	110ms
	01	21	2s535ms	120ms
	02	2	237ms	118ms
	05	16	1s804ms	112ms
	06	6	675ms	112ms
	08	97	11s352ms	117ms
	09	232	27s838ms	119ms
	10	389	45s936ms	118ms
	11	254	30s22ms	118ms
	12	839	1m38s	117ms
	13	1,161	2m17s	118ms
	14	866	1m41s	117ms
	15	1,543	3m2s	118ms
	16	489	57s441ms	117ms
	17	476	57s75ms	119ms
	18	230	29s284ms	127ms
	19	300	36s805ms	122ms
	20	167	19s368ms	115ms
	21	58	6s886ms	118ms
	22	16	1s927ms	120ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8062168)) AND (("cash_track"."id" not in (7532339, 7550492, 7552295, 7569741, 7569741)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 17:23:06 Duration: 178ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067055)) AND (("cash_track"."id" not in (7568112)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 16:34:06 Duration: 170ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067477)) AND (("cash_track"."id" not in (7570478)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 18:22:23 Duration: 168ms

17

11m56s

2,726

Details

203ms

425ms

262ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 31	00	120	31s956ms	266ms
	01	120	32s676ms	272ms
	02	120	32s132ms	267ms
	03	120	32s409ms	270ms
	04	120	31s986ms	266ms
	05	120	32s17ms	266ms
	06	120	31s661ms	263ms
	07	120	31s550ms	262ms
	08	120	31s696ms	264ms
	09	120	33s65ms	275ms
	10	120	32s602ms	271ms
	11	120	32s730ms	272ms
	12	120	33s100ms	275ms
	13	120	34s400ms	286ms
	14	120	33s307ms	277ms
	15	120	34s400ms	286ms
	16	120	33s602ms	280ms
	17	116	29s42ms	250ms
	18	120	28s495ms	237ms
	19	120	28s408ms	236ms
	20	120	27s464ms	228ms
	21	120	27s290ms	227ms
	22	90	20s347ms	226ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 16:35:02 Duration: 425ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 16:35:01 Duration: 376ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 12:05:02 Duration: 353ms

18

7m28s

159

Details

0ms

3s938ms

2s820ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	02	1	3s8ms	3s8ms
	06	1	2s958ms	2s958ms
	10	1	666ms	666ms
	11	5	14s634ms	2s926ms
	12	7	21s268ms	3s38ms
	13	12	30s66ms	2s505ms
	14	1	3s130ms	3s130ms
	15	30	1m21s	2s710ms
	16	20	52s49ms	2s602ms
	17	11	34s483ms	3s134ms
	18	19	52s247ms	2s749ms
	19	28	1m24s	3s27ms
	20	17	50s512ms	2s971ms
	21	5	14s448ms	2s889ms
	22	1	2s962ms	2s962ms

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

Date: 2025-01-31 16:34:43 Duration: 3s938ms
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 (32))))))) 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 (32)))))) 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 (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) 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 (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%4%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-31 17:00:31 Duration: 3s668ms
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 (32))))))) 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 (32)))))) 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 (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) 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 (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%42229%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-31 17:00:32 Duration: 3s466ms

19

6m28s

2,804

Details

118ms

290ms

138ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	15	1s946ms	129ms
	01	36	4s849ms	134ms
	02	2	266ms	133ms
	04	16	2s49ms	128ms
	05	5	633ms	126ms
	06	7	919ms	131ms
	07	5	657ms	131ms
	09	55	7s490ms	136ms
	10	296	40s357ms	136ms
	11	235	31s752ms	135ms
	12	470	1m4s	137ms
	13	412	58s391ms	141ms
	14	299	41s757ms	139ms
	15	250	35s718ms	142ms
	16	211	30s669ms	145ms
	17	189	26s241ms	138ms
	18	122	16s535ms	135ms
	19	54	7s416ms	137ms
	20	21	2s785ms	132ms
	21	79	10s410ms	131ms
	22	25	3s287ms	131ms

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

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

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

Date: 2025-01-31 16:33:47 Duration: 244ms

20

5m16s

1,217

Details

208ms

518ms

260ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 31	00	28	7s466ms	266ms
	01	61	15s642ms	256ms
	02	74	19s644ms	265ms
	03	68	17s359ms	255ms
	04	64	15s641ms	244ms
	05	39	9s660ms	247ms
	06	7	1s723ms	246ms
	07	10	2s459ms	245ms
	08	20	5s6ms	250ms
	09	89	23s417ms	263ms
	10	43	11s205ms	260ms
	11	113	29s192ms	258ms
	12	52	13s752ms	264ms
	13	91	24s816ms	272ms
	14	85	22s824ms	268ms
	15	64	17s301ms	270ms
	16	92	24s815ms	269ms
	17	73	18s744ms	256ms
	18	46	11s279ms	245ms
	19	63	16s356ms	259ms
	20	24	5s404ms	225ms
	21	8	1s805ms	225ms
	22	3	921ms	307ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('227219', '55977', '143260', '142532', '9877343', '55963', '142524', '143267');

Date: 2025-01-31 19:24:51 Duration: 518ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9984293', '9984955', '9984020', '9984018', '9732946', '9984011', '9984834', '9984860');

Date: 2025-01-31 16:39:45 Duration: 488ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9613121', '9905941', '9796181', '9796167', '9613080');

Date: 2025-01-31 13:56:12 Duration: 462ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

1,418,056

Details

1m4s

0ms

3ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 31	00	37,928	1s433ms	0ms
	01	49,271	2s163ms	0ms
	02	40,750	1s599ms	0ms
	03	38,251	1s567ms	0ms
	04	30,340	1s217ms	0ms
	05	21,064	900ms	0ms
	06	15,645	694ms	0ms
	07	12,783	415ms	0ms
	08	32,896	1s268ms	0ms
	09	71,445	3s2ms	0ms
	10	99,280	4s222ms	0ms
	11	83,442	3s780ms	0ms
	12	100,432	5s54ms	0ms
	13	118,731	5s509ms	0ms
	14	105,283	5s215ms	0ms
	15	117,219	5s566ms	0ms
	16	104,178	4s764ms	0ms
	17	89,644	4s7ms	0ms
	18	72,041	3s406ms	0ms
	19	69,685	3s451ms	0ms
	20	47,925	2s251ms	0ms
	21	35,853	1s558ms	0ms
	22	23,970	1s17ms	0ms

DISCARD ALL;

Date: 2025-01-31 14:31:32 Duration: 3ms
DISCARD ALL;

Date: 2025-01-31 03:13:03 Duration: 1ms
DISCARD ALL;

Date: 2025-01-31 14:28:41 Duration: 1ms

2

1,113,899

Details

16s293ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 31	00	28,158	396ms	0ms
	01	39,368	593ms	0ms
	02	31,646	448ms	0ms
	03	29,850	447ms	0ms
	04	23,366	354ms	0ms
	05	15,480	260ms	0ms
	06	11,437	206ms	0ms
	07	8,554	138ms	0ms
	08	24,408	354ms	0ms
	09	56,637	796ms	0ms
	10	81,181	1s111ms	0ms
	11	65,616	928ms	0ms
	12	82,125	1s261ms	0ms
	13	96,907	1s416ms	0ms
	14	83,268	1s270ms	0ms
	15	93,019	1s379ms	0ms
	16	81,539	1s190ms	0ms
	17	70,824	969ms	0ms
	18	55,840	816ms	0ms
	19	54,287	801ms	0ms
	20	35,919	522ms	0ms
	21	26,365	374ms	0ms
	22	18,105	253ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-31 09:36:50 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-31 11:43:40 Duration: 0ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2025-01-31 17:39:39 Duration: 0ms

3

726,260

Details

7s188ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 31	00	19,618	177ms	0ms
	01	25,400	257ms	0ms
	02	20,968	207ms	0ms
	03	19,734	205ms	0ms
	04	15,799	148ms	0ms
	05	11,136	106ms	0ms
	06	8,412	82ms	0ms
	07	6,984	58ms	0ms
	08	17,153	147ms	0ms
	09	36,506	362ms	0ms
	10	50,358	498ms	0ms
	11	42,397	412ms	0ms
	12	51,034	534ms	0ms
	13	60,242	652ms	0ms
	14	53,609	547ms	0ms
	15	59,542	611ms	0ms
	16	53,172	535ms	0ms
	17	45,745	443ms	0ms
	18	37,016	355ms	0ms
	19	35,600	350ms	0ms
	20	24,596	221ms	0ms
	21	18,665	164ms	0ms
	22	12,574	106ms	0ms

ROLLBACK;

Date: 2025-01-31 09:42:29 Duration: 0ms
ROLLBACK;

Date: 2025-01-31 18:13:36 Duration: 0ms
ROLLBACK;

Date: 2025-01-31 19:23:42 Duration: 0ms

4

713,485

Details

2m16s

0ms

16ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 31	00	18,907	3s549ms	0ms
	01	24,606	5s247ms	0ms
	02	20,336	4s156ms	0ms
	03	19,084	4s46ms	0ms
	04	15,156	2s841ms	0ms
	05	10,549	2s11ms	0ms
	06	7,795	1s512ms	0ms
	07	6,345	818ms	0ms
	08	16,514	2s511ms	0ms
	09	35,898	6s877ms	0ms
	10	49,825	9s613ms	0ms
	11	42,056	8s95ms	0ms
	12	50,761	10s584ms	0ms
	13	59,851	12s651ms	0ms
	14	53,095	10s865ms	0ms
	15	59,208	11s832ms	0ms
	16	52,652	10s494ms	0ms
	17	45,129	8s242ms	0ms
	18	36,394	6s302ms	0ms
	19	35,109	6s83ms	0ms
	20	24,112	3s859ms	0ms
	21	18,018	2s521ms	0ms
	22	12,085	1s630ms	0ms

SELECT payload FROM http_sessions WHERE sid = '03eb0542cf50016fe03f36a3d73f83b894966da4';

Date: 2025-01-31 12:39:48 Duration: 16ms
SELECT payload FROM http_sessions WHERE sid = '55ad6d9d80d8f2d5ff8677f7a5e2e6597de5c777';

Date: 2025-01-31 02:09:26 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = '115631cede3945e3eeaf8c00ea3fab6fec477bb7';

Date: 2025-01-31 12:39:48 Duration: 10ms

5

709,910

Details

1m3s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 31	00	18,974	1s569ms	0ms
	01	24,661	2s283ms	0ms
	02	20,460	1s830ms	0ms
	03	19,202	1s765ms	0ms
	04	15,263	1s326ms	0ms
	05	10,628	950ms	0ms
	06	7,903	727ms	0ms
	07	6,467	489ms	0ms
	08	16,515	1s288ms	0ms
	09	35,746	3s270ms	0ms
	10	49,610	4s423ms	0ms
	11	41,798	3s737ms	0ms
	12	50,235	4s785ms	0ms
	13	59,375	5s749ms	0ms
	14	52,623	4s814ms	0ms
	15	58,601	5s436ms	0ms
	16	52,069	4s751ms	0ms
	17	44,812	4s	0ms
	18	36,028	3s208ms	0ms
	19	34,897	3s159ms	0ms
	20	24,040	2s28ms	0ms
	21	17,996	1s462ms	0ms
	22	12,007	925ms	0ms

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

Date: 2025-01-31 14:15:30 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-31 03:27:55 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2025-01-31 12:56:59 Duration: 0ms

6

497,420

Details

1m13s

0ms

10ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 31	00	10,658	1s563ms	0ms
	01	18,895	2s642ms	0ms
	02	13,652	1s951ms	0ms
	03	12,228	1s916ms	0ms
	04	8,521	1s388ms	0ms
	05	4,988	948ms	0ms
	06	3,463	723ms	0ms
	07	1,507	434ms	0ms
	08	9,677	1s443ms	0ms
	09	27,372	3s727ms	0ms
	10	41,971	5s430ms	0ms
	11	29,584	4s200ms	0ms
	12	40,601	5s898ms	0ms
	13	48,529	6s909ms	0ms
	14	38,018	6s88ms	0ms
	15	42,717	6s321ms	0ms
	16	35,703	5s147ms	0ms
	17	32,047	4s482ms	0ms
	18	23,481	3s655ms	0ms
	19	23,373	3s648ms	0ms
	20	13,984	2s194ms	0ms
	21	9,367	1s446ms	0ms
	22	7,084	1s5ms	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 (1214);

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

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

Date: 2025-01-31 17:21:55 Duration: 9ms

7

387,029

Details

1m9s

0ms

33ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 31	00	8,477	1s449ms	0ms
	01	13,936	2s671ms	0ms
	02	10,680	2s106ms	0ms
	03	10,117	2s384ms	0ms
	04	7,566	1s622ms	0ms
	05	4,344	892ms	0ms
	06	3,026	686ms	0ms
	07	1,570	308ms	0ms
	08	7,229	1s184ms	0ms
	09	20,122	3s301ms	0ms
	10	30,680	5s275ms	0ms
	11	23,228	3s890ms	0ms
	12	31,055	5s559ms	0ms
	13	36,600	6s718ms	0ms
	14	29,574	5s131ms	0ms
	15	33,443	6s267ms	0ms
	16	28,298	5s22ms	0ms
	17	25,046	4s315ms	0ms
	18	18,805	3s543ms	0ms
	19	18,698	3s559ms	0ms
	20	11,325	1s942ms	0ms
	21	7,699	1s190ms	0ms
	22	5,511	851ms	0ms

COMMIT;

Date: 2025-01-31 12:56:54 Duration: 33ms
COMMIT;

Date: 2025-01-31 17:31:18 Duration: 30ms
COMMIT;

Date: 2025-01-31 11:06:28 Duration: 30ms

8

295,045

Details

37s189ms

0ms

6ms

0ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 31	00	7,134	856ms	0ms
	01	11,945	1s535ms	0ms
	02	8,103	1s34ms	0ms
	03	7,830	967ms	0ms
	04	3,011	380ms	0ms
	05	3,062	378ms	0ms
	06	3,129	330ms	0ms
	07	373	45ms	0ms
	08	5,487	622ms	0ms
	09	16,607	2s226ms	0ms
	10	27,608	3s647ms	0ms
	11	16,792	2s154ms	0ms
	12	25,108	3s505ms	0ms
	13	28,088	4s4ms	0ms
	14	21,163	2s627ms	0ms
	15	24,025	2s894ms	0ms
	16	19,646	2s556ms	0ms
	17	20,235	2s295ms	0ms
	18	13,377	1s595ms	0ms
	19	13,677	1s591ms	0ms
	20	8,387	898ms	0ms
	21	5,484	530ms	0ms
	22	4,774	509ms	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 (5122092, 5101567, 5099224, 5099007, 5100246, 5334206, 5099698, 5099130, 5104709, 5101066, 5099009, 5170186, 5099010, 5177202, 5099121, 5100464, 5122044, 5099028, 5100540, 5370165, 5099254, 5099190, 5100980, 5099956, 5099037, 5132134, 5099014, 5099102, 5401326, 5099006, 5099092, 5099819, 5099679, 5152253, 5100259, 5099144, 5110117, 5151449, 5101623, 5100163, 5098987, 5099947, 5100804, 5099333, 5109980, 5099309, 5100420, 5099413, 5099857, 5099277, 5099120, 5099403, 5099804, 5099013, 5108738, 5105468, 5099684, 5117663, 5099523, 5109804, 5101628, 5099737, 5099404, 5109007, 5110822, 5119519, 5099719, 5273917, 5174225, 5217980, 5099119, 5099236, 5101367, 5109608, 5100024, 5106354);

Date: 2025-01-31 17:21:58 Duration: 6ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5118664, 5100246, 5197499, 5116614, 5099264, 5099651, 5103145, 5098976, 5108030, 5146758, 5163349, 5099857, 5099488, 5099761, 5177701, 5102821, 5099137, 5100786, 5099403, 5099010, 5108738, 5099141, 5099804, 5100205, 5377840, 5099009, 5102481, 5160860, 5099528, 5099263, 5099321, 5099181, 5134698, 5100302, 5100486, 5099045, 5105761, 5100669, 5099007, 5120507, 5106172, 5121112, 5105492, 5099737, 5099724, 5390027, 5099196, 5102342, 5104250, 5104396, 5113941, 5100207, 5100001, 5099415, 5107762, 5101169, 5101935, 5122066, 5099119, 5109050, 5101969, 5099277, 5099896, 5117645, 5165454, 5099814, 5117663, 5099590, 5099130, 5103741, 5154740, 5099139, 5099013, 5100762, 5099920);

Date: 2025-01-31 17:21:58 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 (5099343, 5100936, 5119622, 5248901, 5104885, 5099045, 5099008, 5099182, 5111228, 5100714, 5099904, 5149370, 5099930, 5099420, 5100421, 5099169, 5099646, 5099138, 5099924, 5099356, 5110922, 5101642, 5099148, 5144163, 5104783, 5134296, 5099590, 5123952, 5399939, 5100822, 5098985, 5099251, 5099515, 5132237, 5099264, 5099525, 5102148, 5170032, 5105916, 5100431, 5100468, 5111196, 5100477, 5102372, 5099489, 5103061, 5100327, 5099272, 5099035, 5099521, 5099282, 5101160);

Date: 2025-01-31 17:21:58 Duration: 4ms

9

288,058

Details

16s982ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5,825	304ms	0ms
	01	9,264	546ms	0ms
	02	6,363	352ms	0ms
	03	5,472	316ms	0ms
	04	2,677	149ms	0ms
	05	2,163	124ms	0ms
	06	1,920	124ms	0ms
	07	517	31ms	0ms
	08	5,079	258ms	0ms
	09	15,263	867ms	0ms
	10	25,084	1s418ms	0ms
	11	16,192	904ms	0ms
	12	24,227	1s481ms	0ms
	13	28,121	1s850ms	0ms
	14	22,238	1s283ms	0ms
	15	27,260	1s623ms	0ms
	16	21,597	1s337ms	0ms
	17	20,242	1s224ms	0ms
	18	14,684	837ms	0ms
	19	15,260	930ms	0ms
	20	8,811	463ms	0ms
	21	5,698	346ms	0ms
	22	4,101	205ms	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 (119);

Date: 2025-01-31 17:21:55 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 (128, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 16, 17, 19, 22, 24, 26, 27, 28, 29, 30, 32, 35, 36, 38, 39, 40, 41, 42, 44, 46, 48, 49, 51, 52, 53, 55, 60, 61, 62, 64, 65, 66, 67, 68, 70, 71, 73, 74, 75, 76, 77, 78, 79, 80, 85, 102, 110, 111, 113, 114, 115, 119, 121, 123, 126, 127);

Date: 2025-01-31 09:36:38 Duration: 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 (19, 14, 27, 28, 64, 5, 24, 39, 75, 52);

Date: 2025-01-31 13:30:16 Duration: 0ms

10

200,218

Details

35s753ms

0ms

10ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	4,045	708ms	0ms
	01	7,117	1s194ms	0ms
	02	4,109	753ms	0ms
	03	3,387	698ms	0ms
	04	1,903	363ms	0ms
	05	1,452	268ms	0ms
	06	1,162	202ms	0ms
	07	370	60ms	0ms
	08	4,820	672ms	0ms
	09	11,853	1s972ms	0ms
	10	17,260	2s968ms	0ms
	11	11,189	1s956ms	0ms
	12	16,415	3s38ms	0ms
	13	21,371	3s997ms	0ms
	14	15,799	2s897ms	0ms
	15	18,442	3s422ms	0ms
	16	14,764	2s739ms	0ms
	17	13,500	2s477ms	0ms
	18	9,958	1s766ms	0ms
	19	9,619	1s710ms	0ms
	20	5,416	899ms	0ms
	21	3,467	555ms	0ms
	22	2,800	426ms	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 (8006645, 8006534);

Date: 2025-01-31 17:21:55 Duration: 10ms
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 (8006453, 8006428, 8006458, 8006456, 8006595, 8006462, 8006460, 8006457, 8006461, 8006459, 8006454, 8007032, 8006288, 8006472, 8007311, 8006359, 8006341, 8006481, 8004676, 8006437, 2, 8004657, 8007174, 8006645, 3, 8006455, 8006318, 8007331, 8007305, 8004683, 8006302);

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

Date: 2025-01-31 19:06:18 Duration: 2ms

11

177,036

Details

54s950ms

0ms

4ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 31	00	3,850	1s68ms	0ms
	01	4,510	1s389ms	0ms
	02	2,463	778ms	0ms
	03	1,891	605ms	0ms
	04	1,177	372ms	0ms
	05	949	279ms	0ms
	06	821	246ms	0ms
	07	304	91ms	0ms
	08	3,401	976ms	0ms
	09	8,647	2s647ms	0ms
	10	13,813	4s142ms	0ms
	11	7,252	2s207ms	0ms
	12	13,424	4s294ms	0ms
	13	21,611	7s66ms	0ms
	14	12,763	4s25ms	0ms
	15	18,965	6s55ms	0ms
	16	17,580	5s562ms	0ms
	17	15,502	4s699ms	0ms
	18	10,283	3s90ms	0ms
	19	8,883	2s797ms	0ms
	20	3,867	1s150ms	0ms
	21	3,363	947ms	0ms
	22	1,717	457ms	0ms

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

Date: 2025-01-31 16:33:14 Duration: 4ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 977) OR r.global) ORDER BY r.id;

Date: 2025-01-31 18:12:08 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 = 926) OR r.global) ORDER BY r.id;

Date: 2025-01-31 18:55:40 Duration: 2ms

12

174,642

Details

1d4h47m51s

520ms

1s224ms

593ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5,545	54m32s	590ms
	01	10,329	1h43m2s	598ms
	02	8,508	1h22m11s	579ms
	03	10,388	1h41m59s	589ms
	04	6,057	57m35s	570ms
	05	4,258	41m39s	587ms
	06	3,897	39m34s	609ms
	07	893	8m22s	562ms
	08	1,964	18m33s	567ms
	09	6,329	1h2m37s	593ms
	10	8,374	1h21m20s	582ms
	11	7,428	1h13m4s	590ms
	12	10,335	1h43m	598ms
	13	12,224	2h5m8s	614ms
	14	8,924	1h28m15s	593ms
	15	12,378	2h5m47s	609ms
	16	7,881	1h21m2s	617ms
	17	9,447	1h33m24s	593ms
	18	13,202	2h10m27s	592ms
	19	13,989	2h18m22s	593ms
	20	6,725	1h3m53s	570ms
	21	3,353	32m21s	579ms
	22	2,214	21m32s	583ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4913939)) AND (("shipping_track"."id" not in (40736981, 40739407, 40739938, 40885946, 40886103, 40912614, 40913559, 40926922, 40978707, 40978707)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:50 Duration: 1s224ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947038)) AND (("shipping_track"."id" not in (40978713, 40978713)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:51 Duration: 1s97ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947036)) AND (("shipping_track"."id" not in (40978685, 40978685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:46 Duration: 1s94ms

13

145,217

Details

23s449ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	4,104	567ms	0ms
	01	4,890	722ms	0ms
	02	2,634	367ms	0ms
	03	2,321	308ms	0ms
	04	1,436	178ms	0ms
	05	1,055	141ms	0ms
	06	628	88ms	0ms
	07	381	49ms	0ms
	08	3,937	534ms	0ms
	09	9,010	1s355ms	0ms
	10	10,225	1s680ms	0ms
	11	5,898	899ms	0ms
	12	9,810	1s696ms	0ms
	13	16,200	2s921ms	0ms
	14	9,798	1s573ms	0ms
	15	14,148	2s460ms	0ms
	16	12,729	2s245ms	0ms
	17	13,082	2s135ms	0ms
	18	8,647	1s378ms	0ms
	19	6,587	1s66ms	0ms
	20	3,347	479ms	0ms
	21	2,548	368ms	0ms
	22	1,802	227ms	0ms

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

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

Date: 2025-01-31 16:33:20 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: 2025-01-31 16:34:44 Duration: 1ms

14

128,152

Details

33s44ms

0ms

26ms

0ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 31	00	3,303	876ms	0ms
	01	5,519	1s378ms	0ms
	02	3,274	873ms	0ms
	03	3,620	1s14ms	0ms
	04	1,072	303ms	0ms
	05	1,656	448ms	0ms
	06	2,257	591ms	0ms
	07	141	39ms	0ms
	08	2,203	509ms	0ms
	09	6,413	1s841ms	0ms
	10	10,508	2s978ms	0ms
	11	6,624	1s794ms	0ms
	12	10,103	2s710ms	0ms
	13	11,711	3s242ms	0ms
	14	9,062	2s181ms	0ms
	15	11,692	2s633ms	0ms
	16	8,738	2s292ms	0ms
	17	9,477	2s338ms	0ms
	18	5,908	1s496ms	0ms
	19	6,211	1s453ms	0ms
	20	3,895	808ms	0ms
	21	2,581	550ms	0ms
	22	2,184	687ms	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 (39918091, 39208982, 41128076, 40747331, 39970046, 41627339, 40869785, 40896776, 41091254, 41194140, 41580821, 41302613, 41342499, 39827495, 41049176, 41005867, 41136270, 40940404, 41247353, 39542554, 40914019, 41123658, 41900434, 41289531, 39766912, 42012182, 42142203, 40823494, 42060997, 32200049, 41591868, 41717410, 41352901, 41293366, 32287450, 32255115, 41294933, 39706708, 41304318, 32593116, 40707786, 39661983, 39539410, 41293367, 40316829, 41302374, 41106961, 42141538, 32286892, 39781513, 41550216, 42040673, 41974030, 32294471, 32188024, 41986484, 39228086, 41152165, 41974145, 39752682, 32662496, 42119163, 42119238, 39788717, 42058116, 32237459, 42058120, 40328851, 41991591, 42159888, 41889106, 42045354, 41623257, 42092720, 39615637, 32205579, 42090705, 41919575, 41981997, 32212490, 42030506, 32294431, 32662006, 42119152, 41974108, 32343029, 32322730, 42172559, 39523996, 38977445, 32196562, 42002100, 39567944, 42091508, 38549133, 42133853, 32205980, 42058467, 42048897, 39810428);

Date: 2025-01-31 17:21:58 Duration: 26ms
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 (41504197, 39970046, 40988019, 41504196, 41025964, 39423184, 40389462, 32217086, 39705159, 37854822, 39514906, 34766372, 38907190, 39778792, 39798260, 39740075, 39721386, 42088210, 40301233, 41791138, 41991054, 41936434, 40631319, 41137425, 41991352, 42058120, 41091278, 42058116, 41839650, 41252236, 42058555, 42057730, 41271835, 41277214, 41609598, 41991591, 41475906, 40675170, 41991162, 32204783, 41839842, 41618452, 42058550, 40719641, 41202512, 41575636, 40786694, 41790852, 41790798, 41574940, 41803452, 41936300, 41705121, 41804121, 41136270, 41155832, 41432468, 32205579, 40937769, 41159843, 32205323, 41159837, 32205843, 42091409, 40930292, 41035019, 41643236, 32204901, 40133154, 41523625, 41936599, 40939576, 40508450, 41084280, 41510991, 41495623, 40517115, 40090720, 41255815, 41861080, 41153309, 40852090, 40921124, 41758752, 40921287, 41889106, 40918225, 41329998, 41330181, 41049670, 41444247, 41815691, 40743874, 41642471, 41547387, 41152875, 41494886, 32204840, 41046660, 41903471);

Date: 2025-01-31 17:21:58 Duration: 22ms
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 (32306851, 32262773, 42093129, 32306643, 32306660, 42088335, 32304729, 42175174, 41825257, 42174446, 42065785, 42065788, 42169735, 32311878, 41966340, 32373245, 32258547, 32230237, 32318480, 32318478, 32318474, 32318392, 32230216, 32318445, 32318513, 41915406, 41915404, 32318351, 41915401, 41915396, 32229775, 32318534, 32304445, 32654275, 32319545, 32288399, 32207228, 32279008, 32279021, 42165836, 40920190, 32288192, 32288206, 32288292, 41331728, 32654276, 32288421, 32379231, 32278827, 32178731, 41647844, 42071581, 41837791, 41837705, 32379387, 32379230, 41792057, 42165840, 42165985, 32319612, 32330493, 41837706, 32288435, 42063588, 32300557, 32379372, 42071562, 32288191, 32300581, 41979227, 32379300, 32249281, 32288546, 32277163, 42169069, 32288423, 32330498, 32279012, 32249279, 32379379, 32300584, 32381811, 32279001, 32654482, 32270196, 41886714, 32654466, 41703524, 32187644, 32187706, 32654478, 32290612, 32288551, 32654281, 42071553, 41275927, 32319461, 41929164, 32206687, 32300628, 42169465, 32319630, 32654397, 32379473, 32289001, 32654259, 32654431, 32654465, 42071891, 42072541, 41885975, 32300604, 42169001, 32389746, 32379278, 32277007, 42071577, 42009201, 32389900, 42168963, 32288376, 32267355, 32299016, 32315538, 32315535, 32215824, 32296915, 32296929, 32296928, 32296823, 32296891, 32296859, 32296844, 32296880, 32296881, 32315494, 32402703, 32402702, 32315469, 32315530, 32315526, 32314980, 32315599, 32315600, 32315583, 32315578, 32315572, 32324734, 32314880, 32314869, 32314868, 32314864, 32314855, 32315328, 32315324, 32315506, 32316630, 32314698, 32314695, 32314692, 32315299, 32314933, 32315237, 32314736, 32314734, 32315149, 32315097, 32315101, 32315520, 32315176, 32298853, 32316318, 32297536, 32297534, 32314733, 32297526, 32315243, 32297586, 32297515, 32299138, 32299412, 32299419, 32325448, 32326470, 32315586, 32315611, 32314960, 32315246, 32315275, 32315277, 32314714, 32314853, 32314706, 32324730, 32307257, 41796634, 41796635, 32307436, 42145104, 32325030, 32284469, 32283999, 32284478, 32284473, 32284477, 32284949, 42175837, 32284470, 32284790, 32285115, 32283730, 32368042, 41771093, 32283818, 32283712, 42069945, 32297576, 32299128, 42116825, 32296901, 32297566, 32297564, 32299121, 41526053, 41526938, 41526680, 41526971, 41526595, 41526967, 41526551, 32234499, 32319796, 32235984, 32235229, 32235240, 32320174, 32302429, 42160244, 32314530, 42139739, 32269758, 32340510, 32339792, 32339871, 32354183, 32354188, 32354393, 32354396, 32227511, 32227510, 32301496, 32302735, 32302729, 32302726, 32302717, 32302708, 32302660, 32301989, 32301986, 32301980, 32301959, 32339908, 32296223, 32296217, 32370661, 42151336, 32280134, 41417908, 32339854, 32324678, 32346749, 32346743, 32347278, 42169715, 32354280, 41607113, 32354266, 32237294, 32237295, 32186672, 41574792, 32266114, 32193678, 32355135, 42097785, 32282403, 32355130, 32282487, 32195031, 42097782, 32193681, 42106980, 41553839, 32183598, 41553829, 32361226, 32360897, 42142736, 32213866, 32361427, 32361435, 32361238, 32361421, 32361418, 42165439, 42165436, 42165434, 42165432, 32296459, 32296457, 32296461, 32296298, 32183502, 32361276, 32361340, 32361177, 32183499, 32183038, 32183035, 42174093, 32321416, 32320713, 32234549, 41665534, 41665509, 41665529, 32328147, 32249968, 32347246, 32347244, 32346985, 32326549, 32326545, 32326547, 32326552, 32326554, 32281631, 32347552, 32347254, 32346980, 32347568, 32315195, 32314796, 32314791, 42101159, 32328255, 32314785, 32328263, 32328276, 42104916, 32328045, 32314782, 42106440, 32315013, 32314773, 32314774, 32244951, 32249953, 32249989, 32249692, 42032914, 32249922, 32249934, 32245556, 32347073, 32347009, 32347035, 32280760, 32355608, 32195059, 32281621, 41853633, 32281620, 32355404, 32355406, 32262364, 32315077, 32316385, 32262327, 32262314, 32346949, 32307154, 32307152, 32326394, 32305951, 32325160, 32325174, 32325173, 32324850, 32307164, 32325809, 32307143, 32325958, 32325768, 32325755, 32325753, 32325748, 32222765, 32326242, 32326246, 32326061, 32305713, 41993378, 32275508, 32341927, 32275576, 32275564, 32273901, 32273917, 32341737, 41993360, 32328006, 32328499, 32328506, 41993363, 32373325, 32262242, 32299075, 32262241, 32299074, 32298968, 32299071, 32299070, 32262226, 32299069, 32299093, 32298966, 32342918, 32343857, 32243004, 42148501, 42148494, 32243169, 32243387, 42130291, 32345012, 42130286, 32344364, 32243311, 32343849, 32346977, 32347504, 32312927, 32322825, 32322910, 32180855, 32256516, 32344679, 32345029, 32344942, 32343850, 32344744, 32344666, 32315128, 32345014, 32344366, 32315104, 41882536, 32344756, 32315062, 32315060, 32315045, 32314742, 32314750, 32314754, 41882534, 32347089, 32347056, 32346710, 32346718, 32271878, 32271885, 32347202, 32347128, 32347136, 32305141, 32305139, 32323721, 32324107, 32305130, 32346734, 32347192, 32321793, 32322793, 32356106, 41893425, 32213311, 32213312, 41893431, 41893420, 32295392, 42007430, 42007418, 32355672, 41588984, 32256508, 32294517, 32363602, 32363594, 32362716, 32362711, 32310243, 32273398, 42050025, 42050021, 32198105, 32355104, 41652889, 41652888, 32356326, 32356316, 32356314, 32356330, 32264334, 32222902, 32222906, 32326943, 32326937, 32263784, 41856033, 41856039, 42125543, 42125621, 42125191, 32218186, 32218182, 42125500, 32325506, 32325572, 32306464, 32305805, 32306935, 32311821, 42158584, 32341949, 41986581, 32257919, 32257922, 32257921, 32257862, 32272548, 32272439, 42053590, 32325425, 32310996, 32325422, 32325414, 32325412, 32321462, 32325442, 32220558, 32320210, 32235982, 32234121, 42031419, 42155044, 42073839, 42155148, 42154732, 41935214, 42154736, 32208796, 32208798, 42155288, 32344358, 32343819, 42164137, 42164136, 42164132, 32344447, 32344442, 32344443, 42142131, 42078396, 42077924, 41800031, 32344646, 42164322, 32344340, 32274947, 41993527, 42122988, 32273894, 32273865, 32343831, 32275543, 32275184, 32275185, 32373333, 32308852, 32308795, 32354689, 32354679, 32354681, 41589923, 32342670, 32294531, 32294593, 32294595, 32294597, 32294596, 32307619, 32307618, 32307620, 32307625, 32306214, 32306221, 32302509, 32272541, 32302505, 32311244, 42050088, 32355539, 32355093, 32355092, 32354995, 32354998, 32355600, 32355542, 32355546, 32355544, 32355567, 32355571, 32307956, 32222074, 32298777, 32298779, 32215522, 32283378, 32298944, 42173535, 32354703, 42173431, 42173427, 32306330, 42173425, 32307814, 32311511, 32311515, 32307806, 32307747, 32294497, 32197621, 32197619, 32294481, 41874630, 32294480, 32307721, 42137569, 42137565, 32198560, 42159284, 42159283, 32355399, 42137555, 32221506, 42049421, 32355297, 32302388, 32306568, 32306560, 32307192, 32368679, 41473504, 32310218, 32310205, 32310202, 32310196, 42138463, 32199589, 32311408, 32199374, 32199375, 32272215, 41935204, 41935199, 32320456, 32320839, 41892781, 32320816, 32320171, 41139178, 41139177, 32234228, 32293889, 32326919, 42152365, 42152379, 42152373, 42151577, 32356402, 32195525, 32356297, 32356641, 32272332, 32311502, 32272331, 32310834, 32310835, 32222419, 32221908, 32311743, 42051586, 42051585, 32264199, 42051579, 42051578, 42097430, 32308787, 32264217, 32308772, 32308769, 42060932, 42096412, 41863687, 32259095, 32258819, 32258772, 41958637, 32368666, 32368657, 32309870, 32309866, 32309844, 32282993, 32282992, 41473604, 42038310, 32310978, 32342900, 32342898, 32342643, 32221402, 32356394, 32195551, 32355182, 32341852, 32356637, 32356631, 42051436, 42051399, 42050428, 32198550, 32198544, 32308748, 32308742, 32310014, 32251499, 32251508, 32251464, 32294470, 32221387, 41963279, 42161298, 32331797, 32331809, 32294140, 42173698, 42174747, 42128194, 32293777, 42049420, 32294430, 32293940, 32286879, 32294098, 32294134, 32255630, 41967966, 42155575, 32237385, 32237355, 32287775, 32287745, 32269585, 32330245, 32288277, 32655138, 32654388, 32287756, 32249285, 32269591, 32269586, 32269590, 32287744, 42166091, 32304452, 32304480, 32654221, 32300103, 32287763, 32287787, 32330067, 32288098, 32288158, 32330070, 32304475, 32330596, 41837766, 32265146, 32179287, 32379183, 32379292, 32304377, 32278993, 42063308, 32277409, 32287752, 32288076, 41804076, 32249553, 32187791, 32288124, 32217367, 32379169, 32289511, 42063258, 32379142, 32304021, 32207467, 32379168, 32289101, 32379154, 32329909, 42079634, 42009198, 32217264, 32304370, 32288271, 42079633, 32330077, 32206685, 32288706, 32268766, 32265473, 32279561, 41251035, 32217269, 32276734, 32330597, 32299742, 42104079, 32304468, 41837777, 41837765, 32330579, 32207484, 32207583, 42165980, 41990634, 32319599, 32278804, 42165712, 32207206, 32318943, 32379413, 32207403, 42071532, 32330574, 32278798, 32330570, 32207371, 32318673, 32319542, 42168800, 41902509, 32654354, 42168799, 32654370, 42072030, 42084453, 41792289, 42143239, 41792287, 41902479, 41703496, 32290086, 32188096, 32290097, 32188519, 32188420, 41902424, 32290090, 32276984, 42071540, 42071507, 32276983, 41902436, 42071525, 32319139, 41703507, 32654331, 32314897, 32191478, 32318314, 32230487, 32316194, 32316188, 32314910, 32232298, 32316474, 32270465, 41874776, 41976420, 32215690, 32316597, 32316431, 32301934, 32301928, 32301841, 32301840, 32301837, 32301824, 32236183, 32236177, 42043813, 32298716, 32299530, 32298678, 32210475, 32210458, 32210456, 32210452, 32316413, 32316571, 32316546, 32323816, 32234497, 32228579, 32228578, 32228569, 32252694, 32302171, 32302169, 32253066, 32302165, 32302156, 32302149, 32210410, 32210391, 32302146, 32302144, 41374288, 42074016, 32315722, 32315965, 32315927, 32315950, 32315942, 42176128, 42176898, 32315774, 32315777, 32315887, 41526771, 32215820, 32215817, 42116872, 32320856, 41932308, 32316124, 42000530, 32301800, 32301788, 32301770, 32301768, 32301761, 32301752, 32301736, 32301735, 32301734, 32301725, 32301718, 32301703, 32301699, 32301697, 32301677, 32301670, 32233399, 32317588, 32317580, 32317574, 32317550, 32231356, 32231362, 32233372, 32317596, 32233396, 32233433, 32233413, 32266598, 32299575, 32299552, 32295663, 41800661, 42151306, 32237554, 32281156, 32281155, 32237440);

Date: 2025-01-31 17:23:20 Duration: 16ms

15

102,298

Details

49s638ms

0ms

10ms

0ms

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

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Jan 31	00	573	376ms	0ms
	01	1,922	1s403ms	0ms
	02	610	378ms	0ms
	03	265	167ms	0ms
	04	198	112ms	0ms
	05	124	74ms	0ms
	06	153	86ms	0ms
	07	40	24ms	0ms
	08	1,319	626ms	0ms
	09	4,939	2s587ms	0ms
	10	4,166	2s344ms	0ms
	11	5,988	2s837ms	0ms
	12	5,561	3s80ms	0ms
	13	9,329	5s29ms	0ms
	14	7,772	3s798ms	0ms
	15	7,797	3s895ms	0ms
	16	10,083	4s879ms	0ms
	17	8,724	4s22ms	0ms
	18	13,619	5s707ms	0ms
	19	14,190	5s918ms	0ms
	20	3,887	1s728ms	0ms
	21	507	278ms	0ms
	22	532	281ms	0ms

SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4886298, 4889097, 4862322, 4886296, 4886303, 4852850, 4852836, 4850516, 4844577, 4872534, 4856528, 4592866, 4862205, 4889128, 4852876, 4756307, 4816554, 4819325, 4844511, 4850520, 4883159, 4883144, 4910396, 4911897, 4886305, 4708256, 4859736, 4796339, 4828214, 4590511, 4867640, 4805644, 4836035, 4854130, 4398487, 4601302, 4708271, 4819347, 4773309, 4816562, 4586602, 4690211, 4686013, 4375696, 4363790, 4850513, 4852871, 4862217, 4782315, 4816590, 4873343, 4852863, 4793888, 4852851, 4863745, 4826770, 4753633, 4816594, 4875347, 4862259, 4876242, 4873299, 4819305, 4850514, 4816601, 4763460, 4826842, 4873274, 4891072, 4773295, 4809969, 4852847, 4837546, 4756289, 4873252, 4676757, 4873282, 4826831, 4297613, 4873346, 3781678, 4751503, 4679026, 4826757, 4843713, 4819343, 4844057, 4751500, 4843828, 4398563, 4592862, 4843878, 4819312, 4819307, 4819315, 4839833, 4816556, 4819327, 4782314, 4843833, 4843835, 4819332, 4826805, 4844492, 4781989, 4829310, 4793873, 4843832, 4814022, 4816560, 4739250, 4844572, 4829312, 4839900, 4719193, 4751504, 4843827, 4863653, 4819322, 4819317, 4756336, 4792413, 4739489, 4844083, 4826780, 4843918, 4647456, 4591713, 4816575, 4837441, 4782255, 4844521, 4708212, 4755595, 4696659, 4816564, 4782284, 4303591, 4755436, 4782331, 4793825, 4793869, 4773314, 4773273, 4763494, 4819104, 4756298, 4755598, 4782281, 4324633, 4550908, 3881743, 4676842, 4708175, 4738855, 4757107, 4809968, 4818065, 4767533, 4773274, 4782323, 4763432, 4782265, 4782326, 4782285, 4773282, 4751473, 4756278, 4216374, 4696583, 4648803, 4751450, 4215019, 4782288, 4773316, 4809974, 4814606, 4763489, 4676796, 4376284, 4782477, 4773319, 4782253, 4802331, 4739455, 4793828, 4755413, 4751505, 4186200, 4838277, 4404103, 4781967, 4756363, 4676809);

Date: 2025-01-31 16:33:31 Duration: 10ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4819445, 4843728, 4852620, 4853873, 4907154, 4560368, 4732073, 4795539, 4826516, 4829326, 4831275, 4831653, 4836116, 4839501, 4850767, 4870436, 4873788, 4873817, 4878197, 4878815, 4885161, 4887122, 4897888, 4907153, 4546935, 4610800, 4736882, 4773515, 4820420, 4826196, 4843718, 4862622, 4863535, 4830810, 4830273, 4823523, 4818962, 4836429, 4822580, 4818726, 4733188, 4749520, 4769287, 4775451, 4789103, 4805456, 4824044, 4830827, 4836261, 4836600, 4844594, 4848251, 4862561, 4824764, 4826735, 4855702, 4857273, 4864188, 4865300, 4872120, 4873774, 4879484, 4879950, 4880717, 4881234, 4882943, 4883008, 4883019, 4883844, 4883895, 4885498, 4887535, 4887738, 4887778, 4888992, 4890650, 4891917, 4893109, 4893112, 4893149, 4894833, 4894995, 4895746, 4896065, 4896200, 4898934, 4903502, 4906943, 4906991, 4907148, 4907150, 4907158, 4594710, 4611840, 4650141, 4659374, 4699401, 4708533, 4710497, 4728121, 4781692, 4804810, 4808502, 4813326, 4813335, 4814984, 4843723, 4843734, 4850657, 4852122, 4853197, 4854172, 4854189, 4863373, 4864706, 4867649, 4873770, 4873780, 4873799, 4873832, 4885027, 4887273, 4893254, 4896754, 4906986, 4906989, 4907147, 4812327, 4810981, 4854322, 4905330, 4858805, 4822604, 4849763, 4866716, 4870561, 4866168, 4880857, 4849138, 4841987, 4897499, 4699439, 4672202, 4721507, 4735535, 4832050, 4843175, 4849075, 4850768, 4852850, 4853425, 4853611, 4854512, 4854961, 4856240, 4859096, 4860454, 4863684, 4864713, 4866269, 4866580, 4866679, 4866717, 4868359, 4869102, 4870061, 4876539, 4891604, 4892495, 4645725, 4786355, 4801459, 4822553, 4834420, 4838970, 4846774, 4851890, 4852836, 4853940, 4855046, 4856474, 4856556, 4861766, 4862154, 4866263, 4866676);

Date: 2025-01-31 17:22:12 Duration: 9ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (1305474, 1779075, 1779071, 1239608, 1314009, 1710176, 1644193, 1625932, 1588502, 1543831, 1451658, 1355021, 1177113, 1889177, 1869843, 1856453, 1856452, 1856399, 1856377, 1854932, 1854925, 1888010, 1888001, 1887997, 1887991, 1887989, 1887987, 1887984, 1887981, 1887978, 1887975, 1887972, 1887968, 1869018, 1856351, 1850084, 1816181, 1611816, 1502030, 1412051, 380291, 1644389, 1625986, 1737211, 1671883, 1573091, 1538125, 2055691, 1989053, 1959907, 1959906, 1959905, 1959903, 1959902, 1959900, 1959899, 1959896, 1944350, 1943846, 1943841, 1943827, 1943588, 1943567, 1905376, 1904779, 1943589, 2055744, 2020061, 2017103, 2017052, 2017033, 2016586, 2016159, 1983245, 1964432, 1964431, 1964428, 1964426, 1964424, 1964421, 1964420, 1964418, 2054771, 1998006, 1771983, 1671823, 1611776, 2109978, 2088045, 2054577, 2109994, 2095804, 2088279, 2088274, 2056197, 2055666, 2054796, 2054792, 2054770, 2054591, 2054538, 2054504, 1752699, 2113454, 2110004, 2109937, 2107301, 2095884, 2095806, 2095151, 2088048, 2088047, 2088046, 2088044, 2056243, 2054759, 2054742, 2054583, 2054548, 2054515, 1850112, 1779038, 1349405, 1939549, 1888180, 1873662, 1850116, 1779013, 1779012, 1778983, 1746942, 1737191, 1737101, 1710198, 1710184, 1710153, 1573029, 1543731, 1501954, 1484467, 1451570, 1412056, 1409946, 1354959, 1314132, 1146311, 1030228, 916752, 348203, 1544962, 1679385, 1887778, 1865098, 1865069, 1816223, 1779023, 1710201, 1671861, 1625930, 1538144, 1370661, 868009, 1968003, 1813144, 1710260, 1998062, 1998034, 1370817, 1995033, 2036953, 1968572, 1865012, 1772147, 1737068, 1582698, 1502018, 1409997, 1372761, 1355026, 1277060, 1063945, 1055835, 743978, 1747029, 2145513, 2139222, 2139221, 2124535, 2124452, 2124445, 2109546, 1873747, 2145518, 2139223, 2139220, 2124531, 2124448, 2109560, 2017609, 1538506, 1813092, 1816274, 2179890, 1813190, 2036922, 1363776, 839747, 1974874, 1939536, 1939535, 1865117, 1625908, 2124449, 2157893, 2158125, 2215813, 2215802, 2215799, 2215797, 2215791, 2215692, 2215620, 2215594, 2180702, 2179513, 2158128, 2158081, 2157881, 2157842, 2157802, 2157773, 2145057, 1994924, 1747052, 1305318, 1091466, 867882, 2087665, 2032251, 1873693, 1370723, 992931, 1946584, 2255512, 1982688, 2255467, 2242909, 2255560, 2145516, 2255495, 2255537, 2242910, 2299676, 2341120, 2255536, 2255534, 2255533, 2255532, 1538152, 1905641, 2392985, 2390325, 2333501, 2292643, 2255485, 2242913, 2242912, 2242911, 2242908, 2179574, 2054783, 2054740, 2413968, 2106771, 2088002, 1625922, 1451667, 2440236, 2255559, 2203034, 2124547, 2124543, 2087609, 2032146, 1737227, 1710205, 1501970, 1278865, 2032271, 2457915, 2401475, 2379861, 2341520, 2293187, 2254738, 2193566, 2305698, 2457913, 2341518, 2215792, 2413973, 2413976, 2413857, 2413970, 2145058, 2430540, 2413985, 2413984, 2413983, 2413982, 2413981, 2413980, 2413979, 2413978, 2413977, 2413975, 2413974, 2413972, 2413971, 2413969, 2413967, 2413966, 2413965, 2413964, 2394107, 2393050, 2392904, 2124733, 2105579, 2105519, 1995031, 1846029, 1625893, 1314043, 2466210, 2457912, 2466565, 1502034, 2168659, 2105532, 1314039, 2361815, 2466274, 2334347, 2393029, 2505613, 2505558, 2486750, 2466584, 2466260, 2466245, 2445189, 2393045, 2393013, 2413892, 2341485, 2318577, 2278849, 2278702, 2270621, 2248021, 2242859, 2239730, 2203088, 2199454, 2193499, 2168521, 2168511, 2140184, 2139982, 2087606, 2040214, 1998284, 1995083, 1994998, 1974889, 1865064, 1816322, 1816262, 1772054, 1772042, 1710150, 1644330, 1625880, 1314146, 1099154, 960080, 2334281, 2552145, 2599635, 2561685, 2560649, 2558731, 2558728, 2553595, 2552134, 2552129, 2520011, 2520008, 2520006, 2520004, 2505287, 2393080, 2344502, 2344488, 2239714, 2168716, 2139233, 2124494, 1968000, 1779069, 1737163, 1409954, 1146335, 2619864, 2597533, 2597530, 2597357, 2597337, 2597335, 2597305, 2597286, 2597266, 2578805, 2578802, 2578800, 2578797, 2578795, 2578792, 2578790, 2578750, 2528053, 2527855, 2466145, 2444906, 2341505, 2158086, 867955, 522370, 2352557, 2612772, 2597342, 2597297, 2619527, 2597319, 2660289, 2487195, 2386405, 2341524, 2203055, 1813071, 2677456, 2654958, 2621448, 2620468, 2619925, 2619734, 2619547, 2619544, 2612771, 2597488, 2561687, 2393276, 2528271, 2486937, 2413954, 2199426, 1974878, 1484554, 2655442, 2655381, 2654934, 2676919, 2203904, 2527932, 2477516, 2441038, 2325903, 2280564, 2278774, 2124845, 1998059, 2707284, 2688552, 2687875, 2687840, 2687792, 2687764, 2687756, 2687715, 2676921, 2676917, 2676916, 2645271, 2640257, 2413805, 2386518, 2386394, 2386384, 2386374, 2278707, 2139230, 1995067, 1995017, 1412074, 2775317, 2775316, 2775315, 2775314, 2775313, 2775312, 2775311, 2749933, 2735856, 2735848, 2734093, 2734089, 2730938, 2688192, 2687776, 2687771, 2687743, 2654891, 2578747, 2520906, 2436523, 2416181, 2386411, 2239897, 2106816, 2008639, 1998095, 1611811, 1611810, 1573148, 2780308, 2766498, 2761144, 2761133, 2761120, 2761108, 2761101, 2761087, 2761073, 2761063, 2761053, 2761042, 2761025, 2844536, 2413996, 1737098, 2040079, 2724310, 2719122, 2645481, 2640045, 2619793, 2521064, 2487383, 2487088, 2413899, 2248114, 2140110, 1998101, 1968076, 1778971, 2612567, 2239766, 2882655, 2844353, 2844040, 2842660, 2842643, 2842638, 2835346, 2887447, 2844060, 2886344, 2886024, 2842629, 2886296, 2856857, 2842759, 2842749, 2886312, 2886022, 2882652, 2842707, 2762066, 2255507, 1545008, 1888183, 2087661, 1710204, 1737168, 1747004, 1846021, 2087938, 2105518, 2106781, 1864978, 1997982, 1968031, 1998011, 993072, 2140020, 1968060, 2891918, 2891527, 2892160, 2891475, 2891399, 2444865, 2640162, 2640161, 2584394, 2168696, 2139242, 2054794, 2578888, 1865062, 1816286, 1710237, 2678330, 2926684, 2926683, 2906283, 2905399, 2905316, 2905219, 2898486, 2891397, 2886016, 2647419, 2441154, 2413831, 2168705, 1974886, 1939591, 2761483, 2203906, 1278875, 2203908, 2157955, 2922905, 2762392, 2681839, 2584511, 2323751, 2278968, 2248141, 1967946, 1865135, 2323843, 2278934, 2344572, 2676965, 2168686, 2477934, 2922898, 2922896, 2965986, 2954172, 2954082, 2954078, 2954076, 2954075, 2954069, 2923081, 2922904, 2922900, 2836165, 2954170, 2954081, 2954073, 2954070, 2954067, 2762602, 2640267, 2584384, 2441001, 1746937, 1779008, 2386525, 1844209, 2828515, 2578949, 2139228, 1538362, 2891396, 2999061, 2999019, 2999017, 2689378, 3000103, 2999479, 2999062, 2966382, 2965968, 2965900, 2640121, 2578986, 2323861, 2140119, 2039885, 2008658, 1998293, 1865137, 1865093, 1737190, 2719211, 2527934, 2199546, 2040195, 2124524, 1383331, 3013639, 3013637, 3013635, 3013634, 2921033, 2921024, 2842725, 2645284, 2593887, 2440850, 2278712, 2193614, 2105378, 1888356, 3029631, 2898611, 2844056, 2174451, 2168682, 1671768, 2898570, 2882089, 2106772, 2681756, 2106788, 2898686, 2878663, 2762456, 3094466, 3069553, 3057221, 3044037, 3044030, 3044028, 3069540, 3044043, 3069754, 3044035, 3094465, 3069630, 3044042, 3044039, 3044033, 2828527, 2978536, 2898626, 2827857, 2597359, 2487003, 2440294, 2344497, 2036941, 2619816, 2520789, 2926701, 2520005, 2199573, 1239534, 3101218, 3094464, 2926712, 2724054, 2325922, 3109021, 3109020, 3104832, 3104761, 3148125, 3148188, 3125030, 3094463, 3036037, 3101189, 3146133, 2999563, 2958268, 2898636, 2827309, 2766773, 2761432, 2724085, 2676957, 2344514, 2341591, 2247924, 2140032, 2766643, 3148873, 3134413, 3134411, 3101105, 3148097, 2640027, 2157974, 2954298, 2922937, 2898545, 2882147, 3175956, 3176453, 3146296, 1779054, 3029683, 3093796, 3090243, 2999243, 2958241, 2954090, 2926744, 2926743, 2882074, 2579081, 2444933, 2413907, 2140052, 1939546, 1305304, 2999467, 2105480, 3093840, 3029650, 2954129, 2898532, 2578759, 3175957, 3211131, 3211115, 3211102, 3211072, 3211049, 3211048, 3211047, 3211046, 3211022, 3210997, 3210933, 3210919, 3210586, 3220671, 3211231, 3211060, 3200948, 3176492, 3176485, 3250245, 3250155, 3249710, 3202740, 2978218, 2528872, 2487489, 3013476, 1873691, 1348971, 2413999, 3251296, 3035746, 3264374, 3287147, 3286490, 3286217, 3249706, 3148181, 3320121, 3286297, 3286243, 3286167, 3286676, 3286376, 3286210, 3286449, 3320736, 3286371, 3109123, 2842754, 2640240, 2521052, 3319817, 3175924, 3334648, 2766833, 3325016, 3320637, 3374341, 3373303, 3372500, 3372488, 3325019, 3320123, 3250202);

Date: 2025-01-31 12:19:32 Duration: 7ms

16

99,820

Details

5h40m20s

162ms

388ms

204ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	938	3m5s	198ms
	01	2,933	9m46s	200ms
	02	2,939	9m42s	198ms
	03	2,682	9m2s	202ms
	04	2,612	8m37s	198ms
	05	1,557	5m7s	197ms
	06	665	2m12s	199ms
	07	475	1m36s	203ms
	08	1,312	4m20s	198ms
	09	5,069	17m20s	205ms
	10	2,340	7m54s	202ms
	11	6,925	23m48s	206ms
	12	3,817	13m6s	206ms
	13	10,162	35m38s	210ms
	14	8,795	30m31s	208ms
	15	7,346	25m40s	209ms
	16	13,963	51m20s	220ms
	17	9,190	31m9s	203ms
	18	4,969	15m25s	186ms
	19	7,268	23m	189ms
	20	3,678	11m18s	184ms
	21	168	30s452ms	181ms
	22	17	3s84ms	181ms

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

Date: 2025-01-31 16:33:52 Duration: 388ms
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" = '123487')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:34:56 Duration: 375ms
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" = '124593')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:35:01 Duration: 369ms

17

99,370

Details

7s759ms

0ms

2ms

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,061	133ms	0ms
	01	3,501	255ms	0ms
	02	2,664	187ms	0ms
	03	2,245	168ms	0ms
	04	1,071	74ms	0ms
	05	765	55ms	0ms
	06	557	37ms	0ms
	07	136	9ms	0ms
	08	1,954	119ms	0ms
	09	5,713	394ms	0ms
	10	9,597	650ms	0ms
	11	5,689	401ms	0ms
	12	8,736	676ms	0ms
	13	9,915	914ms	0ms
	14	7,633	656ms	0ms
	15	8,513	753ms	0ms
	16	6,840	642ms	0ms
	17	6,842	614ms	0ms
	18	4,560	386ms	0ms
	19	4,670	296ms	0ms
	20	2,766	163ms	0ms
	21	1,596	93ms	0ms
	22	1,346	75ms	0ms

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

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

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

Date: 2025-01-31 16:32:11 Duration: 0ms

18

97,277

Details

1h17m50s

37ms

194ms

48ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,823	2m8s	45ms
	01	4,898	3m45s	46ms
	02	2,960	2m14s	45ms
	03	3,444	2m36s	45ms
	04	1,451	1m6s	45ms
	05	1,174	53s413ms	45ms
	06	1,089	49s231ms	45ms
	07	570	26s92ms	45ms
	08	1,526	1m9s	45ms
	09	4,924	3m53s	47ms
	10	6,332	4m52s	46ms
	11	6,621	5m7s	46ms
	12	7,577	5m58s	47ms
	13	10,652	8m35s	48ms
	14	6,990	5m29s	47ms
	15	9,252	7m21s	47ms
	16	6,480	5m12s	48ms
	17	4,779	4m4s	51ms
	18	4,322	3m50s	53ms
	19	3,504	3m9s	54ms
	20	2,479	2m8s	51ms
	21	2,185	1m53s	51ms
	22	1,245	1m4s	51ms

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

Date: 2025-01-31 17:22:10 Duration: 194ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4941421)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 17:22:11 Duration: 112ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4940196)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 16:33:39 Duration: 106ms

19

80,214

Details

21s633ms

0ms

27ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,534	622ms	0ms
	01	5,929	1s453ms	0ms
	02	3,754	876ms	0ms
	03	5,225	1s277ms	0ms
	04	1,708	349ms	0ms
	05	1,945	490ms	0ms
	06	2,701	742ms	0ms
	07	489	88ms	0ms
	08	763	177ms	0ms
	09	3,376	876ms	0ms
	10	4,540	1s179ms	0ms
	11	4,732	1s265ms	0ms
	12	5,868	1s556ms	0ms
	13	6,865	1s884ms	0ms
	14	4,550	1s246ms	0ms
	15	4,868	1s326ms	0ms
	16	3,977	1s108ms	0ms
	17	4,253	1s570ms	0ms
	18	2,895	967ms	0ms
	19	2,549	810ms	0ms
	20	2,382	643ms	0ms
	21	2,653	655ms	0ms
	22	1,658	461ms	0ms

INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8006397, '', '2025-01-31 11:56:13.667710', 1030, '2025-01-31 11:57:18', false, NULL, true, '<588225586512113.1738324638.689672231674194-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4894828, NULL, 2, '2025-01-31 11:56:13.667710', 1030) RETURNING "id";

Date: 2025-01-31 12:57:18 Duration: 27ms
INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8006324, '', '2025-01-31 14:46:33.288176', 960, '2025-01-31 14:47:55', false, NULL, true, '<688147596955336.1738334875.146774768829346-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4805456, NULL, 2, '2025-01-31 14:46:33.288176', 960) RETURNING "id";

Date: 2025-01-31 15:47:55 Duration: 25ms
INSERT INTO "mail_message" ("author_id", "body", "create_date", "create_uid", "date", "email_add_signature", "email_from", "is_internal", "message_id", "message_type", "model", "record_name", "reply_to", "res_id", "subject", "subtype_id", "write_date", "write_uid") VALUES (8006752, '', '2025-01-31 02:09:25.473300', 1123, '2025-01-31 02:10:41', false, NULL, true, '<743604203269007.1738289441.493669986724854-openerp-message-notify@urg-dell>', 'notification', 'shipping.policy', NULL, NULL, 4938875, NULL, 2, '2025-01-31 02:09:25.473300', 1123) RETURNING "id";

Date: 2025-01-31 03:10:41 Duration: 24ms

20

77,123

Details

7s419ms

0ms

17ms

0ms

insert into "mail_tracking_value" ("create_date", "create_uid", "field", "field_desc", "field_type", "mail_message_id", "new_value_char", "old_value_char", "tracking_sequence", "write_date", "write_uid") values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) returning "id";

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,272	190ms	0ms
	01	4,114	337ms	0ms
	02	3,140	245ms	0ms
	03	3,816	311ms	0ms
	04	1,644	132ms	0ms
	05	1,284	91ms	0ms
	06	1,196	97ms	0ms
	07	548	39ms	0ms
	08	1,335	104ms	0ms
	09	4,003	415ms	0ms
	10	4,399	446ms	0ms
	11	5,035	465ms	0ms
	12	5,955	596ms	0ms
	13	7,612	804ms	0ms
	14	5,129	528ms	0ms
	15	6,306	651ms	0ms
	16	4,753	486ms	0ms
	17	4,025	448ms	0ms
	18	3,056	328ms	0ms
	19	2,544	280ms	0ms
	20	2,028	180ms	0ms
	21	1,867	151ms	0ms
	22	1,062	84ms	0ms

INSERT INTO "mail_tracking_value" ("create_date", "create_uid", "field", "field_desc", "field_type", "mail_message_id", "new_value_char", "old_value_char", "tracking_sequence", "write_date", "write_uid") VALUES ('2025-01-31 08:33:44.004676', 1030, 7312, 'الحالة', 'selection', 37201252, 'تم استلام العميل', 'تم التوصيل', 100, '2025-01-31 08:33:44.004676', 1030) RETURNING "id";

Date: 2025-01-31 09:34:39 Duration: 17ms
INSERT INTO "mail_tracking_value" ("create_date", "create_uid", "field", "field_desc", "field_type", "mail_message_id", "new_value_char", "old_value_char", "tracking_sequence", "write_date", "write_uid") VALUES ('2025-01-31 09:24:51.269291', 1030, 7312, 'الحالة', 'selection', 37208192, 'تم استلام العميل', 'في الطريق الي العميل', 100, '2025-01-31 09:24:51.269291', 1030) RETURNING "id";

Date: 2025-01-31 10:25:56 Duration: 16ms
INSERT INTO "mail_tracking_value" ("create_date", "create_uid", "field", "field_desc", "field_type", "mail_message_id", "new_value_char", "old_value_char", "tracking_sequence", "write_date", "write_uid") VALUES ('2025-01-31 08:08:32.088273', 1030, 7312, 'الحالة', 'selection', 37198787, 'تم استلام العميل', 'في الطريق الي العميل', 100, '2025-01-31 08:08:32.088273', 1030) RETURNING "id";

Date: 2025-01-31 09:09:34 Duration: 15ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

59m59s

2m10s

40

Details

1h27m4s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Jan 31	00	4	2ms	0ms
	01	3	11m59s	3m59s
	08	1	1ms	1ms
	09	1	1ms	1ms
	10	7	1h8m12s	9m44s
	11	3	2ms	0ms
	12	3	4ms	1ms
	13	4	6ms	1ms
	14	3	6m52s	2m17s
	15	3	4ms	1ms
	17	3	4ms	1ms
	19	2	0ms	0ms
	21	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 08:52:19.516591', "last_update" = '2025-01-31 08:07:19.516613', "write_date" = '2025-01-31 08:07:19.182770', "write_uid" = 965 WHERE id IN (965);

Date: 2025-01-31 10:07:19 Duration: 59m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 01:12:22.033870', "last_update" = '2025-01-31 00:27:22.033891', "write_date" = '2025-01-31 00:27:21.716855', "write_uid" = 1 WHERE id IN (1295);

Date: 2025-01-31 01:39:21 Duration: 11m59s
UPDATE "res_users" SET "exp_date" = '2025-01-31 10:12:08.146853', "last_update" = '2025-01-31 09:27:08.146876', "write_date" = '2025-01-31 09:27:07.813715', "write_uid" = 1 WHERE id IN (865);

Date: 2025-01-31 10:35:21 Duration: 8m13s

2

0ms

22m22s

1m38s

144

Details

3h56m12s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5	3ms	0ms
	01	16	1h45m33s	6m35s
	02	1	1ms	1ms
	03	1	1ms	1ms
	04	2	3ms	1ms
	08	3	1ms	0ms
	09	6	7ms	1ms
	10	10	2m39s	15s981ms
	11	3	4ms	1ms
	12	9	7ms	0ms
	13	8	10ms	1ms
	14	13	14m22s	1m6s
	15	18	18ms	1ms
	16	19	1h53m36s	5m58s
	17	9	10ms	1ms
	18	6	6ms	1ms
	19	3	2ms	0ms
	20	3	3ms	1ms
	21	6	3ms	0ms
	22	3	0ms	0ms

UPDATE "res_users" SET "exp_date" = '2025-01-31 01:01:58.533012', "last_update" = '2025-01-31 00:16:58.533032', "sid" = 'ab6ed4a88a72cd7cefb4c73299c469e23cc551da', "write_date" = '2025-01-31 00:16:58.207160', "write_uid" = 1 WHERE id IN (1211);

Date: 2025-01-31 01:39:21 Duration: 22m22s
UPDATE "res_users" SET "exp_date" = '2025-01-31 16:19:23.668331', "last_update" = '2025-01-31 15:34:23.668365', "sid" = 'a83618e54c78abd1c0265095e1012ad345560503', "write_date" = '2025-01-31 15:34:23.198288', "write_uid" = 1 WHERE id IN (861);

Date: 2025-01-31 16:55:21 Duration: 20m57s
UPDATE "res_users" SET "exp_date" = '2025-01-31 01:03:36.151896', "last_update" = '2025-01-31 00:18:36.151916', "sid" = 'ab6ed4a88a72cd7cefb4c73299c469e23cc551da', "write_date" = '2025-01-31 00:18:35.820222', "write_uid" = 1 WHERE id IN (1211);

Date: 2025-01-31 01:39:21 Duration: 20m45s

3

0ms

1h2s

8s372ms

34,823

Details

3d8h59m32s

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

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Jan 31	00	893	16h3m46s	1m4s
	01	1,275	8h23m8s	23s677ms
	02	1,089	244ms	0ms
	03	1,051	239ms	0ms
	04	675	146ms	0ms
	05	407	91ms	0ms
	06	219	49ms	0ms
	07	140	31ms	0ms
	08	566	123ms	0ms
	09	1,589	4h29m38s	10s181ms
	10	2,424	6h8m	9s109ms
	11	1,684	2h	4s275ms
	12	2,650	1h31m16s	2s66ms
	13	3,242	5h18m39s	5s897ms
	14	2,798	8h13m33s	10s583ms
	15	3,295	6h21m52s	6s953ms
	16	2,662	10h57m53s	14s828ms
	17	2,329	5h51m39s	9s59ms
	18	1,880	15m8s	483ms
	19	1,842	3h14m42s	6s342ms
	20	997	212ms	0ms
	21	627	2h10m10s	12s456ms
	22	489	99ms	0ms

update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.283221', exp_date = '2025-01-31 17:51:07.283225', logged_in = 'TRUE' where id = 854;

Date: 2025-01-31 19:06:10 Duration: 1h2s
update res_users set sid = '19793c19b3c84ce4cde853f8d7939971bbe58192', last_update = '2025-01-31 17:06:07.282693', exp_date = '2025-01-31 17:51:07.282696', logged_in = 'TRUE' where id = 854;

Date: 2025-01-31 19:06:10 Duration: 1h2s
update res_users set sid = '1943a91668cba1c065cc59ee914a053e8f14a119', last_update = '2025-01-31 09:51:56.523527', exp_date = '2025-01-31 10:36:56.523530', logged_in = 'TRUE' where id = 847;

Date: 2025-01-31 11:51:56 Duration: 59m59s

4

0ms

3s938ms

2s820ms

159

Details

7m28s

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

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Jan 31	02	1	3s8ms	3s8ms
	06	1	2s958ms	2s958ms
	10	1	666ms	666ms
	11	5	14s634ms	2s926ms
	12	7	21s268ms	3s38ms
	13	12	30s66ms	2s505ms
	14	1	3s130ms	3s130ms
	15	30	1m21s	2s710ms
	16	20	52s49ms	2s602ms
	17	11	34s483ms	3s134ms
	18	19	52s247ms	2s749ms
	19	28	1m24s	3s27ms
	20	17	50s512ms	2s971ms
	21	5	14s448ms	2s889ms
	22	1	2s962ms	2s962ms

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

Date: 2025-01-31 16:34:43 Duration: 3s938ms
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 (32))))))) 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 (32)))))) 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 (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) 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 (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%4%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-31 17:00:31 Duration: 3s668ms
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 (32))))))) 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 (32)))))) 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 (32)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))))) 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 (32))))))))) 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 (32)))))))) AND ("policy_number"."name"::text ilike '%42229%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2025-01-31 17:00:32 Duration: 3s466ms

5

213ms

1s211ms

638ms

5,038

Details

53m37s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Jan 31	00	476	2m55s	368ms
	01	921	10m36s	691ms
	02	169	43s578ms	257ms
	05	123	30s684ms	249ms
	08	15	13s135ms	875ms
	09	1	863ms	863ms
	10	32	26s205ms	818ms
	11	43	41s562ms	966ms
	13	23	22s396ms	973ms
	14	47	37s510ms	798ms
	15	78	1m13s	936ms
	16	85	1m19s	934ms
	17	356	5m18s	895ms
	18	422	5m53s	836ms
	19	517	6m36s	767ms
	20	590	6m57s	707ms
	21	575	5m39s	590ms
	22	565	3m31s	374ms

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

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

Date: 2025-01-31 19:24:54 Duration: 1s159ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '260670')) 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 (70))))))) 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 (70)))))) 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 (70)))))) 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 (70))))))))) ORDER BY "policy_number"."id";

Date: 2025-01-31 19:09:25 Duration: 1s116ms

6

520ms

1s784ms

609ms

27,470

Details

4h38m49s

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Jan 31	00	154	1m40s	650ms
	01	339	3m39s	646ms
	02	189	2m7s	676ms
	03	236	2m40s	680ms
	04	170	1m51s	656ms
	05	151	1m31s	604ms
	06	140	1m26s	617ms
	07	35	22s904ms	654ms
	08	603	5m47s	576ms
	09	1,601	16m8s	604ms
	10	2,044	20m31s	602ms
	11	1,470	14m46s	603ms
	12	2,947	30m4s	612ms
	13	2,411	25m29s	634ms
	14	2,592	26m22s	610ms
	15	3,679	37m54s	618ms
	16	1,990	20m19s	612ms
	17	2,041	20m11s	593ms
	18	2,062	20m16s	589ms
	19	1,287	12m50s	599ms
	20	731	6m59s	574ms
	21	349	3m22s	579ms
	22	249	2m22s	570ms

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

Date: 2025-01-31 17:22:11 Duration: 1s784ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4822827, 4808277, 4806181, 4803919, 4803205, 4797904, 4797014, 4796018, 4793626, 4792605, 4791037, 4790921, 4790097, 4789064, 4753887, 4687466)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 17:22:11 Duration: 1s323ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4940196, 4940057, 4924323, 4926325, 4927463, 4940028, 4916492, 4919220, 4808278, 4918150, 4917091, 4912407, 4914491, 4945432, 4914606, 4923526)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:41 Duration: 1s266ms

7

520ms

1s224ms

593ms

174,642

Details

1d4h47m51s

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Jan 31	00	5,545	54m32s	590ms
	01	10,329	1h43m2s	598ms
	02	8,508	1h22m11s	579ms
	03	10,388	1h41m59s	589ms
	04	6,057	57m35s	570ms
	05	4,258	41m39s	587ms
	06	3,897	39m34s	609ms
	07	893	8m22s	562ms
	08	1,964	18m33s	567ms
	09	6,329	1h2m37s	593ms
	10	8,374	1h21m20s	582ms
	11	7,428	1h13m4s	590ms
	12	10,335	1h43m	598ms
	13	12,224	2h5m8s	614ms
	14	8,924	1h28m15s	593ms
	15	12,378	2h5m47s	609ms
	16	7,881	1h21m2s	617ms
	17	9,447	1h33m24s	593ms
	18	13,202	2h10m27s	592ms
	19	13,989	2h18m22s	593ms
	20	6,725	1h3m53s	570ms
	21	3,353	32m21s	579ms
	22	2,214	21m32s	583ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4913939)) AND (("shipping_track"."id" not in (40736981, 40739407, 40739938, 40885946, 40886103, 40912614, 40913559, 40926922, 40978707, 40978707)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:50 Duration: 1s224ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947038)) AND (("shipping_track"."id" not in (40978713, 40978713)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:51 Duration: 1s97ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4947036)) AND (("shipping_track"."id" not in (40978685, 40978685)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2025-01-31 16:33:46 Duration: 1s94ms

8

186ms

636ms

292ms

24,159

Details

1h57m45s

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Jan 31	08	431	1m49s	254ms
	09	2,241	10m18s	275ms
	10	1,313	6m17s	287ms
	11	2,797	13m19s	285ms
	12	2,211	10m43s	291ms
	13	4,896	23m48s	291ms
	14	4,033	20m50s	309ms
	15	2,691	13m9s	293ms
	16	2,849	13m54s	292ms
	17	697	3m35s	309ms

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

Date: 2025-01-31 12:04:55 Duration: 636ms
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" = '31863')))) ORDER BY "collection_policy"."id";

Date: 2025-01-31 12:05:19 Duration: 620ms
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" = '137444')))) ORDER BY "collection_policy"."id";

Date: 2025-01-31 14:34:19 Duration: 612ms

9

212ms

501ms

281ms

9,700

Details

45m34s

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Jan 31	00	725	3m19s	275ms
	01	979	4m35s	281ms
	02	399	1m49s	273ms
	03	1,380	6m23s	277ms
	05	755	3m29s	277ms
	06	1,679	7m44s	276ms
	07	2	531ms	265ms
	08	21	5s613ms	267ms
	10	47	13s177ms	280ms
	11	43	11s913ms	277ms
	12	45	13s778ms	306ms
	13	83	25s487ms	307ms
	14	24	7s472ms	311ms
	15	477	2m28s	311ms
	16	615	3m9s	308ms
	17	1,252	6m	287ms
	18	319	1m24s	266ms
	19	315	1m33s	296ms
	20	197	50s880ms	258ms
	21	235	58s847ms	250ms
	22	108	28s868ms	267ms

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

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

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

Date: 2025-01-31 16:33:49 Duration: 462ms

10

203ms

425ms

262ms

2,726

Details

11m56s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Jan 31	00	120	31s956ms	266ms
	01	120	32s676ms	272ms
	02	120	32s132ms	267ms
	03	120	32s409ms	270ms
	04	120	31s986ms	266ms
	05	120	32s17ms	266ms
	06	120	31s661ms	263ms
	07	120	31s550ms	262ms
	08	120	31s696ms	264ms
	09	120	33s65ms	275ms
	10	120	32s602ms	271ms
	11	120	32s730ms	272ms
	12	120	33s100ms	275ms
	13	120	34s400ms	286ms
	14	120	33s307ms	277ms
	15	120	34s400ms	286ms
	16	120	33s602ms	280ms
	17	116	29s42ms	250ms
	18	120	28s495ms	237ms
	19	120	28s408ms	236ms
	20	120	27s464ms	228ms
	21	120	27s290ms	227ms
	22	90	20s347ms	226ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 16:35:02 Duration: 425ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 16:35:01 Duration: 376ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2025-01-31 12:05:02 Duration: 353ms

11

208ms

518ms

260ms

1,217

Details

5m16s

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Jan 31	00	28	7s466ms	266ms
	01	61	15s642ms	256ms
	02	74	19s644ms	265ms
	03	68	17s359ms	255ms
	04	64	15s641ms	244ms
	05	39	9s660ms	247ms
	06	7	1s723ms	246ms
	07	10	2s459ms	245ms
	08	20	5s6ms	250ms
	09	89	23s417ms	263ms
	10	43	11s205ms	260ms
	11	113	29s192ms	258ms
	12	52	13s752ms	264ms
	13	91	24s816ms	272ms
	14	85	22s824ms	268ms
	15	64	17s301ms	270ms
	16	92	24s815ms	269ms
	17	73	18s744ms	256ms
	18	46	11s279ms	245ms
	19	63	16s356ms	259ms
	20	24	5s404ms	225ms
	21	8	1s805ms	225ms
	22	3	921ms	307ms

select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('227219', '55977', '143260', '142532', '9877343', '55963', '142524', '143267');

Date: 2025-01-31 19:24:51 Duration: 518ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9984293', '9984955', '9984020', '9984018', '9732946', '9984011', '9984834', '9984860');

Date: 2025-01-31 16:39:45 Duration: 488ms
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('9613121', '9905941', '9796181', '9796167', '9613080');

Date: 2025-01-31 13:56:12 Duration: 462ms

12

97ms

814ms

232ms

29,143

Details

1h52m59s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,380	9m9s	230ms
	01	3,768	13m57s	222ms
	02	1,120	4m47s	256ms
	03	2,718	10m48s	238ms
	05	1,742	6m36s	227ms
	06	3,344	12m49s	230ms
	07	4	930ms	232ms
	08	70	12s44ms	172ms
	09	2	477ms	238ms
	10	144	34s135ms	237ms
	11	168	34s220ms	203ms
	12	82	17s779ms	216ms
	13	208	49s766ms	239ms
	14	140	35s907ms	256ms
	15	1,094	4m39s	255ms
	16	1,382	6m9s	267ms
	17	3,172	12m31s	237ms
	18	1,456	5m26s	224ms
	19	1,650	6m48s	247ms
	20	1,564	5m28s	210ms
	21	1,603	5m49s	218ms
	22	1,332	4m50s	217ms

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

Date: 2025-01-31 06:09:04 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-31 06:09:04 Duration: 814ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محل')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2025-01-31 06:07:19 Duration: 796ms

13

162ms

388ms

204ms

99,820

Details

5h40m20s

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
Jan 31	00	938	3m5s	198ms
	01	2,933	9m46s	200ms
	02	2,939	9m42s	198ms
	03	2,682	9m2s	202ms
	04	2,612	8m37s	198ms
	05	1,557	5m7s	197ms
	06	665	2m12s	199ms
	07	475	1m36s	203ms
	08	1,312	4m20s	198ms
	09	5,069	17m20s	205ms
	10	2,340	7m54s	202ms
	11	6,925	23m48s	206ms
	12	3,817	13m6s	206ms
	13	10,162	35m38s	210ms
	14	8,795	30m31s	208ms
	15	7,346	25m40s	209ms
	16	13,963	51m20s	220ms
	17	9,190	31m9s	203ms
	18	4,969	15m25s	186ms
	19	7,268	23m	189ms
	20	3,678	11m18s	184ms
	21	168	30s452ms	181ms
	22	17	3s84ms	181ms

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

Date: 2025-01-31 16:33:52 Duration: 388ms
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" = '123487')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:34:56 Duration: 375ms
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" = '124593')) ORDER BY "shipping_policy"."id" DESC;

Date: 2025-01-31 16:35:01 Duration: 369ms

14

176ms

271ms

200ms

11,599

Details

38m47s

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Jan 31	00	640	2m8s	200ms
	01	2,674	8m54s	199ms
	02	2,841	9m27s	199ms
	03	2,086	7m14s	208ms
	04	2,217	7m17s	197ms
	05	1,134	3m44s	197ms
	22	7	1s274ms	182ms

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

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

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

Date: 2025-01-31 03:40:18 Duration: 262ms

15

165ms

293ms

197ms

8,894

Details

29m16s

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

Day	Hour	Count	Duration	Avg duration
Jan 31	00	138	27s68ms	196ms
	01	239	48s431ms	202ms
	03	11	2s161ms	196ms
	05	119	23s444ms	197ms
	06	139	27s692ms	199ms
	07	458	1m33s	203ms
	08	368	1m14s	201ms
	09	95	18s871ms	198ms
	10	241	49s367ms	204ms
	11	110	21s727ms	197ms
	12	265	55s115ms	207ms
	13	1,066	3m46s	212ms
	14	765	2m37s	205ms
	15	332	1m10s	212ms
	16	172	35s647ms	207ms
	17	379	1m13s	194ms
	18	1,057	3m20s	189ms
	19	1,814	5m44s	189ms
	20	986	3m	183ms
	21	132	24s5ms	181ms
	22	8	1s459ms	182ms

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

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

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

Date: 2025-01-31 19:06:20 Duration: 276ms

16

118ms

290ms

138ms

2,804

Details

6m28s

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

Times Reported Time consuming queries #16

Day	Hour	Count	Duration	Avg duration
Jan 31	00	15	1s946ms	129ms
	01	36	4s849ms	134ms
	02	2	266ms	133ms
	04	16	2s49ms	128ms
	05	5	633ms	126ms
	06	7	919ms	131ms
	07	5	657ms	131ms
	09	55	7s490ms	136ms
	10	296	40s357ms	136ms
	11	235	31s752ms	135ms
	12	470	1m4s	137ms
	13	412	58s391ms	141ms
	14	299	41s757ms	139ms
	15	250	35s718ms	142ms
	16	211	30s669ms	145ms
	17	189	26s241ms	138ms
	18	122	16s535ms	135ms
	19	54	7s416ms	137ms
	20	21	2s785ms	132ms
	21	79	10s410ms	131ms
	22	25	3s287ms	131ms

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

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

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

Date: 2025-01-31 16:33:47 Duration: 244ms

17

96ms

178ms

118ms

7,229

Details

14m17s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Jan 31	00	67	7s425ms	110ms
	01	21	2s535ms	120ms
	02	2	237ms	118ms
	05	16	1s804ms	112ms
	06	6	675ms	112ms
	08	97	11s352ms	117ms
	09	232	27s838ms	119ms
	10	389	45s936ms	118ms
	11	254	30s22ms	118ms
	12	839	1m38s	117ms
	13	1,161	2m17s	118ms
	14	866	1m41s	117ms
	15	1,543	3m2s	118ms
	16	489	57s441ms	117ms
	17	476	57s75ms	119ms
	18	230	29s284ms	127ms
	19	300	36s805ms	122ms
	20	167	19s368ms	115ms
	21	58	6s886ms	118ms
	22	16	1s927ms	120ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8062168)) AND (("cash_track"."id" not in (7532339, 7550492, 7552295, 7569741, 7569741)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 17:23:06 Duration: 178ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067055)) AND (("cash_track"."id" not in (7568112)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 16:34:06 Duration: 170ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8067477)) AND (("cash_track"."id" not in (7570478)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2025-01-31 18:22:23 Duration: 168ms

18

44ms

131ms

57ms

40,372

Details

39m1s

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Jan 31	08	640	35s637ms	55ms
	09	3,655	3m32s	58ms
	10	1,896	1m47s	56ms
	11	4,839	4m34s	56ms
	12	2,998	2m55s	58ms
	13	8,169	8m7s	59ms
	14	4,819	4m36s	57ms
	15	7,273	7m2s	58ms
	16	3,591	3m30s	58ms
	17	2,255	2m5s	55ms
	18	103	5s459ms	53ms
	19	45	2s444ms	54ms
	20	64	3s354ms	52ms
	21	15	800ms	53ms
	22	10	544ms	54ms

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

Date: 2025-01-31 16:33:41 Duration: 131ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4858775) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:42 Duration: 103ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4858267) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:42 Duration: 95ms

19

39ms

98ms

52ms

19,354

Details

16m48s

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Jan 31	08	324	16s127ms	49ms
	09	1,927	1m39s	51ms
	10	915	46s547ms	50ms
	11	2,438	2m6s	51ms
	12	1,714	1m28s	51ms
	13	3,880	3m27s	53ms
	14	3,151	2m44s	52ms
	15	2,426	2m5s	51ms
	16	1,832	1m36s	52ms
	17	742	37s428ms	50ms
	18	5	258ms	51ms

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

Date: 2025-01-31 16:34:13 Duration: 98ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4860509) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:31 Duration: 87ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4859936) ORDER BY "collection_policy"."id";

Date: 2025-01-31 16:33:31 Duration: 85ms

20

37ms

194ms

48ms

97,277

Details

1h17m50s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Jan 31	00	2,823	2m8s	45ms
	01	4,898	3m45s	46ms
	02	2,960	2m14s	45ms
	03	3,444	2m36s	45ms
	04	1,451	1m6s	45ms
	05	1,174	53s413ms	45ms
	06	1,089	49s231ms	45ms
	07	570	26s92ms	45ms
	08	1,526	1m9s	45ms
	09	4,924	3m53s	47ms
	10	6,332	4m52s	46ms
	11	6,621	5m7s	46ms
	12	7,577	5m58s	47ms
	13	10,652	8m35s	48ms
	14	6,990	5m29s	47ms
	15	9,252	7m21s	47ms
	16	6,480	5m12s	48ms
	17	4,779	4m4s	51ms
	18	4,322	3m50s	53ms
	19	3,504	3m9s	54ms
	20	2,479	2m8s	51ms
	21	2,185	1m53s	51ms
	22	1,245	1m4s	51ms

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

Date: 2025-01-31 17:22:10 Duration: 194ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4941421)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 17:22:11 Duration: 112ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4940196)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2025-01-31 16:33:39 Duration: 106ms

Time consuming prepare

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

Time consuming bind

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

Log levels

Key values

10,620,391 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	12	0.00%
DETAIL	10	0.00%
ERROR	1,678	0.02%
EVENTLOG	649	0.01%
FATAL	565	0.01%
HINT	8	0.00%
LOG	10,615,766	99.96%
STATEMENT	1,703	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
565 FATAL entries
1678 ERROR entries
0 WARNING entries
649 EVENTLOG entries

Most Frequent Errors/Events

Key values

927 Max number of times the same event was reported
2,892 Total events found

Rank

Times reported

Error

1

927

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Jan 31	00	19
	01	25
	02	5
	03	5
	04	6
	05	4
	06	4
	07	2
	08	22
	09	49
	10	45
	11	50
	12	74
	13	105
	14	69
	15	82
	16	97
	17	69
	18	61
	19	86
	20	23
	21	10
	22	15

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

733

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Jan 31	00	17
	01	21
	02	2
	03	3
	04	4
	06	2
	07	2
	08	18
	09	39
	10	37
	11	41
	12	67
	13	92
	14	55
	15	68
	16	76
	17	58
	18	35
	19	57
	20	15
	21	10
	22	14

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

3

439

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Jan 31	00	53
	01	28
	09	30
	10	105
	12	29
	13	42
	14	44
	15	23
	16	56
	17	26
	19	1
	21	2

4

439

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Jan 31	00	53
	01	28
	09	30
	10	105
	12	29
	13	42
	14	44
	15	23
	16	56
	17	26
	19	1
	21	2

5

150

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Jan 31	00	11
	01	15
	09	2
	10	27
	11	2
	12	3
	13	22
	14	32
	15	9
	16	18
	17	6
	19	2
	21	1

6

89

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Jan 31	17	89

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

7

59

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Jan 31	00	6
	01	1
	09	1
	10	11
	12	2
	13	15
	14	11
	15	4
	16	3
	17	4
	19	1

8

12

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Jan 31	17	12

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

9

8

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Jan 31	09	1
	11	1
	12	1
	13	3
	15	1
	17	1

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

10

7

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Jan 31	17	7

11

5

Details

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

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Jan 31	01	1
	06	1
	10	1
	15	1
	17	1

12

5

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Jan 31	01	1
	06	1
	10	1
	15	1
	17	1

13

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Jan 31	01	1
	06	1
	10	1
	17	1

14

4

Details

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

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Jan 31	12	2
	13	1
	21	1

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

15

2

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Jan 31	17	2

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

16

2

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Jan 31	13	1
	20	1

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

17

2

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Jan 31	13	1
	14	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

18

2

Details

FATAL: database "..." does not exist

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Jan 31	13	1
	15	1

19

1

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Jan 31	07	1

20

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Jan 31	17	1

21

1

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #21

Day	Hour	Count
Jan 31	17	1

Global information

Overview

Global Stats

SQL Traffic

Key values

SELECT Traffic

Key values

INSERT/UPDATE/DELETE Traffic

Key values

Queries duration

Key values

Prepared queries ratio

Key values

General Activity

Connections

Established Connections

Key values

Connections per database

Key values

Connections per database

Connections per user

Key values

Connections per user

Connections per host

Key values

Connections per host

Sessions

Simultaneous sessions

Key values

Histogram of session times

Key values

Sessions per database

Key values

Sessions per database

Sessions per user

Key values

Sessions per user

Sessions per host

Key values

Sessions per host

Sessions per application

Key values

Sessions per application

Checkpoints / Restartpoints

Checkpoints Buffers

Key values

Checkpoints Wal files

Key values

Checkpoints distance

Key values

Checkpoints Activity

Checkpoint causes

Key values

Temporary Files

Size of temporary files

Key values

Size of temporary files (5 minutes period)

Number of temporary files

Key values

Number of temporary files (5 minutes period)

Temporary Files Activity

Vacuums

Vacuums / Analyzes Distribution

Key values

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

Analyzes per tables

Vacuums per table

Key values

Vacuums per tables

Tuples removed per table

Key values

Tuples removed per tables

Pages removed per table

Key values

Pages removed per tables