pgBadger-
Global information
- Generated on Wed Jan 15 23:47:39 2025
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 46,357,629 log entries in 2m38s
- Log start from 2025-01-15 00:00:00 to 2025-01-15 22:45:01
-
Overview
Global Stats
- 20,464 Number of unique normalized queries
- 19,907,619 Number of queries
- 6d9h32m38s Total query duration
- 2025-01-15 00:00:00 First query
- 2025-01-15 22:45:01 Last query
- 7,197 queries/s at 2025-01-15 14:14:12 Query peak
- 6d9h32m38s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6d9h32m38s Execute total duration
- 5,980 Number of events
- 22 Number of unique normalized events
- 2,310 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
- 19,907,619 Average queries per session
- 6d9h32m38s 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
- 7,197 queries/s Query Peak
- 2025-01-15 14:14:12 Date
SELECT Traffic
Key values
- 4,645 queries/s Query Peak
- 2025-01-15 14:14:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,739 queries/s Query Peak
- 2025-01-15 14:14:12 Date
Queries duration
Key values
- 6d9h32m38s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 00 364,851 0ms 8m31s 50ms 8m43s 10m35s 15m1s 01 277,664 0ms 4m54s 30ms 4m5s 4m28s 7m44s 02 265,119 0ms 1m2s 31ms 4m34s 4m52s 6m28s 03 255,275 0ms 59m56s 51ms 3m36s 4m8s 1h36m18s 04 236,492 0ms 1m15s 31ms 4m1s 4m27s 5m36s 05 174,295 0ms 932ms 25ms 2m19s 3m 3m16s 06 232,836 0ms 944ms 17ms 2m14s 3m4s 3m17s 07 227,690 0ms 4s486ms 19ms 2m22s 3m21s 3m47s 08 481,562 0ms 3s977ms 9ms 2m38s 3m15s 3m51s 09 1,070,958 0ms 4s830ms 14ms 6m10s 6m41s 7m21s 10 1,345,900 0ms 31m8s 37ms 6m21s 7m27s 5h36m18s 11 1,737,242 0ms 22m58s 37ms 8m45s 1h26m35s 7h34m4s 12 2,061,114 0ms 18m6s 21ms 7m 48m47s 3h44m18s 13 1,517,055 0ms 14m43s 31ms 6m42s 1h8m2s 4h20m3s 14 1,430,584 0ms 17m31s 19ms 4m52s 5m28s 4h10m44s 15 2,291,045 0ms 11m34s 15ms 7m53s 1h40m37s 2h36m32s 16 1,230,609 0ms 14m52s 15ms 8m40s 9m51s 19m32s 17 1,184,160 0ms 4s785ms 15ms 8m37s 9m52s 10m51s 18 990,985 0ms 47m10s 64ms 7m38s 9m35s 11h2m34s 19 824,340 0ms 3m30s 20ms 7m30s 8m5s 11m35s 20 735,922 0ms 12m27s 46ms 11m34s 12m17s 3h25m18s 21 605,898 0ms 2m31s 31ms 9m35s 10m22s 10m26s 22 366,023 0ms 1h1s 61ms 3m44s 4m52s 2h48m41s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 00 209,600 0 52ms 4m15s 4m35s 5m2s 01 150,362 0 52ms 3m7s 3m47s 4m27s 02 141,715 0 58ms 3m26s 4m34s 5m14s 03 132,258 0 57ms 3m10s 3m34s 4m30s 04 127,510 0 57ms 2m58s 3m41s 4m27s 05 85,648 0 52ms 1m48s 2m18s 3m10s 06 125,259 0 31ms 1m33s 2m14s 3m14s 07 130,447 0 33ms 2m12s 2m22s 3m43s 08 289,350 0 15ms 1m48s 2m37s 3m31s 09 622,606 0 24ms 5m40s 6m9s 6m49s 10 811,770 0 15ms 4m45s 5m55s 6m28s 11 1,072,643 0 15ms 6m14s 7m2s 8m38s 12 1,233,776 0 12ms 5m23s 5m51s 7m1s 13 911,777 0 14ms 4m53s 5m56s 6m40s 14 839,451 0 14ms 4m33s 4m50s 5m27s 15 1,465,474 0 9ms 4m50s 5m59s 14m7s 16 697,909 0 26ms 7m33s 8m25s 9m50s 17 702,665 0 25ms 7m23s 8m35s 10m10s 18 582,873 0 31ms 6m12s 7m17s 8m22s 19 477,887 0 33ms 5m38s 6m21s 8m3s 20 426,879 0 48ms 8m21s 11m7s 12m16s 21 359,099 0 52ms 7m51s 9m30s 10m21s 22 216,652 0 24ms 2m46s 3m16s 4m51s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 15 00 43,310 8,315 138 0 142ms 2m46s 3m27s 5m59s 01 29,462 6,723 139 0 14ms 173ms 220ms 1m28s 02 27,380 6,971 143 0 2ms 171ms 258ms 9s317ms 03 23,974 6,890 145 0 181ms 168ms 242ms 38s966ms 04 26,229 6,627 131 0 2ms 157ms 241ms 410ms 05 12,120 4,364 154 0 0ms 84ms 118ms 159ms 06 15,049 4,124 211 0 0ms 85ms 105ms 136ms 07 16,535 4,100 134 0 0ms 113ms 153ms 248ms 08 16,561 5,753 286 0 0ms 105ms 141ms 177ms 09 53,507 17,669 806 0 0ms 303ms 363ms 452ms 10 55,642 17,058 580 0 504ms 335ms 382ms 26s482ms 11 73,797 20,624 696 2 505ms 466ms 592ms 1h24m57s 12 67,239 19,504 678 0 326ms 405ms 487ms 45m31s 13 59,072 18,991 633 1 434ms 387ms 453ms 1h6m47s 14 57,298 19,165 441 0 195ms 341ms 405ms 567ms 15 56,316 20,736 990 0 292ms 346ms 457ms 1h37m2s 16 68,501 20,862 934 0 14ms 467ms 552ms 1m40s 17 65,178 21,281 654 0 0ms 515ms 606ms 778ms 18 65,767 18,783 506 0 536ms 429ms 510ms 1m58s 19 55,010 14,454 623 0 12ms 383ms 537ms 2m54s 20 64,701 23,276 380 0 148ms 514ms 1s43ms 3m11s 21 63,022 14,002 347 0 3ms 414ms 516ms 683ms 22 32,071 6,679 381 0 436ms 280ms 394ms 1h56m41s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% Day Hour Count Average / Second Jan 15 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s Day Hour Count Average Duration Average idle time Jan 15 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 60,697 buffers Checkpoint Peak
- 2025-01-15 13:31:21 Date
- 270.059 seconds Highest write time
- 0.016 seconds Sync time
Checkpoints Wal files
Key values
- 24 files Wal files usage Peak
- 2025-01-15 13:31:21 Date
Checkpoints distance
Key values
- 762.81 Mo Distance Peak
- 2025-01-15 13:31:21 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 15 00 160,854 3,239.579s 0.036s 3,239.671s 01 126,839 3,239.548s 0.032s 3,239.621s 02 150,056 3,239.584s 0.032s 3,239.665s 03 150,094 3,239.543s 0.032s 3,239.635s 04 138,951 3,239.532s 0.034s 3,239.617s 05 122,921 3,239.574s 0.028s 3,239.645s 06 133,604 3,239.541s 0.033s 3,239.632s 07 112,778 2,974.572s 0.029s 2,974.639s 08 116,864 3,132.391s 0.041s 3,132.473s 09 374,890 3,239.608s 0.045s 3,239.723s 10 398,983 3,239.546s 0.039s 3,239.654s 11 499,683 3,239.46s 0.059s 3,239.595s 12 531,544 3,239.593s 0.057s 3,239.733s 13 462,391 3,239.427s 0.049s 3,239.549s 14 425,927 3,239.527s 0.046s 3,239.643s 15 351,323 3,239.576s 0.058s 3,239.694s 16 435,818 3,239.592s 0.051s 3,239.719s 17 337,272 2,890.497s 0.081s 2,890.65s 18 306,363 3,239.479s 0.05s 3,239.611s 19 291,032 3,239.491s 0.053s 3,239.614s 20 253,599 3,239.539s 0.047s 3,239.651s 21 278,964 3,239.546s 0.045s 3,239.66s 22 143,195 2,429.684s 0.039s 2,429.762s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 15 00 0 0 68 3,672 0.002s 0.012s 01 0 0 56 2,920 0.002s 0.012s 02 0 0 62 2,979 0.002s 0.012s 03 0 0 64 2,842 0.002s 0.012s 04 0 0 61 2,784 0.006s 0.012s 05 0 0 49 2,578 0.002s 0.012s 06 0 0 52 3,003 0.002s 0.012s 07 0 0 44 2,904 0.002s 0.012s 08 0 0 44 3,489 0.010s 0.012s 09 0 0 143 4,916 0.002s 0.012s 10 0 0 160 5,152 0.002s 0.012s 11 0 0 200 5,231 0.002s 0.012s 12 0 0 217 5,177 0.002s 0.012s 13 0 0 184 5,278 0.003s 0.012s 14 0 0 178 5,511 0.002s 0.012s 15 0 0 141 5,664 0.004s 0.012s 16 0 0 181 5,618 0.002s 0.012s 17 0 0 139 5,585 0.011s 0.012s 18 0 0 134 5,247 0.002s 0.012s 19 0 0 123 5,038 0.002s 0.012s 20 0 0 111 4,932 0.002s 0.012s 21 0 0 122 4,702 0.003s 0.012s 22 0 0 63 3,574 0.003s 0.009s Day Hour Count Avg time (sec) Jan 15 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s Day Hour Mean distance Mean estimate Jan 15 00 92,828.67 kB 130,660.67 kB 01 75,589.33 kB 116,644.33 kB 02 85,960.08 kB 120,155.83 kB 03 87,199.08 kB 119,079.33 kB 04 82,948.17 kB 111,861.75 kB 05 64,890.09 kB 98,440.27 kB 06 70,607.75 kB 100,827.00 kB 07 60,043.33 kB 91,887.42 kB 08 60,337.67 kB 87,312.08 kB 09 195,646.92 kB 227,402.92 kB 10 218,492.25 kB 259,388.58 kB 11 264,596.30 kB 301,689.80 kB 12 299,106.60 kB 343,831.50 kB 13 251,310.00 kB 330,242.67 kB 14 242,438.75 kB 312,644.25 kB 15 197,920.27 kB 254,019.64 kB 16 246,121.92 kB 297,738.92 kB 17 190,970.75 kB 254,676.92 kB 18 181,652.75 kB 224,175.00 kB 19 168,746.58 kB 195,391.83 kB 20 151,028.67 kB 184,429.92 kB 21 167,420.42 kB 207,875.00 kB 22 113,208.67 kB 187,384.22 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Average Autovacuum Duration
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
Average Autovacuum Duration (5 minutes average)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 15 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 11,813,610 Total read queries
- 5,519,087 Total write queries
Queries by database
Key values
- unknown Main database
- 19,907,619 Requests
- 6d9h32m38s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 19,907,619 Requests
User Request type Count Duration unknown Total 19,907,619 6d9h32m38s copy from 3 0ms cte 22,793 4s934ms ddl 1,458 202ms delete 10,130 11s476ms insert 1,047,741 5m29s others 2,574,922 2m5s select 11,813,610 3d4h19m25s tcl 4,130,011 2m39s update 306,951 3d5h2m41s Duration by user
Key values
- 6d9h32m38s (unknown) Main time consuming user
User Request type Count Duration unknown Total 19,907,619 6d9h32m38s copy from 3 0ms cte 22,793 4s934ms ddl 1,458 202ms delete 10,130 11s476ms insert 1,047,741 5m29s others 2,574,922 2m5s select 11,813,610 3d4h19m25s tcl 4,130,011 2m39s update 306,951 3d5h2m41s Queries by host
Key values
- unknown Main host
- 19,907,619 Requests
- 6d9h32m38s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 19,907,619 Requests
- 6d9h32m38s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2025-01-15 06:05:39 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 18,646,757 0-1ms duration
Slowest individual queries
Rank Duration Query 1 1h1s update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949180', exp_date = '2025-01-15 21:24:32.949184', logged_in = 'TRUE' where id = 870;[ Date: 2025-01-15 22:39:34 ]
2 1h1s update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949188', exp_date = '2025-01-15 21:24:32.949190', logged_in = 'TRUE' where id = 870;[ Date: 2025-01-15 22:39:34 ]
3 59m59s UPDATE "res_users" SET "exp_date" = '2025-01-15 21:01:03.912132', "last_update" = '2025-01-15 20:16:03.912171', "write_date" = '2025-01-15 20:16:03.489562', "write_uid" = 1 WHERE id IN (1229);[ Date: 2025-01-15 22:16:03 ]
4 59m56s UPDATE "res_users" SET "exp_date" = '2025-01-15 02:24:58.367642', "last_update" = '2025-01-15 01:39:58.367662', "write_date" = '2025-01-15 01:39:58.046667', "write_uid" = 1 WHERE id IN (1053);[ Date: 2025-01-15 03:39:54 ]
5 56m42s update res_users set sid = '5029a0aa891187345599bf82a70ab2c6fa0b902f', last_update = '2025-01-15 20:19:21.196181', exp_date = '2025-01-15 21:04:21.196185', logged_in = 'TRUE' where id = 1229;[ Date: 2025-01-15 22:16:03 ]
6 47m10s update res_users set sid = 'a1fc21f38adf04bf2bf1ad5d1a8c7ba22fab3e0e', last_update = '2025-01-15 16:49:10.724768', exp_date = '2025-01-15 17:34:10.724773', logged_in = 'TRUE' where id = 1363;[ Date: 2025-01-15 18:36:21 ]
7 47m10s update res_users set sid = 'a1fc21f38adf04bf2bf1ad5d1a8c7ba22fab3e0e', last_update = '2025-01-15 16:49:10.724269', exp_date = '2025-01-15 17:34:10.724274', logged_in = 'TRUE' where id = 1363;[ Date: 2025-01-15 18:36:21 ]
8 46m12s update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:53:21.793972', exp_date = '2025-01-15 21:38:21.793975', logged_in = 'TRUE' where id = 870;[ Date: 2025-01-15 22:39:34 ]
9 41m33s update res_users set sid = 'a1fc21f38adf04bf2bf1ad5d1a8c7ba22fab3e0e', last_update = '2025-01-15 16:54:47.718156', exp_date = '2025-01-15 17:39:47.718160', logged_in = 'TRUE' where id = 1363;[ Date: 2025-01-15 18:36:21 ]
10 40m42s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:55:38.565765', exp_date = '2025-01-15 17:40:38.565771', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
11 40m42s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:55:38.566287', exp_date = '2025-01-15 17:40:38.566291', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
12 39m7s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:57:13.872103', exp_date = '2025-01-15 17:42:13.872108', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
13 39m5s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:57:16.129070', exp_date = '2025-01-15 17:42:16.129073', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
14 39m3s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:57:18.185837', exp_date = '2025-01-15 17:42:18.185839', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
15 39m update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:57:21.201545', exp_date = '2025-01-15 17:42:21.201547', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
16 38m57s update res_users set sid = 'f055d98a0e40b23f4a19054b3dfb84d8b442eb53', last_update = '2025-01-15 16:57:23.728761', exp_date = '2025-01-15 17:42:23.728764', logged_in = 'TRUE' where id = 932;[ Date: 2025-01-15 18:36:21 ]
17 31m24s UPDATE "res_users" SET "exp_date" = '2025-01-15 02:53:30.578086', "last_update" = '2025-01-15 02:08:30.578108', "sid" = '1450830fbaf7359b85a8818bf78e3c665d1dc87d', "write_date" = '2025-01-15 02:08:30.256425', "write_uid" = 1053 WHERE id IN (1053);[ Date: 2025-01-15 03:39:54 ]
18 31m8s update res_users set sid = '457d420049498adeef457524674e903d6a3f8f76', last_update = '2025-01-15 08:36:12.273554', exp_date = '2025-01-15 09:21:12.273557', logged_in = 'TRUE' where id = 833;[ Date: 2025-01-15 10:07:20 ]
19 31m8s update res_users set sid = '457d420049498adeef457524674e903d6a3f8f76', last_update = '2025-01-15 08:36:12.273256', exp_date = '2025-01-15 09:21:12.273259', logged_in = 'TRUE' where id = 833;[ Date: 2025-01-15 10:07:20 ]
20 30m56s update res_users set sid = '415d9a56f6f0234a155ccf82b4699a186f8472c2', last_update = '2025-01-15 09:07:23.850356', exp_date = '2025-01-15 09:52:23.850358', logged_in = 'TRUE' where id = 1102;[ Date: 2025-01-15 10:38:20 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3d21m4s 68,092 0ms 1h1s 3s825ms update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 00 883 1h3m11s 4s293ms 01 1,026 226ms 0ms 02 952 15s617ms 16ms 03 1,185 53s220ms 44ms 04 808 175ms 0ms 05 783 165ms 0ms 06 765 157ms 0ms 07 601 127ms 0ms 08 1,734 361ms 0ms 09 4,451 1s12ms 0ms 10 5,693 9h58m29s 6s307ms 11 6,906 13h16m36s 6s921ms 12 6,395 7h55m50s 4s464ms 13 5,951 9h18m34s 5s631ms 14 5,453 4h9m26s 2s744ms 15 5,197 6h17m6s 4s353ms 16 4,354 20m2s 276ms 17 4,143 1s143ms 0ms 18 3,196 12h37m49s 14s227ms 19 2,687 13m55s 311ms 20 2,159 3h20m49s 5s580ms 21 1,688 3m52s 137ms 22 1,082 3h44m7s 12s428ms -
update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949180', exp_date = '2025-01-15 21:24:32.949184', logged_in = 'TRUE' where id = 870;
Date: 2025-01-15 22:39:34 Duration: 1h1s
-
update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949188', exp_date = '2025-01-15 21:24:32.949190', logged_in = 'TRUE' where id = 870;
Date: 2025-01-15 22:39:34 Duration: 1h1s
-
update res_users set sid = '5029a0aa891187345599bf82a70ab2c6fa0b902f', last_update = '2025-01-15 20:19:21.196181', exp_date = '2025-01-15 21:04:21.196185', logged_in = 'TRUE' where id = 1229;
Date: 2025-01-15 22:16:03 Duration: 56m42s
2 1d16h52m15s 261,919 475ms 4s451ms 561ms select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 00 10,536 1h37m8s 553ms 01 9,359 1h23m37s 536ms 02 8,325 1h14m32s 537ms 03 9,192 1h20m38s 526ms 04 7,888 1h10m10s 533ms 05 5,781 49m1s 508ms 06 4,725 40m28s 514ms 07 4,519 40m8s 532ms 08 4,501 38m46s 516ms 09 14,073 2h8m5s 546ms 10 13,310 2h31s 543ms 11 16,877 2h40m59s 572ms 12 14,995 2h19m58s 560ms 13 11,411 1h45m 552ms 14 10,594 1h35m53s 543ms 15 10,797 1h43m2s 572ms 16 15,329 2h29m19s 584ms 17 14,024 2h18m26s 592ms 18 16,802 2h41m59s 578ms 19 16,472 2h35m48s 567ms 20 16,556 2h44m58s 597ms 21 20,817 3h26m56s 596ms 22 5,036 46m41s 556ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4498064)) AND (("shipping_track"."id" not in (37127217, 37127217)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:01 Duration: 4s451ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4437963)) AND (("shipping_track"."id" not in (36687263, 36703571, 36703963, 36755370, 36755934, 36756041, 36896803, 36951885, 37127154, 37127154)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:51 Duration: 3s384ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4247780)) AND (("shipping_track"."id" not in (34893528, 34894245, 34902078, 34902244, 34930509, 34930981, 34991384, 35594697, 37127136, 37127215, 37127215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:02 Duration: 3s12ms
3 7h2m55s 44,228 477ms 4s160ms 573ms select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 00 204 1m55s 565ms 01 197 1m52s 571ms 02 304 2m47s 551ms 03 188 1m52s 598ms 04 222 2m5s 565ms 05 282 2m33s 544ms 06 513 4m28s 522ms 07 199 1m46s 535ms 08 929 8m15s 533ms 09 3,802 35m30s 560ms 10 2,749 26m1s 568ms 11 3,841 37m55s 592ms 12 3,888 37m28s 578ms 13 3,293 31m8s 567ms 14 2,628 24m31s 559ms 15 3,759 36m12s 577ms 16 4,561 44m31s 585ms 17 3,352 32m51s 588ms 18 2,147 20m34s 574ms 19 3,017 28m22s 564ms 20 1,794 17m57s 600ms 21 1,380 13m31s 588ms 22 979 8m41s 532ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4487764, 4469084, 4460438, 4458937, 4455055, 4431327, 4411960, 4404459, 4361498)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:16 Duration: 4s160ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4367883)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:24 Duration: 3s341ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4247780)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:59 Duration: 3s288ms
4 7h1m2s 117,494 160ms 1s230ms 215ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 00 1,449 4m59s 206ms 01 1,533 5m14s 205ms 02 2,578 8m48s 205ms 03 3,073 10m32s 205ms 04 2,457 8m25s 205ms 05 2,791 9m36s 206ms 06 1,847 6m19s 205ms 07 1,853 6m18s 204ms 08 2,163 7m22s 204ms 09 9,092 33m20s 220ms 10 6,164 22m39s 220ms 11 5,770 21m50s 227ms 12 4,131 15m36s 226ms 13 5,762 21m6s 219ms 14 5,787 20m45s 215ms 15 6,006 24m33s 245ms 16 7,590 29m1s 229ms 17 8,957 30m47s 206ms 18 7,945 25m52s 195ms 19 2,839 9m13s 194ms 20 23,036 1h23m4s 216ms 21 4,372 14m40s 201ms 22 299 52s898ms 176ms -
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" = '9767847')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:03 Duration: 1s230ms
-
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" = '9817183')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:48 Duration: 1s36ms
-
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" = '9767944')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:06 Duration: 972ms
5 4h35m59s 69,729 91ms 890ms 237ms 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 #5
Day Hour Count Duration Avg duration Jan 15 00 8,802 31m43s 216ms 01 4,624 17m41s 229ms 02 4,090 12m52s 188ms 03 2,440 8m28s 208ms 04 4,046 13m40s 202ms 05 118 18s676ms 158ms 06 550 1m25s 155ms 07 2,524 9m16s 220ms 08 518 1m48s 210ms 09 94 20s535ms 218ms 10 190 29s111ms 153ms 11 418 1m32s 220ms 12 228 1m 266ms 13 718 2m41s 225ms 14 892 3m13s 216ms 15 1,806 7m19s 243ms 16 3,440 14m53s 259ms 17 5,747 25m24s 265ms 18 6,114 26m44s 262ms 19 4,966 21m 253ms 20 6,486 29m14s 270ms 21 7,416 31m42s 256ms 22 3,502 13m6s 224ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:01:54 Duration: 890ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:01:54 Duration: 889ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسن')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:02:33 Duration: 870ms
6 3h55m3s 15,305 214ms 1s626ms 921ms 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 #6
Day Hour Count Duration Avg duration Jan 15 00 1,806 26m52s 892ms 01 310 4m38s 897ms 02 1,677 25m5s 897ms 03 511 7m34s 889ms 04 511 7m33s 888ms 05 61 54s132ms 887ms 06 278 4m6s 885ms 08 10 8s909ms 890ms 09 9 8s313ms 923ms 10 99 1m36s 979ms 11 8 7s614ms 951ms 12 9 8s803ms 978ms 13 116 1m51s 957ms 14 285 4m30s 949ms 15 327 5m13s 957ms 16 708 12m4s 1s22ms 17 1,542 25m12s 981ms 18 1,932 28m26s 883ms 19 1,389 20m1s 865ms 20 1,779 29m5s 981ms 21 1,558 24m 924ms 22 380 5m43s 903ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9732719')) 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 (113))))))) 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 (113)))))) 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 (113)))))) 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 (113))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 17:21:56 Duration: 1s626ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9909116')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 16:08:44 Duration: 1s614ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9923380')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 16:08:45 Duration: 1s431ms
7 1h59m55s 49 0ms 59m59s 2m26s update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 00 1 0ms 0ms 03 1 59m56s 59m56s 04 1 0ms 0ms 08 2 0ms 0ms 09 3 0ms 0ms 10 4 4ms 1ms 11 5 9ms 1ms 12 2 1ms 0ms 13 8 6ms 0ms 14 3 5ms 1ms 15 1 3ms 3ms 16 4 2ms 0ms 17 2 1ms 0ms 18 1 2ms 2ms 19 6 5ms 0ms 20 3 0ms 0ms 22 2 59m59s 29m59s -
UPDATE "res_users" SET "exp_date" = '2025-01-15 21:01:03.912132', "last_update" = '2025-01-15 20:16:03.912171', "write_date" = '2025-01-15 20:16:03.489562', "write_uid" = 1 WHERE id IN (1229);
Date: 2025-01-15 22:16:03 Duration: 59m59s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 02:24:58.367642', "last_update" = '2025-01-15 01:39:58.367662', "write_date" = '2025-01-15 01:39:58.046667', "write_uid" = 1 WHERE id IN (1053);
Date: 2025-01-15 03:39:54 Duration: 59m56s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 15:00:33.909572', "last_update" = '2025-01-15 14:15:33.909599', "write_date" = '2025-01-15 14:15:33.489377', "write_uid" = 1034 WHERE id IN (1034);
Date: 2025-01-15 15:15:33 Duration: 3ms
8 1h50m7s 146,525 33ms 222ms 45ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 00 3,684 2m35s 42ms 01 3,255 2m17s 42ms 02 2,531 1m47s 42ms 03 2,573 1m48s 42ms 04 2,680 1m51s 41ms 05 1,399 58s772ms 42ms 06 1,526 1m4s 42ms 07 1,201 50s263ms 41ms 08 3,056 2m9s 42ms 09 9,365 6m59s 44ms 10 10,143 7m32s 44ms 11 13,546 10m31s 46ms 12 13,033 9m55s 45ms 13 9,817 7m21s 44ms 14 8,732 6m25s 44ms 15 7,589 5m48s 45ms 16 9,617 7m26s 46ms 17 9,485 7m22s 46ms 18 7,995 6m6s 45ms 19 9,878 7m26s 45ms 20 6,566 5m8s 46ms 21 6,156 4m44s 46ms 22 2,698 1m55s 42ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4404459)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:59 Duration: 222ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4453656)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:23 Duration: 218ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4428636)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:52:13 Duration: 190ms
9 1h37m18s 19,831 172ms 746ms 294ms select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 07 117 30s127ms 257ms 08 797 3m28s 261ms 09 2,627 12m47s 292ms 10 1,214 6m19s 312ms 11 1,671 8m1s 288ms 12 1,286 6m23s 298ms 13 2,218 10m41s 289ms 14 2,020 10m7s 300ms 15 1,714 9m10s 321ms 16 2,638 12m55s 293ms 17 2,304 11m9s 290ms 18 1,031 4m48s 279ms 19 194 54s482ms 280ms -
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" = '9779239')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:17 Duration: 746ms
-
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" = '9779035')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:19 Duration: 680ms
-
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" = '')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:24 Duration: 675ms
10 1h31m37s 20,008 201ms 1s293ms 274ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 00 2,610 11m49s 271ms 01 2,035 9m22s 276ms 02 394 1m51s 282ms 03 729 3m18s 272ms 04 1,549 7m9s 277ms 07 1,271 5m49s 274ms 08 249 1m8s 273ms 09 48 14s117ms 294ms 10 11 3s104ms 282ms 11 207 1m6s 322ms 12 107 32s595ms 304ms 13 250 1m13s 295ms 14 165 47s669ms 288ms 15 599 3m3s 306ms 16 1,028 5m15s 306ms 17 1,370 6m14s 273ms 18 1,164 5m1s 259ms 19 1,121 4m44s 253ms 20 1,506 6m56s 276ms 21 2,197 10m1s 273ms 22 1,398 5m52s 252ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9963602')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:56 Duration: 1s293ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9925971')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:19 Duration: 701ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9829839')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:21 Duration: 639ms
11 1h22m6s 307 0ms 31m24s 16s46ms update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 15 00 2 2ms 1ms 01 7 1ms 0ms 02 5 1ms 0ms 03 2 31m24s 15m42s 04 1 0ms 0ms 05 1 0ms 0ms 06 5 0ms 0ms 07 1 0ms 0ms 08 13 2ms 0ms 09 22 5ms 0ms 10 37 16m50s 27s321ms 11 24 4m41s 11s717ms 12 27 33ms 1ms 13 28 10m13s 21s921ms 14 20 15ms 0ms 15 22 2m48s 7s663ms 16 20 16ms 0ms 17 11 9ms 0ms 18 9 1m54s 12s712ms 19 15 11ms 0ms 20 18 14m13s 47s399ms 21 8 12ms 1ms 22 9 3ms 0ms -
UPDATE "res_users" SET "exp_date" = '2025-01-15 02:53:30.578086', "last_update" = '2025-01-15 02:08:30.578108', "sid" = '1450830fbaf7359b85a8818bf78e3c665d1dc87d', "write_date" = '2025-01-15 02:08:30.256425', "write_uid" = 1053 WHERE id IN (1053);
Date: 2025-01-15 03:39:54 Duration: 31m24s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 10:06:29.960495', "last_update" = '2025-01-15 09:21:29.960523', "sid" = '7a9ae19aab0f2904bcddbc2b0de823394ec93703', "write_date" = '2025-01-15 09:21:29.590801', "write_uid" = 1 WHERE id IN (875);
Date: 2025-01-15 10:38:20 Duration: 16m50s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 12:48:07.290791', "last_update" = '2025-01-15 12:03:07.290821', "sid" = 'b6b90f6073186a1effa8f06a6dfbc083b385b665', "write_date" = '2025-01-15 12:03:06.906416', "write_uid" = 1 WHERE id IN (836);
Date: 2025-01-15 13:13:21 Duration: 10m13s
12 1h14m44s 35,399 0ms 8m31s 126ms update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 15 00 4,360 59m21s 816ms 01 2,315 8m37s 223ms 02 2,041 1m12s 35ms 03 1,212 1m27s 71ms 04 2,021 1m19s 39ms 05 62 10ms 0ms 06 281 49ms 0ms 07 1,262 258ms 0ms 08 270 51ms 0ms 09 109 36ms 0ms 10 133 44ms 0ms 11 252 79ms 0ms 12 160 48ms 0ms 13 405 120ms 0ms 14 480 121ms 0ms 15 953 261ms 0ms 16 1,785 527ms 0ms 17 2,932 875ms 0ms 18 3,079 868ms 0ms 19 2,527 18s202ms 7ms 20 3,264 2m23s 43ms 21 3,730 1s2ms 0ms 22 1,766 471ms 0ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:49:50.539409', "write_uid" = 1224 WHERE id IN (32657720);
Date: 2025-01-15 00:58:23 Duration: 8m31s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:42:57.746450', "write_uid" = 1244 WHERE id IN (32657720);
Date: 2025-01-15 00:48:00 Duration: 5m1s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:55:41.320327', "write_uid" = 1244 WHERE id IN (32657720);
Date: 2025-01-15 01:00:37 Duration: 4m54s
13 50m33s 48,828 46ms 177ms 62ms select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 15 00 17 1s5ms 59ms 01 7 417ms 59ms 02 29 1s739ms 59ms 03 5 285ms 57ms 04 1 53ms 53ms 05 4 246ms 61ms 06 5 311ms 62ms 07 244 14s17ms 57ms 08 1,601 1m32s 58ms 09 5,263 5m21s 61ms 10 2,309 2m23s 62ms 11 4,492 4m46s 63ms 12 3,431 3m37s 63ms 13 4,694 4m52s 62ms 14 4,384 4m29s 61ms 15 3,945 4m13s 64ms 16 4,793 5m5s 63ms 17 4,474 4m34s 61ms 18 3,650 3m42s 61ms 19 4,681 4m43s 60ms 20 518 33s476ms 64ms 21 171 11s466ms 67ms 22 110 6s372ms 57ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4428636) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:52:07 Duration: 177ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4312380) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:52:03 Duration: 152ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4349561) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:57 Duration: 145ms
14 47m9s 13,395 163ms 375ms 211ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 15 00 144 30s525ms 211ms 01 298 1m1s 206ms 02 473 1m37s 205ms 03 13 2s670ms 205ms 04 286 59s273ms 207ms 05 550 1m53s 207ms 06 1,186 4m3s 205ms 07 745 2m32s 204ms 08 518 1m46s 205ms 09 1,629 5m54s 217ms 10 412 1m30s 218ms 11 1,433 5m24s 226ms 12 952 3m30s 221ms 13 776 2m44s 212ms 14 1,025 3m40s 215ms 15 622 2m23s 230ms 16 284 1m2s 220ms 17 698 2m22s 204ms 18 259 47s914ms 184ms 19 261 47s327ms 181ms 20 378 1m11s 189ms 21 200 36s78ms 180ms 22 253 44s801ms 177ms -
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" = '9862101')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:59 Duration: 375ms
-
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9790644')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:01 Duration: 374ms
-
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" = '9817894')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:53 Duration: 372ms
15 42m8s 12,293 170ms 257ms 205ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 00 1,304 4m28s 206ms 01 1,235 4m13s 205ms 02 1,822 6m14s 205ms 03 2,915 9m59s 205ms 04 2,107 7m13s 205ms 05 2,207 7m34s 206ms 06 661 2m15s 205ms 22 42 7s509ms 178ms -
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" = '9919562')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 02:37:34 Duration: 257ms
-
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" = '9812642')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 04:32:01 Duration: 254ms
-
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" = '9714610')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 02:44:42 Duration: 253ms
16 35m29s 18,612 91ms 603ms 114ms select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 05 16 1s745ms 109ms 06 64 7s76ms 110ms 08 116 12s978ms 111ms 09 979 1m53s 115ms 10 1,302 2m24s 110ms 11 2,251 4m23s 117ms 12 1,997 3m51s 115ms 13 2,369 4m29s 113ms 14 2,162 3m57s 109ms 15 1,895 3m36s 114ms 16 1,624 3m12s 118ms 17 789 1m32s 116ms 18 1,032 1m56s 113ms 19 621 1m11s 115ms 20 395 47s208ms 119ms 21 447 53s821ms 120ms 22 553 58s870ms 106ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7987836)) AND (("cash_track"."id" not in (6992568)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 15:51:21 Duration: 603ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7987838)) AND (("cash_track"."id" not in (6992588)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 15:52:13 Duration: 344ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7988632)) AND (("cash_track"."id" not in (6997186)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 17:23:44 Duration: 289ms
17 17m18s 18,329 43ms 107ms 56ms select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 15 07 117 6s244ms 53ms 08 608 32s303ms 53ms 09 2,895 2m41s 55ms 10 1,090 1m2s 56ms 11 1,393 1m21s 58ms 12 1,355 1m19s 58ms 13 1,837 1m48s 59ms 14 1,817 1m42s 56ms 15 1,596 1m32s 58ms 16 2,093 1m57s 56ms 17 1,920 1m46s 55ms 18 1,363 1m14s 54ms 19 245 13s506ms 55ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4406226) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:47 Duration: 107ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4415169) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:46 Duration: 106ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4410453) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:48 Duration: 99ms
18 16m58s 6,200 122ms 1s67ms 164ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 01 5 743ms 148ms 08 68 10s178ms 149ms 09 333 55s88ms 165ms 10 1,084 2m52s 159ms 11 1,175 3m20s 170ms 12 1,129 3m9s 168ms 13 555 1m31s 165ms 14 711 1m52s 158ms 15 398 1m10s 177ms 16 195 33s201ms 170ms 17 234 36s486ms 155ms 18 130 19s38ms 146ms 19 75 10s536ms 140ms 20 37 5s323ms 143ms 21 57 8s576ms 150ms 22 14 1s852ms 132ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 66)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:51:53 Duration: 1s67ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:52:41 Duration: 998ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:51:54 Duration: 784ms
19 11m52s 2,641 18ms 937ms 269ms select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 00 2 44ms 22ms 05 2 518ms 259ms 06 3 150ms 50ms 07 5 944ms 188ms 08 41 5s98ms 124ms 09 135 33s517ms 248ms 10 247 58s619ms 237ms 11 310 1m21s 264ms 12 361 1m40s 278ms 13 334 1m33s 280ms 14 317 1m22s 261ms 15 241 1m10s 293ms 16 174 53s934ms 309ms 17 108 34s360ms 318ms 18 89 25s890ms 290ms 19 64 25s321ms 395ms 20 56 24s127ms 430ms 21 46 15s231ms 331ms 22 106 5s158ms 48ms -
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 15:51:23 Duration: 937ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 15:51:10 Duration: 794ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 16:08:39 Duration: 725ms
20 10m54s 237 12ms 4s560ms 2s760ms select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 02 5 15s442ms 3s88ms 09 18 59s186ms 3s288ms 11 4 3s577ms 894ms 12 11 25s32ms 2s275ms 13 17 56s341ms 3s314ms 14 10 34s619ms 3s461ms 15 20 50s254ms 2s512ms 16 29 1m34s 3s265ms 17 14 15s132ms 1s80ms 18 32 1m15s 2s366ms 19 16 50s732ms 3s170ms 20 27 1m1s 2s272ms 21 25 1m25s 3s406ms 22 9 26s971ms 2s996ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:38 Duration: 4s560ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9836685%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:41 Duration: 4s525ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%98%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:38 Duration: 4s285ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,573,977 2m5s 0ms 15ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 00 40,769 2s141ms 0ms 01 36,310 1s843ms 0ms 02 35,261 1s779ms 0ms 03 35,685 1s869ms 0ms 04 29,987 1s558ms 0ms 05 28,034 1s432ms 0ms 06 33,522 1s730ms 0ms 07 29,397 1s518ms 0ms 08 64,484 3s344ms 0ms 09 142,341 8s479ms 0ms 10 173,310 8s494ms 0ms 11 211,900 9s403ms 0ms 12 272,225 11s837ms 0ms 13 203,352 9s600ms 0ms 14 199,914 9s694ms 0ms 15 276,593 12s134ms 0ms 16 175,999 8s918ms 0ms 17 153,043 7s554ms 0ms 18 126,463 6s398ms 0ms 19 108,955 5s768ms 0ms 20 86,870 4s748ms 0ms 21 67,166 3s203ms 0ms 22 42,397 2s5ms 0ms -
DISCARD ALL;
Date: 2025-01-15 15:15:47 Duration: 15ms
-
DISCARD ALL;
Date: 2025-01-15 11:23:38 Duration: 14ms
-
DISCARD ALL;
Date: 2025-01-15 08:46:08 Duration: 12ms
2 2,065,356 28s913ms 0ms 1ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 00 31,283 489ms 0ms 01 27,291 428ms 0ms 02 26,818 414ms 0ms 03 28,144 428ms 0ms 04 22,986 364ms 0ms 05 21,977 338ms 0ms 06 27,312 403ms 0ms 07 23,522 353ms 0ms 08 52,167 728ms 0ms 09 116,723 1s735ms 0ms 10 142,502 1s911ms 0ms 11 176,894 2s285ms 0ms 12 232,504 2s826ms 0ms 13 160,296 2s174ms 0ms 14 156,344 2s67ms 0ms 15 233,982 2s880ms 0ms 16 132,805 1s930ms 0ms 17 120,018 1s734ms 0ms 18 97,559 1s527ms 0ms 19 83,328 1s375ms 0ms 20 66,627 1s156ms 0ms 21 50,663 845ms 0ms 22 33,611 512ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-15 20:50:00 Duration: 1ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-15 20:43:09 Duration: 1ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2025-01-15 09:47:19 Duration: 1ms
3 1,309,334 12s946ms 0ms 0ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 00 21,306 210ms 0ms 01 18,902 186ms 0ms 02 18,290 178ms 0ms 03 18,499 182ms 0ms 04 15,619 157ms 0ms 05 14,626 139ms 0ms 06 17,418 166ms 0ms 07 15,273 146ms 0ms 08 33,157 314ms 0ms 09 72,363 767ms 0ms 10 88,260 830ms 0ms 11 107,327 1s75ms 0ms 12 137,452 1s296ms 0ms 13 102,960 961ms 0ms 14 101,190 937ms 0ms 15 139,642 1s316ms 0ms 16 89,198 864ms 0ms 17 77,488 819ms 0ms 18 64,212 675ms 0ms 19 55,488 597ms 0ms 20 44,314 507ms 0ms 21 34,468 395ms 0ms 22 21,882 219ms 0ms -
ROLLBACK;
Date: 2025-01-15 14:27:33 Duration: 0ms
-
ROLLBACK;
Date: 2025-01-15 17:48:30 Duration: 0ms
-
ROLLBACK;
Date: 2025-01-15 16:28:28 Duration: 0ms
4 1,297,490 3m40s 0ms 14ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 00 20,448 3s547ms 0ms 01 18,209 3s121ms 0ms 02 17,639 2s922ms 0ms 03 17,793 2s942ms 0ms 04 14,962 2s522ms 0ms 05 13,976 2s224ms 0ms 06 16,813 2s581ms 0ms 07 14,662 2s259ms 0ms 08 32,493 4s879ms 0ms 09 72,132 12s309ms 0ms 10 87,730 14s224ms 0ms 11 107,044 18s71ms 0ms 12 137,270 20s718ms 0ms 13 102,689 16s558ms 0ms 14 100,958 15s695ms 0ms 15 139,002 21s355ms 0ms 16 88,968 14s342ms 0ms 17 77,017 14s633ms 0ms 18 63,636 12s732ms 0ms 19 54,967 11s427ms 0ms 20 43,865 9s606ms 0ms 21 33,881 7s454ms 0ms 22 21,336 3s918ms 0ms -
SELECT payload FROM http_sessions WHERE sid = '299c4db016e5a6aaa080c17fa19138752522e143';
Date: 2025-01-15 13:04:52 Duration: 14ms
-
SELECT payload FROM http_sessions WHERE sid = 'a1ad0fe623d6e648e03732b4dd42c2c610941aa7';
Date: 2025-01-15 08:46:08 Duration: 13ms
-
SELECT payload FROM http_sessions WHERE sid = 'c81696b3cf2c8b586cde30a916bd5e485bfe97a4';
Date: 2025-01-15 20:01:48 Duration: 12ms
5 1,286,629 1m53s 0ms 17ms 0ms select base_registry_signaling.last_value, base_cache_signaling.last_value from base_registry_signaling, base_cache_signaling;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 15 00 20,413 1s771ms 0ms 01 18,200 1s556ms 0ms 02 17,686 1s515ms 0ms 03 17,901 1s521ms 0ms 04 15,069 1s309ms 0ms 05 14,073 1s188ms 0ms 06 16,815 1s406ms 0ms 07 14,775 1s239ms 0ms 08 32,237 2s603ms 0ms 09 71,129 6s334ms 0ms 10 86,492 7s250ms 0ms 11 105,832 9s569ms 0ms 12 136,029 11s514ms 0ms 13 101,555 8s638ms 0ms 14 99,918 8s453ms 0ms 15 138,193 11s859ms 0ms 16 87,961 7s673ms 0ms 17 76,508 7s144ms 0ms 18 63,188 5s872ms 0ms 19 54,436 5s201ms 0ms 20 43,401 4s260ms 0ms 21 33,621 3s296ms 0ms 22 21,197 1s829ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-15 13:33:25 Duration: 17ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-15 11:42:25 Duration: 15ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2025-01-15 02:27:26 Duration: 1ms
6 1,018,214 2m25s 0ms 13ms 0ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 15 00 12,882 2s168ms 0ms 01 10,214 1s816ms 0ms 02 9,923 1s753ms 0ms 03 11,354 2s19ms 0ms 04 8,680 1s553ms 0ms 05 8,315 1s462ms 0ms 06 12,409 1s872ms 0ms 07 11,079 1s650ms 0ms 08 25,300 3s570ms 0ms 09 58,853 9s5ms 0ms 10 71,189 10s212ms 0ms 11 91,563 12s405ms 0ms 12 130,853 16s12ms 0ms 13 75,885 11s265ms 0ms 14 73,416 10s277ms 0ms 15 151,773 17s61ms 0ms 16 56,814 9s584ms 0ms 17 54,693 8s565ms 0ms 18 42,221 6s382ms 0ms 19 36,282 5s966ms 0ms 20 27,981 4s965ms 0ms 21 20,468 3s427ms 0ms 22 16,067 2s427ms 0ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (852);
Date: 2025-01-15 17:21:52 Duration: 13ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1102);
Date: 2025-01-15 17:21:52 Duration: 13ms
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" FROM "res_users" WHERE "res_users".id IN (1423);
Date: 2025-01-15 17:21:52 Duration: 12ms
7 755,302 1m57s 0ms 31ms 0ms commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 00 9,975 1s543ms 0ms 01 8,391 1s513ms 0ms 02 8,520 1s544ms 0ms 03 9,650 1s860ms 0ms 04 7,368 1s516ms 0ms 05 7,351 1s449ms 0ms 06 9,896 1s506ms 0ms 07 8,249 1s262ms 0ms 08 19,007 2s699ms 0ms 09 44,337 7s162ms 0ms 10 54,177 8s126ms 0ms 11 69,418 10s782ms 0ms 12 94,934 11s153ms 0ms 13 57,222 9s204ms 0ms 14 55,112 8s505ms 0ms 15 94,262 10s303ms 0ms 16 43,586 7s430ms 0ms 17 42,517 7s554ms 0ms 18 33,291 6s204ms 0ms 19 27,837 5s397ms 0ms 20 22,274 4s597ms 0ms 21 16,189 3s912ms 0ms 22 11,739 2s103ms 0ms -
COMMIT;
Date: 2025-01-15 13:24:33 Duration: 31ms
-
COMMIT;
Date: 2025-01-15 16:18:52 Duration: 30ms
-
COMMIT;
Date: 2025-01-15 18:19:43 Duration: 29ms
8 671,161 1m15s 0ms 18ms 0ms select "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" from "urgent_customer" where "urgent_customer".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 00 12,718 1s495ms 0ms 01 7,775 994ms 0ms 02 6,222 671ms 0ms 03 6,458 768ms 0ms 04 6,506 662ms 0ms 05 3,289 443ms 0ms 06 6,787 876ms 0ms 07 6,957 893ms 0ms 08 14,411 1s834ms 0ms 09 35,702 4s764ms 0ms 10 42,359 5s321ms 0ms 11 55,471 7s337ms 0ms 12 95,471 9s121ms 0ms 13 43,178 6s157ms 0ms 14 40,434 4s827ms 0ms 15 123,152 8s786ms 0ms 16 34,755 4s364ms 0ms 17 34,451 4s187ms 0ms 18 27,383 3s263ms 0ms 19 23,938 3s31ms 0ms 20 17,899 2s306ms 0ms 21 14,466 1s875ms 0ms 22 11,379 1s373ms 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 (5099008, 5099128, 5470650, 5099641, 5099010, 5099144, 5099009, 5099006, 5099243, 5439062, 5099007, 5100738, 5099737, 5103580, 5099013, 5099236, 5099321, 5099224, 5099403, 5099759, 5100218, 5100901, 5099003, 5099035, 5099445, 5099349, 5100737, 5099693, 5103188, 5107748, 5100421, 5131923, 5100181, 5099138, 5100111, 5099242, 5102478, 5099102, 5099103, 5099587, 5099251, 5099170, 5099037, 5099921, 5099031, 5470068, 5105798, 5099129, 5099404, 5099135, 5099095, 5103388, 5099277, 5172655, 5101246, 5099420, 5099111, 5099547, 5099254, 5100110, 5100714, 5100554, 5270607, 5099120, 5099533, 5099360, 5099206, 5102026, 5099190, 5280292, 5103258, 5099133, 5099045, 5265832, 5229921, 5099162, 5114981, 5149370, 5103853, 5099875, 5100306, 5099246, 5099644, 5099922, 5100404, 5099359, 5101238, 5099867, 5099521, 5099169, 5099028, 5100144, 5100796, 5470364, 5100207, 5099137, 5099662, 5099014, 5102413, 5101943, 5099092, 5099887, 5413580, 5099181, 5103007, 5099677, 5468080, 5099382, 5398622, 5099406, 5099590, 5099258, 5099540, 5098989, 5100471, 5469489, 5110062, 5099973, 5099727, 5099885, 5099422, 5111584, 5357538, 5099204, 5099130, 5134271, 5100431, 5099263, 5100540, 5417356, 5099334, 5099264, 5099400, 5099311, 5099947, 5099179, 5101122, 5100517, 5245166, 5230217, 5100499, 5099090, 5099924, 5105173, 5151829, 5100952, 5249571, 5100152, 5115318, 5257081, 5427181, 5103356, 5247428, 5099287, 5104383, 5099200, 5099297, 5100850, 5111322, 5102459, 5106303, 5100628, 5442570, 5274469, 5105671, 5100810, 5099117, 5100148, 5099159, 5462861, 5099577, 5099594, 5107893, 5099177, 5101313, 5353676, 5099356, 5099489, 5099598, 5099413, 5099119, 5099500, 5104672, 5101222, 5103839, 5099244, 5099512, 5100004, 5099920, 5113543, 5100273, 5245208, 5099296, 5101971, 5430836, 5459081, 5099203, 5460613, 5460611, 5177621, 5102794, 5099167, 5102148, 5099034, 5108587, 5099415, 5099272, 5442942, 5102762, 5099248, 5320388, 5182576, 5099313, 5099309, 5101165, 5102265, 5099804, 5435795, 5099140, 5100457, 5099427, 5109612, 5104276, 5099788, 5332262, 5105025, 5193184, 5100350, 5103944, 5106238, 5440858, 5100476, 5230842, 5100832, 5101173);
Date: 2025-01-15 13:21:17 Duration: 18ms
-
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 (5099504, 5101027, 5099761, 5100506, 5123655, 5124670, 5099181, 5142718, 5101445, 5099359, 5105152, 5103631, 5099693, 5118032, 5109066, 5100348, 5099028, 5099351, 5099243, 5101219, 5476477, 5409499, 5099141, 5111230, 5100163, 5123666, 5099564, 5099684, 5099878, 5100688, 5099080, 5359622, 5103325, 5111168, 5472363, 5100935, 5099688, 5099533, 5099138, 5103579, 5098996, 5115765, 5099266, 5099358, 5322121, 5099289, 5101722, 5099263, 5121106, 5099585, 5109226, 5116779, 5108796, 5103731, 5099231, 5112342, 5173236, 5157999, 5100431, 5102122, 5102287, 5099654, 5105966, 5099102, 5101808, 5100833, 5100499, 5099403, 5415359, 5467736, 5110603, 5100606, 5100366, 5110705, 5158951, 5102344, 5099119, 5110163, 5399152, 5099570, 5099008, 5181967, 5102390, 5099782, 5110301, 5099727, 5100292, 5133599, 5099525, 5099246, 5125379, 5148736, 5129946, 5467125, 5100525, 5106302, 5158064, 5107116, 5100023, 5100421, 5110951, 5247982, 5100273, 5102136, 5106054, 5132956, 5099082, 5100563, 5100516, 5099759, 5126396, 5099169, 5324217, 5100396, 5411021, 5100788, 5103500, 5099299, 5100681, 5103866, 5125262, 5101525, 5100390, 5472946, 5478504, 5472585, 5104402, 5121313, 5099866, 5101133, 5101775, 5100386, 5099277);
Date: 2025-01-15 17:21:53 Duration: 12ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099009, 5099006, 5099007, 5099200, 5126138, 5103909, 5101952, 5099296, 5099013, 5099360, 5099045, 5099491, 5099540, 5100564, 5139485, 5477108, 5118668, 5099224, 5099010, 5103374, 5099885, 5101362, 5099158, 5100658, 5104848, 5478227, 5103640, 5099003, 5100781, 5475448, 5100933, 5100005, 5099035, 5099206, 5099174, 5099190, 5111598, 5099924, 5099037, 5243342, 5099202, 5099187, 5099135, 5099677, 5101378, 5472361, 5099334, 5099137, 5099236, 5100161, 5100554, 5131378, 5099855, 5101367, 5099170, 5099014, 5106646, 5099309, 5109522, 5105969, 5101185, 5101745, 5099251, 5099111, 5100511, 5100471, 5099090, 5100916, 5102253, 5100726, 5099128, 5099590, 5099650, 5099130, 5099272, 5099333, 5106573, 5174492, 5099321, 5099788, 5100187, 5105702, 5099002, 5473107, 5100738, 5103801, 5473652, 5102762, 5099144, 5099499, 5099920, 5248910, 5099648, 5104141);
Date: 2025-01-15 17:21:53 Duration: 9ms
9 647,907 38s284ms 0ms 1ms 0ms select "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 00 7,717 470ms 0ms 01 4,914 277ms 0ms 02 4,529 267ms 0ms 03 4,670 262ms 0ms 04 3,960 228ms 0ms 05 2,913 160ms 0ms 06 7,156 371ms 0ms 07 6,147 331ms 0ms 08 13,419 775ms 0ms 09 33,969 2s200ms 0ms 10 41,906 2s455ms 0ms 11 56,004 3s677ms 0ms 12 83,239 4s550ms 0ms 13 44,439 2s804ms 0ms 14 43,607 2s633ms 0ms 15 125,453 6s49ms 0ms 16 35,666 2s279ms 0ms 17 35,519 2s330ms 0ms 18 26,806 1s729ms 0ms 19 23,985 1s588ms 0ms 20 18,379 1s310ms 0ms 21 13,769 975ms 0ms 22 9,741 553ms 0ms -
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (9);
Date: 2025-01-15 11:31:36 Duration: 1ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (14, 17, 5, 6, 40, 24, 8, 62, 39, 46, 55, 75, 67, 3, 26, 61, 64);
Date: 2025-01-15 12:36:12 Duration: 1ms
-
SELECT "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" FROM "urgent_office" WHERE "urgent_office".id IN (65, 85, 29, 22);
Date: 2025-01-15 12:56:09 Duration: 0ms
10 431,173 1m18s 0ms 12ms 0ms select "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" from "res_partner" where "res_partner".id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 00 4,243 809ms 0ms 01 3,166 602ms 0ms 02 2,510 462ms 0ms 03 2,810 525ms 0ms 04 2,441 461ms 0ms 05 1,830 336ms 0ms 06 4,769 731ms 0ms 07 4,843 718ms 0ms 08 11,533 1s786ms 0ms 09 26,631 4s734ms 0ms 10 30,323 5s437ms 0ms 11 38,027 7s339ms 0ms 12 52,085 9s476ms 0ms 13 34,101 6s156ms 0ms 14 32,656 5s718ms 0ms 15 71,727 12s743ms 0ms 16 24,304 4s477ms 0ms 17 23,851 4s662ms 0ms 18 17,305 3s331ms 0ms 19 15,131 2s898ms 0ms 20 11,196 2s310ms 0ms 21 8,629 1s721ms 0ms 22 7,062 1s175ms 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 (8007747);
Date: 2025-01-15 17:21:52 Duration: 12ms
-
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 (8007704);
Date: 2025-01-15 17:21:52 Duration: 12ms
-
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 (8006361, 8004658);
Date: 2025-01-15 17:21:52 Duration: 2ms
11 359,093 1m53s 0ms 18ms 0ms select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 15 00 2,309 705ms 0ms 01 1,916 594ms 0ms 02 1,803 554ms 0ms 03 1,163 353ms 0ms 04 1,111 333ms 0ms 05 930 286ms 0ms 06 1,699 512ms 0ms 07 1,808 541ms 0ms 08 9,952 2s957ms 0ms 09 16,874 5s569ms 0ms 10 29,635 8s838ms 0ms 11 44,759 14s377ms 0ms 12 37,863 11s785ms 0ms 13 36,724 11s453ms 0ms 14 29,825 9s253ms 0ms 15 37,792 11s980ms 0ms 16 21,421 7s85ms 0ms 17 24,890 8s203ms 0ms 18 16,811 5s271ms 0ms 19 13,952 4s488ms 0ms 20 10,277 3s468ms 0ms 21 10,025 3s305ms 0ms 22 5,554 1s512ms 0ms -
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'mail.message' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 837) OR r.global) ORDER BY r.id;
Date: 2025-01-15 18:32:51 Duration: 18ms
-
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 = 928) OR r.global) ORDER BY r.id;
Date: 2025-01-15 12:05:52 Duration: 2ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.office' 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 = 859) OR r.global) ORDER BY r.id;
Date: 2025-01-15 20:16:42 Duration: 2ms
12 308,618 1m6s 0ms 43ms 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 #12
Day Hour Count Duration Avg duration Jan 15 00 7,311 1s843ms 0ms 01 4,281 1s116ms 0ms 02 3,543 820ms 0ms 03 3,086 780ms 0ms 04 3,501 848ms 0ms 05 1,188 361ms 0ms 06 2,760 683ms 0ms 07 3,581 852ms 0ms 08 5,832 1s446ms 0ms 09 14,238 3s691ms 0ms 10 17,451 4s240ms 0ms 11 23,182 5s556ms 0ms 12 36,924 6s758ms 0ms 13 19,620 5s97ms 0ms 14 19,700 3s964ms 0ms 15 60,545 8s288ms 0ms 16 16,558 3s867ms 0ms 17 16,458 3s988ms 0ms 18 13,870 3s213ms 0ms 19 11,087 2s868ms 0ms 20 8,992 2s406ms 0ms 21 8,435 2s203ms 0ms 22 6,475 1s383ms 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 (42047044, 42039535, 42004337, 42006899, 41923958, 41900077, 41873296, 42045309, 41865530, 41999254, 42015893, 41970977, 32659756, 41963364, 41963351, 42064649, 42017482, 41800331, 41985955, 41983419, 41817983, 42010616, 41931345, 42061065, 42017385, 41909416, 42006835, 42006321, 42004280, 41963363, 41933534, 41853909, 41631554, 42008664, 39166231, 41979016, 42026844, 42079895, 41903625, 41814456, 41964098, 42066735, 42066478, 42066459, 42017933, 42065935, 42065980, 42066042, 42017036, 41966711, 42072854, 42011263, 41969413, 42028128, 41844429, 42073392, 42015668, 42007587, 41799960, 41960923, 42045442, 41642874, 42065313, 41938041, 41829209, 41960027, 41860809, 41854451, 42077347, 32660569, 42039533, 42039539, 42035094, 42025014, 41949977, 32668018, 41961122, 41937621, 41945674, 32667266, 42016830, 42019349, 42064179, 42047388, 41995905, 42028387, 42015360, 42046199, 41974828, 42059258, 42065455, 41957427, 41325457, 42064822, 42058500, 42058048, 42039271, 42017059, 42065257, 42043905, 42065160, 41894191, 42041050, 41898181, 41854554, 41948800, 41809535, 42039013, 32667960, 41773502, 41974495, 42012513, 41812126, 41647717, 41921059, 42007011, 41986151, 41924170, 41940098, 41965363, 41929221, 41703457, 42071647, 41921215, 41763406, 41455013, 41956947, 41816280, 42077558, 41851013, 42065076, 41954552, 41883861, 41997104, 42039529, 42042051, 41139566, 41829214, 41866869, 41723021, 41993146, 41854498, 41948802, 41854447, 42004915, 41995595, 41995626, 41997597, 41831504, 41996986, 41761920, 32652308, 41964009, 42043939, 42019884, 41754964, 42034999, 41836117, 41963154, 41985932, 41835209, 41925168, 41973472, 41804976, 42062868, 41614034, 41347517, 42068149, 41871006, 42068384, 42067736, 42059445, 42059252, 42017781, 42077577, 42077575, 41298074, 41982267, 42039037, 42017061, 42065025, 41995344, 41801049, 41517276, 42017183, 42041857, 42018776, 41989046, 42007800, 41898171, 41898819, 41971196, 42015349, 42028593, 42027920, 42081776, 42076735, 41970336, 42004916, 32668468, 41998066, 42039537, 42028073, 41947385, 42006449, 42004308, 42024998, 42003371, 32659740, 41899387, 42027617, 41873228, 42049601, 41963369, 41800329, 32666236, 41905285, 41924301, 41944446, 41966161, 41393340, 32653587, 42066740, 42066471, 42068692, 41957252, 41921060, 41837866, 42077631, 42066232, 42018103, 42016933, 42028135, 40601919, 42020364, 41875342, 38903082, 42078947, 41972434, 42077282, 42065436, 42065449, 42063881, 42065858, 40958707, 41789283, 42064998);
Date: 2025-01-15 17:21:53 Duration: 43ms
-
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 (41968779, 41890572, 41890576, 41890577, 41275809, 42062986, 41412118, 41742841, 41743220, 41972417, 42084211, 42084325, 41090616, 41275825, 41275803, 41275838, 41411938, 41601316, 41743218, 41927902, 41812917, 41927921, 41927913, 41412122, 41412119, 41927928, 41812972, 41815977, 41927944, 41815974, 41972422, 41972423, 41972430, 41751796, 41815972, 41972433, 41978714, 41978715, 42062963, 42017151, 32652571, 41972406, 41979018, 32651912, 41972428, 41972415, 41601310, 41847767, 41601317, 41412123, 41171139, 41779482, 41804743, 41927053, 41415800, 41412117, 41927529, 41979002, 41412125, 41943082, 41847766, 41972421, 41844353, 32652568, 41928870, 41331803, 41844352, 41968775, 41963993, 42017147, 41991403, 32652288, 32638236, 41331834, 42017149, 41815903, 41412115, 41923210, 41974650, 41411937, 41601312, 41879032, 41978944, 41561722, 41927911, 41923215, 41847770, 41972414, 32652942, 41963946, 41923212, 41847776, 41927939, 41937008, 41331747, 41968776, 32652185, 41979005, 32651976, 41275808, 41847772, 32652679, 41869792, 41805027, 41171183, 41923216, 41923208, 41412124, 41923207, 41805020, 41815967, 41968773, 41963948, 42062920, 41968780, 41844351, 41964069, 41890579, 41829998, 32652401, 41331752, 41928678, 41508589, 41847762, 41847765, 41847764, 41847748, 41171118, 41978943, 41879041, 41743219, 41805579, 41662230, 41779485, 41879036, 41928857, 41927915, 41416364, 32652569, 41964222, 41812973, 41508576, 41923213, 41968777, 41968778, 41979001, 41972431, 41972425, 41979016, 41825010, 42063397, 41972429, 42017148, 41331753, 41890581, 32653392, 41275806, 41275807, 40717880, 41869794, 42084209, 41415934, 41502319, 41601313, 41923211, 41538804, 41815854, 41812918, 41923209, 41927919, 41171151, 41978947, 41890046, 41975278, 42062921, 32653157, 41978712, 41968770, 41847775, 41923214, 32652428, 41927895);
Date: 2025-01-15 13:53:37 Duration: 17ms
-
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 (41879027, 41928207, 42021402, 41929194, 42078980, 41828919, 42078951, 42033819, 42084390, 41979516, 41774536, 41561619, 32658745, 41978870, 42033810, 41979195, 42078959, 32653299, 41979199, 41978822, 41978878, 41979245, 32653303, 41879143, 41989958, 41978987, 41978747, 41978984, 42078957, 32653205, 42033813, 41928203, 41978798, 41978979, 40753290, 41816001, 41928868, 41887093, 42009474, 41774535, 41879197, 41979371, 41752105, 41978831, 41929195, 41879563, 42084393, 41979248, 41879590, 41927021, 41929329, 41815996, 41979029, 41502085, 41828911, 41979067, 42009479, 41774541, 41929221, 42033818, 41805121, 41815993, 41879451, 41887120, 41887110, 41974700, 41878987, 41874818, 41964041, 40753291, 41979315, 41979247, 41778898, 42010300, 41978692, 42009488, 41979325, 41779470, 41979242, 41964593, 41963930, 41879636, 41879450, 42071654, 41956695, 41979256, 41816005, 41878686, 41331749, 41956724, 41385826, 41178675, 41751795, 41774517, 41956696, 42009486, 41978653, 41979189, 41879460, 41978933, 41990040, 41331750, 41964597, 41974701, 41979192, 41703604, 41979074, 41828927, 41793650, 41979059, 41826876, 41686268, 41625822, 41447875, 40753287, 41978915, 41828925, 41978677, 41447880, 41826853, 41447877, 41774539, 41447876, 41447871, 41974682, 41978682, 41892371, 41878689, 41286411, 41989959, 41878983, 41879363, 41828924, 41447868, 41828895, 41879456, 41828920, 41956694, 42072118, 41703597, 41447873, 41956693, 41828898, 41886862, 41278801, 41828928, 41979028, 41778930, 41879496, 41943161, 41679502, 41956698, 41956202, 41703603, 41794188, 41779467, 41879368, 41793646, 41978921, 41703598, 41886864, 41774533, 41978983, 41793652, 41794190, 41779468, 41779466, 41964407, 41879452, 41278840, 41878680, 42038801, 41538771, 41879054, 41978978, 41978916, 41978671, 41971737, 41779203, 41416035, 41874816, 41752095, 41929498, 41874808, 41130233, 41879638, 41971736, 41964488, 41847649, 41447870, 41879472, 41385827, 41879628, 41964489, 41964408, 41978912, 41447866, 41978904, 41943126, 41956210, 41956206, 41879025, 41956207, 41943219, 41878998, 41878719, 41929303, 41956211, 41896697, 41887300, 41887308, 41878928, 41927306, 41929326, 41794177, 41971883, 41927014, 41879536, 41956208, 41813301, 32641429, 41447865, 41793644, 41779465, 41892433, 41561620, 41561617, 41379444, 41385832, 41878995, 41779072, 41874815, 41878900, 41886969, 41874814, 41561618, 41793682, 41793666, 41480055, 41878709, 41840786, 41892431, 41793647, 41892432, 41926086, 41878997, 41737969, 41686242, 41980327, 41874812, 41793679, 41447848, 41447864, 41794159, 41874811, 41793678, 41956198, 41812921, 41929448, 41812923, 41874809, 41980328, 41878836, 41929318, 41813049, 41878898, 41956194, 41892434, 41956196, 41812882, 41956192, 41793668, 40753285, 41878929, 41793657, 41878905, 41793671, 41794175, 41480086, 41929319, 41885868, 41926085, 41925920, 41793659, 41793677, 41793663, 41925921, 41956195, 41481174, 41793670, 41812661, 41956197, 41793654, 41686286, 41793681, 41793661, 41447863, 41885835, 41793649, 41793653, 41805147, 41885837, 41793656, 41793660, 41887160, 41686279, 41793658, 41793672, 41793662, 41929317, 41793655, 41793669, 41793664, 41447860, 41885869, 41874801, 41874807, 41912707, 41874796, 41813347, 41502440, 41874797, 41874802, 41874800, 41874795, 41874798, 41813343, 41840787, 41813348, 41385820, 41813429, 41502437, 41813148, 41840785, 41840781, 32639999, 41625405, 41813145, 41813426, 40930448, 41502433, 41813425, 41385839, 41706728, 41566161, 40485166, 41222407, 40485169, 40485161, 40485164, 40485170, 40485163);
Date: 2025-01-15 12:50:54 Duration: 16ms
13 274,260 47s920ms 0ms 2ms 0ms select ? from res_groups_users_rel where uid = ? and gid in ( select res_id from ir_model_data where module = ? and name = ? and model = ?);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 15 00 2,437 352ms 0ms 01 1,918 274ms 0ms 02 2,114 286ms 0ms 03 1,300 165ms 0ms 04 1,252 159ms 0ms 05 1,187 151ms 0ms 06 1,602 231ms 0ms 07 1,778 254ms 0ms 08 10,145 1s538ms 0ms 09 15,059 2s569ms 0ms 10 24,007 3s938ms 0ms 11 32,286 6s70ms 0ms 12 26,338 4s714ms 0ms 13 26,286 4s732ms 0ms 14 21,617 3s697ms 0ms 15 27,604 5s53ms 0ms 16 15,086 2s686ms 0ms 17 17,246 3s191ms 0ms 18 14,210 2s425ms 0ms 19 10,780 1s846ms 0ms 20 8,286 1s514ms 0ms 21 7,659 1s420ms 0ms 22 4,063 646ms 0ms -
SELECT 1 FROM res_groups_users_rel WHERE uid = 1036 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_track_search' AND name = 'group_search_training_shipping' AND model = 'res.groups');
Date: 2025-01-15 20:46:05 Duration: 2ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1228 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2025-01-15 14:21:37 Duration: 2ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1068 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'urgent_track_search' AND name = 'group_search_training_shipping' AND model = 'res.groups');
Date: 2025-01-15 09:38:01 Duration: 2ms
14 261,919 1d16h52m15s 475ms 4s451ms 561ms 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 #14
Day Hour Count Duration Avg duration Jan 15 00 10,536 1h37m8s 553ms 01 9,359 1h23m37s 536ms 02 8,325 1h14m32s 537ms 03 9,192 1h20m38s 526ms 04 7,888 1h10m10s 533ms 05 5,781 49m1s 508ms 06 4,725 40m28s 514ms 07 4,519 40m8s 532ms 08 4,501 38m46s 516ms 09 14,073 2h8m5s 546ms 10 13,310 2h31s 543ms 11 16,877 2h40m59s 572ms 12 14,995 2h19m58s 560ms 13 11,411 1h45m 552ms 14 10,594 1h35m53s 543ms 15 10,797 1h43m2s 572ms 16 15,329 2h29m19s 584ms 17 14,024 2h18m26s 592ms 18 16,802 2h41m59s 578ms 19 16,472 2h35m48s 567ms 20 16,556 2h44m58s 597ms 21 20,817 3h26m56s 596ms 22 5,036 46m41s 556ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4498064)) AND (("shipping_track"."id" not in (37127217, 37127217)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:01 Duration: 4s451ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4437963)) AND (("shipping_track"."id" not in (36687263, 36703571, 36703963, 36755370, 36755934, 36756041, 36896803, 36951885, 37127154, 37127154)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:51 Duration: 3s384ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4247780)) AND (("shipping_track"."id" not in (34893528, 34894245, 34902078, 34902244, 34930509, 34930981, 34991384, 35594697, 37127136, 37127215, 37127215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:02 Duration: 3s12ms
15 240,867 16s934ms 0ms 1ms 0ms select "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" from "notebook_package" where "notebook_package".id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 00 2,847 181ms 0ms 01 1,943 127ms 0ms 02 1,453 93ms 0ms 03 1,845 119ms 0ms 04 1,433 96ms 0ms 05 1,103 71ms 0ms 06 2,288 142ms 0ms 07 2,135 137ms 0ms 08 5,116 320ms 0ms 09 12,376 896ms 0ms 10 15,282 1s42ms 0ms 11 20,039 1s564ms 0ms 12 33,395 2s344ms 0ms 13 15,900 1s45ms 0ms 14 15,339 978ms 0ms 15 56,129 3s192ms 0ms 16 11,915 853ms 0ms 17 11,600 895ms 0ms 18 8,695 739ms 0ms 19 7,548 689ms 0ms 20 5,154 665ms 0ms 21 3,819 529ms 0ms 22 3,513 208ms 0ms -
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-15 17:21:52 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-15 17:21:52 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2025-01-15 17:21:52 Duration: 1ms
16 166,044 10s248ms 0ms 1ms 0ms select "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" from "urgent_warehouse" where "urgent_warehouse".id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 00 3,006 149ms 0ms 01 2,382 102ms 0ms 02 1,778 80ms 0ms 03 2,470 101ms 0ms 04 1,720 73ms 0ms 05 1,513 64ms 0ms 06 1,933 88ms 0ms 07 1,118 53ms 0ms 08 3,741 246ms 0ms 09 7,079 470ms 0ms 10 10,532 700ms 0ms 11 12,101 1s37ms 0ms 12 10,904 847ms 0ms 13 9,913 762ms 0ms 14 9,081 625ms 0ms 15 52,899 2s280ms 0ms 16 6,656 478ms 0ms 17 7,798 634ms 0ms 18 5,393 400ms 0ms 19 5,252 371ms 0ms 20 3,947 306ms 0ms 21 2,991 255ms 0ms 22 1,837 115ms 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 (18, 28, 16, 42, 46);
Date: 2025-01-15 15:51:53 Duration: 1ms
-
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (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-01-15 11:40:05 Duration: 0ms
-
SELECT "urgent_warehouse"."id" AS "id", "urgent_warehouse"."active" AS "active", "urgent_warehouse"."name" AS "name", "urgent_warehouse"."create_uid" AS "create_uid", "urgent_warehouse"."create_date" AS "create_date", "urgent_warehouse"."write_uid" AS "write_uid", "urgent_warehouse"."write_date" AS "write_date" FROM "urgent_warehouse" WHERE "urgent_warehouse".id IN (46);
Date: 2025-01-15 13:02:45 Duration: 0ms
17 161,742 51s663ms 0ms 2ms 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 #17
Day Hour Count Duration Avg duration Jan 15 00 18,826 5s320ms 0ms 01 11,171 3s308ms 0ms 02 10,087 3s106ms 0ms 03 7,582 2s578ms 0ms 04 9,709 2s910ms 0ms 05 2,382 1s59ms 0ms 06 2,544 950ms 0ms 07 6,267 1s926ms 0ms 08 1,575 521ms 0ms 09 1,147 535ms 0ms 10 1,776 832ms 0ms 11 2,192 1s17ms 0ms 12 1,090 485ms 0ms 13 1,914 688ms 0ms 14 2,441 857ms 0ms 15 3,866 1s330ms 0ms 16 7,218 2s466ms 0ms 17 11,794 3s842ms 0ms 18 12,278 3s750ms 0ms 19 10,346 3s220ms 0ms 20 13,601 4s442ms 0ms 21 14,888 4s617ms 0ms 22 7,048 1s895ms 0ms -
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 27) AND ("price_list"."to_office_id" = 24)) ORDER BY "price_list"."id";
Date: 2025-01-15 20:48:32 Duration: 2ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 17) AND ("price_list"."to_office_id" = 39)) ORDER BY "price_list"."id";
Date: 2025-01-15 21:26:12 Duration: 1ms
-
SELECT "price_list".id FROM "price_list" WHERE (("price_list"."from_office_id" = 24) AND ("price_list"."to_office_id" = 126)) ORDER BY "price_list"."id";
Date: 2025-01-15 11:07:58 Duration: 1ms
18 153,086 1m25s 0ms 46ms 0ms select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" from "shipping_policy" where "shipping_policy".id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 00 482 268ms 0ms 01 178 116ms 0ms 02 224 129ms 0ms 03 225 134ms 0ms 04 255 133ms 0ms 05 177 103ms 0ms 06 1,099 588ms 0ms 07 1,553 883ms 0ms 08 3,014 1s759ms 0ms 09 8,853 5s1ms 0ms 10 8,187 4s359ms 0ms 11 10,109 6s332ms 0ms 12 10,665 6s696ms 0ms 13 11,386 8s723ms 0ms 14 10,949 6s121ms 0ms 15 8,853 4s836ms 0ms 16 10,640 5s854ms 0ms 17 9,544 4s969ms 0ms 18 13,445 6s864ms 0ms 19 7,102 3s543ms 0ms 20 18,311 9s59ms 0ms 21 16,412 7s786ms 0ms 22 1,423 1s152ms 0ms -
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4455015, 4455018, 4328035, 4426257, 4472347, 4417096, 4288275, 4465099, 4438952, 4446849, 4359208, 4486426, 4454279, 4384371, 4465083, 4413911, 4408865, 4446107, 4466786, 4407788, 4454323, 4324200, 3959802, 4442087, 4455627, 4417507, 4454066, 4382644, 4478103, 4477974, 4465816, 4365341, 4491874, 4313144, 4471936, 4490267, 4461188, 4291131, 4431956, 4422032, 4421362, 4396328, 4373760, 4451800, 4455296, 4412578, 4451839, 4446837, 4453564, 4396666, 4416046, 4446857, 4451867, 4430048, 4431667, 4450567, 4422059, 4451883, 4362261, 4430425, 4421085, 4433247, 4447628, 4425563, 4420809, 4438444, 4432455, 4432695, 4446816, 4431857, 4446862, 4254465, 4383969, 4281346, 4379513, 4432075, 4373694, 4432063, 4413056, 4438223, 4404561, 4225187, 4417099, 4414113, 4339207, 4386649, 4348151, 4424020, 4399540, 4400552, 4417230, 4414458, 4422035, 4358085, 4422046, 4374512, 4404166, 4384180, 4169700, 4407489, 4303249, 4424000, 4395922, 4405294, 4382937, 4332220, 4414478, 4422020, 4415925, 3767217, 4353762, 4359209, 4404169, 4406050, 4410336, 4369265, 4396926, 4414430, 4421372, 4408571, 4338572, 4365644, 4345602, 4396340, 4332223, 4401701, 4403468, 4425227, 4401652, 4292491, 4316096, 4414449, 4401674, 4307530, 4396377, 4190921, 4420341, 4413378, 4392095, 4248064, 4372791, 4407100, 4280698, 3716694, 4384687, 4396359, 4312903, 4392633, 4424027, 4353079, 4420348, 4207939, 4320388, 4372286, 4386328, 4380191, 4397006, 3930790, 4390299, 4379462, 4397108, 4394139, 4401686, 4343609, 4386868, 4319847, 4386528, 4396397, 4394210, 4351809, 4313222, 4395554, 4106295, 4386887, 4389183, 4386487, 3727834, 4388766, 4385132, 4392215, 4394946, 4383929, 4378458, 4403835, 4388859, 4378383, 4395655, 4384404, 4373279, 4359210, 4381074, 4372597, 4379054, 4388805, 4236940, 4395204, 4352245);
Date: 2025-01-15 17:21:53 Duration: 46ms
-
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4443500, 4445104, 4443237, 4446699, 4446796, 4447748, 4374642, 4374616, 4447026, 4445046, 4446696, 4443315, 4448684, 4373823, 4448803, 4436688, 4446783, 4447881, 4402571, 4448949, 4372766, 4443296, 4374238, 4447884, 4399056, 4445100, 4447746, 4436514, 4446790, 4447713, 4397952, 4446680, 4448989, 4447698, 4402546, 4447939, 4448978, 4447741, 4443310, 4374602, 4295737, 4448763, 4444965, 4436686, 4445180, 4401755, 4324306, 4448657, 4448980, 4447978, 4212737, 4273723, 4401776, 4444980, 4448821, 4400818, 4400541, 4448985, 4361588, 4374256, 4170011, 4436511, 4447079, 4443287, 4447894, 4398965, 4374227, 4361392, 4400611, 4325014, 4444971, 4444976, 4445217, 4436681, 4399378, 4400588, 4436659, 4446698, 4436484, 4443498, 4445169, 4436662, 4325099, 4448948, 4447073, 4447910, 4418954, 4325923, 4396666, 4443243, 4374770, 4374725, 4396719, 4400556, 4399284, 4396706, 4292682, 4352020, 4447947, 4448045, 4436694, 4444968, 4444978, 4398903, 4399424, 4436466, 4371982, 4396691, 4396469, 4400625, 4304868, 4354270, 4399362, 4372638, 3993913, 4400620, 4357139, 4321414, 4372796, 4355468, 4397987, 4360933, 4397447, 4402620, 4211009, 4402282, 4112277, 4216312, 4324153, 4400613, 4328588, 4396699, 4397375, 4361394, 4400795, 4396690, 4188120, 4400590, 4328730, 4397448, 4399324, 4396687, 4397214, 4400586, 4426556, 4418953, 4400745, 4400618, 4399250, 4396522, 4297567, 4400785, 4400819, 3948765, 4397192, 4402407, 4418934, 4396463, 4418936, 4330415, 4397163, 4348502, 4350796, 4402570, 4353829, 4402445, 4372895, 4399375, 4400589, 4399227, 4114424, 4396748, 4269042, 4352044, 4397440, 4398008, 4324273, 4400758, 4354341, 4373821, 4374239, 4400552, 4372800, 4404166, 4402726, 4396776, 4373596, 4400551, 4372079, 4372666, 4360979, 4400385, 4373871, 4170197, 4353894, 4339276, 4372794, 4402316, 4374756);
Date: 2025-01-15 11:26:12 Duration: 13ms
-
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."zero_date_change" AS "zero_date_change", "shipping_policy"."zero_date_change_user" AS "zero_date_change_user", "shipping_policy"."d_unlink_delete" AS "d_unlink_delete", "shipping_policy"."name" AS "name", "shipping_policy"."notebook_package_id" AS "notebook_package_id", "shipping_policy"."policy_id" AS "policy_id", "shipping_policy"."pol_name" AS "pol_name", "shipping_policy"."delegate_policy_id" AS "delegate_policy_id", "shipping_policy"."office_policy_id" AS "office_policy_id", "shipping_policy"."from_office" AS "from_office", "shipping_policy"."to_office" AS "to_office", "shipping_policy"."from_state" AS "from_state", "shipping_policy"."to_state" AS "to_state", "shipping_policy"."return_before" AS "return_before", "shipping_policy"."state" AS "state", "shipping_policy"."driver_id" AS "driver_id", "shipping_policy"."delegate_id" AS "delegate_id", "shipping_policy"."out_date" AS "out_date", "shipping_policy"."review_state" AS "review_state", "shipping_policy"."review_date" AS "review_date", "shipping_policy"."customer_id" AS "customer_id", "shipping_policy"."customer_receive_id" AS "customer_receive_id", "shipping_policy"."sender_mob" AS "sender_mob", "shipping_policy"."sender_name" AS "sender_name", "shipping_policy"."receive_mob" AS "receive_mob", "shipping_policy"."receive_name" AS "receive_name", "shipping_policy"."sender_add" AS "sender_add", "shipping_policy"."receive_add" AS "receive_add", "shipping_policy"."receive_man_id" AS "receive_man_id", "shipping_policy"."receive_man_id_no" AS "receive_man_id_no", "shipping_policy"."cash_policy_id" AS "cash_policy_id", "shipping_policy"."total_amount_cash_lines" AS "total_amount_cash_lines", "shipping_policy"."cash" AS "cash", "shipping_policy"."cash_amount" AS "cash_amount", "shipping_policy"."cheques" AS "cheques", "shipping_policy"."cheque_desc" AS "cheque_desc", "shipping_policy"."collection_amount_sender" AS "collection_amount_sender", "shipping_policy"."collection_amount_receive" AS "collection_amount_receive", "shipping_policy"."total_collection_amount" AS "total_collection_amount", "shipping_policy"."last_driver" AS "last_driver", "shipping_policy"."return_reason" AS "return_reason", "shipping_policy"."wating_reason" AS "wating_reason", "shipping_policy"."last_office" AS "last_office", "shipping_policy"."last_car" AS "last_car", "shipping_policy"."last_office_warehouse" AS "last_office_warehouse", "shipping_policy"."last_warehouse" AS "last_warehouse", "shipping_policy"."last_action" AS "last_action", "shipping_policy"."destination_office" AS "destination_office", "shipping_policy"."new_destination_button" AS "new_destination_button", "shipping_policy"."edit_cash_button" AS "edit_cash_button", "shipping_policy"."create_cash_policy_button" AS "create_cash_policy_button", "shipping_policy"."client_delivery_button" AS "client_delivery_button", "shipping_policy"."return_button" AS "return_button", "shipping_policy"."delegate_button" AS "delegate_button", "shipping_policy"."old_policy" AS "old_policy", "shipping_policy"."total_no_items" AS "total_no_items", "shipping_policy"."total_shipping_price" AS "total_shipping_price", "shipping_policy"."scan_code" AS "scan_code", "shipping_policy"."destination_type" AS "destination_type", "shipping_policy"."from_poilcy" AS "from_poilcy", "shipping_policy"."cancel_shipping_policy" AS "cancel_shipping_policy", "shipping_policy"."confirm_date" AS "confirm_date", "shipping_policy"."client_date" AS "client_date", "shipping_policy"."archive_date" AS "archive_date", "shipping_policy"."cancel_date" AS "cancel_date", "shipping_policy"."return_date" AS "return_date", "shipping_policy"."wating_date" AS "wating_date", "shipping_policy"."create_date" AS "create_date", "shipping_policy"."state_collection" AS "state_collection", "shipping_policy"."before_office_id" AS "before_office_id", "shipping_policy"."paid_by_customer" AS "paid_by_customer", "shipping_policy"."create_uid" AS "create_uid", "shipping_policy"."write_uid" AS "write_uid", "shipping_policy"."write_date" AS "write_date", "shipping_policy"."count_search" AS "count_search", "shipping_policy"."attachment_date" AS "attachment_date", "shipping_policy"."attachment_user" AS "attachment_user" FROM "shipping_policy" WHERE "shipping_policy".id IN (4169159, 4400108, 4332523, 4366337, 4364558, 4358970, 4323915, 4184867, 4291956, 4364789, 4323992, 4359241, 4358947, 4375863, 4396279, 4323864, 4409185, 4220890, 4396300, 4375869, 4364407, 4361998, 4361940, 4401695, 4358979, 4375457, 4374562, 4374533, 4334329, 4398169, 4185850, 4299015, 4300765, 4374106, 4302279, 4360219, 4357269, 4361966, 4360286, 4374574, 4358981, 4358978, 4304203, 4358968, 4305289, 4372633, 4362626, 4361991, 4061149, 4305568, 4277308, 4358934, 4332292, 4173692, 4364930, 4362639, 4373066, 4362747, 4190798, 4358980, 4375543, 4364173, 4215346, 4138820, 4329265, 4366048, 4327559, 4305533, 4358963, 4002506, 4243549, 4334004, 4332338, 4333884, 4358973, 4361771, 4359240, 4358930, 4364883, 4328497, 4303724, 4220402, 4175230, 4358931, 4333525, 4375376, 4330803, 4358946, 4364634, 4358976, 4358932, 4305936, 4323919, 4362246, 4363183, 4358960, 4359213, 3984910, 4272752, 4359229, 4358961, 4163571, 4324738, 4357565, 4330984, 4332268, 4358964, 4334171, 4358965, 4323862, 4363726, 4277280, 4274529, 4363792, 4323893, 4364974, 3785261, 4363985, 4330014, 4323878, 4323988, 4323843, 4305348, 4330115, 4305377, 4323828, 4300370, 2996220, 4323936, 4304138, 4089670, 4323891, 4323850, 4324713, 4335972, 4328394, 4323929, 4262986, 4327644, 4328820, 4323907, 4328789, 4328487, 4333010, 4333564, 4328133, 4333522, 4328135, 4291946, 4118478, 4323884, 4312204, 4334448, 4305916, 4238325, 4215124, 3768753, 4304829, 4332734, 4303256, 4323912, 4274468, 4291941, 4274508, 4332835, 4179294, 4332833, 4332515, 4361840, 4333344, 4274467, 4274752, 4305541, 4304230, 4323869, 4138000, 4303692, 3211056, 4304173, 4323942, 4327530, 4190094, 4291942, 4305297, 4275493, 4243557, 4323835, 4276050, 3915464, 4305538, 4305526, 4291944, 4323871, 4323895, 4312209, 4277343, 4333494, 4323897, 4243581, 4274483, 4323834, 4262947, 4323922, 3469174, 4291960, 4333311, 4323881, 3951855, 4218253, 4215393, 3783223, 4323885, 4163487, 4323910, 4269894, 4323867, 4332233, 4118219, 4275622, 4323857, 4185840, 4247270, 4323877, 4263008, 4051323, 4323900, 4273460, 3804273, 4274762, 4269893, 4274485, 4277348, 4308156, 4304325, 4118467, 4090888, 4163552, 4051370, 4335990, 4274286, 4305915, 4305364, 4276764, 4276755, 4274775, 4305971, 4262954, 4245626, 4297809, 4296367, 4297792, 4141912, 4298104, 4278732, 4184876, 4305581, 4305520, 4276653, 4135065, 4262990, 4247813, 4305908, 4305900, 4276012, 4088224, 4274461, 4300359, 4269892, 4220266, 4276988, 4262980, 4186315, 4247824, 3312215, 4270210, 4263013, 4274312, 4269910, 4269900, 4276043, 4274353, 4274528, 4238320, 4238330, 4269902, 4220797, 4262996, 4183485, 4269891, 3785203, 4263001, 4269901, 4269904, 4118493, 3951383, 4184877, 4262961, 4217579, 4238323, 4274498, 4184852, 4276666, 4273448, 4051339, 4220869, 4247895, 4273462, 4269895, 4183479, 4248321, 4245633, 4238151, 4183470, 4209622, 4209473, 4238127, 4169155, 4209478, 4163615, 4247724, 4184878, 4209626, 4184875, 4221659, 4248317, 4247870, 4247874, 4262662, 4262648, 4247876, 4238328, 4247872, 4175206, 4247268, 3403239, 4238322, 4094893, 4163577, 4244700, 4247741, 4247726, 4238155, 4250886, 4238327, 4183465, 4113648, 4173543, 4247884, 4184860, 4091400, 4184872, 4172197, 4138877, 4247258, 4247471, 4244993, 4244314, 4163627, 3975498, 4183488, 4219581, 4184861, 4143812, 4183476, 4217568, 4184855, 4209630, 4184865, 4029275, 3911685, 4118621, 3997839, 4221619, 4051364, 4163538, 4190732, 4209445, 4168802, 4217887, 4184866, 4220444, 3442640, 3246948, 3780688, 4173461, 4209471, 3986764, 4209469, 4183496, 4216399, 4137782, 4034433, 4216398, 4222115, 4132305, 4135009, 4135121, 4115897, 4135069, 4163544, 4118248, 3402998, 3516968, 4163631, 4145661, 4184871, 4163574, 4048413, 4175454, 4051312, 4175372, 4183491, 4143797, 4172516, 4135216, 3997842, 4184869, 4184859, 4183473, 4089456, 3773944, 4184857, 3997840, 4183498, 4184854, 4183482, 4183459, 4184862, 4091433, 3737127, 4168716, 4135086, 4183501, 4175832, 4184868, 4135011, 3854080, 4184873, 4163547, 4163623, 4184863, 4163550, 4163583, 4183453, 3770251, 4184851, 4118497, 4183467, 4115516, 4184850, 4090952, 3975668, 4184870, 4175869, 4135012, 4163492, 4135081, 4163625, 4163635, 4173607, 4135072, 4175330, 4175287, 4186317, 4183462, 4163541, 4184858, 4163580, 4115880, 4178446, 4183456, 4132293, 4163565, 4163617, 4168718, 3771070, 4138922, 4112838, 4132281, 4132302, 4139892, 4142163, 4132277, 4135006, 4135074, 4163556, 4174380, 4135004, 3915473, 4132285, 4116837, 4163639, 4163637, 4135008, 4115885, 4163562, 4163633, 4118500, 4115912, 4173067, 4135078, 4143143, 4135085, 4134949, 4118107, 4015607, 4135088, 4143792, 4118465, 3975571, 3517277, 4135060, 4135077, 4117882, 4163619, 4116937, 4115883, 4138900, 4138011, 4135067, 4119893, 4135057, 4135013, 4015627, 4118119, 4137877, 4135005, 3735302, 4118566, 4090738, 4135141, 4115884, 4118249, 4135080, 3851219, 4135010, 4118202, 4135062, 4115904, 4015647, 4115502, 4135059, 4009511, 4081792, 4015604, 4091363, 4115905, 4118466, 4088790, 4118258, 4090751, 4115894, 4118507, 4115806, 4118505, 4115901, 4116408, 4115896, 3851212, 4118463, 4118464, 4115878, 4118562, 4118460, 4115899, 4113394, 4118599, 4118502, 4118479, 4029603, 4116208, 4086890, 4118481, 4115876, 4115914, 4113736, 4080635, 3826094, 4086163, 4060991, 4090679, 4086882, 4086892, 4086887, 4086895, 3957339, 4086884, 4015651, 4059648, 4037534, 4057504, 3594721, 3987741, 4059199, 4015632, 4015692, 4009507, 4030804, 4015696, 4015625, 4009502, 4026230, 4015663, 4009516, 4015655, 4015674, 4015611, 4027553, 4009499, 3887289, 4015600, 4015616, 4030287, 4015643, 4029600, 3957330, 4015705, 3986463, 2458943, 3986328, 3921027, 3957370, 3985512, 3951385, 3988974, 3989702, 3957200, 3957369, 4004148, 3948758, 3921940, 3477016, 3957300, 3957501, 3957264, 3669425, 3922497, 3957317, 3921734, 3966743, 3957121, 3924497, 3922431, 3921729, 3921679, 3826223, 3736817, 3629744, 3736804, 3704484, 3825818, 3669678, 3825481, 3757489, 3737203, 3669836, 3737188, 3738881, 3735241, 3735282, 3735283, 3736090, 3777926, 3768816, 3736065, 3735024, 3738269, 3735259, 3736074, 3748528, 3737149, 3737161, 3737229, 3737151, 3669745, 3669701, 3669275, 3669353, 3669292, 3442131, 1544912, 3008319, 1544915, 1544907, 1544910, 1544917, 1544909);
Date: 2025-01-15 13:20:24 Duration: 11ms
19 151,031 8s713ms 0ms 1ms 0ms select "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" from "ir_rule" where "ir_rule".id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 00 994 51ms 0ms 01 790 40ms 0ms 02 761 38ms 0ms 03 461 22ms 0ms 04 388 19ms 0ms 05 381 19ms 0ms 06 764 39ms 0ms 07 680 35ms 0ms 08 4,170 222ms 0ms 09 6,935 406ms 0ms 10 12,358 668ms 0ms 11 19,156 1s157ms 0ms 12 16,088 924ms 0ms 13 15,680 890ms 0ms 14 12,311 689ms 0ms 15 16,454 972ms 0ms 16 8,654 513ms 0ms 17 10,084 608ms 0ms 18 7,142 411ms 0ms 19 5,721 327ms 0ms 20 4,307 267ms 0ms 21 4,317 265ms 0ms 22 2,435 118ms 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 (13);
Date: 2025-01-15 10:43:23 Duration: 1ms
-
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (89);
Date: 2025-01-15 17:58:29 Duration: 0ms
-
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (98, 99);
Date: 2025-01-15 09:33:30 Duration: 0ms
20 146,525 1h50m7s 33ms 222ms 45ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 00 3,684 2m35s 42ms 01 3,255 2m17s 42ms 02 2,531 1m47s 42ms 03 2,573 1m48s 42ms 04 2,680 1m51s 41ms 05 1,399 58s772ms 42ms 06 1,526 1m4s 42ms 07 1,201 50s263ms 41ms 08 3,056 2m9s 42ms 09 9,365 6m59s 44ms 10 10,143 7m32s 44ms 11 13,546 10m31s 46ms 12 13,033 9m55s 45ms 13 9,817 7m21s 44ms 14 8,732 6m25s 44ms 15 7,589 5m48s 45ms 16 9,617 7m26s 46ms 17 9,485 7m22s 46ms 18 7,995 6m6s 45ms 19 9,878 7m26s 45ms 20 6,566 5m8s 46ms 21 6,156 4m44s 46ms 22 2,698 1m55s 42ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4404459)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:59 Duration: 222ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4453656)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:23 Duration: 218ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4428636)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:52:13 Duration: 190ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 59m59s 2m26s 49 1h59m55s update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 15 00 1 0ms 0ms 03 1 59m56s 59m56s 04 1 0ms 0ms 08 2 0ms 0ms 09 3 0ms 0ms 10 4 4ms 1ms 11 5 9ms 1ms 12 2 1ms 0ms 13 8 6ms 0ms 14 3 5ms 1ms 15 1 3ms 3ms 16 4 2ms 0ms 17 2 1ms 0ms 18 1 2ms 2ms 19 6 5ms 0ms 20 3 0ms 0ms 22 2 59m59s 29m59s -
UPDATE "res_users" SET "exp_date" = '2025-01-15 21:01:03.912132', "last_update" = '2025-01-15 20:16:03.912171', "write_date" = '2025-01-15 20:16:03.489562', "write_uid" = 1 WHERE id IN (1229);
Date: 2025-01-15 22:16:03 Duration: 59m59s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 02:24:58.367642', "last_update" = '2025-01-15 01:39:58.367662', "write_date" = '2025-01-15 01:39:58.046667', "write_uid" = 1 WHERE id IN (1053);
Date: 2025-01-15 03:39:54 Duration: 59m56s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 15:00:33.909572', "last_update" = '2025-01-15 14:15:33.909599', "write_date" = '2025-01-15 14:15:33.489377', "write_uid" = 1034 WHERE id IN (1034);
Date: 2025-01-15 15:15:33 Duration: 3ms
2 0ms 31m24s 16s46ms 307 1h22m6s update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 15 00 2 2ms 1ms 01 7 1ms 0ms 02 5 1ms 0ms 03 2 31m24s 15m42s 04 1 0ms 0ms 05 1 0ms 0ms 06 5 0ms 0ms 07 1 0ms 0ms 08 13 2ms 0ms 09 22 5ms 0ms 10 37 16m50s 27s321ms 11 24 4m41s 11s717ms 12 27 33ms 1ms 13 28 10m13s 21s921ms 14 20 15ms 0ms 15 22 2m48s 7s663ms 16 20 16ms 0ms 17 11 9ms 0ms 18 9 1m54s 12s712ms 19 15 11ms 0ms 20 18 14m13s 47s399ms 21 8 12ms 1ms 22 9 3ms 0ms -
UPDATE "res_users" SET "exp_date" = '2025-01-15 02:53:30.578086', "last_update" = '2025-01-15 02:08:30.578108', "sid" = '1450830fbaf7359b85a8818bf78e3c665d1dc87d', "write_date" = '2025-01-15 02:08:30.256425', "write_uid" = 1053 WHERE id IN (1053);
Date: 2025-01-15 03:39:54 Duration: 31m24s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 10:06:29.960495', "last_update" = '2025-01-15 09:21:29.960523', "sid" = '7a9ae19aab0f2904bcddbc2b0de823394ec93703', "write_date" = '2025-01-15 09:21:29.590801', "write_uid" = 1 WHERE id IN (875);
Date: 2025-01-15 10:38:20 Duration: 16m50s
-
UPDATE "res_users" SET "exp_date" = '2025-01-15 12:48:07.290791', "last_update" = '2025-01-15 12:03:07.290821', "sid" = 'b6b90f6073186a1effa8f06a6dfbc083b385b665', "write_date" = '2025-01-15 12:03:06.906416', "write_uid" = 1 WHERE id IN (836);
Date: 2025-01-15 13:13:21 Duration: 10m13s
3 0ms 1h1s 3s825ms 68,092 3d21m4s update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 15 00 883 1h3m11s 4s293ms 01 1,026 226ms 0ms 02 952 15s617ms 16ms 03 1,185 53s220ms 44ms 04 808 175ms 0ms 05 783 165ms 0ms 06 765 157ms 0ms 07 601 127ms 0ms 08 1,734 361ms 0ms 09 4,451 1s12ms 0ms 10 5,693 9h58m29s 6s307ms 11 6,906 13h16m36s 6s921ms 12 6,395 7h55m50s 4s464ms 13 5,951 9h18m34s 5s631ms 14 5,453 4h9m26s 2s744ms 15 5,197 6h17m6s 4s353ms 16 4,354 20m2s 276ms 17 4,143 1s143ms 0ms 18 3,196 12h37m49s 14s227ms 19 2,687 13m55s 311ms 20 2,159 3h20m49s 5s580ms 21 1,688 3m52s 137ms 22 1,082 3h44m7s 12s428ms -
update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949180', exp_date = '2025-01-15 21:24:32.949184', logged_in = 'TRUE' where id = 870;
Date: 2025-01-15 22:39:34 Duration: 1h1s
-
update res_users set sid = '4d57579fe0fba19f9cd9031bb9cfdd1d706a8357', last_update = '2025-01-15 20:39:32.949188', exp_date = '2025-01-15 21:24:32.949190', logged_in = 'TRUE' where id = 870;
Date: 2025-01-15 22:39:34 Duration: 1h1s
-
update res_users set sid = '5029a0aa891187345599bf82a70ab2c6fa0b902f', last_update = '2025-01-15 20:19:21.196181', exp_date = '2025-01-15 21:04:21.196185', logged_in = 'TRUE' where id = 1229;
Date: 2025-01-15 22:16:03 Duration: 56m42s
4 12ms 4s560ms 2s760ms 237 10m54s select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 15 02 5 15s442ms 3s88ms 09 18 59s186ms 3s288ms 11 4 3s577ms 894ms 12 11 25s32ms 2s275ms 13 17 56s341ms 3s314ms 14 10 34s619ms 3s461ms 15 20 50s254ms 2s512ms 16 29 1m34s 3s265ms 17 14 15s132ms 1s80ms 18 32 1m15s 2s366ms 19 16 50s732ms 3s170ms 20 27 1m1s 2s272ms 21 25 1m25s 3s406ms 22 9 26s971ms 2s996ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:38 Duration: 4s560ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%9836685%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:41 Duration: 4s525ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))))))) AND ("policy_number"."name"::text ilike '%98%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2025-01-15 20:57:38 Duration: 4s285ms
5 214ms 1s626ms 921ms 15,305 3h55m3s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 15 00 1,806 26m52s 892ms 01 310 4m38s 897ms 02 1,677 25m5s 897ms 03 511 7m34s 889ms 04 511 7m33s 888ms 05 61 54s132ms 887ms 06 278 4m6s 885ms 08 10 8s909ms 890ms 09 9 8s313ms 923ms 10 99 1m36s 979ms 11 8 7s614ms 951ms 12 9 8s803ms 978ms 13 116 1m51s 957ms 14 285 4m30s 949ms 15 327 5m13s 957ms 16 708 12m4s 1s22ms 17 1,542 25m12s 981ms 18 1,932 28m26s 883ms 19 1,389 20m1s 865ms 20 1,779 29m5s 981ms 21 1,558 24m 924ms 22 380 5m43s 903ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9732719')) 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 (113))))))) 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 (113)))))) 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 (113)))))) 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 (113))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 17:21:56 Duration: 1s626ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9909116')) 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 (11))))))) 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 (11)))))) 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 (11)))))) 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 (11))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 16:08:44 Duration: 1s614ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9923380')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 16:08:45 Duration: 1s431ms
6 477ms 4s160ms 573ms 44,228 7h2m55s select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 15 00 204 1m55s 565ms 01 197 1m52s 571ms 02 304 2m47s 551ms 03 188 1m52s 598ms 04 222 2m5s 565ms 05 282 2m33s 544ms 06 513 4m28s 522ms 07 199 1m46s 535ms 08 929 8m15s 533ms 09 3,802 35m30s 560ms 10 2,749 26m1s 568ms 11 3,841 37m55s 592ms 12 3,888 37m28s 578ms 13 3,293 31m8s 567ms 14 2,628 24m31s 559ms 15 3,759 36m12s 577ms 16 4,561 44m31s 585ms 17 3,352 32m51s 588ms 18 2,147 20m34s 574ms 19 3,017 28m22s 564ms 20 1,794 17m57s 600ms 21 1,380 13m31s 588ms 22 979 8m41s 532ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4487764, 4469084, 4460438, 4458937, 4455055, 4431327, 4411960, 4404459, 4361498)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:16 Duration: 4s160ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4367883)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:24 Duration: 3s341ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4247780)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:59 Duration: 3s288ms
7 475ms 4s451ms 561ms 261,919 1d16h52m15s select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 15 00 10,536 1h37m8s 553ms 01 9,359 1h23m37s 536ms 02 8,325 1h14m32s 537ms 03 9,192 1h20m38s 526ms 04 7,888 1h10m10s 533ms 05 5,781 49m1s 508ms 06 4,725 40m28s 514ms 07 4,519 40m8s 532ms 08 4,501 38m46s 516ms 09 14,073 2h8m5s 546ms 10 13,310 2h31s 543ms 11 16,877 2h40m59s 572ms 12 14,995 2h19m58s 560ms 13 11,411 1h45m 552ms 14 10,594 1h35m53s 543ms 15 10,797 1h43m2s 572ms 16 15,329 2h29m19s 584ms 17 14,024 2h18m26s 592ms 18 16,802 2h41m59s 578ms 19 16,472 2h35m48s 567ms 20 16,556 2h44m58s 597ms 21 20,817 3h26m56s 596ms 22 5,036 46m41s 556ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4498064)) AND (("shipping_track"."id" not in (37127217, 37127217)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:01 Duration: 4s451ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4437963)) AND (("shipping_track"."id" not in (36687263, 36703571, 36703963, 36755370, 36755934, 36756041, 36896803, 36951885, 37127154, 37127154)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:51:51 Duration: 3s384ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4247780)) AND (("shipping_track"."id" not in (34893528, 34894245, 34902078, 34902244, 34930509, 34930981, 34991384, 35594697, 37127136, 37127215, 37127215)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2025-01-15 15:52:02 Duration: 3s12ms
8 172ms 746ms 294ms 19,831 1h37m18s select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 15 07 117 30s127ms 257ms 08 797 3m28s 261ms 09 2,627 12m47s 292ms 10 1,214 6m19s 312ms 11 1,671 8m1s 288ms 12 1,286 6m23s 298ms 13 2,218 10m41s 289ms 14 2,020 10m7s 300ms 15 1,714 9m10s 321ms 16 2,638 12m55s 293ms 17 2,304 11m9s 290ms 18 1,031 4m48s 279ms 19 194 54s482ms 280ms -
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" = '9779239')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:17 Duration: 746ms
-
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" = '9779035')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:19 Duration: 680ms
-
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" = '')))) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:24 Duration: 675ms
9 201ms 1s293ms 274ms 20,008 1h31m37s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 15 00 2,610 11m49s 271ms 01 2,035 9m22s 276ms 02 394 1m51s 282ms 03 729 3m18s 272ms 04 1,549 7m9s 277ms 07 1,271 5m49s 274ms 08 249 1m8s 273ms 09 48 14s117ms 294ms 10 11 3s104ms 282ms 11 207 1m6s 322ms 12 107 32s595ms 304ms 13 250 1m13s 295ms 14 165 47s669ms 288ms 15 599 3m3s 306ms 16 1,028 5m15s 306ms 17 1,370 6m14s 273ms 18 1,164 5m1s 259ms 19 1,121 4m44s 253ms 20 1,506 6m56s 276ms 21 2,197 10m1s 273ms 22 1,398 5m52s 252ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9963602')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:56 Duration: 1s293ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9925971')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:19 Duration: 701ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9829839')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2025-01-15 15:51:21 Duration: 639ms
10 18ms 937ms 269ms 2,641 11m52s select count(*) from ( select from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) limit ?) t;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 15 00 2 44ms 22ms 05 2 518ms 259ms 06 3 150ms 50ms 07 5 944ms 188ms 08 41 5s98ms 124ms 09 135 33s517ms 248ms 10 247 58s619ms 237ms 11 310 1m21s 264ms 12 361 1m40s 278ms 13 334 1m33s 280ms 14 317 1m22s 261ms 15 241 1m10s 293ms 16 174 53s934ms 309ms 17 108 34s360ms 318ms 18 89 25s890ms 290ms 19 64 25s321ms 395ms 20 56 24s127ms 430ms 21 46 15s231ms 331ms 22 106 5s158ms 48ms -
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 15:51:23 Duration: 937ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (76))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 15:51:10 Duration: 794ms
-
SELECT COUNT(*) FROM ( SELECT FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (53))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) LIMIT 10001) t;
Date: 2025-01-15 16:08:39 Duration: 725ms
11 91ms 890ms 237ms 69,729 4h35m59s 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 #11
Day Hour Count Duration Avg duration Jan 15 00 8,802 31m43s 216ms 01 4,624 17m41s 229ms 02 4,090 12m52s 188ms 03 2,440 8m28s 208ms 04 4,046 13m40s 202ms 05 118 18s676ms 158ms 06 550 1m25s 155ms 07 2,524 9m16s 220ms 08 518 1m48s 210ms 09 94 20s535ms 218ms 10 190 29s111ms 153ms 11 418 1m32s 220ms 12 228 1m 266ms 13 718 2m41s 225ms 14 892 3m13s 216ms 15 1,806 7m19s 243ms 16 3,440 14m53s 259ms 17 5,747 25m24s 265ms 18 6,114 26m44s 262ms 19 4,966 21m 253ms 20 6,486 29m14s 270ms 21 7,416 31m42s 256ms 22 3,502 13m6s 224ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:01:54 Duration: 890ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسام')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:01:54 Duration: 889ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'حسن')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2025-01-15 21:02:33 Duration: 870ms
12 160ms 1s230ms 215ms 117,494 7h1m2s 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 Jan 15 00 1,449 4m59s 206ms 01 1,533 5m14s 205ms 02 2,578 8m48s 205ms 03 3,073 10m32s 205ms 04 2,457 8m25s 205ms 05 2,791 9m36s 206ms 06 1,847 6m19s 205ms 07 1,853 6m18s 204ms 08 2,163 7m22s 204ms 09 9,092 33m20s 220ms 10 6,164 22m39s 220ms 11 5,770 21m50s 227ms 12 4,131 15m36s 226ms 13 5,762 21m6s 219ms 14 5,787 20m45s 215ms 15 6,006 24m33s 245ms 16 7,590 29m1s 229ms 17 8,957 30m47s 206ms 18 7,945 25m52s 195ms 19 2,839 9m13s 194ms 20 23,036 1h23m4s 216ms 21 4,372 14m40s 201ms 22 299 52s898ms 176ms -
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" = '9767847')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:03 Duration: 1s230ms
-
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" = '9817183')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:48 Duration: 1s36ms
-
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" = '9767944')) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:06 Duration: 972ms
13 163ms 375ms 211ms 13,395 47m9s 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 #13
Day Hour Count Duration Avg duration Jan 15 00 144 30s525ms 211ms 01 298 1m1s 206ms 02 473 1m37s 205ms 03 13 2s670ms 205ms 04 286 59s273ms 207ms 05 550 1m53s 207ms 06 1,186 4m3s 205ms 07 745 2m32s 204ms 08 518 1m46s 205ms 09 1,629 5m54s 217ms 10 412 1m30s 218ms 11 1,433 5m24s 226ms 12 952 3m30s 221ms 13 776 2m44s 212ms 14 1,025 3m40s 215ms 15 622 2m23s 230ms 16 284 1m2s 220ms 17 698 2m22s 204ms 18 259 47s914ms 184ms 19 261 47s327ms 181ms 20 378 1m11s 189ms 21 200 36s78ms 180ms 22 253 44s801ms 177ms -
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" = '9862101')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:59 Duration: 375ms
-
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9790644')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:52:01 Duration: 374ms
-
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" = '9817894')) 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 (30)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (30))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 15:51:53 Duration: 372ms
14 170ms 257ms 205ms 12,293 42m8s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 15 00 1,304 4m28s 206ms 01 1,235 4m13s 205ms 02 1,822 6m14s 205ms 03 2,915 9m59s 205ms 04 2,107 7m13s 205ms 05 2,207 7m34s 206ms 06 661 2m15s 205ms 22 42 7s509ms 178ms -
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" = '9919562')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 115)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 02:37:34 Duration: 257ms
-
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" = '9812642')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 04:32:01 Duration: 254ms
-
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" = '9714610')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2025-01-15 02:44:42 Duration: 253ms
15 122ms 1s67ms 164ms 6,200 16m58s select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 15 01 5 743ms 148ms 08 68 10s178ms 149ms 09 333 55s88ms 165ms 10 1,084 2m52s 159ms 11 1,175 3m20s 170ms 12 1,129 3m9s 168ms 13 555 1m31s 165ms 14 711 1m52s 158ms 15 398 1m10s 177ms 16 195 33s201ms 170ms 17 234 36s486ms 155ms 18 130 19s38ms 146ms 19 75 10s536ms 140ms 20 37 5s323ms 143ms 21 57 8s576ms 150ms 22 14 1s852ms 132ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 66)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:51:53 Duration: 1s67ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 10)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:52:41 Duration: 998ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 17)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2025-01-15 15:51:54 Duration: 784ms
16 0ms 8m31s 126ms 35,399 1h14m44s update "policy_number" set "done" = true, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 15 00 4,360 59m21s 816ms 01 2,315 8m37s 223ms 02 2,041 1m12s 35ms 03 1,212 1m27s 71ms 04 2,021 1m19s 39ms 05 62 10ms 0ms 06 281 49ms 0ms 07 1,262 258ms 0ms 08 270 51ms 0ms 09 109 36ms 0ms 10 133 44ms 0ms 11 252 79ms 0ms 12 160 48ms 0ms 13 405 120ms 0ms 14 480 121ms 0ms 15 953 261ms 0ms 16 1,785 527ms 0ms 17 2,932 875ms 0ms 18 3,079 868ms 0ms 19 2,527 18s202ms 7ms 20 3,264 2m23s 43ms 21 3,730 1s2ms 0ms 22 1,766 471ms 0ms -
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:49:50.539409', "write_uid" = 1224 WHERE id IN (32657720);
Date: 2025-01-15 00:58:23 Duration: 8m31s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:42:57.746450', "write_uid" = 1244 WHERE id IN (32657720);
Date: 2025-01-15 00:48:00 Duration: 5m1s
-
UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:55:41.320327', "write_uid" = 1244 WHERE id IN (32657720);
Date: 2025-01-15 01:00:37 Duration: 4m54s
17 91ms 603ms 114ms 18,612 35m29s select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 15 05 16 1s745ms 109ms 06 64 7s76ms 110ms 08 116 12s978ms 111ms 09 979 1m53s 115ms 10 1,302 2m24s 110ms 11 2,251 4m23s 117ms 12 1,997 3m51s 115ms 13 2,369 4m29s 113ms 14 2,162 3m57s 109ms 15 1,895 3m36s 114ms 16 1,624 3m12s 118ms 17 789 1m32s 116ms 18 1,032 1m56s 113ms 19 621 1m11s 115ms 20 395 47s208ms 119ms 21 447 53s821ms 120ms 22 553 58s870ms 106ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7987836)) AND (("cash_track"."id" not in (6992568)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 15:51:21 Duration: 603ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7987838)) AND (("cash_track"."id" not in (6992588)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 15:52:13 Duration: 344ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7988632)) AND (("cash_track"."id" not in (6997186)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2025-01-15 17:23:44 Duration: 289ms
18 46ms 177ms 62ms 48,828 50m33s select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 15 00 17 1s5ms 59ms 01 7 417ms 59ms 02 29 1s739ms 59ms 03 5 285ms 57ms 04 1 53ms 53ms 05 4 246ms 61ms 06 5 311ms 62ms 07 244 14s17ms 57ms 08 1,601 1m32s 58ms 09 5,263 5m21s 61ms 10 2,309 2m23s 62ms 11 4,492 4m46s 63ms 12 3,431 3m37s 63ms 13 4,694 4m52s 62ms 14 4,384 4m29s 61ms 15 3,945 4m13s 64ms 16 4,793 5m5s 63ms 17 4,474 4m34s 61ms 18 3,650 3m42s 61ms 19 4,681 4m43s 60ms 20 518 33s476ms 64ms 21 171 11s466ms 67ms 22 110 6s372ms 57ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4428636) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:52:07 Duration: 177ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4312380) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:52:03 Duration: 152ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4349561) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:57 Duration: 145ms
19 43ms 107ms 56ms 18,329 17m18s select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 15 07 117 6s244ms 53ms 08 608 32s303ms 53ms 09 2,895 2m41s 55ms 10 1,090 1m2s 56ms 11 1,393 1m21s 58ms 12 1,355 1m19s 58ms 13 1,837 1m48s 59ms 14 1,817 1m42s 56ms 15 1,596 1m32s 58ms 16 2,093 1m57s 56ms 17 1,920 1m46s 55ms 18 1,363 1m14s 54ms 19 245 13s506ms 55ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4406226) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:47 Duration: 107ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4415169) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:46 Duration: 106ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 4410453) ORDER BY "collection_policy"."id";
Date: 2025-01-15 15:51:48 Duration: 99ms
20 33ms 222ms 45ms 146,525 1h50m7s select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 15 00 3,684 2m35s 42ms 01 3,255 2m17s 42ms 02 2,531 1m47s 42ms 03 2,573 1m48s 42ms 04 2,680 1m51s 41ms 05 1,399 58s772ms 42ms 06 1,526 1m4s 42ms 07 1,201 50s263ms 41ms 08 3,056 2m9s 42ms 09 9,365 6m59s 44ms 10 10,143 7m32s 44ms 11 13,546 10m31s 46ms 12 13,033 9m55s 45ms 13 9,817 7m21s 44ms 14 8,732 6m25s 44ms 15 7,589 5m48s 45ms 16 9,617 7m26s 46ms 17 9,485 7m22s 46ms 18 7,995 6m6s 45ms 19 9,878 7m26s 45ms 20 6,566 5m8s 46ms 21 6,156 4m44s 46ms 22 2,698 1m55s 42ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4404459)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:59 Duration: 222ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4453656)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:51:23 Duration: 218ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4428636)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2025-01-15 15:52:13 Duration: 190ms
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
- 19,918,848 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 693 FATAL entries
- 4487 ERROR entries
- 0 WARNING entries
- 800 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,310 Max number of times the same event was reported
- 5,980 Total events found
Rank Times reported Error 1 2,310 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 15 00 117 01 21 02 10 03 23 04 3 05 9 06 9 07 10 08 52 09 101 10 170 11 218 12 234 13 217 14 220 15 161 16 114 17 137 18 85 19 163 20 137 21 54 22 45 - ERROR: could not serialize access due to concurrent update
- ERROR: could not serialize access due to concurrent update
- ERROR: could not serialize access due to concurrent update
Statement: update res_users set sid = '9bb84d31916523f714a9f608ccc55a2c1fc04e87', last_update = '2025-01-14 23:02:31.778750',exp_date = '2025-01-14 23:47:31.778753', logged_in = 'TRUE' where id = 1001
Date: 2025-01-15 00:02:32
Statement: update res_users set sid = '181718627a5cbb10a5faf8eff6923e759234d321', last_update = '2025-01-14 23:07:19.812456',exp_date = '2025-01-14 23:52:19.812459', logged_in = 'TRUE' where id = 1390
Date: 2025-01-15 00:07:19
Statement: update res_users set sid = '181718627a5cbb10a5faf8eff6923e759234d321', last_update = '2025-01-14 23:07:19.814310',exp_date = '2025-01-14 23:52:19.814312', logged_in = 'TRUE' where id = 1390
Date: 2025-01-15 00:07:19
2 2,113 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 15 00 116 01 20 02 7 03 22 05 8 06 9 07 10 08 48 09 77 10 155 11 203 12 231 13 209 14 210 15 153 16 91 17 129 18 74 19 146 20 104 21 43 22 48 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT active, id, login, password, totp_secret, (SELECT value FROM ir_config_parameter WHERE key='database.secret') FROM res_users WHERE id=1001
Date: 2025-01-15 00:02:32
Statement: SELECT active, id, login, password, totp_secret, (SELECT value FROM ir_config_parameter WHERE key='database.secret') FROM res_users WHERE id=1390
Date: 2025-01-15 00:07:19
Statement: SELECT "cash_policy_line"."id" AS "id", "cash_policy_line"."name" AS "name", "cash_policy_line"."currency_id" AS "currency_id", "cash_policy_line"."rate_at_creation" AS "rate_at_creation", "cash_policy_line"."amount_at_creation" AS "amount_at_creation" FROM "cash_policy_line" WHERE "cash_policy_line".id IN (1212076)
Date: 2025-01-15 00:07:19
3 484 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 15 03 1 10 45 11 112 12 69 13 84 14 28 15 66 18 47 20 30 22 2 4 484 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #4
Day Hour Count Jan 15 03 1 10 45 11 112 12 69 13 84 14 28 15 66 18 47 20 30 22 2 5 214 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #5
Day Hour Count Jan 15 03 1 10 20 11 54 12 27 13 46 14 4 15 30 16 1 17 1 18 18 19 2 20 7 22 3 6 132 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #6
Day Hour Count Jan 15 17 132 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-01-15 17:20:02
Statement: update res_users set sid = '69a0a7f6ec46915f966bd7114ffd49cf5aea6188', last_update = '2025-01-15 16:19:55.687634',exp_date = '2025-01-15 17:04:55.687638', logged_in = 'TRUE' where id = 1031
Date: 2025-01-15 17:20:02
Statement: update res_users set sid = '0ff61103934c706f8a00df0ae45720f159a47e16', last_update = '2025-01-15 16:16:15.458231',exp_date = '2025-01-15 17:01:15.458236', logged_in = 'TRUE' where id = 1037
Date: 2025-01-15 17:20:02
7 101 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #7
Day Hour Count Jan 15 10 10 11 25 12 11 13 27 14 2 15 18 18 7 22 1 8 45 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #8
Day Hour Count Jan 15 00 39 03 2 04 1 09 2 14 1 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 172589 waits for ShareLock on transaction 6103069; blocked by process 877859. Process 877859 waits for ShareLock on transaction 6103056; blocked by process 172589. Process 172589: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 22:59:26.130883', "write_uid" = 975 WHERE id IN (42120719) Process 877859: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:00:18.412415', "write_uid" = 1223 WHERE id IN (42120171)
Context: while updating tuple (81546,125) in relation "policy_number"
Hint: See server log for query details.
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 22:59:26.130883', "write_uid" = 975 WHERE id IN (42120719)Date: 2025-01-15 00:02:01
Detail: Process 172589 waits for ShareLock on transaction 6103139; blocked by process 172592. Process 172592 waits for ShareLock on transaction 6103098; blocked by process 172589. Process 172589: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:02:02.840390', "write_uid" = 975 WHERE id IN (42120759) Process 172592: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:03:41.252217', "write_uid" = 1223 WHERE id IN (42120719)
Context: while updating tuple (85250,36) in relation "policy_number"
Hint: See server log for query details.
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:02:02.840390', "write_uid" = 975 WHERE id IN (42120759)Date: 2025-01-15 00:05:25
Detail: Process 172592 waits for ShareLock on transaction 6103157; blocked by process 496811. Process 496811 waits for ShareLock on transaction 6103139; blocked by process 172592. Process 172592: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:03:41.252217', "write_uid" = 1223 WHERE id IN (42018627) Process 496811: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:04:26.249692', "write_uid" = 975 WHERE id IN (42018630)
Context: while updating tuple (144776,88) in relation "policy_number"
Hint: See server log for query details.
Statement: UPDATE "policy_number" SET "done" = true, "write_date" = '2025-01-14 23:03:41.252217', "write_uid" = 1223 WHERE id IN (42018627)Date: 2025-01-15 00:06:11
9 21 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #9
Day Hour Count Jan 15 10 3 12 1 15 7 16 9 21 1 10 16 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Jan 15 17 16 11 12 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #11
Day Hour Count Jan 15 17 12 - FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4500755)) AND (("shipping_track"."id" not in (37148406, 37148406)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-01-15 17:20:02
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2025-01-15 17:20:02
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4500285)) AND (("shipping_track"."id" not in (37145649, 37148405, 37148405)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"
Date: 2025-01-15 17:20:02
12 9 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #12
Day Hour Count Jan 15 01 3 04 3 16 3 - FATAL: password authentication failed for user "postgres"
Detail: User "postgres" has no password assigned. Connection matched file "/var/lib/pgsql/16/data/pg_hba.conf" line 123: "host all all all scram-sha-256"
Date: 2025-01-15 01:34:18
13 8 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #13
Day Hour Count Jan 15 10 1 11 1 13 4 14 1 15 1 - ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
Detail: Failing row contains (5478470, null, 825, 825, null, فيميكا, null, null, t, 2025-01-15 09:09:24.45145, 2025-01-15 09:09:24.45145, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-01-15 09:09:24.451450', 825, 'فيميكا', '2025-01-15 09:09:24.451450', 825) RETURNING "id"Date: 2025-01-15 10:09:24
Detail: Failing row contains (5478503, null, 825, 825, null, شركة قاسم, null, null, t, 2025-01-15 10:28:13.862936, 2025-01-15 10:28:13.862936, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-01-15 10:28:13.862936', 825, 'شركة قاسم', '2025-01-15 10:28:13.862936', 825) RETURNING "id"Date: 2025-01-15 11:28:13
Detail: Failing row contains (5478511, null, 827, 827, null, مروران, null, null, t, 2025-01-15 12:00:34.197245, 2025-01-15 12:00:34.197245, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2025-01-15 12:00:34.197245', 827, 'مروران', '2025-01-15 12:00:34.197245', 827) RETURNING "id"Date: 2025-01-15 13:00:34
14 6 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Jan 15 02 1 11 1 14 2 16 2 - ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 159
- ERROR: syntax error at or near ")" at character 300
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 ('9906479',)
Date: 2025-01-15 02:56:39
Statement: select po.id,policy.name from cash_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('9494200',)
Date: 2025-01-15 11:22:02
Statement: select sum(total_shipping_price-collection_amount_receive-collection_amount_sender) FROM shipping_policy where collection_amount_sender+collection_amount_receive<total_shipping_price and id in (shipping.policy(4461501,), 0)
Date: 2025-01-15 14:07:59
15 5 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #15
Day Hour Count Jan 15 03 1 05 2 19 1 20 1 16 5 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #16
Day Hour Count Jan 15 03 1 05 2 19 1 20 1 17 5 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #17
Day Hour Count Jan 15 03 1 05 2 19 1 20 1 18 3 ERROR: bigint out of range
Times Reported Most Frequent Error / Event #18
Day Hour Count Jan 15 21 3 - ERROR: bigint out of range
- ERROR: bigint out of range
- ERROR: bigint out of range
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%خلق%'))) AND (("cash_policy"."create_date_policy" >= '2024-09-01') AND ("cash_policy"."create_date_policy" <= '2025-01-15'))))) AND (((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."id" DESC LIMIT 555555555555555540000
Date: 2025-01-15 21:21:00
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."create_uid" = 963) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%خلق%'))) AND (("cash_policy"."create_date_policy" >= '2024-09-01') AND ("cash_policy"."create_date_policy" <= '2025-01-15')))))) AND (((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."total_paid_by_receiver" ASC LIMIT 555555555555555540000
Date: 2025-01-15 21:22:05
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."create_uid" = 833) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%خلق%'))) AND (("cash_policy"."create_date_policy" >= '2024-09-01') AND ("cash_policy"."create_date_policy" <= '2025-01-15')))))) AND (((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 128, 112))))) OR ("cash_policy__policy_id"."notebook_id" in (SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) AND (("cash_policy"."state" not in ('draft', 'confirm_payment')) OR "cash_policy"."state" IS NULL)) ORDER BY "cash_policy"."total_paid_by_receiver" ASC LIMIT 555555555555555540000
Date: 2025-01-15 21:22:24
19 3 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #19
Day Hour Count Jan 15 17 3 20 2 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #20
Day Hour Count Jan 15 17 2 - ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4500755)) AND (("shipping_track"."id" not in (37148406, 37148406)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-01-15 17:20:02
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4500285)) AND (("shipping_track"."id" not in (37145649, 37148405, 37148405)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id"Date: 2025-01-15 17:20:02
21 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #21
Day Hour Count Jan 15 20 1 22 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #22
Day Hour Count Jan 15 17 1