pgBadger :: PostgreSQL Log Analyzer

Global information

Generated on Fri Dec 27 23:46:48 2024
Log file: /var/lib/pgsql/16/data/log/postgresql.log
Parsed 25,446,822 log entries in 1m46s
Log start from 2024-12-27 00:00:00 to 2024-12-27 22:45:02

Global Stats

13,424 Number of unique normalized queries
11,017,802 Number of queries
3d12h40m20s Total query duration
2024-12-27 00:00:00 First query
2024-12-27 22:45:02 Last query
4,496 queries/s at 2024-12-27 14:05:12 Query peak

3d12h40m20s Total query duration
0ms Prepare/parse total duration
0ms Bind total duration
3d12h40m20s Execute total duration

3,454 Number of events
21 Number of unique normalized events
1,225 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
11,017,802 Average queries per session
3d12h40m20s 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

4,496 queries/s Query Peak
2024-12-27 14:05:12 Date

SELECT Traffic

Key values

3,308 queries/s Query Peak
2024-12-27 14:05:12 Date

INSERT/UPDATE/DELETE Traffic

Key values

844 queries/s Query Peak
2024-12-27 16:42:11 Date

Queries duration

Key values

3d12h40m20s Total query duration

Prepared queries ratio

Key values

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

General Activity

Day	Hour	Count	Min duration	Max duration	Avg duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 27	00	302,953	0ms	4s488ms	18ms	2m42s	3m3s	3m8s
	01	257,208	0ms	4s460ms	19ms	2m47s	3m31s	4m2s
	02	233,336	0ms	1s78ms	20ms	2m18s	2m52s	3m42s
	03	184,939	0ms	1s598ms	18ms	2m10s	2m38s	2m49s
	04	197,421	0ms	573ms	20ms	2m	2m27s	2m40s
	05	244,845	0ms	4s449ms	29ms	3m21s	3m33s	4m39s
	06	166,919	0ms	589ms	21ms	2m12s	2m51s	4m5s
	07	194,431	0ms	577ms	15ms	1m48s	2m39s	3m7s
	08	404,395	0ms	4s524ms	11ms	2m32s	2m55s	3m50s
	09	516,775	0ms	42m45s	63ms	2m23s	2m59s	7h53m1s
	10	552,310	0ms	3s223ms	9ms	2m36s	3m1s	3m21s
	11	398,094	0ms	1s133ms	9ms	1m49s	2m11s	2m44s
	12	797,024	0ms	6m33s	41ms	50m52s	1h12m15s	1h38m26s
	13	1,031,062	0ms	14m27s	32ms	4m20s	50m12s	3h55m51s
	14	839,024	0ms	25m59s	12ms	4m24s	4m43s	27m1s
	15	851,783	0ms	34m32s	34ms	3m56s	4m36s	4h21m56s
	16	895,849	0ms	14s505ms	8ms	3m19s	3m35s	5m3s
	17	719,485	0ms	4m9s	20ms	6m4s	6m43s	56m35s
	18	692,528	0ms	1m26s	25ms	9m57s	12m47s	14m58s
	19	646,728	0ms	2m15s	20ms	6m43s	8m43s	10m5s
	20	385,206	0ms	1h2s	47ms	6m28s	8m20s	3h42s
	21	284,872	0ms	35m53s	105ms	1m19s	1m49s	7h37m15s
	22	220,615	0ms	59m59s	61ms	2m11s	3m17s	2h59m25s

Day	Hour	SELECT	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 27	00	161,203	33ms	2m24s	2m41s	3m3s
	01	129,849	39ms	2m10s	2m46s	3m32s
	02	119,275	39ms	1m59s	2m18s	3m16s
	03	88,348	37ms	1m40s	2m10s	2m38s
	04	95,802	42ms	1m38s	2m	2m28s
	05	129,479	55ms	2m52s	3m21s	3m34s
	06	78,855	45ms	1m34s	2m11s	3m40s
	07	103,793	29ms	1m23s	1m47s	2m50s
	08	225,569	20ms	1m58s	2m31s	3m32s
	09	298,989	15ms	2m1s	2m22s	2m58s
	10	303,940	17ms	2m7s	2m35s	3m1s
	11	206,667	17ms	1m29s	1m49s	2m31s
	12	481,146	12ms	2m26s	2m46s	3m9s
	13	619,416	14ms	3m19s	3m54s	4m26s
	14	482,686	17ms	3m8s	3m50s	4m42s
	15	509,234	15ms	3m5s	3m54s	4m12s
	16	540,672	13ms	3m6s	3m18s	4m39s
	17	430,676	26ms	4m35s	5m48s	6m43s
	18	398,184	43ms	7m30s	9m56s	13m39s
	19	382,040	33ms	5m8s	6m40s	8m42s
	20	212,135	35ms	4m7s	5m6s	8m19s
	21	161,710	16ms	1m7s	1m18s	1m49s
	22	124,621	22ms	1m39s	2m7s	3m37s

Day	Hour	INSERT	UPDATE	DELETE	COPY FROM	Average Duration	Latency Percentile(90)	Latency Percentile(95)	Latency Percentile(99)
Dec 27	00	26,658	5,732	150	0	0ms	162ms	221ms	337ms
	01	18,213	5,870	133	0	0ms	125ms	169ms	223ms
	02	20,054	4,586	151	0	0ms	114ms	164ms	221ms
	03	12,875	3,351	126	0	0ms	91ms	135ms	171ms
	04	14,556	4,316	127	0	0ms	90ms	113ms	173ms
	05	28,707	7,307	134	0	0ms	152ms	213ms	285ms
	06	10,852	4,417	132	0	0ms	79ms	100ms	202ms
	07	11,926	3,818	169	0	0ms	73ms	97ms	181ms
	08	21,021	6,464	384	0	0ms	122ms	163ms	215ms
	09	18,757	7,384	335	0	1s68ms	121ms	148ms	247ms
	10	25,360	7,044	377	0	0ms	145ms	170ms	213ms
	11	16,476	5,653	428	0	0ms	90ms	109ms	165ms
	12	30,215	9,215	458	0	680ms	190ms	255ms	1h10m34s
	13	46,848	13,802	462	0	405ms	259ms	342ms	47m38s
	14	39,071	12,787	538	0	30ms	221ms	255ms	408ms
	15	35,870	12,396	755	0	428ms	205ms	241ms	317ms
	16	33,499	10,736	463	1	0ms	199ms	275ms	371ms
	17	41,559	15,781	501	0	57ms	313ms	426ms	880ms
	18	54,118	23,110	498	0	3ms	406ms	502ms	56s948ms
	19	43,811	12,347	884	0	7ms	269ms	395ms	1m33s
	20	26,599	7,798	344	0	310ms	205ms	252ms	398ms
	21	17,350	3,494	268	0	1s299ms	82ms	112ms	770ms
	22	14,877	3,301	171	0	583ms	122ms	155ms	320ms

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

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

Day	Hour	Average Duration	Average idle time
Dec 27	00	0ms	0ms
	01	0ms	0ms
	02	0ms	0ms
	03	0ms	0ms
	04	0ms	0ms
	05	0ms	0ms
	06	0ms	0ms
	07	0ms	0ms
	08	0ms	0ms
	09	0ms	0ms
	10	0ms	0ms
	11	0ms	0ms
	12	0ms	0ms
	13	0ms	0ms
	14	0ms	0ms
	15	0ms	0ms
	16	0ms	0ms
	17	0ms	0ms
	18	0ms	0ms
	19	0ms	0ms
	20	0ms	0ms
	21	0ms	0ms
	22	0ms	0ms

↑ Back to the top of the General Activity table

Established Connections

Key values

0 connections Connection Peak
Date

Connections per database

Key values

unknown Main Database
0 connections Total

Chart
Table

Connections per database

Database	User	Count

Connections per user

Key values

unknown Main User
0 connections Total

Chart
Table

Connections per user

User	Count

Connections per host

Key values

unknown Main host with 0 connections
0 Total connections

Chart
Table

Connections per host

Host	Count

Simultaneous sessions

Key values

0 sessions Session Peak
Date

Histogram of session times

Key values

duration

Chart
Table

Range	Count	Percentage
NO DATASET

Sessions per database

Key values

unknown Main Database
0 sessions Total

Chart
Table

Sessions per database

Database	Count	Total Duration	Average Duration
NO DATASET

Sessions per user

Key values

unknown Main User
0 sessions Total

Chart
Table

Sessions per user

User	Count	Total Duration	Average Duration
NO DATASET

Sessions per host

Key values

unknown Main Host
0 sessions Total

Chart
Table

Sessions per host

Host	Count	Total Duration	Average Duration
NO DATASET

Sessions per application

Key values

unknown Main Application
0 sessions Total

Chart
Table

Sessions per application

Application	Count	Total Duration	Average Duration
NO DATASET

Checkpoints Buffers

Key values

44,657 buffers Checkpoint Peak
2024-12-27 15:06:24 Date
270.057 seconds Highest write time
0.019 seconds Sync time

Checkpoints Wal files

Key values

18 files Wal files usage Peak
2024-12-27 15:06:24 Date

Checkpoints distance

Key values

574.41 Mo Distance Peak
2024-12-27 15:06:24 Date

Checkpoints Activity

Day	Hour	Written buffers	Write time	Sync time	Total time
Dec 27	00	128,851	3,203.541s	0.033s	3,203.622s
	01	145,363	3,239.521s	0.031s	3,239.598s
	02	132,962	3,239.591s	0.03s	3,239.665s
	03	108,996	3,104.53s	0.026s	3,104.596s
	04	121,606	3,239.516s	0.026s	3,239.583s
	05	149,785	3,239.575s	0.032s	3,239.65s
	06	128,347	3,239.548s	0.036s	3,239.628s
	07	95,209	3,184.527s	0.027s	3,184.599s
	08	162,348	3,239.604s	0.048s	3,239.701s
	09	190,885	3,239.524s	0.038s	3,239.614s
	10	223,140	3,239.568s	0.037s	3,239.655s
	11	149,831	3,239.552s	0.028s	3,239.624s
	12	246,834	3,239.563s	0.048s	3,239.664s
	13	374,887	3,239.505s	0.057s	3,239.63s
	14	325,623	3,239.536s	0.045s	3,239.641s
	15	289,202	3,239.567s	0.039s	3,239.66s
	16	255,913	3,239.574s	0.042s	3,239.671s
	17	255,614	2,887.36s	0.058s	2,887.484s
	18	259,619	3,239.506s	0.041s	3,239.615s
	19	268,654	3,239.608s	0.04s	3,239.717s
	20	180,275	3,239.487s	0.043s	3,239.582s
	21	110,545	3,227.634s	0.033s	3,227.711s
	22	77,543	2,429.654s	0.036s	2,429.721s

Day	Hour	Recycled	Synced files	Longest sync	Average sync
Dec 27	00	53	3,313	0.002s	0.012s
	01	59	2,940	0.002s	0.012s
	02	52	2,787	0.002s	0.012s
	03	44	2,338	0.002s	0.012s
	04	53	2,543	0.002s	0.012s
	05	62	2,837	0.002s	0.012s
	06	51	2,175	0.011s	0.012s
	07	39	2,528	0.002s	0.012s
	08	62	3,353	0.017s	0.012s
	09	77	4,309	0.003s	0.012s
	10	86	4,195	0.002s	0.012s
	11	56	3,610	0.002s	0.012s
	12	96	4,723	0.008s	0.012s
	13	151	4,699	0.005s	0.012s
	14	132	4,954	0.002s	0.012s
	15	116	5,179	0.002s	0.012s
	16	101	5,001	0.002s	0.012s
	17	104	4,884	0.007s	0.012s
	18	107	4,911	0.002s	0.012s
	19	119	5,012	0.002s	0.012s
	20	81	4,816	0.003s	0.012s
	21	45	4,118	0.002s	0.012s
	22	32	3,026	0.009s	0.009s

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

Day	Hour	Mean distance	Mean estimate
Dec 27	00	71,783.08 kB	127,147.58 kB
	01	81,686.00 kB	114,829.18 kB
	02	71,421.67 kB	89,337.08 kB
	03	60,393.58 kB	103,278.67 kB
	04	72,569.08 kB	103,230.42 kB
	05	85,714.36 kB	97,121.45 kB
	06	70,101.75 kB	100,960.50 kB
	07	52,730.75 kB	93,504.67 kB
	08	85,495.75 kB	99,510.33 kB
	09	104,738.08 kB	149,092.17 kB
	10	117,088.25 kB	156,250.25 kB
	11	76,953.50 kB	123,920.58 kB
	12	131,302.25 kB	149,548.92 kB
	13	205,522.00 kB	240,460.08 kB
	14	184,739.00 kB	232,904.45 kB
	15	158,354.42 kB	237,906.00 kB
	16	137,377.09 kB	198,315.55 kB
	17	141,042.42 kB	177,466.33 kB
	18	147,114.08 kB	181,706.25 kB
	19	170,561.10 kB	193,907.00 kB
	20	110,697.83 kB	196,660.67 kB
	21	61,258.50 kB	143,388.58 kB
	22	58,893.22 kB	94,236.78 kB

↑ Back to the top of the Checkpoint Activity table

Checkpoint causes

Key values

time (272) Main checkpoint cause
273 checkpoints Total

Chart
Table

Cause	Number of checkpoints
time	272
shutdown immediate	1
Total	273

Size of temporary files

Key values

0 Temp Files size Peak
Date

Size of temporary files (5 minutes period)

Number of temporary files

Key values

0 per second Temp Files Peak
Date

Number of temporary files (5 minutes period)

Temporary Files Activity

Temp Files

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

↑ Back to the top of the Temporary Files Activity table

Vacuums / Analyzes Distribution

Key values

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

Autovacuum actions (5 minutes period)

Average Autovacuum Duration

Key values

0 sec Highest CPU-cost vacuum
Table
Database
Date

Average Autovacuum Duration (5 minutes average)

Analyzes per table

Key values

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

Chart
Table

Analyzes per tables

Table	Number of analyzes
NO DATASET

Vacuums per table

Key values

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

Chart
Table

Vacuums per tables

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

Tuples removed per table

Key values

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

Chart
Table

Tuples removed per tables

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

Pages removed per table

Key values

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

Chart
Table

Pages removed per tables

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

Autovacuum Activity

Vacuums / Analyzes

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

↑ Back to the top of the Autovacuum Activity table

Locks by types

Key values

unknown Main Lock Type
0 locks Total

Chart
Table

Type of locks

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

Most frequent waiting queries (N)

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

Queries that waited the most

Rank	Wait time	Query
NO DATASET

Queries by type

Key values

6,284,289 Total read queries
3,183,018 Total write queries

Chart
Table

Type	Count	Percentage
SELECT	6,284,289	57.04%
INSERT	609,272	5.53%
UPDATE	190,709	1.73%
DELETE	7,988	0.07%
COPY FROM	1	0.00%
COPY TO	0	0.00%
CTE	14,991	0.14%
DDL	1,091	0.01%
TCL	2,358,966	21.41%
CURSOR	0	0.00%
OTHERS	1,550,495	14.07%

Queries by database

Key values

unknown Main database
11,017,802 Requests
3d12h40m20s (unknown)
Main time consuming database

Chart
Table

Database	Request type	Count	Duration
unknown	Total	11,017,802	3d12h40m20s
	copy from	1	2ms
	cte	14,991	2s994ms
	ddl	1,091	156ms
	delete	7,988	10s303ms
	insert	609,272	2m59s
	others	1,550,494	1m10s
	select	6,284,289	1d17h20m16s
	tcl	2,358,966	1m34s
	update	190,709	1d19h14m6s

Queries by user

Key values

unknown Main user
11,017,802 Requests

Queries Chart
Table

User	Request type	Count	Duration
unknown	Total	11,017,802	3d12h40m20s
	copy from	1	2ms
	cte	14,991	2s994ms
	ddl	1,091	156ms
	delete	7,988	10s303ms
	insert	609,272	2m59s
	others	1,550,494	1m10s
	select	6,284,289	1d17h20m16s
	tcl	2,358,966	1m34s
	update	190,709	1d19h14m6s

Duration by user

Key values

3d12h40m20s (unknown) Main time consuming user

Duration Chart
Table

