pgBadger-
Global information
- Generated on Fri Mar 21 23:47:21 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 37,310,986 log entries in 2m20s
- Log start from 2025-03-20 23:00:09 to 2025-03-21 19:45:01
-
Overview
Global Stats
- 18,867 Number of unique normalized queries
- 15,836,983 Number of queries
- 9d2h34m28s Total query duration
- 2025-03-20 23:00:09 First query
- 2025-03-21 19:45:01 Last query
- 3,121 queries/s at 2025-03-21 14:03:17 Query peak
- 9d2h34m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 9d2h34m28s Execute total duration
- 4,438 Number of events
- 24 Number of unique normalized events
- 1,497 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
- 15,836,983 Average queries per session
- 9d2h34m28s 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
- 3,121 queries/s Query Peak
- 2025-03-21 14:03:17 Date
SELECT Traffic
Key values
- 2,175 queries/s Query Peak
- 2025-03-21 13:49:26 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,338 queries/s Query Peak
- 2025-03-21 00:15:32 Date
Queries duration
Key values
- 9d2h34m28s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 20 23 902,050 0ms 6m17s 46ms 17m23s 19m43s 22m30s Mar 21 00 745,581 0ms 4m16s 37ms 11m55s 13m31s 17m16s 01 439,463 0ms 7s14ms 28ms 5m37s 7m27s 8m48s 02 345,150 0ms 2s973ms 30ms 5m9s 6m 6m12s 03 273,628 0ms 2s30ms 39ms 5m7s 5m43s 6m39s 04 355,647 0ms 7s133ms 40ms 6m6s 7m6s 8m21s 05 394,738 0ms 2s988ms 45ms 7m32s 8m32s 8m54s 06 372,214 0ms 12m58s 69ms 14m21s 16m19s 19m39s 07 321,627 0ms 7s166ms 49ms 6m2s 7m16s 9m34s 08 495,036 0ms 10s864ms 40ms 9m27s 9m33s 10m32s 09 780,978 0ms 25s68ms 28ms 9m46s 12m19s 13m16s 10 986,388 0ms 23m50s 37ms 15m23s 19m13s 32m46s 11 868,243 0ms 7s981ms 34ms 14m12s 17m 23m46s 12 1,534,901 0ms 22s584ms 52ms 35m52s 39m26s 39m42s 13 1,614,937 0ms 9m1s 113ms 57m47s 1h26s 1h13m28s 14 1,667,095 0ms 3m36s 89ms 58m8s 1h1m8s 1h2m23s 15 1,274,028 0ms 1m8s 25ms 14m48s 22m23s 27m30s 16 758,274 0ms 50s63ms 13ms 5m 5m46s 8m56s 17 324,662 0ms 48s892ms 12ms 2m11s 2m41s 3m8s 18 733,420 0ms 48s513ms 21ms 8m45s 9m33s 10m8s 19 648,923 0ms 1m7s 38ms 12m12s 12m45s 14m48s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 20 23 513,292 0 78ms 14m6s 17m6s 20m33s Mar 21 00 440,104 0 61ms 10m10s 11m48s 12m59s 01 244,205 0 51ms 4m56s 5m35s 8m4s 02 194,194 0 54ms 4m4s 5m9s 6m9s 03 156,560 0 69ms 4m11s 5m6s 6m33s 04 195,456 0 73ms 5m6s 6m5s 7m11s 05 219,226 0 81ms 6m21s 7m31s 8m38s 06 204,200 0 93ms 6m40s 7m48s 10m46s 07 173,908 0 91ms 5m35s 6m1s 8m30s 08 285,998 0 70ms 7m49s 9m26s 9m39s 09 454,915 0 49ms 7m56s 9m45s 12m29s 10 558,160 0 64ms 13m7s 15m22s 21m9s 11 477,522 0 63ms 11m52s 14m10s 19m55s 12 873,380 0 91ms 30m44s 35m50s 39m30s 13 951,985 0 190ms 56m14s 57m44s 1h1m4s 14 1,053,898 0 140ms 54m10s 58m4s 1h1m18s 15 770,091 0 41ms 10m35s 14m46s 25m29s 16 442,742 0 23ms 3m52s 4m59s 5m45s 17 168,140 0 23ms 1m53s 2m11s 2m41s 18 420,509 0 37ms 6m43s 8m45s 9m57s 19 369,901 0 66ms 11m9s 12m11s 14m47s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 20 23 86,307 19,013 933 1 11ms 637ms 805ms 5m25s Mar 21 00 75,752 13,586 331 3 10ms 511ms 701ms 2m42s 01 31,504 6,093 262 0 0ms 196ms 219ms 417ms 02 26,489 4,477 84 0 0ms 215ms 338ms 524ms 03 27,827 5,572 79 0 0ms 200ms 239ms 345ms 04 34,026 7,202 79 0 0ms 220ms 263ms 346ms 05 38,603 7,468 77 0 0ms 249ms 301ms 428ms 06 42,159 8,059 79 0 134ms 401ms 4m6s 12m38s 07 32,828 7,544 87 0 0ms 205ms 254ms 326ms 08 39,547 8,538 167 0 0ms 263ms 296ms 392ms 09 43,731 10,831 483 0 0ms 292ms 365ms 464ms 10 67,574 15,476 1,098 0 2ms 504ms 697ms 20s4ms 11 58,498 12,387 922 0 0ms 419ms 616ms 921ms 12 93,997 19,325 1,115 0 0ms 877ms 1s4ms 6s126ms 13 97,829 21,067 1,273 0 14ms 1s148ms 6s368ms 3m43s 14 91,131 17,543 1,094 0 11ms 1s305ms 1s762ms 2m34s 15 71,241 13,372 1,183 1 1ms 574ms 716ms 1s38ms 16 31,309 6,447 653 0 0ms 206ms 260ms 362ms 17 10,406 2,546 324 0 0ms 78ms 102ms 150ms 18 37,332 9,538 391 1 0ms 234ms 283ms 932ms 19 45,599 8,794 649 0 0ms 413ms 486ms 593ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 20 23 0 0 0.00 0.00% Mar 21 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% Day Hour Count Average / Second Mar 20 23 0 0.00/s Mar 21 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s Day Hour Count Average Duration Average idle time Mar 20 23 0 0ms 0ms Mar 21 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 177,053 buffers Checkpoint Peak
- 2025-03-21 10:29:39 Date
- 270.048 seconds Highest write time
- 1.578 seconds Sync time
Checkpoints Wal files
Key values
- 134 files Wal files usage Peak
- 2025-03-21 10:24:39 Date
Checkpoints distance
Key values
- 4,275.41 Mo Distance Peak
- 2025-03-21 10:24:39 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 20 23 383,703 2,969.046s 0.057s 2,969.181s Mar 21 00 385,910 3,239.506s 0.052s 3,239.63s 01 213,718 3,239.558s 0.034s 3,239.645s 02 192,156 2,429.521s 0.063s 2,429.647s 03 138,861 3,239.605s 0.034s 3,239.687s 04 201,772 3,239.568s 0.064s 3,239.684s 05 274,577 3,162.971s 0.05s 3,163.087s 06 261,447 3,239.625s 0.045s 3,239.736s 07 198,562 3,239.491s 0.031s 3,239.579s 08 217,831 2,969.129s 0.045s 2,969.233s 09 291,557 3,239.522s 0.055s 3,239.639s 10 732,912 3,238.761s 1.631s 3,240.624s 11 462,051 2,969.467s 0.063s 2,969.674s 12 684,602 3,239.405s 0.079s 3,239.605s 13 699,161 3,239.42s 0.085s 3,239.672s 14 631,877 2,430.781s 0.092s 2,431.004s 15 667,687 3,239.381s 0.063s 3,239.552s 16 326,563 3,239.544s 0.042s 3,239.654s 17 96,234 3,023.254s 0.055s 3,023.357s 18 251,684 3,239.545s 0.062s 3,239.661s 19 305,452 2,429.592s 0.036s 2,429.695s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 20 23 0 0 169 4,717 0.002s 0.011s Mar 21 00 0 0 167 5,300 0.002s 0.012s 01 0 0 95 4,259 0.002s 0.012s 02 0 0 83 3,633 0.009s 0.011s 03 0 0 64 3,066 0.002s 0.012s 04 0 0 90 3,358 0.021s 0.012s 05 0 0 122 3,658 0.003s 0.013s 06 0 0 119 3,275 0.002s 0.012s 07 0 0 92 3,005 0.002s 0.012s 08 0 0 100 3,988 0.006s 0.012s 09 0 0 127 4,654 0.002s 0.012s 10 0 70 317 5,095 0.115s 0.015s 11 0 35 129 4,452 0.008s 0.012s 12 0 0 248 5,119 0.003s 0.012s 13 0 0 266 5,231 0.006s 0.012s 14 0 0 233 4,752 0.009s 0.011s 15 0 0 259 5,365 0.002s 0.012s 16 0 0 128 5,250 0.002s 0.012s 17 0 0 35 3,907 0.005s 0.013s 18 0 0 93 5,022 0.012s 0.012s 19 0 0 123 3,963 0.003s 0.009s Day Hour Count Avg time (sec) Mar 20 23 0 0s Mar 21 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s Day Hour Mean distance Mean estimate Mar 20 23 251,383.55 kB 295,480.00 kB Mar 21 00 227,798.83 kB 275,310.50 kB 01 130,077.75 kB 251,742.92 kB 02 123,928.09 kB 137,166.09 kB 03 87,140.92 kB 140,086.25 kB 04 123,364.00 kB 143,130.75 kB 05 153,313.23 kB 211,057.46 kB 06 163,010.83 kB 285,509.50 kB 07 125,633.00 kB 183,484.08 kB 08 135,411.33 kB 150,363.08 kB 09 174,535.67 kB 220,062.17 kB 10 540,357.18 kB 1,187,903.64 kB 11 223,858.17 kB 383,430.25 kB 12 339,461.92 kB 361,831.50 kB 13 360,878.18 kB 411,651.09 kB 14 347,821.82 kB 365,239.45 kB 15 353,530.58 kB 431,636.92 kB 16 171,893.36 kB 300,453.64 kB 17 43,746.54 kB 83,969.54 kB 18 126,282.92 kB 185,691.58 kB 19 225,032.67 kB 257,622.78 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Mar 20 23 0 0 0 Mar 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 20 23 0 0 Mar 21 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 9,168,386 Total read queries
- 4,582,638 Total write queries
Queries by database
Key values
- unknown Main database
- 15,836,983 Requests
- 9d2h34m28s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 15,836,983 Requests
User Request type Count Duration unknown Total 15,836,983 9d2h34m28s copy from 6 10ms cte 16,572 5s128ms ddl 1,328 242ms delete 11,363 4m57s insert 1,083,689 7m29s others 2,085,959 1m57s select 9,168,386 8d22h58m2s tcl 3,244,802 2m43s update 224,878 3h19m11s Duration by user
Key values
- 9d2h34m28s (unknown) Main time consuming user
User Request type Count Duration unknown Total 15,836,983 9d2h34m28s copy from 6 10ms cte 16,572 5s128ms ddl 1,328 242ms delete 11,363 4m57s insert 1,083,689 7m29s others 2,085,959 1m57s select 9,168,386 8d22h58m2s tcl 3,244,802 2m43s update 224,878 3h19m11s Queries by host
Key values
- unknown Main host
- 15,836,983 Requests
- 9d2h34m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 15,836,983 Requests
- 9d2h34m28s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-03-21 17:05:57 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 14,370,116 0-1ms duration
Slowest individual queries
Rank Duration Query 1 23m50s SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))) AND ("policy_number"."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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))))) ORDER BY "policy_number"."id" LIMIT 8;[ Date: 2025-03-21 10:54:19 ]
2 12m58s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:12:43.510726', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:25:45 ]
3 12m38s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:00.870848', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:18:41 ]
4 12m34s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:58.858871', "write_uid" = 1088 WHERE id IN (45330808);[ Date: 2025-03-21 06:19:35 ]
5 10m53s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:20:34.382595', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:31:30 ]
6 9m37s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:31:16.291582', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:40:56 ]
7 9m1s UPDATE "shipping_policy" SET "write_date" = '2025-03-21 12:23:43.890837', "write_uid" = 1030 WHERE id IN (6574419, 6574473, 6520651, 6540335, 6510485, 6519117, 6511401, 6519179, 6526266, 6530199, 6536844, 6536867, 6517108, 6519551, 6520351, 6508244, 6542687, 6538350, 6538712, 6520387, 6547516, 6547580, 6547790, 6507229, 6519489, 6530126, 6472855, 6489994, 6450182, 6498903, 6547277, 6517789, 6547536, 6503777, 6418055, 6498802, 6547301, 6528930, 6510646, 6510655, 6506040, 6507653, 6262302, 6547398, 6538547, 6500233, 6538308, 6454730, 6514953, 6424174, 6469126, 6473988, 6513839, 6547412, 6524808, 6540779, 6494454);[ Date: 2025-03-21 13:40:20 ]
8 7m43s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:14:23.892542', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:22:10 ]
9 7m14s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:22:15.022840', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:29:32 ]
10 6m17s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 22:42:27.319860', "write_uid" = 1227 WHERE id IN (45224455);[ Date: 2025-03-20 23:48:48 ]
11 6m10s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:08:39.519146', "write_uid" = 1088 WHERE id IN (45330808);[ Date: 2025-03-21 06:14:52 ]
12 6m1s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 22:48:38.818648', "write_uid" = 1227 WHERE id IN (45224455);[ Date: 2025-03-20 23:54:43 ]
13 5m59s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:31:32.234697', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:37:34 ]
14 5m25s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 22:29:33.655223', "write_uid" = 1227 WHERE id IN (45224455);[ Date: 2025-03-20 23:35:04 ]
15 5m14s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:18:59.894419', "write_uid" = 1088 WHERE id IN (45330808);[ Date: 2025-03-21 06:24:17 ]
16 4m40s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:05:18.189938', "write_uid" = 1088 WHERE id IN (45330808);[ Date: 2025-03-21 06:10:01 ]
17 4m16s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 23:15:22.844494', "write_uid" = 1227 WHERE id IN (45224455);[ Date: 2025-03-21 00:19:42 ]
18 4m11s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 23:28:23.464516', "write_uid" = 1227 WHERE id IN (45224455);[ Date: 2025-03-21 00:32:39 ]
19 4m5s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:11:02.755816', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:15:11 ]
20 3m49s UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:29:32.813200', "write_uid" = 1088 WHERE id IN (45387940);[ Date: 2025-03-21 06:33:25 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5d6h43m21s 296,102 694ms 9s123ms 1s540ms select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 20 23 18,631 6h5m 1s175ms Mar 21 00 14,353 4h12m44s 1s56ms 01 7,597 2h1m59s 963ms 02 8,209 1h55m32s 844ms 03 7,217 1h36m5s 798ms 04 10,968 2h24m27s 790ms 05 12,493 3h3m58s 883ms 06 12,739 3h10m50s 898ms 07 11,525 2h46m39s 867ms 08 11,861 3h5m4s 936ms 09 11,209 2h58m25s 955ms 10 15,912 4h55m58s 1s116ms 11 15,600 4h49m12s 1s112ms 12 26,500 13h15m24s 1s800ms 13 32,477 1d7h13m 3s460ms 14 30,322 1d1h15m15s 2s998ms 15 17,928 5h17m16s 1s61ms 16 7,138 1h39m21s 835ms 17 2,115 33m3s 937ms 18 7,350 2h3m45s 1s10ms 19 13,958 4h20m15s 1s118ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644889)) AND (("shipping_track"."id" not in (55460289, 55460289)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:36:47 Duration: 9s123ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644877)) AND (("shipping_track"."id" not in (55457825, 55457825)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:32:35 Duration: 9s108ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644890)) AND (("shipping_track"."id" not in (55460425, 55460425)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:37:01 Duration: 9s100ms
2 1d2h23m46s 50,709 714ms 10s638ms 1s873ms select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 20 23 3,729 1h11m17s 1s146ms Mar 21 00 1,796 31m16s 1s45ms 01 1,021 16m18s 958ms 02 484 7m25s 919ms 03 166 2m19s 842ms 04 186 2m47s 900ms 05 218 3m38s 1s1ms 06 284 4m35s 970ms 07 231 3m42s 964ms 08 586 9m12s 942ms 09 2,214 36m23s 986ms 10 3,895 1h15m32s 1s163ms 11 3,850 1h13m53s 1s151ms 12 4,937 2h57m24s 2s155ms 13 7,059 7h39m10s 3s902ms 14 6,275 6h14m1s 3s576ms 15 5,377 1h36m54s 1s81ms 16 2,680 37m16s 834ms 17 902 14m19s 952ms 18 1,981 33m31s 1s15ms 19 2,838 52m44s 1s114ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6613564, 6607005, 6606966, 6606911, 6601564, 6600074, 6105071, 6100068)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:36:14 Duration: 10s638ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6644590, 6644589, 6644588, 6644587, 6644586, 6644585, 6644584, 6644583)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:20:07 Duration: 10s404ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6641240, 6641204, 6641132, 6640984, 6640969, 6640893, 6640859, 6640853)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:14:52 Duration: 10s193ms
3 15h43m57s 96,208 232ms 3s195ms 588ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 20 23 1,914 13m56s 437ms Mar 21 00 2,942 19m40s 401ms 01 924 5m42s 370ms 02 1,160 5m44s 297ms 03 1,714 7m32s 264ms 04 3,358 15m18s 273ms 05 2,580 14m49s 344ms 06 3,172 18m55s 358ms 07 4,214 24m31s 349ms 08 4,552 28m8s 371ms 09 7,430 49m14s 397ms 10 8,672 1h3m6s 436ms 11 7,232 47m56s 397ms 12 11,658 2h32s 620ms 13 12,795 3h52m45s 1s91ms 14 9,509 3h5m56s 1s173ms 15 2,628 18m11s 415ms 16 599 3m10s 318ms 17 267 1m49s 409ms 18 7,762 57m56s 447ms 19 1,126 8m56s 476ms -
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" = '1032299')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 13:05:06 Duration: 3s195ms
-
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" = '1193126')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:27:24 Duration: 3s159ms
-
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" = '1250307')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:26:04 Duration: 3s156ms
4 9h16m50s 26,325 938ms 3s305ms 1s269ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 20 23 2,938 1h10m29s 1s439ms Mar 21 00 2,786 1h22s 1s300ms 01 1,227 23m51s 1s166ms 02 1,032 19m20s 1s124ms 03 2,059 38m49s 1s131ms 04 1,659 31m24s 1s135ms 05 2,759 54m21s 1s182ms 06 2,778 54m51s 1s184ms 07 1,660 32m7s 1s160ms 08 2,458 49m48s 1s215ms 09 968 19m20s 1s198ms 10 1,037 24m6s 1s394ms 11 423 10m8s 1s439ms 12 269 8m25s 1s880ms 13 161 7m12s 2s687ms 14 285 11m27s 2s413ms 15 368 9m7s 1s488ms 16 72 1m24s 1s169ms 17 101 1m53s 1s122ms 18 335 6m45s 1s209ms 19 950 21m33s 1s361ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '484376')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:40:42 Duration: 3s305ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '319948')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:48:32 Duration: 3s264ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '369155')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:58:19 Duration: 3s240ms
5 5h2m16s 163,891 49ms 670ms 110ms 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 #5
Day Hour Count Duration Avg duration Mar 20 23 10,544 15m1s 85ms Mar 21 00 8,513 11m2s 77ms 01 4,032 4m50s 72ms 02 3,800 4m12s 66ms 03 2,898 2m53s 59ms 04 4,242 4m17s 60ms 05 3,837 4m19s 67ms 06 4,535 5m10s 68ms 07 2,796 3m8s 67ms 08 4,074 4m52s 71ms 09 7,708 9m35s 74ms 10 10,960 15m37s 85ms 11 11,568 16m31s 85ms 12 18,066 39m22s 130ms 13 17,590 1h3m2s 215ms 14 19,345 1h1m12s 189ms 15 12,853 17m5s 79ms 16 5,374 5m42s 63ms 17 1,813 2m8s 70ms 18 4,469 5m31s 74ms 19 4,874 6m37s 81ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6539431, 6539393, 6539387, 6539314, 6535616, 6511899, 6127287)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:51:11 Duration: 670ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6557880, 6550617, 6474886, 6405734, 6405733, 6401442, 6342830, 6314614)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 14:49:04 Duration: 629ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6613564, 6607005, 6606966, 6606911, 6601564, 6600074, 6105071, 6100068)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:36:21 Duration: 625ms
6 4h45m7s 65,167 92ms 1s94ms 262ms 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 Mar 20 23 10,478 51m49s 296ms Mar 21 00 7,016 30m32s 261ms 01 3,652 14m50s 243ms 02 2,664 8m56s 201ms 03 4,982 17m28s 210ms 04 3,780 14m2s 222ms 05 5,476 22m6s 242ms 06 5,468 22m44s 249ms 07 3,294 12m27s 226ms 08 4,891 18m28s 226ms 09 1,956 7m49s 239ms 10 2,211 10m40s 289ms 11 843 4m24s 313ms 12 574 4m37s 483ms 13 370 4m38s 753ms 14 742 8m 648ms 15 972 4m37s 285ms 16 846 3m1s 214ms 17 234 54s504ms 232ms 18 1,594 6m22s 240ms 19 3,124 16m31s 317ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايه ايه ايه ايه')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 14:08:53 Duration: 1s94ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياموت')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 13:32:36 Duration: 1s71ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شركة 99-99')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 13:58:20 Duration: 1s54ms
7 4h10m14s 17,728 325ms 5s30ms 846ms select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 21 08 585 4m46s 490ms 09 3,949 33m11s 504ms 10 2,957 28m17s 574ms 11 2,373 21m39s 547ms 12 2,616 38m34s 884ms 13 3,313 1h20m49s 1s463ms 14 1,695 40m15s 1s425ms 15 240 2m39s 665ms -
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" = '721583')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:32:38 Duration: 5s30ms
-
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" = '1003102')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:48:41 Duration: 4s936ms
-
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" = '721759')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:32:43 Duration: 4s922ms
8 3h6m2s 18,377 236ms 3s127ms 607ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 20 23 1,013 7m38s 452ms Mar 21 00 1,611 10m47s 401ms 01 98 36s107ms 368ms 02 134 43s197ms 322ms 03 524 2m18s 264ms 04 196 54s649ms 278ms 05 54 18s307ms 339ms 06 663 3m55s 355ms 07 1,674 9m38s 345ms 08 1,676 10m26s 373ms 09 415 2m37s 379ms 10 1,560 11m42s 450ms 11 826 5m13s 379ms 12 1,716 15m52s 555ms 13 2,566 53m54s 1s260ms 14 1,775 36m46s 1s243ms 15 757 5m21s 424ms 16 373 1m59s 319ms 17 135 55s530ms 411ms 18 565 4m 424ms 19 46 23s529ms 511ms -
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" = '1225508')) 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 (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:37:11 Duration: 3s127ms
-
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" = '1212337')) 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 (64)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:28:33 Duration: 3s127ms
-
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" = '1254870')) 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 (1)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:27:48 Duration: 3s125ms
9 2h28m29s 33,080 0ms 12m58s 269ms update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 20 23 5,275 19m29s 221ms Mar 21 00 3,529 15m19s 260ms 01 1,836 396ms 0ms 02 1,332 309ms 0ms 03 2,488 508ms 0ms 04 1,891 355ms 0ms 05 2,737 585ms 0ms 06 2,720 1h52m40s 2s485ms 07 1,646 310ms 0ms 08 2,446 515ms 0ms 09 999 229ms 0ms 10 1,150 345ms 0ms 11 466 158ms 0ms 12 346 153ms 0ms 13 256 50s871ms 198ms 14 420 200ms 0ms 15 542 186ms 0ms 16 452 119ms 0ms 17 131 32ms 0ms 18 821 4s827ms 5ms 19 1,597 460ms 0ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:12:43.510726', "write_uid" = 1088 WHERE id IN (45387940);
Date: 2025-03-21 06:25:45 Duration: 12m58s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:00.870848', "write_uid" = 1088 WHERE id IN (45387940);
Date: 2025-03-21 06:18:41 Duration: 12m38s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:58.858871', "write_uid" = 1088 WHERE id IN (45330808);
Date: 2025-03-21 06:19:35 Duration: 12m34s
10 2h18m19s 6,697 920ms 3s49ms 1s239ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 20 23 2,360 52m48s 1s342ms Mar 21 00 751 15m19s 1s223ms 01 618 11m3s 1s73ms 02 309 5m30s 1s68ms 03 464 7m45s 1s2ms 04 249 4m16s 1s30ms 05 24 27s544ms 1s147ms 06 1 1s60ms 1s60ms 08 18 19s57ms 1s58ms 09 29 34s46ms 1s174ms 10 99 2m29s 1s513ms 11 9 10s159ms 1s128ms 12 25 50s637ms 2s25ms 13 37 1m28s 2s388ms 14 93 3m31s 2s269ms 15 134 2m52s 1s284ms 16 363 6m29s 1s74ms 17 18 19s398ms 1s77ms 18 473 8m47s 1s115ms 19 623 13m15s 1s276ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:09:45 Duration: 3s49ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:07:14 Duration: 3s
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1314408')) AND ("policy_number"."package_id" = 2414)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:32:45 Duration: 2s915ms
11 1h50m22s 44,382 62ms 562ms 149ms select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 20 23 107 11s23ms 103ms Mar 21 00 29 2s824ms 97ms 08 1,037 1m26s 83ms 09 5,934 8m46s 88ms 10 6,634 10m57s 99ms 11 4,219 6m49s 97ms 12 5,285 12m9s 138ms 13 9,024 30m52s 205ms 14 10,846 36m51s 203ms 15 1,267 2m15s 106ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6509206) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:28:05 Duration: 562ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6401321) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:08:57 Duration: 531ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6415447) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:23:20 Duration: 528ms
12 1h44m17s 8,306 271ms 3s94ms 753ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 20 23 128 53s317ms 416ms Mar 21 00 254 1m45s 414ms 01 27 10s128ms 375ms 02 33 11s610ms 351ms 04 4 1s96ms 274ms 05 271 1m33s 343ms 07 149 50s636ms 339ms 08 691 4m27s 386ms 09 183 1m11s 388ms 10 462 3m29s 453ms 11 1,018 6m38s 391ms 12 1,359 14m41s 648ms 13 1,484 30m3s 1s215ms 14 1,524 33m27s 1s317ms 15 624 4m10s 400ms 19 95 43s222ms 454ms -
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" = '1256105')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:32:36 Duration: 3s94ms
-
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" = '1081223')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:13:05 Duration: 3s80ms
-
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" = '1014079')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 13:53:10 Duration: 3s54ms
13 1h18m47s 14,147 125ms 1s289ms 334ms select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 20 23 1,523 5m30s 216ms Mar 21 00 817 2m31s 185ms 01 209 37s122ms 177ms 02 6 1s336ms 222ms 08 45 7s452ms 165ms 09 372 1m5s 174ms 10 1,080 3m38s 202ms 11 831 3m7s 226ms 12 1,515 9m24s 372ms 13 2,249 24m16s 647ms 14 1,795 17m42s 591ms 15 1,339 4m9s 186ms 16 640 1m33s 146ms 17 218 34s510ms 158ms 18 334 54s896ms 164ms 19 1,174 3m32s 180ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8405070)) AND (("cash_track"."id" not in (9899240)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 14:35:28 Duration: 1s289ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8404403)) AND (("cash_track"."id" not in (9896296)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 13:47:32 Duration: 1s287ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8404537)) AND (("cash_track"."id" not in (9896759)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 13:57:16 Duration: 1s279ms
14 59m41s 14,250 187ms 504ms 251ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 20 23 196 57s352ms 292ms Mar 21 00 969 4m31s 280ms 01 695 3m2s 262ms 02 955 3m49s 240ms 03 1,072 4m9s 232ms 04 2,598 10m23s 239ms 05 2,018 8m7s 241ms 06 2,381 10m 252ms 07 1,913 7m57s 249ms 08 925 4m10s 270ms 09 528 2m31s 286ms -
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" = '1041830')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 05:00:29 Duration: 504ms
-
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" = '1270964')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 02:28:19 Duration: 432ms
-
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" = '1003967')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 02:00:27 Duration: 425ms
15 46m43s 4,269 249ms 3s95ms 656ms 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 #15
Day Hour Count Duration Avg duration Mar 20 23 40 16s240ms 406ms Mar 21 01 2 593ms 296ms 03 4 1s375ms 343ms 08 476 2m42s 342ms 09 709 4m16s 361ms 10 527 3m32s 403ms 11 34 14s325ms 421ms 12 605 6m38s 658ms 13 381 7m48s 1s229ms 14 849 16m9s 1s141ms 15 453 3m53s 515ms 16 61 20s372ms 333ms 17 44 15s910ms 361ms 18 54 19s546ms 361ms 19 30 14s181ms 472ms -
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" = '901400')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:32:14 Duration: 3s95ms
-
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" = '982035')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:37:04 Duration: 3s88ms
-
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" = '911889')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:36:52 Duration: 3s73ms
16 43m29s 2,151 304ms 6s773ms 1s213ms select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 20 23 95 57s883ms 609ms Mar 21 00 85 44s317ms 521ms 01 49 22s417ms 457ms 02 37 13s886ms 375ms 03 34 12s436ms 365ms 04 51 18s839ms 369ms 05 56 25s638ms 457ms 06 53 24s239ms 457ms 07 62 27s502ms 443ms 08 73 35s462ms 485ms 09 120 1m 503ms 10 125 1m25s 687ms 11 139 1m29s 643ms 12 246 6m29s 1s581ms 13 304 14m54s 2s940ms 14 249 9m49s 2s369ms 15 152 1m43s 682ms 16 54 22s52ms 408ms 17 29 14s502ms 500ms 18 84 44s388ms 528ms 19 54 33s881ms 627ms -
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('1012658', '1012594', '1012411', '1012172', '1012837', '1012273', '1012843');
Date: 2025-03-21 13:40:27 Duration: 6s773ms
-
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('1313689', '1267731', '1124705', '1248349', '1202278', '1106480');
Date: 2025-03-21 13:41:07 Duration: 6s340ms
-
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('893573', '721583', '721759', '92033', '721567', '721479', '366859', '299893');
Date: 2025-03-21 14:32:24 Duration: 6s276ms
17 41m47s 5,522 122ms 1s437ms 454ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 20 23 211 40s692ms 192ms Mar 21 00 183 29s559ms 161ms 01 141 21s434ms 152ms 02 21 3s61ms 145ms 03 15 1s997ms 133ms 04 105 14s470ms 137ms 05 42 6s157ms 146ms 06 30 4s587ms 152ms 08 85 12s971ms 152ms 09 115 20s243ms 176ms 10 358 1m24s 234ms 11 566 2m10s 230ms 12 1,136 9m59s 528ms 13 637 10m24s 980ms 14 735 10m59s 897ms 15 661 3m 272ms 16 185 26s11ms 140ms 17 74 10s808ms 146ms 18 124 20s42ms 161ms 19 98 17s183ms 175ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 8)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 13:31:16 Duration: 1s437ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 14:26:09 Duration: 1s409ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 14:34:14 Duration: 1s379ms
18 36m25s 18,644 56ms 423ms 117ms select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 21 08 474 34s388ms 72ms 09 3,425 4m39s 81ms 10 3,718 5m21s 86ms 11 2,065 3m8s 91ms 12 2,855 5m43s 120ms 13 4,209 12m18s 175ms 14 1,432 3m55s 164ms 15 466 44s152ms 94ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6550885) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:55:33 Duration: 423ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6280866) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:46:06 Duration: 422ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6345321) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:07:09 Duration: 421ms
19 34m58s 3,082 302ms 3s86ms 680ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 21 08 463 2m52s 373ms 09 577 3m45s 390ms 10 415 2m52s 416ms 12 321 3m16s 612ms 13 326 6m38s 1s222ms 14 609 12m27s 1s226ms 15 371 3m4s 498ms -
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" = '1221381')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:31:57 Duration: 3s86ms
-
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" = '1022148')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:31:27 Duration: 3s60ms
-
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" = '1173172')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 13:45:58 Duration: 3s24ms
20 26m6s 77 726ms 23m50s 20s345ms 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 (...)))))))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 20 23 12 16s371ms 1s364ms Mar 21 00 9 12s901ms 1s433ms 02 1 1s174ms 1s174ms 04 5 6s382ms 1s276ms 10 1 23m50s 23m50s 11 1 1s296ms 1s296ms 12 6 13s200ms 2s200ms 13 11 35s84ms 3s189ms 14 5 12s723ms 2s544ms 15 11 16s424ms 1s493ms 16 1 1s231ms 1s231ms 17 2 2s460ms 1s230ms 18 4 5s67ms 1s266ms 19 8 12s215ms 1s526ms -
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))) AND ("policy_number"."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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 10:54:19 Duration: 23m50s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 14:19:20 Duration: 3s588ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))))) 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 (51)))))) 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 (51)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) 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 (51))))))))) 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 (51)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 13:21:39 Duration: 3s495ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,085,168 1m57s 0ms 4ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 20 23 110,205 5s820ms 0ms Mar 21 00 86,085 4s710ms 0ms 01 63,914 3s296ms 0ms 02 47,804 1s896ms 0ms 03 34,851 1s535ms 0ms 04 47,993 2s216ms 0ms 05 51,328 2s192ms 0ms 06 47,195 2s72ms 0ms 07 43,697 1s972ms 0ms 08 62,696 2s596ms 0ms 09 105,162 5s408ms 0ms 10 133,602 7s952ms 0ms 11 125,094 6s116ms 0ms 12 208,013 15s126ms 0ms 13 207,267 14s579ms 0ms 14 189,312 11s16ms 0ms 15 159,437 10s154ms 0ms 16 109,127 6s319ms 0ms 17 60,100 2s134ms 0ms 18 104,236 5s243ms 0ms 19 88,050 4s993ms 0ms -
DISCARD ALL;
Date: 2025-03-21 14:28:22 Duration: 4ms
-
DISCARD ALL;
Date: 2025-03-21 14:12:39 Duration: 4ms
-
DISCARD ALL;
Date: 2025-03-21 13:23:01 Duration: 3ms
2 1,622,718 31s895ms 0ms 21ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 20 23 85,989 1s437ms 0ms Mar 21 00 64,223 1s68ms 0ms 01 46,424 713ms 0ms 02 35,700 499ms 0ms 03 24,202 370ms 0ms 04 35,332 530ms 0ms 05 38,957 576ms 0ms 06 35,221 527ms 0ms 07 31,720 483ms 0ms 08 48,770 819ms 0ms 09 82,669 1s309ms 0ms 10 105,027 2s20ms 0ms 11 96,817 1s612ms 0ms 12 169,375 4s170ms 0ms 13 166,585 4s803ms 0ms 14 154,705 3s893ms 0ms 15 128,046 2s487ms 0ms 16 83,326 1s384ms 0ms 17 41,401 553ms 0ms 18 80,408 1s316ms 0ms 19 67,821 1s315ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-21 00:34:32 Duration: 21ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-21 19:10:12 Duration: 17ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-03-21 05:00:09 Duration: 13ms
3 1,061,434 12s840ms 0ms 24ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 20 23 56,023 633ms 0ms Mar 21 00 43,808 446ms 0ms 01 32,649 299ms 0ms 02 24,487 226ms 0ms 03 18,110 169ms 0ms 04 24,604 236ms 0ms 05 26,320 269ms 0ms 06 24,234 250ms 0ms 07 22,470 222ms 0ms 08 34,160 348ms 0ms 09 53,420 545ms 0ms 10 67,703 806ms 0ms 11 63,467 720ms 0ms 12 105,068 1s428ms 0ms 13 104,820 1s790ms 0ms 14 95,509 1s618ms 0ms 15 80,779 969ms 0ms 16 55,317 543ms 0ms 17 30,742 261ms 0ms 18 53,059 534ms 0ms 19 44,685 518ms 0ms -
ROLLBACK;
Date: 2025-03-21 10:36:07 Duration: 24ms
-
ROLLBACK;
Date: 2025-03-21 13:37:54 Duration: 3ms
-
ROLLBACK;
Date: 2025-03-21 13:59:16 Duration: 3ms
4 1,048,817 3m52s 0ms 25ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 20 23 55,510 11s649ms 0ms Mar 21 00 43,222 8s412ms 0ms 01 32,121 5s710ms 0ms 02 23,971 4s589ms 0ms 03 17,521 3s71ms 0ms 04 24,017 4s447ms 0ms 05 25,705 5s120ms 0ms 06 23,630 4s594ms 0ms 07 21,898 4s238ms 0ms 08 31,487 5s963ms 0ms 09 53,005 10s160ms 0ms 10 67,379 14s344ms 0ms 11 63,117 13s315ms 0ms 12 104,652 25s872ms 0ms 13 104,400 27s360ms 0ms 14 94,929 26s495ms 0ms 15 80,342 19s36ms 0ms 16 54,924 11s213ms 0ms 17 30,203 5s42ms 0ms 18 52,486 11s158ms 0ms 19 44,298 10s592ms 0ms -
SELECT payload FROM http_sessions WHERE sid = 'fc381c0d9e5736a641cb828e459f96eb52c6a020';
Date: 2025-03-21 12:28:17 Duration: 25ms
-
SELECT payload FROM http_sessions WHERE sid = '54a5284c317a59505a8d98de85aaaa22bc7bc4d4';
Date: 2025-03-21 10:36:07 Duration: 19ms
-
SELECT payload FROM http_sessions WHERE sid = '6aa3c13a48b7806c0d98541ba1fc8e1753f321f5';
Date: 2025-03-21 10:45:03 Duration: 18ms
5 1,042,099 1m55s 0ms 3ms 0ms select base_registry_signaling.last_value, base_cache_signaling.last_value from base_registry_signaling, base_cache_signaling;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 20 23 55,147 5s878ms 0ms Mar 21 00 43,026 4s253ms 0ms 01 31,975 2s917ms 0ms 02 23,951 2s279ms 0ms 03 17,477 1s638ms 0ms 04 24,051 2s337ms 0ms 05 25,752 2s540ms 0ms 06 23,654 2s286ms 0ms 07 21,893 2s107ms 0ms 08 31,106 2s939ms 0ms 09 52,565 5s203ms 0ms 10 66,774 7s232ms 0ms 11 62,572 6s661ms 0ms 12 103,893 12s819ms 0ms 13 103,444 14s436ms 0ms 14 94,474 13s481ms 0ms 15 79,620 8s912ms 0ms 16 54,540 5s225ms 0ms 17 30,119 2s426ms 0ms 18 52,076 5s47ms 0ms 19 43,990 4s770ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-21 13:46:31 Duration: 3ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-21 13:27:36 Duration: 3ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-03-21 14:12:55 Duration: 3ms
6 560,621 1m59s 0ms 88ms 0ms commit;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 20 23 29,957 6s361ms 0ms Mar 21 00 20,421 4s435ms 0ms 01 13,776 2s385ms 0ms 02 11,206 1s965ms 0ms 03 6,093 1s172ms 0ms 04 10,727 1s915ms 0ms 05 12,633 2s529ms 0ms 06 10,983 2s181ms 0ms 07 9,252 2s47ms 0ms 08 14,605 2s475ms 0ms 09 29,250 4s811ms 0ms 10 37,321 7s603ms 0ms 11 33,343 6s658ms 0ms 12 64,278 15s289ms 0ms 13 61,546 17s416ms 0ms 14 58,803 16s58ms 0ms 15 47,283 9s782ms 0ms 16 28,009 4s348ms 0ms 17 10,661 1s433ms 0ms 18 27,339 3s913ms 0ms 19 23,135 4s270ms 0ms -
COMMIT;
Date: 2025-03-21 13:59:58 Duration: 88ms
-
COMMIT;
Date: 2025-03-20 23:19:06 Duration: 79ms
-
COMMIT;
Date: 2025-03-21 12:49:56 Duration: 73ms
7 496,966 1m42s 0ms 7ms 0ms select "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" from "urgent_customer" where "urgent_customer".id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 20 23 27,653 4s612ms 0ms Mar 21 00 17,482 2s797ms 0ms 01 12,928 2s49ms 0ms 02 12,261 2s136ms 0ms 03 7,049 796ms 0ms 04 12,376 1s983ms 0ms 05 15,684 2s635ms 0ms 06 13,170 2s56ms 0ms 07 9,941 1s520ms 0ms 08 13,272 2s89ms 0ms 09 22,520 3s724ms 0ms 10 35,472 7s127ms 0ms 11 30,025 6s2ms 0ms 12 55,864 14s178ms 0ms 13 52,106 16s545ms 0ms 14 47,460 14s667ms 0ms 15 38,581 6s875ms 0ms 16 23,956 3s454ms 0ms 17 7,410 1s49ms 0ms 18 21,423 3s366ms 0ms 19 20,333 3s305ms 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 (5099590, 5099008, 5571992, 5099009, 5113565, 5099092, 5130152, 5102986, 5571989, 5099236, 5100721, 5571988, 5100181, 5198276, 5099636, 5104600, 5112243, 5100600, 5100054, 5571983, 5100786, 5458045, 5099401, 5099047, 5128278, 5100074, 5099014, 5101164, 5107181, 5100677, 5101563, 5176347, 5208988, 5099241, 5099356, 5099658, 5571985, 5565050, 5119007, 5169304, 5531841, 5106320, 5141953, 5571979, 5099246, 5273902, 5128643, 5244969, 5101901, 5107929, 5139691, 5099404, 5099181, 5099897, 5099445, 5099128, 5099162, 5099138, 5099159, 5100004);
Date: 2025-03-21 14:21:54 Duration: 7ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099148, 5099251, 5099182, 5099206, 5099009, 5100482, 5187214, 5099008, 5099581, 5099130, 5099007, 5099186, 5102979, 5099006, 5099356, 5099174, 5099285, 5105150, 5099248, 5099644, 5099035, 5099800, 5099144, 5099102, 5100457, 5100327, 5555152, 5099010, 5561184, 5100499, 5102575, 5103363, 5195523, 5100302, 5099967, 5099590, 5208233, 5099806, 5102250, 5100933, 5179852, 5099027, 5099045);
Date: 2025-03-21 02:21:55 Duration: 4ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099148, 5099251, 5099182, 5099206, 5099009, 5100482, 5187214, 5099008, 5099581, 5099130, 5099007, 5099186, 5102979, 5099006, 5099356, 5099174, 5099285, 5105150, 5099035, 5099248, 5099644, 5099800, 5099144, 5099102, 5100457, 5100327, 5555152, 5099010, 5561184, 5100499, 5102575, 5103363, 5195523, 5100302, 5099967, 5099590, 5208233, 5099806, 5102250, 5099941, 5100933, 5179852, 5099027, 5099045);
Date: 2025-03-21 02:21:55 Duration: 4ms
8 462,969 54s230ms 0ms 4ms 0ms select "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 20 23 26,606 2s540ms 0ms Mar 21 00 16,918 1s528ms 0ms 01 10,545 810ms 0ms 02 9,225 703ms 0ms 03 4,046 280ms 0ms 04 7,884 612ms 0ms 05 9,539 785ms 0ms 06 8,070 720ms 0ms 07 6,983 601ms 0ms 08 10,146 888ms 0ms 09 22,741 2s19ms 0ms 10 31,523 3s382ms 0ms 11 26,872 2s808ms 0ms 12 52,291 7s550ms 0ms 13 51,836 10s23ms 0ms 14 50,778 9s60ms 0ms 15 40,343 4s65ms 0ms 16 24,469 1s702ms 0ms 17 8,458 515ms 0ms 18 23,025 1s726ms 0ms 19 20,671 1s906ms 0ms -
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (17, 7, 30);
Date: 2025-03-21 14:16:27 Duration: 4ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);
Date: 2025-03-21 13:43:37 Duration: 3ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (7, 38, 121);
Date: 2025-03-21 14:33:44 Duration: 2ms
9 306,358 2m16s 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 #9
Day Hour Count Duration Avg duration Mar 20 23 13,255 5s425ms 0ms Mar 21 00 15,256 5s549ms 0ms 01 7,559 2s568ms 0ms 02 5,374 1s756ms 0ms 03 4,136 1s277ms 0ms 04 3,763 1s267ms 0ms 05 3,668 1s312ms 0ms 06 3,101 1s61ms 0ms 07 3,005 1s51ms 0ms 08 9,323 3s219ms 0ms 09 15,772 5s917ms 0ms 10 15,191 6s508ms 0ms 11 11,484 4s824ms 0ms 12 25,020 13s506ms 0ms 13 31,733 18s984ms 0ms 14 49,769 28s685ms 0ms 15 36,471 14s960ms 0ms 16 19,005 6s572ms 0ms 17 5,331 1s701ms 0ms 18 16,225 5s750ms 0ms 19 11,917 4s967ms 0ms -
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy.items' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 1459) OR r.global) ORDER BY r.id;
Date: 2025-03-21 13:24:16 Duration: 4ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' 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 = 831) OR r.global) ORDER BY r.id;
Date: 2025-03-21 13:44:40 Duration: 4ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.country.state' 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 = 950) OR r.global) ORDER BY r.id;
Date: 2025-03-21 14:27:14 Duration: 3ms
10 302,098 1m19s 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 Mar 20 23 16,002 3s891ms 0ms Mar 21 00 9,980 2s226ms 0ms 01 6,744 1s279ms 0ms 02 5,391 1s162ms 0ms 03 3,164 563ms 0ms 04 4,842 941ms 0ms 05 5,781 1s290ms 0ms 06 5,378 1s180ms 0ms 07 4,446 900ms 0ms 08 8,369 1s615ms 0ms 09 17,005 3s398ms 0ms 10 20,612 4s892ms 0ms 11 17,420 4s236ms 0ms 12 35,579 11s73ms 0ms 13 33,505 12s859ms 0ms 14 31,569 12s160ms 0ms 15 25,624 6s73ms 0ms 16 15,645 2s861ms 0ms 17 6,104 1s6ms 0ms 18 15,980 3s17ms 0ms 19 12,958 2s923ms 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 (8004719);
Date: 2025-03-21 02:21:55 Duration: 10ms
-
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8007029);
Date: 2025-03-21 14:21:54 Duration: 8ms
-
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 (8006287, 8006936, 8006458, 8007364, 8006797);
Date: 2025-03-21 14:21:54 Duration: 8ms
11 296,102 5d6h43m21s 694ms 9s123ms 1s540ms 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 #11
Day Hour Count Duration Avg duration Mar 20 23 18,631 6h5m 1s175ms Mar 21 00 14,353 4h12m44s 1s56ms 01 7,597 2h1m59s 963ms 02 8,209 1h55m32s 844ms 03 7,217 1h36m5s 798ms 04 10,968 2h24m27s 790ms 05 12,493 3h3m58s 883ms 06 12,739 3h10m50s 898ms 07 11,525 2h46m39s 867ms 08 11,861 3h5m4s 936ms 09 11,209 2h58m25s 955ms 10 15,912 4h55m58s 1s116ms 11 15,600 4h49m12s 1s112ms 12 26,500 13h15m24s 1s800ms 13 32,477 1d7h13m 3s460ms 14 30,322 1d1h15m15s 2s998ms 15 17,928 5h17m16s 1s61ms 16 7,138 1h39m21s 835ms 17 2,115 33m3s 937ms 18 7,350 2h3m45s 1s10ms 19 13,958 4h20m15s 1s118ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644889)) AND (("shipping_track"."id" not in (55460289, 55460289)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:36:47 Duration: 9s123ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644877)) AND (("shipping_track"."id" not in (55457825, 55457825)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:32:35 Duration: 9s108ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644890)) AND (("shipping_track"."id" not in (55460425, 55460425)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:37:01 Duration: 9s100ms
12 252,334 35s5ms 0ms 3ms 0ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 20 23 13,760 1s622ms 0ms Mar 21 00 8,580 992ms 0ms 01 5,786 585ms 0ms 02 4,798 550ms 0ms 03 2,531 300ms 0ms 04 4,317 476ms 0ms 05 5,186 626ms 0ms 06 4,716 669ms 0ms 07 3,730 463ms 0ms 08 6,568 711ms 0ms 09 13,937 1s388ms 0ms 10 17,485 2s85ms 0ms 11 14,924 1s834ms 0ms 12 29,286 4s725ms 0ms 13 28,126 6s7ms 0ms 14 26,132 5s410ms 0ms 15 20,857 2s417ms 0ms 16 13,031 1s150ms 0ms 17 4,912 467ms 0ms 18 12,854 1s269ms 0ms 19 10,818 1s249ms 0ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (821);
Date: 2025-03-21 13:42:08 Duration: 3ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (821);
Date: 2025-03-21 13:52:34 Duration: 3ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (821);
Date: 2025-03-21 13:36:46 Duration: 3ms
13 238,525 58s39ms 0ms 6ms 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 Mar 20 23 9,420 1s960ms 0ms Mar 21 00 11,722 2s426ms 0ms 01 6,054 1s9ms 0ms 02 4,207 721ms 0ms 03 3,664 566ms 0ms 04 3,046 500ms 0ms 05 3,481 586ms 0ms 06 2,617 409ms 0ms 07 2,999 487ms 0ms 08 8,959 1s629ms 0ms 09 13,197 2s430ms 0ms 10 11,780 2s526ms 0ms 11 9,463 1s963ms 0ms 12 21,444 5s836ms 0ms 13 25,265 8s789ms 0ms 14 37,266 13s159ms 0ms 15 25,496 5s894ms 0ms 16 13,460 2s417ms 0ms 17 3,644 587ms 0ms 18 12,557 2s261ms 0ms 19 8,784 1s874ms 0ms -
SELECT 1 FROM res_groups_users_rel WHERE uid = 1055 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');
Date: 2025-03-21 14:17:06 Duration: 6ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-03-21 15:43:20 Duration: 4ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 832 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-03-21 14:12:43 Duration: 4ms
14 218,994 1m23s 0ms 30ms 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 Mar 20 23 14,976 4s855ms 0ms Mar 21 00 10,199 2s976ms 0ms 01 5,960 1s770ms 0ms 02 5,109 2s17ms 0ms 03 4,010 1s52ms 0ms 04 5,441 1s657ms 0ms 05 7,012 2s304ms 0ms 06 6,261 1s946ms 0ms 07 4,413 1s358ms 0ms 08 6,769 2s295ms 0ms 09 9,608 3s452ms 0ms 10 14,410 5s307ms 0ms 11 11,781 4s708ms 0ms 12 22,619 10s326ms 0ms 13 21,814 12s186ms 0ms 14 19,723 11s488ms 0ms 15 16,131 5s187ms 0ms 16 9,924 2s484ms 0ms 17 3,130 862ms 0ms 18 9,333 2s727ms 0ms 19 10,371 2s925ms 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 (41898608, 39689092, 45060149, 32247955, 32359181, 32359420, 32360612, 32419039, 32419105, 32454693, 32454805, 32525061, 32525421, 32526250, 32526582, 41994041, 42133188, 44503470, 44504314, 44822123, 44822248, 44822427, 44822678, 44868676, 44869125, 44946428, 44946842, 44947401, 44947580, 45120885, 45120886, 45120887, 45120911, 45121176, 45121473, 45185186, 44899306, 32260000, 44552255, 44914065, 44914610, 45064540, 45064622, 32396145, 32396910, 32397362, 32452599, 44849192, 44967517, 32325140, 32326080, 32432364, 32433070, 32433743, 32434405, 32434442, 32557014, 32559508, 42037312, 44711264, 44711425, 44713669, 44839740, 45011426, 45078838, 45079290, 45080817, 32193109, 32282570, 32356704, 32357174, 32530436, 39953262, 42048130, 42098991, 44475219, 44533789, 44534355, 44534437, 44597771, 44597833, 44709298, 44814802, 44815493, 44890725, 44891065, 44891488, 45005178, 45006042, 45006064, 45007867, 45056373, 45057958, 45057966, 44529371, 44631988, 44632833, 44913174, 41525720, 41526345);
Date: 2025-03-21 14:21:55 Duration: 30ms
-
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 (32192037, 32191064, 42056714, 42002117, 32544745, 42162876, 32191047, 42157659, 32326266, 32277926, 41746634, 32208985, 32315146, 32189096, 42117313, 32292686, 32349072, 32346488, 32561421, 32226284, 32192622, 42129037, 44973669, 32201194, 42037914, 32201217, 32368546, 32249920, 32287205, 32192625, 41935138, 42125572, 32297678, 32250002, 32440749, 44955823, 42112522, 32275176, 32295550, 32422518, 42110929, 32192604, 41473212, 32258539, 42159044, 32306299, 32191981, 32191773, 44915700, 42056222, 44707039, 42103651, 32195669, 42043872, 42137764, 44668908, 32216532, 44658017, 44857007, 45180483, 32200085, 45002979, 45111008, 42137396, 32226003, 32354267, 32229011, 32442007, 32347344, 32234056, 42086874, 32315002, 32491796, 32237619, 42107381, 32344697, 32317765, 32657422, 32246135, 32316125, 32326909, 44961728, 42170660, 42161752, 32656764, 42110928, 41741362, 42103964, 32560661, 32216740, 32284643, 32334916, 32533418, 44801666, 42011871, 42170979, 32183359, 32206559, 32322714, 41771354);
Date: 2025-03-21 14:21:56 Duration: 28ms
-
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 (40460028, 39970046, 32258019, 40988019, 41025964, 41325953, 42130752, 44661454, 32257744, 32663979, 32663944, 32646199, 32646214, 41935711, 41791189, 41791181, 32217086, 42041244, 42041242, 37855132, 42088210, 40301233, 39868153, 40385905, 39847214, 39516078, 39810428, 39687508, 39208982, 39718707, 39667895, 39832858, 39414557, 32539445, 44899933, 44879446, 42058499, 42058555, 40719641, 41574940, 41790798, 42057730, 41936434, 41839842, 44985515, 41790852, 41791138, 41936300, 41839650, 44801294, 41066195, 45321377, 39788717, 41792533, 45205720, 45033702, 45164535, 44787602, 45232400, 41131925, 40357924, 40357922, 45016563, 42130531, 41936599, 39798263, 42082359, 41889106, 41255815, 41758752, 41743467, 41973481, 41874721, 44858191, 41903050, 41932196, 41903471, 41903585, 41625173, 42039579, 45029108, 41547387, 40591295, 39567944, 39725818, 39797866, 39709122, 39722913, 39707919, 44714208, 44831800, 44747787, 39555175, 39385934, 40023025, 39959732, 39706708, 39810747, 39589227, 39594612);
Date: 2025-03-21 02:21:56 Duration: 25ms
15 163,891 5h2m16s 49ms 670ms 110ms 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 #15
Day Hour Count Duration Avg duration Mar 20 23 10,544 15m1s 85ms Mar 21 00 8,513 11m2s 77ms 01 4,032 4m50s 72ms 02 3,800 4m12s 66ms 03 2,898 2m53s 59ms 04 4,242 4m17s 60ms 05 3,837 4m19s 67ms 06 4,535 5m10s 68ms 07 2,796 3m8s 67ms 08 4,074 4m52s 71ms 09 7,708 9m35s 74ms 10 10,960 15m37s 85ms 11 11,568 16m31s 85ms 12 18,066 39m22s 130ms 13 17,590 1h3m2s 215ms 14 19,345 1h1m12s 189ms 15 12,853 17m5s 79ms 16 5,374 5m42s 63ms 17 1,813 2m8s 70ms 18 4,469 5m31s 74ms 19 4,874 6m37s 81ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6539431, 6539393, 6539387, 6539314, 6535616, 6511899, 6127287)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:51:11 Duration: 670ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6557880, 6550617, 6474886, 6405734, 6405733, 6401442, 6342830, 6314614)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 14:49:04 Duration: 629ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6613564, 6607005, 6606966, 6606911, 6601564, 6600074, 6105071, 6100068)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:36:21 Duration: 625ms
16 163,868 1m5s 0ms 5ms 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 #16
Day Hour Count Duration Avg duration Mar 20 23 21,470 8s700ms 0ms Mar 21 00 15,292 5s483ms 0ms 01 7,993 2s477ms 0ms 02 6,814 2s252ms 0ms 03 10,955 3s195ms 0ms 04 10,131 3s346ms 0ms 05 14,124 4s988ms 0ms 06 13,965 4s988ms 0ms 07 10,435 3s920ms 0ms 08 12,446 4s490ms 0ms 09 5,038 1s882ms 0ms 10 4,933 2s109ms 0ms 11 2,685 1s408ms 0ms 12 3,557 2s675ms 0ms 13 2,333 2s151ms 0ms 14 5,813 5s309ms 0ms 15 3,116 1s604ms 0ms 16 2,077 732ms 0ms 17 538 172ms 0ms 18 3,474 1s181ms 0ms 19 6,679 2s600ms 0ms -
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 14) AND ("price_list"."to_office_id" = 13)) ORDER BY "price_list"."id";
Date: 2025-03-21 14:28:02 Duration: 5ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 64) AND ("price_list"."to_office_id" = 102)) ORDER BY "price_list"."id";
Date: 2025-03-21 14:32:43 Duration: 4ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 111) AND ("price_list"."to_office_id" = 22)) ORDER BY "price_list"."id";
Date: 2025-03-21 05:01:54 Duration: 4ms
17 161,884 31s679ms 0ms 23ms 0ms select "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" from "notebook_package" where "notebook_package".id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 20 23 7,717 1s767ms 0ms Mar 21 00 5,008 1s174ms 0ms 01 3,887 829ms 0ms 02 3,688 781ms 0ms 03 1,440 130ms 0ms 04 3,458 249ms 0ms 05 4,214 340ms 0ms 06 3,488 284ms 0ms 07 2,726 213ms 0ms 08 3,587 297ms 0ms 09 7,423 729ms 0ms 10 11,684 1s600ms 0ms 11 10,041 1s325ms 0ms 12 19,542 3s997ms 0ms 13 18,197 5s451ms 0ms 14 16,857 5s133ms 0ms 15 13,461 2s716ms 0ms 16 8,335 1s366ms 0ms 17 2,522 401ms 0ms 18 7,555 1s330ms 0ms 19 7,054 1s558ms 0ms -
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2414, 2);
Date: 2025-03-21 15:23:38 Duration: 23ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2414);
Date: 2025-03-21 13:46:28 Duration: 4ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2414);
Date: 2025-03-21 13:32:22 Duration: 4ms
18 131,030 11s174ms 0ms 2ms 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 #18
Day Hour Count Duration Avg duration Mar 20 23 5,478 400ms 0ms Mar 21 00 7,059 473ms 0ms 01 3,198 184ms 0ms 02 2,388 138ms 0ms 03 1,776 96ms 0ms 04 1,500 87ms 0ms 05 1,375 88ms 0ms 06 1,204 70ms 0ms 07 1,302 76ms 0ms 08 3,786 233ms 0ms 09 6,607 428ms 0ms 10 6,348 485ms 0ms 11 4,636 354ms 0ms 12 10,581 1s44ms 0ms 13 13,588 1s714ms 0ms 14 21,643 2s663ms 0ms 15 15,607 1s195ms 0ms 16 8,506 511ms 0ms 17 2,270 121ms 0ms 18 7,077 431ms 0ms 19 5,101 372ms 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 (98, 99);
Date: 2025-03-21 14:17:10 Duration: 2ms
-
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 (98, 99);
Date: 2025-03-21 13:06:40 Duration: 2ms
-
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 (98, 99);
Date: 2025-03-21 13:02:18 Duration: 1ms
19 130,833 15s519ms 0ms 18ms 0ms select "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" from "urgent_warehouse" where "urgent_warehouse".id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 20 23 4,894 448ms 0ms Mar 21 00 5,342 562ms 0ms 01 3,608 262ms 0ms 02 3,507 243ms 0ms 03 1,838 124ms 0ms 04 3,479 210ms 0ms 05 4,054 252ms 0ms 06 3,980 228ms 0ms 07 2,969 176ms 0ms 08 3,417 261ms 0ms 09 5,723 511ms 0ms 10 7,554 725ms 0ms 11 6,847 602ms 0ms 12 13,639 1s878ms 0ms 13 13,065 2s618ms 0ms 14 16,188 3s440ms 0ms 15 12,104 1s406ms 0ms 16 6,850 576ms 0ms 17 1,774 109ms 0ms 18 5,890 469ms 0ms 19 4,111 410ms 0ms -
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109);
Date: 2025-03-21 14:28:05 Duration: 18ms
-
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109);
Date: 2025-03-21 14:07:55 Duration: 2ms
-
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (73);
Date: 2025-03-21 14:19:13 Duration: 1ms
20 123,977 23s879ms 0ms 3ms 0ms select rule_group_rel.rule_group_id, rule_group_rel.group_id from rule_group_rel, "res_groups" where ? = ? and rule_group_rel.rule_group_id in (...) and rule_group_rel.group_id = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 20 23 5,235 836ms 0ms Mar 21 00 6,378 938ms 0ms 01 2,972 367ms 0ms 02 2,369 280ms 0ms 03 1,472 169ms 0ms 04 1,145 140ms 0ms 05 1,233 160ms 0ms 06 1,192 150ms 0ms 07 1,275 162ms 0ms 08 3,714 494ms 0ms 09 6,510 939ms 0ms 10 6,002 1s35ms 0ms 11 4,461 743ms 0ms 12 10,041 2s268ms 0ms 13 12,622 3s716ms 0ms 14 20,790 6s9ms 0ms 15 14,671 2s502ms 0ms 16 8,029 1s31ms 0ms 17 2,163 239ms 0ms 18 6,777 897ms 0ms 19 4,926 795ms 0ms -
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2025-03-21 14:30:57 Duration: 3ms
-
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2025-03-21 15:35:22 Duration: 1ms
-
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2025-03-21 13:38:05 Duration: 1ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 726ms 23m50s 20s345ms 77 26m6s 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 (...)))))))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 20 23 12 16s371ms 1s364ms Mar 21 00 9 12s901ms 1s433ms 02 1 1s174ms 1s174ms 04 5 6s382ms 1s276ms 10 1 23m50s 23m50s 11 1 1s296ms 1s296ms 12 6 13s200ms 2s200ms 13 11 35s84ms 3s189ms 14 5 12s723ms 2s544ms 15 11 16s424ms 1s493ms 16 1 1s231ms 1s231ms 17 2 2s460ms 1s230ms 18 4 5s67ms 1s266ms 19 8 12s215ms 1s526ms -
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))) AND ("policy_number"."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 (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 10:54:19 Duration: 23m50s
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95))))))) 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 (95)))))) 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 (95)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))))) 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 (95))))))))) 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 (95)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 14:19:20 Duration: 3s588ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2414) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))))) 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 (51)))))) 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 (51)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) 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 (51))))))))) 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 (51)))))))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-03-21 13:21:39 Duration: 3s495ms
2 714ms 10s638ms 1s873ms 50,709 1d2h23m46s select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 20 23 3,729 1h11m17s 1s146ms Mar 21 00 1,796 31m16s 1s45ms 01 1,021 16m18s 958ms 02 484 7m25s 919ms 03 166 2m19s 842ms 04 186 2m47s 900ms 05 218 3m38s 1s1ms 06 284 4m35s 970ms 07 231 3m42s 964ms 08 586 9m12s 942ms 09 2,214 36m23s 986ms 10 3,895 1h15m32s 1s163ms 11 3,850 1h13m53s 1s151ms 12 4,937 2h57m24s 2s155ms 13 7,059 7h39m10s 3s902ms 14 6,275 6h14m1s 3s576ms 15 5,377 1h36m54s 1s81ms 16 2,680 37m16s 834ms 17 902 14m19s 952ms 18 1,981 33m31s 1s15ms 19 2,838 52m44s 1s114ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6613564, 6607005, 6606966, 6606911, 6601564, 6600074, 6105071, 6100068)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:36:14 Duration: 10s638ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6644590, 6644589, 6644588, 6644587, 6644586, 6644585, 6644584, 6644583)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:20:07 Duration: 10s404ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6641240, 6641204, 6641132, 6640984, 6640969, 6640893, 6640859, 6640853)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 13:14:52 Duration: 10s193ms
3 694ms 9s123ms 1s540ms 296,102 5d6h43m21s select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 20 23 18,631 6h5m 1s175ms Mar 21 00 14,353 4h12m44s 1s56ms 01 7,597 2h1m59s 963ms 02 8,209 1h55m32s 844ms 03 7,217 1h36m5s 798ms 04 10,968 2h24m27s 790ms 05 12,493 3h3m58s 883ms 06 12,739 3h10m50s 898ms 07 11,525 2h46m39s 867ms 08 11,861 3h5m4s 936ms 09 11,209 2h58m25s 955ms 10 15,912 4h55m58s 1s116ms 11 15,600 4h49m12s 1s112ms 12 26,500 13h15m24s 1s800ms 13 32,477 1d7h13m 3s460ms 14 30,322 1d1h15m15s 2s998ms 15 17,928 5h17m16s 1s61ms 16 7,138 1h39m21s 835ms 17 2,115 33m3s 937ms 18 7,350 2h3m45s 1s10ms 19 13,958 4h20m15s 1s118ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644889)) AND (("shipping_track"."id" not in (55460289, 55460289)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:36:47 Duration: 9s123ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644877)) AND (("shipping_track"."id" not in (55457825, 55457825)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:32:35 Duration: 9s108ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6644890)) AND (("shipping_track"."id" not in (55460425, 55460425)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-03-21 14:37:01 Duration: 9s100ms
4 938ms 3s305ms 1s269ms 26,325 9h16m50s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 20 23 2,938 1h10m29s 1s439ms Mar 21 00 2,786 1h22s 1s300ms 01 1,227 23m51s 1s166ms 02 1,032 19m20s 1s124ms 03 2,059 38m49s 1s131ms 04 1,659 31m24s 1s135ms 05 2,759 54m21s 1s182ms 06 2,778 54m51s 1s184ms 07 1,660 32m7s 1s160ms 08 2,458 49m48s 1s215ms 09 968 19m20s 1s198ms 10 1,037 24m6s 1s394ms 11 423 10m8s 1s439ms 12 269 8m25s 1s880ms 13 161 7m12s 2s687ms 14 285 11m27s 2s413ms 15 368 9m7s 1s488ms 16 72 1m24s 1s169ms 17 101 1m53s 1s122ms 18 335 6m45s 1s209ms 19 950 21m33s 1s361ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '484376')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:40:42 Duration: 3s305ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '319948')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:48:32 Duration: 3s264ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '369155')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:58:19 Duration: 3s240ms
5 920ms 3s49ms 1s239ms 6,697 2h18m19s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 20 23 2,360 52m48s 1s342ms Mar 21 00 751 15m19s 1s223ms 01 618 11m3s 1s73ms 02 309 5m30s 1s68ms 03 464 7m45s 1s2ms 04 249 4m16s 1s30ms 05 24 27s544ms 1s147ms 06 1 1s60ms 1s60ms 08 18 19s57ms 1s58ms 09 29 34s46ms 1s174ms 10 99 2m29s 1s513ms 11 9 10s159ms 1s128ms 12 25 50s637ms 2s25ms 13 37 1m28s 2s388ms 14 93 3m31s 2s269ms 15 134 2m52s 1s284ms 16 363 6m29s 1s74ms 17 18 19s398ms 1s77ms 18 473 8m47s 1s115ms 19 623 13m15s 1s276ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:09:45 Duration: 3s49ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '')) 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 (62))))))) 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 (62)))))) 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 (62)))))) 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 (62))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:07:14 Duration: 3s
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1314408')) AND ("policy_number"."package_id" = 2414)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))) 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 (60)))))) 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 (60)))))) 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 (60))))))))) ORDER BY "policy_number"."id";
Date: 2025-03-21 13:32:45 Duration: 2s915ms
6 304ms 6s773ms 1s213ms 2,151 43m29s select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 20 23 95 57s883ms 609ms Mar 21 00 85 44s317ms 521ms 01 49 22s417ms 457ms 02 37 13s886ms 375ms 03 34 12s436ms 365ms 04 51 18s839ms 369ms 05 56 25s638ms 457ms 06 53 24s239ms 457ms 07 62 27s502ms 443ms 08 73 35s462ms 485ms 09 120 1m 503ms 10 125 1m25s 687ms 11 139 1m29s 643ms 12 246 6m29s 1s581ms 13 304 14m54s 2s940ms 14 249 9m49s 2s369ms 15 152 1m43s 682ms 16 54 22s52ms 408ms 17 29 14s502ms 500ms 18 84 44s388ms 528ms 19 54 33s881ms 627ms -
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('1012658', '1012594', '1012411', '1012172', '1012837', '1012273', '1012843');
Date: 2025-03-21 13:40:27 Duration: 6s773ms
-
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('1313689', '1267731', '1124705', '1248349', '1202278', '1106480');
Date: 2025-03-21 13:41:07 Duration: 6s340ms
-
select po.id, policy.name from shipping_policy as po inner join policy_number as policy on policy.id = po.policy_id where policy.name in ('893573', '721583', '721759', '92033', '721567', '721479', '366859', '299893');
Date: 2025-03-21 14:32:24 Duration: 6s276ms
7 325ms 5s30ms 846ms 17,728 4h10m14s select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 21 08 585 4m46s 490ms 09 3,949 33m11s 504ms 10 2,957 28m17s 574ms 11 2,373 21m39s 547ms 12 2,616 38m34s 884ms 13 3,313 1h20m49s 1s463ms 14 1,695 40m15s 1s425ms 15 240 2m39s 665ms -
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" = '721583')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:32:38 Duration: 5s30ms
-
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" = '1003102')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:48:41 Duration: 4s936ms
-
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" = '721759')))) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:32:43 Duration: 4s922ms
8 271ms 3s94ms 753ms 8,306 1h44m17s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 20 23 128 53s317ms 416ms Mar 21 00 254 1m45s 414ms 01 27 10s128ms 375ms 02 33 11s610ms 351ms 04 4 1s96ms 274ms 05 271 1m33s 343ms 07 149 50s636ms 339ms 08 691 4m27s 386ms 09 183 1m11s 388ms 10 462 3m29s 453ms 11 1,018 6m38s 391ms 12 1,359 14m41s 648ms 13 1,484 30m3s 1s215ms 14 1,524 33m27s 1s317ms 15 624 4m10s 400ms 19 95 43s222ms 454ms -
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" = '1256105')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:32:36 Duration: 3s94ms
-
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" = '1081223')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:13:05 Duration: 3s80ms
-
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" = '1014079')) AND ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 13:53:10 Duration: 3s54ms
9 302ms 3s86ms 680ms 3,082 34m58s select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 21 08 463 2m52s 373ms 09 577 3m45s 390ms 10 415 2m52s 416ms 12 321 3m16s 612ms 13 326 6m38s 1s222ms 14 609 12m27s 1s226ms 15 371 3m4s 498ms -
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" = '1221381')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:31:57 Duration: 3s86ms
-
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" = '1022148')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:31:27 Duration: 3s60ms
-
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" = '1173172')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23, 112))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 13:45:58 Duration: 3s24ms
10 249ms 3s95ms 656ms 4,269 46m43s 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 #10
Day Hour Count Duration Avg duration Mar 20 23 40 16s240ms 406ms Mar 21 01 2 593ms 296ms 03 4 1s375ms 343ms 08 476 2m42s 342ms 09 709 4m16s 361ms 10 527 3m32s 403ms 11 34 14s325ms 421ms 12 605 6m38s 658ms 13 381 7m48s 1s229ms 14 849 16m9s 1s141ms 15 453 3m53s 515ms 16 61 20s372ms 333ms 17 44 15s910ms 361ms 18 54 19s546ms 361ms 19 30 14s181ms 472ms -
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" = '901400')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:32:14 Duration: 3s95ms
-
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" = '982035')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:37:04 Duration: 3s88ms
-
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" = '911889')) ORDER BY "cash_policy"."id" DESC;
Date: 2025-03-21 14:36:52 Duration: 3s73ms
11 236ms 3s127ms 607ms 18,377 3h6m2s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 20 23 1,013 7m38s 452ms Mar 21 00 1,611 10m47s 401ms 01 98 36s107ms 368ms 02 134 43s197ms 322ms 03 524 2m18s 264ms 04 196 54s649ms 278ms 05 54 18s307ms 339ms 06 663 3m55s 355ms 07 1,674 9m38s 345ms 08 1,676 10m26s 373ms 09 415 2m37s 379ms 10 1,560 11m42s 450ms 11 826 5m13s 379ms 12 1,716 15m52s 555ms 13 2,566 53m54s 1s260ms 14 1,775 36m46s 1s243ms 15 757 5m21s 424ms 16 373 1m59s 319ms 17 135 55s530ms 411ms 18 565 4m 424ms 19 46 23s529ms 511ms -
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" = '1225508')) 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 (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:37:11 Duration: 3s127ms
-
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" = '1212337')) 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 (64)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:28:33 Duration: 3s127ms
-
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" = '1254870')) 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 (1)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:27:48 Duration: 3s125ms
12 232ms 3s195ms 588ms 96,208 15h43m57s 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 #12
Day Hour Count Duration Avg duration Mar 20 23 1,914 13m56s 437ms Mar 21 00 2,942 19m40s 401ms 01 924 5m42s 370ms 02 1,160 5m44s 297ms 03 1,714 7m32s 264ms 04 3,358 15m18s 273ms 05 2,580 14m49s 344ms 06 3,172 18m55s 358ms 07 4,214 24m31s 349ms 08 4,552 28m8s 371ms 09 7,430 49m14s 397ms 10 8,672 1h3m6s 436ms 11 7,232 47m56s 397ms 12 11,658 2h32s 620ms 13 12,795 3h52m45s 1s91ms 14 9,509 3h5m56s 1s173ms 15 2,628 18m11s 415ms 16 599 3m10s 318ms 17 267 1m49s 409ms 18 7,762 57m56s 447ms 19 1,126 8m56s 476ms -
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" = '1032299')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 13:05:06 Duration: 3s195ms
-
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" = '1193126')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:27:24 Duration: 3s159ms
-
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" = '1250307')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 14:26:04 Duration: 3s156ms
13 122ms 1s437ms 454ms 5,522 41m47s 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 #13
Day Hour Count Duration Avg duration Mar 20 23 211 40s692ms 192ms Mar 21 00 183 29s559ms 161ms 01 141 21s434ms 152ms 02 21 3s61ms 145ms 03 15 1s997ms 133ms 04 105 14s470ms 137ms 05 42 6s157ms 146ms 06 30 4s587ms 152ms 08 85 12s971ms 152ms 09 115 20s243ms 176ms 10 358 1m24s 234ms 11 566 2m10s 230ms 12 1,136 9m59s 528ms 13 637 10m24s 980ms 14 735 10m59s 897ms 15 661 3m 272ms 16 185 26s11ms 140ms 17 74 10s808ms 146ms 18 124 20s42ms 161ms 19 98 17s183ms 175ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 8)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 13:31:16 Duration: 1s437ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 14:26:09 Duration: 1s409ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 7)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-03-21 14:34:14 Duration: 1s379ms
14 125ms 1s289ms 334ms 14,147 1h18m47s select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 20 23 1,523 5m30s 216ms Mar 21 00 817 2m31s 185ms 01 209 37s122ms 177ms 02 6 1s336ms 222ms 08 45 7s452ms 165ms 09 372 1m5s 174ms 10 1,080 3m38s 202ms 11 831 3m7s 226ms 12 1,515 9m24s 372ms 13 2,249 24m16s 647ms 14 1,795 17m42s 591ms 15 1,339 4m9s 186ms 16 640 1m33s 146ms 17 218 34s510ms 158ms 18 334 54s896ms 164ms 19 1,174 3m32s 180ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8405070)) AND (("cash_track"."id" not in (9899240)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 14:35:28 Duration: 1s289ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8404403)) AND (("cash_track"."id" not in (9896296)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 13:47:32 Duration: 1s287ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (8404537)) AND (("cash_track"."id" not in (9896759)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-03-21 13:57:16 Duration: 1s279ms
15 0ms 12m58s 269ms 33,080 2h28m29s update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 20 23 5,275 19m29s 221ms Mar 21 00 3,529 15m19s 260ms 01 1,836 396ms 0ms 02 1,332 309ms 0ms 03 2,488 508ms 0ms 04 1,891 355ms 0ms 05 2,737 585ms 0ms 06 2,720 1h52m40s 2s485ms 07 1,646 310ms 0ms 08 2,446 515ms 0ms 09 999 229ms 0ms 10 1,150 345ms 0ms 11 466 158ms 0ms 12 346 153ms 0ms 13 256 50s871ms 198ms 14 420 200ms 0ms 15 542 186ms 0ms 16 452 119ms 0ms 17 131 32ms 0ms 18 821 4s827ms 5ms 19 1,597 460ms 0ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:12:43.510726', "write_uid" = 1088 WHERE id IN (45387940);
Date: 2025-03-21 06:25:45 Duration: 12m58s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:00.870848', "write_uid" = 1088 WHERE id IN (45387940);
Date: 2025-03-21 06:18:41 Duration: 12m38s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-21 05:06:58.858871', "write_uid" = 1088 WHERE id IN (45330808);
Date: 2025-03-21 06:19:35 Duration: 12m34s
16 92ms 1s94ms 262ms 65,167 4h45m7s 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 #16
Day Hour Count Duration Avg duration Mar 20 23 10,478 51m49s 296ms Mar 21 00 7,016 30m32s 261ms 01 3,652 14m50s 243ms 02 2,664 8m56s 201ms 03 4,982 17m28s 210ms 04 3,780 14m2s 222ms 05 5,476 22m6s 242ms 06 5,468 22m44s 249ms 07 3,294 12m27s 226ms 08 4,891 18m28s 226ms 09 1,956 7m49s 239ms 10 2,211 10m40s 289ms 11 843 4m24s 313ms 12 574 4m37s 483ms 13 370 4m38s 753ms 14 742 8m 648ms 15 972 4m37s 285ms 16 846 3m1s 214ms 17 234 54s504ms 232ms 18 1,594 6m22s 240ms 19 3,124 16m31s 317ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ايه ايه ايه ايه')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 14:08:53 Duration: 1s94ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياموت')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 13:32:36 Duration: 1s71ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'شركة 99-99')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-03-21 13:58:20 Duration: 1s54ms
17 187ms 504ms 251ms 14,250 59m41s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 20 23 196 57s352ms 292ms Mar 21 00 969 4m31s 280ms 01 695 3m2s 262ms 02 955 3m49s 240ms 03 1,072 4m9s 232ms 04 2,598 10m23s 239ms 05 2,018 8m7s 241ms 06 2,381 10m 252ms 07 1,913 7m57s 249ms 08 925 4m10s 270ms 09 528 2m31s 286ms -
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" = '1041830')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 05:00:29 Duration: 504ms
-
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" = '1270964')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 02:28:19 Duration: 432ms
-
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" = '1003967')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-03-21 02:00:27 Duration: 425ms
18 62ms 562ms 149ms 44,382 1h50m22s select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) and ("collection_policy"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 20 23 107 11s23ms 103ms Mar 21 00 29 2s824ms 97ms 08 1,037 1m26s 83ms 09 5,934 8m46s 88ms 10 6,634 10m57s 99ms 11 4,219 6m49s 97ms 12 5,285 12m9s 138ms 13 9,024 30m52s 205ms 14 10,846 36m51s 203ms 15 1,267 2m15s 106ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6509206) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:28:05 Duration: 562ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6401321) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:08:57 Duration: 531ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 6415447) AND ("collection_policy"."state" = 'draft')) AND ("collection_policy"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 23)))) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:23:20 Duration: 528ms
19 56ms 423ms 117ms 18,644 36m25s 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 Mar 21 08 474 34s388ms 72ms 09 3,425 4m39s 81ms 10 3,718 5m21s 86ms 11 2,065 3m8s 91ms 12 2,855 5m43s 120ms 13 4,209 12m18s 175ms 14 1,432 3m55s 164ms 15 466 44s152ms 94ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6550885) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:55:33 Duration: 423ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6280866) ORDER BY "collection_policy"."id";
Date: 2025-03-21 13:46:06 Duration: 422ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 6345321) ORDER BY "collection_policy"."id";
Date: 2025-03-21 14:07:09 Duration: 421ms
20 49ms 670ms 110ms 163,891 5h2m16s 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 Mar 20 23 10,544 15m1s 85ms Mar 21 00 8,513 11m2s 77ms 01 4,032 4m50s 72ms 02 3,800 4m12s 66ms 03 2,898 2m53s 59ms 04 4,242 4m17s 60ms 05 3,837 4m19s 67ms 06 4,535 5m10s 68ms 07 2,796 3m8s 67ms 08 4,074 4m52s 71ms 09 7,708 9m35s 74ms 10 10,960 15m37s 85ms 11 11,568 16m31s 85ms 12 18,066 39m22s 130ms 13 17,590 1h3m2s 215ms 14 19,345 1h1m12s 189ms 15 12,853 17m5s 79ms 16 5,374 5m42s 63ms 17 1,813 2m8s 70ms 18 4,469 5m31s 74ms 19 4,874 6m37s 81ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6539431, 6539393, 6539387, 6539314, 6535616, 6511899, 6127287)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:51:11 Duration: 670ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6557880, 6550617, 6474886, 6405734, 6405733, 6401442, 6342830, 6314614)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 14:49:04 Duration: 629ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (6613564, 6607005, 6606966, 6606911, 6601564, 6600074, 6105071, 6100068)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-03-21 13:36:21 Duration: 625ms
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
- 15,843,083 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 3378 FATAL entries
- 498 ERROR entries
- 0 WARNING entries
- 562 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 1,497 Max number of times the same event was reported
- 4,438 Total events found
Rank Times reported Error 1 1,497 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 21 02 360 05 182 08 167 11 258 14 312 17 218 - 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-03-21 02:20:02
Statement: SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '1284260')) AND ("policy_number"."package_id" = 2414)) AND ("policy_number"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false )) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false )) AND (("policy_number"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id"
Date: 2025-03-21 02:20:02
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6595729)) AND (("shipping_track"."id" not in (54964911, 54965198, 54965839, 55329584, 55329584)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-03-21 08:00:07
2 1,201 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 21 02 116 05 38 08 69 11 271 14 616 17 91 3 449 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 21 13 167 14 282 - FATAL: connection to client lost
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6643616, 6642909, 6636273, 6628512, 6628506, 6628341, 6627695, 6627691, 6627681, 6627623, 6627572, 6627568, 6627541, 6627529, 6627514, 6627484, 6627465, 6627455, 6622888, 6622814, 6622222, 6619867, 6619634, 6617704, 6616379, 6616091, 6614770, 6614725, 6612863, 6612422, 6611879, 6607659, 6606280, 6605892, 6604950, 6604916, 6604334, 6604200, 6601581, 6601332, 6600928, 6598818, 6598100, 6597982, 6584078, 6579830, 6579376, 6577897, 6574847, 6573570, 6573565, 6570475, 6568763, 6567323, 6565433, 6563563, 6560682, 6555462, 6553215, 6549088, 6380533, 6278122)) ORDER BY "shipping_track"."id"
Date: 2025-03-21 14:03:17
4 449 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 21 13 167 14 282 - LOG: could not send data to client: Broken pipe
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (6643616, 6642909, 6636273, 6628512, 6628506, 6628341, 6627695, 6627691, 6627681, 6627623, 6627572, 6627568, 6627541, 6627529, 6627514, 6627484, 6627465, 6627455, 6622888, 6622814, 6622222, 6619867, 6619634, 6617704, 6616379, 6616091, 6614770, 6614725, 6612863, 6612422, 6611879, 6607659, 6606280, 6605892, 6604950, 6604916, 6604334, 6604200, 6601581, 6601332, 6600928, 6598818, 6598100, 6597982, 6584078, 6579830, 6579376, 6577897, 6574847, 6573570, 6573565, 6570475, 6568763, 6567323, 6565433, 6563563, 6560682, 6555462, 6553215, 6549088, 6380533, 6278122)) ORDER BY "shipping_track"."id"
Date: 2025-03-21 14:03:17
5 342 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #5
Day Hour Count Mar 20 23 9 Mar 21 00 5 02 6 03 3 04 6 05 2 06 16 07 4 08 2 09 9 10 17 11 18 12 30 13 99 14 61 15 12 16 3 18 9 19 31 - 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 "shipping_policy" SET "cash_policy_id" = 8400213, "client_delivery_button" = false, "edit_cash_button" = false, "return_button" = true, "write_date" = '2025-03-20 22:20:18.682262', "write_uid" = 1025 WHERE id IN (6579039)
Date: 2025-03-20 23:21:48
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 22:28:42.453809', "write_uid" = 903 WHERE id IN (45053728)
Date: 2025-03-20 23:30:18
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-03-20 22:31:17.025747', "write_uid" = 975 WHERE id IN (45238155)
Date: 2025-03-20 23:32:06
6 178 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Mar 21 02 24 05 12 08 12 11 12 14 118 - FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6525023)) AND (("shipping_track"."id" not in (54427621, 54430858, 54508134, 54508441, 55080037, 55093645, 55266416, 55266416)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-03-21 02:00:06
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6584427)) AND (("shipping_track"."id" not in (54884460, 54885444, 55094472, 55094901, 55165131, 55266275, 55266415, 55266415)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-03-21 02:00:06
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-03-21 02:20:02
7 70 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #7
Day Hour Count Mar 21 13 27 14 30 15 5 16 7 19 1 8 66 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Mar 21 02 5 05 3 08 2 11 3 14 53 - ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6525023)) AND (("shipping_track"."id" not in (54427621, 54430858, 54508134, 54508441, 55080037, 55093645, 55266416, 55266416)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-03-21 02:00:06
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (6584427)) AND (("shipping_track"."id" not in (54884460, 54885444, 55094472, 55094901, 55165131, 55266275, 55266415, 55266415)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-03-21 02:00:06
Context: parallel worker
Statement: SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '964295')) 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" DESCDate: 2025-03-21 02:20:02
9 56 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Mar 20 23 1 Mar 21 00 3 01 2 05 1 09 2 10 2 11 1 12 9 13 7 14 5 15 9 16 3 18 6 19 5 - ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 162
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('1206020',)
Date: 2025-03-20 23:50:49
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('1091594',)
Date: 2025-03-21 00:44:56
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('974982',)
Date: 2025-03-21 00:53:10
10 34 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #10
Day Hour Count Mar 21 13 14 14 18 19 2 11 18 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Mar 21 00 1 04 1 06 1 08 1 10 1 13 1 15 4 17 1 18 6 19 1 - FATAL: password authentication failed for user "postgres"
Detail: User "postgres" has no password assigned. Connection matched file "/var/lib/pgsql/16/data/pg_hba.conf" line 123: "host all all all scram-sha-256"
Date: 2025-03-21 00:15:26
12 17 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #12
Day Hour Count Mar 21 10 5 11 1 12 3 13 5 15 3 - ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM "delegate_track" WHERE id IN (208800)
Date: 2025-03-21 10:36:07
Statement: DELETE FROM "delegate_track" WHERE id IN (208817)
Date: 2025-03-21 10:36:07
Statement: DELETE FROM "delegate_track" WHERE id IN (208828)
Date: 2025-03-21 10:37:47
13 14 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #13
Day Hour Count Mar 21 10 1 11 1 12 3 13 4 14 5 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 892686 waits for ShareLock on transaction 11440258; blocked by process 602354. Process 602354 waits for ShareLock on transaction 11440250; blocked by process 892686. Process 892686: update shipping_policy set count_search=1 where id=6643352 Process 602354: UPDATE "shipping_policy" SET "destination_type" = 'warehouse', "last_action" = '2025-03-21', "last_car" = 13, "last_driver" = 8007152, "last_office" = NULL, "last_office_warehouse" = 11, "last_warehouse" = 28, "state" = 'in_way', "write_date" = '2025-03-21 09:30:29.062656', "write_uid" = 1204 WHERE id IN (6643332, 6643328, 6643282, 6643280)
Context: while updating tuple (485,4) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=1 where id=6643352Date: 2025-03-21 10:30:59
Detail: Process 1203799 waits for ShareLock on transaction 11443315; blocked by process 1203904. Process 1203904 waits for ShareLock on transaction 11443327; blocked by process 1203799. Process 1203799: DELETE FROM "delegate_track" WHERE id IN (206209) Process 1203904: DELETE FROM "delegate_track" WHERE id IN (206235)
Context: while deleting tuple (9,44) in relation "delegate_track"
Hint: See server log for query details.
Statement: DELETE FROM "delegate_track" WHERE id IN (206209)Date: 2025-03-21 11:24:17
Detail: Process 1203826 waits for ShareLock on transaction 11445337; blocked by process 1203763. Process 1203763 waits for ShareLock on transaction 11445277; blocked by process 1203826. Process 1203826: update shipping_policy set count_search=2 where id=6479687 Process 1203763: UPDATE "shipping_policy" SET "before_office_id" = 22, "write_date" = '2025-03-21 11:03:28.572548', "write_uid" = 1300 WHERE id IN (6565237, 6569664, 6572947, 6573635, 6582324, 6582489, 6584012, 6584013, 6584084, 6643655, 6479687, 6533611, 6623738, 6628735, 6628797, 6632120, 6637676, 6641784, 6597498, 6597725, 6598324, 6599554, 6599757, 6600941, 6601532, 6601637, 6602491, 6605346, 6610527, 6610745, 6611718, 6611783, 6612855, 6613731, 6619279, 6620597, 6622126)
Context: while updating tuple (141974,1) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=2 where id=6479687Date: 2025-03-21 12:03:34
14 11 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #14
Day Hour Count Mar 21 02 2 14 6 17 3 15 9 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #15
Day Hour Count Mar 20 23 1 Mar 21 02 2 05 1 08 1 11 1 14 2 17 1 16 6 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #16
Day Hour Count Mar 21 03 1 05 1 06 1 07 1 09 1 15 1 17 5 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #17
Day Hour Count Mar 21 05 1 06 1 07 1 09 1 15 1 18 5 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #18
Day Hour Count Mar 21 05 1 06 1 07 1 09 1 15 1 19 4 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #19
Day Hour Count Mar 21 17 2 18 2 20 2 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #20
Day Hour Count Mar 21 07 1 13 1 - ERROR: null value in column "code" of relation "res_country_state" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
Detail: Failing row contains (4564, 65, 1196, 1196, سويس, null, 2025-03-21 06:42:43.309503, 2025-03-21 06:42:43.309503).
Statement: INSERT INTO "res_country_state" ("country_id", "create_date", "create_uid", "name", "write_date", "write_uid") VALUES (65, '2025-03-21 06:42:43.309503', 1196, 'سويس', '2025-03-21 06:42:43.309503', 1196) RETURNING "id"Date: 2025-03-21 07:42:43
Detail: Failing row contains (5571935, null, 825, 825, null, كوبرا, null, null, t, 2025-03-21 12:13:02.584019, 2025-03-21 12:13:02.584019, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-03-21 12:13:02.584019', 825, 'كوبرا', '2025-03-21 12:13:02.584019', 825) RETURNING "id"Date: 2025-03-21 13:13:02
21 2 FATAL: canceling authentication due to timeout
Times Reported Most Frequent Error / Event #21
Day Hour Count Mar 21 08 1 14 1 22 1 FATAL: unsupported frontend protocol 65107.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #22
Day Hour Count Mar 21 07 1 23 1 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #23
Day Hour Count Mar 21 13 1 - ERROR: column urgent_office.is_no_change_office does not exist at character 574
Statement: SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."is_no_change_office" AS "is_no_change_office", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (39)
Date: 2025-03-21 13:33:33
24 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #24
Day Hour Count Mar 21 15 1