pgBadger-
Global information
- Generated on Tue Mar 11 23:47:26 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 39,637,302 log entries in 2m25s
- Log start from 2025-03-11 00:00:00 to 2025-03-11 19:45:01
-
Overview
Global Stats
- 17,958 Number of unique normalized queries
- 16,672,794 Number of queries
- 7d7h52m45s Total query duration
- 2025-03-11 00:00:00 First query
- 2025-03-11 19:45:01 Last query
- 2,530 queries/s at 2025-03-11 16:13:03 Query peak
- 7d7h52m45s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7d7h52m45s Execute total duration
- 3,550 Number of events
- 20 Number of unique normalized events
- 1,421 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
- 16,672,794 Average queries per session
- 7d7h52m45s 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
- 2,530 queries/s Query Peak
- 2025-03-11 16:13:03 Date
SELECT Traffic
Key values
- 1,567 queries/s Query Peak
- 2025-03-11 16:13:03 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 839 queries/s Query Peak
- 2025-03-11 19:08:37 Date
Queries duration
Key values
- 7d7h52m45s 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
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 11 00 462,079 0ms 48s6ms 32ms 6m36s 8m7s 8m39s 01 330,311 0ms 5s603ms 38ms 6m56s 7m49s 8m45s 02 320,994 0ms 3s787ms 33ms 5m33s 6m3s 6m20s 03 262,369 0ms 3s581ms 37ms 4m41s 5m17s 7m12s 04 272,254 0ms 1s888ms 27ms 3m33s 4m32s 5m21s 05 330,318 0ms 6s320ms 44ms 6m10s 6m24s 8m15s 06 429,465 0ms 2s47ms 45ms 9m31s 10m31s 11m46s 07 330,496 0ms 2s835ms 45ms 8m4s 8m59s 15m11s 08 534,966 0ms 2m30s 29ms 7m47s 8m53s 12m18s 09 1,167,364 0ms 51s367ms 23ms 11m8s 12m45s 13m22s 10 1,497,237 0ms 4m30s 37ms 22m45s 26m5s 30m5s 11 1,640,454 0ms 8m25s 56ms 34m56s 37m19s 41m41s 12 1,821,511 0ms 5m58s 45ms 32m14s 33m34s 35m40s 13 1,697,843 0ms 4m21s 39ms 27m26s 28m14s 39m9s 14 1,511,043 0ms 11m46s 48ms 28m52s 31m11s 32m43s 15 1,336,090 0ms 1m19s 41ms 24m12s 25m53s 30m 16 986,052 0ms 1m7s 25ms 12m5s 13m29s 16m18s 17 449,133 0ms 49s359ms 22ms 6m23s 7m2s 7m29s 18 703,622 0ms 49s334ms 17ms 5m59s 6m43s 7m56s 19 589,193 0ms 3m47s 19ms 5m49s 7m14s 10m4s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 11 00 255,576 0 58ms 5m57s 6m35s 8m7s 01 175,692 0 72ms 4m55s 6m55s 8m12s 02 166,005 0 65ms 4m28s 5m32s 6m9s 03 141,225 0 69ms 4m 4m41s 5m39s 04 151,059 0 49ms 2m43s 3m32s 4m37s 05 185,815 0 79ms 5m19s 6m10s 7m28s 06 240,486 0 81ms 6m56s 9m31s 11m34s 07 186,022 0 80ms 6m35s 8m3s 13m18s 08 317,782 0 48ms 6m 7m46s 11m20s 09 679,441 0 40ms 9m45s 11m7s 12m59s 10 853,498 0 64ms 20m18s 22m44s 26m2s 11 929,456 0 97ms 30m14s 34m3s 40m28s 12 1,039,500 0 79ms 29m29s 31m45s 33m32s 13 968,261 0 67ms 25m11s 26m57s 32m53s 14 873,495 0 81ms 26m9s 28m41s 31m9s 15 775,405 0 70ms 22m30s 24m11s 27m15s 16 589,816 0 43ms 10m9s 12m3s 13m34s 17 239,820 0 41ms 4m6s 6m22s 7m1s 18 408,159 0 29ms 5m17s 5m58s 6m55s 19 340,151 0 32ms 4m57s 5m48s 7m41s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 11 00 44,769 7,785 150 0 0ms 250ms 304ms 471ms 01 29,070 6,227 138 0 0ms 182ms 259ms 314ms 02 26,215 5,175 114 0 0ms 158ms 203ms 316ms 03 23,048 4,748 98 0 0ms 145ms 199ms 232ms 04 16,285 4,337 174 0 0ms 161ms 267ms 495ms 05 34,098 9,003 211 0 0ms 252ms 311ms 416ms 06 47,280 11,036 167 0 0ms 302ms 382ms 479ms 07 33,709 6,722 105 0 0ms 280ms 339ms 461ms 08 29,632 8,605 168 0 4ms 211ms 272ms 918ms 09 63,032 14,762 846 0 0ms 423ms 522ms 685ms 10 88,838 23,035 1,079 0 5ms 815ms 1s67ms 43s331ms 11 105,417 23,597 1,076 0 15ms 1s144ms 20s623ms 3m48s 12 102,083 22,612 1,207 0 5ms 938ms 1s122ms 25s269ms 13 95,460 19,414 741 0 6ms 832ms 1s115ms 1m14s 14 85,730 19,752 763 0 15ms 754ms 878ms 3m19s 15 74,515 16,659 897 0 0ms 561ms 682ms 1s157ms 16 63,849 13,981 903 1 0ms 605ms 754ms 1s381ms 17 25,964 5,939 312 0 0ms 188ms 249ms 367ms 18 35,712 8,868 496 0 0ms 242ms 309ms 406ms 19 32,170 7,197 512 0 6ms 265ms 343ms 429ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 11 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% Day Hour Count Average / Second Mar 11 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s Day Hour Count Average Duration Average idle time Mar 11 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 115,380 buffers Checkpoint Peak
- 2025-03-11 14:59:40 Date
- 270.050 seconds Highest write time
- 0.020 seconds Sync time
Checkpoints Wal files
Key values
- 56 files Wal files usage Peak
- 2025-03-11 14:59:40 Date
Checkpoints distance
Key values
- 1,784.61 Mo Distance Peak
- 2025-03-11 14:59:40 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 11 00 230,034 3,239.555s 0.044s 3,239.654s 01 236,163 2,969.618s 0.04s 2,969.72s 02 215,590 3,239.565s 0.033s 3,239.65s 03 152,408 3,239.567s 0.032s 3,239.646s 04 152,487 2,429.422s 0.056s 2,429.524s 05 206,483 3,239.495s 0.039s 3,239.588s 06 229,562 3,239.57s 0.048s 3,239.691s 07 214,156 3,163.06s 0.05s 3,163.173s 08 164,455 3,239.569s 0.038s 3,239.67s 09 479,153 3,239.453s 0.053s 3,239.607s 10 613,188 2,970.249s 0.085s 2,970.465s 11 719,045 3,239.495s 0.083s 3,239.725s 12 774,443 3,239.342s 0.073s 3,239.572s 13 711,861 2,969.724s 0.079s 2,969.945s 14 632,878 3,239.455s 0.069s 3,239.649s 15 513,507 3,239.468s 0.065s 3,239.643s 16 358,520 2,489.681s 0.089s 2,489.849s 17 141,297 3,093.944s 0.053s 3,094.047s 18 188,536 3,239.566s 0.041s 3,239.661s 19 204,572 2,429.653s 0.029s 2,429.726s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 11 00 0 0 112 4,505 0.002s 0.012s 01 0 0 103 3,829 0.007s 0.012s 02 0 0 94 3,731 0.002s 0.012s 03 0 0 67 3,399 0.003s 0.012s 04 0 0 62 2,961 0.015s 0.011s 05 0 0 92 3,679 0.002s 0.012s 06 0 0 103 3,634 0.009s 0.012s 07 0 0 97 3,426 0.003s 0.013s 08 0 0 70 3,503 0.003s 0.012s 09 0 0 205 5,067 0.003s 0.012s 10 0 0 264 5,326 0.003s 0.012s 11 0 0 317 5,343 0.003s 0.012s 12 0 0 342 5,637 0.003s 0.012s 13 0 0 315 5,491 0.006s 0.012s 14 0 0 285 5,611 0.003s 0.012s 15 0 0 211 5,645 0.002s 0.012s 16 0 0 145 5,283 0.010s 0.012s 17 0 0 57 4,440 0.004s 0.013s 18 0 0 76 4,840 0.002s 0.012s 19 0 0 82 3,827 0.002s 0.009s Day Hour Count Avg time (sec) Mar 11 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s Day Hour Mean distance Mean estimate Mar 11 00 154,100.25 kB 319,385.00 kB 01 139,722.58 kB 180,348.50 kB 02 128,659.25 kB 196,810.67 kB 03 91,235.92 kB 149,491.17 kB 04 93,196.55 kB 120,395.45 kB 05 125,396.92 kB 154,583.17 kB 06 139,784.58 kB 173,933.25 kB 07 123,343.15 kB 185,055.92 kB 08 94,922.92 kB 125,323.25 kB 09 280,296.33 kB 317,659.75 kB 10 360,518.92 kB 381,533.58 kB 11 432,837.00 kB 485,586.83 kB 12 466,426.92 kB 534,583.83 kB 13 430,395.75 kB 483,806.58 kB 14 388,788.42 kB 483,555.00 kB 15 281,285.91 kB 621,571.82 kB 16 197,839.92 kB 278,242.83 kB 17 72,454.62 kB 117,251.46 kB 18 103,612.58 kB 145,313.00 kB 19 149,075.22 kB 206,262.11 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 11 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 -
Vacuums
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)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 11 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 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
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
Queries by type
Key values
- 9,516,664 Total read queries
- 4,869,535 Total write queries
Queries by database
Key values
- unknown Main database
- 16,672,794 Requests
- 7d7h52m45s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 16,672,794 Requests
User Request type Count Duration unknown Total 16,672,794 7d7h52m45s copy from 1 2ms cte 10,588 3s33ms ddl 326 47ms delete 10,157 3s146ms insert 1,056,876 7m17s others 2,286,595 2m15s select 9,516,664 7d5h59m55s tcl 3,552,133 3m6s update 239,454 1h40m4s Duration by user
Key values
- 7d7h52m45s (unknown) Main time consuming user
User Request type Count Duration unknown Total 16,672,794 7d7h52m45s copy from 1 2ms cte 10,588 3s33ms ddl 326 47ms delete 10,157 3s146ms insert 1,056,876 7m17s others 2,286,595 2m15s select 9,516,664 7d5h59m55s tcl 3,552,133 3m6s update 239,454 1h40m4s Queries by host
Key values
- unknown Main host
- 16,672,794 Requests
- 7d7h52m45s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 16,672,794 Requests
- 7d7h52m45s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-03-11 07:22:22 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 15,164,692 0-1ms duration
Slowest individual queries
Rank Duration Query 1 11m46s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:34:01.156512', "write_uid" = 988 WHERE id IN (45056985);[ Date: 2025-03-11 14:45:53 ]
2 8m25s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:31:00.356616', "write_uid" = 988 WHERE id IN (45056985);[ Date: 2025-03-11 14:39:30 ]
3 8m25s update shipping_policy set count_search = 3 where id = 5969412;[ Date: 2025-03-11 11:53:30 ]
4 6m11s update shipping_policy set count_search = 3 where id = 5969412;[ Date: 2025-03-11 11:38:59 ]
5 5m58s update shipping_policy set count_search = 3 where id = 5969412;[ Date: 2025-03-11 12:00:22 ]
6 4m30s UPDATE "shipping_policy" SET "client_delivery_button" = false, "collection_amount_receive" = '90', "total_collection_amount" = true, "write_date" = '2025-03-11 09:29:11.297443', "write_uid" = 841 WHERE id IN (6077945);[ Date: 2025-03-11 10:34:07 ]
7 4m21s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 12:21:21.320249', "write_uid" = 988 WHERE id IN (45056985);[ Date: 2025-03-11 13:25:50 ]
8 3m47s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 18:14:02.241098', "write_uid" = 1388 WHERE id IN (45079642);[ Date: 2025-03-11 19:17:53 ]
9 3m47s update shipping_policy set count_search = 3 where id = 5969412;[ Date: 2025-03-11 11:44:51 ]
10 3m19s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:30:21.930339', "write_uid" = 988 WHERE id IN (45056985);[ Date: 2025-03-11 14:33:46 ]
11 2m59s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:25:56.909237', "write_uid" = 988 WHERE id IN (45056985);[ Date: 2025-03-11 14:29:01 ]
12 2m58s update shipping_policy set count_search = 13 where id = 6163860;[ Date: 2025-03-11 12:14:19 ]
13 2m30s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 07:30:15.917580', "write_uid" = 970 WHERE id IN (44935786);[ Date: 2025-03-11 08:32:49 ]
14 2m28s UPDATE "shipping_policy" SET "state_collection" = 'confirm', "write_date" = '2025-03-11 09:31:35.895046', "write_uid" = 1082 WHERE id IN (6079285, 6093942, 6076056, 6015534, 6107290, 6007213, 6092519, 5990273, 5964670, 6113027, 6112917, 6111652, 6109615, 6106266, 6102694, 6099756, 6076382, 6089247, 6039403, 6092492, 5999104, 6033471, 5938100, 6094111, 6073245, 6047803, 6090769, 5976126, 5996725);[ Date: 2025-03-11 10:34:07 ]
15 2m12s UPDATE "shipping_policy" SET "client_date" = '2025-03-11', "client_delivery_button" = true, "edit_cash_button" = false, "receive_man_id" = 'محمود محمد البسيونى', "return_button" = true, "state" = 'client_receive', "write_date" = '2025-03-11 10:00:13.410034', "write_uid" = 947 WHERE id IN (6139173, 6139181, 6139187, 6159572, 6160135, 6141829, 6149285, 5977799, 6102270, 6104031, 6112194, 6119149, 6146133, 6137595, 6138514, 6099289, 6089421, 6143970, 6090476, 6145971, 6160173, 6154541);[ Date: 2025-03-11 11:04:35 ]
16 1m58s UPDATE "shipping_policy" SET "delegate_button" = true, "delegate_id" = 8005215, "driver_id" = 8007003, "last_car" = 657, "state" = 'in_way_to_client', "state_id" = 1907, "write_date" = '2025-03-11 10:34:46.810718', "write_uid" = 991 WHERE id IN (6202535, 6202519, 6202501, 6202473, 6202425, 6202281, 6202263, 6202217, 6202107, 6202059, 6201358, 6201343, 6197679, 6197651, 6197648, 6197642, 6197634, 6197628, 6197624, 6197616, 6197595, 6197593, 6197583, 6197576, 6197559, 6194758);[ Date: 2025-03-11 11:38:47 ]
17 1m38s SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 23)))))) AND ("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" LIMIT 8;[ Date: 2025-03-11 10:53:42 ]
18 1m32s SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 95, 128, 83, 23, 112)))))) AND ("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" LIMIT 8;[ Date: 2025-03-11 11:55:52 ]
19 1m23s update shipping_policy set count_search = 2 where id = 6096433;[ Date: 2025-03-11 10:24:04 ]
20 1m21s update shipping_policy set count_search = 1 where id = 6088657;[ Date: 2025-03-11 13:39:58 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4d30m58s 279,482 641ms 8s63ms 1s243ms 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 #1
Day Hour Count Duration Avg duration Mar 11 00 9,655 2h17m41s 855ms 01 9,259 2h14m25s 871ms 02 8,169 1h56m11s 853ms 03 6,822 1h38m11s 863ms 04 6,880 1h26m1s 750ms 05 9,897 2h2m45s 744ms 06 13,308 2h54m6s 785ms 07 10,678 2h33m3s 860ms 08 9,145 2h9m45s 851ms 09 15,381 3h57m53s 927ms 10 20,640 7h22m51s 1s287ms 11 27,657 13h40m11s 1s779ms 12 26,839 12h26m20s 1s668ms 13 24,131 10h26m16s 1s557ms 14 25,250 11h40m40s 1s664ms 15 22,461 9h29m46s 1s522ms 16 13,967 3h44m16s 963ms 17 5,717 1h19m50s 837ms 18 6,935 1h37m43s 845ms 19 6,691 1h32m56s 833ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207639)) AND (("shipping_track"."id" not in (51809528, 51809528)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:12:11 Duration: 8s63ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207632)) AND (("shipping_track"."id" not in (51808927, 51808927)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:11:08 Duration: 7s979ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207707)) AND (("shipping_track"."id" not in (51815795, 51815795)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:24:57 Duration: 7s879ms
2 18h46m5s 46,277 648ms 9s54ms 1s460ms select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 11 00 446 6m25s 863ms 01 766 11m25s 894ms 02 510 7m27s 877ms 03 284 4m15s 898ms 04 530 7m5s 802ms 05 613 7m39s 750ms 06 696 9m20s 804ms 07 414 6m7s 887ms 08 951 14m10s 894ms 09 3,670 57m42s 943ms 10 5,010 2h28s 1s442ms 11 4,900 3h1m41s 2s224ms 12 6,165 3h23m51s 1s983ms 13 4,698 2h17m8s 1s751ms 14 3,470 1h50m25s 1s909ms 15 3,942 1h46m23s 1s619ms 16 3,913 1h1m52s 948ms 17 1,361 18m21s 809ms 18 1,931 26m36s 826ms 19 2,007 27m36s 825ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6206976, 6206973, 6206970, 6206967, 6206964, 6206955, 4994906)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:19:56 Duration: 9s54ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6194575, 6194558, 6194470, 6174472, 6147338, 6125580)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:11:59 Duration: 8s422ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6174611, 6173881, 6170247, 6170218, 6169381)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:12:41 Duration: 8s398ms
3 16h19m59s 119,282 249ms 2s935ms 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" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 11 00 1,135 6m9s 325ms 01 2,875 15m53s 331ms 02 2,429 13m21s 329ms 03 1,558 8m31s 328ms 04 2,222 10m44s 290ms 05 5,127 25m34s 299ms 06 4,597 24m1s 313ms 07 2,797 14m53s 319ms 08 7,995 44m4s 330ms 09 8,261 49m44s 361ms 10 15,059 2h13m55s 533ms 11 16,250 3h4m9s 679ms 12 12,037 2h8m46s 641ms 13 9,119 1h26m49s 571ms 14 14,769 2h18m48s 563ms 15 7,684 1h5m45s 513ms 16 2,480 13m44s 332ms 17 498 2m39s 320ms 18 1,366 7m10s 314ms 19 1,024 5m13s 306ms -
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" = '1013506')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:12:52 Duration: 2s935ms
-
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" = '1064587')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:06:05 Duration: 2s935ms
-
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" = '1013672')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:02:34 Duration: 2s921ms
4 6h47m15s 19,992 892ms 3s129ms 1s222ms 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 #4
Day Hour Count Duration Avg duration Mar 11 00 1,208 23m33s 1s170ms 01 646 12m12s 1s134ms 02 749 13m36s 1s90ms 03 1,510 27m37s 1s97ms 04 376 6m48s 1s86ms 05 2,380 44m23s 1s119ms 06 3,298 1h3m32s 1s155ms 07 2,118 42m7s 1s193ms 08 727 13m58s 1s153ms 09 506 10m34s 1s252ms 10 191 5m22s 1s686ms 11 248 8m2s 1s945ms 12 239 7m37s 1s915ms 13 695 20m4s 1s733ms 14 514 15m38s 1s824ms 15 401 9m53s 1s480ms 16 1,427 30m8s 1s267ms 17 884 16m37s 1s128ms 18 946 17m53s 1s135ms 19 929 17m32s 1s132ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '238239')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 11:52:41 Duration: 3s129ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9422755')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 14:25:41 Duration: 2s993ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9669175')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:36:36 Duration: 2s968ms
5 5h31m24s 27,961 320ms 4s166ms 711ms 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" = ?)))) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 11 07 167 1m1s 370ms 08 2,355 17m3s 434ms 09 2,547 19m51s 467ms 10 3,454 39m18s 682ms 11 5,199 1h15m55s 876ms 12 3,526 51m44s 880ms 13 3,378 45m8s 801ms 14 3,794 49m38s 784ms 15 1,493 16m33s 665ms 16 962 7m33s 471ms 17 191 1m19s 415ms 18 629 4m20s 414ms 19 266 1m54s 429ms -
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" = '901600')))) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:35:02 Duration: 4s166ms
-
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" = '955361')))) AND ("collection_policy"."office_id" 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, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 13:25:04 Duration: 4s161ms
-
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" = '915416')))) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:34:50 Duration: 4s156ms
6 4h33m20s 154,675 45ms 607ms 106ms 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 #6
Day Hour Count Duration Avg duration Mar 11 00 4,072 5m2s 74ms 01 3,977 4m21s 65ms 02 3,268 3m29s 64ms 03 3,099 3m18s 64ms 04 2,286 2m12s 58ms 05 3,562 3m19s 56ms 06 4,876 4m49s 59ms 07 4,144 4m22s 63ms 08 3,772 4m4s 64ms 09 11,808 13m46s 69ms 10 14,783 29m4s 117ms 11 17,937 45m 150ms 12 17,495 42m16s 144ms 13 15,370 34m5s 133ms 14 12,531 28m30s 136ms 15 9,453 19m46s 125ms 16 8,999 11m36s 77ms 17 3,753 3m59s 63ms 18 4,591 4m58s 64ms 19 4,899 5m16s 64ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6202419, 6197572, 6194822, 6187012, 6186880, 6186859, 6172400, 6148166)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 11:19:23 Duration: 607ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6168395, 6161561, 6134164, 6125782, 6105292, 6103639, 6102948, 6099088)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 12:11:23 Duration: 572ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187825, 6187823, 6187821, 6187819, 6186994, 6186990, 6184839, 6184833)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 14:56:57 Duration: 542ms
7 3h52m18s 52,880 97ms 991ms 263ms select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 11 00 6,210 23m15s 224ms 01 2,390 8m35s 215ms 02 2,182 7m48s 214ms 03 3,098 11m11s 216ms 04 740 2m44s 221ms 05 4,684 17m24s 222ms 06 6,540 25m54s 237ms 07 4,248 17m33s 247ms 08 1,696 6m18s 223ms 09 1,084 4m31s 250ms 10 406 2m43s 403ms 11 564 4m53s 520ms 12 688 5m58s 521ms 13 2,006 13m39s 408ms 14 1,866 13m10s 423ms 15 2,010 11m48s 352ms 16 4,236 20m7s 284ms 17 2,906 12m17s 253ms 18 3,190 13m7s 246ms 19 2,136 9m14s 259ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مصنع اكرمة')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 12:49:55 Duration: 991ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سنر الهدى')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 12:49:38 Duration: 988ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سامح خطر')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 14:55:22 Duration: 979ms
8 2h25m40s 17,714 246ms 2s954ms 493ms 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 #8
Day Hour Count Duration Avg duration Mar 11 00 423 2m20s 332ms 01 739 4m4s 330ms 02 284 1m35s 336ms 03 388 2m12s 342ms 04 2 548ms 274ms 05 819 4m6s 300ms 06 1,094 5m39s 310ms 07 911 4m49s 318ms 08 1,016 5m42s 336ms 09 1,430 8m47s 368ms 10 2,111 17m47s 505ms 11 1,984 22m37s 684ms 12 3,032 36m4s 713ms 13 1,275 11m33s 543ms 14 908 9m15s 611ms 15 486 4m39s 575ms 16 486 2m41s 332ms 17 116 36s362ms 313ms 18 60 19s609ms 326ms 19 150 46s488ms 309ms -
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" = '1064587')) 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: 2025-03-11 11:06:02 Duration: 2s954ms
-
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" = '1009026')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 12:14:47 Duration: 2s875ms
-
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" = '1064731')) 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: 2025-03-11 11:05:28 Duration: 2s854ms
9 2h13m44s 6,806 902ms 2s666ms 1s179ms 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 #9
Day Hour Count Duration Avg duration Mar 11 00 1,922 33m26s 1s43ms 01 565 9m35s 1s18ms 02 364 6m7s 1s8ms 03 53 53s316ms 1s5ms 06 14 17s428ms 1s244ms 07 34 34s289ms 1s8ms 08 134 2m23s 1s73ms 09 47 56s998ms 1s212ms 10 17 28s369ms 1s668ms 11 41 1m17s 1s899ms 12 120 3m56s 1s969ms 13 327 8m 1s469ms 14 441 11m49s 1s608ms 15 618 15m39s 1s520ms 16 719 13m53s 1s159ms 17 581 10m12s 1s54ms 18 662 11m35s 1s49ms 19 147 2m36s 1s66ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '889781')) AND ("policy_number"."package_id" = 2414)) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:14:17 Duration: 2s666ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '815950')) AND ("policy_number"."package_id" = 2414)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 15:23:12 Duration: 2s648ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '76695')) 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 (61))))))) 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 (61)))))) 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 (61)))))) 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 (61))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:14:43 Duration: 2s638ms
10 1h56m35s 55,722 59ms 491ms 125ms select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 11 00 5 399ms 79ms 07 379 27s28ms 71ms 08 1,781 2m16s 76ms 09 5,578 7m38s 82ms 10 5,852 11m10s 114ms 11 9,234 20m57s 136ms 12 10,245 22m9s 129ms 13 6,903 17m3s 148ms 14 7,106 18m35s 156ms 15 3,822 9m19s 146ms 16 2,761 4m18s 93ms 17 347 27s650ms 79ms 18 1,152 1m28s 77ms 19 557 42s895ms 77ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5548090) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 13:00:12 Duration: 491ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6013177) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 12:21:14 Duration: 449ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6027019) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:13:27 Duration: 447ms
11 1h36m31s 21,041 122ms 1s91ms 275ms 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 #11
Day Hour Count Duration Avg duration Mar 11 00 87 13s271ms 152ms 01 117 19s522ms 166ms 02 21 3s437ms 163ms 03 17 2s779ms 163ms 04 84 12s808ms 152ms 05 126 18s482ms 146ms 06 72 11s626ms 161ms 07 21 3s477ms 165ms 08 109 19s383ms 177ms 09 1,321 3m43s 168ms 10 1,869 7m48s 250ms 11 2,852 17m6s 359ms 12 3,108 16m51s 325ms 13 2,757 13m57s 303ms 14 2,155 11m55s 331ms 15 2,714 13m31s 299ms 16 1,802 5m30s 183ms 17 398 57s301ms 143ms 18 738 1m45s 142ms 19 673 1m38s 146ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8311607)) AND (("cash_track"."id" not in (9272359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 12:14:48 Duration: 1s91ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8310725)) AND (("cash_track"."id" not in (9266778)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 11:11:15 Duration: 1s81ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8312346)) AND (("cash_track"."id" not in (9276795)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 12:53:42 Duration: 1s74ms
12 54m49s 15,079 173ms 527ms 218ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 11 00 673 2m38s 235ms 01 1,972 7m5s 215ms 02 2,044 7m24s 217ms 03 1,143 4m5s 214ms 04 2,118 7m26s 210ms 05 3,272 11m43s 215ms 06 3,162 11m43s 222ms 07 433 1m43s 238ms 08 262 57s670ms 220ms -
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" = '1026364')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 01:00:23 Duration: 527ms
-
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 (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 07:01:29 Duration: 428ms
-
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" = '962859')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 04:22:24 Duration: 416ms
13 53m 5,748 269ms 2s922ms 553ms 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 #13
Day Hour Count Duration Avg duration Mar 11 01 25 8s457ms 338ms 05 914 4m33s 298ms 06 340 1m51s 328ms 08 167 56s239ms 336ms 09 490 2m54s 356ms 10 2,556 25m16s 593ms 11 1,158 16m23s 849ms 13 35 16s913ms 483ms 14 63 39s738ms 630ms -
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" = '1044286')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:12:06 Duration: 2s922ms
-
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" = '1005843')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:19:59 Duration: 2s840ms
-
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" = '1072302')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:05:49 Duration: 2s830ms
14 50m7s 26,620 55ms 377ms 112ms select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 11 07 162 11s2ms 67ms 08 996 1m13s 73ms 09 3,104 3m56s 76ms 10 2,600 4m12s 97ms 11 5,199 10m40s 123ms 12 3,454 6m52s 119ms 13 3,024 6m40s 132ms 14 4,576 10m45s 141ms 15 1,156 2m26s 126ms 16 1,287 1m52s 87ms 17 189 13s576ms 71ms 18 603 42s969ms 71ms 19 270 18s873ms 69ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5855989) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:58:25 Duration: 377ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6009008) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:50:15 Duration: 372ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5949380) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:58:49 Duration: 367ms
15 41m28s 5,875 130ms 1s286ms 423ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 11 00 63 9s475ms 150ms 01 40 6s277ms 156ms 02 55 7s858ms 142ms 03 141 20s357ms 144ms 04 35 5s348ms 152ms 05 5 711ms 142ms 07 20 2s931ms 146ms 08 35 5s700ms 162ms 09 518 1m31s 175ms 10 822 5m55s 433ms 11 969 10m59s 680ms 12 1,077 9m56s 553ms 13 819 5m23s 394ms 14 623 3m56s 379ms 15 243 1m40s 412ms 16 116 20s596ms 177ms 17 76 11s499ms 151ms 18 111 17s228ms 155ms 19 107 16s890ms 157ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 11:11:22 Duration: 1s286ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 11:11:14 Duration: 1s268ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 9)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 12:14:17 Duration: 1s267ms
16 38m30s 26,935 0ms 11m46s 85ms update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 11 00 3,110 680ms 0ms 01 1,195 271ms 0ms 02 1,089 231ms 0ms 03 1,550 319ms 0ms 04 371 85ms 0ms 05 2,344 6s868ms 2ms 06 3,269 686ms 0ms 07 2,126 441ms 0ms 08 854 2m30s 176ms 09 585 161ms 0ms 10 274 130ms 0ms 11 348 166ms 0ms 12 412 178ms 0ms 13 1,043 5m27s 313ms 14 967 26m32s 1s646ms 15 1,048 352ms 0ms 16 2,158 655ms 0ms 17 1,470 343ms 0ms 18 1,622 387ms 0ms 19 1,100 3m48s 207ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:34:01.156512', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 14:45:53 Duration: 11m46s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:31:00.356616', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 14:39:30 Duration: 8m25s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 12:21:21.320249', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 13:25:50 Duration: 4m21s
17 37m50s 2,113 30ms 2s261ms 1s74ms select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 11 00 8 3s210ms 401ms 01 6 299ms 49ms 02 5 1s383ms 276ms 03 1 908ms 908ms 04 3 3s40ms 1s13ms 05 2 2s178ms 1s89ms 07 4 2s16ms 504ms 08 35 12s525ms 357ms 09 119 1m14s 625ms 10 222 4m24s 1s192ms 11 224 5m9s 1s380ms 12 351 7m46s 1s330ms 13 312 6m7s 1s177ms 14 238 4m36s 1s162ms 15 277 4m2s 875ms 16 104 1m17s 749ms 17 37 29s101ms 786ms 18 86 1m8s 799ms 19 79 1m6s 847ms -
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 15:04:10 Duration: 2s261ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 12:17:19 Duration: 2s232ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 11:53:19 Duration: 2s220ms
18 36m13s 51 201ms 1m38s 42s610ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 11 00 7 52s454ms 7s493ms 08 2 1s942ms 971ms 09 2 1m41s 50s819ms 10 2 2m53s 1m26s 11 1 1m32s 1m32s 15 13 13m11s 1m 16 6 4m43s 47s248ms 17 10 5m32s 33s270ms 18 2 1m38s 49s208ms 19 6 4m4s 40s668ms -
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 23)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 10:53:42 Duration: 1m38s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 95, 128, 83, 23, 112)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 11:55:52 Duration: 1m32s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 15:18:15 Duration: 1m19s
19 34m33s 72,303 0ms 8m25s 28ms update shipping_policy set count_search = ? where id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 11 00 1,031 337ms 0ms 01 2,406 837ms 0ms 02 1,905 548ms 0ms 03 1,023 288ms 0ms 04 1,754 540ms 0ms 05 3,075 917ms 0ms 06 3,625 1s30ms 0ms 07 1,814 565ms 0ms 08 4,269 1s828ms 0ms 09 4,779 1s981ms 0ms 10 9,647 1m27s 9ms 11 9,473 21m18s 134ms 12 7,427 9m54s 80ms 13 5,146 1m37s 18ms 14 7,827 4s293ms 0ms 15 4,054 1s859ms 0ms 16 1,469 487ms 0ms 17 303 87ms 0ms 18 709 264ms 0ms 19 567 175ms 0ms -
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 11:53:30 Duration: 8m25s
-
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 11:38:59 Duration: 6m11s
-
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 12:00:22 Duration: 5m58s
20 27m44s 3,566 275ms 2s694ms 466ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 11 08 961 5m12s 324ms 09 954 5m34s 350ms 10 796 7m37s 574ms 11 446 5m6s 686ms 12 250 2m49s 678ms 13 138 1m14s 540ms 14 21 10s284ms 489ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '821396')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 11:11:39 Duration: 2s694ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '744462')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 11:12:13 Duration: 2s678ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '331383')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 10:21:51 Duration: 2s612ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,286,342 2m15s 0ms 15ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 11 00 62,298 3s212ms 0ms 01 49,251 2s44ms 0ms 02 50,650 2s230ms 0ms 03 38,625 1s736ms 0ms 04 40,094 1s554ms 0ms 05 41,049 1s923ms 0ms 06 51,680 2s590ms 0ms 07 41,502 1s728ms 0ms 08 69,953 3s396ms 0ms 09 155,935 8s827ms 0ms 10 202,257 12s894ms 0ms 11 223,376 15s813ms 0ms 12 250,474 18s392ms 0ms 13 236,284 14s184ms 0ms 14 207,037 14s748ms 0ms 15 183,296 12s394ms 0ms 16 123,999 6s272ms 0ms 17 74,801 2s966ms 0ms 18 100,526 4s708ms 0ms 19 83,255 4s309ms 0ms -
DISCARD ALL;
Date: 2025-03-11 08:55:11 Duration: 15ms
-
DISCARD ALL;
Date: 2025-03-11 08:55:11 Duration: 15ms
-
DISCARD ALL;
Date: 2025-03-11 11:29:36 Duration: 2ms
2 1,776,098 35s313ms 0ms 26ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 11 00 45,691 807ms 0ms 01 34,943 572ms 0ms 02 36,383 605ms 0ms 03 27,276 474ms 0ms 04 29,873 435ms 0ms 05 29,968 467ms 0ms 06 39,344 636ms 0ms 07 31,137 464ms 0ms 08 54,194 847ms 0ms 09 126,311 2s108ms 0ms 10 164,076 3s465ms 0ms 11 178,558 4s450ms 0ms 12 202,570 4s824ms 0ms 13 188,579 3s926ms 0ms 14 161,544 3s669ms 0ms 15 142,054 2s914ms 0ms 16 95,665 1s607ms 0ms 17 50,959 768ms 0ms 18 74,393 1s201ms 0ms 19 62,580 1s63ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-11 14:02:33 Duration: 26ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-11 11:13:40 Duration: 2ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-11 14:23:59 Duration: 2ms
3 1,161,750 14s84ms 0ms 1ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 11 00 31,899 329ms 0ms 01 25,343 255ms 0ms 02 26,026 258ms 0ms 03 20,013 195ms 0ms 04 20,747 194ms 0ms 05 21,238 211ms 0ms 06 26,602 275ms 0ms 07 21,458 216ms 0ms 08 35,889 359ms 0ms 09 78,909 851ms 0ms 10 102,548 1s336ms 0ms 11 112,768 1s577ms 0ms 12 126,385 1s780ms 0ms 13 119,623 1s619ms 0ms 14 104,796 1s425ms 0ms 15 92,781 1s178ms 0ms 16 62,982 733ms 0ms 17 38,204 354ms 0ms 18 51,204 502ms 0ms 19 42,335 427ms 0ms -
ROLLBACK;
Date: 2025-03-11 06:53:28 Duration: 1ms
-
ROLLBACK;
Date: 2025-03-11 10:35:55 Duration: 1ms
-
ROLLBACK;
Date: 2025-03-11 11:07:47 Duration: 1ms
4 1,154,863 4m15s 0ms 24ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 11 00 31,323 6s790ms 0ms 01 24,770 5s556ms 0ms 02 25,390 5s507ms 0ms 03 19,376 4s127ms 0ms 04 20,072 3s870ms 0ms 05 20,569 3s764ms 0ms 06 25,972 4s912ms 0ms 07 20,844 4s15ms 0ms 08 35,266 6s700ms 0ms 09 78,829 15s482ms 0ms 10 102,645 24s73ms 0ms 11 113,235 28s53ms 0ms 12 127,120 29s727ms 0ms 13 119,659 27s604ms 0ms 14 104,460 24s448ms 0ms 15 92,681 20s169ms 0ms 16 62,421 13s986ms 0ms 17 37,661 7s255ms 0ms 18 50,674 10s269ms 0ms 19 41,896 9s34ms 0ms -
SELECT payload FROM http_sessions WHERE sid = 'a209cf8f911d172d17a1b751052c99f49a9d9704';
Date: 2025-03-11 14:02:33 Duration: 24ms
-
SELECT payload FROM http_sessions WHERE sid = '82b4d5b492e3edf76e45315fb8130fef0e9411c0';
Date: 2025-03-11 14:02:33 Duration: 23ms
-
SELECT payload FROM http_sessions WHERE sid = '0908efdef67fe9d2435d4b023059d35b15a5c28e';
Date: 2025-03-11 11:41:52 Duration: 23ms
5 1,143,171 2m3s 0ms 2ms 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 Mar 11 00 31,165 2s985ms 0ms 01 24,701 2s350ms 0ms 02 25,364 2s336ms 0ms 03 19,360 1s753ms 0ms 04 20,091 1s859ms 0ms 05 20,579 1s958ms 0ms 06 25,875 2s515ms 0ms 07 20,824 1s982ms 0ms 08 34,973 3s289ms 0ms 09 77,937 7s676ms 0ms 10 101,070 11s645ms 0ms 11 111,623 13s400ms 0ms 12 125,175 14s579ms 0ms 13 118,098 14s36ms 0ms 14 103,429 12s274ms 0ms 15 91,625 10s277ms 0ms 16 61,950 6s689ms 0ms 17 37,464 3s325ms 0ms 18 50,252 4s622ms 0ms 19 41,616 3s913ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-11 11:58:21 Duration: 2ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-11 12:29:17 Duration: 2ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-11 13:24:42 Duration: 2ms
6 614,282 2m16s 0ms 73ms 0ms commit;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 11 00 13,790 2s461ms 0ms 01 9,593 2s140ms 0ms 02 10,359 2s71ms 0ms 03 7,266 1s505ms 0ms 04 9,122 1s719ms 0ms 05 8,724 1s879ms 0ms 06 12,742 2s508ms 0ms 07 9,674 1s929ms 0ms 08 18,298 2s885ms 0ms 09 47,402 8s382ms 0ms 10 61,496 14s526ms 0ms 11 65,813 18s266ms 0ms 12 76,176 19s617ms 0ms 13 68,937 16s647ms 0ms 14 56,743 14s155ms 0ms 15 49,292 11s251ms 0ms 16 32,671 6s216ms 0ms 17 12,750 2s109ms 0ms 18 23,190 3s406ms 0ms 19 20,244 3s116ms 0ms -
COMMIT;
Date: 2025-03-11 15:44:50 Duration: 73ms
-
COMMIT;
Date: 2025-03-11 15:24:48 Duration: 64ms
-
COMMIT;
Date: 2025-03-11 13:01:50 Duration: 62ms
7 534,524 1m49s 0ms 12ms 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 #7
Day Hour Count Duration Avg duration Mar 11 00 15,032 2s91ms 0ms 01 8,419 1s280ms 0ms 02 9,339 1s386ms 0ms 03 7,028 946ms 0ms 04 7,481 1s37ms 0ms 05 9,214 1s160ms 0ms 06 13,238 1s831ms 0ms 07 9,225 1s280ms 0ms 08 14,532 2s264ms 0ms 09 42,614 7s255ms 0ms 10 49,970 11s28ms 0ms 11 56,417 15s235ms 0ms 12 66,050 16s804ms 0ms 13 58,084 13s604ms 0ms 14 49,018 11s793ms 0ms 15 43,797 9s575ms 0ms 16 28,960 4s828ms 0ms 17 9,849 1s277ms 0ms 18 19,406 2s568ms 0ms 19 16,851 2s301ms 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 (5099007, 5099422, 5100202, 5099102, 5106336, 5099008, 5099309, 5099006, 5099967, 5099103, 5099119, 5099403, 5545041, 5099594, 5099013, 5176215, 5099009, 5129048, 5102340, 5100952, 5163370, 5099010, 5099719, 5099499, 5151738, 5134113, 5101219, 5099248, 5100753, 5107116, 5099867, 5099386, 5099134, 5099037, 5104917, 5232966, 5105789, 5152660, 5123910, 5114088, 5102601, 5101969, 5099415, 5099224, 5100976, 5099035, 5100927, 5124501, 5118383, 5099254, 5099281, 5101865, 5102665, 5175704, 5108394, 5099138, 5102171, 5099528, 5100619, 5100142, 5099299, 5099603, 5111665, 5099282, 5099678, 5099442, 5101898, 5164695, 5099544, 5100062, 5099170, 5100150, 5099144, 5100074, 5142608, 5099141, 5111526, 5549618, 5549599, 5099095, 5100663, 5232124, 5099392, 5108701, 5150807, 5107364, 5261552, 5100525, 5099896, 5108558, 5100354, 5099140, 5150371, 5120762, 5099890, 5099296, 5099264, 5102415, 5118969, 5099305, 5178097, 5101638, 5099121, 5102831, 5099895, 5104029, 5099131, 5102991, 5105089, 5103701, 5549102, 5112620, 5100301, 5509344, 5107079, 5099130, 5100700, 5114850, 5198009, 5224189, 5099135, 5099921, 5123876, 5099186, 5099764, 5099651, 5099632, 5198536, 5316776, 5100181, 5099693, 5102186, 5113157, 5134456, 5110665, 5260514, 5113941, 5391156, 5161466, 5099523, 5104141, 5548642, 5131259, 5187222, 5106348, 5196405, 5102059, 5111662, 5100015, 5100431, 5100950, 5131969, 5139053, 5099187, 5099585, 5107136, 5099995, 5099745, 5206762, 5103051, 5176162, 5099334, 5104291, 5104907, 5108618, 5174515, 5099045, 5103117, 5099329, 5104075, 5544415, 5403240, 5103816, 5109542, 5100386, 5103931, 5244879, 5109026);
Date: 2025-03-11 16:13:04 Duration: 12ms
-
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 (5099028, 5112098, 5099129, 5101971, 5102366, 5100857, 5099027, 5100421, 5099590, 5099558, 5100636, 5106664, 5099206, 5107208, 5099725, 5100477, 5179470, 5234219, 5121513, 5099158, 5099677, 5099540, 5108273, 5099445, 5121179, 5099413, 5100257, 5100218, 5107076, 5255635, 5107821, 5109564, 5130710, 5102989, 5110304, 5108319, 5219693, 5100832, 5111222, 5154417, 5107656, 5100004, 5100204, 5099192, 5112032, 5109429, 5099401, 5100881, 5149068, 5107990, 5099043, 5099547, 5233840, 5102250, 5100212, 5110833, 5112264, 5295047, 5099788, 5100725, 5099112, 5209971, 5549587, 5105642, 5100935, 5154754, 5100628, 5449621, 5102312, 5099244, 5099430, 5116279, 5099359, 5107260, 5099489, 5100490, 5105765, 5100246, 5100048, 5126696, 5357284, 5487613, 5101592, 5099360, 5101687, 5099646, 5099319, 5104116, 5548720, 5252858, 5548688, 5548686, 5108339, 5212061, 5452239, 5103962, 5106030, 5548450, 5100610, 5103393, 5106039, 5099174, 5104202, 5547683, 5122507, 5111217, 5105790, 5104776, 5542451, 5100564, 5105492, 5099333, 5366902, 5098994, 5099243, 5544632, 5110061, 5544401, 5099114, 5101315, 5165160, 5103238);
Date: 2025-03-11 16:13:04 Duration: 7ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099013, 5100090, 5099009, 5127650, 5131716, 5280485, 5105970, 5155551, 5099028, 5101238, 5099008, 5108142, 5244093, 5179872, 5099254, 5157747, 5099403, 5106208, 5113704, 5099815, 5099035, 5102295, 5121832, 5100302, 5099130, 5099503, 5099295, 5098989, 5504950, 5547687, 5100600, 5099636, 5541281, 5449788, 5102231, 5542583, 5104075, 5102386, 5099102, 5099446, 5099642, 5099045);
Date: 2025-03-11 16:13:03 Duration: 7ms
8 509,845 51s657ms 0ms 29ms 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"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 11 00 10,846 743ms 0ms 01 7,065 476ms 0ms 02 7,325 435ms 0ms 03 5,207 305ms 0ms 04 6,641 379ms 0ms 05 5,863 360ms 0ms 06 9,232 608ms 0ms 07 7,605 482ms 0ms 08 13,706 972ms 0ms 09 40,314 3s262ms 0ms 10 50,535 5s463ms 0ms 11 54,857 7s232ms 0ms 12 63,764 8s83ms 0ms 13 57,920 6s736ms 0ms 14 46,867 5s923ms 0ms 15 43,493 4s684ms 0ms 16 29,285 2s405ms 0ms 17 11,438 714ms 0ms 18 20,354 1s253ms 0ms 19 17,528 1s133ms 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"."is_no_change_office" AS "is_no_change_office", "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 (49);
Date: 2025-03-11 14:43:57 Duration: 29ms
-
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"."is_no_change_office" AS "is_no_change_office", "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 (62, 51, 17, 27, 14, 102, 39, 30, 46, 41, 29, 6, 16, 22, 48, 23, 111, 73, 26, 74, 77, 78, 66, 13);
Date: 2025-03-11 12:44:41 Duration: 2ms
-
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"."is_no_change_office" AS "is_no_change_office", "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, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 57, 23, 59, 97, 101, 108, 118, 120, 129, 20);
Date: 2025-03-11 12:46:49 Duration: 1ms
9 348,634 1m30s 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 #9
Day Hour Count Duration Avg duration Mar 11 00 7,720 1s428ms 0ms 01 5,220 1s51ms 0ms 02 4,881 886ms 0ms 03 3,969 682ms 0ms 04 4,340 810ms 0ms 05 3,890 708ms 0ms 06 5,887 1s136ms 0ms 07 5,415 1s60ms 0ms 08 12,485 2s247ms 0ms 09 29,159 6s120ms 0ms 10 34,780 9s963ms 0ms 11 37,000 11s976ms 0ms 12 43,087 13s530ms 0ms 13 39,580 11s521ms 0ms 14 32,458 9s798ms 0ms 15 28,577 7s806ms 0ms 16 18,284 4s163ms 0ms 17 7,108 1s265ms 0ms 18 13,220 2s349ms 0ms 19 11,574 2s150ms 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 (8007763);
Date: 2025-03-11 04:21:55 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 (8004700, 8006459, 8006534, 8006460, 8006595, 8006457, 8006428, 8006456, 8006455, 3, 8006472, 8006454, 8004805, 8004698, 8006453, 8006462, 8007032, 8007979, 8006958, 8007174, 8006318, 8006376, 8006330, 8006289, 8007030, 8006323, 8007305, 8006481, 8006443, 8006317, 8006461);
Date: 2025-03-11 16:13:06 Duration: 3ms
-
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 (8008347, 8006936, 8004685, 8006808, 8006806, 8006752);
Date: 2025-03-11 16:13:03 Duration: 2ms
10 297,381 2m13s 0ms 3ms 0ms select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 11 00 5,121 1s763ms 0ms 01 4,003 1s452ms 0ms 02 2,934 1s5ms 0ms 03 2,666 891ms 0ms 04 3,962 1s331ms 0ms 05 3,834 1s242ms 0ms 06 4,875 1s722ms 0ms 07 3,793 1s284ms 0ms 08 11,378 3s985ms 0ms 09 21,913 8s627ms 0ms 10 25,740 12s749ms 0ms 11 24,224 13s661ms 0ms 12 29,958 16s131ms 0ms 13 29,246 14s589ms 0ms 14 29,217 15s208ms 0ms 15 31,361 14s986ms 0ms 16 24,763 9s484ms 0ms 17 7,756 2s558ms 0ms 18 16,257 5s365ms 0ms 19 14,380 5s34ms 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 = 970) OR r.global) ORDER BY r.id;
Date: 2025-03-11 04:21:55 Duration: 3ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'mail.message' 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 = 827) OR r.global) ORDER BY r.id;
Date: 2025-03-11 08:54:26 Duration: 3ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.partner' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 861) OR r.global) ORDER BY r.id;
Date: 2025-03-11 17:00:38 Duration: 3ms
11 289,755 38s286ms 0ms 16ms 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"."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 #11
Day Hour Count Duration Avg duration Mar 11 00 6,365 624ms 0ms 01 4,236 488ms 0ms 02 4,081 432ms 0ms 03 2,854 335ms 0ms 04 3,427 375ms 0ms 05 3,263 376ms 0ms 06 5,001 553ms 0ms 07 4,273 479ms 0ms 08 9,182 896ms 0ms 09 23,399 2s391ms 0ms 10 29,157 4s50ms 0ms 11 30,961 5s129ms 0ms 12 36,430 5s663ms 0ms 13 33,215 4s814ms 0ms 14 27,699 4s209ms 0ms 15 24,220 3s354ms 0ms 16 15,528 1s702ms 0ms 17 5,853 568ms 0ms 18 10,990 972ms 0ms 19 9,621 865ms 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"."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 (1089, 1372, 1369, 1225);
Date: 2025-03-11 15:43:39 Duration: 16ms
-
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"."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 (821);
Date: 2025-03-11 13:03:15 Duration: 3ms
-
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"."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 (821);
Date: 2025-03-11 12:19:26 Duration: 3ms
12 279,482 4d30m58s 641ms 8s63ms 1s243ms 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 Mar 11 00 9,655 2h17m41s 855ms 01 9,259 2h14m25s 871ms 02 8,169 1h56m11s 853ms 03 6,822 1h38m11s 863ms 04 6,880 1h26m1s 750ms 05 9,897 2h2m45s 744ms 06 13,308 2h54m6s 785ms 07 10,678 2h33m3s 860ms 08 9,145 2h9m45s 851ms 09 15,381 3h57m53s 927ms 10 20,640 7h22m51s 1s287ms 11 27,657 13h40m11s 1s779ms 12 26,839 12h26m20s 1s668ms 13 24,131 10h26m16s 1s557ms 14 25,250 11h40m40s 1s664ms 15 22,461 9h29m46s 1s522ms 16 13,967 3h44m16s 963ms 17 5,717 1h19m50s 837ms 18 6,935 1h37m43s 845ms 19 6,691 1h32m56s 833ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207639)) AND (("shipping_track"."id" not in (51809528, 51809528)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:12:11 Duration: 8s63ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207632)) AND (("shipping_track"."id" not in (51808927, 51808927)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:11:08 Duration: 7s979ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207707)) AND (("shipping_track"."id" not in (51815795, 51815795)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:24:57 Duration: 7s879ms
13 241,411 1m26s 0ms 58ms 0ms select "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" from "policy_number" where "policy_number".id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 11 00 7,744 1s956ms 0ms 01 3,852 1s134ms 0ms 02 4,023 1s117ms 0ms 03 3,431 975ms 0ms 04 2,896 934ms 0ms 05 4,606 1s201ms 0ms 06 6,628 1s845ms 0ms 07 4,733 1s464ms 0ms 08 6,277 1s894ms 0ms 09 17,324 5s325ms 0ms 10 20,925 8s128ms 0ms 11 23,956 11s526ms 0ms 12 28,608 12s303ms 0ms 13 26,145 10s506ms 0ms 14 21,529 8s918ms 0ms 15 20,586 7s109ms 0ms 16 14,074 4s430ms 0ms 17 5,368 1s336ms 0ms 18 9,724 2s265ms 0ms 19 8,982 1s955ms 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 (44818393, 45000396, 45018652, 45108569, 45144142, 45052230, 45069844, 45069690, 45042842, 44938623, 45068007, 32385220, 45019466, 44951006, 45001091, 44911181, 45001230, 45067095, 45043721, 44979542, 45022764, 44950164, 44950191, 45122100, 44873776, 44826203, 45018245, 45055164, 44819026, 44950522, 44950468, 45083193, 44867217, 45054526, 44992124, 45002508, 44847206, 44992798, 45129080, 44978745, 45063610, 44951178, 44839848, 45056582, 45047540, 45057263, 44876744, 44893780, 44957843, 45025168, 44898703, 44978705, 44969608, 44965571, 44884778, 45005174, 44880729, 45039878, 45039871, 45016175, 45016129, 44935207, 44677988, 45106954, 45107041, 45030166, 45038908, 45104234, 44678039, 44678019, 45018164, 45034870, 45068944, 45095936, 44861797, 45085277, 45072456, 45032724, 44923756, 44964552, 44985651, 44917891, 44917103, 44960777, 44973374, 32408625, 44938543, 44938504, 44925762, 45052925, 45052577, 45066680, 45066528, 45041520, 45041530, 45041764, 45106671, 45017691, 45031921, 45041798, 45041487, 44932708, 44882316, 45042057, 45042033, 44963479, 45038766, 45031006, 45038763, 45041886, 41584727, 42079832, 32475200, 44756395, 44756539, 45053169, 44938368, 45019287, 44921455, 45066143, 44802228, 45070520, 44802153, 44746317, 44746227, 44911178, 44838748, 45078106, 44872530, 45001074, 44872987, 45075451, 45075440, 45075332, 44863944, 44599010, 45034456, 44897710, 45022198, 44839840, 45022341, 45021467, 45022335, 45007786, 44749995, 44980769, 44982960, 44986136, 44916498, 44920347, 44957943, 44850900, 44897096, 44783706, 45064327, 45000398, 44895410, 44951982, 45007420, 44978692, 44977529, 45011966, 45012011, 44670199, 45062766, 45047135, 44974216, 45027165, 44979317, 44986089, 44986439, 44986453, 44898695, 44892657, 45050625, 45006684, 44951967, 45062422, 45063005, 44952995, 45073580, 44979845, 45023457, 45050374, 45006334, 44901568, 44988535, 44986393, 45041100, 45030732, 45040691, 44869837, 44946784, 44948871, 45034986, 45021995, 44590254, 45023309, 45023306, 45029498, 44694180, 44917463, 44921689, 44998987, 44879089, 44864937, 45007877, 44784801, 44785491, 44948203, 45011875, 45011856, 44953631, 45020567, 44934267, 44934113, 45029761, 45029690, 45011177, 44835593, 44749348, 44901521, 44833747, 44914440, 44880955, 44664470, 44754352, 44835155, 44820593, 44831388, 44739002, 44541348, 42009281);
Date: 2025-03-11 16:13:04 Duration: 58ms
-
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 (44490229, 41892591, 39958958, 41470597, 41689412, 32486512, 40740755, 44980228, 32321245, 44980214, 32438877, 32438569, 40320793, 40363079, 40499075, 44915332, 39949928, 40397369, 44780227, 41056144, 41759958, 44683474, 44787583, 40012626, 41572140, 44861986, 45059807, 44754691, 41816753, 41366953, 41650205, 32542608, 44884268, 44984496, 44683475, 44972475, 32425183, 44883107, 44809122, 44857689, 40962205, 44667358, 32440655, 40820508, 32303886, 40455895, 41431091, 41322821, 44742933, 40833969, 40716407, 44769179, 44780562, 44594936, 32180980, 32278986, 44986494, 40541334, 32334132, 41549099, 44984716, 40989894, 32317987, 41154140, 32346016, 32442164, 41358777, 42064805, 40976010, 40616147, 41554201, 32404898, 32620138, 41252947, 44843349, 40470256, 32346033, 41965582, 41323719, 41642558, 32293765, 41739381, 32439727, 44918793, 40907091, 40479025, 44995254, 45090536, 41798819, 44588777, 44747880, 41226875, 32319197, 41793783, 41859678, 40849707, 41843175, 41171908, 44878045, 40897726);
Date: 2025-03-11 16:13:05 Duration: 31ms
-
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 (32331747, 39995651, 40576840, 42089538, 40988019, 41025964, 40460028, 41325953, 39970046, 42025851, 42173797, 42087761, 42089084, 42088881, 42088740, 39324339, 40423385, 42087861, 39324319, 42089085, 41721920, 40423384, 42087860, 41791181, 37855132, 39414557, 39516078, 40385905, 39718707, 39832858, 39667895, 39868153, 39648163, 39847214, 42088210, 41609854, 40043384, 39208982, 39641312, 40301233, 44875424, 41131925, 40357922, 44914862, 44920709, 41741036, 40357924, 44626542, 41792533, 42058499, 41990687, 41956852, 42158760, 44859808, 44985515, 39788717, 45029108, 41956043, 44695480, 41238227, 41365439, 44787602, 44494254, 42088214, 40591295, 41743467, 41743457, 40816621, 41547387, 41743460, 41762138, 41743468, 42088194, 39385934, 42088202, 41238165, 42088480, 40023025, 39760935, 39629887, 32604385, 39594612, 39737150, 39647696, 39806463, 39516281, 39705149, 39589227, 44747787, 39706708, 39764234, 39555175, 41743581, 42088220, 44675534, 39959732, 39752682, 39810747, 41364301, 41713615);
Date: 2025-03-11 16:13:06 Duration: 23ms
14 224,907 51s750ms 0ms 3ms 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 #14
Day Hour Count Duration Avg duration Mar 11 00 4,568 718ms 0ms 01 3,596 572ms 0ms 02 2,966 433ms 0ms 03 2,323 329ms 0ms 04 4,032 623ms 0ms 05 4,360 643ms 0ms 06 4,340 703ms 0ms 07 4,187 657ms 0ms 08 11,809 2s28ms 0ms 09 18,270 3s612ms 0ms 10 19,156 4s911ms 0ms 11 18,533 5s368ms 0ms 12 20,723 5s817ms 0ms 13 20,839 5s410ms 0ms 14 20,637 5s927ms 0ms 15 20,088 5s479ms 0ms 16 16,887 3s744ms 0ms 17 5,384 888ms 0ms 18 12,258 2s103ms 0ms 19 9,951 1s774ms 0ms -
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-03-11 14:47:24 Duration: 3ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-03-11 13:04:17 Duration: 3ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-03-11 10:14:31 Duration: 2ms
15 181,100 33s642ms 0ms 1ms 0ms select "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" from "notebook_package" where "notebook_package".id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 11 00 4,372 387ms 0ms 01 2,526 266ms 0ms 02 2,848 281ms 0ms 03 1,827 168ms 0ms 04 2,428 228ms 0ms 05 2,108 216ms 0ms 06 3,181 366ms 0ms 07 2,427 266ms 0ms 08 4,936 629ms 0ms 09 14,827 2s181ms 0ms 10 17,676 3s735ms 0ms 11 19,893 3s925ms 0ms 12 23,369 5s410ms 0ms 13 20,597 5s555ms 0ms 14 17,332 5s365ms 0ms 15 15,643 2s326ms 0ms 16 9,554 974ms 0ms 17 3,145 255ms 0ms 18 6,598 572ms 0ms 19 5,813 529ms 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 (2414);
Date: 2025-03-11 04:21:55 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 (2414);
Date: 2025-03-11 12:33:45 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2414);
Date: 2025-03-11 11:24:26 Duration: 1ms
16 156,235 1m57s 0ms 22ms 0ms select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" from "shipping_policy" where "shipping_policy".id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 11 00 1,734 1s247ms 0ms 01 698 575ms 0ms 02 866 614ms 0ms 03 343 182ms 0ms 04 326 237ms 0ms 05 384 224ms 0ms 06 812 396ms 0ms 07 1,370 661ms 0ms 08 7,505 3s635ms 0ms 09 9,208 5s734ms 0ms 10 14,330 10s938ms 0ms 11 18,896 15s950ms 0ms 12 21,619 18s656ms 0ms 13 18,910 16s175ms 0ms 14 24,754 19s302ms 0ms 15 20,862 15s17ms 0ms 16 5,426 3s683ms 0ms 17 1,733 889ms 0ms 18 3,403 1s881ms 0ms 19 3,056 1s677ms 0ms -
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (6195840, 6128991, 6128989, 6128559, 6120920, 6120848, 6120748, 6120746, 6117444, 6115424, 6113314, 6113113, 6112157, 6110345, 6105309, 6105163, 6104400, 6102225, 6101943, 6101586, 6101276, 6097314, 6094459, 6093155, 6093087, 6090819, 6090563, 6090516, 6089164, 6087733, 6086780, 6072110, 6071849, 6050163, 6042708, 6039786, 6038210, 6035576, 6035406, 6030021, 6029558, 6014652, 5998109, 5994534, 5992193, 5977174, 5974907, 5963625, 5961122, 5960627, 5920225, 5798877, 5778465);
Date: 2025-03-11 16:13:04 Duration: 22ms
-
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (5729394, 5431691, 5089743, 5232337, 5318483, 6000916, 5340358, 5561613, 5790015, 6111751, 6125805, 5257057, 5805365, 5089804, 5849153, 5223167, 4987752, 3169210, 5557228, 6053689, 4717050, 5099152, 5170910, 4566496, 5254286, 4714846, 5204170, 5634825, 5773391, 5112341, 5247574, 3398853, 3727278, 4602061, 5623666, 5487071, 5913228, 5080417, 6005101, 5441638, 5617853, 5544033, 5903184, 3706057, 5045667, 5283516, 5101800, 4942269, 6030379, 6159205, 4745462, 4986474, 5604677, 5573779, 5711081, 3684333, 4688522, 4956207, 5053817, 5803776, 5451935, 5340046, 5390037, 5690823, 5765782, 5080519, 4936276, 5164421, 5451204, 5360318, 6067753, 4191270, 5944320, 5970014, 4980696, 5802285, 5236027, 5613527, 5603665, 5791563, 5617848, 5230516, 5234422, 5735757, 6077426, 6069261, 6077536, 5045224, 5033229, 6077424, 5540704, 5256711, 5857127, 5613526, 5071115, 5304354, 5045646, 5045648, 5972931, 5721909, 5791951, 5959717, 4989847, 5903592, 5033417, 5140421, 5451326, 5278520, 5863762, 5069942, 4972466, 5962315, 5218010, 5510768, 5198699, 5609948, 5835624, 5853418, 5979680, 5955414, 5486299, 5450839, 4962859, 4923757, 5329754, 4469090, 5216198, 6041088, 5935970, 5564431, 5543321, 5020536, 5205930, 6126935, 6047698, 5837225, 5763780, 5807047, 5905040, 5536061, 5831250, 4844315, 5379007, 5266029, 5808740, 5487093, 5441792, 4937397, 5602966, 5078211, 5558390, 5980020, 5836468, 5290553, 5773336, 4982161, 5656570, 5265483, 5934279, 4907368, 5360334, 5799328, 5128316, 5373622, 6163394, 6040104, 5791409, 5804870, 5195843, 5715243, 5668345, 5743658, 2087165, 6017295, 5443912, 5563699, 5257769, 5552781, 5730299, 5013372, 5227004, 5258959, 5209602, 5301050, 5868946, 5148815, 5324361, 5123359, 4912093, 5380442, 5527791, 5647358, 6067466, 5029137, 5266070, 6008121, 5573752, 4901932, 5029131, 5523198);
Date: 2025-03-11 16:13:40 Duration: 16ms
-
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (5838357, 5829181, 5385260, 5029181, 4997240, 5317192, 5829009, 5581937, 5359540, 5496557, 5496579, 5511561, 5052758, 5748581, 5826621, 5792468, 5058311, 4972953, 5580452, 5018686, 5780948, 5676518, 5609223, 5858902, 5491373, 4893009, 4927559, 5686203, 5223900, 4949203, 5676521, 5165701, 5212882, 5100206, 5437380, 5213047, 4893050, 5213035, 4916631, 4666996, 5435428, 5463623, 5000084, 5212867, 5243773, 5243750, 4722245, 5317240, 5058359, 5567971, 5088003, 5496528, 5088006, 5242392, 5359565, 5676530, 5272836, 5639677, 5327104, 5243747, 5242414, 5491301, 5630170, 5609222, 5437399, 5277828, 4793864, 5698437, 5435425, 5118297, 5568008, 5878269, 5785221, 5609224, 5609231, 5818030, 5712709, 5356048, 5398728, 5548414, 5213029, 5541458, 5091217, 5491296, 5317251, 5243757, 5223895, 5567980, 5397688, 4950419, 5317228, 4949196, 5325681, 5535793, 5243786, 5085799, 4882921, 4972989, 5859371, 5753988, 5398707, 5179706, 5029240, 4858661, 5223080, 5118289, 5326349, 4930532, 4995739, 4916611, 5323380, 4991296, 5535718, 5569694, 5567994, 5858870, 5858890, 5408531, 5637239, 4893052, 5608103, 5435434, 5676499, 5463617, 5433233, 5433255, 5829242, 5491299, 5491421, 5548571, 5788899, 5893297, 5467765, 5437383, 5576948, 5826634, 5491295, 5100203, 4947185, 5829155, 5058408, 5568002, 5572295, 5086987, 4882917, 4881319, 5748358, 5826609, 5609207, 5578864, 5433238, 5748328, 5780972, 5818445, 5223084, 5319194, 5676533, 5496560, 4889729, 5858941, 5285288, 5826644, 5639347, 5935653, 5676469, 5272755, 4793874, 5676464, 5491300, 5785273, 5127930, 4793875, 5785306, 5243744, 5165702, 5359575, 5676449, 5317223, 5567993, 5223180, 5698424, 5858914, 4882947, 5129581, 5327114, 5133411, 5826637, 5676433, 5676503, 5002272, 5150478, 5285358, 5748343, 5748370, 5698446, 5018996, 5491368, 5000089, 5491377);
Date: 2025-03-11 16:13:54 Duration: 13ms
17 154,675 4h33m20s 45ms 607ms 106ms 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 #17
Day Hour Count Duration Avg duration Mar 11 00 4,072 5m2s 74ms 01 3,977 4m21s 65ms 02 3,268 3m29s 64ms 03 3,099 3m18s 64ms 04 2,286 2m12s 58ms 05 3,562 3m19s 56ms 06 4,876 4m49s 59ms 07 4,144 4m22s 63ms 08 3,772 4m4s 64ms 09 11,808 13m46s 69ms 10 14,783 29m4s 117ms 11 17,937 45m 150ms 12 17,495 42m16s 144ms 13 15,370 34m5s 133ms 14 12,531 28m30s 136ms 15 9,453 19m46s 125ms 16 8,999 11m36s 77ms 17 3,753 3m59s 63ms 18 4,591 4m58s 64ms 19 4,899 5m16s 64ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6202419, 6197572, 6194822, 6187012, 6186880, 6186859, 6172400, 6148166)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 11:19:23 Duration: 607ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6168395, 6161561, 6134164, 6125782, 6105292, 6103639, 6102948, 6099088)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 12:11:23 Duration: 572ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187825, 6187823, 6187821, 6187819, 6186994, 6186990, 6184839, 6184833)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 14:56:57 Duration: 542ms
18 130,073 50s473ms 0ms 3ms 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 #18
Day Hour Count Duration Avg duration Mar 11 00 13,669 4s232ms 0ms 01 6,643 2s450ms 0ms 02 6,228 2s266ms 0ms 03 7,309 2s311ms 0ms 04 3,508 1s420ms 0ms 05 11,252 3s553ms 0ms 06 15,701 5s203ms 0ms 07 10,915 3s881ms 0ms 08 4,758 1s745ms 0ms 09 2,767 1s118ms 0ms 10 2,432 1s785ms 0ms 11 2,566 2s60ms 0ms 12 2,671 2s37ms 0ms 13 5,036 2s959ms 0ms 14 4,524 2s800ms 0ms 15 4,447 2s235ms 0ms 16 9,068 3s479ms 0ms 17 5,846 1s726ms 0ms 18 6,428 1s918ms 0ms 19 4,305 1s287ms 0ms -
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 62) AND ("price_list"."to_office_id" = 36)) ORDER BY "price_list"."id";
Date: 2025-03-11 11:52:08 Duration: 3ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 19) AND ("price_list"."to_office_id" = 126)) ORDER BY "price_list"."id";
Date: 2025-03-11 16:00:10 Duration: 2ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 17) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";
Date: 2025-03-11 13:26:09 Duration: 2ms
19 123,396 9s849ms 0ms 1ms 0ms select "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" from "ir_rule" where "ir_rule".id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 11 00 2,180 122ms 0ms 01 1,597 94ms 0ms 02 1,137 60ms 0ms 03 992 53ms 0ms 04 1,739 100ms 0ms 05 1,553 84ms 0ms 06 2,011 119ms 0ms 07 1,647 96ms 0ms 08 5,009 303ms 0ms 09 9,446 647ms 0ms 10 10,659 946ms 0ms 11 9,883 1s10ms 0ms 12 11,751 1s153ms 0ms 13 11,659 1s50ms 0ms 14 11,866 1s141ms 0ms 15 12,947 1s131ms 0ms 16 10,586 759ms 0ms 17 3,288 187ms 0ms 18 7,274 419ms 0ms 19 6,172 365ms 0ms -
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (17);
Date: 2025-03-11 14:38:54 Duration: 1ms
-
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (89);
Date: 2025-03-11 11:18:06 Duration: 1ms
-
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (89);
Date: 2025-03-11 15:17:04 Duration: 1ms
20 120,582 12s979ms 0ms 1ms 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 #20
Day Hour Count Duration Avg duration Mar 11 00 3,179 173ms 0ms 01 2,359 158ms 0ms 02 2,738 143ms 0ms 03 2,088 115ms 0ms 04 2,763 189ms 0ms 05 2,647 164ms 0ms 06 3,647 253ms 0ms 07 2,490 153ms 0ms 08 4,175 305ms 0ms 09 9,943 834ms 0ms 10 10,076 1s210ms 0ms 11 11,168 1s630ms 0ms 12 12,891 1s771ms 0ms 13 11,996 1s461ms 0ms 14 10,677 1s506ms 0ms 15 9,708 1s266ms 0ms 16 7,148 763ms 0ms 17 2,027 159ms 0ms 18 4,645 390ms 0ms 19 4,217 329ms 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: 2025-03-11 14:15:29 Duration: 1ms
-
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 (46, 53, 28, 56, 50, 82, 74, 16);
Date: 2025-03-11 10:16:51 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 (50);
Date: 2025-03-11 09:49:38 Duration: 0ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 201ms 1m38s 42s610ms 51 36m13s 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 11 00 7 52s454ms 7s493ms 08 2 1s942ms 971ms 09 2 1m41s 50s819ms 10 2 2m53s 1m26s 11 1 1m32s 1m32s 15 13 13m11s 1m 16 6 4m43s 47s248ms 17 10 5m32s 33s270ms 18 2 1m38s 49s208ms 19 6 4m4s 40s668ms -
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 23)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 10:53:42 Duration: 1m38s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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, 95, 128, 83, 23, 112)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 11:55:52 Duration: 1m32s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) 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"."office_id" 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)))))) AND ("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" LIMIT 8;
Date: 2025-03-11 15:18:15 Duration: 1m19s
2 648ms 9s54ms 1s460ms 46,277 18h46m5s select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 11 00 446 6m25s 863ms 01 766 11m25s 894ms 02 510 7m27s 877ms 03 284 4m15s 898ms 04 530 7m5s 802ms 05 613 7m39s 750ms 06 696 9m20s 804ms 07 414 6m7s 887ms 08 951 14m10s 894ms 09 3,670 57m42s 943ms 10 5,010 2h28s 1s442ms 11 4,900 3h1m41s 2s224ms 12 6,165 3h23m51s 1s983ms 13 4,698 2h17m8s 1s751ms 14 3,470 1h50m25s 1s909ms 15 3,942 1h46m23s 1s619ms 16 3,913 1h1m52s 948ms 17 1,361 18m21s 809ms 18 1,931 26m36s 826ms 19 2,007 27m36s 825ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6206976, 6206973, 6206970, 6206967, 6206964, 6206955, 4994906)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:19:56 Duration: 9s54ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6194575, 6194558, 6194470, 6174472, 6147338, 6125580)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:11:59 Duration: 8s422ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6174611, 6173881, 6170247, 6170218, 6169381)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:12:41 Duration: 8s398ms
3 641ms 8s63ms 1s243ms 279,482 4d30m58s 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 #3
Day Hour Count Duration Avg duration Mar 11 00 9,655 2h17m41s 855ms 01 9,259 2h14m25s 871ms 02 8,169 1h56m11s 853ms 03 6,822 1h38m11s 863ms 04 6,880 1h26m1s 750ms 05 9,897 2h2m45s 744ms 06 13,308 2h54m6s 785ms 07 10,678 2h33m3s 860ms 08 9,145 2h9m45s 851ms 09 15,381 3h57m53s 927ms 10 20,640 7h22m51s 1s287ms 11 27,657 13h40m11s 1s779ms 12 26,839 12h26m20s 1s668ms 13 24,131 10h26m16s 1s557ms 14 25,250 11h40m40s 1s664ms 15 22,461 9h29m46s 1s522ms 16 13,967 3h44m16s 963ms 17 5,717 1h19m50s 837ms 18 6,935 1h37m43s 845ms 19 6,691 1h32m56s 833ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207639)) AND (("shipping_track"."id" not in (51809528, 51809528)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:12:11 Duration: 8s63ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207632)) AND (("shipping_track"."id" not in (51808927, 51808927)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:11:08 Duration: 7s979ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6207707)) AND (("shipping_track"."id" not in (51815795, 51815795)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-11 11:24:57 Duration: 7s879ms
4 892ms 3s129ms 1s222ms 19,992 6h47m15s 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 #4
Day Hour Count Duration Avg duration Mar 11 00 1,208 23m33s 1s170ms 01 646 12m12s 1s134ms 02 749 13m36s 1s90ms 03 1,510 27m37s 1s97ms 04 376 6m48s 1s86ms 05 2,380 44m23s 1s119ms 06 3,298 1h3m32s 1s155ms 07 2,118 42m7s 1s193ms 08 727 13m58s 1s153ms 09 506 10m34s 1s252ms 10 191 5m22s 1s686ms 11 248 8m2s 1s945ms 12 239 7m37s 1s915ms 13 695 20m4s 1s733ms 14 514 15m38s 1s824ms 15 401 9m53s 1s480ms 16 1,427 30m8s 1s267ms 17 884 16m37s 1s128ms 18 946 17m53s 1s135ms 19 929 17m32s 1s132ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '238239')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 11:52:41 Duration: 3s129ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9422755')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 14:25:41 Duration: 2s993ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9669175')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:36:36 Duration: 2s968ms
5 902ms 2s666ms 1s179ms 6,806 2h13m44s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 11 00 1,922 33m26s 1s43ms 01 565 9m35s 1s18ms 02 364 6m7s 1s8ms 03 53 53s316ms 1s5ms 06 14 17s428ms 1s244ms 07 34 34s289ms 1s8ms 08 134 2m23s 1s73ms 09 47 56s998ms 1s212ms 10 17 28s369ms 1s668ms 11 41 1m17s 1s899ms 12 120 3m56s 1s969ms 13 327 8m 1s469ms 14 441 11m49s 1s608ms 15 618 15m39s 1s520ms 16 719 13m53s 1s159ms 17 581 10m12s 1s54ms 18 662 11m35s 1s49ms 19 147 2m36s 1s66ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '889781')) AND ("policy_number"."package_id" = 2414)) 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 (26))))))) 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 (26)))))) 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 (26)))))) 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 (26))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:14:17 Duration: 2s666ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '815950')) AND ("policy_number"."package_id" = 2414)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 15:23:12 Duration: 2s648ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '76695')) 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 (61))))))) 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 (61)))))) 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 (61)))))) 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 (61))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-11 12:14:43 Duration: 2s638ms
6 30ms 2s261ms 1s74ms 2,113 37m50s select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 11 00 8 3s210ms 401ms 01 6 299ms 49ms 02 5 1s383ms 276ms 03 1 908ms 908ms 04 3 3s40ms 1s13ms 05 2 2s178ms 1s89ms 07 4 2s16ms 504ms 08 35 12s525ms 357ms 09 119 1m14s 625ms 10 222 4m24s 1s192ms 11 224 5m9s 1s380ms 12 351 7m46s 1s330ms 13 312 6m7s 1s177ms 14 238 4m36s 1s162ms 15 277 4m2s 875ms 16 104 1m17s 749ms 17 37 29s101ms 786ms 18 86 1m8s 799ms 19 79 1m6s 847ms -
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 15:04:10 Duration: 2s261ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 12:17:19 Duration: 2s232ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-03-11 11:53:19 Duration: 2s220ms
7 320ms 4s166ms 711ms 27,961 5h31m24s 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" = ?)))) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 11 07 167 1m1s 370ms 08 2,355 17m3s 434ms 09 2,547 19m51s 467ms 10 3,454 39m18s 682ms 11 5,199 1h15m55s 876ms 12 3,526 51m44s 880ms 13 3,378 45m8s 801ms 14 3,794 49m38s 784ms 15 1,493 16m33s 665ms 16 962 7m33s 471ms 17 191 1m19s 415ms 18 629 4m20s 414ms 19 266 1m54s 429ms -
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" = '901600')))) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:35:02 Duration: 4s166ms
-
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" = '955361')))) AND ("collection_policy"."office_id" 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, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 13:25:04 Duration: 4s161ms
-
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" = '915416')))) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:34:50 Duration: 4s156ms
8 269ms 2s922ms 553ms 5,748 53m 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 #8
Day Hour Count Duration Avg duration Mar 11 01 25 8s457ms 338ms 05 914 4m33s 298ms 06 340 1m51s 328ms 08 167 56s239ms 336ms 09 490 2m54s 356ms 10 2,556 25m16s 593ms 11 1,158 16m23s 849ms 13 35 16s913ms 483ms 14 63 39s738ms 630ms -
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" = '1044286')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:12:06 Duration: 2s922ms
-
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" = '1005843')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:19:59 Duration: 2s840ms
-
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" = '1072302')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:05:49 Duration: 2s830ms
9 246ms 2s954ms 493ms 17,714 2h25m40s 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 #9
Day Hour Count Duration Avg duration Mar 11 00 423 2m20s 332ms 01 739 4m4s 330ms 02 284 1m35s 336ms 03 388 2m12s 342ms 04 2 548ms 274ms 05 819 4m6s 300ms 06 1,094 5m39s 310ms 07 911 4m49s 318ms 08 1,016 5m42s 336ms 09 1,430 8m47s 368ms 10 2,111 17m47s 505ms 11 1,984 22m37s 684ms 12 3,032 36m4s 713ms 13 1,275 11m33s 543ms 14 908 9m15s 611ms 15 486 4m39s 575ms 16 486 2m41s 332ms 17 116 36s362ms 313ms 18 60 19s609ms 326ms 19 150 46s488ms 309ms -
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" = '1064587')) 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: 2025-03-11 11:06:02 Duration: 2s954ms
-
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" = '1009026')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 12:14:47 Duration: 2s875ms
-
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" = '1064731')) 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: 2025-03-11 11:05:28 Duration: 2s854ms
10 249ms 2s935ms 492ms 119,282 16h19m59s 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 #10
Day Hour Count Duration Avg duration Mar 11 00 1,135 6m9s 325ms 01 2,875 15m53s 331ms 02 2,429 13m21s 329ms 03 1,558 8m31s 328ms 04 2,222 10m44s 290ms 05 5,127 25m34s 299ms 06 4,597 24m1s 313ms 07 2,797 14m53s 319ms 08 7,995 44m4s 330ms 09 8,261 49m44s 361ms 10 15,059 2h13m55s 533ms 11 16,250 3h4m9s 679ms 12 12,037 2h8m46s 641ms 13 9,119 1h26m49s 571ms 14 14,769 2h18m48s 563ms 15 7,684 1h5m45s 513ms 16 2,480 13m44s 332ms 17 498 2m39s 320ms 18 1,366 7m10s 314ms 19 1,024 5m13s 306ms -
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" = '1013506')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:12:52 Duration: 2s935ms
-
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" = '1064587')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:06:05 Duration: 2s935ms
-
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" = '1013672')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 11:02:34 Duration: 2s921ms
11 275ms 2s694ms 466ms 3,566 27m44s select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 11 08 961 5m12s 324ms 09 954 5m34s 350ms 10 796 7m37s 574ms 11 446 5m6s 686ms 12 250 2m49s 678ms 13 138 1m14s 540ms 14 21 10s284ms 489ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '821396')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 11:11:39 Duration: 2s694ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '744462')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 11:12:13 Duration: 2s678ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '331383')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-11 10:21:51 Duration: 2s612ms
12 130ms 1s286ms 423ms 5,875 41m28s 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 #12
Day Hour Count Duration Avg duration Mar 11 00 63 9s475ms 150ms 01 40 6s277ms 156ms 02 55 7s858ms 142ms 03 141 20s357ms 144ms 04 35 5s348ms 152ms 05 5 711ms 142ms 07 20 2s931ms 146ms 08 35 5s700ms 162ms 09 518 1m31s 175ms 10 822 5m55s 433ms 11 969 10m59s 680ms 12 1,077 9m56s 553ms 13 819 5m23s 394ms 14 623 3m56s 379ms 15 243 1m40s 412ms 16 116 20s596ms 177ms 17 76 11s499ms 151ms 18 111 17s228ms 155ms 19 107 16s890ms 157ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 11:11:22 Duration: 1s286ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 11:11:14 Duration: 1s268ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 9)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-11 12:14:17 Duration: 1s267ms
13 122ms 1s91ms 275ms 21,041 1h36m31s 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 #13
Day Hour Count Duration Avg duration Mar 11 00 87 13s271ms 152ms 01 117 19s522ms 166ms 02 21 3s437ms 163ms 03 17 2s779ms 163ms 04 84 12s808ms 152ms 05 126 18s482ms 146ms 06 72 11s626ms 161ms 07 21 3s477ms 165ms 08 109 19s383ms 177ms 09 1,321 3m43s 168ms 10 1,869 7m48s 250ms 11 2,852 17m6s 359ms 12 3,108 16m51s 325ms 13 2,757 13m57s 303ms 14 2,155 11m55s 331ms 15 2,714 13m31s 299ms 16 1,802 5m30s 183ms 17 398 57s301ms 143ms 18 738 1m45s 142ms 19 673 1m38s 146ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8311607)) AND (("cash_track"."id" not in (9272359)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 12:14:48 Duration: 1s91ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8310725)) AND (("cash_track"."id" not in (9266778)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 11:11:15 Duration: 1s81ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8312346)) AND (("cash_track"."id" not in (9276795)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-11 12:53:42 Duration: 1s74ms
14 97ms 991ms 263ms 52,880 3h52m18s 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 #14
Day Hour Count Duration Avg duration Mar 11 00 6,210 23m15s 224ms 01 2,390 8m35s 215ms 02 2,182 7m48s 214ms 03 3,098 11m11s 216ms 04 740 2m44s 221ms 05 4,684 17m24s 222ms 06 6,540 25m54s 237ms 07 4,248 17m33s 247ms 08 1,696 6m18s 223ms 09 1,084 4m31s 250ms 10 406 2m43s 403ms 11 564 4m53s 520ms 12 688 5m58s 521ms 13 2,006 13m39s 408ms 14 1,866 13m10s 423ms 15 2,010 11m48s 352ms 16 4,236 20m7s 284ms 17 2,906 12m17s 253ms 18 3,190 13m7s 246ms 19 2,136 9m14s 259ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'مصنع اكرمة')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 12:49:55 Duration: 991ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سنر الهدى')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 12:49:38 Duration: 988ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'سامح خطر')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-11 14:55:22 Duration: 979ms
15 173ms 527ms 218ms 15,079 54m49s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 11 00 673 2m38s 235ms 01 1,972 7m5s 215ms 02 2,044 7m24s 217ms 03 1,143 4m5s 214ms 04 2,118 7m26s 210ms 05 3,272 11m43s 215ms 06 3,162 11m43s 222ms 07 433 1m43s 238ms 08 262 57s670ms 220ms -
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" = '1026364')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 01:00:23 Duration: 527ms
-
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 (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 07:01:29 Duration: 428ms
-
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" = '962859')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-11 04:22:24 Duration: 416ms
16 59ms 491ms 125ms 55,722 1h56m35s select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 11 00 5 399ms 79ms 07 379 27s28ms 71ms 08 1,781 2m16s 76ms 09 5,578 7m38s 82ms 10 5,852 11m10s 114ms 11 9,234 20m57s 136ms 12 10,245 22m9s 129ms 13 6,903 17m3s 148ms 14 7,106 18m35s 156ms 15 3,822 9m19s 146ms 16 2,761 4m18s 93ms 17 347 27s650ms 79ms 18 1,152 1m28s 77ms 19 557 42s895ms 77ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 5548090) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 13:00:12 Duration: 491ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6013177) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 12:21:14 Duration: 449ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6027019) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" 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, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-11 10:13:27 Duration: 447ms
17 55ms 377ms 112ms 26,620 50m7s select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 11 07 162 11s2ms 67ms 08 996 1m13s 73ms 09 3,104 3m56s 76ms 10 2,600 4m12s 97ms 11 5,199 10m40s 123ms 12 3,454 6m52s 119ms 13 3,024 6m40s 132ms 14 4,576 10m45s 141ms 15 1,156 2m26s 126ms 16 1,287 1m52s 87ms 17 189 13s576ms 71ms 18 603 42s969ms 71ms 19 270 18s873ms 69ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5855989) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:58:25 Duration: 377ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6009008) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:50:15 Duration: 372ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 5949380) ORDER BY "collection_policy"."id";
Date: 2025-03-11 14:58:49 Duration: 367ms
18 45ms 607ms 106ms 154,675 4h33m20s 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 Mar 11 00 4,072 5m2s 74ms 01 3,977 4m21s 65ms 02 3,268 3m29s 64ms 03 3,099 3m18s 64ms 04 2,286 2m12s 58ms 05 3,562 3m19s 56ms 06 4,876 4m49s 59ms 07 4,144 4m22s 63ms 08 3,772 4m4s 64ms 09 11,808 13m46s 69ms 10 14,783 29m4s 117ms 11 17,937 45m 150ms 12 17,495 42m16s 144ms 13 15,370 34m5s 133ms 14 12,531 28m30s 136ms 15 9,453 19m46s 125ms 16 8,999 11m36s 77ms 17 3,753 3m59s 63ms 18 4,591 4m58s 64ms 19 4,899 5m16s 64ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6202419, 6197572, 6194822, 6187012, 6186880, 6186859, 6172400, 6148166)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 11:19:23 Duration: 607ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6168395, 6161561, 6134164, 6125782, 6105292, 6103639, 6102948, 6099088)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 12:11:23 Duration: 572ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6187825, 6187823, 6187821, 6187819, 6186994, 6186990, 6184839, 6184833)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-11 14:56:57 Duration: 542ms
19 0ms 11m46s 85ms 26,935 38m30s update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 11 00 3,110 680ms 0ms 01 1,195 271ms 0ms 02 1,089 231ms 0ms 03 1,550 319ms 0ms 04 371 85ms 0ms 05 2,344 6s868ms 2ms 06 3,269 686ms 0ms 07 2,126 441ms 0ms 08 854 2m30s 176ms 09 585 161ms 0ms 10 274 130ms 0ms 11 348 166ms 0ms 12 412 178ms 0ms 13 1,043 5m27s 313ms 14 967 26m32s 1s646ms 15 1,048 352ms 0ms 16 2,158 655ms 0ms 17 1,470 343ms 0ms 18 1,622 387ms 0ms 19 1,100 3m48s 207ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:34:01.156512', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 14:45:53 Duration: 11m46s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 13:31:00.356616', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 14:39:30 Duration: 8m25s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 12:21:21.320249', "write_uid" = 988 WHERE id IN (45056985);
Date: 2025-03-11 13:25:50 Duration: 4m21s
20 0ms 8m25s 28ms 72,303 34m33s update shipping_policy set count_search = ? where id = ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 11 00 1,031 337ms 0ms 01 2,406 837ms 0ms 02 1,905 548ms 0ms 03 1,023 288ms 0ms 04 1,754 540ms 0ms 05 3,075 917ms 0ms 06 3,625 1s30ms 0ms 07 1,814 565ms 0ms 08 4,269 1s828ms 0ms 09 4,779 1s981ms 0ms 10 9,647 1m27s 9ms 11 9,473 21m18s 134ms 12 7,427 9m54s 80ms 13 5,146 1m37s 18ms 14 7,827 4s293ms 0ms 15 4,054 1s859ms 0ms 16 1,469 487ms 0ms 17 303 87ms 0ms 18 709 264ms 0ms 19 567 175ms 0ms -
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 11:53:30 Duration: 8m25s
-
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 11:38:59 Duration: 6m11s
-
update shipping_policy set count_search = 3 where id = 5969412;
Date: 2025-03-11 12:00:22 Duration: 5m58s
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
-
Events
Log levels
Key values
- 16,677,909 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 3012 FATAL entries
- 519 ERROR entries
- 0 WARNING entries
- 19 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,421 Max number of times the same event was reported
- 3,550 Total events found
Rank Times reported Error 1 1,421 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 11 01 90 04 48 07 95 10 288 13 554 16 224 17 122 2 1,379 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 11 01 170 04 259 07 159 10 173 13 194 16 283 17 141 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Context: while updating tuple (213355,114) in relation "policy_number"
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 00:00:00.706496', "write_uid" = 975 WHERE id IN (45074437)Date: 2025-03-11 01:00:06
Context: while updating tuple (213355,114) in relation "policy_number"
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-10 23:59:28.648080', "write_uid" = 975 WHERE id IN (45074437)Date: 2025-03-11 01:00:06
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-03-11 04:20:01
3 444 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 11 00 1 01 5 02 1 03 1 05 7 06 8 07 4 08 6 09 8 10 30 11 99 12 63 13 54 14 73 15 64 16 14 17 1 18 2 19 3 - 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
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-10 23:13:46.419040', "write_uid" = 1227 WHERE id IN (45052365)
Date: 2025-03-11 00:15:06
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 00:08:20.362997', "write_uid" = 975 WHERE id IN (45074437)
Date: 2025-03-11 01:09:05
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-11 00:03:19.879692', "write_uid" = 975 WHERE id IN (45074437)
Date: 2025-03-11 01:09:05
4 173 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 11 01 16 04 20 07 12 10 44 13 49 16 32 - 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
Statement: 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" = '788048')) ORDER BY "shipping_policy"."id" DESC
Date: 2025-03-11 01:00:06
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6179448)) AND (("shipping_track"."id" not in (51630301, 51631019, 51693208, 51693208)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-03-11 01:00:06
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6194091)) AND (("shipping_track"."id" not in (51693207, 51693207)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-03-11 01:00:06
5 42 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 11 01 4 04 3 07 3 10 11 13 13 16 8 - 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
Context: parallel worker
Statement: 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" = '788048')) ORDER BY "shipping_policy"."id" DESCDate: 2025-03-11 01:00:06
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6179448)) AND (("shipping_track"."id" not in (51630301, 51631019, 51693208, 51693208)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-03-11 01:00:06
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6194090)) AND (("shipping_track"."id" not in (51693206, 51693206)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-03-11 01:00:06
6 19 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 11 07 3 17 16 - FATAL: password authentication failed for user "postgres"
Detail: User "postgres" has no password assigned. Connection matched file "/var/lib/pgsql/16/data/pg_hba.conf" line 123: "host all all all scram-sha-256"
Date: 2025-03-11 07:53:20
7 15 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 11 10 3 11 6 12 2 13 3 14 1 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 830862 waits for ShareLock on transaction 10733011; blocked by process 831043. Process 831043 waits for ShareLock on transaction 10732735; blocked by process 830862. Process 830862: update shipping_policy set count_search=3 where id=6096406 Process 831043: update shipping_policy set count_search=2 where id=6096433
Context: while updating tuple (80884,3) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=3 where id=6096406Date: 2025-03-11 10:24:04
Detail: Process 830847 waits for ShareLock on transaction 10734421; blocked by process 852119. Process 852119 waits for ShareLock on transaction 10734396; blocked by process 830847. Process 830847: update shipping_policy set count_search=9 where id=6145142 Process 852119: UPDATE "shipping_policy" SET "client_delivery_button" = false, "edit_cash_button" = true, "new_destination_button" = true, "out_date" = '2025-03-11', "return_button" = false, "state" = 'in_way_to_client', "write_date" = '2025-03-11 09:34:43.665890', "write_uid" = 991 WHERE id IN (6162643, 6145142)
Context: while updating tuple (83502,27) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=9 where id=6145142Date: 2025-03-11 10:35:52
Detail: Process 847194 waits for ShareLock on transaction 10736487; blocked by process 830865. Process 830865 waits for ShareLock on transaction 10736463; blocked by process 847194. Process 847194: update shipping_policy set count_search=8 where id=5906000 Process 830865: UPDATE "shipping_policy" SET "state_collection" = 'confirm', "write_date" = '2025-03-11 09:54:17.687502', "write_uid" = 1102 WHERE id IN (6157731, 6124669, 6118277, 6100571, 6159011, 6159001, 6150531, 6120471, 6082263, 6158340, 6149594, 6132702, 6132535, 6119497, 6092812, 5906000, 6149532, 6165606, 6165604, 6159612, 6153553, 6150680, 6150572, 6150565, 6146972, 6143640, 6141678, 6141572, 6136633, 6134192, 6100293, 6093367, 6090868, 6090434, 6070094, 6043825, 6001512, 6148984, 6141006, 6141003, 6140140, 6135611, 6129722, 6153470, 6140880, 6140048, 6138862, 6132185, 6119184, 5996323)
Context: while updating tuple (27037,22) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=8 where id=5906000Date: 2025-03-11 10:54:29
8 9 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 11 01 1 04 2 07 1 10 1 13 1 16 2 17 1 9 8 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 11 16 8 10 8 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 11 16 8 11 7 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 11 03 1 09 1 10 1 11 1 12 2 16 1 - ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM "delegate_track" WHERE id IN (196916)
Date: 2025-03-11 03:27:58
Statement: DELETE FROM "delegate_track" WHERE id IN (196905)
Date: 2025-03-11 09:14:36
Statement: DELETE FROM "delegate_track" WHERE id IN (196513)
Date: 2025-03-11 10:02:32
12 7 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 11 01 3 02 1 07 1 11 2 - ERROR: syntax error at or near ")" at character 162
- ERROR: syntax error at or near ")" at character 162
- ERROR: syntax error at or near ")" at character 163
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('938954',)
Date: 2025-03-11 01:17:33
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('784661',)
Date: 2025-03-11 02:47:19
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('1006675',)
Date: 2025-03-11 07:26:00
13 5 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 11 04 1 10 2 13 2 14 3 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 11 12 2 14 1 - ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "code" of relation "res_country_state" violates not-null constraint
Detail: Failing row contains (5553406, null, 822, 822, null, 01226532072, null, null, t, 2025-03-11 11:02:51.454682, 2025-03-11 11:02:51.454682, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-03-11 11:02:51.454682', 822, '01226532072', '2025-03-11 11:02:51.454682', 822) RETURNING "id"Date: 2025-03-11 12:02:51
Detail: Failing row contains (5553420, null, 822, 822, null, 01014000673, null, null, t, 2025-03-11 11:43:14.088865, 2025-03-11 11:43:14.088865, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-03-11 11:43:14.088865', 822, '01014000673', '2025-03-11 11:43:14.088865', 822) RETURNING "id"Date: 2025-03-11 12:43:14
Detail: Failing row contains (4544, 65, 866, 866, مدينة نصر, null, 2025-03-11 13:08:12.499252, 2025-03-11 13:08:12.499252).
Statement: INSERT INTO "res_country_state" ("country_id", "create_date", "create_uid", "name", "write_date", "write_uid") VALUES (65, '2025-03-11 13:08:12.499252', 866, 'مدينة نصر', '2025-03-11 13:08:12.499252', 866) RETURNING "id"Date: 2025-03-11 14:08:12
15 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #15
Day Hour Count Mar 11 02 1 13 1 16 2 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 11 16 2 17 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 11 02 1 13 1 18 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #18
Day Hour Count Mar 11 02 1 13 1 19 1 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #19
Day Hour Count Mar 11 16 1 20 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #20
Day Hour Count Mar 11 13 1 - ERROR: column urgent_office.is_no_change_office does not exist at character 574
Statement: 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"."is_no_change_office" AS "is_no_change_office", "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)
Date: 2025-03-11 13:33:54