User	Request type	Count	Duration
unknown	Total	11,017,802	3d12h40m20s
	copy from	1	2ms
	cte	14,991	2s994ms
	ddl	1,091	156ms
	delete	7,988	10s303ms
	insert	609,272	2m59s
	others	1,550,494	1m10s
	select	6,284,289	1d17h20m16s
	tcl	2,358,966	1m34s
	update	190,709	1d19h14m6s

Queries by host

Key values

unknown Main host
11,017,802 Requests
3d12h40m20s (unknown)
Main time consuming host

Chart
Table

Host	Request type	Count	Duration
unknown	Total	11,017,802	3d12h40m20s
	copy from	1	2ms
	cte	14,991	2s994ms
	ddl	1,091	156ms
	delete	7,988	10s303ms
	insert	609,272	2m59s
	others	1,550,494	1m10s
	select	6,284,289	1d17h20m16s
	tcl	2,358,966	1m34s
	update	190,709	1d19h14m6s

Queries by application

Key values

unknown Main application
11,017,802 Requests
3d12h40m20s (unknown)
Main time consuming application

Chart
Table

Application	Request type	Count	Duration
unknown	Total	11,017,802	3d12h40m20s
	copy from	1	2ms
	cte	14,991	2s994ms
	ddl	1,091	156ms
	delete	7,988	10s303ms
	insert	609,272	2m59s
	others	1,550,494	1m10s
	select	6,284,289	1d17h20m16s
	tcl	2,358,966	1m34s
	update	190,709	1d19h14m6s

Number of cancelled queries

Key values

0 per second Cancelled query Peak
2024-12-27 16:31:24 Date

Number of cancelled queries (5 minutes period)

Histogram of query times

Key values

10,289,883 0-1ms duration

Chart
Table

Range	Count	Percentage
0-1ms	10,289,883	93.39%
1-5ms	151,068	1.37%
5-10ms	6,651	0.06%
10-25ms	26,355	0.24%
25-50ms	119,054	1.08%
50-100ms	15,970	0.14%
100-500ms	377,108	3.42%
500-1000ms	29,538	0.27%
1000-10000ms	1,722	0.02%
> 10000ms	453	0.00%

Slowest individual queries

Rank	Duration	Query
1	1h2s	update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.254941', exp_date = '2024-12-27 19:36:55.254943', logged_in = 'TRUE' where id = 1096; [ Date: 2024-12-27 20:51:57 ]
2	1h2s	update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.255358', exp_date = '2024-12-27 19:36:55.255361', logged_in = 'TRUE' where id = 1096; [ Date: 2024-12-27 20:51:57 ]
3	59m59s	update res_users set sid = 'd81e3aca116a939e692610f2e67cfef2c5751ecb', last_update = '2024-12-27 20:33:49.762391', exp_date = '2024-12-27 21:18:49.762394', logged_in = 'TRUE' where id = 1034; [ Date: 2024-12-27 22:33:49 ]
4	59m59s	update res_users set sid = 'd81e3aca116a939e692610f2e67cfef2c5751ecb', last_update = '2024-12-27 20:33:49.763250', exp_date = '2024-12-27 21:18:49.763254', logged_in = 'TRUE' where id = 1034; [ Date: 2024-12-27 22:33:49 ]
5	59m36s	update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:52:21.246046', exp_date = '2024-12-27 19:37:21.246048', logged_in = 'TRUE' where id = 1096; [ Date: 2024-12-27 20:51:57 ]
6	58m21s	update res_users set sid = 'd81e3aca116a939e692610f2e67cfef2c5751ecb', last_update = '2024-12-27 20:35:28.713482', exp_date = '2024-12-27 21:20:28.713484', logged_in = 'TRUE' where id = 1034; [ Date: 2024-12-27 22:33:49 ]
7	42m45s	update res_users set sid = 'b05a95cd0360dc4eaef78fde58adac8e39ae0941', last_update = '2024-12-27 07:43:35.281440', exp_date = '2024-12-27 08:28:35.281443', logged_in = 'TRUE' where id = 1083; [ Date: 2024-12-27 09:26:20 ]
8	42m45s	update res_users set sid = 'b05a95cd0360dc4eaef78fde58adac8e39ae0941', last_update = '2024-12-27 07:43:35.281440', exp_date = '2024-12-27 08:28:35.281443', logged_in = 'TRUE' where id = 1083; [ Date: 2024-12-27 09:26:20 ]
9	41m1s	update res_users set sid = 'b05a95cd0360dc4eaef78fde58adac8e39ae0941', last_update = '2024-12-27 07:45:18.984524', exp_date = '2024-12-27 08:30:18.984528', logged_in = 'TRUE' where id = 1083; [ Date: 2024-12-27 09:26:20 ]
10	35m53s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:36:26.638401', exp_date = '2024-12-27 20:21:26.638403', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
11	35m53s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:36:26.637752', exp_date = '2024-12-27 20:21:26.637754', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
12	34m32s	update res_users set sid = '4bc257a0b4c3fbab2cc8e8c4fb7fcb6e4a015e97', last_update = '2024-12-27 14:06:48.380450', exp_date = '2024-12-27 14:51:48.380454', logged_in = 'TRUE' where id = 873; [ Date: 2024-12-27 15:41:21 ]
13	34m32s	update res_users set sid = '4bc257a0b4c3fbab2cc8e8c4fb7fcb6e4a015e97', last_update = '2024-12-27 14:06:48.380102', exp_date = '2024-12-27 14:51:48.380105', logged_in = 'TRUE' where id = 873; [ Date: 2024-12-27 15:41:21 ]
14	34m18s	update res_users set sid = '4bc257a0b4c3fbab2cc8e8c4fb7fcb6e4a015e97', last_update = '2024-12-27 14:07:02.708676', exp_date = '2024-12-27 14:52:02.708680', logged_in = 'TRUE' where id = 873; [ Date: 2024-12-27 15:41:21 ]
15	33m58s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:38:22.243289', exp_date = '2024-12-27 20:23:22.243291', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
16	33m11s	update res_users set sid = '4bc257a0b4c3fbab2cc8e8c4fb7fcb6e4a015e97', last_update = '2024-12-27 14:08:09.917666', exp_date = '2024-12-27 14:53:09.917671', logged_in = 'TRUE' where id = 873; [ Date: 2024-12-27 15:41:21 ]
17	31m23s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:40:57.175228', exp_date = '2024-12-27 20:25:57.175232', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
18	31m8s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:41:12.077438', exp_date = '2024-12-27 20:26:12.077443', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
19	31m1s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:41:18.580683', exp_date = '2024-12-27 20:26:18.580687', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]
20	30m46s	update res_users set sid = '387558900edea2255e7730a389793e137caa79a6', last_update = '2024-12-27 19:41:34.107213', exp_date = '2024-12-27 20:26:34.107215', logged_in = 'TRUE' where id = 844; [ Date: 2024-12-27 21:12:20 ]

Time consuming queries (N)

Rank

Total duration

Times executed

Min duration

Max duration

Avg duration

Query

1

1d16h12m3s

38,365

Details

0ms

1h2s

3s772ms

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 27	00	801	186ms	0ms
	01	853	185ms	0ms
	02	665	145ms	0ms
	03	573	124ms	0ms
	04	619	133ms	0ms
	05	720	162ms	0ms
	06	580	127ms	0ms
	07	536	118ms	0ms
	08	1,376	310ms	0ms
	09	1,841	6h30m47s	12s736ms
	10	1,873	406ms	0ms
	11	1,324	283ms	0ms
	12	3,175	7h10m22s	8s133ms
	13	4,523	6h49m50s	5s436ms
	14	3,327	811ms	0ms
	15	3,224	5h39m2s	6s309ms
	16	2,752	15s145ms	5ms
	17	2,552	51m24s	1s208ms
	18	2,225	2m25s	65ms
	19	2,088	6m27s	185ms
	20	1,285	2h59m40s	8s389ms
	21	830	7h3m22s	30s605ms
	22	623	2h58m21s	17s176ms

update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.254941', exp_date = '2024-12-27 19:36:55.254943', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-27 20:51:57 Duration: 1h2s
update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.255358', exp_date = '2024-12-27 19:36:55.255361', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-27 20:51:57 Duration: 1h2s
update res_users set sid = 'd81e3aca116a939e692610f2e67cfef2c5751ecb', last_update = '2024-12-27 20:33:49.762391', exp_date = '2024-12-27 21:18:49.762394', logged_in = 'TRUE' where id = 1034;

Date: 2024-12-27 22:33:49 Duration: 59m59s

2

21h57m

177,151

Details

394ms

950ms

446ms

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 27	00	7,004	52m13s	447ms
	01	6,965	50m26s	434ms
	02	6,711	49m13s	440ms
	03	5,433	38m50s	429ms
	04	6,250	44m32s	427ms
	05	9,094	1h7m44s	446ms
	06	5,142	36m58s	431ms
	07	4,117	29m39s	432ms
	08	6,369	45m33s	429ms
	09	5,268	37m48s	430ms
	10	7,266	51m55s	428ms
	11	4,328	30m48s	427ms
	12	8,207	59m4s	431ms
	13	10,721	1h18m38s	440ms
	14	9,138	1h6m28s	436ms
	15	8,633	1h3m4s	438ms
	16	7,596	56m3s	442ms
	17	11,475	1h29m	465ms
	18	14,144	1h53m41s	482ms
	19	17,304	2h12m41s	460ms
	20	9,858	1h16m45s	467ms
	21	2,744	20m27s	447ms
	22	3,384	25m16s	448ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3883086)) AND (("shipping_track"."id" not in (31624872, 31625216, 31625384, 31650089, 31650192, 31691976, 31692692, 32596175, 32596175)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:29:17 Duration: 950ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993538)) AND (("shipping_track"."id" not in (32596472, 32596472)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:08 Duration: 902ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993542)) AND (("shipping_track"."id" not in (32596511, 32596511)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:16 Duration: 834ms

3

6h15m40s

101,480

Details

182ms

492ms

222ms

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
Dec 27	00	718	2m26s	204ms
	01	2,600	8m54s	205ms
	02	1,047	3m33s	203ms
	03	1,410	4m49s	205ms
	04	2,292	7m47s	203ms
	05	2,751	9m26s	205ms
	06	2,530	8m39s	205ms
	07	1,691	5m47s	205ms
	08	2,543	8m45s	206ms
	09	4,029	13m44s	204ms
	10	2,837	9m39s	204ms
	11	2,736	9m18s	204ms
	12	2,279	7m52s	207ms
	13	4,860	17m2s	210ms
	14	6,252	21m42s	208ms
	15	4,436	15m21s	207ms
	16	4,310	15m12s	211ms
	17	13,961	50m37s	217ms
	18	27,299	1h53m51s	250ms
	19	6,142	23m39s	231ms
	20	4,750	17m26s	220ms
	22	7	1s423ms	203ms

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

Date: 2024-12-27 18:29:36 Duration: 492ms
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" = '9595983')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:11 Duration: 411ms
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" = '9627935')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:20 Duration: 404ms

4

3h34m29s

28,401

Details

398ms

1s328ms

453ms

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
Dec 27	00	196	1m33s	475ms
	01	204	1m37s	479ms
	02	291	2m15s	464ms
	03	120	1m	505ms
	04	121	1m	499ms
	05	153	1m17s	505ms
	06	131	1m4s	494ms
	07	196	1m30s	464ms
	08	1,361	9m57s	439ms
	09	1,145	8m24s	440ms
	10	1,471	10m55s	445ms
	11	1,365	9m55s	436ms
	12	1,970	14m42s	447ms
	13	3,020	22m42s	451ms
	14	2,844	21m1s	443ms
	15	2,717	20m19s	448ms
	16	1,789	13m21s	448ms
	17	2,030	15m30s	458ms
	18	2,124	16m58s	479ms
	19	2,774	21m32s	465ms
	20	973	7m28s	461ms
	21	862	6m18s	439ms
	22	544	4m	441ms

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

Date: 2024-12-27 17:21:55 Duration: 1s328ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3888051)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 17:21:55 Duration: 1s2ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3883153, 3883152, 3883151, 3883150, 3883149, 3883148, 3883147, 3883146, 3883145, 3883144, 3883143, 3883142, 3883141, 3883140, 3883139, 3883138, 3883135, 3883132, 3883130, 3883127, 3883124, 3883122, 3883120, 3883117, 3883115, 3883113, 3883110, 3883108, 3883105, 3883102, 3883100, 3883097, 3883095, 3883092, 3883089, 3883086, 3883084, 3883082, 3883081, 3883080, 3883079, 3883078, 3883077, 3883076, 3883075, 3883074, 3883073, 3883072, 3883071, 3883070, 3883069, 3883068, 3883067, 3883066, 3883065, 3883064, 3883063, 3883062, 3883061, 3883060, 3882538, 3882535, 3882531, 3882528, 3882525, 3882521, 3882518, 3882514, 3882510, 3882507, 3882503, 3882500, 3882496, 3882492, 3882489, 3882485, 3882481, 3882478, 3882475, 3882472, 3882470, 3882467, 3882465, 3882462, 3882460, 3882457, 3882455, 3882452, 3882450, 3882447, 3882445)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:28:54 Duration: 864ms

5

2h55m5s

185

Details

0ms

26m41s

56s788ms

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
Dec 27	00	5	3ms	0ms
	01	1	1ms	1ms
	02	2	1ms	0ms
	05	2	3ms	1ms
	06	1	0ms	0ms
	07	6	1ms	0ms
	08	9	2ms	0ms
	09	22	1h20m22s	3m39s
	10	5	5ms	1ms
	11	2	0ms	0ms
	12	25	21m48s	52s337ms
	13	17	3m8s	11s71ms
	14	28	25m59s	55s683ms
	15	11	7m1s	38s296ms
	16	8	4ms	0ms
	17	9	3m11s	21s229ms
	18	10	9ms	0ms
	19	6	1ms	0ms
	20	8	1ms	0ms
	21	5	33m35s	6m43s
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-27 08:44:38.788028', "last_update" = '2024-12-27 07:59:38.788058', "sid" = 'c41a10faa557495f9cf6a08be28391573e6952d4', "write_date" = '2024-12-27 07:59:38.385297', "write_uid" = 1 WHERE id IN (1083);

Date: 2024-12-27 09:26:20 Duration: 26m41s
UPDATE "res_users" SET "exp_date" = '2024-12-27 14:18:48.120639', "last_update" = '2024-12-27 13:33:48.120662', "sid" = 'e7bd9a66795e69300c69d3e3618b8a7fa38259b6', "write_date" = '2024-12-27 13:33:47.796390', "write_uid" = 1 WHERE id IN (1379);

Date: 2024-12-27 14:59:47 Duration: 25m59s
UPDATE "res_users" SET "exp_date" = '2024-12-27 20:31:33.643108', "last_update" = '2024-12-27 19:46:33.643127', "sid" = '151b6d43a6c2c083c2544067191e20a3e352351a', "write_date" = '2024-12-27 19:46:33.322989', "write_uid" = 1 WHERE id IN (844);

Date: 2024-12-27 21:12:20 Duration: 25m46s

6

1h53m13s

30,687

Details

89ms

801ms

221ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 27	00	3,784	11m52s	188ms
	01	1,518	4m52s	193ms
	02	2,528	8m26s	200ms
	03	596	2m9s	217ms
	04	600	2m18s	231ms
	05	4,424	16m34s	224ms
	06	500	2m4s	249ms
	07	874	3m11s	219ms
	08	140	33s594ms	239ms
	09	402	1m25s	212ms
	10	8	1s612ms	201ms
	11	62	9s700ms	156ms
	12	172	38s309ms	222ms
	13	242	55s452ms	229ms
	14	408	1m39s	244ms
	15	574	2m7s	221ms
	16	1,390	5m35s	241ms
	17	2,340	9m37s	246ms
	18	3,719	15m27s	249ms
	19	2,172	8m48s	243ms
	20	1,586	5m47s	218ms
	21	1,178	4m16s	217ms
	22	1,470	4m36s	188ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالله')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:36 Duration: 801ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:36 Duration: 801ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:35 Duration: 792ms

7

1h13m55s

5,194

Details

233ms

1s479ms

