pgBadger-
Global information
- Generated on Sun Jan 26 23:47:18 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 40,283,780 log entries in 2m17s
- Log start from 2025-01-26 00:00:00 to 2025-01-26 22:45:01
-
Overview
Global Stats
- 19,709 Number of unique normalized queries
- 17,255,473 Number of queries
- 5d18h28m7s Total query duration
- 2025-01-26 00:00:00 First query
- 2025-01-26 22:45:01 Last query
- 6,426 queries/s at 2025-01-26 12:58:13 Query peak
- 5d18h28m7s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 5d18h28m7s Execute total duration
- 4,177 Number of events
- 23 Number of unique normalized events
- 1,658 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
- 17,255,473 Average queries per session
- 5d18h28m7s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 6,426 queries/s Query Peak
- 2025-01-26 12:58:13 Date
SELECT Traffic
Key values
- 4,743 queries/s Query Peak
- 2025-01-26 12:58:13 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,214 queries/s Query Peak
- 2025-01-26 15:29:12 Date
Queries duration
Key values
- 5d18h28m7s 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) Jan 26 00 259,310 0ms 982ms 23ms 3m10s 3m28s 4m28s 01 310,822 0ms 3s231ms 27ms 4m25s 4m41s 6m23s 02 235,045 0ms 3s863ms 25ms 3m12s 4m 5m8s 03 296,739 0ms 4s195ms 31ms 5m5s 5m22s 5m42s 04 189,437 0ms 3s929ms 26ms 2m37s 2m52s 4m50s 05 105,766 0ms 983ms 23ms 1m49s 2m16s 2m45s 06 179,144 0ms 4s599ms 20ms 2m9s 2m24s 2m41s 07 155,766 0ms 4s504ms 19ms 1m43s 1m53s 2m36s 08 353,483 0ms 4s580ms 11ms 2m29s 3m11s 4m40s 09 1,041,397 0ms 13h54m9s 61ms 6m20s 7m59s 13h58m44s 10 1,501,426 0ms 12s58ms 15ms 9m23s 9m59s 10m21s 11 1,653,733 0ms 46m9s 30ms 8m54s 1h6m35s 6h27m56s 12 1,664,311 0ms 15m32s 23ms 9m9s 10m13s 3h26m48s 13 1,406,215 0ms 15m46s 24ms 6m11s 7m28s 4h22m25s 14 1,308,069 0ms 28m53s 28ms 5m39s 5m56s 7h7m40s 15 1,237,708 0ms 16s49ms 12ms 6m30s 7m21s 8m14s 16 1,219,921 0ms 22m49s 30ms 7m20s 7m44s 4h2m16s 17 1,100,896 0ms 10m 20ms 5m52s 7m47s 2h23m2s 18 932,953 0ms 12m32s 34ms 15m33s 19m9s 2h57m3s 19 702,254 0ms 59m59s 31ms 8m33s 9m20s 1h7m31s 20 696,208 0ms 10m20s 30ms 9m48s 12m37s 16m7s 21 448,898 0ms 27m10s 78ms 6m33s 10m16s 5h28m49s 22 255,972 0ms 19m56s 61ms 6m26s 7m39s 2h39m11s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 26 00 136,217 0 44ms 2m33s 3m10s 3m37s 01 165,491 0 51ms 3m22s 4m25s 5m17s 02 120,437 0 50ms 2m40s 3m12s 5m5s 03 152,681 0 60ms 4m11s 5m4s 5m39s 04 93,385 0 52ms 2m9s 2m37s 3m10s 05 52,068 0 48ms 1m11s 1m48s 2m41s 06 99,139 0 36ms 1m48s 2m9s 2m24s 07 82,243 0 36ms 1m17s 1m43s 2m28s 08 205,481 0 19ms 2m3s 2m29s 3m21s 09 602,675 0 106ms 5m34s 6m20s 8m52s 10 853,971 0 27ms 8m17s 9m21s 10m1s 11 1,005,671 0 19ms 6m58s 7m43s 9m5s 12 1,018,309 0 19ms 7m28s 8m41s 9m22s 13 851,800 0 15ms 5m33s 6m7s 7m17s 14 757,698 0 16ms 4m55s 5m18s 5m55s 15 711,472 0 21ms 5m42s 6m29s 7m41s 16 714,323 0 23ms 6m3s 7m5s 7m34s 17 661,634 0 20ms 5m7s 5m49s 7m45s 18 552,575 0 39ms 8m59s 12m50s 19m5s 19 401,012 0 45ms 7m29s 8m28s 9m19s 20 406,273 0 48ms 6m51s 9m9s 12m1s 21 261,878 0 58ms 5m11s 6m1s 10m15s 22 151,259 0 41ms 3m38s 5m32s 7m54s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 26 00 21,730 5,001 143 0 0ms 139ms 174ms 223ms 01 30,636 6,984 145 0 0ms 184ms 229ms 327ms 02 20,660 5,438 138 0 0ms 150ms 171ms 257ms 03 32,118 7,760 159 0 0ms 196ms 291ms 348ms 04 13,581 4,511 133 0 0ms 119ms 174ms 237ms 05 6,911 1,876 199 0 0ms 64ms 88ms 131ms 06 12,401 3,717 136 0 0ms 90ms 125ms 192ms 07 9,787 2,761 134 0 0ms 73ms 109ms 143ms 08 11,503 4,863 248 0 0ms 96ms 117ms 169ms 09 53,573 16,919 744 0 0ms 299ms 356ms 475ms 10 81,848 24,735 924 0 0ms 506ms 580ms 956ms 11 72,497 21,366 893 0 327ms 440ms 563ms 1h4m16s 12 73,726 21,879 937 2 191ms 476ms 552ms 643ms 13 53,223 18,354 599 3 286ms 306ms 385ms 572ms 14 49,217 18,228 709 0 372ms 279ms 362ms 430ms 15 58,255 19,667 1,194 0 0ms 296ms 402ms 563ms 16 59,323 19,763 770 0 261ms 341ms 420ms 2m52s 17 69,201 19,315 545 0 97ms 460ms 576ms 1s697ms 18 69,803 26,875 634 0 110ms 564ms 767ms 58s862ms 19 63,826 15,034 472 0 47ms 388ms 512ms 40s251ms 20 67,346 23,133 260 0 13ms 436ms 576ms 2m56s 21 48,779 11,997 223 0 323ms 286ms 361ms 597ms 22 24,164 5,104 158 0 319ms 193ms 239ms 663ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 26 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% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jan 26 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 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s Day Hour Count Average Duration Average idle time Jan 26 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 20 0 0ms 0ms 21 0 0ms 0ms 22 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
- 136,306 buffers Checkpoint Peak
- 2025-01-26 01:56:23 Date
- 270.059 seconds Highest write time
- 1.086 seconds Sync time
Checkpoints Wal files
Key values
- 72 files Wal files usage Peak
- 2025-01-26 01:56:23 Date
Checkpoints distance
Key values
- 2,302.98 Mo Distance Peak
- 2025-01-26 01:56:23 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 26 00 117,633 3,238.884s 0.035s 3,238.96s 01 285,831 3,239.52s 0.046s 3,239.631s 02 102,473 3,239.556s 0.031s 3,239.625s 03 125,850 3,239.636s 0.029s 3,239.704s 04 108,308 3,239.579s 0.027s 3,239.655s 05 80,820 2,746.304s 0.025s 2,746.371s 06 72,488 2,937.551s 0.028s 2,937.622s 07 66,769 3,097.47s 0.028s 3,097.532s 08 75,418 2,848.412s 0.031s 2,848.474s 09 400,467 3,239.634s 0.041s 3,239.738s 10 506,705 3,239.421s 0.058s 3,239.567s 11 523,146 3,239.551s 0.066s 3,239.706s 12 524,727 3,239.443s 0.058s 3,239.582s 13 411,635 3,239.572s 0.047s 3,239.693s 14 415,570 3,239.556s 0.049s 3,239.676s 15 408,649 3,239.473s 0.049s 3,239.587s 16 354,728 3,239.534s 0.047s 3,239.654s 17 299,420 2,887.574s 0.079s 2,887.714s 18 321,039 3,239.395s 1.137s 3,240.614s 19 336,264 3,239.552s 0.044s 3,239.661s 20 213,408 3,239.519s 0.046s 3,239.62s 21 283,400 3,239.593s 0.039s 3,239.692s 22 106,819 2,429.696s 0.028s 2,429.755s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 26 00 0 0 53 3,886 0.002s 0.012s 01 0 0 140 4,068 0.008s 0.012s 02 0 0 41 2,846 0.002s 0.012s 03 0 0 53 3,012 0.002s 0.012s 04 0 0 46 2,816 0.002s 0.012s 05 0 0 34 2,529 0.002s 0.012s 06 0 0 29 2,273 0.002s 0.012s 07 0 0 30 2,560 0.002s 0.012s 08 0 0 28 3,181 0.002s 0.012s 09 0 0 156 5,102 0.002s 0.012s 10 0 0 200 5,322 0.003s 0.012s 11 0 0 207 5,323 0.003s 0.012s 12 0 0 213 5,424 0.004s 0.012s 13 0 0 165 5,354 0.003s 0.012s 14 0 0 168 5,514 0.002s 0.012s 15 0 0 166 5,531 0.002s 0.012s 16 0 0 146 5,607 0.003s 0.012s 17 0 0 123 5,570 0.010s 0.012s 18 0 0 145 5,371 0.598s 0.014s 19 0 0 148 5,180 0.002s 0.012s 20 0 0 94 4,945 0.002s 0.012s 21 0 0 125 4,651 0.002s 0.012s 22 0 0 47 2,915 0.002s 0.009s Day Hour Count Avg time (sec) Jan 26 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 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jan 26 00 72,535.83 kB 100,383.92 kB 01 191,515.33 kB 211,037.25 kB 02 55,630.75 kB 659,951.67 kB 03 72,419.92 kB 233,262.83 kB 04 62,955.83 kB 117,521.58 kB 05 48,974.36 kB 165,471.82 kB 06 39,975.75 kB 80,337.33 kB 07 40,103.00 kB 65,348.75 kB 08 38,714.25 kB 51,035.75 kB 09 212,421.00 kB 341,060.67 kB 10 273,223.33 kB 365,399.92 kB 11 286,314.64 kB 344,461.91 kB 12 289,657.75 kB 335,584.50 kB 13 219,335.18 kB 285,258.18 kB 14 229,324.25 kB 276,587.83 kB 15 237,134.27 kB 303,693.18 kB 16 198,751.50 kB 241,892.42 kB 17 168,467.25 kB 203,992.75 kB 18 197,680.00 kB 271,053.42 kB 19 202,429.33 kB 304,618.33 kB 20 127,298.42 kB 250,301.33 kB 21 170,763.08 kB 223,022.75 kB 22 85,650.89 kB 207,414.56 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 Jan 26 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 -
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 Jan 26 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 - 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
- 10,057,692 Total read queries
- 4,918,671 Total write queries
Queries by database
Key values
- unknown Main database
- 17,255,473 Requests
- 5d18h28m7s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 17,255,473 Requests
User Request type Count Duration unknown Total 17,255,473 5d18h28m7s copy from 5 4ms cte 17,999 3s984ms ddl 1,011 143ms delete 10,497 1s417ms insert 1,004,108 5m18s others 2,279,109 1m55s select 10,057,692 3d19h6m49s tcl 3,579,771 2m24s update 305,280 1d23h11m35s Duration by user
Key values
- 5d18h28m7s (unknown) Main time consuming user
User Request type Count Duration unknown Total 17,255,473 5d18h28m7s copy from 5 4ms cte 17,999 3s984ms ddl 1,011 143ms delete 10,497 1s417ms insert 1,004,108 5m18s others 2,279,109 1m55s select 10,057,692 3d19h6m49s tcl 3,579,771 2m24s update 305,280 1d23h11m35s Queries by host
Key values
- unknown Main host
- 17,255,473 Requests
- 5d18h28m7s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 17,255,473 Requests
- 5d18h28m7s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-01-26 05:59:41 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 16,032,731 0-1ms duration
Slowest individual queries
Rank Duration Query 1 13h54m9s SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__from_office" ON ("shipping_policy"."from_office" = "shipping_policy__from_office"."id") WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name"::text not ilike '%9842912%') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)) 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"."collection_amount_sender" ASC, "shipping_policy__from_office"."new_code" ASC, "shipping_policy"."total_shipping_price" ASC, "shipping_policy"."total_amount_cash_lines" ASC LIMIT 100;[ Date: 2025-01-26 09:23:07 ]
2 59m59s update res_users set sid = '0ff61103934c706f8a00df0ae45720f159a47e16', last_update = '2025-01-26 17:33:03.971255', exp_date = '2025-01-26 18:18:03.971261', logged_in = 'TRUE' where id = 1037;[ Date: 2025-01-26 19:33:03 ]
3 46m9s update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350440', exp_date = '2025-01-26 10:02:11.350443', logged_in = 'TRUE' where id = 843;[ Date: 2025-01-26 11:03:20 ]
4 46m9s update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350385', exp_date = '2025-01-26 10:02:11.350388', logged_in = 'TRUE' where id = 843;[ Date: 2025-01-26 11:03:20 ]
5 45m4s update res_users set sid = '877fe23db067d2d4501a28d0693805326f2ad07c', last_update = '2025-01-26 09:18:15.894020', exp_date = '2025-01-26 10:03:15.894025', logged_in = 'TRUE' where id = 843;[ Date: 2025-01-26 11:03:20 ]
6 39m27s update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:23:53.465569', exp_date = '2025-01-26 10:08:53.465572', logged_in = 'TRUE' where id = 843;[ Date: 2025-01-26 11:03:20 ]
7 39m5s update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:24:14.938386', exp_date = '2025-01-26 10:09:14.938390', logged_in = 'TRUE' where id = 843;[ Date: 2025-01-26 11:03:20 ]
8 28m53s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:20:27.819115', exp_date = '2025-01-26 14:05:27.819118', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
9 28m53s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:20:27.818967', exp_date = '2025-01-26 14:05:27.818970', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
10 27m10s update res_users set sid = '407eaccb5b54b14e4dd4991fcd8d5e55f653ceb0', last_update = '2025-01-26 20:20:10.188066', exp_date = '2025-01-26 21:05:10.188070', logged_in = 'TRUE' where id = 823;[ Date: 2025-01-26 21:47:21 ]
11 27m10s update res_users set sid = '407eaccb5b54b14e4dd4991fcd8d5e55f653ceb0', last_update = '2025-01-26 20:20:10.187993', exp_date = '2025-01-26 21:05:10.187996', logged_in = 'TRUE' where id = 823;[ Date: 2025-01-26 21:47:21 ]
12 24m21s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:24:59.728191', exp_date = '2025-01-26 14:09:59.728194', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
13 24m16s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:25:03.997774', exp_date = '2025-01-26 14:10:03.997779', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
14 24m9s update res_users set sid = 'c899fab5691aaa780d2406c42125f5fadeb0aa1a', last_update = '2025-01-26 09:39:11.282836', exp_date = '2025-01-26 10:24:11.282840', logged_in = 'TRUE' where id = 985;[ Date: 2025-01-26 11:03:20 ]
15 24m9s update res_users set sid = 'c899fab5691aaa780d2406c42125f5fadeb0aa1a', last_update = '2025-01-26 09:39:11.282119', exp_date = '2025-01-26 10:24:11.282123', logged_in = 'TRUE' where id = 985;[ Date: 2025-01-26 11:03:20 ]
16 23m59s update res_users set sid = '407eaccb5b54b14e4dd4991fcd8d5e55f653ceb0', last_update = '2025-01-26 20:23:21.540066', exp_date = '2025-01-26 21:08:21.540071', logged_in = 'TRUE' where id = 823;[ Date: 2025-01-26 21:47:21 ]
17 23m58s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:25:22.355560', exp_date = '2025-01-26 14:10:22.355563', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
18 23m39s update res_users set sid = '407eaccb5b54b14e4dd4991fcd8d5e55f653ceb0', last_update = '2025-01-26 20:23:41.666370', exp_date = '2025-01-26 21:08:41.666375', logged_in = 'TRUE' where id = 823;[ Date: 2025-01-26 21:47:21 ]
19 23m28s update res_users set sid = '56c5644937b6f31e4eb9f349a63010971a190030', last_update = '2025-01-26 13:25:52.459135', exp_date = '2025-01-26 14:10:52.459140', logged_in = 'TRUE' where id = 862;[ Date: 2025-01-26 14:49:20 ]
20 23m26s update res_users set sid = 'c899fab5691aaa780d2406c42125f5fadeb0aa1a', last_update = '2025-01-26 09:39:54.383959', exp_date = '2025-01-26 10:24:54.383965', logged_in = 'TRUE' where id = 985;[ Date: 2025-01-26 11:03:20 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1d20h39m51s 62,038 0ms 59m59s 2s591ms update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 26 00 893 219ms 0ms 01 950 241ms 0ms 02 723 179ms 0ms 03 1,175 309ms 0ms 04 784 217ms 0ms 05 244 57ms 0ms 06 473 107ms 0ms 07 411 96ms 0ms 08 1,256 1s490ms 1ms 09 4,223 981ms 0ms 10 6,597 1s688ms 0ms 11 6,574 8h36m25s 4s713ms 12 6,301 3h21m59s 1s923ms 13 5,446 5h18m58s 3s514ms 14 5,334 7h3m9s 4s759ms 15 4,634 1s77ms 0ms 16 4,195 5h48m4s 4s978ms 17 3,675 2h21m37s 2s312ms 18 2,677 2h45m54s 3s718ms 19 2,006 1h1m58s 1s853ms 20 1,803 16m47s 558ms 21 1,083 5h28m17s 18s187ms 22 581 2h36m32s 16s166ms -
update res_users set sid = '0ff61103934c706f8a00df0ae45720f159a47e16', last_update = '2025-01-26 17:33:03.971255', exp_date = '2025-01-26 18:18:03.971261', logged_in = 'TRUE' where id = 1037;
Date: 2025-01-26 19:33:03 Duration: 59m59s
-
update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350440', exp_date = '2025-01-26 10:02:11.350443', logged_in = 'TRUE' where id = 843;
Date: 2025-01-26 11:03:20 Duration: 46m9s
-
update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350385', exp_date = '2025-01-26 10:02:11.350388', logged_in = 'TRUE' where id = 843;
Date: 2025-01-26 11:03:20 Duration: 46m9s
2 1d18h4m20s 248,053 490ms 5s210ms 610ms select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 7,015 1h8m 581ms 01 9,380 1h32m33s 592ms 02 7,082 1h9m22s 587ms 03 10,049 1h39m55s 596ms 04 5,809 55m50s 576ms 05 3,070 28m57s 565ms 06 3,325 32m24s 584ms 07 3,480 33m10s 571ms 08 3,341 31m45s 570ms 09 12,557 2h7m29s 609ms 10 19,533 3h34m19s 658ms 11 17,969 3h10m54s 637ms 12 17,613 3h10m3s 647ms 13 10,590 1h46m57s 606ms 14 9,303 1h32m32s 596ms 15 11,452 1h57m3s 613ms 16 11,871 2h4m26s 628ms 17 11,856 1h58m1s 597ms 18 15,255 2h45m24s 650ms 19 19,138 3h10m41s 597ms 20 13,457 2h16m33s 608ms 21 18,014 2h52m10s 573ms 22 6,894 1h5m40s 571ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797245)) AND (("shipping_track"."id" not in (39712235, 39712235)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:39 Duration: 5s210ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797170)) AND (("shipping_track"."id" not in (39711810, 39711810)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:30 Duration: 5s12ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797270)) AND (("shipping_track"."id" not in (39712349, 39712349)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:59 Duration: 4s885ms
3 13h54m9s 1 13h54m9s 13h54m9s 13h54m9s select "shipping_policy".id from "shipping_policy" left join "urgent_office" AS "shipping_policy__from_office" on ("shipping_policy"."from_office" = "shipping_policy__from_office"."id") where ((("shipping_policy"."active" = true) and (("shipping_policy"."state" != ?) or "shipping_policy"."state" is null)) and (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where (("policy_number"."name"::text not ilike ?) or "policy_number"."name" is null))) or "shipping_policy"."policy_id" is null)) 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"."collection_amount_sender" asc, "shipping_policy__from_office"."new_code" asc, "shipping_policy"."total_shipping_price" asc, "shipping_policy"."total_amount_cash_lines" asc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 09 1 13h54m9s 13h54m9s -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__from_office" ON ("shipping_policy"."from_office" = "shipping_policy__from_office"."id") WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name"::text not ilike '%9842912%') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)) 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"."collection_amount_sender" ASC, "shipping_policy__from_office"."new_code" ASC, "shipping_policy"."total_shipping_price" ASC, "shipping_policy"."total_amount_cash_lines" ASC LIMIT 100;
Date: 2025-01-26 09:23:07 Duration: 13h54m9s
4 8h11m8s 136,796 158ms 1s548ms 215ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 26 00 1,293 4m13s 195ms 01 2,223 7m31s 203ms 02 1,784 5m53s 198ms 03 3,487 11m38s 200ms 04 2,203 7m11s 195ms 05 745 2m25s 195ms 06 1,975 6m26s 195ms 07 974 3m9s 194ms 08 2,818 9m21s 199ms 09 6,517 23m13s 213ms 10 9,242 35m32s 230ms 11 5,755 21m28s 223ms 12 6,090 22m54s 225ms 13 5,629 19m47s 210ms 14 5,323 18m38s 210ms 15 5,851 20m53s 214ms 16 8,564 30m42s 215ms 17 2,532 8m30s 201ms 18 27,217 1h47m16s 236ms 19 3,158 10m52s 206ms 20 21,753 1h15m55s 209ms 21 9,677 31m1s 192ms 22 1,986 6m28s 195ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9997843')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:37 Duration: 1s548ms
-
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" = '4228')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:36 Duration: 1s452ms
-
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" = '100704')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:18 Duration: 1s400ms
5 7h34m2s 43,276 500ms 4s321ms 629ms select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 26 00 150 1m36s 645ms 01 221 2m26s 665ms 02 170 1m54s 673ms 03 209 2m22s 680ms 04 150 1m37s 649ms 05 265 2m34s 582ms 06 205 1m59s 581ms 07 184 1m51s 605ms 08 707 6m57s 591ms 09 3,155 32m39s 621ms 10 4,793 53m38s 671ms 11 4,660 51m12s 659ms 12 4,947 54m39s 662ms 13 3,549 36m22s 614ms 14 3,052 30m55s 608ms 15 4,422 45m17s 614ms 16 3,684 38m14s 622ms 17 2,459 24m6s 588ms 18 2,235 23m46s 638ms 19 1,479 14m29s 588ms 20 1,596 15m42s 590ms 21 599 5m55s 593ms 22 385 3m41s 575ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4742441, 4733071, 4711819, 4710012, 4694417, 4689452, 4688097, 4680256, 4671369)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:33:05 Duration: 4s321ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4770633)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:11 Duration: 4s148ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4788476)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:21 Duration: 4s44ms
6 3h50m55s 56,650 92ms 940ms 244ms select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 26 00 1,913 6m2s 189ms 01 2,880 10m23s 216ms 02 2,260 8m47s 233ms 03 2,636 10m20s 235ms 04 956 4m9s 261ms 05 302 1m17s 257ms 06 1,626 6m41s 247ms 07 950 3m38s 229ms 08 50 12s678ms 253ms 09 436 1m42s 234ms 10 566 2m38s 279ms 11 300 1m13s 246ms 12 212 1m 286ms 13 360 1m28s 246ms 14 758 3m8s 249ms 15 1,880 8m10s 261ms 16 3,935 17m13s 262ms 17 6,321 26m34s 252ms 18 4,598 20m52s 272ms 19 7,068 29m12s 247ms 20 8,706 34m9s 235ms 21 4,719 18m36s 236ms 22 3,218 13m17s 247ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:35:02 Duration: 940ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شيماء')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:35:02 Duration: 938ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:50:55 Duration: 927ms
7 2h52m35s 11,211 212ms 1s843ms 923ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 26 00 544 7m57s 877ms 01 790 12m6s 919ms 02 12 10s656ms 888ms 03 502 7m42s 922ms 05 157 2m19s 890ms 07 5 4s401ms 880ms 08 6 5s341ms 890ms 09 12 11s176ms 931ms 10 9 9s154ms 1s17ms 11 37 39s776ms 1s75ms 12 54 54s523ms 1s9ms 13 99 1m39s 1s7ms 14 104 1m41s 978ms 15 474 7m33s 956ms 16 442 7m6s 964ms 17 432 6m45s 938ms 18 1,007 16m37s 990ms 19 2,236 34m23s 922ms 20 3,123 47m3s 904ms 21 812 11m50s 874ms 22 354 5m33s 943ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '85677')) 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 (8))))))) 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 (8)))))) 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 (8)))))) 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 (8))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:36:43 Duration: 1s843ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '17347')) 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 (22))))))) 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 (22)))))) 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 (22)))))) 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 (22))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:32:16 Duration: 1s819ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '94803')) 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 (22))))))) 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 (22)))))) 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 (22)))))) 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 (22))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:32:45 Duration: 1s799ms
8 2h21m22s 291 0ms 12m42s 29s148ms update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 26 00 5 1ms 0ms 01 5 1ms 0ms 02 3 0ms 0ms 03 4 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 13 2ms 0ms 09 28 6ms 0ms 10 30 7ms 0ms 11 26 27ms 1ms 12 35 1h45m5s 3m 13 31 25m43s 49s788ms 14 30 18ms 0ms 15 16 11ms 0ms 16 13 10ms 0ms 17 18 23ms 1ms 18 9 10m33s 1m10s 19 4 2ms 0ms 20 3 3ms 1ms 21 8 4ms 0ms 22 6 8ms 1ms -
UPDATE "res_users" SET "exp_date" = '2025-01-26 11:48:38.578935', "last_update" = '2025-01-26 11:03:38.578968', "sid" = '7ba19d50711fb32486d349a84abc04535b2dc548', "write_date" = '2025-01-26 11:03:38.112147', "write_uid" = 1 WHERE id IN (826);
Date: 2025-01-26 12:16:20 Duration: 12m42s
-
UPDATE "res_users" SET "exp_date" = '2025-01-26 11:49:05.800113', "last_update" = '2025-01-26 11:04:05.800142', "sid" = '0a4a2a1c8e67d6d6f727741bd720c3039903df0f', "write_date" = '2025-01-26 11:04:05.408207', "write_uid" = 1 WHERE id IN (826);
Date: 2025-01-26 12:16:20 Duration: 12m15s
-
UPDATE "res_users" SET "exp_date" = '2025-01-26 12:59:36.178876', "last_update" = '2025-01-26 12:14:36.178899', "sid" = '44a30fc9a8748cb00b04b484a35a0f215bf5084b', "write_date" = '2025-01-26 12:14:35.805323', "write_uid" = 1 WHERE id IN (947);
Date: 2025-01-26 13:26:20 Duration: 11m44s
9 1h59m3s 24,298 190ms 638ms 293ms select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 26 08 1,101 5m4s 276ms 09 2,185 10m32s 289ms 10 3,356 17m31s 313ms 11 1,825 9m18s 306ms 12 2,638 13m14s 301ms 13 3,144 14m52s 283ms 14 2,828 13m36s 288ms 15 2,901 13m46s 284ms 16 3,239 15m47s 292ms 17 1,081 5m18s 295ms -
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" = '9909839')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:43 Duration: 638ms
-
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" = '9909600')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:39 Duration: 594ms
-
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" = '9909563')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:35 Duration: 588ms
10 1h50m7s 138,425 35ms 328ms 47ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 26 00 2,970 2m13s 45ms 01 4,058 3m5s 45ms 02 2,724 2m3s 45ms 03 4,447 3m24s 45ms 04 1,378 1m2s 45ms 05 853 37s804ms 44ms 06 1,204 52s906ms 43ms 07 1,264 55s652ms 44ms 08 2,189 1m38s 44ms 09 9,587 7m32s 47ms 10 13,755 11m41s 51ms 11 13,792 11m24s 49ms 12 14,480 12m6s 50ms 13 8,092 6m22s 47ms 14 7,508 5m49s 46ms 15 8,087 6m22s 47ms 16 8,508 6m47s 47ms 17 7,963 6m5s 45ms 18 5,657 4m41s 49ms 19 5,369 4m9s 46ms 20 7,501 5m50s 46ms 21 3,854 2m55s 45ms 22 3,185 2m21s 44ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4775488, 4774032, 4767954)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:32:22 Duration: 328ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4785067, 4733784, 4619705)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:33:52 Duration: 315ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4662697)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:35:41 Duration: 272ms
11 1h19m15s 17,471 206ms 1s938ms 272ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 26 00 418 1m52s 269ms 01 659 3m1s 274ms 02 1,133 5m1s 266ms 03 827 3m44s 271ms 04 491 2m6s 258ms 06 824 3m34s 259ms 07 476 2m5s 262ms 08 23 5s850ms 254ms 09 212 1m1s 289ms 10 308 1m36s 311ms 11 118 34s912ms 295ms 12 53 17s76ms 322ms 13 87 24s531ms 281ms 14 279 1m19s 285ms 15 485 2m17s 282ms 16 1,565 7m23s 283ms 17 2,769 12m10s 263ms 18 1,307 6m58s 320ms 19 1,329 5m49s 262ms 20 1,261 5m41s 271ms 21 1,576 6m53s 262ms 22 1,271 5m16s 249ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '96383')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:35:52 Duration: 1s938ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9972793')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:36:07 Duration: 1s875ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9948172')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:35:47 Duration: 1s846ms
12 44m13s 12,488 162ms 396ms 212ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 26 00 20 4s77ms 203ms 01 80 16s205ms 202ms 02 12 2s518ms 209ms 03 103 20s490ms 198ms 05 136 26s592ms 195ms 06 1,094 3m34s 196ms 07 918 2m59s 195ms 08 632 2m4s 197ms 09 2,044 7m14s 212ms 10 1,858 6m53s 222ms 11 1,812 6m41s 221ms 12 1,360 5m11s 229ms 13 898 3m9s 210ms 14 605 2m5s 207ms 15 227 48s560ms 213ms 16 191 41s219ms 215ms 17 130 25s930ms 199ms 18 97 21s983ms 226ms 19 154 29s6ms 188ms 20 55 10s466ms 190ms 21 56 10s565ms 188ms 22 6 1s90ms 181ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '74141')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:49 Duration: 396ms
-
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" = '74191')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:50 Duration: 359ms
-
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" = '77176')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 10:07:41 Duration: 347ms
13 39m17s 19,553 95ms 724ms 120ms 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 Jan 26 00 289 31s77ms 107ms 01 71 7s817ms 110ms 05 56 6s453ms 115ms 08 135 15s345ms 113ms 09 1,299 2m36s 120ms 10 2,060 4m16s 124ms 11 1,421 2m58s 125ms 12 1,794 3m49s 127ms 13 2,108 4m7s 117ms 14 2,474 4m44s 115ms 15 2,201 4m25s 120ms 16 1,551 3m6s 120ms 17 1,853 3m32s 114ms 18 951 2m4s 130ms 19 921 1m50s 119ms 20 215 25s842ms 120ms 21 93 11s129ms 119ms 22 61 7s498ms 122ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8003794)) AND (("cash_track"."id" not in (7105518, 7109072, 7132040, 7384506, 7388173, 7388173)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:34:43 Duration: 724ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8039222)) AND (("cash_track"."id" not in (7364360, 7373716, 7387873, 7388145, 7388145)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:33:49 Duration: 704ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8028961)) AND (("cash_track"."id" not in (7300721, 7304686, 7305978, 7384443, 7388161, 7388161)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:34:40 Duration: 613ms
14 37m18s 38,724 44ms 343ms 57ms select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 26 08 1,377 1m13s 53ms 09 4,693 4m24s 56ms 10 2,730 2m48s 61ms 11 4,092 4m4s 59ms 12 5,542 5m36s 60ms 13 3,621 3m26s 57ms 14 4,275 3m55s 55ms 15 4,394 4m11s 57ms 16 5,549 5m19s 57ms 17 2,238 2m3s 55ms 18 84 6s564ms 78ms 19 36 1s951ms 54ms 20 61 3s490ms 57ms 21 10 543ms 54ms 22 22 1s236ms 56ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4766555) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:34:23 Duration: 343ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4761346) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:33:59 Duration: 334ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4763380) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:34:52 Duration: 330ms
15 32m34s 9,794 169ms 281ms 199ms 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 Jan 26 00 1,179 3m52s 197ms 01 1,971 6m41s 203ms 02 1,772 5m51s 198ms 03 2,286 7m40s 201ms 04 2,149 7m1s 196ms 05 437 1m25s 196ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '119712')) 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-01-26 03:47:23 Duration: 281ms
-
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" = '81711')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 01:15:15 Duration: 261ms
-
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" = '153261')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 01:15:15 Duration: 261ms
16 16m15s 18,729 39ms 102ms 52ms select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 26 08 987 47s763ms 48ms 09 2,558 2m10s 50ms 10 1,280 1m10s 54ms 11 2,079 1m50s 52ms 12 2,238 2m5s 55ms 13 1,779 1m31s 51ms 14 1,819 1m32s 50ms 15 2,402 2m6s 52ms 16 2,462 2m5s 51ms 17 1,121 54s932ms 49ms 18 4 325ms 81ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4667229) ORDER BY "collection_policy"."id";
Date: 2025-01-26 12:23:49 Duration: 102ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4543211) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:33:24 Duration: 101ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4628163) ORDER BY "collection_policy"."id";
Date: 2025-01-26 14:05:47 Duration: 91ms
17 14m50s 1,851 364ms 733ms 480ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 26 00 218 1m31s 420ms 08 351 2m30s 428ms 09 319 2m39s 501ms 10 474 4m9s 525ms 11 307 2m33s 498ms 12 6 3s21ms 503ms 13 31 13s946ms 449ms 14 78 37s337ms 478ms 15 63 29s745ms 472ms 16 4 1s928ms 482ms -
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" = '9847762')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 10:42:58 Duration: 733ms
-
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" = '9847938')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 10:42:19 Duration: 719ms
-
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" = '478934')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 11:41:12 Duration: 705ms
18 14m11s 5,636 119ms 279ms 151ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 26 00 10 1s422ms 142ms 01 11 1s475ms 134ms 03 73 11s188ms 153ms 05 5 660ms 132ms 06 5 647ms 129ms 08 140 19s115ms 136ms 09 447 1m5s 146ms 10 1,110 2m57s 159ms 11 1,062 2m43s 154ms 12 1,166 3m1s 156ms 13 377 53s928ms 143ms 14 287 40s420ms 140ms 15 149 21s982ms 147ms 16 309 45s298ms 146ms 17 189 26s436ms 139ms 18 87 12s490ms 143ms 19 39 5s298ms 135ms 20 96 13s65ms 136ms 21 34 4s703ms 138ms 22 40 5s290ms 132ms -
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-01-26 10:42:18 Duration: 279ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 64)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-26 10:40:07 Duration: 278ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 78)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-26 10:44:27 Duration: 272ms
19 12m50s 266 28ms 4s451ms 2s896ms select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 26 01 17 51s351ms 3s20ms 08 2 5s987ms 2s993ms 09 2 6s589ms 3s294ms 10 8 24s554ms 3s69ms 11 4 11s937ms 2s984ms 12 41 1m58s 2s895ms 13 14 37s232ms 2s659ms 14 17 47s750ms 2s808ms 15 12 39s882ms 3s323ms 16 18 1m1s 3s435ms 17 48 1m43s 2s157ms 18 37 2m6s 3s408ms 19 23 1m11s 3s103ms 20 8 19s76ms 2s384ms 21 15 44s598ms 2s973ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))))) 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 (77)))))) 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 (77)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))))))) 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 (77)))))))) AND ("policy_number"."name"::text ilike '%32142%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 18:36:42 Duration: 4s451ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))) 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 (22)))))) 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 (22)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) 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 (22)))))))) AND ("policy_number"."name"::text ilike '%9874013%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 18:31:49 Duration: 4s344ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))))) 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 (85)))))) 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 (85)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))))))) 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 (85)))))))) AND ("policy_number"."name"::text ilike '%9985%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 14:06:11 Duration: 4s169ms
20 12m20s 2,726 218ms 819ms 271ms select name from shipping_policy order by create_date desc limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 120 31s699ms 264ms 01 120 32s195ms 268ms 02 120 31s569ms 263ms 03 120 32s345ms 269ms 04 120 31s423ms 261ms 05 120 30s954ms 257ms 06 120 31s169ms 259ms 07 120 31s26ms 258ms 08 120 31s426ms 261ms 09 120 34s64ms 283ms 10 120 36s427ms 303ms 11 120 35s662ms 297ms 12 120 35s806ms 298ms 13 120 33s580ms 279ms 14 120 33s585ms 279ms 15 120 34s128ms 284ms 16 120 34s75ms 283ms 17 116 30s445ms 262ms 18 120 33s47ms 275ms 19 120 31s178ms 259ms 20 120 31s715ms 264ms 21 120 30s715ms 255ms 22 90 21s962ms 244ms -
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:34:03 Duration: 819ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:34:02 Duration: 709ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:33:03 Duration: 432ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,278,435 1m55s 0ms 2ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 26 00 38,530 1s990ms 0ms 01 42,814 2s260ms 0ms 02 35,521 1s808ms 0ms 03 40,651 2s149ms 0ms 04 31,083 1s566ms 0ms 05 18,275 881ms 0ms 06 24,717 1s262ms 0ms 07 23,852 1s214ms 0ms 08 51,212 2s669ms 0ms 09 137,963 8s3ms 0ms 10 203,243 12s413ms 0ms 11 209,332 10s379ms 0ms 12 208,139 10s326ms 0ms 13 184,955 8s740ms 0ms 14 187,365 8s996ms 0ms 15 176,135 8s694ms 0ms 16 168,666 7s533ms 0ms 17 136,133 6s284ms 0ms 18 111,802 5s531ms 0ms 19 89,417 4s473ms 0ms 20 77,899 4s227ms 0ms 21 50,336 2s546ms 0ms 22 30,395 1s221ms 0ms -
DISCARD ALL;
Date: 2025-01-26 10:40:01 Duration: 2ms
-
DISCARD ALL;
Date: 2025-01-26 03:31:37 Duration: 1ms
-
DISCARD ALL;
Date: 2025-01-26 10:46:43 Duration: 1ms
2 1,790,127 26s115ms 0ms 1ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 28,833 455ms 0ms 01 32,365 512ms 0ms 02 26,409 414ms 0ms 03 31,683 502ms 0ms 04 23,370 368ms 0ms 05 13,217 220ms 0ms 06 19,506 309ms 0ms 07 18,492 294ms 0ms 08 40,008 606ms 0ms 09 114,653 1s719ms 0ms 10 168,184 2s617ms 0ms 11 170,447 2s383ms 0ms 12 169,007 2s444ms 0ms 13 147,343 2s27ms 0ms 14 146,824 1s988ms 0ms 15 134,916 1s955ms 0ms 16 127,669 1s725ms 0ms 17 105,999 1s429ms 0ms 18 84,919 1s286ms 0ms 19 66,046 994ms 0ms 20 60,459 949ms 0ms 21 37,621 594ms 0ms 22 22,157 312ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-26 09:08:19 Duration: 1ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-26 10:48:06 Duration: 1ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-26 10:32:39 Duration: 1ms
3 1,160,953 11s768ms 0ms 1ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 00 19,937 192ms 0ms 01 22,069 221ms 0ms 02 18,375 179ms 0ms 03 21,024 212ms 0ms 04 16,149 156ms 0ms 05 9,747 90ms 0ms 06 13,010 127ms 0ms 07 12,537 120ms 0ms 08 26,526 257ms 0ms 09 70,137 748ms 0ms 10 102,987 1s192ms 0ms 11 106,167 1s118ms 0ms 12 105,590 1s97ms 0ms 13 93,732 899ms 0ms 14 95,026 892ms 0ms 15 89,382 871ms 0ms 16 85,433 843ms 0ms 17 69,177 678ms 0ms 18 56,837 604ms 0ms 19 45,597 441ms 0ms 20 39,756 417ms 0ms 21 25,997 261ms 0ms 22 15,761 140ms 0ms -
ROLLBACK;
Date: 2025-01-26 17:49:06 Duration: 1ms
-
ROLLBACK;
Date: 2025-01-26 17:14:25 Duration: 1ms
-
ROLLBACK;
Date: 2025-01-26 02:17:05 Duration: 1ms
4 1,148,962 3m14s 0ms 15ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 26 00 19,295 3s232ms 0ms 01 21,420 3s701ms 0ms 02 17,741 3s17ms 0ms 03 20,358 3s644ms 0ms 04 15,507 2s636ms 0ms 05 9,135 1s512ms 0ms 06 12,359 2s71ms 0ms 07 11,904 1s937ms 0ms 08 25,809 4s169ms 0ms 09 69,646 11s910ms 0ms 10 102,833 17s890ms 0ms 11 105,743 18s774ms 0ms 12 105,418 18s115ms 0ms 13 93,606 15s283ms 0ms 14 94,541 14s478ms 0ms 15 88,824 14s246ms 0ms 16 85,134 14s223ms 0ms 17 68,680 11s605ms 0ms 18 56,303 10s334ms 0ms 19 44,999 7s814ms 0ms 20 39,227 7s171ms 0ms 21 25,213 4s601ms 0ms 22 15,267 2s464ms 0ms -
SELECT payload FROM http_sessions WHERE sid = '443195c2c364c2d4e0c43a6e3d042cd0804c2714';
Date: 2025-01-26 13:13:52 Duration: 15ms
-
SELECT payload FROM http_sessions WHERE sid = '7213b7d2babf18f1accebe14935e4dc8e4407a1b';
Date: 2025-01-26 13:13:52 Duration: 14ms
-
SELECT payload FROM http_sessions WHERE sid = '415d9a56f6f0234a155ccf82b4699a186f8472c2';
Date: 2025-01-26 12:37:36 Duration: 14ms
5 1,139,457 1m41s 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 Jan 26 00 19,341 1s689ms 0ms 01 21,472 1s885ms 0ms 02 17,836 1s527ms 0ms 03 20,395 1s795ms 0ms 04 15,625 1s352ms 0ms 05 9,204 783ms 0ms 06 12,435 1s64ms 0ms 07 12,014 1s30ms 0ms 08 25,595 2s158ms 0ms 09 68,906 6s116ms 0ms 10 101,595 9s327ms 0ms 11 104,578 9s830ms 0ms 12 103,953 9s651ms 0ms 13 92,433 8s96ms 0ms 14 93,615 7s794ms 0ms 15 88,031 7s662ms 0ms 16 84,309 7s430ms 0ms 17 68,062 6s156ms 0ms 18 55,924 5s402ms 0ms 19 44,729 3s963ms 0ms 20 39,010 3s653ms 0ms 21 25,176 2s300ms 0ms 22 15,219 1s274ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-26 19:10:19 Duration: 2ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-26 10:32:39 Duration: 1ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-26 17:21:53 Duration: 1ms
6 814,378 2m18s 0ms 10ms 0ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 26 00 11,697 3s82ms 0ms 01 13,457 3s685ms 0ms 02 9,441 2s910ms 0ms 03 12,954 4s76ms 0ms 04 8,348 3s44ms 0ms 05 4,004 1s543ms 0ms 06 7,928 2s475ms 0ms 07 6,946 2s254ms 0ms 08 17,078 3s951ms 0ms 09 58,489 10s399ms 0ms 10 84,938 14s925ms 0ms 11 84,397 12s398ms 0ms 12 82,652 12s286ms 0ms 13 71,370 10s218ms 0ms 14 68,477 10s459ms 0ms 15 61,190 9s89ms 0ms 16 54,411 7s596ms 0ms 17 47,145 6s692ms 0ms 18 35,278 5s555ms 0ms 19 26,147 4s239ms 0ms 20 26,182 4s345ms 0ms 21 14,076 2s411ms 0ms 22 7,773 1s191ms 0ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1315);
Date: 2025-01-26 17:21:53 Duration: 10ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (977);
Date: 2025-01-26 17:21:53 Duration: 10ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (977);
Date: 2025-01-26 17:21:53 Duration: 10ms
7 628,670 1m46s 0ms 40ms 0ms commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 26 00 8,898 1s695ms 0ms 01 10,297 2s1ms 0ms 02 8,034 1s382ms 0ms 03 10,659 1s818ms 0ms 04 7,221 1s294ms 0ms 05 3,469 547ms 0ms 06 6,497 908ms 0ms 07 5,955 898ms 0ms 08 13,481 1s878ms 0ms 09 44,510 7s19ms 0ms 10 65,176 10s832ms 0ms 11 64,204 10s654ms 0ms 12 63,333 10s841ms 0ms 13 53,547 8s744ms 0ms 14 51,764 7s830ms 0ms 15 45,531 7s325ms 0ms 16 42,173 6s813ms 0ms 17 36,784 6s36ms 0ms 18 28,031 5s700ms 0ms 19 20,444 4s228ms 0ms 20 20,722 3s756ms 0ms 21 11,578 2s859ms 0ms 22 6,362 1s254ms 0ms -
COMMIT;
Date: 2025-01-26 11:33:58 Duration: 40ms
-
COMMIT;
Date: 2025-01-26 18:31:52 Duration: 39ms
-
COMMIT;
Date: 2025-01-26 19:42:20 Duration: 34ms
8 492,267 1m5s 0ms 6ms 0ms select "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" from "urgent_customer" where "urgent_customer".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 26 00 8,323 992ms 0ms 01 8,805 1s16ms 0ms 02 5,646 588ms 0ms 03 7,847 977ms 0ms 04 3,977 464ms 0ms 05 2,312 353ms 0ms 06 5,061 585ms 0ms 07 3,504 420ms 0ms 08 8,678 1s44ms 0ms 09 34,866 5s2ms 0ms 10 51,062 7s513ms 0ms 11 50,708 7s515ms 0ms 12 47,262 6s725ms 0ms 13 41,282 5s808ms 0ms 14 38,628 4s905ms 0ms 15 37,785 4s694ms 0ms 16 33,123 4s203ms 0ms 17 31,530 3s771ms 0ms 18 21,670 2s926ms 0ms 19 17,780 2s101ms 0ms 20 18,354 2s161ms 0ms 21 8,575 1s118ms 0ms 22 5,489 866ms 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 (5099138, 5099009, 5410844, 5100498, 5198278, 5099585, 5099035, 5192556, 5099141, 5099013, 5492093, 5099103, 5102973, 5099445, 5492092, 5099631, 5099006, 5121781, 5104087, 5099500, 5099296, 5101817, 5101829, 5103117, 5099254, 5099263, 5099007, 5126395, 5100578, 5099746, 5099287);
Date: 2025-01-26 17:21:53 Duration: 6ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5100838, 5099669, 5099162, 5100581, 5115015, 5099740, 5107921, 5099415, 5099007, 5102186, 5100538, 5100518, 5099263, 5099008, 5099678, 5099788, 5318887, 5101152, 5099182, 5103662);
Date: 2025-01-26 17:21:53 Duration: 5ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099102, 5099006, 5100413, 5148620, 5101078, 5099404, 5099007, 5251741, 5112956, 5099009, 5101122, 5099138, 5107816, 5099296, 5099141, 5099802, 5101966, 5099243, 5404807, 5099244, 5099416, 5099144, 5100729, 5099008, 5099013, 5099112, 5125988, 5129839, 5208811, 5099590, 5099014, 5370578, 5225519, 5100142, 5099570, 5176085, 5108224, 5122526, 5132150, 5258979, 5110180, 5099639, 5099499, 5099750, 5175453, 5099967, 5099712, 5101185, 5100872, 5110244, 5102234, 5099758, 5126396, 5099010, 5099027, 5151450, 5099403, 5099788, 5101349, 5187607, 5128669, 5100428, 5109418, 5484732, 5430613, 5100233, 5099266, 5104006, 5103878, 5099103, 5099707, 5099698, 5373749, 5100347);
Date: 2025-01-26 17:21:54 Duration: 4ms
9 487,875 32s244ms 0ms 13ms 0ms select "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 26 00 6,201 352ms 0ms 01 6,325 389ms 0ms 02 3,756 212ms 0ms 03 5,641 340ms 0ms 04 3,086 181ms 0ms 05 1,953 102ms 0ms 06 4,990 262ms 0ms 07 4,128 226ms 0ms 08 8,844 503ms 0ms 09 33,190 2s198ms 0ms 10 50,649 3s689ms 0ms 11 51,806 3s667ms 0ms 12 50,576 3s571ms 0ms 13 43,399 2s827ms 0ms 14 40,550 2s578ms 0ms 15 38,142 2s378ms 0ms 16 33,265 2s107ms 0ms 17 30,753 1s873ms 0ms 18 22,701 1s659ms 0ms 19 16,484 1s57ms 0ms 20 18,084 1s154ms 0ms 21 8,405 599ms 0ms 22 4,947 311ms 0ms -
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (14, 13, 26, 110, 52, 17, 27, 55, 65, 39, 111, 127, 53);
Date: 2025-01-26 11:07:11 Duration: 13ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (62);
Date: 2025-01-26 10:29:27 Duration: 1ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17);
Date: 2025-01-26 12:17:04 Duration: 1ms
10 340,367 1m3s 0ms 10ms 0ms select "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" from "res_partner" where "res_partner".id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 26 00 4,034 684ms 0ms 01 4,647 803ms 0ms 02 2,464 461ms 0ms 03 3,420 671ms 0ms 04 1,947 367ms 0ms 05 1,163 180ms 0ms 06 3,281 522ms 0ms 07 2,487 411ms 0ms 08 8,261 1s293ms 0ms 09 25,249 4s457ms 0ms 10 34,607 6s985ms 0ms 11 35,171 7s54ms 0ms 12 35,244 6s892ms 0ms 13 31,304 5s608ms 0ms 14 30,260 5s167ms 0ms 15 26,665 4s723ms 0ms 16 23,641 4s367ms 0ms 17 20,621 3s753ms 0ms 18 14,856 3s70ms 0ms 19 11,034 2s58ms 0ms 20 11,038 2s129ms 0ms 21 5,776 1s111ms 0ms 22 3,197 596ms 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 (8006457);
Date: 2025-01-26 17:21:53 Duration: 10ms
-
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8006316);
Date: 2025-01-26 17:21:53 Duration: 10ms
-
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8006936, 8006325, 8006353, 8006346, 8006435, 8006359, 8007494, 8007496, 8004660, 8004678, 8006302, 8006398, 8006392, 8006469, 8004663, 8006354);
Date: 2025-01-26 10:42:46 Duration: 2ms
11 323,333 1m44s 0ms 4ms 0ms select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 26 00 1,922 604ms 0ms 01 2,343 735ms 0ms 02 1,710 527ms 0ms 03 1,591 509ms 0ms 04 776 246ms 0ms 05 561 165ms 0ms 06 1,333 406ms 0ms 07 872 262ms 0ms 08 7,206 2s211ms 0ms 09 16,727 5s546ms 0ms 10 20,968 7s421ms 0ms 11 39,593 13s247ms 0ms 12 44,119 14s693ms 0ms 13 35,226 10s998ms 0ms 14 25,240 7s877ms 0ms 15 23,418 7s683ms 0ms 16 25,998 8s277ms 0ms 17 26,158 8s122ms 0ms 18 18,432 6s370ms 0ms 19 10,074 3s111ms 0ms 20 9,257 3s20ms 0ms 21 5,630 1s737ms 0ms 22 4,179 1s155ms 0ms -
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1031) OR r.global) ORDER BY r.id;
Date: 2025-01-26 13:08:13 Duration: 4ms
-
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 = 833) OR r.global) ORDER BY r.id;
Date: 2025-01-26 14:06:10 Duration: 4ms
-
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 = 844) OR r.global) ORDER BY r.id;
Date: 2025-01-26 17:21:53 Duration: 3ms
12 248,053 1d18h4m20s 490ms 5s210ms 610ms select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 26 00 7,015 1h8m 581ms 01 9,380 1h32m33s 592ms 02 7,082 1h9m22s 587ms 03 10,049 1h39m55s 596ms 04 5,809 55m50s 576ms 05 3,070 28m57s 565ms 06 3,325 32m24s 584ms 07 3,480 33m10s 571ms 08 3,341 31m45s 570ms 09 12,557 2h7m29s 609ms 10 19,533 3h34m19s 658ms 11 17,969 3h10m54s 637ms 12 17,613 3h10m3s 647ms 13 10,590 1h46m57s 606ms 14 9,303 1h32m32s 596ms 15 11,452 1h57m3s 613ms 16 11,871 2h4m26s 628ms 17 11,856 1h58m1s 597ms 18 15,255 2h45m24s 650ms 19 19,138 3h10m41s 597ms 20 13,457 2h16m33s 608ms 21 18,014 2h52m10s 573ms 22 6,894 1h5m40s 571ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797245)) AND (("shipping_track"."id" not in (39712235, 39712235)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:39 Duration: 5s210ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797170)) AND (("shipping_track"."id" not in (39711810, 39711810)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:30 Duration: 5s12ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797270)) AND (("shipping_track"."id" not in (39712349, 39712349)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:59 Duration: 4s885ms
13 243,939 43s162ms 0ms 2ms 0ms select ? from res_groups_users_rel where uid = ? and gid in ( select res_id from ir_model_data where module = ? and name = ? and model = ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 26 00 1,787 254ms 0ms 01 2,851 400ms 0ms 02 1,867 254ms 0ms 03 1,905 258ms 0ms 04 1,208 151ms 0ms 05 793 106ms 0ms 06 1,309 183ms 0ms 07 1,046 139ms 0ms 08 7,812 1s174ms 0ms 09 13,840 2s326ms 0ms 10 15,878 2s891ms 0ms 11 29,248 5s583ms 0ms 12 29,511 5s859ms 0ms 13 25,365 4s506ms 0ms 14 18,718 3s126ms 0ms 15 16,336 2s915ms 0ms 16 18,302 3s254ms 0ms 17 17,932 3s131ms 0ms 18 14,135 2s745ms 0ms 19 8,089 1s291ms 0ms 20 6,616 1s135ms 0ms 21 5,552 876ms 0ms 22 3,839 594ms 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-01-26 18:33:19 Duration: 2ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1353 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_cash_policy' AND name = 'active_unactive_policy' AND model = 'res.groups');
Date: 2025-01-26 16:16:45 Duration: 2ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-01-26 12:40:30 Duration: 1ms
14 227,275 56s997ms 0ms 20ms 0ms select "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" from "policy_number" where "policy_number".id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 26 00 3,540 802ms 0ms 01 4,059 933ms 0ms 02 2,672 638ms 0ms 03 3,639 1s32ms 0ms 04 1,747 451ms 0ms 05 911 299ms 0ms 06 2,499 624ms 0ms 07 1,694 450ms 0ms 08 3,620 895ms 0ms 09 14,501 4s85ms 0ms 10 20,782 5s744ms 0ms 11 20,800 5s780ms 0ms 12 20,371 5s260ms 0ms 13 18,660 4s462ms 0ms 14 17,614 3s902ms 0ms 15 18,159 4s166ms 0ms 16 15,700 3s829ms 0ms 17 16,818 3s857ms 0ms 18 10,776 2s844ms 0ms 19 10,525 2s369ms 0ms 20 10,137 2s489ms 0ms 21 4,882 1s287ms 0ms 22 3,169 790ms 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 (41388142, 41473293, 41253060, 41472930, 32228855, 32229005, 41935053, 32196580, 32215025, 41233816, 41771354, 42058776, 32228864, 32228994, 32192631, 42042730, 42103612, 32190875, 32191048, 32196581, 41339668, 41325701, 41788334, 32191787, 42031918, 32192037, 42058770, 41922531, 41578346, 42142405, 42047506, 41473216, 41473220, 41473386, 41473153, 41958508, 41439953, 41746634, 42129037, 41473379, 41957995, 41791612, 42061714, 41473144, 41328218, 32190781, 32192604, 32192625, 32656185, 32191773, 32192245, 42177971, 42111404, 32192553, 32188965, 41473389, 41954243, 42076105, 42107932, 41964106, 42103965, 42103645, 32267192, 41473385, 42098106, 41958211, 41974853, 32655982, 41473221, 32656911, 32656924, 41393360, 32233810, 32206649, 42021635, 32249350, 41703493, 42107381, 42107175, 42112522, 41473150, 41958443, 41473210, 41935138, 42117313, 32190783, 41473383, 41875311, 32662358, 32186143, 41473387, 42103964, 42170717, 42110928, 32216740, 41473151, 41473391, 40870189, 32191981, 42101866);
Date: 2025-01-26 17:21:54 Duration: 20ms
-
SELECT "policy_number"."id" AS "id", "policy_number"."from_poilcy" AS "from_poilcy", "policy_number"."name" AS "name", "policy_number"."damaged" AS "damaged", "policy_number"."done" AS "done", "policy_number"."active" AS "active", "policy_number"."reason" AS "reason", "policy_number"."reason_date" AS "reason_date", "policy_number"."notebook_id" AS "notebook_id", "policy_number"."office_id" AS "office_id", "policy_number"."delegate_id" AS "delegate_id", "policy_number"."package_id" AS "package_id", "policy_number"."create_uid" AS "create_uid", "policy_number"."create_date" AS "create_date", "policy_number"."write_uid" AS "write_uid", "policy_number"."write_date" AS "write_date" FROM "policy_number" WHERE "policy_number".id IN (40590283, 41164754, 32668847, 41689916, 41343341, 41344737, 41342733, 41710037, 41163199, 40590262, 32595839, 32650861, 32668632, 41393976, 41689536, 40260197, 40834902, 40228940, 39287018, 40514846, 40648075, 41690234, 41344729, 41344534, 41344725, 41343947, 41688457, 42132162, 41611807, 41611809, 41611820, 41234820, 41613019, 40517115, 42024356, 41905787, 41101154, 40588749, 41531972, 41530750, 41165161, 41104046, 41688662, 41234470, 41394637, 41468816, 42134495, 40992993, 41712773, 42024285, 41530613, 41344415, 41996652, 41905350, 41164129, 41905482, 41996656, 41996672, 41103618, 41234725, 41689371, 41532040, 40811112, 42133847, 41530882, 41777880, 40835284, 41777109, 41995435, 41647425, 40993130, 41777881, 41709731, 41996668, 41884703, 41394956, 41345003, 41904744, 40516680, 40836404, 40835730, 40992304, 41468911, 40835734, 41690170, 41997155, 41344021, 41234402, 41530616, 41234392, 41103654, 41104424, 41688093, 41232448, 41100825, 41467938, 41613039, 41394015, 41610880, 40865079);
Date: 2025-01-26 17:21:54 Duration: 18ms
-
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 (32247897, 32246675, 32247804, 32260409, 32195428, 32283044, 42050012, 32203998, 32306188, 42096135, 42041187, 41903506, 32269461, 32269488, 32654162, 32269475, 32185681, 32227257, 42163935, 32319750, 32208273, 32293752, 42026117, 42074255, 41934902, 32230636, 32230452, 32298219, 32298076, 32297836, 32297787, 32265594, 32211740);
Date: 2025-01-26 17:21:53 Duration: 12ms
15 167,492 1m31s 0ms 19ms 0ms select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."is_change_cash_price" AS "is_change_cash_price", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" from "shipping_policy" where "shipping_policy".id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 26 00 1,101 677ms 0ms 01 959 629ms 0ms 02 182 111ms 0ms 03 237 159ms 0ms 04 182 109ms 0ms 05 88 55ms 0ms 06 635 252ms 0ms 07 501 192ms 0ms 08 2,508 1s184ms 0ms 09 7,217 5s125ms 0ms 10 10,595 6s449ms 0ms 11 9,131 5s780ms 0ms 12 10,458 6s474ms 0ms 13 11,287 7s60ms 0ms 14 9,996 5s820ms 0ms 15 10,170 5s593ms 0ms 16 9,416 5s121ms 0ms 17 5,715 3s265ms 0ms 18 22,974 12s497ms 0ms 19 13,336 7s29ms 0ms 20 15,836 6s951ms 0ms 21 21,574 8s956ms 0ms 22 3,394 1s611ms 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 (1220751, 2826085, 1761967, 1668548, 1354786, 1792279, 1489772, 1742868, 2026377, 3075330, 1830622, 1830452, 1429622, 1830545, 3712854, 1752859, 1957944, 1273797, 1801305, 1789877, 1810835, 1725383, 1710159, 1829106, 1469772, 1882294, 1802115, 1788759, 1573235, 1762660, 2099540, 2267554, 1612649, 1707730, 1740521, 1708525, 1705697, 1259357, 1722984, 1690398, 712346, 1830430, 1881612, 1343545, 1723914, 1748420, 1765301, 1282201, 1728103, 1758715, 1697778, 2338526, 1713548, 1881778, 4381300, 1593075, 1583362, 1762690, 1792621, 1755048, 1762681, 1926124, 2031805, 1762689, 1830560, 1828966, 1985122, 2153066, 2148602, 2195117, 2180359, 2197215, 1792805, 2133479, 2090657, 2121546, 2121804, 2194963, 2073874, 2122405, 2151834, 1835801, 1792914, 1824536, 1656962, 1761961, 1796429, 1614391, 1614445, 1051288, 1755066, 1755067, 1690102, 1668064, 1700082, 1985200, 1829064, 1835957, 1742552, 1692366, 1830572, 1835845, 1197354, 1835948, 1784091, 1470247, 1470108, 1470514, 1470101, 1527320, 1395035, 1333624, 1557444, 1566984, 1527419, 1570652, 1614928, 1792567, 1949042, 1761950, 1989527, 1761502, 1796342, 1830532, 1429773, 1795266, 1792581, 1663802, 1663818, 1830580, 1762713, 1659351, 1569376, 1659352, 1602906, 1794994, 4381411, 1742737, 1698585, 2188291, 1855444, 1527646, 1695496, 1796095, 1473449, 1667922, 2156644, 1836227, 1811418, 1855443, 1532652, 1791194, 1687921, 1555470, 1613776, 1806648, 1827975, 1863455, 1823071, 1767039, 1833132, 1845778, 1799675, 1830017, 1845568, 1742634, 1795264, 1761402, 1849445, 1821573, 1516744, 1857737, 1773716, 1729235, 2903709, 4377426, 3866804, 1273804, 1404953, 1337370, 4014278, 1611237, 1835841, 1796418, 1668069, 1796494, 1762769, 2956216, 1705315, 3251915, 3337405, 1527532, 1317742, 1684859, 1638186, 1616555, 1326852, 1391427, 4241368, 3549545);
Date: 2025-01-26 17:21:54 Duration: 19ms
-
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 (4392104, 4356740, 4416932, 4512179, 4556925, 4545030, 4514014, 4416935, 4584132, 4504990, 4514008, 4587702, 4324306, 4442094, 4442096, 4587632, 4475527, 4618311, 4642190, 4442098, 4640220, 4600280, 4545604, 4585267, 4514071, 4471860, 4471857, 4479561, 4584029, 4584027, 4587629, 4514081, 4475485, 4495733, 4514082, 4585249, 4584032, 4514006, 4618285, 4618290, 4618314, 4584125, 4637661, 4618287, 4418216, 4514016, 4618288, 4618327, 4372640, 4616746, 4372638, 4442100, 4442034, 4475487, 4416924, 4416926, 4475486, 4545603, 4504993, 4545615, 4505001, 4513999, 4545032, 4545037, 4514063, 4616541, 4616540, 4471859, 4618322, 4616735, 4615361, 4584063, 4616748, 4587647, 4504985, 4617905, 4505004, 4618291, 4585272, 4637669, 4516610, 4504986, 4616742, 4583477, 4671075, 4641521, 4618289, 4544683, 4640225, 4618286, 4547234, 4640381, 4641519, 4615467, 4475526, 4545598, 4587697, 4584025, 4324607, 4514043, 4642186, 4514011, 4545035, 4616744, 3992016, 3759173, 4209756);
Date: 2025-01-26 14:51:10 Duration: 15ms
-
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 (4545890, 4730465, 4733856, 4672805, 4720083, 4727361, 4727754, 4729237, 4732468, 4733564, 4743308, 4753829, 4737554, 4749586, 4342725, 4752268, 4750573, 4736749, 4669009, 4730280, 4660305, 4570758, 4635854, 4607524, 4636818, 4747662, 4727856, 4723538, 4699162, 4719610, 4689038, 4671940, 4700923, 4724916, 4678652, 4602047, 4706424, 4721873, 4732593, 3979440, 4667002, 4703511, 4704714, 4714072, 4715040, 4727765, 4729117, 4729332, 4730275, 4730435, 4743693, 4744022, 4749546, 4438649, 4300216, 4330879, 4618775, 4619686, 4631117, 4661321, 4663957, 4692301, 4746274, 4735774, 4739988, 4718611, 4706390, 4683211, 4739820, 4711943, 4700321, 4503209, 4717839, 4746163, 4709942, 4699020, 4726404, 4698576, 4733874, 4704430, 4722547, 4686794, 4717818, 4742794, 4723742, 4699319, 4720340, 4743187, 4576633, 4649978, 4523494, 4553132, 4672658, 4700975, 4744143, 4540391, 4742810, 4732891, 4731769, 4699648, 4733011, 4697637, 4749232, 4730577, 4752684, 4581406, 4736834, 4752668, 4702845, 4702952, 4748268, 4691136, 4664339, 4756312, 4715368, 4739321, 4677478, 4706606, 4729351, 4736207, 4681756, 4604200, 4727084, 4746289, 4702976, 4724704, 4702671, 4715129, 4731438, 4725046, 4692227, 4697590, 4693185, 4726605, 4727487, 4732437, 4736667, 4726882, 4742844, 4753823, 4751656, 4736842, 4753035, 4736825, 4686571, 4736697, 4724368, 4721713, 4750064, 4724046, 4727903, 4727952, 4742592, 4757805, 4731847, 4749073, 4730397, 4720789, 4662842, 4730506, 4722863, 4562841, 4550215, 4543571, 4722797, 4722861, 4532053, 4550800, 4582693, 4611984, 4614171, 4640945, 4662418, 4674140, 3996215, 4237270, 4263686, 4615283, 4628159, 4634376, 4646539, 4647179, 4683260, 4693802, 4599194);
Date: 2025-01-26 17:22:01 Duration: 13ms
16 167,074 14s59ms 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 #16
Day Hour Count Duration Avg duration Jan 26 00 2,525 191ms 0ms 01 2,554 192ms 0ms 02 1,526 116ms 0ms 03 2,286 189ms 0ms 04 1,228 95ms 0ms 05 695 45ms 0ms 06 1,570 112ms 0ms 07 1,124 74ms 0ms 08 3,161 224ms 0ms 09 12,249 1s79ms 0ms 10 17,969 1s874ms 0ms 11 18,186 1s555ms 0ms 12 17,058 1s322ms 0ms 13 15,152 1s111ms 0ms 14 14,026 1s25ms 0ms 15 13,184 1s65ms 0ms 16 11,166 1s34ms 0ms 17 10,326 934ms 0ms 18 6,932 587ms 0ms 19 5,209 384ms 0ms 20 5,202 479ms 0ms 21 2,303 231ms 0ms 22 1,443 133ms 0ms -
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-26 02:50:10 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-26 17:21:53 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-26 17:31:00 Duration: 0ms
17 138,451 8s244ms 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 #17
Day Hour Count Duration Avg duration Jan 26 00 760 40ms 0ms 01 971 51ms 0ms 02 669 34ms 0ms 03 650 34ms 0ms 04 282 14ms 0ms 05 235 12ms 0ms 06 543 29ms 0ms 07 357 18ms 0ms 08 2,926 157ms 0ms 09 7,068 420ms 0ms 10 8,292 541ms 0ms 11 17,420 1s104ms 0ms 12 18,754 1s186ms 0ms 13 15,536 888ms 0ms 14 10,635 600ms 0ms 15 9,963 593ms 0ms 16 10,945 640ms 0ms 17 11,321 638ms 0ms 18 8,400 535ms 0ms 19 4,386 238ms 0ms 20 3,991 232ms 0ms 21 2,456 134ms 0ms 22 1,891 95ms 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 (96);
Date: 2025-01-26 17:51:26 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 (83);
Date: 2025-01-26 21:38:55 Duration: 0ms
-
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);
Date: 2025-01-26 14:06:10 Duration: 0ms
18 138,425 1h50m7s 35ms 328ms 47ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 26 00 2,970 2m13s 45ms 01 4,058 3m5s 45ms 02 2,724 2m3s 45ms 03 4,447 3m24s 45ms 04 1,378 1m2s 45ms 05 853 37s804ms 44ms 06 1,204 52s906ms 43ms 07 1,264 55s652ms 44ms 08 2,189 1m38s 44ms 09 9,587 7m32s 47ms 10 13,755 11m41s 51ms 11 13,792 11m24s 49ms 12 14,480 12m6s 50ms 13 8,092 6m22s 47ms 14 7,508 5m49s 46ms 15 8,087 6m22s 47ms 16 8,508 6m47s 47ms 17 7,963 6m5s 45ms 18 5,657 4m41s 49ms 19 5,369 4m9s 46ms 20 7,501 5m50s 46ms 21 3,854 2m55s 45ms 22 3,185 2m21s 44ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4775488, 4774032, 4767954)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:32:22 Duration: 328ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4785067, 4733784, 4619705)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:33:52 Duration: 315ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4662697)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:35:41 Duration: 272ms
19 136,796 8h11m8s 158ms 1s548ms 215ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 26 00 1,293 4m13s 195ms 01 2,223 7m31s 203ms 02 1,784 5m53s 198ms 03 3,487 11m38s 200ms 04 2,203 7m11s 195ms 05 745 2m25s 195ms 06 1,975 6m26s 195ms 07 974 3m9s 194ms 08 2,818 9m21s 199ms 09 6,517 23m13s 213ms 10 9,242 35m32s 230ms 11 5,755 21m28s 223ms 12 6,090 22m54s 225ms 13 5,629 19m47s 210ms 14 5,323 18m38s 210ms 15 5,851 20m53s 214ms 16 8,564 30m42s 215ms 17 2,532 8m30s 201ms 18 27,217 1h47m16s 236ms 19 3,158 10m52s 206ms 20 21,753 1h15m55s 209ms 21 9,677 31m1s 192ms 22 1,986 6m28s 195ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9997843')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:37 Duration: 1s548ms
-
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" = '4228')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:36 Duration: 1s452ms
-
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" = '100704')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:18 Duration: 1s400ms
20 132,292 43s30ms 0ms 4ms 0ms select "price_list".id from "price_list" where (("price_list"."from_office_id" = ?) and ("price_list"."to_office_id" = ?)) order by "price_list"."id";Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 5,405 1s799ms 0ms 01 7,729 2s556ms 0ms 02 6,160 1s957ms 0ms 03 7,492 2s526ms 0ms 04 3,931 1s432ms 0ms 05 1,689 657ms 0ms 06 4,043 1s228ms 0ms 07 2,856 939ms 0ms 08 566 244ms 0ms 09 1,658 682ms 0ms 10 2,879 1s354ms 0ms 11 1,879 869ms 0ms 12 1,256 598ms 0ms 13 1,375 575ms 0ms 14 1,939 672ms 0ms 15 3,941 1s244ms 0ms 16 7,969 2s482ms 0ms 17 12,685 3s851ms 0ms 18 9,245 3s277ms 0ms 19 14,133 4s237ms 0ms 20 17,510 5s273ms 0ms 21 9,444 2s748ms 0ms 22 6,508 1s819ms 0ms -
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 17) AND ("price_list"."to_office_id" = 7)) ORDER BY "price_list"."id";
Date: 2025-01-26 03:56:05 Duration: 4ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 5) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";
Date: 2025-01-26 11:11:43 Duration: 2ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 22) AND ("price_list"."to_office_id" = 19)) ORDER BY "price_list"."id";
Date: 2025-01-26 17:22:24 Duration: 1ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 13h54m9s 13h54m9s 13h54m9s 1 13h54m9s select "shipping_policy".id from "shipping_policy" left join "urgent_office" AS "shipping_policy__from_office" on ("shipping_policy"."from_office" = "shipping_policy__from_office"."id") where ((("shipping_policy"."active" = true) and (("shipping_policy"."state" != ?) or "shipping_policy"."state" is null)) and (("shipping_policy"."policy_id" in ( select "policy_number".id from "policy_number" where (("policy_number"."name"::text not ilike ?) or "policy_number"."name" is null))) or "shipping_policy"."policy_id" is null)) 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"."collection_amount_sender" asc, "shipping_policy__from_office"."new_code" asc, "shipping_policy"."total_shipping_price" asc, "shipping_policy"."total_amount_cash_lines" asc limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 26 09 1 13h54m9s 13h54m9s -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "urgent_office" AS "shipping_policy__from_office" ON ("shipping_policy"."from_office" = "shipping_policy__from_office"."id") WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."policy_id" in ( SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."name"::text not ilike '%9842912%') OR "policy_number"."name" IS NULL))) OR "shipping_policy"."policy_id" IS NULL)) 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"."collection_amount_sender" ASC, "shipping_policy__from_office"."new_code" ASC, "shipping_policy"."total_shipping_price" ASC, "shipping_policy"."total_amount_cash_lines" ASC LIMIT 100;
Date: 2025-01-26 09:23:07 Duration: 13h54m9s
2 0ms 12m42s 29s148ms 291 2h21m22s update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 26 00 5 1ms 0ms 01 5 1ms 0ms 02 3 0ms 0ms 03 4 0ms 0ms 04 1 0ms 0ms 05 1 0ms 0ms 06 1 0ms 0ms 07 1 0ms 0ms 08 13 2ms 0ms 09 28 6ms 0ms 10 30 7ms 0ms 11 26 27ms 1ms 12 35 1h45m5s 3m 13 31 25m43s 49s788ms 14 30 18ms 0ms 15 16 11ms 0ms 16 13 10ms 0ms 17 18 23ms 1ms 18 9 10m33s 1m10s 19 4 2ms 0ms 20 3 3ms 1ms 21 8 4ms 0ms 22 6 8ms 1ms -
UPDATE "res_users" SET "exp_date" = '2025-01-26 11:48:38.578935', "last_update" = '2025-01-26 11:03:38.578968', "sid" = '7ba19d50711fb32486d349a84abc04535b2dc548', "write_date" = '2025-01-26 11:03:38.112147', "write_uid" = 1 WHERE id IN (826);
Date: 2025-01-26 12:16:20 Duration: 12m42s
-
UPDATE "res_users" SET "exp_date" = '2025-01-26 11:49:05.800113', "last_update" = '2025-01-26 11:04:05.800142', "sid" = '0a4a2a1c8e67d6d6f727741bd720c3039903df0f', "write_date" = '2025-01-26 11:04:05.408207', "write_uid" = 1 WHERE id IN (826);
Date: 2025-01-26 12:16:20 Duration: 12m15s
-
UPDATE "res_users" SET "exp_date" = '2025-01-26 12:59:36.178876', "last_update" = '2025-01-26 12:14:36.178899', "sid" = '44a30fc9a8748cb00b04b484a35a0f215bf5084b', "write_date" = '2025-01-26 12:14:35.805323', "write_uid" = 1 WHERE id IN (947);
Date: 2025-01-26 13:26:20 Duration: 11m44s
3 28ms 4s451ms 2s896ms 266 12m50s select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 26 01 17 51s351ms 3s20ms 08 2 5s987ms 2s993ms 09 2 6s589ms 3s294ms 10 8 24s554ms 3s69ms 11 4 11s937ms 2s984ms 12 41 1m58s 2s895ms 13 14 37s232ms 2s659ms 14 17 47s750ms 2s808ms 15 12 39s882ms 3s323ms 16 18 1m1s 3s435ms 17 48 1m43s 2s157ms 18 37 2m6s 3s408ms 19 23 1m11s 3s103ms 20 8 19s76ms 2s384ms 21 15 44s598ms 2s973ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))))) 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 (77)))))) 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 (77)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (77))))))))) 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 (77)))))))) AND ("policy_number"."name"::text ilike '%32142%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 18:36:42 Duration: 4s451ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))) 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 (22)))))) 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 (22)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (22))))))))) 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 (22)))))))) AND ("policy_number"."name"::text ilike '%9874013%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 18:31:49 Duration: 4s344ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))))) 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 (85)))))) 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 (85)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))))))) 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 (85)))))))) AND ("policy_number"."name"::text ilike '%9985%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-26 14:06:11 Duration: 4s169ms
4 0ms 59m59s 2s591ms 62,038 1d20h39m51s update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 26 00 893 219ms 0ms 01 950 241ms 0ms 02 723 179ms 0ms 03 1,175 309ms 0ms 04 784 217ms 0ms 05 244 57ms 0ms 06 473 107ms 0ms 07 411 96ms 0ms 08 1,256 1s490ms 1ms 09 4,223 981ms 0ms 10 6,597 1s688ms 0ms 11 6,574 8h36m25s 4s713ms 12 6,301 3h21m59s 1s923ms 13 5,446 5h18m58s 3s514ms 14 5,334 7h3m9s 4s759ms 15 4,634 1s77ms 0ms 16 4,195 5h48m4s 4s978ms 17 3,675 2h21m37s 2s312ms 18 2,677 2h45m54s 3s718ms 19 2,006 1h1m58s 1s853ms 20 1,803 16m47s 558ms 21 1,083 5h28m17s 18s187ms 22 581 2h36m32s 16s166ms -
update res_users set sid = '0ff61103934c706f8a00df0ae45720f159a47e16', last_update = '2025-01-26 17:33:03.971255', exp_date = '2025-01-26 18:18:03.971261', logged_in = 'TRUE' where id = 1037;
Date: 2025-01-26 19:33:03 Duration: 59m59s
-
update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350440', exp_date = '2025-01-26 10:02:11.350443', logged_in = 'TRUE' where id = 843;
Date: 2025-01-26 11:03:20 Duration: 46m9s
-
update res_users set sid = 'f96e945ce68ad098216d182c099af0f75ea90001', last_update = '2025-01-26 09:17:11.350385', exp_date = '2025-01-26 10:02:11.350388', logged_in = 'TRUE' where id = 843;
Date: 2025-01-26 11:03:20 Duration: 46m9s
5 212ms 1s843ms 923ms 11,211 2h52m35s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 26 00 544 7m57s 877ms 01 790 12m6s 919ms 02 12 10s656ms 888ms 03 502 7m42s 922ms 05 157 2m19s 890ms 07 5 4s401ms 880ms 08 6 5s341ms 890ms 09 12 11s176ms 931ms 10 9 9s154ms 1s17ms 11 37 39s776ms 1s75ms 12 54 54s523ms 1s9ms 13 99 1m39s 1s7ms 14 104 1m41s 978ms 15 474 7m33s 956ms 16 442 7m6s 964ms 17 432 6m45s 938ms 18 1,007 16m37s 990ms 19 2,236 34m23s 922ms 20 3,123 47m3s 904ms 21 812 11m50s 874ms 22 354 5m33s 943ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '85677')) 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 (8))))))) 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 (8)))))) 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 (8)))))) 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 (8))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:36:43 Duration: 1s843ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '17347')) 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 (22))))))) 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 (22)))))) 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 (22)))))) 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 (22))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:32:16 Duration: 1s819ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '94803')) 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 (22))))))) 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 (22)))))) 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 (22)))))) 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 (22))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:32:45 Duration: 1s799ms
6 500ms 4s321ms 629ms 43,276 7h34m2s select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 26 00 150 1m36s 645ms 01 221 2m26s 665ms 02 170 1m54s 673ms 03 209 2m22s 680ms 04 150 1m37s 649ms 05 265 2m34s 582ms 06 205 1m59s 581ms 07 184 1m51s 605ms 08 707 6m57s 591ms 09 3,155 32m39s 621ms 10 4,793 53m38s 671ms 11 4,660 51m12s 659ms 12 4,947 54m39s 662ms 13 3,549 36m22s 614ms 14 3,052 30m55s 608ms 15 4,422 45m17s 614ms 16 3,684 38m14s 622ms 17 2,459 24m6s 588ms 18 2,235 23m46s 638ms 19 1,479 14m29s 588ms 20 1,596 15m42s 590ms 21 599 5m55s 593ms 22 385 3m41s 575ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4742441, 4733071, 4711819, 4710012, 4694417, 4689452, 4688097, 4680256, 4671369)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:33:05 Duration: 4s321ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4770633)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:11 Duration: 4s148ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4788476)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:21 Duration: 4s44ms
7 490ms 5s210ms 610ms 248,053 1d18h4m20s select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 26 00 7,015 1h8m 581ms 01 9,380 1h32m33s 592ms 02 7,082 1h9m22s 587ms 03 10,049 1h39m55s 596ms 04 5,809 55m50s 576ms 05 3,070 28m57s 565ms 06 3,325 32m24s 584ms 07 3,480 33m10s 571ms 08 3,341 31m45s 570ms 09 12,557 2h7m29s 609ms 10 19,533 3h34m19s 658ms 11 17,969 3h10m54s 637ms 12 17,613 3h10m3s 647ms 13 10,590 1h46m57s 606ms 14 9,303 1h32m32s 596ms 15 11,452 1h57m3s 613ms 16 11,871 2h4m26s 628ms 17 11,856 1h58m1s 597ms 18 15,255 2h45m24s 650ms 19 19,138 3h10m41s 597ms 20 13,457 2h16m33s 608ms 21 18,014 2h52m10s 573ms 22 6,894 1h5m40s 571ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797245)) AND (("shipping_track"."id" not in (39712235, 39712235)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:39 Duration: 5s210ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797170)) AND (("shipping_track"."id" not in (39711810, 39711810)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:34:30 Duration: 5s12ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4797270)) AND (("shipping_track"."id" not in (39712349, 39712349)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-26 18:35:59 Duration: 4s885ms
8 364ms 733ms 480ms 1,851 14m50s select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 26 00 218 1m31s 420ms 08 351 2m30s 428ms 09 319 2m39s 501ms 10 474 4m9s 525ms 11 307 2m33s 498ms 12 6 3s21ms 503ms 13 31 13s946ms 449ms 14 78 37s337ms 478ms 15 63 29s745ms 472ms 16 4 1s928ms 482ms -
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" = '9847762')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 10:42:58 Duration: 733ms
-
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" = '9847938')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 10:42:19 Duration: 719ms
-
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" = '478934')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-01-26 11:41:12 Duration: 705ms
9 190ms 638ms 293ms 24,298 1h59m3s select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 26 08 1,101 5m4s 276ms 09 2,185 10m32s 289ms 10 3,356 17m31s 313ms 11 1,825 9m18s 306ms 12 2,638 13m14s 301ms 13 3,144 14m52s 283ms 14 2,828 13m36s 288ms 15 2,901 13m46s 284ms 16 3,239 15m47s 292ms 17 1,081 5m18s 295ms -
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" = '9909839')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:43 Duration: 638ms
-
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" = '9909600')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:39 Duration: 594ms
-
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" = '9909563')))) ORDER BY "collection_policy"."id";
Date: 2025-01-26 11:11:35 Duration: 588ms
10 206ms 1s938ms 272ms 17,471 1h19m15s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 26 00 418 1m52s 269ms 01 659 3m1s 274ms 02 1,133 5m1s 266ms 03 827 3m44s 271ms 04 491 2m6s 258ms 06 824 3m34s 259ms 07 476 2m5s 262ms 08 23 5s850ms 254ms 09 212 1m1s 289ms 10 308 1m36s 311ms 11 118 34s912ms 295ms 12 53 17s76ms 322ms 13 87 24s531ms 281ms 14 279 1m19s 285ms 15 485 2m17s 282ms 16 1,565 7m23s 283ms 17 2,769 12m10s 263ms 18 1,307 6m58s 320ms 19 1,329 5m49s 262ms 20 1,261 5m41s 271ms 21 1,576 6m53s 262ms 22 1,271 5m16s 249ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '96383')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:35:52 Duration: 1s938ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9972793')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:36:07 Duration: 1s875ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9948172')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-26 18:35:47 Duration: 1s846ms
11 218ms 819ms 271ms 2,726 12m20s select name from shipping_policy order by create_date desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 26 00 120 31s699ms 264ms 01 120 32s195ms 268ms 02 120 31s569ms 263ms 03 120 32s345ms 269ms 04 120 31s423ms 261ms 05 120 30s954ms 257ms 06 120 31s169ms 259ms 07 120 31s26ms 258ms 08 120 31s426ms 261ms 09 120 34s64ms 283ms 10 120 36s427ms 303ms 11 120 35s662ms 297ms 12 120 35s806ms 298ms 13 120 33s580ms 279ms 14 120 33s585ms 279ms 15 120 34s128ms 284ms 16 120 34s75ms 283ms 17 116 30s445ms 262ms 18 120 33s47ms 275ms 19 120 31s178ms 259ms 20 120 31s715ms 264ms 21 120 30s715ms 255ms 22 90 21s962ms 244ms -
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:34:03 Duration: 819ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:34:02 Duration: 709ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2025-01-26 18:33:03 Duration: 432ms
12 92ms 940ms 244ms 56,650 3h50m55s select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 26 00 1,913 6m2s 189ms 01 2,880 10m23s 216ms 02 2,260 8m47s 233ms 03 2,636 10m20s 235ms 04 956 4m9s 261ms 05 302 1m17s 257ms 06 1,626 6m41s 247ms 07 950 3m38s 229ms 08 50 12s678ms 253ms 09 436 1m42s 234ms 10 566 2m38s 279ms 11 300 1m13s 246ms 12 212 1m 286ms 13 360 1m28s 246ms 14 758 3m8s 249ms 15 1,880 8m10s 261ms 16 3,935 17m13s 262ms 17 6,321 26m34s 252ms 18 4,598 20m52s 272ms 19 7,068 29m12s 247ms 20 8,706 34m9s 235ms 21 4,719 18m36s 236ms 22 3,218 13m17s 247ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:35:02 Duration: 940ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شيماء')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:35:02 Duration: 938ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-26 18:50:55 Duration: 927ms
13 158ms 1s548ms 215ms 136,796 8h11m8s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 26 00 1,293 4m13s 195ms 01 2,223 7m31s 203ms 02 1,784 5m53s 198ms 03 3,487 11m38s 200ms 04 2,203 7m11s 195ms 05 745 2m25s 195ms 06 1,975 6m26s 195ms 07 974 3m9s 194ms 08 2,818 9m21s 199ms 09 6,517 23m13s 213ms 10 9,242 35m32s 230ms 11 5,755 21m28s 223ms 12 6,090 22m54s 225ms 13 5,629 19m47s 210ms 14 5,323 18m38s 210ms 15 5,851 20m53s 214ms 16 8,564 30m42s 215ms 17 2,532 8m30s 201ms 18 27,217 1h47m16s 236ms 19 3,158 10m52s 206ms 20 21,753 1h15m55s 209ms 21 9,677 31m1s 192ms 22 1,986 6m28s 195ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9997843')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:37 Duration: 1s548ms
-
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" = '4228')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:36 Duration: 1s452ms
-
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" = '100704')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:34:18 Duration: 1s400ms
14 162ms 396ms 212ms 12,488 44m13s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 26 00 20 4s77ms 203ms 01 80 16s205ms 202ms 02 12 2s518ms 209ms 03 103 20s490ms 198ms 05 136 26s592ms 195ms 06 1,094 3m34s 196ms 07 918 2m59s 195ms 08 632 2m4s 197ms 09 2,044 7m14s 212ms 10 1,858 6m53s 222ms 11 1,812 6m41s 221ms 12 1,360 5m11s 229ms 13 898 3m9s 210ms 14 605 2m5s 207ms 15 227 48s560ms 213ms 16 191 41s219ms 215ms 17 130 25s930ms 199ms 18 97 21s983ms 226ms 19 154 29s6ms 188ms 20 55 10s466ms 190ms 21 56 10s565ms 188ms 22 6 1s90ms 181ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '74141')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:49 Duration: 396ms
-
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" = '74191')) 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)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 18:35:50 Duration: 359ms
-
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" = '77176')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 10:07:41 Duration: 347ms
15 169ms 281ms 199ms 9,794 32m34s 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 Jan 26 00 1,179 3m52s 197ms 01 1,971 6m41s 203ms 02 1,772 5m51s 198ms 03 2,286 7m40s 201ms 04 2,149 7m1s 196ms 05 437 1m25s 196ms -
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '119712')) 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-01-26 03:47:23 Duration: 281ms
-
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" = '81711')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 01:15:15 Duration: 261ms
-
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" = '153261')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-26 01:15:15 Duration: 261ms
16 119ms 279ms 151ms 5,636 14m11s select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 26 00 10 1s422ms 142ms 01 11 1s475ms 134ms 03 73 11s188ms 153ms 05 5 660ms 132ms 06 5 647ms 129ms 08 140 19s115ms 136ms 09 447 1m5s 146ms 10 1,110 2m57s 159ms 11 1,062 2m43s 154ms 12 1,166 3m1s 156ms 13 377 53s928ms 143ms 14 287 40s420ms 140ms 15 149 21s982ms 147ms 16 309 45s298ms 146ms 17 189 26s436ms 139ms 18 87 12s490ms 143ms 19 39 5s298ms 135ms 20 96 13s65ms 136ms 21 34 4s703ms 138ms 22 40 5s290ms 132ms -
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-01-26 10:42:18 Duration: 279ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 64)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-26 10:40:07 Duration: 278ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 78)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-26 10:44:27 Duration: 272ms
17 95ms 724ms 120ms 19,553 39m17s select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 26 00 289 31s77ms 107ms 01 71 7s817ms 110ms 05 56 6s453ms 115ms 08 135 15s345ms 113ms 09 1,299 2m36s 120ms 10 2,060 4m16s 124ms 11 1,421 2m58s 125ms 12 1,794 3m49s 127ms 13 2,108 4m7s 117ms 14 2,474 4m44s 115ms 15 2,201 4m25s 120ms 16 1,551 3m6s 120ms 17 1,853 3m32s 114ms 18 951 2m4s 130ms 19 921 1m50s 119ms 20 215 25s842ms 120ms 21 93 11s129ms 119ms 22 61 7s498ms 122ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8003794)) AND (("cash_track"."id" not in (7105518, 7109072, 7132040, 7384506, 7388173, 7388173)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:34:43 Duration: 724ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8039222)) AND (("cash_track"."id" not in (7364360, 7373716, 7387873, 7388145, 7388145)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:33:49 Duration: 704ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8028961)) AND (("cash_track"."id" not in (7300721, 7304686, 7305978, 7384443, 7388161, 7388161)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-26 18:34:40 Duration: 613ms
18 44ms 343ms 57ms 38,724 37m18s select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 26 08 1,377 1m13s 53ms 09 4,693 4m24s 56ms 10 2,730 2m48s 61ms 11 4,092 4m4s 59ms 12 5,542 5m36s 60ms 13 3,621 3m26s 57ms 14 4,275 3m55s 55ms 15 4,394 4m11s 57ms 16 5,549 5m19s 57ms 17 2,238 2m3s 55ms 18 84 6s564ms 78ms 19 36 1s951ms 54ms 20 61 3s490ms 57ms 21 10 543ms 54ms 22 22 1s236ms 56ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4766555) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:34:23 Duration: 343ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4761346) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:33:59 Duration: 334ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4763380) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:34:52 Duration: 330ms
19 39ms 102ms 52ms 18,729 16m15s select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 26 08 987 47s763ms 48ms 09 2,558 2m10s 50ms 10 1,280 1m10s 54ms 11 2,079 1m50s 52ms 12 2,238 2m5s 55ms 13 1,779 1m31s 51ms 14 1,819 1m32s 50ms 15 2,402 2m6s 52ms 16 2,462 2m5s 51ms 17 1,121 54s932ms 49ms 18 4 325ms 81ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4667229) ORDER BY "collection_policy"."id";
Date: 2025-01-26 12:23:49 Duration: 102ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4543211) ORDER BY "collection_policy"."id";
Date: 2025-01-26 18:33:24 Duration: 101ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4628163) ORDER BY "collection_policy"."id";
Date: 2025-01-26 14:05:47 Duration: 91ms
20 35ms 328ms 47ms 138,425 1h50m7s select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 26 00 2,970 2m13s 45ms 01 4,058 3m5s 45ms 02 2,724 2m3s 45ms 03 4,447 3m24s 45ms 04 1,378 1m2s 45ms 05 853 37s804ms 44ms 06 1,204 52s906ms 43ms 07 1,264 55s652ms 44ms 08 2,189 1m38s 44ms 09 9,587 7m32s 47ms 10 13,755 11m41s 51ms 11 13,792 11m24s 49ms 12 14,480 12m6s 50ms 13 8,092 6m22s 47ms 14 7,508 5m49s 46ms 15 8,087 6m22s 47ms 16 8,508 6m47s 47ms 17 7,963 6m5s 45ms 18 5,657 4m41s 49ms 19 5,369 4m9s 46ms 20 7,501 5m50s 46ms 21 3,854 2m55s 45ms 22 3,185 2m21s 44ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4775488, 4774032, 4767954)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:32:22 Duration: 328ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4785067, 4733784, 4619705)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:33:52 Duration: 315ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4662697)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-26 18:35:41 Duration: 272ms
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
- 17,263,418 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 507 FATAL entries
- 3130 ERROR entries
- 0 WARNING entries
- 540 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,658 Max number of times the same event was reported
- 4,177 Total events found
Rank Times reported Error 1 1,658 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 26 00 4 01 16 02 10 03 28 04 17 05 1 06 7 07 12 08 43 09 75 10 147 11 232 12 217 13 135 14 79 15 173 16 80 17 86 18 87 19 72 20 100 21 28 22 9 - 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 res_users set sid = '2315ec428e6ee1fd75e62e04ed39f77cc65321a3', last_update = '2025-01-25 23:00:50.315578',exp_date = '2025-01-25 23:45:50.315582', logged_in = 'TRUE' where id = 956
Date: 2025-01-26 00:00:51
Statement: update res_users set sid = '35e2d21be25ea06559f76ad6de824d8400799927', last_update = '2025-01-25 23:03:42.969118',exp_date = '2025-01-25 23:48:42.969122', logged_in = 'TRUE' where id = 1038
Date: 2025-01-26 00:03:42
Statement: update res_users set sid = '2f2d73e521318f751e10af03a3714ebde4fee551', last_update = '2025-01-25 23:17:29.125105',exp_date = '2025-01-26 00:02:29.125109', logged_in = 'TRUE' where id = 1247
Date: 2025-01-26 00:17:29
2 1,455 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 26 00 3 01 13 02 8 03 20 04 15 05 1 06 6 07 10 08 40 09 67 10 123 11 216 12 188 13 121 14 70 15 163 16 67 17 79 18 66 19 60 20 92 21 23 22 4 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "shipping_policy".id FROM "shipping_policy" WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."out_date" = '2025-01-25') AND (("shipping_policy"."last_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%دمنهور%'))) AND (("shipping_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%دمنهور%'))) AND ((("shipping_policy"."state" = 'in_way_to_client') OR ("shipping_policy"."state" = 'client_receive')) AND ("shipping_policy"."delegate_id" in (SELECT "res_partner".id FROM "res_partner" WHERE ((((("res_partner"."display_name"::text ilike '%اسلام%') OR ("res_partner"."email"::text ilike '%اسلام%')) OR ("res_partner"."ref"::text ilike '%اسلام%')) OR ("res_partner"."vat"::text ilike '%اسلام%')) OR ("res_partner"."company_registry"::text ilike '%اسلام%')) 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 ))))))))) 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 (28)))) OR ("shipping_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28))))) OR ("shipping_policy"."last_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28))))) 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 LIMIT 100
Date: 2025-01-26 00:00:51
Statement: SELECT "res_partner".id FROM "res_partner" WHERE "res_partner".id IN (2)
Date: 2025-01-26 00:03:42
Statement: SELECT "res_users".id FROM "res_users" WHERE "res_users".id IN (1247)
Date: 2025-01-26 00:17:29
3 337 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 26 09 1 11 69 12 45 13 47 14 26 16 43 17 25 18 28 21 30 22 23 4 337 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 26 09 1 11 69 12 45 13 47 14 26 16 43 17 25 18 28 21 30 22 23 5 135 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 26 11 28 12 32 13 21 14 12 16 20 17 5 18 5 19 1 21 2 22 9 6 90 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 26 17 90 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-01-26 17:20:02
Context: while updating tuple (32,15) in relation "res_users"
Statement: UPDATE "res_users" SET "exp_date" = '2025-01-26 17:00:19.468182', "last_update" = '2025-01-26 16:15:19.468213', "sid" = '077f73a000efc2920689cb238c26d0de63ca6af0', "write_date" = '2025-01-26 16:15:19.103304', "write_uid" = 1 WHERE id IN (1031)Date: 2025-01-26 17:20:02
Statement: update res_users set sid = '45b8ec46a3be0971aaa99d4f9a2824e72cec25c4', last_update = '2025-01-26 16:15:02.468862',exp_date = '2025-01-26 17:00:02.468867', logged_in = 'TRUE' where id = 1031
Date: 2025-01-26 17:20:02
7 67 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 26 11 17 12 11 13 11 14 4 16 14 17 3 18 2 21 1 22 4 8 22 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #8
Day Hour Count Jan 26 17 22 9 21 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jan 26 13 7 17 14 10 16 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #10
Day Hour Count Jan 26 13 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-01-26 13:37:22
11 12 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #11
Day Hour Count Jan 26 17 12 - FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-01-26 17:20:02
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4793623)) AND (("shipping_track"."id" not in (39695001, 39695001)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-01-26 17:20:02
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."policy_name" = '9612219') OR (("cash_policy"."policy_name" = '9791560') OR (("cash_policy"."policy_name" = '9791564') OR (("cash_policy"."policy_name" = '9971563') OR (("cash_policy"."policy_name" = '9975164') OR (("cash_policy"."policy_name" = '9971564') OR (("cash_policy"."policy_name" = '997565') OR (("cash_policy"."policy_name" = '9971565') OR (("cash_policy"."policy_name" = '9971567') OR (("cash_policy"."policy_name" = '9860484') OR (("cash_policy"."policy_name" = '9914924') OR (("cash_policy"."policy_name" = '9770812') OR (("cash_policy"."policy_name" = '9770826') OR (("cash_policy"."policy_name" = '9770824') OR (("cash_policy"."policy_name" = '9770827') OR (("cash_policy"."policy_name" = '9770809') OR (("cash_policy"."policy_name" = '9971569') OR (("cash_policy"."policy_name" = '9757310') OR (("cash_policy"."policy_name" = '975480') OR (("cash_policy"."policy_name" = '9757480') OR (("cash_policy"."policy_name" = '9757464') OR (("cash_policy"."policy_name" = '9757485') OR (("cash_policy"."policy_name" = '9757487') OR (("cash_policy"."policy_name" = '9757486') OR (("cash_policy"."policy_name" = '9757491') OR (("cash_policy"."policy_name" = '9757492') OR (("cash_policy"."policy_name" = '9757495') OR (("cash_policy"."policy_name" = '9757496') OR (("cash_policy"."policy_name" = '9940848') OR (("cash_policy"."policy_name" = '9483896') OR (("cash_policy"."policy_name" = '9986663') OR (("cash_policy"."policy_name" = '9986665') OR (("cash_policy"."policy_name" = '9986682') OR (("cash_policy"."policy_name" = '9622666') OR (("cash_policy"."policy_name" = '9622685') OR (("cash_policy"."policy_name" = '9622389') OR (("cash_policy"."policy_name" = '9622386') OR (("cash_policy"."policy_name" = '9622687') OR (("cash_policy"."policy_name" = '9986692') OR (("cash_policy"."policy_name" = '9986696') OR (("cash_policy"."policy_name" = '9757621') OR (("cash_policy"."policy_name" = '35308') OR (("cash_policy"."policy_name" = '9798897') OR (("cash_policy"."policy_name" = '9915167') OR (("cash_policy"."policy_name" = '87080') OR (("cash_policy"."policy_name" = '35873') OR (("cash_policy"."policy_name" = '8714500') OR (("cash_policy"."policy_name" = '9247644') OR (("cash_policy"."policy_name" = '9247645') OR (("cash_policy"."policy_name" = '9247647') OR (("cash_policy"."policy_name" = '9021269') OR (("cash_policy"."policy_name" = '35880') OR (("cash_policy"."policy_name" = '35882') OR (("cash_policy"."policy_name" = '35881') OR (("cash_policy"."policy_name" = '87742') OR ("cash_policy"."policy_name" = '87739')))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND (((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."total_amount_cash_lines_at_receive" ASC LIMIT 200
Date: 2025-01-26 17:20:02
12 8 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #12
Day Hour Count Jan 26 09 1 10 1 13 1 14 2 16 3 - 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 (5491810, null, 827, 827, null, ik[, null, null, t, 2025-01-26 08:33:52.033172, 2025-01-26 08:33:52.033172, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-01-26 08:33:52.033172', 827, 'ik[', '2025-01-26 08:33:52.033172', 827) RETURNING "id"Date: 2025-01-26 09:33:52
Detail: Failing row contains (5491866, null, 827, 827, null, عبدالرحمن, null, null, t, 2025-01-26 09:42:55.976087, 2025-01-26 09:42:55.976087, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-01-26 09:42:55.976087', 827, 'عبدالرحمن', '2025-01-26 09:42:55.976087', 827) RETURNING "id"Date: 2025-01-26 10:42:55
Detail: Failing row contains (4463, 65, 866, 866, مدينة نصر, null, 2025-01-26 12:37:09.614561, 2025-01-26 12:37:09.614561).
Statement: INSERT INTO "res_country_state" ("country_id", "create_date", "create_uid", "name", "write_date", "write_uid") VALUES (65, '2025-01-26 12:37:09.614561', 866, 'مدينة نصر', '2025-01-26 12:37:09.614561', 866) RETURNING "id"Date: 2025-01-26 13:37:09
13 4 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Jan 26 10 1 12 1 16 2 - ERROR: syntax error at or near ")" at character 300
- ERROR: syntax error at or near ")" at character 300
- ERROR: syntax error at or near ")" at character 300
Statement: select sum(total_shipping_price-collection_amount_receive-collection_amount_sender) FROM shipping_policy where collection_amount_sender+collection_amount_receive<total_shipping_price and id in (shipping.policy(4789001,), 0)
Date: 2025-01-26 10:58:16
Statement: select sum(total_shipping_price-collection_amount_receive-collection_amount_sender) FROM shipping_policy where collection_amount_sender+collection_amount_receive<total_shipping_price and id in (shipping.policy(4757190,), 0)
Date: 2025-01-26 12:31:07
Statement: select sum(total_shipping_price-collection_amount_receive-collection_amount_sender) FROM shipping_policy where collection_amount_sender+collection_amount_receive<total_shipping_price and id in (shipping.policy(4083306,), 0)
Date: 2025-01-26 16:52:45
14 2 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #14
Day Hour Count Jan 26 10 1 11 1 - ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 331463 waits for ShareLock on transaction 7388194; blocked by process 726178. Process 726178 waits for ShareLock on transaction 7388051; blocked by process 331463. Process 331463: update shipping_policy set count_search=2 where id=4783292 Process 726178: UPDATE "shipping_policy" SET "delegate_button" = true, "delegate_id" = 8005431, "driver_id" = 8006985, "last_car" = 224, "out_date" = '2025-01-26', "state" = 'in_way_to_client', "state_id" = 1969, "write_date" = '2025-01-26 09:07:28.605845', "write_uid" = 914 WHERE id IN (4780263, 4779715, 4777939, 4777712, 4777462, 4776171, 4775181, 4775073, 4774076, 4771537, 4771308, 4770343, 4769732, 4768405, 4768365, 4768331, 4768063, 4766539, 4766467, 4764823, 4763984, 4761675, 4761466, 4760887, 4759875)
Context: while updating tuple (5087,10) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=2 where id=4783292Date: 2025-01-26 10:08:10
Detail: Process 2049921 waits for ShareLock on transaction 7399695; blocked by process 2049931. Process 2049931 waits for ShareLock on transaction 7399689; blocked by process 2049921. Process 2049921: update shipping_policy set count_search=6 where id=4519595 Process 2049931: UPDATE "shipping_policy" SET "state_collection" = 'confirm', "write_date" = '2025-01-26 10:04:34.365705', "write_uid" = 1081 WHERE id IN (4528811, 4692843, 4627750, 4655886, 4714859, 4714842, 4708860, 4654204, 4658715, 4657520, 4698704, 4662954, 4693220, 4695352, 4690148, 4587684, 4699510, 4714800, 4712852, 4699677, 4701201, 4737389, 4701620, 4714868, 4703977, 4708967, 4716523, 4708481, 4703944, 4519595, 4691412, 4688071, 4671579, 4671613, 4646565, 4677422, 4671631, 4685365, 4660266, 4685366, 4692892, 4685104, 4711811, 4714833, 4682110, 4662009, 4682129, 4688763, 4699056, 4688870, 4682139, 4708993, 4608823, 4688122, 4708870, 4580784, 4693311, 4665319, 4689737)
Context: while updating tuple (103006,8) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=6 where id=4519595Date: 2025-01-26 11:04:49
15 2 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #15
Day Hour Count Jan 26 12 1 20 1 16 2 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #16
Day Hour Count Jan 26 17 2 - 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_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4793623)) AND (("shipping_track"."id" not in (39695001, 39695001)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-01-26 17:20:02
Context: parallel worker
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."policy_name" = '9612219') OR (("cash_policy"."policy_name" = '9791560') OR (("cash_policy"."policy_name" = '9791564') OR (("cash_policy"."policy_name" = '9971563') OR (("cash_policy"."policy_name" = '9975164') OR (("cash_policy"."policy_name" = '9971564') OR (("cash_policy"."policy_name" = '997565') OR (("cash_policy"."policy_name" = '9971565') OR (("cash_policy"."policy_name" = '9971567') OR (("cash_policy"."policy_name" = '9860484') OR (("cash_policy"."policy_name" = '9914924') OR (("cash_policy"."policy_name" = '9770812') OR (("cash_policy"."policy_name" = '9770826') OR (("cash_policy"."policy_name" = '9770824') OR (("cash_policy"."policy_name" = '9770827') OR (("cash_policy"."policy_name" = '9770809') OR (("cash_policy"."policy_name" = '9971569') OR (("cash_policy"."policy_name" = '9757310') OR (("cash_policy"."policy_name" = '975480') OR (("cash_policy"."policy_name" = '9757480') OR (("cash_policy"."policy_name" = '9757464') OR (("cash_policy"."policy_name" = '9757485') OR (("cash_policy"."policy_name" = '9757487') OR (("cash_policy"."policy_name" = '9757486') OR (("cash_policy"."policy_name" = '9757491') OR (("cash_policy"."policy_name" = '9757492') OR (("cash_policy"."policy_name" = '9757495') OR (("cash_policy"."policy_name" = '9757496') OR (("cash_policy"."policy_name" = '9940848') OR (("cash_policy"."policy_name" = '9483896') OR (("cash_policy"."policy_name" = '9986663') OR (("cash_policy"."policy_name" = '9986665') OR (("cash_policy"."policy_name" = '9986682') OR (("cash_policy"."policy_name" = '9622666') OR (("cash_policy"."policy_name" = '9622685') OR (("cash_policy"."policy_name" = '9622389') OR (("cash_policy"."policy_name" = '9622386') OR (("cash_policy"."policy_name" = '9622687') OR (("cash_policy"."policy_name" = '9986692') OR (("cash_policy"."policy_name" = '9986696') OR (("cash_policy"."policy_name" = '9757621') OR (("cash_policy"."policy_name" = '35308') OR (("cash_policy"."policy_name" = '9798897') OR (("cash_policy"."policy_name" = '9915167') OR (("cash_policy"."policy_name" = '87080') OR (("cash_policy"."policy_name" = '35873') OR (("cash_policy"."policy_name" = '8714500') OR (("cash_policy"."policy_name" = '9247644') OR (("cash_policy"."policy_name" = '9247645') OR (("cash_policy"."policy_name" = '9247647') OR (("cash_policy"."policy_name" = '9021269') OR (("cash_policy"."policy_name" = '35880') OR (("cash_policy"."policy_name" = '35882') OR (("cash_policy"."policy_name" = '35881') OR (("cash_policy"."policy_name" = '87742') OR ("cash_policy"."policy_name" = '87739')))))))))))))))))))))))))))))))))))))))))))))))))))))))))) AND (((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."total_amount_cash_lines_at_receive" ASC LIMIT 200Date: 2025-01-26 17:20:02
17 2 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #17
Day Hour Count Jan 26 12 1 20 1 18 2 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #18
Day Hour Count Jan 26 12 1 20 1 19 1 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #19
Day Hour Count Jan 26 21 1 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM "delegate_track" WHERE id IN (151732)
Date: 2025-01-26 21:08:07
20 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #20
Day Hour Count Jan 26 15 1 21 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #21
Day Hour Count Jan 26 22 1 22 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #22
Day Hour Count Jan 26 17 1 23 1 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #23
Day Hour Count Jan 26 17 1