854ms

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

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 27	00	682	8m48s	774ms
	01	298	4m54s	989ms
	02	203	3m18s	980ms
	10	2	1s984ms	992ms
	12	33	32s332ms	979ms
	13	9	8s872ms	985ms
	14	21	20s803ms	990ms
	15	119	1m57s	989ms
	16	87	1m21s	941ms
	17	520	5m33s	641ms
	18	773	11m	854ms
	19	796	13m30s	1s17ms
	20	691	8m55s	775ms
	21	474	7m35s	960ms
	22	486	5m55s	731ms

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

Date: 2024-12-27 17:23:55 Duration: 1s479ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9606441')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 18:30:14 Duration: 1s372ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9649779')) 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: 2024-12-27 18:50:17 Duration: 1s352ms

8

55m43s

86,528

Details

30ms

116ms

38ms

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

Times Reported Time consuming queries #8

Day	Hour	Count	Duration	Avg duration
Dec 27	00	3,433	2m9s	37ms
	01	2,295	1m26s	37ms
	02	2,225	1m24s	37ms
	03	1,817	1m8s	37ms
	04	1,559	59s72ms	37ms
	05	2,216	1m24s	38ms
	06	780	29s943ms	38ms
	07	1,475	55s857ms	37ms
	08	3,525	2m15s	38ms
	09	2,566	1m38s	38ms
	10	5,365	3m24s	38ms
	11	3,483	2m12s	38ms
	12	6,499	4m9s	38ms
	13	9,816	6m22s	38ms
	14	7,126	4m34s	38ms
	15	6,319	4m3s	38ms
	16	5,790	3m42s	38ms
	17	3,918	2m35s	39ms
	18	4,344	2m58s	41ms
	19	4,746	3m8s	39ms
	20	2,980	1m55s	38ms
	21	1,829	1m10s	38ms
	22	2,422	1m32s	38ms

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

Date: 2024-12-27 17:21:55 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3951039)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 17:21:55 Duration: 115ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3926735, 3908847, 3902794, 3867613, 3005001)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 18:28:22 Duration: 91ms

9

53m27s

10,432

Details

226ms

561ms

307ms

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

Times Reported Time consuming queries #9

Day	Hour	Count	Duration	Avg duration
Dec 27	00	1,245	6m14s	301ms
	01	483	2m25s	302ms
	02	1,089	5m30s	303ms
	03	302	1m29s	297ms
	04	312	1m33s	299ms
	05	2,247	11m19s	302ms
	06	254	1m18s	309ms
	07	443	2m10s	294ms
	08	73	21s916ms	300ms
	09	206	1m2s	303ms
	10	2	664ms	332ms
	11	31	9s571ms	308ms
	12	54	17s31ms	315ms
	13	116	35s990ms	310ms
	14	194	1m	310ms
	15	177	55s573ms	313ms
	16	622	3m17s	317ms
	17	672	3m32s	316ms
	18	1,123	6m8s	328ms
	19	302	1m36s	319ms
	20	107	33s293ms	311ms
	21	126	37s344ms	296ms
	22	252	1m15s	299ms

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

Date: 2024-12-27 18:30:08 Duration: 561ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9533781')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 17:22:10 Duration: 507ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510350')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 18:30:03 Duration: 484ms

10

46m12s

10,368

Details

191ms

401ms

267ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 27	08	152	43s801ms	288ms
	09	1,290	5m32s	257ms
	10	826	3m29s	253ms
	11	758	3m12s	254ms
	12	936	3m56s	252ms
	13	1,149	5m6s	266ms
	14	2,162	10m25s	289ms
	15	1,703	7m29s	263ms
	16	1,060	4m43s	267ms
	17	332	1m31s	275ms

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

Date: 2024-12-27 14:41:01 Duration: 401ms
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" = '9574229')))) ORDER BY "collection_policy"."id";

Date: 2024-12-27 14:41:12 Duration: 398ms
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" = '9574143')))) ORDER BY "collection_policy"."id";

Date: 2024-12-27 14:41:12 Duration: 397ms

11

42m26s

12,421

Details

183ms

256ms

205ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 27	00	599	2m2s	204ms
	01	2,355	8m3s	205ms
	02	1,031	3m30s	203ms
	03	1,223	4m10s	204ms
	04	2,103	7m8s	203ms
	05	2,049	7m2s	205ms
	06	2,036	6m58s	205ms
	07	622	2m7s	205ms
	08	403	1m22s	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" = '9589955')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 43, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-27 01:37:52 Duration: 246ms

12

34m14s

9,864

Details

185ms

355ms

208ms

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 27	00	119	24s367ms	204ms
	01	245	49s865ms	203ms
	03	187	38s492ms	205ms
	04	185	37s687ms	203ms
	05	169	34s327ms	203ms
	06	218	44s900ms	205ms
	07	891	3m3s	205ms
	08	1,341	4m36s	206ms
	09	476	1m38s	207ms
	10	493	1m41s	206ms
	11	216	44s283ms	205ms
	12	757	2m38s	208ms
	13	778	2m44s	211ms
	14	786	2m42s	207ms
	15	631	2m13s	211ms
	16	796	2m45s	208ms
	17	473	1m40s	213ms
	18	519	1m53s	218ms
	19	271	57s497ms	212ms
	20	306	1m3s	207ms
	22	7	1s422ms	203ms

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

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

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

Date: 2024-12-27 18:30:09 Duration: 336ms

13

16m42s

22,119

Details

36ms

89ms

45ms

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

Times Reported Time consuming queries #13

Day	Hour	Count	Duration	Avg duration
Dec 27	00	5	233ms	46ms
	02	1	49ms	49ms
	07	43	2s26ms	47ms
	08	355	16s31ms	45ms
	09	1,033	46s133ms	44ms
	10	2,551	1m53s	44ms
	11	2,359	1m44s	44ms
	12	1,501	1m7s	45ms
	13	3,089	2m21s	45ms
	14	1,737	1m18s	45ms
	15	2,655	1m59s	45ms
	16	3,562	2m40s	45ms
	17	1,484	1m8s	46ms
	18	664	31s937ms	48ms
	19	548	25s995ms	47ms
	20	222	10s514ms	47ms
	21	244	11s127ms	45ms
	22	66	2s982ms	45ms

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

Date: 2024-12-27 18:28:43 Duration: 89ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3902794) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-27 18:28:16 Duration: 86ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3860441) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-27 18:29:49 Duration: 84ms

14

11m37s

7,296

Details

79ms

185ms

95ms

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

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 27	00	1	97ms	97ms
	04	4	350ms	87ms
	07	24	2s289ms	95ms
	08	222	21s676ms	97ms
	09	194	18s345ms	94ms
	10	258	24s677ms	95ms
	11	258	24s662ms	95ms
	12	389	36s975ms	95ms
	13	1,353	2m5s	93ms
	14	891	1m22s	92ms
	15	788	1m14s	94ms
	16	557	51s887ms	93ms
	17	495	48s459ms	97ms
	18	586	59s846ms	102ms
	19	690	1m9s	101ms
	20	267	26s31ms	97ms
	21	135	12s364ms	91ms
	22	184	16s803ms	91ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7792104)) AND (("cash_track"."id" not in (5517071, 5519563, 5522723, 6272421, 6272444, 6272537, 6272555, 6272555)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 18:30:04 Duration: 185ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7772955)) AND (("cash_track"."id" not in (5391547, 5392217, 5392872, 6272425, 6272448, 6272541, 6272559, 6272559)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 18:30:05 Duration: 178ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7889204)) AND (("cash_track"."id" not in (6256946, 6257059, 6258389, 6271005, 6271490, 6271490)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 17:22:44 Duration: 168ms

15

7m38s

2,726

Details

145ms

312ms

168ms

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 27	00	120	19s856ms	165ms
	01	120	19s839ms	165ms
	02	120	19s844ms	165ms
	03	120	19s816ms	165ms
	04	120	19s862ms	165ms
	05	120	20s45ms	167ms
	06	120	19s933ms	166ms
	07	120	19s893ms	165ms
	08	120	19s899ms	165ms
	09	120	19s859ms	165ms
	10	120	19s941ms	166ms
	11	120	19s798ms	164ms
	12	120	20s187ms	168ms
	13	120	20s574ms	171ms
	14	120	20s277ms	168ms
	15	120	20s240ms	168ms
	16	120	20s423ms	170ms
	17	116	20s238ms	174ms
	18	120	21s701ms	180ms
	19	120	20s856ms	173ms
	20	120	20s347ms	169ms
	21	120	19s769ms	164ms
	22	90	14s844ms	164ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 17:22:02 Duration: 312ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 18:29:02 Duration: 296ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 18:28:02 Duration: 253ms

16

6m31s

2,914

Details

119ms

264ms

134ms

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
Dec 27	00	12	1s548ms	129ms
	02	17	2s196ms	129ms
	08	20	2s623ms	131ms
	09	86	11s361ms	132ms
	10	295	38s663ms	131ms
	11	77	10s87ms	131ms
	12	509	1m7s	133ms
	13	614	1m23s	136ms
	14	328	43s797ms	133ms
	15	242	32s432ms	134ms
	16	214	28s641ms	133ms
	17	95	13s359ms	140ms
	18	75	11s16ms	146ms
	19	140	19s294ms	137ms
	20	98	12s961ms	132ms
	21	46	6s52ms	131ms
	22	46	6s58ms	131ms

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

Date: 2024-12-27 18:29:27 Duration: 264ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 113)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-27 18:31:06 Duration: 195ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 113)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-27 18:31:10 Duration: 190ms

17

6m29s

143

Details

13ms

4s154ms

2s724ms

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	4	12s401ms	3s100ms
	10	1	3s223ms	3s223ms
	12	9	25s152ms	2s794ms
	13	11	22s840ms	2s76ms
	14	12	38s475ms	3s206ms
	15	5	16s285ms	3s257ms
	16	19	53s164ms	2s798ms
	17	18	57s632ms	3s201ms
	18	10	26s549ms	2s654ms
	19	33	1m17s	2s355ms
	20	9	28s314ms	3s146ms
	21	7	18s556ms	2s650ms
	22	5	9s256ms	1s851ms

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

Date: 2024-12-27 18:33:25 Duration: 4s154ms
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 (36))))))) 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 (36)))))) 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 (36)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))))) 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 (36))))))))) 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 (36)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-27 19:43:01 Duration: 3s985ms
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 (36))))))) 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 (36)))))) 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 (36)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))))) 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 (36))))))))) 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 (36)))))))) AND ("policy_number"."name"::text ilike '%9496007%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-27 19:43:03 Duration: 3s969ms

18

5m33s

8,205

Details

33ms

59ms

40ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 27	07	1	49ms	49ms
	08	64	2s568ms	40ms
	09	354	14s214ms	40ms
	10	1,029	41s698ms	40ms
	11	843	33s623ms	39ms
	12	485	20s83ms	41ms
	13	1,196	49s416ms	41ms
	14	971	39s500ms	40ms
	15	1,618	1m5s	40ms
	16	1,271	51s535ms	40ms
	17	371	16s10ms	43ms
	18	2	87ms	43ms

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

Date: 2024-12-27 17:12:22 Duration: 59ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3570377) ORDER BY "collection_policy"."id";

Date: 2024-12-27 17:12:22 Duration: 53ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3548350) ORDER BY "collection_policy"."id";

Date: 2024-12-27 17:12:22 Duration: 52ms

19

5m23s

1,575

Details

185ms

234ms

205ms

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

Day	Hour	Count	Duration	Avg duration
Dec 27	05	534	1m50s	206ms
	06	79	16s52ms	203ms
	07	170	35s224ms	207ms
	08	63	13s99ms	207ms
	09	476	1m37s	204ms
	10	70	14s330ms	204ms
	12	124	25s521ms	205ms
	15	59	11s934ms	202ms

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

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

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

Date: 2024-12-27 05:41:10 Duration: 232ms

20

4m36s

1,914

Details

130ms

266ms

144ms

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and (("res_partner"."type_employee" = ?) and ("res_partner"."type_driver" = ?))) 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 limit ?;

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 27	00	70	9s946ms	142ms
	01	103	14s614ms	141ms
	02	101	14s283ms	141ms
	03	90	12s786ms	142ms
	04	90	12s828ms	142ms
	05	95	13s513ms	142ms
	06	112	15s862ms	141ms
	07	92	13s124ms	142ms
	08	63	8s974ms	142ms
	09	68	9s658ms	142ms
	10	107	15s216ms	142ms
	11	41	5s824ms	142ms
	12	118	17s221ms	145ms
	13	115	17s27ms	148ms
	14	75	10s796ms	143ms
	15	106	15s604ms	147ms
	16	106	15s326ms	144ms
	17	57	8s847ms	155ms
	18	80	12s341ms	154ms
	19	87	12s832ms	147ms
	20	58	8s405ms	144ms
	21	50	7s178ms	143ms
	22	30	4s258ms	141ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 17:22:38 Duration: 266ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 18:29:08 Duration: 257ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 17:22:45 Duration: 218ms

Most frequent queries (N)

Rank

Times executed

Total duration

Min duration

Max duration

Avg duration

Query

1

1,549,865

Details

1m10s

0ms

1ms

0ms

discard all;

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 27	00	45,198	2s8ms	0ms
	01	42,163	1s931ms	0ms
	02	36,821	1s621ms	0ms
	03	33,204	1s374ms	0ms
	04	33,819	1s553ms	0ms
	05	31,907	1s632ms	0ms
	06	29,410	1s321ms	0ms
	07	30,120	1s332ms	0ms
	08	57,370	2s923ms	0ms
	09	74,982	3s191ms	0ms
	10	85,244	3s731ms	0ms
	11	69,319	2s801ms	0ms
	12	106,500	4s41ms	0ms
	13	133,904	5s606ms	0ms
	14	119,241	5s775ms	0ms
	15	114,887	5s395ms	0ms
	16	119,673	5s651ms	0ms
	17	90,290	4s50ms	0ms
	18	85,701	4s552ms	0ms
	19	81,604	4s507ms	0ms
	20	56,315	2s785ms	0ms
	21	41,079	1s498ms	0ms
	22	31,114	1s226ms	0ms

DISCARD ALL;

Date: 2024-12-27 14:36:56 Duration: 1ms
DISCARD ALL;

Date: 2024-12-27 20:05:03 Duration: 1ms
DISCARD ALL;

Date: 2024-12-27 16:41:02 Duration: 1ms

2

1,179,747

Details

17s520ms

0ms

1ms

0ms

begin isolation level repeatable read;

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 27	00	31,948	513ms	0ms
	01	30,463	485ms	0ms
	02	26,215	422ms	0ms
	03	23,517	366ms	0ms
	04	24,390	403ms	0ms
	05	23,651	423ms	0ms
	06	21,619	350ms	0ms
	07	22,166	361ms	0ms
	08	46,588	734ms	0ms
	09	57,637	802ms	0ms
	10	64,925	931ms	0ms
	11	49,657	709ms	0ms
	12	83,502	1s86ms	0ms
	13	107,200	1s402ms	0ms
	14	91,743	1s333ms	0ms
	15	88,401	1s272ms	0ms
	16	94,632	1s355ms	0ms
	17	69,597	1s26ms	0ms
	18	65,238	1s120ms	0ms
	19	62,495	1s65ms	0ms
	20	40,887	640ms	0ms
	21	30,122	395ms	0ms
	22	23,154	315ms	0ms

BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-27 13:19:16 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-27 19:46:32 Duration: 1ms
BEGIN ISOLATION LEVEL REPEATABLE READ;

Date: 2024-12-27 02:33:39 Duration: 1ms

3

792,401

Details

7s560ms

0ms

rollback;

Times Reported Time consuming queries #3

Day	Hour	Count	Duration	Avg duration
Dec 27	00	23,436	227ms	0ms
	01	21,696	203ms	0ms
	02	19,046	180ms	0ms
	03	17,166	150ms	0ms
	04	17,514	163ms	0ms
	05	16,555	171ms	0ms
	06	15,282	139ms	0ms
	07	15,732	142ms	0ms
	08	29,481	285ms	0ms
	09	38,435	342ms	0ms
	10	43,348	393ms	0ms
	11	35,267	304ms	0ms
	12	54,167	497ms	0ms
	13	67,964	661ms	0ms
	14	60,713	554ms	0ms
	15	58,389	566ms	0ms
	16	60,820	580ms	0ms
	17	45,952	472ms	0ms
	18	43,799	485ms	0ms
	19	41,591	437ms	0ms
	20	28,868	275ms	0ms
	21	21,157	181ms	0ms
	22	16,023	142ms	0ms

ROLLBACK;

Date: 2024-12-27 08:33:25 Duration: 0ms
ROLLBACK;

Date: 2024-12-27 12:47:53 Duration: 0ms
ROLLBACK;

Date: 2024-12-27 13:14:47 Duration: 0ms

4

778,764

Details

2m21s

0ms

11ms

0ms

select payload from http_sessions where sid = ?;

Times Reported Time consuming queries #4

Day	Hour	Count	Duration	Avg duration
Dec 27	00	22,667	4s323ms	0ms
	01	21,050	3s949ms	0ms
	02	18,396	3s315ms	0ms
	03	16,568	2s829ms	0ms
	04	16,886	3s152ms	0ms
	05	15,915	3s396ms	0ms
	06	14,674	2s569ms	0ms
	07	15,070	2s593ms	0ms
	08	28,811	5s360ms	0ms
	09	37,760	6s308ms	0ms
	10	42,865	7s580ms	0ms
	11	34,878	5s619ms	0ms
	12	53,253	9s456ms	0ms
	13	67,529	12s483ms	0ms
	14	60,108	10s675ms	0ms
	15	57,793	10s590ms	0ms
	16	60,083	10s719ms	0ms
	17	45,241	8s890ms	0ms
	18	43,165	9s65ms	0ms
	19	41,253	8s519ms	0ms
	20	28,484	4s916ms	0ms
	21	20,667	3s62ms	0ms
	22	15,648	2s551ms	0ms

SELECT payload FROM http_sessions WHERE sid = '7b3edc6a46edf0ef6c4b53a8e9f96908b4956fcf';

Date: 2024-12-27 19:35:04 Duration: 11ms
SELECT payload FROM http_sessions WHERE sid = 'da0c6df5123e70ca600fab865f57dc71689b7a3c';

Date: 2024-12-27 17:21:52 Duration: 10ms
SELECT payload FROM http_sessions WHERE sid = '65e7eb522b667f9959dcdf8e3b1819b738052b43';

Date: 2024-12-27 16:12:19 Duration: 8ms

5

775,723

Details

1m8s

0ms

1ms

0ms

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 27	00	22,648	2s32ms	0ms
	01	21,164	1s876ms	0ms
	02	18,492	1s619ms	0ms
	03	16,691	1s380ms	0ms
	04	16,992	1s518ms	0ms
	05	16,033	1s534ms	0ms
	06	14,788	1s270ms	0ms
	07	15,122	1s277ms	0ms
	08	28,721	2s547ms	0ms
	09	37,490	3s153ms	0ms
	10	42,677	3s709ms	0ms
	11	34,735	2s806ms	0ms
	12	53,146	4s569ms	0ms
	13	66,938	5s984ms	0ms
	14	59,595	5s53ms	0ms
	15	57,427	5s84ms	0ms
	16	59,818	5s253ms	0ms
	17	45,131	4s258ms	0ms
	18	42,876	4s273ms	0ms
	19	40,834	3s912ms	0ms
	20	28,216	2s415ms	0ms
	21	20,589	1s576ms	0ms
	22	15,600	1s252ms	0ms

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

Date: 2024-12-27 19:11:39 Duration: 1ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-27 03:07:41 Duration: 0ms
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;

Date: 2024-12-27 17:22:29 Duration: 0ms

6

493,771

Details

1m11s

0ms

18ms

0ms

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

Times Reported Time consuming queries #6

Day	Hour	Count	Duration	Avg duration
Dec 27	00	11,654	1s611ms	0ms
	01	10,416	1s608ms	0ms
	02	8,706	1s361ms	0ms
	03	7,682	1s215ms	0ms
	04	8,143	1s293ms	0ms
	05	8,186	1s425ms	0ms
	06	6,740	1s160ms	0ms
	07	7,488	1s245ms	0ms
	08	22,098	3s215ms	0ms
	09	25,182	3s370ms	0ms
	10	27,950	3s688ms	0ms
	11	18,451	2s555ms	0ms
	12	37,374	4s582ms	0ms
	13	50,866	6s422ms	0ms
	14	40,598	6s680ms	0ms
	15	37,924	5s501ms	0ms
	16	44,721	5s889ms	0ms
	17	30,301	4s163ms	0ms
	18	27,555	4s290ms	0ms
	19	26,430	4s153ms	0ms
	20	15,197	2s656ms	0ms
	21	10,951	1s482ms	0ms
	22	9,158	1s450ms	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 (981, 1102, 835, 956, 838, 979, 890, 923, 916, 904, 855, 1038, 1031, 969, 1030, 903, 947, 833, 857, 988, 1029, 953, 848, 939, 854, 978, 874, 851, 949, 1049, 1008, 832, 934, 918, 842, 1299, 1274, 847, 845, 1369);

Date: 2024-12-27 19:35:04 Duration: 18ms
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 (1270);

Date: 2024-12-27 17:21:53 Duration: 7ms
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (968);

Date: 2024-12-27 17:21:53 Duration: 7ms

7

386,815

Details

1m9s

0ms

33ms

0ms

commit;

Times Reported Time consuming queries #7

Day	Hour	Count	Duration	Avg duration
Dec 27	00	8,515	1s536ms	0ms
	01	8,765	1s506ms	0ms
	02	7,168	1s442ms	0ms
	03	6,351	1s176ms	0ms
	04	6,879	1s282ms	0ms
	05	7,093	1s531ms	0ms
	06	6,338	1s342ms	0ms
	07	6,436	1s208ms	0ms
	08	17,097	2s795ms	0ms
	09	19,173	3s242ms	0ms
	10	21,579	3s775ms	0ms
	11	14,388	2s521ms	0ms
	12	29,089	4s768ms	0ms
	13	39,131	6s608ms	0ms
	14	31,047	5s428ms	0ms
	15	29,943	5s140ms	0ms
	16	33,814	4s972ms	0ms
	17	23,601	4s486ms	0ms
	18	21,439	4s449ms	0ms
	19	20,892	4s325ms	0ms
	20	12,015	2s587ms	0ms
	21	8,945	1s558ms	0ms
	22	7,117	1s356ms	0ms

COMMIT;

Date: 2024-12-27 14:13:02 Duration: 33ms
COMMIT;

Date: 2024-12-27 18:06:52 Duration: 30ms
COMMIT;

Date: 2024-12-27 13:46:21 Duration: 30ms

8

296,646

Details

36s54ms

0ms

3ms

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
Dec 27	00	9,263	1s220ms	0ms
	01	5,664	696ms	0ms
	02	6,330	667ms	0ms
	03	4,692	574ms	0ms
	04	4,395	548ms	0ms
	05	6,106	635ms	0ms
	06	1,710	221ms	0ms
	07	3,486	409ms	0ms
	08	12,489	1s537ms	0ms
	09	14,300	1s714ms	0ms
	10	16,606	1s987ms	0ms
	11	10,912	1s406ms	0ms
	12	21,549	2s852ms	0ms
	13	29,952	3s971ms	0ms
	14	24,362	2s729ms	0ms
	15	20,483	2s497ms	0ms
	16	28,215	3s203ms	0ms
	17	18,290	2s322ms	0ms
	18	18,847	2s431ms	0ms
	19	16,948	2s20ms	0ms
	20	9,210	1s8ms	0ms
	21	6,519	676ms	0ms
	22	6,318	720ms	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 (5258299, 5099577, 5099009, 5103772, 5098978, 5099013, 5099263, 5184405, 5117202, 5102312, 5226031, 5106026, 5174814, 5100233, 5101133, 5100983);

Date: 2024-12-27 17:21:53 Duration: 3ms
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 (5099009, 5099130, 5100275, 5099709, 5099678, 5100431, 5441305, 5099035, 5099111, 5099007, 5100204, 5114135, 5265106, 5099356, 5103258, 5099010, 5099169, 5099170, 5099028, 5099026, 5099264, 5100302, 5099144, 5347380, 5136333, 5100636, 5099013, 5099224, 5099321, 5099206, 5099581, 5100952, 5099891, 5099138, 5099037, 5099313, 5099006, 5099248, 5099296, 5100762, 5309184, 5106849, 5447551, 5103356, 5099103, 5099590, 5099186, 5099014, 5168674, 5099272, 5099577, 5102053, 5115862, 5099202, 5099236, 5099008, 5099671, 5099523, 5099693, 5100181, 5100725, 5099674, 5100004, 5103078, 5103216, 5134239, 5100796, 5247928, 5437934, 5109980, 5203505, 5099382, 5103223, 5227729, 5099102, 5099027, 5099045, 5447549, 5099095, 5099244, 5099333, 5099924, 5113426, 5099415, 5113531, 5101315, 5099904, 5099119, 5099334, 5111375, 5127710, 5099949, 5447084, 5102444, 5206906, 5103799, 5099598, 5323774, 5108466, 5102265, 5443349, 5130651, 5099309, 5099864, 5099552, 5099112, 5446126, 5100624, 5101850, 5100457, 5125342, 5100719, 5098978, 5100901, 5169703, 5100241, 5100857, 5443926, 5439317, 5099503, 5443347, 5099489, 5099180, 5099445, 5099158);

Date: 2024-12-27 17:22:02 Duration: 3ms
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099010, 5123579, 5099441, 5099007, 5100719, 5099403, 5099138, 5099190, 5099008, 5099009, 5285857, 5107401, 5099013, 5099958, 5100207, 5099248, 5110328, 5101089, 5121073, 5104679, 5099980, 5105761, 5127704);

Date: 2024-12-27 17:21:54 Duration: 3ms

9

289,471

Details

16s191ms

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
Dec 27	00	6,442	380ms	0ms
	01	4,529	248ms	0ms
	02	4,281	239ms	0ms
	03	3,479	182ms	0ms
	04	3,448	190ms	0ms
	05	3,264	183ms	0ms
	06	1,832	105ms	0ms
	07	3,392	194ms	0ms
	08	11,937	654ms	0ms
	09	13,776	722ms	0ms
	10	15,715	852ms	0ms
	11	10,777	579ms	0ms
	12	22,205	1s233ms	0ms
	13	30,331	1s754ms	0ms
	14	25,259	1s298ms	0ms
	15	23,097	1s313ms	0ms
	16	27,694	1s552ms	0ms
	17	19,086	1s124ms	0ms
	18	18,588	1s176ms	0ms
	19	17,917	1s55ms	0ms
	20	9,579	511ms	0ms
	21	7,198	351ms	0ms
	22	5,645	284ms	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 (6, 55, 53, 17);

Date: 2024-12-27 13:22:44 Duration: 1ms
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (41);

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

Date: 2024-12-27 14:09:41 Duration: 0ms

10

197,010

Details

33s970ms

0ms

9ms

0ms

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 27	00	4,405	726ms	0ms
	01	3,182	550ms	0ms
	02	2,560	472ms	0ms
	03	2,156	393ms	0ms
	04	2,103	379ms	0ms
	05	1,999	392ms	0ms
	06	1,280	243ms	0ms
	07	2,670	419ms	0ms
	08	8,406	1s398ms	0ms
	09	11,057	1s672ms	0ms
	10	10,897	1s783ms	0ms
	11	6,798	1s126ms	0ms
	12	15,243	2s699ms	0ms
	13	21,931	3s822ms	0ms
	14	17,233	2s871ms	0ms
	15	15,780	2s716ms	0ms
	16	19,010	3s184ms	0ms
	17	13,495	2s467ms	0ms
	18	11,761	2s249ms	0ms
	19	10,504	1s951ms	0ms
	20	6,196	1s84ms	0ms
	21	4,464	743ms	0ms
	22	3,880	620ms	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 (8006335);

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

Date: 2024-12-27 17:21:53 Duration: 9ms
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8004672, 8004684, 8006534, 8006311, 8006398, 8006343, 8006302, 8006342, 8007496, 8004808, 8004683, 8006320, 8004675, 8004805, 8004657, 8004676, 8006300, 8006462, 8006277, 8004671, 8006303, 8007461, 8004685, 8006288, 8006324, 8007485, 8004678, 8006397, 8004714, 8004659, 8006326, 8006459, 8004670, 8006353, 8004680, 8004679);

Date: 2024-12-27 17:21:55 Duration: 2ms

11

180,270

Details

55s289ms

0ms

2ms

0ms

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

Times Reported Time consuming queries #11

Day	Hour	Count	Duration	Avg duration
Dec 27	00	2,396	720ms	0ms
	01	1,778	557ms	0ms
	02	1,314	391ms	0ms
	03	638	206ms	0ms
	04	698	223ms	0ms
	05	1,090	352ms	0ms
	06	737	236ms	0ms
	07	2,103	617ms	0ms
	08	5,149	1s582ms	0ms
	09	9,203	2s675ms	0ms
	10	7,166	2s180ms	0ms
	11	3,618	1s110ms	0ms
	12	18,778	5s586ms	0ms
	13	22,525	6s909ms	0ms
	14	13,905	4s16ms	0ms
	15	18,740	5s726ms	0ms
	16	21,000	6s441ms	0ms
	17	14,865	4s871ms	0ms
	18	9,225	3s194ms	0ms
	19	12,133	3s926ms	0ms
	20	4,915	1s447ms	0ms
	21	5,004	1s395ms	0ms
	22	3,290	919ms	0ms

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

Date: 2024-12-27 17:21:53 Duration: 2ms
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 = 976) OR r.global) ORDER BY r.id;

Date: 2024-12-27 15:04:53 Duration: 2ms
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy.cash' 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 = 1294) OR r.global) ORDER BY r.id;

Date: 2024-12-27 19:51:18 Duration: 2ms

12

177,151

Details

21h57m

394ms

950ms

446ms

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
Dec 27	00	7,004	52m13s	447ms
	01	6,965	50m26s	434ms
	02	6,711	49m13s	440ms
	03	5,433	38m50s	429ms
	04	6,250	44m32s	427ms
	05	9,094	1h7m44s	446ms
	06	5,142	36m58s	431ms
	07	4,117	29m39s	432ms
	08	6,369	45m33s	429ms
	09	5,268	37m48s	430ms
	10	7,266	51m55s	428ms
	11	4,328	30m48s	427ms
	12	8,207	59m4s	431ms
	13	10,721	1h18m38s	440ms
	14	9,138	1h6m28s	436ms
	15	8,633	1h3m4s	438ms
	16	7,596	56m3s	442ms
	17	11,475	1h29m	465ms
	18	14,144	1h53m41s	482ms
	19	17,304	2h12m41s	460ms
	20	9,858	1h16m45s	467ms
	21	2,744	20m27s	447ms
	22	3,384	25m16s	448ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3883086)) AND (("shipping_track"."id" not in (31624872, 31625216, 31625384, 31650089, 31650192, 31691976, 31692692, 32596175, 32596175)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:29:17 Duration: 950ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993538)) AND (("shipping_track"."id" not in (32596472, 32596472)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:08 Duration: 902ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993542)) AND (("shipping_track"."id" not in (32596511, 32596511)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:16 Duration: 834ms

13

137,414

Details

21s585ms

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
Dec 27	00	2,288	319ms	0ms
	01	2,073	253ms	0ms
	02	1,482	180ms	0ms
	03	734	93ms	0ms
	04	1,240	149ms	0ms
	05	1,122	145ms	0ms
	06	1,072	133ms	0ms
	07	2,657	351ms	0ms
	08	4,500	667ms	0ms
	09	7,306	1s77ms	0ms
	10	5,189	752ms	0ms
	11	2,673	381ms	0ms
	12	14,160	2s220ms	0ms
	13	15,723	2s583ms	0ms
	14	10,225	1s520ms	0ms
	15	14,355	2s312ms	0ms
	16	13,445	2s280ms	0ms
	17	11,645	1s994ms	0ms
	18	7,110	1s262ms	0ms
	19	8,339	1s449ms	0ms
	20	3,537	529ms	0ms
	21	3,507	514ms	0ms
	22	3,032	412ms	0ms

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

Date: 2024-12-27 18:11:26 Duration: 1ms
SELECT 1 FROM res_groups_users_rel WHERE uid = 844 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');

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

Date: 2024-12-27 14:05:49 Duration: 1ms

14

128,064

Details

31s999ms

0ms

15ms

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
Dec 27	00	4,432	1s145ms	0ms
	01	2,490	648ms	0ms
	02	2,974	719ms	0ms
	03	1,817	488ms	0ms
	04	1,720	479ms	0ms
	05	3,514	935ms	0ms
	06	838	239ms	0ms
	07	1,500	401ms	0ms
	08	4,598	1s284ms	0ms
	09	5,661	1s448ms	0ms
	10	6,313	1s607ms	0ms
	11	4,319	1s224ms	0ms
	12	8,570	2s552ms	0ms
	13	12,418	3s213ms	0ms
	14	10,762	2s370ms	0ms
	15	9,083	2s107ms	0ms
	16	11,879	2s710ms	0ms
	17	8,502	2s135ms	0ms
	18	8,935	2s252ms	0ms
	19	7,616	1s765ms	0ms
	20	4,329	908ms	0ms
	21	2,946	677ms	0ms
	22	2,848	681ms	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 (41644239, 41644789, 41662526, 41219932, 41690972, 41644221, 41528106, 32634177, 41644303, 41644917, 41662504, 41691102, 41475175, 41645342, 41579605, 41537658, 41645451, 41691105, 41691103, 41690665, 41529479, 41642715, 41691110, 40613538, 41583233, 41690867, 41529491, 41690917, 41645275, 41643865, 41581864, 41690975, 41644155, 41645479, 41645274, 41690667, 41625462, 41645416, 41209695, 41645415, 41644369, 41644257, 41644604, 41644951, 41690970, 41645062, 41645277, 41690782, 41662505, 41642710, 41644744, 41679318, 41644562, 41678833, 41643819, 41583445, 41583481, 41662502, 41645339, 41642704, 41743740, 41644755, 41625476, 41625483, 41645430, 41642716, 41644223, 41644952, 41690757, 41645499, 41645599, 41645217, 41581910, 41644563, 41690755, 41583528, 41645563, 41644688, 41644566, 41644588, 41625477, 41643891, 40783518, 41645218, 41303126, 41690834, 41644689, 41642693, 41644896, 41583225, 41625490, 41528676, 41579601, 41625466, 41625486, 41645201, 41644600, 41644995, 41644559, 41661958, 41679317, 41642702, 41642707, 41642706, 41642692, 41644649, 41644997, 41642705, 41644724, 41642694, 41642703, 41579604, 41625470, 41579559, 41625484, 41625487, 41643705, 41583253, 41625481, 41582039, 41625472, 41645311, 41644601, 41644326, 41643878, 41579599, 41385029, 41625478, 41625488, 41644648, 41625480, 41643766, 41579600, 41579558, 41644725, 41625475, 41644352, 41583425, 41644307, 41644603, 41583405, 41551483, 41551479, 41328120, 41625467, 41582491, 41537659, 41417999, 41579565, 41583513, 41643763, 41583529, 41582969, 41551485, 41575195, 41582743, 41625469, 41625468, 41551480, 41582929, 41537651, 41583420, 41528674, 41579561, 41551551, 41579563, 41303127, 41551491, 41582221, 41551484, 41551489, 41551482, 41551481, 41529440, 41581937, 41303128, 41551488, 41529435, 41529437, 41475949, 41528312, 41575330, 41582071, 41581678, 41529636, 41529387, 41528723, 41581676, 41476558, 41581677, 40753608, 41528915, 41528297, 41527705, 41209963, 41527904, 41475338, 41211219, 41425784, 41324284, 41425942, 41474874, 41211223, 41381231, 41324221, 41384010, 41211228, 41211222, 41211231, 41211218, 41157304, 41211220, 41156288, 40988668, 40988666, 40546545, 40782240, 40831468, 40546039);

Date: 2024-12-27 14:03:21 Duration: 15ms
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 (40870398, 41687184, 41670295, 41823728, 41499181, 41720031, 41407005, 41669048, 41297866, 41699373, 41735623, 41738693, 41845683, 41815774, 41723216, 41764527, 41802454, 41618599, 41575456);

Date: 2024-12-27 17:21:53 Duration: 8ms
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 (32640047, 41190134, 41686471, 41773792, 41698478, 41717545, 41496797, 41580530, 41665753, 41718555, 41627136, 41695680, 41720861, 41622350, 41706612, 41698567, 41666302, 41571124, 41665310, 41486925, 41708656, 41675882, 41539391, 41566255, 41550250, 41574649, 41162474, 41162481, 41162468);

Date: 2024-12-27 17:21:54 Duration: 7ms

15

105,534

Details

51s666ms

0ms

13ms

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"."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
Dec 27	00	991	941ms	0ms
	01	464	310ms	0ms
	02	338	178ms	0ms
	03	128	79ms	0ms
	04	152	100ms	0ms
	05	161	115ms	0ms
	06	226	117ms	0ms
	07	193	106ms	0ms
	08	1,503	783ms	0ms
	09	3,727	1s831ms	0ms
	10	3,024	1s397ms	0ms
	11	2,405	1s39ms	0ms
	12	2,975	1s534ms	0ms
	13	6,782	3s660ms	0ms
	14	6,501	3s38ms	0ms
	15	5,117	2s592ms	0ms
	16	5,263	3s169ms	0ms
	17	14,928	6s857ms	0ms
	18	22,788	11s69ms	0ms
	19	17,440	7s581ms	0ms
	20	9,084	4s470ms	0ms
	21	870	426ms	0ms
	22	474	265ms	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"."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 (3839991, 3941665, 3977681, 3950016, 3890605, 3941601, 3804865, 3804880, 3798623, 3108090, 3847170, 3847210, 3865080, 3905427, 3905440, 3907533, 3968412, 3973830, 3553480, 3977675, 3905505, 3774691, 3867857, 3847173, 3865083, 3905448, 3905482, 3807078, 3940138, 3888046, 3637729, 3932139, 3955370, 3845304, 3939514, 3940240, 3908592, 3904751, 3812712, 3907241, 3943497, 3924508, 3990290, 3925514, 3905488, 3925525, 3905441, 3889714, 3980602, 3939371, 3932804, 3867853, 3865056, 3931778, 3532753, 3898414, 3925488, 3870567, 3861295, 3718457, 3925541, 3937714, 3941655, 3898605, 3861363, 3941679, 3933930, 3933927, 3990125, 3871302, 3927217, 3830210, 3645838, 3796354, 3955326, 3718703, 3945867, 3951148, 3942044, 3923026, 3550965, 3952822, 3936173, 3957176, 3949774, 3949762, 3949740, 3898622, 3870131, 3923099, 3812681, 3933220, 3925064, 3943977, 3955472, 3955470, 3716211, 3932489, 3943272, 3926738, 3927070, 3867501, 3937715, 3878537, 3720260, 3926622, 3634842, 3955458, 3838488, 3943263, 3690670, 3933328, 3085630, 3905966, 3860618, 3931807, 3909823, 3952228, 3871819, 3286773, 3924842, 3865381, 3820111, 3648447, 3956663, 3923947, 3932786, 3907952, 3796972, 3946314, 3891112, 3941246, 3949558, 3887974, 3805695, 3941893, 3778551, 3927886, 3945646, 3926739, 3933468, 3934306, 3921021, 3923306, 3919773, 3902061, 3913247, 3947105, 3941969, 3939242, 3942023, 3930554, 3955512, 3656267, 3902776, 3902524, 3851354, 3902507, 3894927, 3894358, 3906057, 3907168, 3893131, 3903292, 3915701, 3924513, 3919678, 3904788, 3890695, 3905968, 3904267, 3894807, 3901870, 3871644, 3938554, 3951219, 3935281, 3940999, 3951166, 3955367, 3906853, 3955295, 3942097, 3945814, 3931589, 3932649, 3947299, 3864602, 3951214, 3931584, 3931479, 3931632, 3940690, 3504802, 3949891, 3517476, 3884629, 3931669);

Date: 2024-12-27 17:22:05 Duration: 13ms
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"."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 (3100481, 3478081, 3475431, 3440675, 3475751, 3441312, 3475762, 3440120, 3548864, 3549330, 2592264, 3545283, 3246959, 3441136, 3283402, 3598237, 3626624, 2211668, 3475292, 3440270, 3625937, 3548302, 3661707, 3626085, 3512587, 3703290, 3661751, 2328040, 3669446, 3283725, 2580045, 3248662, 2686571, 3396999, 3559074, 3246270, 3246266, 3703740, 3703617, 3248262, 3734707, 3728760, 3736975, 3736700, 3732705, 3205624, 3246749, 3765788, 3823766, 3625589, 3854197, 3767221, 3247835, 3318489, 3316491, 3319518, 3174554, 3551351, 2723605, 3478062, 3548506, 3245849, 2938132, 3089837, 2343415, 3283429, 3400954, 3627203, 3283985, 3244776, 3706544, 3402994, 3550430, 3765756, 3702784, 3703268, 2330133, 2591848, 2593108, 2595507, 2326378, 2173843, 3548465, 2962160, 3515923, 3600064, 3737475, 3854193, 3514189, 3512023, 3439677, 2390906, 3402183, 3317439, 2841975, 2461770, 3100037, 3068361, 3366954, 3378857, 3317438, 3363692, 2051595, 3437450, 3366821, 3401903, 3768223, 3548470, 3371864, 3401028, 2834056, 3438406, 1592893, 3032144, 3400102, 3440216, 3438072, 3249919, 3481141, 3441237, 3402467, 3478408, 3283715, 3371779, 3512662, 3439086, 3625746, 3478847, 3702803, 3247752, 3703846, 3548824, 3546491, 3437467, 3592750, 3734550, 3766735, 3599993, 3736789, 3475495, 3440136, 3766317, 3699894, 3400995, 3704189, 3437424, 3473036, 3248524, 3437465, 3512615, 3626258, 3363685, 3735822, 2331124, 2212169, 2775939, 3400997, 3702821, 3736189, 3681058, 3766324, 3703850, 3585647, 3051283, 3642685, 3564390, 3627160, 3732652, 3765091, 3625586, 3852274, 3477667, 3624983, 3883271, 3564972, 3195605, 3699532, 3562172, 3702759, 3598827, 3660804, 3585642, 3776011, 3539352, 3736221, 3666384, 3771340, 3736769, 3585646, 3595876, 3549766, 3432861, 3827866, 3510626, 3510620, 3517450, 3510616, 3506678, 3510622, 3510612, 3513912, 3369977, 3550106, 3234539, 3667971, 3400239, 3667304, 3086411, 2874435, 3385200, 3319525, 3099924, 3512281, 3736580, 3194652, 3550158, 3768277, 3710378, 3710376, 3565604, 3626607, 3600469, 3822525, 3822591, 3887910, 3732371, 3551669, 3510628, 3585645, 3551041, 3669208, 3483657, 3573787, 3573782, 3042271, 3483664, 3514545, 3513914, 3206247, 3407732, 3207799, 3051238, 3457962, 3585649, 3625869, 3704164, 3598248, 3655285, 3768246, 3702720, 3735880, 3539390, 3813078, 3665001, 3586443, 3704260, 3283749, 3664383, 3735887, 3824461, 3736420, 3600115, 3853380, 3433595, 3768247, 3820994, 3371781, 3515312, 3625773, 3335203, 3702747, 3783146, 3667127, 3600096, 3734773, 3852297, 3472093, 3850601, 2233071, 3661763, 3736661, 3600079, 3586439, 3548819, 3736552, 3814094, 3514178, 3736522, 3735072, 3737476, 3668389, 3664533, 3661730, 3705284, 3667671, 3883479, 3667584, 3599140, 3202990, 3627184, 3735185, 3730542, 3477551, 3478772, 3548341, 3548304, 2963053, 3720229, 3726588, 3598538, 3762787, 3667593, 3883280, 3686481, 3730113, 3202068, 3202071, 3785519, 3664521, 3562668, 3573769, 3626488, 3625571, 3170643, 3443703, 3730457, 3726585, 3733248, 3767978, 3767843, 3734562, 3735233, 3758401, 3795547, 3760940, 3784537, 3704254, 3667788, 3206805, 3562694, 3703238, 3853595, 3249367, 3699456, 3710375, 3583908, 3886935, 3853643, 3886526, 3598849, 3666609, 3666682, 3736896, 3699449, 3790574, 3762779, 3726590, 3551038, 3869834, 3509308, 3655256, 3869917, 3655263, 3776020, 3702892, 3869831, 3869820, 3655506, 3704604, 3767571, 3666967, 3820987, 3665774, 3768276, 3044827, 3196472, 3202069, 3317296, 3202070, 3369372, 3742689, 3627411, 3661731, 3585650, 3600155, 3609129, 3627008, 3626821, 3284977, 3564402, 3681061, 3703371, 3316258, 3318609, 3514543, 3819854, 3736357, 3820158, 3854070, 3357962, 3816481, 3816477, 3736205, 3284736, 3367481, 3369958, 3067296, 3400104, 3434601, 3475768, 3369146, 3295693, 3510624, 3240995, 3478735, 3457953, 3598815, 3585648, 3534217, 3669376, 3667094, 3600102, 3667097, 3532498, 3623070, 3281329, 3785298, 3816472, 3816474, 3595376, 3595446, 3733216, 3788091, 3472094, 3762784, 3762776, 3815922, 3700294, 3814419, 3457966, 3748007, 3209235, 3783096, 3806875, 3806897, 3733145, 3780108, 3664561, 3736585, 3703235, 3671614, 3669123, 3651276, 3642682, 3737484, 3704706, 3702856, 3265189, 3758393, 3758137, 3754073, 3766440, 3767517, 3824476, 3793860, 3779187, 3806857, 3827857, 3806868, 3767312, 3565233, 2635244, 3667962, 3853257, 3856560, 3653161, 3372663, 3821017, 3702793, 3385198, 3806865, 3821043, 3853590, 3598790, 3820991, 3819862, 3823070, 3779167, 3779160, 3763257, 3762785, 3767328, 3736470, 3806842, 3793800, 3813567, 3700358, 3812826, 3759213, 3668428, 3667359, 3627448, 3626044, 3703195, 3542556, 3754069, 3665003, 3704016, 3664387, 3667928, 3732691, 3763026, 3759752, 3472161, 3595462, 3844915, 3816505, 3472315, 3790591, 3067143, 3824360, 3783511, 3783133, 3783157, 3853161, 3785513, 3204431, 3512063, 3516149, 3099914, 3667958, 3667939, 3728774, 3822733, 3597751, 3771379, 3690887, 2904891, 3440499, 3516255, 3853168, 3793868, 3814095, 3700353, 3819931, 3823282, 3816655, 3370008, 3264653, 3315192, 3439671, 2962279, 3441130, 3548518, 3472786, 3595827, 3598236, 3598415, 3626033, 3209237, 3759033, 2050222, 2936884, 2874441, 3054522, 2874438, 3738278, 3869877, 3883513, 3596457, 3869815, 3375216, 3366326, 3439072, 3483660, 3500574, 3585643, 3510629, 3565052, 3625336, 3665055, 3595482, 3506644, 3664618, 3176436, 3665053, 3664563, 3664622, 3438973, 3331753, 3664620, 3664531, 3595370, 3562674, 3664559, 3595487, 3664642, 3700347, 3595490, 3595454, 3331794, 3700418, 3664630, 3665052, 3314240, 3664616, 3595423, 3700345, 3595483, 3562653, 3206242, 3664566, 3374064, 3664555, 3147983, 3595486, 3562684, 3438983, 3665128, 3665130, 3700296, 3700357, 3733221, 3700352, 3733219, 3595494, 3700351, 3665123, 3664644, 3733252, 3733244, 3664564, 3512828, 3762763, 3472092, 3734582, 3762755, 3785431, 3785382, 3513918, 3784482, 3733253, 3733220, 3582345, 3786105, 3762792, 3762754, 3733218, 3768319, 3700298, 3785250, 3472058, 3733144, 3762765, 3543175, 3786199, 3700599, 3762786, 3733243, 3754304, 3816478, 3762756, 3762770, 3785181, 3785297, 3754083, 3762762, 3786964, 3595488, 3822580, 3806894, 3700342, 3733250, 3839296, 3595470, 3785514, 3767336, 3780106, 3754348, 3783148, 3816507, 3816504, 3856555, 3815928, 3652694, 3815920, 3710379, 3785462, 3512548, 3703728, 3815914, 3438981, 2833901, 2653141, 3100476, 3664954, 3767254, 3783431, 3853189, 3625230, 3814368, 3814220, 2421066, 2685318, 3031757, 2889842, 2997627, 3767931, 3564019, 3821027, 3585375, 3814218, 2994822, 3031077, 3034985, 2292816, 3565115, 3549169, 3535577, 3549143, 3548505, 3625603, 3699536, 3625232, 3666731, 3667751, 3702726, 3777931, 3736534, 3736587, 3768192, 3784441, 3767240, 3785895, 3564016, 3779217, 3245644, 3782834, 3822256, 3819923, 3821106, 3767358, 3782614, 3853259, 3852295, 3548348, 3781520, 3815042, 3822420, 3722816, 3850781, 3852260, 3805196, 3776005, 3632033, 3869900, 3884869, 3869837, 3886953, 3626492, 3600297, 3854063, 3887006, 3869923, 3887374, 3887325, 3821011, 3866557, 3632025, 3550417, 3060998, 3787011, 3681078, 3703395, 3069854, 3739229, 3818925, 3512127, 3626043, 3702704, 3666393, 3710374, 3823801, 3477079, 3400928, 3441432, 3284038, 3401999, 3478055, 3399730, 3385194, 3471704, 3813081, 3821070, 3333152, 3509067, 1594391, 3319537, 3527767, 3273138, 3655267, 3703978, 3564761, 3545774, 3288896, 3340462, 3690630, 3548799, 3516283, 3666727, 3565238, 3854268, 3583621, 3600423, 1782167, 3250559, 3506674, 3471676, 3852924, 3703832, 3573800, 3483661, 2251907, 3728787, 3732697, 3703818, 3440596, 3820986, 3054524, 3248619, 3333937, 3317374, 3591592, 3516178, 3885640, 3586437, 3814761, 3668025, 3736638, 3565581, 3651272, 3566408, 2593682, 3793866, 3820980, 3699482, 3550431, 3669431, 3766710, 3032246, 3704017, 3210995, 3551452, 3853978, 3247008, 3703842, 3591457, 3626061, 3483659, 3583906, 3440497, 3702411, 3767786, 3550027, 3521566, 3565252, 3697656, 3565146, 3736342, 3609119, 3703627, 3518611, 3500577, 3440607, 3368031, 3517535, 3117994, 3438088, 3703546, 3514148, 3748005, 3735061, 3516949, 3861810, 3627376, 3758139, 3732573, 3564999, 3704006, 3793807, 3767452, 3696301, 2987050, 3687414, 3099872, 3318512, 3626496, 3551022, 3852301, 3810473, 3703831, 3066861, 3209231, 2650639, 3368147, 3626056, 3153756, 3481130, 3514718, 3734634, 3549737, 3551307, 3627161, 3400926, 3483662, 3758398, 3319567, 3700629, 3624969, 3609124, 3441556, 3702749, 3754079, 3591098, 3505672, 3733130, 3887738, 3627382, 3100418);

Date: 2024-12-27 18:31:06 Duration: 11ms
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."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 (3439677, 3600064, 3440675, 3823766, 3478062, 3548465, 3475751, 3475762, 3549330, 2592264, 3545283, 2331124, 2343415, 2173843, 2686571, 2328040, 2330133, 2580045, 3768223, 3100481, 3548506, 3626624, 1592893, 3032144, 3400995, 3400954, 3475495, 3319518, 2326378, 2841975, 3068361, 3514189, 3512662, 3246959, 3598237, 3402183, 3548824, 3437424, 3363692, 3371779, 3599993, 3244776, 3475292, 3440270, 3625937, 3548302, 3661707, 3661751, 3366821, 3401903, 3592750, 3512615, 3283725, 3548470, 3438406, 3550430, 3551351, 3396999, 3371864, 2390906, 3736789, 2593108, 3481141, 2461770, 3478408, 3702821, 3609119, 3703627, 3766710, 3687414, 3248524, 3854268, 3583621, 3506674, 3471676, 3066861, 3509067, 2650639, 3368147, 3626056, 3153756, 3440596, 3820986, 3054524, 3248619, 3333937, 3317374, 3565252, 3283715, 3516178, 3885640, 3586437, 3814761, 3668025, 3736638, 3591098, 3505672, 3733130, 3887738, 3478847, 3627382, 3564999, 3340462, 2593682, 3548799, 3516283, 3550431, 3032246, 3477079, 3400928, 3318512, 3626496, 3551022, 3852301, 3363685, 3821070, 3703832, 3573800, 3438088, 3702411, 3767786, 3319537, 3527767, 3521566, 3591592, 3861810, 3627376, 3400926, 3651272, 3566408, 3288896, 3069854, 3820980, 3736342, 3739229, 3818925, 3699482, 3669431, 3704017, 3210995, 3551452, 3853978, 3600423, 1782167, 3250559, 3500577, 3440607, 3368031, 3471704, 3813081, 3810473, 3483661, 2251907, 3550027, 3514718, 3546491, 3100418, 3319567, 3700629, 3624969, 3477667, 3624983, 3883271, 3702749, 3642685, 3564390, 3585642, 3776011, 3734773, 3852297, 3736189, 3609124, 3441556, 3564972, 3195605, 3699532, 3562172, 3702759, 3598827, 3660804, 3432861, 3697656, 3437467, 3539352, 3736221, 3681058, 3766324, 3754079, 3437450, 3600079, 3586439, 3548819, 3765756, 3827866, 3734550, 3686481, 3089837, 3283985, 3402994, 3627160, 3732652, 3765091, 3625586, 3854193, 3852274, 3483662, 3758398, 3666384, 3771340, 3699894, 3766317, 3549737, 3551307, 3627161, 3736580, 3736522, 3735072, 3737476, 3664533, 3661730, 3705284, 3667671, 3883479, 3736769, 3585646, 3595876, 3549766, 3703850, 3437465, 3626258, 3585647, 3051283, 3736552, 3814094, 3514178, 3194652, 3550158, 3202068, 3202071, 3785519, 3664521, 3562668, 3573769, 3626488, 3625589, 3625571, 2723605, 3170643, 3443703, 3667584, 3599140, 3202990, 3627184, 3735185, 3730542, 3477551, 3478772, 3548341, 3548304, 2963053, 3730457, 3726585, 3733248, 3767978, 3767843, 3734562, 3768277, 3710378, 3710376, 3565604, 3626607, 3600469, 3822525, 3822591, 3887910, 3732371, 3551669, 3510628, 3585645, 3551041, 3669208, 3483657, 3573787, 3573782, 3042271, 3483664, 3514545, 3513914, 3206247, 3407732, 3207799, 3051238, 3457962, 3585649, 3625869, 3704164, 3598248, 3655285, 3768246, 3702720, 3735880, 3539390, 3813078, 3665001, 3586443, 3704260, 3283749, 3664383, 3735887, 3824461, 3736420, 3600115, 3853380, 3433595, 3768247, 3820994, 3371781, 3515312, 3625773, 3335203, 3702747, 3783146, 3667127, 3600096, 3699449, 3790574, 3762779, 3758401, 3730113, 3668389, 3472093, 3850601, 3174554, 2233071, 3661763, 3283429, 3627203, 3736661, 3699456, 3710375, 3551038, 3869834, 3509308, 3655256, 3869917, 3655263, 3776020, 3564402, 3681061, 3703371, 3316258, 3318609, 3703268, 3510626, 3510620, 3517450, 3510616, 3506678, 3510622, 3510612, 3513912, 3369977, 3550106, 3234539, 3667971, 3400239, 3667304, 3086411, 2874435, 3385200, 3319525, 3099924, 3512281, 3720229, 3726588, 3742689, 3627411, 3598538, 3762787, 3667593, 3795547, 3760940, 3784537, 3704254, 3655506, 3473036, 3704604, 3514543, 2938132, 3766735, 3703846, 3726590, 3883280, 3667788, 3667094, 3600102, 3667097, 3886935, 3853643, 3886526, 3598849, 3666609, 3666682, 3736896, 3625746, 3668428, 3667359, 3627448, 3626044, 3703195, 3542556, 3754069, 3665003, 3704016, 3664387, 3667928, 3732691, 3763026, 3759752, 3472161, 3595462, 3814419, 3457966, 3706544, 3735233, 3245849, 3661731, 3585650, 3600155, 3609129, 3627008, 3626821, 3284977, 3869831, 3869820, 3206805, 3562694, 3703238, 3853595, 3249367, 3819854, 3736357, 3820158, 3854070, 3512023, 3357962, 3816481, 3816477, 3736205, 3366954, 3284736, 2051595, 3367481, 3369958, 3067296, 3400104, 3434601, 3401028, 2834056, 3249919, 3475768, 3441237, 3402467, 3478081, 3475431, 3767571, 3703235, 3671614, 3669123, 3651276, 3642682, 3737484, 3704706, 3702856, 3265189, 3758393, 3758137, 3754073, 3766440, 3767517, 3824476, 3793860, 3779187, 3806857, 3827857, 3806868, 3767312, 3565233, 2635244, 3667962, 3853257, 3856560, 3653161, 3372663, 3821017, 3702793, 3385198, 3806865, 3821043, 3853590, 3598790, 3820991, 3819862, 3823070, 3779167, 3779160, 3763257, 3762785, 3767328, 3736470, 3806842, 3666967, 3820987, 3665774, 3735822, 3768276, 3044827, 3196472, 3202069, 3317296, 3202070, 3369372, 3369146, 3295693, 3510624, 3240995, 3478735, 3457953, 3598815, 3585648, 3534217, 3669376, 3844915, 3816505, 3472315, 3704189, 3790591, 3067143, 3806875, 3806897, 3733145, 3780108, 3664561, 3736585, 3767931, 3737475, 3564019, 3748007, 3209235, 2211668, 3248662, 3783096, 3246270, 3246266, 3247835, 3316491, 3738278, 3512063, 3516149, 3441312, 3440120, 3548864, 3441136, 3283402, 3099914, 3626085, 3512587, 3703290, 3667958, 3667939, 3728774, 3669446, 3822733, 3597751, 3559074, 3771379, 3703740, 3690887, 2904891, 3734707, 3728760, 3440499, 3765788, 3516255, 3854197, 3853168, 3783511, 3819931, 3823282, 3816655, 3702892, 3583908, 3532498, 3623070, 3281329, 3785298, 3816472, 3816474, 3595376, 3595446, 3733216, 3788091, 3472094, 3762784, 3762776, 3815922, 3700294, 3824360, 3793868, 3814095, 3700353, 3783133, 3783157, 3853161, 3793800, 3813567, 3700358, 3812826, 3759213, 3370008, 3869877, 3883513, 3596457, 3869815, 3375216, 3366326, 3439072, 3483660, 3500574, 3585643, 3510629, 3565052, 3625336, 3665055, 3595482, 3506644, 3664618, 3176436, 3665053, 3664563, 3664622, 3438973, 3331753, 3664620, 3664531, 3595370, 3562674, 3664559, 3595487, 3664642, 3700347, 3595490, 3595454, 3331794, 3700418, 3664630, 3665052, 3314240, 3664616, 3595423, 3700345, 3595483, 3562653, 3206242, 3664566, 3374064, 3664555, 3147983, 3595486, 3562684, 3438983, 3665128, 3665130, 3700296, 3700357, 3733221, 3700352, 3733219, 3595494, 3700351, 3665123, 3664644, 3733252, 3733244, 3664564, 3512828, 3762763, 3472092, 3734582, 3762755, 3785431, 3785382, 3664954, 3767254, 3783431, 3853189, 3625230, 3814368, 3814220, 2889842, 3031077, 2962160, 2997627, 3513918, 3784482, 3733253, 3733220, 3582345, 3786105, 3762792, 3762754, 3733218, 3768319, 3700298, 3785250, 3472058, 3733144, 3762765, 3543175, 3786199, 3700599, 3762786, 3733243, 3754304, 3816478, 3762756, 3762770, 3785181, 3785297, 3754083, 3762762, 3786964, 3595488, 3787011, 3806894, 3700342, 3733250, 3839296, 3595470, 3785514, 3767336, 3780106, 3754348, 3783148, 3816507, 3816504, 3856555, 3815928, 3652694, 3815920, 3710379, 3785462, 3512548, 3703728, 3815914, 3438981, 2833901, 2685318, 3031757, 2936884, 2874441, 3060998, 2292816, 3565115, 3549169, 3535577, 3549143, 3548505, 3625603, 3699536, 3625232, 3666731, 3667751, 3702726, 3777931, 3736534, 3736587, 3768192, 3784441, 3767240, 3785895, 3564016, 3779217, 3245644, 3782834, 3822256, 3819923, 3821106, 3767358, 3782614, 3853259, 3852295, 3548348, 3781520, 3815042, 3822420, 3722816, 3850781, 3852260, 3805196, 3776005, 3632033, 3869900, 3884869, 3869837, 3886953, 3626492, 3600297, 3854063, 3887006, 3869923, 3887374, 3887325, 3821011, 3866557, 3632025, 3550417, 2050222, 2421066, 2212169, 2775939, 2653141, 3054522, 2874438, 3785513, 3400997, 3821027, 3585375, 3814218, 3767221, 3100037, 3248262, 3205624, 3246749, 3318489, 3378857, 3317438, 3400102, 3440216, 3438072, 3703617, 3736975, 3736700, 3732705, 3204431, 3264653, 3315192, 3439671, 2962279, 3441130, 3548518, 3472786, 3595827, 3598236, 3598415, 3626033, 3209237, 3759033, 2591848, 2595507, 2994822, 3034985, 3822580, 3100476, 3681078, 3758139, 3732573, 3545774, 3565581, 3702784, 2987050, 3440136, 3702704, 3666393, 3565238, 3710374, 3823801, 3518611, 3247008, 3703842, 3591457, 3852924, 3439086, 3483659, 3583906, 3440497, 3703546, 3514148, 3703978, 3564761, 3735061, 3516949, 3703395, 3565146, 3793866, 3767452, 3696301, 3247752, 3512127, 3626043, 3666727, 3099872, 3441432, 3284038, 3401999, 3478055, 3399730, 3385194, 3517535, 3117994, 3626061, 3703831, 3333152, 3209231, 3515923, 1594391, 3728787, 3732697, 3703818, 3481130, 3273138, 3655267, 3748005, 3734634, 3702803, 3317439, 3690630, 3704006, 3793807);

Date: 2024-12-27 18:41:41 Duration: 9ms

16

101,480

Details

6h15m40s

182ms

492ms

222ms

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
Dec 27	00	718	2m26s	204ms
	01	2,600	8m54s	205ms
	02	1,047	3m33s	203ms
	03	1,410	4m49s	205ms
	04	2,292	7m47s	203ms
	05	2,751	9m26s	205ms
	06	2,530	8m39s	205ms
	07	1,691	5m47s	205ms
	08	2,543	8m45s	206ms
	09	4,029	13m44s	204ms
	10	2,837	9m39s	204ms
	11	2,736	9m18s	204ms
	12	2,279	7m52s	207ms
	13	4,860	17m2s	210ms
	14	6,252	21m42s	208ms
	15	4,436	15m21s	207ms
	16	4,310	15m12s	211ms
	17	13,961	50m37s	217ms
	18	27,299	1h53m51s	250ms
	19	6,142	23m39s	231ms
	20	4,750	17m26s	220ms
	22	7	1s423ms	203ms

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

Date: 2024-12-27 18:29:36 Duration: 492ms
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" = '9595983')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:11 Duration: 411ms
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" = '9627935')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:20 Duration: 404ms

17

99,354

Details

7s420ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 27	00	2,474	187ms	0ms
	01	1,650	125ms	0ms
	02	1,668	129ms	0ms
	03	1,504	110ms	0ms
	04	1,396	107ms	0ms
	05	1,276	113ms	0ms
	06	578	45ms	0ms
	07	1,024	68ms	0ms
	08	4,162	294ms	0ms
	09	4,996	344ms	0ms
	10	5,695	396ms	0ms
	11	3,722	261ms	0ms
	12	7,702	573ms	0ms
	13	10,717	845ms	0ms
	14	8,766	669ms	0ms
	15	7,194	587ms	0ms
	16	9,859	823ms	0ms
	17	6,197	472ms	0ms
	18	6,169	473ms	0ms
	19	5,509	363ms	0ms
	20	3,073	199ms	0ms
	21	2,095	114ms	0ms
	22	1,928	112ms	0ms

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

Date: 2024-12-27 18:10:08 Duration: 1ms
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);

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

Date: 2024-12-27 14:10:20 Duration: 0ms

18

86,528

Details

55m43s

30ms

116ms

38ms

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

Times Reported Time consuming queries #18

Day	Hour	Count	Duration	Avg duration
Dec 27	00	3,433	2m9s	37ms
	01	2,295	1m26s	37ms
	02	2,225	1m24s	37ms
	03	1,817	1m8s	37ms
	04	1,559	59s72ms	37ms
	05	2,216	1m24s	38ms
	06	780	29s943ms	38ms
	07	1,475	55s857ms	37ms
	08	3,525	2m15s	38ms
	09	2,566	1m38s	38ms
	10	5,365	3m24s	38ms
	11	3,483	2m12s	38ms
	12	6,499	4m9s	38ms
	13	9,816	6m22s	38ms
	14	7,126	4m34s	38ms
	15	6,319	4m3s	38ms
	16	5,790	3m42s	38ms
	17	3,918	2m35s	39ms
	18	4,344	2m58s	41ms
	19	4,746	3m8s	39ms
	20	2,980	1m55s	38ms
	21	1,829	1m10s	38ms
	22	2,422	1m32s	38ms

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

Date: 2024-12-27 17:21:55 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3951039)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 17:21:55 Duration: 115ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3926735, 3908847, 3902794, 3867613, 3005001)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 18:28:22 Duration: 91ms

19

81,651

Details

5s142ms

0ms

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

Times Reported Time consuming queries #19

Day	Hour	Count	Duration	Avg duration
Dec 27	00	2,137	99ms	0ms
	01	2,077	91ms	0ms
	02	2,057	83ms	0ms
	03	1,971	74ms	0ms
	04	1,773	65ms	0ms
	05	1,631	69ms	0ms
	06	866	40ms	0ms
	07	1,269	69ms	0ms
	08	3,405	171ms	0ms
	09	3,642	231ms	0ms
	10	4,283	217ms	0ms
	11	2,591	125ms	0ms
	12	7,436	536ms	0ms
	13	8,856	625ms	0ms
	14	6,379	359ms	0ms
	15	6,260	469ms	0ms
	16	6,235	480ms	0ms
	17	4,627	370ms	0ms
	18	4,341	307ms	0ms
	19	4,694	358ms	0ms
	20	1,969	106ms	0ms
	21	1,745	115ms	0ms
	22	1,407	71ms	0ms

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

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

Date: 2024-12-27 14:22:04 Duration: 0ms
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 40, 41, 42, 46, 47, 49, 50, 51, 52, 59, 60, 61, 62, 64, 66, 67, 69, 72, 73, 83, 95, 97, 100, 108, 109, 112, 113, 114, 115);

Date: 2024-12-27 07:22:12 Duration: 0ms

20

80,910

Details

26s602ms

0ms

1ms

0ms

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 27	00	8,409	2s419ms	0ms
	01	5,044	1s801ms	0ms
	02	6,693	2s133ms	0ms
	03	2,861	1s147ms	0ms
	04	3,426	1s407ms	0ms
	05	11,211	3s476ms	0ms
	06	3,199	1s370ms	0ms
	07	2,861	1s4ms	0ms
	08	1,358	607ms	0ms
	09	1,815	716ms	0ms
	10	745	369ms	0ms
	11	211	75ms	0ms
	12	855	359ms	0ms
	13	726	272ms	0ms
	14	1,121	382ms	0ms
	15	1,613	571ms	0ms
	16	3,242	1s43ms	0ms
	17	4,885	1s484ms	0ms
	18	7,516	2s248ms	0ms
	19	4,580	1s397ms	0ms
	20	3,230	922ms	0ms
	21	2,360	609ms	0ms
	22	2,949	778ms	0ms

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

Date: 2024-12-27 17:22:11 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 27) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";

Date: 2024-12-27 10:18:20 Duration: 1ms
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 6) AND ("price_list"."to_office_id" = 17)) ORDER BY "price_list"."id";

Date: 2024-12-27 17:23:11 Duration: 1ms

Normalized slowest queries (N)

Rank

Min duration

Max duration

Avg duration

Times executed

Total duration

Query

1

0ms

26m41s

56s788ms

185

Details

2h55m5s

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

Times Reported Time consuming queries #1

Day	Hour	Count	Duration	Avg duration
Dec 27	00	5	3ms	0ms
	01	1	1ms	1ms
	02	2	1ms	0ms
	05	2	3ms	1ms
	06	1	0ms	0ms
	07	6	1ms	0ms
	08	9	2ms	0ms
	09	22	1h20m22s	3m39s
	10	5	5ms	1ms
	11	2	0ms	0ms
	12	25	21m48s	52s337ms
	13	17	3m8s	11s71ms
	14	28	25m59s	55s683ms
	15	11	7m1s	38s296ms
	16	8	4ms	0ms
	17	9	3m11s	21s229ms
	18	10	9ms	0ms
	19	6	1ms	0ms
	20	8	1ms	0ms
	21	5	33m35s	6m43s
	22	3	4ms	1ms

UPDATE "res_users" SET "exp_date" = '2024-12-27 08:44:38.788028', "last_update" = '2024-12-27 07:59:38.788058', "sid" = 'c41a10faa557495f9cf6a08be28391573e6952d4', "write_date" = '2024-12-27 07:59:38.385297', "write_uid" = 1 WHERE id IN (1083);

Date: 2024-12-27 09:26:20 Duration: 26m41s
UPDATE "res_users" SET "exp_date" = '2024-12-27 14:18:48.120639', "last_update" = '2024-12-27 13:33:48.120662', "sid" = 'e7bd9a66795e69300c69d3e3618b8a7fa38259b6', "write_date" = '2024-12-27 13:33:47.796390', "write_uid" = 1 WHERE id IN (1379);

Date: 2024-12-27 14:59:47 Duration: 25m59s
UPDATE "res_users" SET "exp_date" = '2024-12-27 20:31:33.643108', "last_update" = '2024-12-27 19:46:33.643127', "sid" = '151b6d43a6c2c083c2544067191e20a3e352351a', "write_date" = '2024-12-27 19:46:33.322989', "write_uid" = 1 WHERE id IN (844);

Date: 2024-12-27 21:12:20 Duration: 25m46s

2

0ms

1h2s

3s772ms

38,365

Details

1d16h12m3s

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

Times Reported Time consuming queries #2

Day	Hour	Count	Duration	Avg duration
Dec 27	00	801	186ms	0ms
	01	853	185ms	0ms
	02	665	145ms	0ms
	03	573	124ms	0ms
	04	619	133ms	0ms
	05	720	162ms	0ms
	06	580	127ms	0ms
	07	536	118ms	0ms
	08	1,376	310ms	0ms
	09	1,841	6h30m47s	12s736ms
	10	1,873	406ms	0ms
	11	1,324	283ms	0ms
	12	3,175	7h10m22s	8s133ms
	13	4,523	6h49m50s	5s436ms
	14	3,327	811ms	0ms
	15	3,224	5h39m2s	6s309ms
	16	2,752	15s145ms	5ms
	17	2,552	51m24s	1s208ms
	18	2,225	2m25s	65ms
	19	2,088	6m27s	185ms
	20	1,285	2h59m40s	8s389ms
	21	830	7h3m22s	30s605ms
	22	623	2h58m21s	17s176ms

update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.254941', exp_date = '2024-12-27 19:36:55.254943', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-27 20:51:57 Duration: 1h2s
update res_users set sid = '9a5160ee441fc5d7c88f7764a44a8b4b7a03c3ec', last_update = '2024-12-27 18:51:55.255358', exp_date = '2024-12-27 19:36:55.255361', logged_in = 'TRUE' where id = 1096;

Date: 2024-12-27 20:51:57 Duration: 1h2s
update res_users set sid = 'd81e3aca116a939e692610f2e67cfef2c5751ecb', last_update = '2024-12-27 20:33:49.762391', exp_date = '2024-12-27 21:18:49.762394', logged_in = 'TRUE' where id = 1034;

Date: 2024-12-27 22:33:49 Duration: 59m59s

3

13ms

4s154ms

2s724ms

143

Details

6m29s

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	4	12s401ms	3s100ms
	10	1	3s223ms	3s223ms
	12	9	25s152ms	2s794ms
	13	11	22s840ms	2s76ms
	14	12	38s475ms	3s206ms
	15	5	16s285ms	3s257ms
	16	19	53s164ms	2s798ms
	17	18	57s632ms	3s201ms
	18	10	26s549ms	2s654ms
	19	33	1m17s	2s355ms
	20	9	28s314ms	3s146ms
	21	7	18s556ms	2s650ms
	22	5	9s256ms	1s851ms

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

Date: 2024-12-27 18:33:25 Duration: 4s154ms
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 (36))))))) 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 (36)))))) 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 (36)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))))) 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 (36))))))))) 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 (36)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-27 19:43:01 Duration: 3s985ms
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 (36))))))) 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 (36)))))) 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 (36)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))))) 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 (36))))))))) 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 (36)))))))) AND ("policy_number"."name"::text ilike '%9496007%')) ORDER BY "policy_number"."id" LIMIT 8;

Date: 2024-12-27 19:43:03 Duration: 3s969ms

4

233ms

1s479ms

854ms

5,194

Details

1h13m55s

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	682	8m48s	774ms
	01	298	4m54s	989ms
	02	203	3m18s	980ms
	10	2	1s984ms	992ms
	12	33	32s332ms	979ms
	13	9	8s872ms	985ms
	14	21	20s803ms	990ms
	15	119	1m57s	989ms
	16	87	1m21s	941ms
	17	520	5m33s	641ms
	18	773	11m	854ms
	19	796	13m30s	1s17ms
	20	691	8m55s	775ms
	21	474	7m35s	960ms
	22	486	5m55s	731ms

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

Date: 2024-12-27 17:23:55 Duration: 1s479ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9606441')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 18:30:14 Duration: 1s372ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9649779')) 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: 2024-12-27 18:50:17 Duration: 1s352ms

5

398ms

1s328ms

453ms

28,401

Details

3h34m29s

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

Times Reported Time consuming queries #5

Day	Hour	Count	Duration	Avg duration
Dec 27	00	196	1m33s	475ms
	01	204	1m37s	479ms
	02	291	2m15s	464ms
	03	120	1m	505ms
	04	121	1m	499ms
	05	153	1m17s	505ms
	06	131	1m4s	494ms
	07	196	1m30s	464ms
	08	1,361	9m57s	439ms
	09	1,145	8m24s	440ms
	10	1,471	10m55s	445ms
	11	1,365	9m55s	436ms
	12	1,970	14m42s	447ms
	13	3,020	22m42s	451ms
	14	2,844	21m1s	443ms
	15	2,717	20m19s	448ms
	16	1,789	13m21s	448ms
	17	2,030	15m30s	458ms
	18	2,124	16m58s	479ms
	19	2,774	21m32s	465ms
	20	973	7m28s	461ms
	21	862	6m18s	439ms
	22	544	4m	441ms

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

Date: 2024-12-27 17:21:55 Duration: 1s328ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3888051)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 17:21:55 Duration: 1s2ms
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3883153, 3883152, 3883151, 3883150, 3883149, 3883148, 3883147, 3883146, 3883145, 3883144, 3883143, 3883142, 3883141, 3883140, 3883139, 3883138, 3883135, 3883132, 3883130, 3883127, 3883124, 3883122, 3883120, 3883117, 3883115, 3883113, 3883110, 3883108, 3883105, 3883102, 3883100, 3883097, 3883095, 3883092, 3883089, 3883086, 3883084, 3883082, 3883081, 3883080, 3883079, 3883078, 3883077, 3883076, 3883075, 3883074, 3883073, 3883072, 3883071, 3883070, 3883069, 3883068, 3883067, 3883066, 3883065, 3883064, 3883063, 3883062, 3883061, 3883060, 3882538, 3882535, 3882531, 3882528, 3882525, 3882521, 3882518, 3882514, 3882510, 3882507, 3882503, 3882500, 3882496, 3882492, 3882489, 3882485, 3882481, 3882478, 3882475, 3882472, 3882470, 3882467, 3882465, 3882462, 3882460, 3882457, 3882455, 3882452, 3882450, 3882447, 3882445)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:28:54 Duration: 864ms

6

394ms

950ms

446ms

177,151

Details

21h57m

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	7,004	52m13s	447ms
	01	6,965	50m26s	434ms
	02	6,711	49m13s	440ms
	03	5,433	38m50s	429ms
	04	6,250	44m32s	427ms
	05	9,094	1h7m44s	446ms
	06	5,142	36m58s	431ms
	07	4,117	29m39s	432ms
	08	6,369	45m33s	429ms
	09	5,268	37m48s	430ms
	10	7,266	51m55s	428ms
	11	4,328	30m48s	427ms
	12	8,207	59m4s	431ms
	13	10,721	1h18m38s	440ms
	14	9,138	1h6m28s	436ms
	15	8,633	1h3m4s	438ms
	16	7,596	56m3s	442ms
	17	11,475	1h29m	465ms
	18	14,144	1h53m41s	482ms
	19	17,304	2h12m41s	460ms
	20	9,858	1h16m45s	467ms
	21	2,744	20m27s	447ms
	22	3,384	25m16s	448ms

SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3883086)) AND (("shipping_track"."id" not in (31624872, 31625216, 31625384, 31650089, 31650192, 31691976, 31692692, 32596175, 32596175)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:29:17 Duration: 950ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993538)) AND (("shipping_track"."id" not in (32596472, 32596472)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:08 Duration: 902ms
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3993542)) AND (("shipping_track"."id" not in (32596511, 32596511)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";

Date: 2024-12-27 18:30:16 Duration: 834ms

7

226ms

561ms

307ms

10,432

Details

53m27s

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	1,245	6m14s	301ms
	01	483	2m25s	302ms
	02	1,089	5m30s	303ms
	03	302	1m29s	297ms
	04	312	1m33s	299ms
	05	2,247	11m19s	302ms
	06	254	1m18s	309ms
	07	443	2m10s	294ms
	08	73	21s916ms	300ms
	09	206	1m2s	303ms
	10	2	664ms	332ms
	11	31	9s571ms	308ms
	12	54	17s31ms	315ms
	13	116	35s990ms	310ms
	14	194	1m	310ms
	15	177	55s573ms	313ms
	16	622	3m17s	317ms
	17	672	3m32s	316ms
	18	1,123	6m8s	328ms
	19	302	1m36s	319ms
	20	107	33s293ms	311ms
	21	126	37s344ms	296ms
	22	252	1m15s	299ms

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

Date: 2024-12-27 18:30:08 Duration: 561ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9533781')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 17:22:10 Duration: 507ms
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9510350')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";

Date: 2024-12-27 18:30:03 Duration: 484ms

8

191ms

401ms

267ms

10,368

Details

46m12s

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
Dec 27	08	152	43s801ms	288ms
	09	1,290	5m32s	257ms
	10	826	3m29s	253ms
	11	758	3m12s	254ms
	12	936	3m56s	252ms
	13	1,149	5m6s	266ms
	14	2,162	10m25s	289ms
	15	1,703	7m29s	263ms
	16	1,060	4m43s	267ms
	17	332	1m31s	275ms

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

Date: 2024-12-27 14:41:01 Duration: 401ms
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" = '9574229')))) ORDER BY "collection_policy"."id";

Date: 2024-12-27 14:41:12 Duration: 398ms
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" = '9574143')))) ORDER BY "collection_policy"."id";

Date: 2024-12-27 14:41:12 Duration: 397ms

9

182ms

492ms

222ms

101,480

Details

6h15m40s

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	718	2m26s	204ms
	01	2,600	8m54s	205ms
	02	1,047	3m33s	203ms
	03	1,410	4m49s	205ms
	04	2,292	7m47s	203ms
	05	2,751	9m26s	205ms
	06	2,530	8m39s	205ms
	07	1,691	5m47s	205ms
	08	2,543	8m45s	206ms
	09	4,029	13m44s	204ms
	10	2,837	9m39s	204ms
	11	2,736	9m18s	204ms
	12	2,279	7m52s	207ms
	13	4,860	17m2s	210ms
	14	6,252	21m42s	208ms
	15	4,436	15m21s	207ms
	16	4,310	15m12s	211ms
	17	13,961	50m37s	217ms
	18	27,299	1h53m51s	250ms
	19	6,142	23m39s	231ms
	20	4,750	17m26s	220ms
	22	7	1s423ms	203ms

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

Date: 2024-12-27 18:29:36 Duration: 492ms
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" = '9595983')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:11 Duration: 411ms
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" = '9627935')) ORDER BY "shipping_policy"."id" DESC;

Date: 2024-12-27 18:29:20 Duration: 404ms

10

89ms

801ms

221ms

30,687

Details

1h53m13s

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

Times Reported Time consuming queries #10

Day	Hour	Count	Duration	Avg duration
Dec 27	00	3,784	11m52s	188ms
	01	1,518	4m52s	193ms
	02	2,528	8m26s	200ms
	03	596	2m9s	217ms
	04	600	2m18s	231ms
	05	4,424	16m34s	224ms
	06	500	2m4s	249ms
	07	874	3m11s	219ms
	08	140	33s594ms	239ms
	09	402	1m25s	212ms
	10	8	1s612ms	201ms
	11	62	9s700ms	156ms
	12	172	38s309ms	222ms
	13	242	55s452ms	229ms
	14	408	1m39s	244ms
	15	574	2m7s	221ms
	16	1,390	5m35s	241ms
	17	2,340	9m37s	246ms
	18	3,719	15m27s	249ms
	19	2,172	8m48s	243ms
	20	1,586	5m47s	218ms
	21	1,178	4m16s	217ms
	22	1,470	4m36s	188ms

SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'عبدالله')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:36 Duration: 801ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:36 Duration: 801ms
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;

Date: 2024-12-27 18:44:35 Duration: 792ms

11

185ms

355ms

208ms

9,864

Details

34m14s

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

Day	Hour	Count	Duration	Avg duration
Dec 27	00	119	24s367ms	204ms
	01	245	49s865ms	203ms
	03	187	38s492ms	205ms
	04	185	37s687ms	203ms
	05	169	34s327ms	203ms
	06	218	44s900ms	205ms
	07	891	3m3s	205ms
	08	1,341	4m36s	206ms
	09	476	1m38s	207ms
	10	493	1m41s	206ms
	11	216	44s283ms	205ms
	12	757	2m38s	208ms
	13	778	2m44s	211ms
	14	786	2m42s	207ms
	15	631	2m13s	211ms
	16	796	2m45s	208ms
	17	473	1m40s	213ms
	18	519	1m53s	218ms
	19	271	57s497ms	212ms
	20	306	1m3s	207ms
	22	7	1s422ms	203ms

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

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

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

Date: 2024-12-27 18:30:09 Duration: 336ms

12

185ms

234ms

205ms

1,575

Details

5m23s

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

Times Reported Time consuming queries #12

Day	Hour	Count	Duration	Avg duration
Dec 27	05	534	1m50s	206ms
	06	79	16s52ms	203ms
	07	170	35s224ms	207ms
	08	63	13s99ms	207ms
	09	476	1m37s	204ms
	10	70	14s330ms	204ms
	12	124	25s521ms	205ms
	15	59	11s934ms	202ms

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

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

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

Date: 2024-12-27 05:41:10 Duration: 232ms

13

183ms

256ms

205ms

12,421

Details

42m26s

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
Dec 27	00	599	2m2s	204ms
	01	2,355	8m3s	205ms
	02	1,031	3m30s	203ms
	03	1,223	4m10s	204ms
	04	2,103	7m8s	203ms
	05	2,049	7m2s	205ms
	06	2,036	6m58s	205ms
	07	622	2m7s	205ms
	08	403	1m22s	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" = '9589955')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 36, 37, 40, 41, 42, 43, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;

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

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

Date: 2024-12-27 01:37:52 Duration: 246ms

14

145ms

312ms

168ms

2,726

Details

7m38s

select name from shipping_policy order by create_date desc limit ?;

Times Reported Time consuming queries #14

Day	Hour	Count	Duration	Avg duration
Dec 27	00	120	19s856ms	165ms
	01	120	19s839ms	165ms
	02	120	19s844ms	165ms
	03	120	19s816ms	165ms
	04	120	19s862ms	165ms
	05	120	20s45ms	167ms
	06	120	19s933ms	166ms
	07	120	19s893ms	165ms
	08	120	19s899ms	165ms
	09	120	19s859ms	165ms
	10	120	19s941ms	166ms
	11	120	19s798ms	164ms
	12	120	20s187ms	168ms
	13	120	20s574ms	171ms
	14	120	20s277ms	168ms
	15	120	20s240ms	168ms
	16	120	20s423ms	170ms
	17	116	20s238ms	174ms
	18	120	21s701ms	180ms
	19	120	20s856ms	173ms
	20	120	20s347ms	169ms
	21	120	19s769ms	164ms
	22	90	14s844ms	164ms

select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 17:22:02 Duration: 312ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 18:29:02 Duration: 296ms
select name from shipping_policy order by create_date desc limit 10;

Date: 2024-12-27 18:28:02 Duration: 253ms

15

130ms

266ms

144ms

1,914

Details

4m36s

select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and (("res_partner"."type_employee" = ?) and ("res_partner"."type_driver" = ?))) 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 limit ?;

Times Reported Time consuming queries #15

Day	Hour	Count	Duration	Avg duration
Dec 27	00	70	9s946ms	142ms
	01	103	14s614ms	141ms
	02	101	14s283ms	141ms
	03	90	12s786ms	142ms
	04	90	12s828ms	142ms
	05	95	13s513ms	142ms
	06	112	15s862ms	141ms
	07	92	13s124ms	142ms
	08	63	8s974ms	142ms
	09	68	9s658ms	142ms
	10	107	15s216ms	142ms
	11	41	5s824ms	142ms
	12	118	17s221ms	145ms
	13	115	17s27ms	148ms
	14	75	10s796ms	143ms
	15	106	15s604ms	147ms
	16	106	15s326ms	144ms
	17	57	8s847ms	155ms
	18	80	12s341ms	154ms
	19	87	12s832ms	147ms
	20	58	8s405ms	144ms
	21	50	7s178ms	143ms
	22	30	4s258ms	141ms

SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 17:22:38 Duration: 266ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 18:29:08 Duration: 257ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) 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 LIMIT 8;

Date: 2024-12-27 17:22:45 Duration: 218ms

16

119ms

264ms

134ms

2,914

Details

6m31s

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
Dec 27	00	12	1s548ms	129ms
	02	17	2s196ms	129ms
	08	20	2s623ms	131ms
	09	86	11s361ms	132ms
	10	295	38s663ms	131ms
	11	77	10s87ms	131ms
	12	509	1m7s	133ms
	13	614	1m23s	136ms
	14	328	43s797ms	133ms
	15	242	32s432ms	134ms
	16	214	28s641ms	133ms
	17	95	13s359ms	140ms
	18	75	11s16ms	146ms
	19	140	19s294ms	137ms
	20	98	12s961ms	132ms
	21	46	6s52ms	131ms
	22	46	6s58ms	131ms

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

Date: 2024-12-27 18:29:27 Duration: 264ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 113)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-27 18:31:06 Duration: 195ms
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 113)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;

Date: 2024-12-27 18:31:10 Duration: 190ms

17

79ms

185ms

95ms

7,296

Details

11m37s

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

Times Reported Time consuming queries #17

Day	Hour	Count	Duration	Avg duration
Dec 27	00	1	97ms	97ms
	04	4	350ms	87ms
	07	24	2s289ms	95ms
	08	222	21s676ms	97ms
	09	194	18s345ms	94ms
	10	258	24s677ms	95ms
	11	258	24s662ms	95ms
	12	389	36s975ms	95ms
	13	1,353	2m5s	93ms
	14	891	1m22s	92ms
	15	788	1m14s	94ms
	16	557	51s887ms	93ms
	17	495	48s459ms	97ms
	18	586	59s846ms	102ms
	19	690	1m9s	101ms
	20	267	26s31ms	97ms
	21	135	12s364ms	91ms
	22	184	16s803ms	91ms

SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7792104)) AND (("cash_track"."id" not in (5517071, 5519563, 5522723, 6272421, 6272444, 6272537, 6272555, 6272555)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 18:30:04 Duration: 185ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7772955)) AND (("cash_track"."id" not in (5391547, 5392217, 5392872, 6272425, 6272448, 6272541, 6272559, 6272559)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 18:30:05 Duration: 178ms
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7889204)) AND (("cash_track"."id" not in (6256946, 6257059, 6258389, 6271005, 6271490, 6271490)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";

Date: 2024-12-27 17:22:44 Duration: 168ms

18

36ms

89ms

45ms

22,119

Details

16m42s

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
Dec 27	00	5	233ms	46ms
	02	1	49ms	49ms
	07	43	2s26ms	47ms
	08	355	16s31ms	45ms
	09	1,033	46s133ms	44ms
	10	2,551	1m53s	44ms
	11	2,359	1m44s	44ms
	12	1,501	1m7s	45ms
	13	3,089	2m21s	45ms
	14	1,737	1m18s	45ms
	15	2,655	1m59s	45ms
	16	3,562	2m40s	45ms
	17	1,484	1m8s	46ms
	18	664	31s937ms	48ms
	19	548	25s995ms	47ms
	20	222	10s514ms	47ms
	21	244	11s127ms	45ms
	22	66	2s982ms	45ms

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

Date: 2024-12-27 18:28:43 Duration: 89ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3902794) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-27 18:28:16 Duration: 86ms
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3860441) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";

Date: 2024-12-27 18:29:49 Duration: 84ms

19

33ms

59ms

40ms

8,205

Details

5m33s

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
Dec 27	07	1	49ms	49ms
	08	64	2s568ms	40ms
	09	354	14s214ms	40ms
	10	1,029	41s698ms	40ms
	11	843	33s623ms	39ms
	12	485	20s83ms	41ms
	13	1,196	49s416ms	41ms
	14	971	39s500ms	40ms
	15	1,618	1m5s	40ms
	16	1,271	51s535ms	40ms
	17	371	16s10ms	43ms
	18	2	87ms	43ms

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

Date: 2024-12-27 17:12:22 Duration: 59ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3570377) ORDER BY "collection_policy"."id";

Date: 2024-12-27 17:12:22 Duration: 53ms
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3548350) ORDER BY "collection_policy"."id";

Date: 2024-12-27 17:12:22 Duration: 52ms

20

30ms

116ms

38ms

86,528

Details

55m43s

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

Times Reported Time consuming queries #20

Day	Hour	Count	Duration	Avg duration
Dec 27	00	3,433	2m9s	37ms
	01	2,295	1m26s	37ms
	02	2,225	1m24s	37ms
	03	1,817	1m8s	37ms
	04	1,559	59s72ms	37ms
	05	2,216	1m24s	38ms
	06	780	29s943ms	38ms
	07	1,475	55s857ms	37ms
	08	3,525	2m15s	38ms
	09	2,566	1m38s	38ms
	10	5,365	3m24s	38ms
	11	3,483	2m12s	38ms
	12	6,499	4m9s	38ms
	13	9,816	6m22s	38ms
	14	7,126	4m34s	38ms
	15	6,319	4m3s	38ms
	16	5,790	3m42s	38ms
	17	3,918	2m35s	39ms
	18	4,344	2m58s	41ms
	19	4,746	3m8s	39ms
	20	2,980	1m55s	38ms
	21	1,829	1m10s	38ms
	22	2,422	1m32s	38ms

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

Date: 2024-12-27 17:21:55 Duration: 116ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3951039)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 17:21:55 Duration: 115ms
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3926735, 3908847, 3902794, 3867613, 3005001)) ORDER BY "shipping_policy_items"."id" DESC;

Date: 2024-12-27 18:28:22 Duration: 91ms

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

11,024,261 Event entries
(EVENTLOG entries are formaly LOG level entries that are not queries)

Chart
Table

Type	Count	Percentage
CONTEXT	7	0.00%
DETAIL	12	0.00%
ERROR	2,359	0.02%
EVENTLOG	549	0.00%
FATAL	546	0.00%
HINT	3	0.00%
LOG	11,018,403	99.95%
STATEMENT	2,382	0.02%

Events distribution (except queries)

Key values

0 PANIC entries
546 FATAL entries
2359 ERROR entries
0 WARNING entries
549 EVENTLOG entries

Most Frequent Errors/Events

Key values

1,225 Max number of times the same event was reported
3,454 Total events found

Rank

Times reported

Error

1

1,225

Details

ERROR: could not serialize access due to concurrent update

Times Reported Most Frequent Error / Event #1

Day	Hour	Count
Dec 27	00	11
	01	10
	02	3
	03	2
	04	4
	05	4
	06	6
	07	6
	08	44
	09	49
	10	49
	11	17
	12	171
	13	165
	14	152
	15	147
	16	59
	17	101
	18	92
	19	73
	20	39
	21	9
	22	12

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

2

1,119

Details

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

Times Reported Most Frequent Error / Event #2

Day	Hour	Count
Dec 27	00	10
	01	10
	04	3
	05	2
	06	3
	07	6
	08	43
	09	48
	10	47
	11	17
	12	166
	13	158
	14	142
	15	143
	16	59
	17	92
	18	74
	19	44
	20	33
	21	9
	22	10

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

416

Details

FATAL: connection to client lost

Times Reported Most Frequent Error / Event #3

Day	Hour	Count
Dec 27	09	31
	12	190
	13	79
	14	1
	15	55
	17	28
	20	2
	21	28
	22	2

4

416

Details

LOG: could not send data to client: Broken pipe

Times Reported Most Frequent Error / Event #4

Day	Hour	Count
Dec 27	09	31
	12	190
	13	79
	14	1
	15	55
	17	28
	20	2
	21	28
	22	2

LOG: could not send data to client: Broken pipe

5

97

Details

ERROR: unexpected EOF on client connection with an open transaction

Times Reported Most Frequent Error / Event #5

Day	Hour	Count
Dec 27	09	6
	12	43
	13	18
	14	5
	15	11
	17	6
	20	1
	21	6
	22	1

6

85

Details

FATAL: terminating connection due to administrator command

Times Reported Most Frequent Error / Event #6

Day	Hour	Count
Dec 27	17	85

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

7

35

Details

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

Times Reported Most Frequent Error / Event #7

Day	Hour	Count
Dec 27	12	16
	13	8
	15	6
	17	3
	21	2

8

20

Details

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

Times Reported Most Frequent Error / Event #8

Day	Hour	Count
Dec 27	17	20

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

9

6

Details

FATAL: the database system is shutting down

Times Reported Most Frequent Error / Event #9

Day	Hour	Count
Dec 27	17	6

10

6

Details

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

Times Reported Most Frequent Error / Event #10

Day	Hour	Count
Dec 27	13	3
	18	3

FATAL: password authentication failed for user "postgres"

11

4

Details

FATAL: no PostgreSQL user name specified in startup packet

Times Reported Most Frequent Error / Event #11

Day	Hour	Count
Dec 27	03	1
	16	1
	17	1
	18	1

12

4

Details

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

Times Reported Most Frequent Error / Event #12

Day	Hour	Count
Dec 27	17	4

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

13

3

Details

FATAL: the database system is starting up

Times Reported Most Frequent Error / Event #13

Day	Hour	Count
Dec 27	17	3

14

3

Details

ERROR: deadlock detected

Times Reported Most Frequent Error / Event #14

Day	Hour	Count
Dec 27	18	2
	20	1

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

15

3

Details

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

Times Reported Most Frequent Error / Event #15

Day	Hour	Count
Dec 27	03	1
	16	1
	17	1

16

3

Details

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

Times Reported Most Frequent Error / Event #16

Day	Hour	Count
Dec 27	13	2
	18	1

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

17

3

Details

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

Times Reported Most Frequent Error / Event #17

Day	Hour	Count
Dec 27	03	1
	16	1
	17	1

18

2

Details

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

Times Reported Most Frequent Error / Event #18

Day	Hour	Count
Dec 27	01	2

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

19

2

Details

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

Times Reported Most Frequent Error / Event #19

Day	Hour	Count
Dec 27	12	1
	16	1

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

20

1

Details

ERROR: could not serialize access due to concurrent delete

Times Reported Most Frequent Error / Event #20

Day	Hour	Count
Dec 27	18	1

ERROR: could not serialize access due to concurrent delete

21

1

Details

LOG: database system was shut down at ...

Times Reported Most Frequent Error / Event #21

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