pgBadger-
Global information
- Generated on Sun Dec 29 23:47:43 2024
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 47,439,615 log entries in 2m42s
- Log start from 2024-12-29 00:00:00 to 2024-12-29 22:45:01
-
Overview
Global Stats
- 25,258 Number of unique normalized queries
- 20,389,284 Number of queries
- 6d10h13m37s Total query duration
- 2024-12-29 00:00:00 First query
- 2024-12-29 22:45:01 Last query
- 7,472 queries/s at 2024-12-29 11:44:37 Query peak
- 6d10h13m37s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 6d10h13m37s Execute total duration
- 12,618 Number of events
- 25 Number of unique normalized events
- 4,756 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
- 20,389,284 Average queries per session
- 6d10h13m37s 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,472 queries/s Query Peak
- 2024-12-29 11:44:37 Date
SELECT Traffic
Key values
- 7,302 queries/s Query Peak
- 2024-12-29 11:44:37 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,180 queries/s Query Peak
- 2024-12-29 14:13:13 Date
Queries duration
Key values
- 6d10h13m37s 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) Dec 29 00 352,440 0ms 3s120ms 18ms 3m11s 4m8s 4m42s 01 243,704 0ms 1s6ms 17ms 2m3s 2m22s 2m45s 02 248,710 0ms 1s15ms 20ms 2m48s 2m59s 3m26s 03 250,912 0ms 1s867ms 25ms 3m13s 3m57s 4m59s 04 218,279 0ms 593ms 21ms 2m41s 2m46s 3m11s 05 186,258 0ms 41s899ms 23ms 2m22s 3m1s 3m21s 06 201,816 0ms 59s573ms 18ms 2m5s 2m24s 2m33s 07 180,672 0ms 4s361ms 13ms 1m34s 2m30s 2m49s 08 447,147 0ms 14m31s 18ms 2m17s 2m28s 1h10m28s 09 1,080,119 0ms 35m27s 63ms 4m6s 7m6s 11h47m27s 10 1,543,949 0ms 26m16s 19ms 6m34s 38m3s 1h44m49s 11 1,860,935 0ms 14m50s 31ms 1h5m25s 1h54m34s 3h48m32s 12 1,850,392 0ms 14m54s 29ms 50m9s 1h4m56s 2h27m16s 13 1,736,120 0ms 14m1s 11ms 5m46s 7m33s 1h27m3s 14 1,600,170 0ms 16m28s 26ms 6m35s 1h27m20s 3h26m2s 15 1,607,601 0ms 17m44s 30ms 38m20s 1h1m32s 3h4m50s 16 1,428,664 0ms 10m1s 25ms 42m55s 1h12m21s 2h55s 17 1,231,568 0ms 21m29s 34ms 8m25s 9m9s 4h47m51s 18 979,298 0ms 59m59s 22ms 8m4s 9m34s 1h3m54s 19 976,201 0ms 57m56s 45ms 10m30s 12m55s 7h17m15s 20 720,311 0ms 16m18s 40ms 7m38s 8m42s 3h37m50s 21 1,186,843 0ms 25m5s 6ms 2m39s 3m44s 37m41s 22 257,175 0ms 4s377ms 14ms 2m46s 2m52s 3m53s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 29 00 195,277 0 33ms 2m48s 3m11s 4m18s 01 125,484 0 33ms 1m47s 2m3s 2m25s 02 125,063 0 40ms 2m9s 2m48s 3m16s 03 128,145 0 48ms 2m30s 3m13s 3m57s 04 107,598 0 43ms 2m7s 2m41s 2m56s 05 93,268 0 45ms 1m44s 2m22s 3m 06 105,349 0 34ms 1m37s 2m4s 2m33s 07 100,856 0 24ms 1m5s 1m33s 2m37s 08 266,398 0 16ms 1m58s 2m7s 2m28s 09 633,720 0 15ms 3m15s 3m53s 5m56s 10 924,784 0 15ms 5m9s 5m45s 6m27s 11 1,143,150 0 12ms 5m 5m40s 7m51s 12 1,160,061 0 12ms 5m56s 7m53s 9m57s 13 1,033,976 0 12ms 4m11s 4m53s 6m7s 14 948,851 0 13ms 4m28s 5m28s 6m15s 15 976,061 0 17ms 6m4s 7m24s 9m10s 16 860,426 0 13ms 4m17s 4m54s 5m46s 17 741,219 0 23ms 6m59s 7m54s 8m24s 18 552,051 0 33ms 6m37s 7m37s 9m33s 19 571,821 0 31ms 6m33s 8m20s 12m53s 20 425,424 0 37ms 5m54s 7m8s 8m1s 21 763,696 0 8ms 2m20s 2m38s 4m8s 22 145,507 0 25ms 2m2s 2m45s 3m53s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 29 00 30,559 6,076 139 0 0ms 157ms 249ms 412ms 01 19,506 4,589 150 0 0ms 107ms 145ms 282ms 02 18,868 6,087 139 0 0ms 124ms 154ms 228ms 03 24,573 6,307 132 0 0ms 144ms 188ms 243ms 04 16,749 4,678 129 0 0ms 108ms 138ms 194ms 05 17,339 5,035 130 0 2ms 119ms 163ms 269ms 06 16,389 5,247 134 0 3ms 92ms 145ms 176ms 07 9,669 3,148 135 0 0ms 66ms 108ms 156ms 08 19,384 6,055 318 0 159ms 126ms 168ms 215ms 09 51,347 15,238 819 0 877ms 286ms 381ms 628ms 10 75,122 21,611 816 0 161ms 477ms 572ms 35m51s 11 74,830 21,967 727 0 450ms 484ms 590ms 1h52m22s 12 70,895 24,046 811 4 417ms 623ms 25m31s 1h2m39s 13 70,710 23,570 927 0 77ms 397ms 485ms 974ms 14 63,569 22,052 650 0 334ms 360ms 435ms 1h25m55s 15 80,182 27,738 976 0 295ms 549ms 840ms 57m 16 51,855 20,717 604 0 338ms 328ms 414ms 1h9m56s 17 66,486 23,414 601 1 277ms 561ms 727ms 2m8s 18 69,035 22,618 885 0 40ms 486ms 560ms 18s241ms 19 87,609 23,575 881 0 237ms 570ms 733ms 1m25s 20 65,091 14,554 479 0 164ms 397ms 482ms 1m47s 21 26,109 6,029 223 0 21ms 146ms 190ms 347ms 22 18,451 4,332 176 0 0ms 147ms 187ms 240ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 29 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 Dec 29 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 Dec 29 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
- 299,802 buffers Checkpoint Peak
- 2024-12-29 12:26:23 Date
- 270.055 seconds Highest write time
- 0.019 seconds Sync time
Checkpoints Wal files
Key values
- 131 files Wal files usage Peak
- 2024-12-29 12:26:23 Date
Checkpoints distance
Key values
- 4,197.83 Mo Distance Peak
- 2024-12-29 12:26:23 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 29 00 157,746 3,239.599s 0.038s 3,239.686s 01 153,973 3,239.547s 0.033s 3,239.628s 02 127,421 3,210.498s 0.037s 3,210.581s 03 134,552 3,239.628s 0.028s 3,239.704s 04 141,442 3,239.542s 0.026s 3,239.618s 05 115,252 3,181.618s 0.032s 3,181.692s 06 82,991 3,076.523s 0.029s 3,076.592s 07 76,835 3,117.476s 0.029s 3,117.536s 08 141,305 3,239.52s 0.032s 3,239.598s 09 368,678 3,239.556s 0.049s 3,239.681s 10 533,867 3,239.392s 0.069s 3,239.566s 11 626,365 3,239.483s 0.057s 3,239.638s 12 783,779 3,239.515s 0.065s 3,239.719s 13 560,043 3,239.418s 0.059s 3,239.592s 14 509,825 3,239.558s 0.05s 3,239.683s 15 552,775 3,239.438s 0.053s 3,239.576s 16 340,818 3,239.593s 0.044s 3,239.699s 17 383,933 2,889.159s 0.066s 2,889.298s 18 357,736 3,239.466s 0.061s 3,239.606s 19 444,882 3,239.404s 0.077s 3,239.587s 20 344,796 3,239.546s 0.046s 3,239.66s 21 149,355 3,239.621s 0.039s 3,239.705s 22 105,001 2,337.532s 0.026s 2,337.59s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 29 00 0 0 71 3,513 0.003s 0.012s 01 0 0 70 3,148 0.002s 0.012s 02 0 0 60 2,549 0.013s 0.012s 03 0 0 65 2,574 0.002s 0.012s 04 0 0 66 2,357 0.002s 0.012s 05 0 0 51 2,379 0.002s 0.012s 06 0 0 39 2,535 0.004s 0.012s 07 0 0 34 2,471 0.002s 0.012s 08 0 0 61 3,610 0.002s 0.012s 09 0 0 165 4,797 0.003s 0.012s 10 0 0 243 5,226 0.003s 0.012s 11 0 0 269 5,272 0.003s 0.012s 12 0 15 305 5,139 0.005s 0.012s 13 0 16 184 5,397 0.003s 0.012s 14 0 0 189 5,356 0.003s 0.012s 15 0 0 211 5,662 0.003s 0.012s 16 0 0 129 5,506 0.004s 0.012s 17 0 0 147 5,446 0.011s 0.012s 18 0 0 149 5,324 0.016s 0.012s 19 0 7 251 5,361 0.017s 0.012s 20 0 2 140 5,076 0.003s 0.012s 21 0 0 61 4,325 0.002s 0.012s 22 0 0 41 3,288 0.002s 0.009s Day Hour Count Avg time (sec) Dec 29 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 Dec 29 00 96,821.42 kB 147,331.00 kB 01 94,856.83 kB 180,030.33 kB 02 82,254.50 kB 120,886.08 kB 03 88,834.58 kB 115,240.00 kB 04 89,639.58 kB 125,583.00 kB 05 70,682.92 kB 101,589.08 kB 06 52,228.75 kB 89,534.75 kB 07 46,364.25 kB 98,697.42 kB 08 84,299.92 kB 111,298.33 kB 09 224,577.08 kB 257,046.67 kB 10 335,856.64 kB 375,799.00 kB 11 367,314.75 kB 610,855.92 kB 12 436,886.50 kB 1,152,462.33 kB 13 264,699.73 kB 829,839.55 kB 14 257,544.00 kB 418,705.17 kB 15 288,015.17 kB 335,268.17 kB 16 175,592.17 kB 264,674.92 kB 17 195,506.91 kB 225,239.27 kB 18 203,118.42 kB 251,036.17 kB 19 351,814.25 kB 924,521.50 kB 20 193,042.50 kB 745,022.40 kB 21 83,207.92 kB 295,368.17 kB 22 74,787.56 kB 143,911.44 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 Dec 29 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 Dec 29 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
- 12,128,185 Total read queries
- 5,598,187 Total write queries
Queries by database
Key values
- unknown Main database
- 20,389,284 Requests
- 6d10h13m37s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 20,389,284 Requests
User Request type Count Duration unknown Total 20,389,284 6d10h13m37s copy from 5 6ms cte 32,494 7s20ms ddl 3,569 483ms delete 10,981 1s420ms insert 1,044,327 5m19s others 2,662,912 2m select 12,128,185 2d15h43m50s tcl 4,188,128 2m53s update 318,683 3d18h19m24s Duration by user
Key values
- 6d10h13m37s (unknown) Main time consuming user
User Request type Count Duration unknown Total 20,389,284 6d10h13m37s copy from 5 6ms cte 32,494 7s20ms ddl 3,569 483ms delete 10,981 1s420ms insert 1,044,327 5m19s others 2,662,912 2m select 12,128,185 2d15h43m50s tcl 4,188,128 2m53s update 318,683 3d18h19m24s Queries by host
Key values
- unknown Main host
- 20,389,284 Requests
- 6d10h13m37s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 20,389,284 Requests
- 6d10h13m37s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-12-29 01:40:25 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 19,141,319 0-1ms duration
Slowest individual queries
Rank Duration Query 1 59m59s update res_users set sid = '5ce22afcaa0c27cbbeccb0dade5f84c8c3e06b44', last_update = '2024-12-29 16:56:12.643956', exp_date = '2024-12-29 17:41:12.643958', logged_in = 'TRUE' where id = 1025;[ Date: 2024-12-29 18:56:12 ]
2 57m56s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036298', exp_date = '2024-12-29 18:41:24.036301', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
3 57m56s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036177', exp_date = '2024-12-29 18:41:24.036181', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
4 51m6s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 18:03:13.962204', exp_date = '2024-12-29 18:48:13.962208', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
5 43m28s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 18:10:51.600357', exp_date = '2024-12-29 18:55:51.600361', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
6 43m24s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 18:10:56.107926', exp_date = '2024-12-29 18:55:56.107929', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
7 40m30s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 18:13:49.812016', exp_date = '2024-12-29 18:58:49.812019', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
8 40m10s update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 18:14:09.585566', exp_date = '2024-12-29 18:59:09.585571', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-29 19:54:20 ]
9 35m27s update res_users set sid = '71483f860765d85c421ca9a5f5061dd6e323af02', last_update = '2024-12-29 08:22:47.626915', exp_date = '2024-12-29 09:07:47.626918', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
10 35m27s update res_users set sid = '71483f860765d85c421ca9a5f5061dd6e323af02', last_update = '2024-12-29 08:22:47.626740', exp_date = '2024-12-29 09:07:47.626743', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
11 35m19s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:22:55.514131', exp_date = '2024-12-29 09:07:55.514135', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
12 35m16s update res_users set sid = '71483f860765d85c421ca9a5f5061dd6e323af02', last_update = '2024-12-29 08:22:59.322326', exp_date = '2024-12-29 09:07:59.322328', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
13 35m15s update res_users set sid = '71483f860765d85c421ca9a5f5061dd6e323af02', last_update = '2024-12-29 08:22:59.502946', exp_date = '2024-12-29 09:07:59.502949', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
14 35m15s update res_users set sid = '71483f860765d85c421ca9a5f5061dd6e323af02', last_update = '2024-12-29 08:22:59.620442', exp_date = '2024-12-29 09:07:59.620447', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
15 35m12s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:23:02.553026', exp_date = '2024-12-29 09:08:02.553029', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
16 35m12s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:23:02.550942', exp_date = '2024-12-29 09:08:02.550946', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
17 35m12s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:23:02.566219', exp_date = '2024-12-29 09:08:02.566222', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
18 35m12s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:23:03.330608', exp_date = '2024-12-29 09:08:03.330611', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
19 34m52s update res_users set sid = '43c7823c68ad9713f449be43261d7fa16aaf81d4', last_update = '2024-12-29 08:23:22.807096', exp_date = '2024-12-29 09:08:22.807100', logged_in = 'TRUE' where id = 988;[ Date: 2024-12-29 09:58:15 ]
20 26m16s update res_users set sid = 'e290b25289a7600ce7b2a081d0856ab394bb629c', last_update = '2024-12-29 08:59:04.774298', exp_date = '2024-12-29 09:44:04.774303', logged_in = 'TRUE' where id = 908;[ Date: 2024-12-29 10:25:20 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3d15h15m33s 82,433 0ms 59m59s 3s810ms update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 29 00 1,017 228ms 0ms 01 852 189ms 0ms 02 1,211 271ms 0ms 03 996 218ms 0ms 04 1,002 218ms 0ms 05 977 214ms 0ms 06 1,003 217ms 0ms 07 644 142ms 0ms 08 1,659 1h3m12s 2s286ms 09 4,689 16h8m32s 12s393ms 10 7,018 4h2m1s 2s69ms 11 8,476 11h55m38s 5s65ms 12 8,562 10h39m53s 4s484ms 13 8,054 2h51s 900ms 14 7,292 7h49m58s 3s867ms 15 7,081 8h53m25s 4s519ms 16 6,115 6h45m30s 3s978ms 17 4,898 6h41m27s 4s917ms 18 3,908 1h1m4s 937ms 19 2,711 6h45m8s 8s966ms 20 2,191 3h28m47s 5s717ms 21 1,301 352ms 0ms 22 776 188ms 0ms -
update res_users set sid = '5ce22afcaa0c27cbbeccb0dade5f84c8c3e06b44', last_update = '2024-12-29 16:56:12.643956', exp_date = '2024-12-29 17:41:12.643958', logged_in = 'TRUE' where id = 1025;
Date: 2024-12-29 18:56:12 Duration: 59m59s
-
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036298', exp_date = '2024-12-29 18:41:24.036301', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-29 19:54:20 Duration: 57m56s
-
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036177', exp_date = '2024-12-29 18:41:24.036181', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-29 19:54:20 Duration: 57m56s
2 1d9h8m19s 253,082 403ms 3s78ms 471ms select "shipping_track".id from "shipping_track" where (("shipping_track"."shipping_id" in (...)) and (("shipping_track"."id" not in (...)) or "shipping_track"."id" is null)) order by "shipping_track"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 29 00 9,100 1h8m11s 449ms 01 6,443 47m2s 438ms 02 7,795 56m50s 437ms 03 10,173 1h15m6s 442ms 04 7,645 55m45s 437ms 05 6,192 45m39s 442ms 06 4,456 32m31s 438ms 07 3,315 24m35s 445ms 08 5,668 41m32s 439ms 09 11,813 1h27m44s 445ms 10 17,383 2h16m43s 471ms 11 17,718 2h19m25s 472ms 12 15,681 2h8m26s 491ms 13 14,078 1h49m23s 466ms 14 12,352 1h35m23s 463ms 15 14,885 2h1m6s 488ms 16 10,624 1h22m13s 464ms 17 15,769 2h10m29s 496ms 18 18,139 2h30m56s 499ms 19 15,341 2h8m34s 502ms 20 19,337 2h38m22s 491ms 21 5,438 42m51s 472ms 22 3,737 29m23s 471ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4011114)) AND (("shipping_track"."id" not in (32803468, 32803585, 32803922, 32912518, 32912641, 32981921, 32981921)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 3s78ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3102795)) AND (("shipping_track"."id" not in (25270502, 25271463, 32519838, 32519839, 32522286, 32522855, 32523043, 32981671, 32981671)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:03 Duration: 2s725ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4024192)) AND (("shipping_track"."id" not in (32854639, 32855073, 32855309, 32915843, 32916003, 32916098, 32981553, 32981924, 32981924)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 1s570ms
3 6h28m17s 48,378 406ms 3s726ms 481ms 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 Dec 29 00 277 2m11s 475ms 01 305 2m22s 466ms 02 225 1m50s 490ms 03 191 1m35s 498ms 04 145 1m13s 508ms 05 128 1m4s 503ms 06 172 1m20s 468ms 07 233 1m45s 451ms 08 1,239 9m1s 436ms 09 3,253 24m45s 456ms 10 4,198 33m59s 485ms 11 4,076 33m16s 489ms 12 4,297 36m24s 508ms 13 4,358 34m26s 474ms 14 4,244 33m15s 470ms 15 4,252 35m9s 496ms 16 3,258 25m21s 466ms 17 3,235 26m49s 497ms 18 3,066 25m2s 489ms 19 3,267 26m12s 481ms 20 2,637 21m2s 478ms 21 832 6m26s 464ms 22 490 3m42s 453ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4035558, 4034307, 4034305, 4034301, 4034291, 4034286, 4034271, 4030944, 4030869, 4027269, 4024103, 4023660, 4023149, 4022789, 4021652, 4021224, 4019630, 4018799, 4017033, 4016911, 4016602, 4016205, 4016096, 4015606, 4014894, 4014449, 4013190, 4012231, 4010382, 4004750, 3995786, 3978031, 3976098, 3721386, 3718466)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:01 Duration: 3s726ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4000256)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:49 Duration: 3s330ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3984633)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:02 Duration: 3s292ms
4 6h53s 109,150 150ms 685ms 198ms 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 Dec 29 00 1,094 3m 165ms 01 1,305 3m34s 164ms 02 2,720 7m30s 165ms 03 2,304 6m19s 164ms 04 1,910 5m16s 165ms 05 1,779 4m51s 163ms 06 3,219 8m53s 165ms 07 1,111 3m4s 166ms 08 1,661 4m35s 166ms 09 4,714 13m28s 171ms 10 5,697 17m7s 180ms 11 5,017 15m13s 182ms 12 7,749 25m8s 194ms 13 3,401 10m9s 179ms 14 6,906 20m22s 177ms 15 9,911 30m41s 185ms 16 8,284 24m19s 176ms 17 14,749 56m8s 228ms 18 12,028 46m10s 230ms 19 10,647 44m12s 249ms 20 2,067 7m40s 222ms 21 769 2m39s 207ms 22 108 22s336ms 206ms -
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" = '9492787')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 685ms
-
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" = '9492787')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 628ms
-
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" = '9412159')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:29:46 Duration: 525ms
5 3h32m53s 54,533 91ms 857ms 234ms 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 Dec 29 00 3,810 12m44s 200ms 01 1,488 4m46s 192ms 02 1,052 3m16s 186ms 03 1,986 7m3s 213ms 04 1,048 4m41s 268ms 05 2,064 7m53s 229ms 06 1,192 4m17s 216ms 07 1,130 4m12s 223ms 08 1,202 4m8s 206ms 09 172 46s323ms 269ms 10 526 2m12s 251ms 11 284 59s936ms 211ms 12 92 21s977ms 238ms 13 1,132 4m5s 217ms 14 1,028 4m6s 240ms 15 1,824 7m12s 237ms 16 2,413 9m33s 237ms 17 5,123 20m25s 239ms 18 6,038 25m37s 254ms 19 8,505 35m17s 249ms 20 7,179 28m11s 235ms 21 2,642 10m4s 228ms 22 2,603 10m52s 250ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 19:48:30 Duration: 857ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياسمين')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 19:48:30 Duration: 854ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 17:07:35 Duration: 844ms
6 2h27m7s 359 0ms 14m56s 24s588ms update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 29 00 4 2ms 0ms 01 4 0ms 0ms 02 4 2ms 0ms 03 2 1ms 0ms 04 1 2ms 2ms 06 4 0ms 0ms 07 1 0ms 0ms 08 14 5m10s 22s187ms 09 45 16m40s 22s224ms 10 28 19m17s 41s355ms 11 32 4m46s 8s967ms 12 45 21m17s 28s398ms 13 26 1m21s 3s132ms 14 32 6m56s 13s29ms 15 27 1m33s 3s456ms 16 23 6m19s 16s499ms 17 19 16m8s 50s993ms 18 14 17ms 1ms 19 18 36m11s 2m 20 5 6ms 1ms 21 8 11m21s 1m25s 22 3 0ms 0ms -
UPDATE "res_users" SET "exp_date" = '2024-12-29 19:24:23.881268', "last_update" = '2024-12-29 18:39:23.881289', "sid" = '619ecee0d4a8029fd8a0ca208718468ae48c3fa4', "write_date" = '2024-12-29 18:39:23.525215', "write_uid" = 1 WHERE id IN (1037);
Date: 2024-12-29 19:54:20 Duration: 14m56s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 19:28:40.377533', "last_update" = '2024-12-29 18:43:40.377557', "sid" = '619ecee0d4a8029fd8a0ca208718468ae48c3fa4', "write_date" = '2024-12-29 18:43:40.054276', "write_uid" = 1 WHERE id IN (1037);
Date: 2024-12-29 19:54:20 Duration: 10m40s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 16:52:29.158954', "last_update" = '2024-12-29 16:07:29.158987', "sid" = 'ebb6e4873d6b86554446efbdd9e27bdc79f1dae5', "write_date" = '2024-12-29 16:07:28.814767', "write_uid" = 1 WHERE id IN (928);
Date: 2024-12-29 17:17:20 Duration: 9m51s
7 1h59m42s 7,719 213ms 1s566ms 930ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 29 00 458 6m26s 844ms 01 159 1m37s 611ms 02 199 3m5s 932ms 03 356 1m51s 313ms 10 25 23s989ms 959ms 11 12 12s470ms 1s39ms 13 76 1m15s 988ms 14 261 4m25s 1s15ms 15 407 7m 1s32ms 16 483 7m28s 928ms 17 598 9m7s 915ms 18 1,226 19m49s 970ms 19 1,606 27m3s 1s11ms 20 978 15m45s 966ms 21 424 6m57s 985ms 22 451 7m11s 956ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9588413')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:30 Duration: 1s566ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9375488')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:30 Duration: 1s524ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9689979')) 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 (67))))))) 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 (67)))))) 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 (67)))))) 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 (67))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:03 Duration: 1s500ms
8 1h46m40s 25,432 157ms 1s307ms 251ms select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 29 08 87 18s727ms 215ms 09 1,250 4m53s 234ms 10 1,479 6m3s 245ms 11 1,469 6m2s 246ms 12 2,076 9m29s 274ms 13 1,188 4m54s 247ms 14 2,439 9m41s 238ms 15 6,826 27m46s 244ms 16 4,271 16m35s 232ms 17 2,538 12m11s 288ms 18 836 4m16s 306ms 19 332 1m27s 264ms 20 627 2m56s 281ms 21 14 4s344ms 310ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9490592')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:29:01 Duration: 1s307ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '455365')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:28:55 Duration: 838ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9527615')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:28:55 Duration: 733ms
9 1h41m10s 19,893 190ms 587ms 305ms select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 29 00 1,477 6m38s 270ms 01 593 2m38s 266ms 02 330 1m28s 269ms 03 647 2m54s 268ms 04 535 2m23s 268ms 05 1,045 4m39s 267ms 06 612 2m41s 264ms 07 571 2m28s 259ms 08 606 2m42s 267ms 09 88 27s950ms 317ms 10 247 1m12s 292ms 11 139 39s856ms 286ms 12 47 13s860ms 294ms 13 506 2m25s 288ms 14 265 1m17s 292ms 15 512 2m33s 300ms 16 741 3m32s 286ms 17 1,984 10m24s 314ms 18 1,822 10m29s 345ms 19 2,700 15m17s 339ms 20 2,638 14m43s 335ms 21 915 4m51s 318ms 22 873 4m24s 303ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9598557')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 18:20:28 Duration: 587ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9641512')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:29 Duration: 481ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9598556')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 18:20:30 Duration: 473ms
10 1h39m54s 149,846 29ms 219ms 40ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 29 00 3,814 2m22s 37ms 01 3,096 1m55s 37ms 02 2,512 1m33s 37ms 03 3,226 2m1s 37ms 04 2,052 1m16s 37ms 05 1,653 1m1s 37ms 06 2,060 1m16s 37ms 07 895 33s744ms 37ms 08 2,146 1m20s 37ms 09 8,302 5m18s 38ms 10 12,295 8m16s 40ms 11 13,041 8m48s 40ms 12 12,993 9m9s 42ms 13 11,053 7m18s 39ms 14 10,349 6m48s 39ms 15 11,551 7m55s 41ms 16 8,551 5m35s 39ms 17 8,264 5m41s 41ms 18 8,206 5m40s 41ms 19 9,578 6m32s 41ms 20 8,272 5m35s 40ms 21 3,595 2m21s 39ms 22 2,342 1m30s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4035558)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 219ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3909283)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:57 Duration: 191ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3523517)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:29:24 Duration: 175ms
11 39m32s 23,616 81ms 657ms 100ms select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 29 00 62 5s532ms 89ms 08 242 23s132ms 95ms 09 2,189 3m27s 94ms 10 2,196 3m41s 101ms 11 2,212 3m40s 99ms 12 2,485 4m17s 103ms 13 2,763 4m35s 99ms 14 2,678 4m21s 97ms 15 3,410 5m57s 104ms 16 1,024 1m41s 98ms 17 840 1m26s 102ms 18 1,028 1m45s 102ms 19 1,439 2m28s 103ms 20 547 55s537ms 101ms 21 227 21s107ms 92ms 22 274 25s145ms 91ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7893583)) AND (("cash_track"."id" not in (6281432, 6288845, 6304891, 6331587, 6331587)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 12:28:55 Duration: 657ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7897634)) AND (("cash_track"."id" not in (6307755, 6313278, 6314226, 6331583, 6331583)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 12:28:53 Duration: 311ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7871924)) AND (("cash_track"."id" not in (6116535, 6148181, 6153923, 6348579, 6348579)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 15:33:42 Duration: 284ms
12 38m29s 13,039 151ms 326ms 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" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 29 01 271 45s42ms 166ms 02 85 14s174ms 166ms 03 213 34s954ms 164ms 04 114 18s992ms 166ms 05 128 20s774ms 162ms 06 2,515 6m57s 166ms 07 545 1m30s 166ms 08 1,066 2m57s 166ms 09 967 2m41s 167ms 10 1,114 3m22s 181ms 11 785 2m22s 182ms 12 876 2m45s 189ms 13 593 1m45s 178ms 14 1,246 3m43s 179ms 15 1,040 3m9s 182ms 16 574 1m40s 175ms 17 329 1m8s 207ms 18 28 7s36ms 251ms 19 71 19s667ms 277ms 20 178 39s885ms 224ms 21 193 40s427ms 209ms 22 108 22s349ms 206ms -
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" = '9183564')) 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: 2024-12-29 19:23:34 Duration: 326ms
-
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" = '9574265')) 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: 2024-12-29 19:23:28 Duration: 315ms
-
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" = '9662851')) 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: 2024-12-29 19:23:25 Duration: 313ms
13 36m51s 45,269 38ms 115ms 48ms select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 29 00 37 1s693ms 45ms 02 6 285ms 47ms 06 7 335ms 47ms 07 21 949ms 45ms 08 276 12s456ms 45ms 09 2,819 2m12s 46ms 10 3,049 2m26s 48ms 11 3,038 2m29s 49ms 12 5,139 4m21s 50ms 13 3,632 2m56s 48ms 14 5,320 4m16s 48ms 15 8,072 6m43s 49ms 16 4,786 3m47s 47ms 17 5,095 4m10s 49ms 18 1,560 1m16s 49ms 19 1,031 50s406ms 48ms 20 919 43s542ms 47ms 21 377 17s24ms 45ms 22 85 3s947ms 46ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3973266) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 17:22:09 Duration: 115ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4035646) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:51:58 Duration: 109ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3966072) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 15:33:04 Duration: 96ms
14 29m53s 10,866 151ms 214ms 165ms 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 Dec 29 00 1,068 2m56s 165ms 01 1,034 2m49s 164ms 02 2,376 6m33s 165ms 03 2,080 5m42s 164ms 04 1,782 4m54s 165ms 05 1,591 4m20s 163ms 06 704 1m57s 166ms 07 231 38s108ms 164ms -
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" = '9664747')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 00:45:59 Duration: 214ms
-
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" = '9543922')) 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: 2024-12-29 02:33:14 Duration: 195ms
-
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9582197')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 02:28:48 Duration: 191ms
15 25m5s 1 25m5s 25m5s 25m5s select count(*) from ( select from "shipping_policy" where ((("shipping_policy"."active" = true) and (("shipping_policy"."state" != ?) or "shipping_policy"."state" is null)) and (("shipping_policy"."delegate_id" in ( select "res_partner".id from "res_partner" where (((((("res_partner"."display_name"::text not ilike ?) or "res_partner"."display_name" is null) and (("res_partner"."email"::text not ilike ?) or "res_partner"."email" is null)) and (("res_partner"."ref"::text not ilike ?) or "res_partner"."ref" is null)) and (("res_partner"."vat"::text not ilike ?) or "res_partner"."vat" is null)) and (("res_partner"."company_registry"::text not ilike ?) or "res_partner"."company_registry" is null)) 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)))) or "shipping_policy"."delegate_id" is null)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) limit ?) t;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 29 21 1 25m5s 25m5s -
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE (((((("res_partner"."display_name"::text not ilike '%حسن علي حسن%') OR "res_partner"."display_name" IS NULL) AND (("res_partner"."email"::text not ilike '%حسن علي حسن%') OR "res_partner"."email" IS NULL)) AND (("res_partner"."ref"::text not ilike '%حسن علي حسن%') OR "res_partner"."ref" IS NULL)) AND (("res_partner"."vat"::text not ilike '%حسن علي حسن%') OR "res_partner"."vat" IS NULL)) AND (("res_partner"."company_registry"::text not ilike '%حسن علي حسن%') OR "res_partner"."company_registry" IS NULL)) 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)))) OR "shipping_policy"."delegate_id" IS NULL)) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) LIMIT 10001) t;
Date: 2024-12-29 21:22:03 Duration: 25m5s
16 19m44s 31 0ms 6m52s 38s201ms update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 29 00 1 1ms 1ms 05 2 0ms 0ms 08 1 0ms 0ms 10 1 0ms 0ms 11 11 11m52s 1m4s 12 3 4m5s 1m21s 13 4 2ms 0ms 14 1 3m46s 3m46s 18 1 0ms 0ms 19 4 2ms 0ms 21 1 1ms 1ms 22 1 1ms 1ms -
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:15:27.650578', "last_update" = '2024-12-29 10:30:27.650604', "write_date" = '2024-12-29 10:30:27.246315', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 11:37:20 Duration: 6m52s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:28:21.176228', "last_update" = '2024-12-29 10:43:21.176253', "write_date" = '2024-12-29 10:43:20.838249', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 11:48:20 Duration: 4m59s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:51:16.161353', "last_update" = '2024-12-29 11:06:16.161382', "write_date" = '2024-12-29 11:06:15.830621', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 12:10:21 Duration: 4m5s
17 14m42s 6,047 118ms 1s277ms 145ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 29 00 24 3s102ms 129ms 08 60 7s955ms 132ms 09 388 52s585ms 135ms 10 827 2m 145ms 11 1,182 2m52s 145ms 12 944 2m27s 156ms 13 662 1m34s 143ms 14 505 1m11s 141ms 15 532 1m20s 150ms 16 260 36s875ms 141ms 17 146 21s684ms 148ms 18 246 35s70ms 142ms 19 141 20s686ms 146ms 20 95 13s745ms 144ms 21 24 3s266ms 136ms 22 11 1s464ms 133ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:26 Duration: 1s277ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:02 Duration: 853ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:23 Duration: 767ms
18 12m28s 17,053 34ms 96ms 43ms select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 29 08 89 3s339ms 37ms 09 1,030 41s730ms 40ms 10 1,246 54s18ms 43ms 11 1,224 53s185ms 43ms 12 1,997 1m35s 48ms 13 1,074 47s248ms 43ms 14 2,082 1m30s 43ms 15 2,882 2m8s 44ms 16 2,007 1m24s 42ms 17 2,365 1m44s 44ms 18 552 24s163ms 43ms 19 234 9s992ms 42ms 20 139 5s718ms 41ms 21 132 5s468ms 41ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3874290) ORDER BY "collection_policy"."id";
Date: 2024-12-29 15:19:23 Duration: 96ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3843456) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:30:09 Duration: 79ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3821132) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:30:10 Duration: 77ms
19 11m59s 258 13ms 4s292ms 2s788ms select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 29 00 5 15s348ms 3s69ms 09 10 31s889ms 3s188ms 10 4 13s814ms 3s453ms 11 17 16s338ms 961ms 12 11 12s352ms 1s122ms 13 19 1m4s 3s400ms 14 40 2m12s 3s320ms 15 19 37s676ms 1s982ms 16 19 1m3s 3s338ms 17 28 1m35s 3s400ms 18 18 48s395ms 2s688ms 19 30 1m41s 3s380ms 20 15 33s450ms 2s230ms 21 19 40s39ms 2s107ms 22 4 12s725ms 3s181ms -
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 (44))))))) 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 (44)))))) 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 (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) 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 (44))))))))) 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 (44)))))))) AND ("policy_number"."name"::text ilike '%9442814%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:41:51 Duration: 4s292ms
-
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 (24))))))) 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 (24)))))) 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 (24)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) 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 (24))))))))) 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 (24)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:23:06 Duration: 4s207ms
-
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 (24))))))) 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 (24)))))) 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 (24)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) 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 (24))))))))) 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 (24)))))))) AND ("policy_number"."name"::text ilike '%96%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:23:06 Duration: 3s989ms
20 11m2s 2,686 16ms 1s356ms 246ms 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 #20
Day Hour Count Duration Avg duration Dec 29 00 7 1s603ms 229ms 07 4 229ms 57ms 08 65 7s630ms 117ms 09 150 25s829ms 172ms 10 285 58s214ms 204ms 11 267 1m4s 241ms 12 328 1m22s 251ms 13 285 1m11s 250ms 14 341 1m32s 272ms 15 290 1m42s 354ms 16 199 47s636ms 239ms 17 125 35s539ms 284ms 18 95 31s4ms 326ms 19 161 17s51ms 105ms 20 51 15s970ms 313ms 21 23 5s956ms 258ms 22 10 1s334ms 133ms -
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:33:04 Duration: 1s356ms
-
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:55:14 Duration: 1s282ms
-
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:55:14 Duration: 1s273ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,660,885 2m 0ms 10ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 29 00 47,623 2s329ms 0ms 01 37,822 1s760ms 0ms 02 39,057 1s895ms 0ms 03 36,648 1s780ms 0ms 04 34,931 1s679ms 0ms 05 28,039 1s347ms 0ms 06 28,991 1s416ms 0ms 07 25,807 1s215ms 0ms 08 59,951 2s583ms 0ms 09 143,114 6s657ms 0ms 10 197,695 9s186ms 0ms 11 234,337 9s896ms 0ms 12 227,050 9s279ms 0ms 13 234,237 11s57ms 0ms 14 220,744 9s668ms 0ms 15 203,885 8s687ms 0ms 16 194,863 8s363ms 0ms 17 156,111 7s175ms 0ms 18 132,531 7s124ms 0ms 19 115,008 6s43ms 0ms 20 85,377 3s871ms 0ms 21 140,720 5s515ms 0ms 22 36,344 1s497ms 0ms -
DISCARD ALL;
Date: 2024-12-29 15:05:23 Duration: 10ms
-
DISCARD ALL;
Date: 2024-12-29 16:05:02 Duration: 1ms
-
DISCARD ALL;
Date: 2024-12-29 15:55:12 Duration: 1ms
2 2,094,918 29s583ms 0ms 17ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 29 00 36,298 587ms 0ms 01 28,062 449ms 0ms 02 29,730 485ms 0ms 03 27,546 453ms 0ms 04 27,093 425ms 0ms 05 21,211 345ms 0ms 06 22,848 369ms 0ms 07 20,505 321ms 0ms 08 47,105 652ms 0ms 09 117,144 1s577ms 0ms 10 160,444 2s258ms 0ms 11 190,889 2s509ms 0ms 12 180,951 2s409ms 0ms 13 185,031 2s579ms 0ms 14 170,670 2s288ms 0ms 15 157,216 2s164ms 0ms 16 148,279 2s9ms 0ms 17 120,434 1s775ms 0ms 18 100,812 1s669ms 0ms 19 87,984 1s435ms 0ms 20 64,027 963ms 0ms 21 124,631 1s468ms 0ms 22 26,008 381ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-29 18:50:17 Duration: 17ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-29 11:57:21 Duration: 1ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-29 12:42:42 Duration: 1ms
3 1,353,476 13s639ms 0ms 0ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 29 00 24,550 248ms 0ms 01 19,579 185ms 0ms 02 20,256 198ms 0ms 03 18,916 189ms 0ms 04 18,020 177ms 0ms 05 14,586 141ms 0ms 06 15,165 150ms 0ms 07 13,551 131ms 0ms 08 30,719 293ms 0ms 09 72,859 688ms 0ms 10 100,196 1s47ms 0ms 11 118,696 1s189ms 0ms 12 115,194 1s194ms 0ms 13 118,837 1s193ms 0ms 14 112,175 1s96ms 0ms 15 103,393 1s81ms 0ms 16 98,823 981ms 0ms 17 79,233 827ms 0ms 18 67,189 702ms 0ms 19 58,354 625ms 0ms 20 43,440 472ms 0ms 21 71,098 649ms 0ms 22 18,647 172ms 0ms -
ROLLBACK;
Date: 2024-12-29 16:02:31 Duration: 0ms
-
ROLLBACK;
Date: 2024-12-29 10:32:45 Duration: 0ms
-
ROLLBACK;
Date: 2024-12-29 13:03:28 Duration: 0ms
4 1,338,389 4m8s 0ms 16ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 29 00 23,855 4s504ms 0ms 01 18,922 3s347ms 0ms 02 19,620 3s636ms 0ms 03 18,290 3s534ms 0ms 04 17,422 3s150ms 0ms 05 13,971 2s522ms 0ms 06 14,511 2s556ms 0ms 07 12,912 2s99ms 0ms 08 30,226 5s505ms 0ms 09 72,333 12s987ms 0ms 10 99,945 19s184ms 0ms 11 117,945 21s509ms 0ms 12 114,044 21s216ms 0ms 13 118,228 21s408ms 0ms 14 110,959 19s629ms 0ms 15 102,184 19s749ms 0ms 16 97,741 17s935ms 0ms 17 78,762 15s405ms 0ms 18 66,788 13s584ms 0ms 19 57,909 11s731ms 0ms 20 43,072 8s995ms 0ms 21 70,509 11s164ms 0ms 22 18,241 3s154ms 0ms -
SELECT payload FROM http_sessions WHERE sid = 'e506e1599ddf9a71efcb034013469f8138ee96ea';
Date: 2024-12-29 14:09:51 Duration: 16ms
-
SELECT payload FROM http_sessions WHERE sid = '5d5cae7f50a1a383c166ec11d895ba2943b1119b';
Date: 2024-12-29 13:53:14 Duration: 16ms
-
SELECT payload FROM http_sessions WHERE sid = '16c2b8d8693f14fc658ac23c91fc09007d78330f';
Date: 2024-12-29 11:49:17 Duration: 16ms
5 1,330,041 2m 0ms 1ms 0ms select base_registry_signaling.last_value, base_cache_signaling.last_value from base_registry_signaling, base_cache_signaling;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 29 00 23,868 2s150ms 0ms 01 18,978 1s639ms 0ms 02 19,591 1s725ms 0ms 03 18,395 1s633ms 0ms 04 17,540 1s518ms 0ms 05 14,094 1s235ms 0ms 06 14,562 1s270ms 0ms 07 12,980 1s92ms 0ms 08 29,966 2s655ms 0ms 09 71,439 6s25ms 0ms 10 98,794 9s177ms 0ms 11 117,022 10s470ms 0ms 12 113,292 10s515ms 0ms 13 117,064 10s673ms 0ms 14 110,264 9s667ms 0ms 15 101,779 9s592ms 0ms 16 97,331 8s818ms 0ms 17 78,008 7s254ms 0ms 18 66,268 6s196ms 0ms 19 57,502 5s362ms 0ms 20 42,690 4s125ms 0ms 21 70,401 5s700ms 0ms 22 18,213 1s521ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-29 00:20:01 Duration: 1ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-29 20:08:31 Duration: 1ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-29 21:52:34 Duration: 0ms
6 997,176 2m16s 0ms 23ms 0ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."sid" AS "sid", "res_users"."exp_date" AS "exp_date", "res_users"."logged_in" AS "logged_in", "res_users"."last_update" AS "last_update", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 29 00 16,479 2s314ms 0ms 01 10,931 1s670ms 0ms 02 11,273 1s808ms 0ms 03 10,515 1s694ms 0ms 04 10,854 1s701ms 0ms 05 7,675 1s364ms 0ms 06 9,246 1s506ms 0ms 07 8,382 1s366ms 0ms 08 21,377 3s84ms 0ms 09 58,967 8s8ms 0ms 10 80,565 11s38ms 0ms 11 97,895 12s458ms 0ms 12 87,083 11s248ms 0ms 13 89,854 11s961ms 0ms 14 77,144 9s686ms 0ms 15 68,827 9s473ms 0ms 16 63,726 8s273ms 0ms 17 52,570 7s646ms 0ms 18 43,117 7s549ms 0ms 19 37,715 6s314ms 0ms 20 25,964 3s987ms 0ms 21 97,714 10s539ms 0ms 22 9,303 1s683ms 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 (838);
Date: 2024-12-29 11:30:08 Duration: 23ms
-
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 (901);
Date: 2024-12-29 17:21:55 Duration: 9ms
-
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 (1299);
Date: 2024-12-29 17:21:55 Duration: 9ms
7 739,716 2m9s 0ms 48ms 0ms commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 29 00 11,748 2s177ms 0ms 01 8,486 1s794ms 0ms 02 9,470 1s960ms 0ms 03 8,633 1s945ms 0ms 04 9,074 1s756ms 0ms 05 6,623 1s464ms 0ms 06 7,683 1s465ms 0ms 07 6,955 1s181ms 0ms 08 16,371 2s709ms 0ms 09 44,216 7s490ms 0ms 10 60,092 11s147ms 0ms 11 72,015 12s209ms 0ms 12 65,322 12s382ms 0ms 13 66,143 11s458ms 0ms 14 58,354 10s54ms 0ms 15 53,540 10s34ms 0ms 16 49,258 8s177ms 0ms 17 41,110 7s708ms 0ms 18 33,631 6s594ms 0ms 19 29,592 5s848ms 0ms 20 20,547 4s569ms 0ms 21 53,493 4s358ms 0ms 22 7,360 1s423ms 0ms -
COMMIT;
Date: 2024-12-29 12:26:09 Duration: 48ms
-
COMMIT;
Date: 2024-12-29 12:26:15 Duration: 38ms
-
COMMIT;
Date: 2024-12-29 19:24:55 Duration: 34ms
8 653,595 1m22s 0ms 5ms 0ms select "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" from "urgent_customer" where "urgent_customer".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 29 00 12,961 2s416ms 0ms 01 7,030 938ms 0ms 02 5,823 677ms 0ms 03 7,151 914ms 0ms 04 6,091 734ms 0ms 05 4,446 503ms 0ms 06 5,399 621ms 0ms 07 5,026 586ms 0ms 08 13,753 1s800ms 0ms 09 36,251 4s746ms 0ms 10 50,363 7s70ms 0ms 11 69,835 10s41ms 0ms 12 50,869 8s30ms 0ms 13 53,930 8s157ms 0ms 14 44,131 6s36ms 0ms 15 39,367 5s569ms 0ms 16 36,577 4s742ms 0ms 17 31,054 4s61ms 0ms 18 28,565 3s521ms 0ms 19 26,745 3s395ms 0ms 20 19,356 2s668ms 0ms 21 92,258 4s630ms 0ms 22 6,614 677ms 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 (5099206, 5099009, 5099415, 5099590, 5112309, 5104559, 5100070, 5099007, 5099329, 5099181, 5112839, 5099236, 5099360, 5099135, 5099277, 5102823, 5100142, 5099815, 5099008, 5114078, 5099027, 5099967, 5099013, 5099503, 5108558, 5104575, 5184766, 5331864, 5456524, 5114223, 5162156, 5099144, 5100628, 5272726, 5099141, 5133980, 5099765, 5099826, 5456516, 5099557, 5126401, 5100202, 5099014, 5456515, 5099321, 5099103, 5117709, 5127932, 5105621);
Date: 2024-12-29 17:21:56 Duration: 5ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099296, 5109767, 5106695, 5099010, 5099181, 5100419, 5102366);
Date: 2024-12-29 17:21:56 Duration: 4ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5103712, 5099474, 5102681, 5100669, 5099504, 5099568, 5098996, 5101328, 5099138, 5149762, 5099179, 5101018, 5179168, 5100246, 5132434, 5148491, 5099929, 5099719, 5102985, 5099515, 5110660, 5099360, 5101850, 5104351, 5106588, 5099042, 5099920, 5265603, 5101079, 5099541, 5263100, 5100419, 5103302, 5099749, 5110332, 5099866, 5099045, 5099947, 5103415, 5101563, 5099247, 5099231, 5101903, 5100354, 5123579, 5100722, 5100396, 5193563, 5429610, 5099901, 5246836, 5100054, 5103051, 5099650, 5100857, 5099163, 5134103, 5099128, 5099456, 5425459, 5102190, 5101184, 5296305, 5102075, 5099458, 5099556, 5104885, 5102314, 5100390, 5103371, 5102816, 5101246, 5105758, 5099720, 5102199, 5099264, 5099646, 5099528, 5099216, 5353250, 5100684, 5100520, 5099094, 5099433, 5183158, 5100821, 5099995, 5099116, 5104964, 5105954, 5099141, 5101362, 5108535, 5099305, 5099752, 5410003, 5110303, 5278694, 5101209, 5101682, 5118481, 5449101, 5245873, 5213512, 5102469, 5203356, 5102390, 5099761, 5198278, 5110833, 5106417, 5107242, 5177544, 5100833, 5169010, 5100477, 5099444, 5108707, 5215775, 5099916, 5110897, 5112342, 5099322, 5449667, 5099677, 5103117, 5115808, 5099875);
Date: 2024-12-29 17:21:57 Duration: 4ms
9 634,587 37s610ms 0ms 1ms 0ms select "urgent_office"."id" AS "id", "urgent_office"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_office"."active" AS "active", "urgent_office"."name" AS "name", "urgent_office"."code" AS "code", "urgent_office"."new_code" AS "new_code", "urgent_office"."last_balance_cash" AS "last_balance_cash", "urgent_office"."last_balance_cheque" AS "last_balance_cheque", "urgent_office"."last_daily_movement_date" AS "last_daily_movement_date", "urgent_office"."client_office" AS "client_office", "urgent_office"."is_create_cheques" AS "is_create_cheques", "urgent_office"."create_uid" AS "create_uid", "urgent_office"."create_date" AS "create_date", "urgent_office"."write_uid" AS "write_uid", "urgent_office"."write_date" AS "write_date", "urgent_office"."v_10_id" AS "v_10_id" from "urgent_office" where "urgent_office".id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 29 00 9,000 536ms 0ms 01 5,565 312ms 0ms 02 4,846 283ms 0ms 03 5,207 306ms 0ms 04 4,493 235ms 0ms 05 2,840 154ms 0ms 06 5,092 255ms 0ms 07 5,344 281ms 0ms 08 12,459 693ms 0ms 09 33,619 1s852ms 0ms 10 47,131 3s96ms 0ms 11 61,622 3s931ms 0ms 12 51,823 3s635ms 0ms 13 55,267 3s529ms 0ms 14 46,202 2s909ms 0ms 15 42,362 2s921ms 0ms 16 39,521 2s380ms 0ms 17 31,904 2s34ms 0ms 18 27,188 1s679ms 0ms 19 26,260 1s734ms 0ms 20 19,006 1s244ms 0ms 21 91,917 3s274ms 0ms 22 5,919 327ms 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 (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, 1, 38, 121, 9, 127, 113, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 57, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);
Date: 2024-12-29 10:45:22 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 (1, 17, 28, 29, 27, 75, 11, 9, 123, 30, 32, 10, 44, 113, 52, 4, 102, 35, 110, 119, 128, 71, 8, 78, 68, 16, 36, 77, 6, 41, 39, 73, 7, 115, 26, 3, 38, 24, 80, 19, 126, 65, 70, 64, 2, 67, 46, 42, 5, 60, 22, 61, 76, 127, 48, 121, 13, 49, 114);
Date: 2024-12-29 10:13:21 Duration: 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 (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);
Date: 2024-12-29 17:21:55 Duration: 0ms
10 419,708 1m16s 0ms 10ms 0ms select "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" from "res_partner" where "res_partner".id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 29 00 6,584 1s69ms 0ms 01 3,904 638ms 0ms 02 2,967 549ms 0ms 03 2,862 543ms 0ms 04 2,581 485ms 0ms 05 1,788 337ms 0ms 06 3,094 514ms 0ms 07 3,607 568ms 0ms 08 9,959 1s591ms 0ms 09 25,891 4s255ms 0ms 10 34,579 6s374ms 0ms 11 40,967 7s836ms 0ms 12 37,224 7s318ms 0ms 13 38,600 6s934ms 0ms 14 32,578 5s812ms 0ms 15 28,813 5s858ms 0ms 16 26,688 4s951ms 0ms 17 22,091 4s296ms 0ms 18 17,016 3s277ms 0ms 19 15,857 3s77ms 0ms 20 10,316 2s76ms 0ms 21 47,607 7s589ms 0ms 22 4,135 664ms 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 (2);
Date: 2024-12-29 17:21:55 Duration: 10ms
-
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (2);
Date: 2024-12-29 17:21:55 Duration: 10ms
-
SELECT "res_partner"."id" AS "id", "res_partner"."message_main_attachment_id" AS "message_main_attachment_id", "res_partner"."email_normalized" AS "email_normalized", "res_partner"."message_bounce" AS "message_bounce", "res_partner"."name" AS "name", "res_partner"."display_name" AS "display_name", "res_partner"."date" AS "date", "res_partner"."title" AS "title", "res_partner"."parent_id" AS "parent_id", "res_partner"."ref" AS "ref", "res_partner"."lang" AS "lang", "res_partner"."tz" AS "tz", "res_partner"."user_id" AS "user_id", "res_partner"."vat" AS "vat", "res_partner"."company_registry" AS "company_registry", "res_partner"."website" AS "website", "res_partner"."comment" AS "comment", "res_partner"."active" AS "active", "res_partner"."employee" AS "employee", "res_partner"."function" AS "function", "res_partner"."type" AS "type", "res_partner"."street" AS "street", "res_partner"."street2" AS "street2", "res_partner"."zip" AS "zip", "res_partner"."city" AS "city", "res_partner"."state_id" AS "state_id", "res_partner"."country_id" AS "country_id", "res_partner"."partner_latitude" AS "partner_latitude", "res_partner"."partner_longitude" AS "partner_longitude", "res_partner"."email" AS "email", "res_partner"."phone" AS "phone", "res_partner"."mobile" AS "mobile", "res_partner"."is_company" AS "is_company", "res_partner"."industry_id" AS "industry_id", "res_partner"."company_id" AS "company_id", "res_partner"."color" AS "color", "res_partner"."partner_share" AS "partner_share", "res_partner"."commercial_partner_id" AS "commercial_partner_id", "res_partner"."commercial_company_name" AS "commercial_company_name", "res_partner"."company_name" AS "company_name", "res_partner"."create_uid" AS "create_uid", "res_partner"."create_date" AS "create_date", "res_partner"."write_uid" AS "write_uid", "res_partner"."write_date" AS "write_date", "res_partner"."office_id" AS "office_id", "res_partner"."employee_traffic" AS "employee_traffic", "res_partner"."code" AS "code", "res_partner"."office_driver_id" AS "office_driver_id", "res_partner"."type_employee" AS "type_employee", "res_partner"."type_driver" AS "type_driver", "res_partner"."v_10_id" AS "v_10_id" FROM "res_partner" WHERE "res_partner".id IN (8007152);
Date: 2024-12-29 15:14:23 Duration: 4ms
11 394,921 2m7s 0ms 13ms 0ms select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 29 00 2,899 908ms 0ms 01 1,518 475ms 0ms 02 1,545 501ms 0ms 03 1,007 330ms 0ms 04 530 182ms 0ms 05 367 119ms 0ms 06 1,049 336ms 0ms 07 1,907 579ms 0ms 08 8,361 2s591ms 0ms 09 17,615 5s301ms 0ms 10 32,890 10s936ms 0ms 11 43,311 14s1ms 0ms 12 52,945 17s455ms 0ms 13 38,446 12s589ms 0ms 14 35,798 11s286ms 0ms 15 40,772 13s674ms 0ms 16 35,323 11s124ms 0ms 17 27,401 9s103ms 0ms 18 12,714 4s166ms 0ms 19 16,372 5s399ms 0ms 20 11,833 3s847ms 0ms 21 6,727 1s972ms 0ms 22 3,591 1s39ms 0ms -
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.company' 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 = 1055) OR r.global) ORDER BY r.id;
Date: 2024-12-29 11:35:00 Duration: 13ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'shipping.policy' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 974) OR r.global) ORDER BY r.id;
Date: 2024-12-29 12:28:55 Duration: 5ms
-
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'urgent.customer' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 920) OR r.global) ORDER BY r.id;
Date: 2024-12-29 19:24:26 Duration: 2ms
12 307,962 1m13s 0ms 16ms 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 Dec 29 00 5,750 1s729ms 0ms 01 2,993 858ms 0ms 02 2,432 608ms 0ms 03 3,090 883ms 0ms 04 2,483 656ms 0ms 05 2,204 598ms 0ms 06 2,389 651ms 0ms 07 2,348 622ms 0ms 08 5,923 1s663ms 0ms 09 14,504 4s48ms 0ms 10 20,829 5s626ms 0ms 11 37,139 8s203ms 0ms 12 21,745 6s676ms 0ms 13 24,160 6s467ms 0ms 14 20,097 5s33ms 0ms 15 20,453 5s92ms 0ms 16 16,306 4s249ms 0ms 17 14,789 3s772ms 0ms 18 13,911 3s313ms 0ms 19 14,963 3s640ms 0ms 20 10,079 2s974ms 0ms 21 45,888 4s856ms 0ms 22 3,487 785ms 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 (41655785, 41371596, 41440735, 41656284, 41656737, 41656736, 41656735, 41568980, 41442076, 41679381, 41567216, 41737228, 41659993, 41281919, 41656287, 41372949, 41569404, 41372968, 41658084, 41281918, 41372974, 41579485, 41657648, 41655838, 41440730, 41135585, 41656290, 41656288, 41657746, 41372122, 41372955, 41372969, 41656093, 41657748, 41658156, 41283213, 41374455, 41656976, 41656126, 41656377, 41440732, 41679553, 41567918, 41655652, 41568982, 41567838, 41656619, 41655650, 41440719, 41568979, 41372978, 41655848, 41656289, 41374476, 41372973, 41656133, 41679564, 41567449, 41679621, 41374468, 41656359, 41372959, 41656129, 41655839, 41440733, 41566688, 41179487, 41656131, 41374474, 41568534, 41372975, 41655645, 41440726, 41656618, 41568571, 41679552, 41372961, 41372971, 41568040, 41441875, 41568320, 41372948, 41372976, 41655845, 41656127, 41568978, 41656094, 41374453, 41679551, 41374479, 41374467, 41655648, 41656132, 41655646, 41567795, 41567142, 41679382, 41567850, 41567813, 41086374, 41632946, 41568137, 41679271, 41440722, 41655843, 41440279, 41655647, 41737229, 41372415, 41568966, 41440718, 41656379, 41679210, 41372416, 41679380, 41568538, 41568105, 41568965, 41440723, 41440708, 41440720, 41372412, 41423538, 41656362, 41568540, 41568054, 41440721, 41568963, 41442279, 41568232, 41372414, 41656363, 41568961, 41655847, 41655651, 41568039, 41568532, 41568964, 41655649, 41568969, 41440724, 41678796, 41679272, 41679231, 41372409, 41568443, 41567590, 41567919, 41567450, 41372405, 41442211, 41567401, 41567589, 41567920, 41567904, 41567587, 41017536, 41442213, 41567841, 41567798, 41569198, 41440356, 41567531, 41567453, 41442212, 41017539, 41017541, 41439168, 41372396, 41374096, 41439169, 41372393, 41423539, 41372395, 41372397, 41373037, 41372401, 41440336, 41372400, 41439170, 41373375, 41373036, 41439618, 41281753, 41282660, 41282661, 41281950, 41191731, 41191730, 41017593, 40948738, 40318739, 40359162, 40359163, 40318737);
Date: 2024-12-29 10:36:20 Duration: 16ms
-
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 (41578570, 41572597, 41683704, 41709490, 41506132, 41417987, 41760036, 41801787, 41728129, 41570127, 41700548, 41875999, 41882847, 41746650, 41486220, 41589811, 41806925, 41297632, 41055790, 41261823, 41648747, 41627006, 41543840, 41739112, 41712704, 32650791, 41583382, 41737538, 41795118, 41791441, 41645473, 41712201, 41306268);
Date: 2024-12-29 17:21:56 Duration: 9ms
-
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 (41775345, 41791850, 41846356, 41764797, 41659318, 41789840, 41796298, 41681676, 41510169, 41816714, 41709120, 41723523, 41840677, 41599973, 41790055, 41739500, 41573374, 41731526, 41453833, 41748656, 41791809, 40907986, 41648228, 41728539, 41740901, 41849952, 41573716, 40517241, 41686530, 41658274, 41207618, 41886929, 41388300, 41848448, 41791995, 41769164, 41782429, 41877410, 41887450, 41648073, 41648048, 41749208, 41263109, 41651000, 41779340, 41770333, 41594800, 41845396, 41632266, 41682294, 41575909, 41792756, 41845750, 41714013, 41815851, 41723720, 41850169, 41757810, 41794218, 41540074, 41794548, 41735229, 41767958, 41875665, 41845409, 41845029, 41823703, 41828408, 41668170, 41250997, 41789997, 41672681, 41570558, 41487408, 41597972, 41522887, 41849845, 41789588, 41850268, 41465718, 41794053, 41602356, 41743247, 41670564, 41675651, 41824243, 41866112, 41848803, 41786109, 41610898, 41801646, 41849666, 41368495, 41864717, 41779220, 41775399, 41787357, 41864946, 41631696, 41691852, 41714355, 41570375, 41758688, 41810957, 41723498, 41845335, 41793741, 41508654, 41829501, 41469573, 41692489, 41743559, 41550141, 41789729, 41810543, 41565623, 41603541, 41734736, 41607572, 41717807, 41796456, 41590232, 41824882, 32641369, 41446580, 41568664, 41679470, 41792613, 41828850, 41849885, 41827906, 41780970, 41877018, 41753050, 41753044, 41743566, 41760010, 41779155, 41806599, 41758601, 41793710, 41816734, 41876782, 41602369, 41742253, 41729994, 41810903, 41592724, 41804782, 41824119, 41779149, 41758889, 41876999, 41747605, 41811247, 41806531, 41801917, 41625396, 41570377, 41708776, 41626582, 41431752, 41801726, 41779432, 41561371, 41804650, 41764811, 41741815, 41628576, 41703002, 41794151, 41695140, 41718079, 41460642, 41769512, 41661764, 41561362, 41698086, 41654487, 41756917, 41659399, 41816720, 41733130, 41875700, 41799195, 41845600, 41706662, 41462494, 41844646, 41700192, 41742122, 41844892, 41730977, 41824885, 32619396, 41657119, 41783758, 41758380, 41708227, 41547967, 41795534, 41793703, 41779130, 41876158, 41120409, 41845282, 41877561, 41281567, 41707459, 41795161, 41481065, 41523729, 41372970, 41696997, 41585332, 41692421, 41795580, 41843354, 41168929, 41510362, 41844909, 41692577, 41768410, 41610857, 41133818, 41849753, 41801648, 41374037, 41372977, 41793522, 41356873, 41850560, 41103442, 41241273, 41555516, 41442283, 41712263, 41816633, 41662041, 41373799, 41786975, 40573890, 40747630, 41597985, 41805764, 41549428, 41616993, 32640631, 41503085, 41694381, 41781352, 41255744, 41611470, 41372440, 41286952, 41648155, 41759865, 41827866, 41607626, 41680541, 32648830, 41745576, 41666194, 41656559, 41686026, 41728597, 41584392, 41818761, 41690293, 41741772, 41720397, 41462480, 41331881, 41717616, 41589701, 41594510, 41828872, 41816707, 41796106, 41672530, 41394875, 41067653, 41702600, 41760363, 41737855, 41684329, 41758667, 41662665, 41503088, 41773875, 41331603, 41542557, 41509914, 41748204, 41622724, 41684306, 41631912, 41700886, 41751147, 41802411, 41657922, 41661311, 41767845, 41569518, 41729790, 41786796, 41729049, 41132986, 41690315, 41765822, 40895947, 41765045, 41373815, 41729107, 41477111, 41678455, 41567493, 41843174, 41629535, 41620342, 41745221, 41502705, 41705315, 41823708, 41620372, 41727482, 41547324, 41210467, 41843542, 41793506, 41770388, 41492633, 41692688, 40345087, 41789725, 41792973, 41659334, 41729230, 41816669, 41461991, 41570791, 41790998, 41774442, 41684277, 41780100, 41423906, 41813463, 41738310, 41569338, 41692135, 41451808, 41764353, 41688728, 41207023, 41747942, 41813417, 41585647, 41695131, 41810917, 41331988, 41794544, 41849724, 41730619, 41605587, 41573975, 41648121, 41690326, 41570368, 41566303, 41570361, 41586560, 41713993, 41480074, 41651375, 41723670, 41710971, 41658406, 41753045, 41744824, 41791804, 41705331, 41737045, 41658395, 41778650, 41681735, 41689686, 41809970, 41722674, 41600774, 41808970, 41554345, 41810933, 41405037, 41787354, 41757664, 41769665, 41758452, 41782417, 41297756, 41358462, 41171333, 41693712, 41875976, 41610981, 41197308, 41683386, 41459335, 41130084, 41089731, 41826660, 41633472, 41757388, 41845650, 41695993, 41668764, 41745499, 41120288, 41659327, 41737570, 41826643, 41611838, 41757824, 41743131, 41731505, 41683009, 41501731, 41501962, 41689157, 41646808, 41760107, 41570306, 41584235, 41802177, 41795075, 41706988, 41331623, 41788804, 41113726, 41848345, 40784016, 41826654, 41723621, 41699385, 41740831, 41717613, 41749370, 41768216, 41719683, 41532659, 41778934, 41664883, 41742251, 38767635, 41788097, 41741447, 41310000, 41735734, 41707340, 41642947, 41570246, 41620374, 41206301, 41003905, 41758350, 41865745, 41717611, 41472814, 40894555, 41678666, 41172252, 41688864, 41757865, 41603074, 41794752, 41559103, 41687941, 41313771, 41357018, 41348390, 41799477, 41768893, 40930448, 41720036, 41356400, 41765024, 41745506, 41670173, 41712675, 41352779, 41801555, 41673018, 41623948, 41657115, 41448480, 41499965, 41811363, 41559101, 41629666, 41591920, 41683369, 41758409, 41445974, 41765948, 41743563, 41671217, 40988257, 41571601, 41669671, 41668634, 41503381, 41672072, 41818950, 41538817, 41849882, 41790592, 41657287, 41657915, 41651814, 41679566, 41716922, 41384986, 41710007, 41685513, 41503660, 41597887, 41573988, 41760425, 41802558, 41584371, 41614755, 41532873, 41633625, 41633491, 41876681, 41845769, 41764508, 41854914, 41782171, 41584370, 41612490, 41701699, 41759070, 41860295, 41442417, 41725633, 41569337, 41803684, 41695858, 41569808, 41860296, 41760027, 41659397, 41692581, 41774839, 41638391, 41785106, 41791099, 41829605, 41720990, 41624496, 41487411, 41782432, 41744506, 41731408, 41395366, 41790141, 41841361, 41383929, 41760146, 41624519, 41825015, 41689318, 41769011, 41789972, 41250579, 41416117, 41685489, 41591141, 41598599, 41462208, 41506629, 41708963, 41713040, 41427506, 41600691, 41699954, 41533409, 41610510, 41792383, 41629848, 41868198, 41877030, 41710934, 41731701, 41845034, 41753185, 41790710, 41539879, 41764673, 41791755, 41793850, 41510415, 41806011, 41650586, 41806099, 41607624, 41766020, 41791802, 41875711, 41805342, 41222386, 41494277, 41574537, 41813544, 41583010, 41489223, 41792594, 41742552, 41775393, 41611439, 41619511, 41579038, 41694508, 41877000, 41252463, 41729987, 41865744, 41448540, 41584421, 41707625, 41840683, 41692532, 41729059, 41876629, 41805602, 41689329, 41523306, 41810702, 41805254, 41721211, 41753056, 41539193, 41808145, 41708866, 41644994, 41611443, 41645341, 41769661, 41886898, 41876152, 41793468, 41753188, 41316949, 41789820, 41625227, 41610917, 41622739, 41624253, 41741556, 41711970, 41799469, 41569421, 41584383, 41780732, 41610864, 41876761, 41780627, 41468833, 32646417, 41677386, 41253409, 41671429, 41669498, 41585333, 41393086, 41681681, 41679790, 41691754, 41692531, 41791671, 41567928, 41645094, 41252519, 41659411, 41801912, 41807206, 41802586, 41584360, 41726232, 41628456, 41665096, 41828252, 41760159, 41801784, 41132088, 41570447, 41816647, 41760015, 41790950, 41788825, 41689028, 41816745, 41753104, 41802587, 41035912, 41357017, 41749737, 41845037, 41607593, 41766029, 41843052, 41742936, 41813406, 41442424, 41708938, 41739386, 41846360, 41723427, 41875695, 41668488, 41824171, 41678274, 41244491, 41509904, 41828807, 41614841, 41056554, 41277094, 41584350, 41654485, 41666367, 41742436, 41694139, 41799421, 41749418, 41782529, 41828798, 41658275, 41746720, 41806971, 41727961, 41618019, 41684261, 41760407, 41593529, 41277092, 41802356, 41854910, 41877559, 41802606, 41802381, 41828693, 41760205, 41798864, 41786045, 41689032, 41684348, 41714158, 41132981, 41666366, 41665095, 41748800, 41764996, 41533510, 41481061, 41789983, 41277093, 41624016, 41850418, 41813137, 41277100, 41789904, 41368512, 41760242, 41723630, 41706894, 41845601, 41636288, 41737528, 41769407, 41874843, 41802549, 41246739, 41694302, 41828812, 41850405, 41760265, 41741393, 41700572, 41667830, 32641215, 41434282, 41563424, 41745502, 41717610, 41691890, 41238123, 41793852, 41427312, 41230107, 41570304, 41886904, 41813244, 41600495, 41828873, 41658709, 41828875, 41842671, 41729990, 41781853, 41692124, 41586908, 41645112, 41802612, 41537866, 41503726, 41692278, 41849672, 41067732, 41230336, 41356980, 41793105, 41740768, 41595114, 41586848, 41659017, 41802420, 41462512, 41704283, 41797443, 41707612, 41656536, 41794475, 41760444, 41801823, 41736787, 41659232, 41801765, 41745109, 41416153, 41824740, 41729520, 41710255, 41584407, 41818829, 41715932, 41779321, 41753132, 41591924, 41860292, 41646018, 41759951, 41702718, 41789009, 41656337, 41661314, 41792549, 41278772, 41591121, 41768888, 41868160, 41789912, 41791817, 41843166, 41462518, 41850564, 41573023, 41742478, 41876890, 41769605, 41684466, 41490209, 41746791, 41702109, 41806518, 41779233, 41348436, 41828891, 41734854, 41695897, 41793500, 41692627, 41598592, 41499977, 41623460, 41786807, 41704597, 41739501, 41686329, 41874846, 41662533, 41588743, 41759269, 41569806, 41393083, 41691759, 41584369, 41793704, 41802472, 41845322, 41692180, 41584258, 41067308, 41698356, 41670590, 41735569, 41681709, 41686328, 41774871, 41832919, 41805767, 41801720, 41781976, 41533418, 41651038, 41696923, 41569133, 41786206, 41648578, 41681759, 40798935, 41574590, 41864967, 41681684, 41840724, 41790971, 41534383, 41796970, 41764912, 41875860, 41623287, 41584877, 41793836, 41647678, 41827164, 41753321, 41811379, 41599681, 41584345, 41790037, 41734469, 41803790, 41489214, 41790031, 41719047, 41849735, 41866366, 41845035, 41693935, 41875934, 41742549, 41848458, 41731706, 41632228, 41171538, 41652708, 41877034, 41866391, 41875718, 41166760, 41354999, 41747595, 41625401, 41798899, 41738161, 41238111, 41865159, 41348025, 41764813, 41840739, 41753109, 41584253, 41731484, 40719640, 41602417, 41393057, 41787436, 41590827, 41753178, 41702456, 41781140, 41845422, 41737070, 41793862, 41765945, 41838420, 41569803, 41790137, 41717172, 41876602, 41744444, 41631120, 41355251, 41845587, 41789837, 41730631, 41763948, 41304129, 41670617, 41689855);
Date: 2024-12-29 19:24:22 Duration: 8ms
13 288,284 51s165ms 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 Dec 29 00 2,452 337ms 0ms 01 1,650 211ms 0ms 02 1,805 230ms 0ms 03 1,119 149ms 0ms 04 657 80ms 0ms 05 522 61ms 0ms 06 1,019 139ms 0ms 07 1,528 216ms 0ms 08 8,091 1s191ms 0ms 09 15,076 2s330ms 0ms 10 24,935 4s473ms 0ms 11 29,998 5s468ms 0ms 12 37,182 7s275ms 0ms 13 25,671 4s613ms 0ms 14 25,536 4s432ms 0ms 15 28,664 5s549ms 0ms 16 25,333 4s443ms 0ms 17 20,392 3s731ms 0ms 18 8,740 1s454ms 0ms 19 10,826 1s986ms 0ms 20 8,784 1s554ms 0ms 21 5,266 778ms 0ms 22 3,038 453ms 0ms -
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2024-12-29 12:29:25 Duration: 2ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 1 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_erp_manager' AND model = 'res.groups');
Date: 2024-12-29 15:12:27 Duration: 1ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 821 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_system' AND model = 'res.groups');
Date: 2024-12-29 12:29:25 Duration: 1ms
14 253,082 1d9h8m19s 403ms 3s78ms 471ms 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 Dec 29 00 9,100 1h8m11s 449ms 01 6,443 47m2s 438ms 02 7,795 56m50s 437ms 03 10,173 1h15m6s 442ms 04 7,645 55m45s 437ms 05 6,192 45m39s 442ms 06 4,456 32m31s 438ms 07 3,315 24m35s 445ms 08 5,668 41m32s 439ms 09 11,813 1h27m44s 445ms 10 17,383 2h16m43s 471ms 11 17,718 2h19m25s 472ms 12 15,681 2h8m26s 491ms 13 14,078 1h49m23s 466ms 14 12,352 1h35m23s 463ms 15 14,885 2h1m6s 488ms 16 10,624 1h22m13s 464ms 17 15,769 2h10m29s 496ms 18 18,139 2h30m56s 499ms 19 15,341 2h8m34s 502ms 20 19,337 2h38m22s 491ms 21 5,438 42m51s 472ms 22 3,737 29m23s 471ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4011114)) AND (("shipping_track"."id" not in (32803468, 32803585, 32803922, 32912518, 32912641, 32981921, 32981921)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 3s78ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3102795)) AND (("shipping_track"."id" not in (25270502, 25271463, 32519838, 32519839, 32522286, 32522855, 32523043, 32981671, 32981671)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:03 Duration: 2s725ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4024192)) AND (("shipping_track"."id" not in (32854639, 32855073, 32855309, 32915843, 32916003, 32916098, 32981553, 32981924, 32981924)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 1s570ms
15 234,664 16s995ms 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 Dec 29 00 3,743 263ms 0ms 01 2,177 133ms 0ms 02 1,886 115ms 0ms 03 2,076 143ms 0ms 04 1,948 127ms 0ms 05 1,161 79ms 0ms 06 1,704 110ms 0ms 07 1,658 103ms 0ms 08 4,734 295ms 0ms 09 12,650 799ms 0ms 10 17,766 1s333ms 0ms 11 23,518 1s738ms 0ms 12 18,369 1s658ms 0ms 13 19,417 1s614ms 0ms 14 16,027 1s16ms 0ms 15 13,890 1s35ms 0ms 16 12,932 947ms 0ms 17 10,256 915ms 0ms 18 9,128 821ms 0ms 19 7,989 810ms 0ms 20 5,565 476ms 0ms 21 44,213 2s337ms 0ms 22 1,857 117ms 0ms -
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2024-12-29 17:21:56 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2024-12-29 12:38:17 Duration: 0ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2024-12-29 20:37:09 Duration: 0ms
16 172,639 9s990ms 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 #16
Day Hour Count Duration Avg duration Dec 29 00 1,217 61ms 0ms 01 611 30ms 0ms 02 607 29ms 0ms 03 375 19ms 0ms 04 181 9ms 0ms 05 131 6ms 0ms 06 429 22ms 0ms 07 726 36ms 0ms 08 3,605 188ms 0ms 09 7,572 391ms 0ms 10 14,120 835ms 0ms 11 18,811 1s107ms 0ms 12 24,663 1s506ms 0ms 13 16,627 958ms 0ms 14 15,970 878ms 0ms 15 18,098 1s113ms 0ms 16 15,260 863ms 0ms 17 11,534 689ms 0ms 18 5,421 304ms 0ms 19 6,912 405ms 0ms 20 5,109 300ms 0ms 21 2,951 147ms 0ms 22 1,709 85ms 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 (99);
Date: 2024-12-29 19:03:42 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 (21);
Date: 2024-12-29 17:51:42 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: 2024-12-29 14:40:20 Duration: 0ms
17 167,110 20s356ms 0ms 1ms 0ms select rule_group_rel.rule_group_id, rule_group_rel.group_id from rule_group_rel, "res_groups" where ? = ? and rule_group_rel.rule_group_id in (...) and rule_group_rel.group_id = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 29 00 1,204 128ms 0ms 01 604 63ms 0ms 02 589 60ms 0ms 03 370 39ms 0ms 04 180 18ms 0ms 05 122 12ms 0ms 06 413 45ms 0ms 07 720 76ms 0ms 08 3,546 390ms 0ms 09 7,410 801ms 0ms 10 13,724 1s719ms 0ms 11 18,393 2s271ms 0ms 12 23,796 3s64ms 0ms 13 16,136 1s965ms 0ms 14 15,503 1s789ms 0ms 15 17,709 2s297ms 0ms 16 14,781 1s755ms 0ms 17 10,947 1s376ms 0ms 18 5,187 611ms 0ms 19 6,560 817ms 0ms 20 4,779 589ms 0ms 21 2,748 283ms 0ms 22 1,689 176ms 0ms -
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (98, 99) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 12:51:53 Duration: 1ms
-
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (21) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 15:55:37 Duration: 1ms
-
SELECT rule_group_rel.rule_group_id, rule_group_rel.group_id FROM rule_group_rel, "res_groups" WHERE 1 = 1 AND rule_group_rel.rule_group_id IN (89) AND rule_group_rel.group_id = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 12:45:44 Duration: 0ms
18 149,846 1h39m54s 29ms 219ms 40ms select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 29 00 3,814 2m22s 37ms 01 3,096 1m55s 37ms 02 2,512 1m33s 37ms 03 3,226 2m1s 37ms 04 2,052 1m16s 37ms 05 1,653 1m1s 37ms 06 2,060 1m16s 37ms 07 895 33s744ms 37ms 08 2,146 1m20s 37ms 09 8,302 5m18s 38ms 10 12,295 8m16s 40ms 11 13,041 8m48s 40ms 12 12,993 9m9s 42ms 13 11,053 7m18s 39ms 14 10,349 6m48s 39ms 15 11,551 7m55s 41ms 16 8,551 5m35s 39ms 17 8,264 5m41s 41ms 18 8,206 5m40s 41ms 19 9,578 6m32s 41ms 20 8,272 5m35s 40ms 21 3,595 2m21s 39ms 22 2,342 1m30s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4035558)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 219ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3909283)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:57 Duration: 191ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3523517)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:29:24 Duration: 175ms
19 145,964 1m31s 0ms 34ms 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 #19
Day Hour Count Duration Avg duration Dec 29 00 1,524 2s46ms 1ms 01 727 766ms 1ms 02 334 173ms 0ms 03 213 135ms 0ms 04 161 100ms 0ms 05 163 95ms 0ms 06 492 188ms 0ms 07 812 341ms 0ms 08 2,337 1s362ms 0ms 09 7,599 5s43ms 0ms 10 10,145 7s704ms 0ms 11 9,938 6s735ms 0ms 12 13,178 10s70ms 0ms 13 11,874 9s779ms 0ms 14 11,574 7s973ms 0ms 15 11,322 6s729ms 0ms 16 10,221 5s223ms 0ms 17 16,030 7s925ms 0ms 18 15,791 8s152ms 0ms 19 8,419 4s497ms 0ms 20 10,550 5s16ms 0ms 21 1,870 1s105ms 0ms 22 690 389ms 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 (3624059, 3681417, 3713925, 3721044, 3785123, 3787340, 3867158, 3873310, 3892503, 3898659, 3903025, 3903962, 3907755, 3912009, 3912020, 3914191, 3925054, 3931304, 3931641, 3933366, 3946562, 3949588, 3949807, 3952818, 3961131, 3961613, 3966755, 3968564, 3977752, 3500461, 3617964, 3625498, 3701191, 3714148, 3729122, 3733477, 3787982, 3796264, 3822303, 3826121, 3833292, 3842256, 3857805, 3871613, 3877048, 3877715, 3902357, 3911954, 3913695, 3936113, 3940870, 3945155, 3951553, 3953735, 3958697, 3960183, 3969189, 3973361, 3974169, 3974467, 3974543, 3978885, 3980693, 3983804, 3986463, 3992502, 3997873, 4002177, 3990333, 3662377, 3877174, 3880084, 3909672, 3918966, 3924337, 3931942, 3932336, 3945349, 3945474, 3948869, 3972316, 3979104, 3980706, 3983823, 3984084, 3958063, 3958079, 3889575, 3843549, 3936485, 3953676, 3973712, 3975050, 3981268, 3982902, 3986467, 3990561, 3991256, 3994852, 3997961, 3910583, 3918993, 3932075, 3934418, 3935181, 3935432, 3941910, 3953086, 3953747, 3959577, 3960542, 3960703, 3963209, 3972048, 3972677, 3973285, 3973775, 3974240, 3974329, 3975531, 3977985, 3979482, 3980056, 3980762, 3981369, 3982522, 3983077, 3983174, 3986459, 3986461, 3986477, 3989702, 3417736, 3546259, 3584345, 3610811, 3658035, 3725512, 3744980, 3761240, 3842284, 3861004, 3868478, 3871760, 3880208, 3899054, 3903624, 3916767, 3918970, 3918984, 3934875, 3942005, 3946910, 3952217, 3960642, 3962320, 3968067, 3973416, 3978026, 3979417, 3980692, 3980709, 3981266, 3986462, 3986471, 3986473, 3771669, 3545786, 3545855, 3786805, 3834160, 3836915, 3836947, 3863181, 3863621, 3880219, 3890565, 3893623, 3896246, 3896321, 3904021, 3909867, 3911873, 3915573, 3921077, 3921080, 3922802, 3926124, 3927348, 3932948, 3933922, 3945806, 3950368, 3978096, 3958078, 3958064, 3553480, 3803878);
Date: 2024-12-29 17:21:57 Duration: 34ms
-
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 (4004811, 4004810, 3904819, 3967693, 3969544, 2653169, 3754735, 3527535, 3135702, 3993853, 3971823, 3972693, 3934415, 3971893, 3968969, 4002110, 3983454, 3933503, 3923239, 3988537, 3813963, 3064221, 3881256, 4037197, 3896250, 3814974, 4002731, 3473993, 3813944, 3968042, 3983161, 4002727, 3945436, 3960955, 3994815, 3971501, 3996149, 3971754, 3998569, 3975061, 3995100, 3977096, 3813976, 2630097, 3642485, 3978115, 3983072, 3962333, 3994056, 3977088, 3995495, 3996307, 4003107, 3998323, 3995661, 3754815, 3736477, 3923159, 3833680, 3894821, 3922853, 3742044, 3805999, 3932416, 3940430, 3936890, 3923805, 3934400, 3915391, 3921325, 3957129, 3865286, 3933722, 3879299, 3955532, 3955522, 2777231, 3916794, 3189342, 3904032, 3659045, 3945236, 3259876, 3086296, 3956642, 3927143, 3936139, 4003360, 3956691, 4002874, 3962335, 3923135, 3962322, 3960940, 3962330, 3958374, 3921775, 3962324, 3962338, 3962292, 3962342, 3962298, 3962348, 3958441, 3962302, 3962307, 3962295, 3962345, 3960934, 3962317, 3893253, 3962288, 3958024, 1722955, 3922492, 3977082, 3093293, 3932965, 3898694, 3479343, 3283126, 3531902, 3873278, 3895179, 3897111, 3617956, 3877227, 3942541, 3459426, 3880498, 3600511, 3350830, 3950091, 3851291, 3846865, 3901726, 3242372, 3373318, 3890192, 3770976, 3962320, 3854978, 3923149, 3879838, 3912538, 3719039, 3796897, 3899012, 3877257, 3915743, 3881679, 3908405, 3873145, 3903379, 3902801, 3887550, 3870764, 3906826, 3899016, 3904363, 3865002, 3933065, 3870632, 3955540, 3926260, 3953665, 3934454, 3920690, 3940278, 3933086, 3951445, 3917644, 3746468, 3665155, 3941008, 3945707, 3893238, 3943573, 3843569, 3911574, 3955550, 3945396, 3926061, 3950245, 3926497, 3897301, 3936723, 3911867, 3936094, 3907941, 3943639, 3933390, 2953556, 3903711, 3946253, 3951404, 3941185, 3937712);
Date: 2024-12-29 17:21:57 Duration: 23ms
-
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 (3915880, 3472346, 3805837, 3946467, 3946454, 3879892, 3949933, 3918685, 3702356, 3879896, 3879891, 3917436, 3704321, 3887535, 3887557, 3920689, 3702947, 3954471, 3917048, 3920013, 3915870, 3917047, 3400917, 3912036, 3909296, 3880228, 3625942, 3842415, 3563216, 3509274, 3918963, 3884400, 3882911, 3882928, 3913874, 3816987, 3911686, 3310389, 3911693, 3909301, 3911690, 3882908, 3919796, 3919786, 3919784, 3920564, 3920568, 3919851, 3888000, 3884135, 3913862, 3916574, 3848428, 3911678, 3842416, 3815056, 3821128, 3918026, 3917046, 3729472, 3911700, 3918013, 3917428, 3696936, 3763679, 3853717, 3822996, 3822241, 3829381, 3869823, 3880227, 3778014, 3879905, 3885519, 3762799, 3879898, 3879903, 3879911, 3884943, 3879894, 3764693, 3885216, 3883352, 3885227, 3765747, 3880817, 3783555, 3883477, 3887285, 3854046, 3853980, 3887046, 3884136, 3729474, 3660270, 3853922, 3879893, 3884137, 3597752, 3818955, 3736414, 3805839, 3855379, 3767265, 3853988, 3757934, 3703638, 3701528, 3761473, 3546644, 3853379, 3819906, 3281662, 3881043, 3759108, 3666941, 3822830, 3852078, 3816502, 3820977, 3852344, 3696963, 3702700, 3515972, 3854292, 3854196, 3729470, 3767380, 3729480, 3853253, 3731222, 3666365, 3731223, 3853169, 3600971, 3734417, 3666653, 3696981, 3727867, 3564322, 3782374, 3805835, 3701504, 3778809, 3813073, 3734534, 3765817, 3704156, 3816634, 3805840, 3765812, 3813091, 3813086, 3665687, 3735794, 3777068, 3824446, 3704712, 3698423, 3824327, 3696967, 3777067, 3816236, 3764896, 3736358, 3731244, 3702889, 3782603, 3694891, 3032974, 3509321, 3669320, 3731246, 3757681, 3757709, 3562691, 3759109, 3660273, 3777070, 3780525, 3768251, 3729478, 3542146, 3702696, 3759110, 3763680, 3768196, 3766328, 3766717, 3696949, 3759085, 3475539, 3777063, 3509033, 3731216, 3729484, 3369729, 3729468, 3757693, 3110113, 3660278, 3729465, 3735194, 3735927, 3701529, 3767884, 3733236, 3736677, 3735130, 3704683, 3696961, 3731243, 3759107, 3362248, 3728309, 3728317, 3439104, 3766711, 3735127, 3729467, 3667941, 3660283, 3732640, 3667948, 3729482, 3595089, 3368054, 3703284, 3665686, 3652660, 3626587, 3662117, 3668360, 3704817, 3550007, 3629904, 3550151, 3599261, 3666959, 3627309, 3627269, 3598934, 3546546, 3437469, 3516153, 3600172, 3560697, 3598828, 3505858, 3514335, 3438083, 3563629, 3563636, 3174136, 3541264, 3511386, 3507505, 3440632, 3473020, 3478488, 3283438, 2683505, 3308374, 3283914, 3285097, 3285079, 3247172, 3249965, 3207635, 3284516, 3234540, 2997469, 3052114, 3052112, 2169974, 2898356, 2581222, 2465987);
Date: 2024-12-29 11:06:36 Duration: 18ms
20 145,694 29s767ms 0ms 2ms 0ms select res_groups_users_rel.uid, res_groups_users_rel.gid from res_groups_users_rel, "res_groups" where ? = ? and res_groups_users_rel.uid in (...) and res_groups_users_rel.gid = res_groups.id order by coalesce("res_groups"."name" ->> ?, "res_groups"."name" ->> ?);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 29 00 1,012 194ms 0ms 01 600 109ms 0ms 02 614 113ms 0ms 03 403 75ms 0ms 04 284 53ms 0ms 05 209 39ms 0ms 06 424 82ms 0ms 07 602 111ms 0ms 08 2,977 571ms 0ms 09 6,728 1s264ms 0ms 10 12,344 2s563ms 0ms 11 16,443 3s311ms 0ms 12 19,699 4s133ms 0ms 13 13,956 2s870ms 0ms 14 13,392 2s659ms 0ms 15 15,222 3s260ms 0ms 16 12,850 2s568ms 0ms 17 9,554 2s20ms 0ms 18 4,844 1s10ms 0ms 19 5,661 1s190ms 0ms 20 4,140 869ms 0ms 21 2,335 431ms 0ms 22 1,401 263ms 0ms -
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (974) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 12:28:55 Duration: 2ms
-
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (960) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 17:21:55 Duration: 2ms
-
SELECT res_groups_users_rel.uid, res_groups_users_rel.gid FROM res_groups_users_rel, "res_groups" WHERE 1 = 1 AND res_groups_users_rel.uid IN (901) AND res_groups_users_rel.gid = res_groups.id ORDER BY COALESCE("res_groups"."name" ->> 'ar_001', "res_groups"."name" ->> 'en_US');
Date: 2024-12-29 17:21:55 Duration: 2ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 25m5s 25m5s 25m5s 1 25m5s select count(*) from ( select from "shipping_policy" where ((("shipping_policy"."active" = true) and (("shipping_policy"."state" != ?) or "shipping_policy"."state" is null)) and (("shipping_policy"."delegate_id" in ( select "res_partner".id from "res_partner" where (((((("res_partner"."display_name"::text not ilike ?) or "res_partner"."display_name" is null) and (("res_partner"."email"::text not ilike ?) or "res_partner"."email" is null)) and (("res_partner"."ref"::text not ilike ?) or "res_partner"."ref" is null)) and (("res_partner"."vat"::text not ilike ?) or "res_partner"."vat" is null)) and (("res_partner"."company_registry"::text not ilike ?) or "res_partner"."company_registry" is null)) 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)))) or "shipping_policy"."delegate_id" is null)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) limit ?) t;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 29 21 1 25m5s 25m5s -
SELECT COUNT(*) FROM ( SELECT FROM "shipping_policy" WHERE ((("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."delegate_id" in ( SELECT "res_partner".id FROM "res_partner" WHERE (((((("res_partner"."display_name"::text not ilike '%حسن علي حسن%') OR "res_partner"."display_name" IS NULL) AND (("res_partner"."email"::text not ilike '%حسن علي حسن%') OR "res_partner"."email" IS NULL)) AND (("res_partner"."ref"::text not ilike '%حسن علي حسن%') OR "res_partner"."ref" IS NULL)) AND (("res_partner"."vat"::text not ilike '%حسن علي حسن%') OR "res_partner"."vat" IS NULL)) AND (("res_partner"."company_registry"::text not ilike '%حسن علي حسن%') OR "res_partner"."company_registry" IS NULL)) 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)))) OR "shipping_policy"."delegate_id" IS NULL)) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) LIMIT 10001) t;
Date: 2024-12-29 21:22:03 Duration: 25m5s
2 0ms 6m52s 38s201ms 31 19m44s update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 29 00 1 1ms 1ms 05 2 0ms 0ms 08 1 0ms 0ms 10 1 0ms 0ms 11 11 11m52s 1m4s 12 3 4m5s 1m21s 13 4 2ms 0ms 14 1 3m46s 3m46s 18 1 0ms 0ms 19 4 2ms 0ms 21 1 1ms 1ms 22 1 1ms 1ms -
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:15:27.650578', "last_update" = '2024-12-29 10:30:27.650604', "write_date" = '2024-12-29 10:30:27.246315', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 11:37:20 Duration: 6m52s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:28:21.176228', "last_update" = '2024-12-29 10:43:21.176253', "write_date" = '2024-12-29 10:43:20.838249', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 11:48:20 Duration: 4m59s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 11:51:16.161353', "last_update" = '2024-12-29 11:06:16.161382', "write_date" = '2024-12-29 11:06:15.830621', "write_uid" = 1 WHERE id IN (867);
Date: 2024-12-29 12:10:21 Duration: 4m5s
3 0ms 14m56s 24s588ms 359 2h27m7s update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 29 00 4 2ms 0ms 01 4 0ms 0ms 02 4 2ms 0ms 03 2 1ms 0ms 04 1 2ms 2ms 06 4 0ms 0ms 07 1 0ms 0ms 08 14 5m10s 22s187ms 09 45 16m40s 22s224ms 10 28 19m17s 41s355ms 11 32 4m46s 8s967ms 12 45 21m17s 28s398ms 13 26 1m21s 3s132ms 14 32 6m56s 13s29ms 15 27 1m33s 3s456ms 16 23 6m19s 16s499ms 17 19 16m8s 50s993ms 18 14 17ms 1ms 19 18 36m11s 2m 20 5 6ms 1ms 21 8 11m21s 1m25s 22 3 0ms 0ms -
UPDATE "res_users" SET "exp_date" = '2024-12-29 19:24:23.881268', "last_update" = '2024-12-29 18:39:23.881289', "sid" = '619ecee0d4a8029fd8a0ca208718468ae48c3fa4', "write_date" = '2024-12-29 18:39:23.525215', "write_uid" = 1 WHERE id IN (1037);
Date: 2024-12-29 19:54:20 Duration: 14m56s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 19:28:40.377533', "last_update" = '2024-12-29 18:43:40.377557', "sid" = '619ecee0d4a8029fd8a0ca208718468ae48c3fa4', "write_date" = '2024-12-29 18:43:40.054276', "write_uid" = 1 WHERE id IN (1037);
Date: 2024-12-29 19:54:20 Duration: 10m40s
-
UPDATE "res_users" SET "exp_date" = '2024-12-29 16:52:29.158954', "last_update" = '2024-12-29 16:07:29.158987', "sid" = 'ebb6e4873d6b86554446efbdd9e27bdc79f1dae5', "write_date" = '2024-12-29 16:07:28.814767', "write_uid" = 1 WHERE id IN (928);
Date: 2024-12-29 17:17:20 Duration: 9m51s
4 0ms 59m59s 3s810ms 82,433 3d15h15m33s update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 29 00 1,017 228ms 0ms 01 852 189ms 0ms 02 1,211 271ms 0ms 03 996 218ms 0ms 04 1,002 218ms 0ms 05 977 214ms 0ms 06 1,003 217ms 0ms 07 644 142ms 0ms 08 1,659 1h3m12s 2s286ms 09 4,689 16h8m32s 12s393ms 10 7,018 4h2m1s 2s69ms 11 8,476 11h55m38s 5s65ms 12 8,562 10h39m53s 4s484ms 13 8,054 2h51s 900ms 14 7,292 7h49m58s 3s867ms 15 7,081 8h53m25s 4s519ms 16 6,115 6h45m30s 3s978ms 17 4,898 6h41m27s 4s917ms 18 3,908 1h1m4s 937ms 19 2,711 6h45m8s 8s966ms 20 2,191 3h28m47s 5s717ms 21 1,301 352ms 0ms 22 776 188ms 0ms -
update res_users set sid = '5ce22afcaa0c27cbbeccb0dade5f84c8c3e06b44', last_update = '2024-12-29 16:56:12.643956', exp_date = '2024-12-29 17:41:12.643958', logged_in = 'TRUE' where id = 1025;
Date: 2024-12-29 18:56:12 Duration: 59m59s
-
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036298', exp_date = '2024-12-29 18:41:24.036301', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-29 19:54:20 Duration: 57m56s
-
update res_users set sid = '92a07b323e9aa295ee76926e49ef52743b5110b8', last_update = '2024-12-29 17:56:24.036177', exp_date = '2024-12-29 18:41:24.036181', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-29 19:54:20 Duration: 57m56s
5 13ms 4s292ms 2s788ms 258 11m59s 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 #5
Day Hour Count Duration Avg duration Dec 29 00 5 15s348ms 3s69ms 09 10 31s889ms 3s188ms 10 4 13s814ms 3s453ms 11 17 16s338ms 961ms 12 11 12s352ms 1s122ms 13 19 1m4s 3s400ms 14 40 2m12s 3s320ms 15 19 37s676ms 1s982ms 16 19 1m3s 3s338ms 17 28 1m35s 3s400ms 18 18 48s395ms 2s688ms 19 30 1m41s 3s380ms 20 15 33s450ms 2s230ms 21 19 40s39ms 2s107ms 22 4 12s725ms 3s181ms -
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 (44))))))) 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 (44)))))) 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 (44)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (44)))))) 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 (44))))))))) 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 (44)))))))) AND ("policy_number"."name"::text ilike '%9442814%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:41:51 Duration: 4s292ms
-
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 (24))))))) 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 (24)))))) 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 (24)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) 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 (24))))))))) 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 (24)))))))) AND ("policy_number"."name"::text ilike '%9%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:23:06 Duration: 4s207ms
-
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 (24))))))) 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 (24)))))) 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 (24)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24)))))) 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 (24))))))))) 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 (24)))))))) AND ("policy_number"."name"::text ilike '%96%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-29 17:23:06 Duration: 3s989ms
6 213ms 1s566ms 930ms 7,719 1h59m42s 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 Dec 29 00 458 6m26s 844ms 01 159 1m37s 611ms 02 199 3m5s 932ms 03 356 1m51s 313ms 10 25 23s989ms 959ms 11 12 12s470ms 1s39ms 13 76 1m15s 988ms 14 261 4m25s 1s15ms 15 407 7m 1s32ms 16 483 7m28s 928ms 17 598 9m7s 915ms 18 1,226 19m49s 970ms 19 1,606 27m3s 1s11ms 20 978 15m45s 966ms 21 424 6m57s 985ms 22 451 7m11s 956ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9588413')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:30 Duration: 1s566ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9375488')) 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 (30))))))) 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 (30)))))) 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 (30)))))) 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 (30))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:30 Duration: 1s524ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9689979')) 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 (67))))))) 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 (67)))))) 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 (67)))))) 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 (67))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:03 Duration: 1s500ms
7 406ms 3s726ms 481ms 48,378 6h28m17s select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 29 00 277 2m11s 475ms 01 305 2m22s 466ms 02 225 1m50s 490ms 03 191 1m35s 498ms 04 145 1m13s 508ms 05 128 1m4s 503ms 06 172 1m20s 468ms 07 233 1m45s 451ms 08 1,239 9m1s 436ms 09 3,253 24m45s 456ms 10 4,198 33m59s 485ms 11 4,076 33m16s 489ms 12 4,297 36m24s 508ms 13 4,358 34m26s 474ms 14 4,244 33m15s 470ms 15 4,252 35m9s 496ms 16 3,258 25m21s 466ms 17 3,235 26m49s 497ms 18 3,066 25m2s 489ms 19 3,267 26m12s 481ms 20 2,637 21m2s 478ms 21 832 6m26s 464ms 22 490 3m42s 453ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4035558, 4034307, 4034305, 4034301, 4034291, 4034286, 4034271, 4030944, 4030869, 4027269, 4024103, 4023660, 4023149, 4022789, 4021652, 4021224, 4019630, 4018799, 4017033, 4016911, 4016602, 4016205, 4016096, 4015606, 4014894, 4014449, 4013190, 4012231, 4010382, 4004750, 3995786, 3978031, 3976098, 3721386, 3718466)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:01 Duration: 3s726ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (4000256)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:49 Duration: 3s330ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3984633)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:02 Duration: 3s292ms
8 403ms 3s78ms 471ms 253,082 1d9h8m19s 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 #8
Day Hour Count Duration Avg duration Dec 29 00 9,100 1h8m11s 449ms 01 6,443 47m2s 438ms 02 7,795 56m50s 437ms 03 10,173 1h15m6s 442ms 04 7,645 55m45s 437ms 05 6,192 45m39s 442ms 06 4,456 32m31s 438ms 07 3,315 24m35s 445ms 08 5,668 41m32s 439ms 09 11,813 1h27m44s 445ms 10 17,383 2h16m43s 471ms 11 17,718 2h19m25s 472ms 12 15,681 2h8m26s 491ms 13 14,078 1h49m23s 466ms 14 12,352 1h35m23s 463ms 15 14,885 2h1m6s 488ms 16 10,624 1h22m13s 464ms 17 15,769 2h10m29s 496ms 18 18,139 2h30m56s 499ms 19 15,341 2h8m34s 502ms 20 19,337 2h38m22s 491ms 21 5,438 42m51s 472ms 22 3,737 29m23s 471ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4011114)) AND (("shipping_track"."id" not in (32803468, 32803585, 32803922, 32912518, 32912641, 32981921, 32981921)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 3s78ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3102795)) AND (("shipping_track"."id" not in (25270502, 25271463, 32519838, 32519839, 32522286, 32522855, 32523043, 32981671, 32981671)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:03 Duration: 2s725ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (4024192)) AND (("shipping_track"."id" not in (32854639, 32855073, 32855309, 32915843, 32916003, 32916098, 32981553, 32981924, 32981924)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-29 12:29:25 Duration: 1s570ms
9 190ms 587ms 305ms 19,893 1h41m10s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true)))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))))) order by "policy_number"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 29 00 1,477 6m38s 270ms 01 593 2m38s 266ms 02 330 1m28s 269ms 03 647 2m54s 268ms 04 535 2m23s 268ms 05 1,045 4m39s 267ms 06 612 2m41s 264ms 07 571 2m28s 259ms 08 606 2m42s 267ms 09 88 27s950ms 317ms 10 247 1m12s 292ms 11 139 39s856ms 286ms 12 47 13s860ms 294ms 13 506 2m25s 288ms 14 265 1m17s 292ms 15 512 2m33s 300ms 16 741 3m32s 286ms 17 1,984 10m24s 314ms 18 1,822 10m29s 345ms 19 2,700 15m17s 339ms 20 2,638 14m43s 335ms 21 915 4m51s 318ms 22 873 4m24s 303ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9598557')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 18:20:28 Duration: 587ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9641512')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 19:23:29 Duration: 481ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9598556')) AND ("policy_number"."package_id" = 2)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true)))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL)) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))))) ORDER BY "policy_number"."id";
Date: 2024-12-29 18:20:30 Duration: 473ms
10 157ms 1s307ms 251ms 25,432 1h46m40s select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 29 08 87 18s727ms 215ms 09 1,250 4m53s 234ms 10 1,479 6m3s 245ms 11 1,469 6m2s 246ms 12 2,076 9m29s 274ms 13 1,188 4m54s 247ms 14 2,439 9m41s 238ms 15 6,826 27m46s 244ms 16 4,271 16m35s 232ms 17 2,538 12m11s 288ms 18 836 4m16s 306ms 19 332 1m27s 264ms 20 627 2m56s 281ms 21 14 4s344ms 310ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9490592')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:29:01 Duration: 1s307ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '455365')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:28:55 Duration: 838ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."type" = 'from_receiver') 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" = '9527615')))) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:28:55 Duration: 733ms
11 16ms 1s356ms 246ms 2,686 11m2s 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 #11
Day Hour Count Duration Avg duration Dec 29 00 7 1s603ms 229ms 07 4 229ms 57ms 08 65 7s630ms 117ms 09 150 25s829ms 172ms 10 285 58s214ms 204ms 11 267 1m4s 241ms 12 328 1m22s 251ms 13 285 1m11s 250ms 14 341 1m32s 272ms 15 290 1m42s 354ms 16 199 47s636ms 239ms 17 125 35s539ms 284ms 18 95 31s4ms 326ms 19 161 17s51ms 105ms 20 51 15s970ms 313ms 21 23 5s956ms 258ms 22 10 1s334ms 133ms -
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:33:04 Duration: 1s356ms
-
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:55:14 Duration: 1s282ms
-
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 (29)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29))))) 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: 2024-12-29 15:55:14 Duration: 1s273ms
12 91ms 857ms 234ms 54,533 3h32m53s select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 29 00 3,810 12m44s 200ms 01 1,488 4m46s 192ms 02 1,052 3m16s 186ms 03 1,986 7m3s 213ms 04 1,048 4m41s 268ms 05 2,064 7m53s 229ms 06 1,192 4m17s 216ms 07 1,130 4m12s 223ms 08 1,202 4m8s 206ms 09 172 46s323ms 269ms 10 526 2m12s 251ms 11 284 59s936ms 211ms 12 92 21s977ms 238ms 13 1,132 4m5s 217ms 14 1,028 4m6s 240ms 15 1,824 7m12s 237ms 16 2,413 9m33s 237ms 17 5,123 20m25s 239ms 18 6,038 25m37s 254ms 19 8,505 35m17s 249ms 20 7,179 28m11s 235ms 21 2,642 10m4s 228ms 22 2,603 10m52s 250ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'محمود')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 19:48:30 Duration: 857ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'ياسمين')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 19:48:30 Duration: 854ms
-
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'احمد')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-29 17:07:35 Duration: 844ms
13 150ms 685ms 198ms 109,150 6h53s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 29 00 1,094 3m 165ms 01 1,305 3m34s 164ms 02 2,720 7m30s 165ms 03 2,304 6m19s 164ms 04 1,910 5m16s 165ms 05 1,779 4m51s 163ms 06 3,219 8m53s 165ms 07 1,111 3m4s 166ms 08 1,661 4m35s 166ms 09 4,714 13m28s 171ms 10 5,697 17m7s 180ms 11 5,017 15m13s 182ms 12 7,749 25m8s 194ms 13 3,401 10m9s 179ms 14 6,906 20m22s 177ms 15 9,911 30m41s 185ms 16 8,284 24m19s 176ms 17 14,749 56m8s 228ms 18 12,028 46m10s 230ms 19 10,647 44m12s 249ms 20 2,067 7m40s 222ms 21 769 2m39s 207ms 22 108 22s336ms 206ms -
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" = '9492787')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 685ms
-
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" = '9492787')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 628ms
-
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" = '9412159')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 12:29:46 Duration: 525ms
14 151ms 326ms 177ms 13,039 38m29s 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 Dec 29 01 271 45s42ms 166ms 02 85 14s174ms 166ms 03 213 34s954ms 164ms 04 114 18s992ms 166ms 05 128 20s774ms 162ms 06 2,515 6m57s 166ms 07 545 1m30s 166ms 08 1,066 2m57s 166ms 09 967 2m41s 167ms 10 1,114 3m22s 181ms 11 785 2m22s 182ms 12 876 2m45s 189ms 13 593 1m45s 178ms 14 1,246 3m43s 179ms 15 1,040 3m9s 182ms 16 574 1m40s 175ms 17 329 1m8s 207ms 18 28 7s36ms 251ms 19 71 19s667ms 277ms 20 178 39s885ms 224ms 21 193 40s427ms 209ms 22 108 22s349ms 206ms -
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" = '9183564')) 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: 2024-12-29 19:23:34 Duration: 326ms
-
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" = '9574265')) 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: 2024-12-29 19:23:28 Duration: 315ms
-
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" = '9662851')) 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: 2024-12-29 19:23:25 Duration: 313ms
15 151ms 214ms 165ms 10,866 29m53s 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 Dec 29 00 1,068 2m56s 165ms 01 1,034 2m49s 164ms 02 2,376 6m33s 165ms 03 2,080 5m42s 164ms 04 1,782 4m54s 165ms 05 1,591 4m20s 163ms 06 704 1m57s 166ms 07 231 38s108ms 164ms -
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" = '9664747')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 00:45:59 Duration: 214ms
-
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" = '9543922')) 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: 2024-12-29 02:33:14 Duration: 195ms
-
SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9582197')) AND ("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112, 113, 114)))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-29 02:28:48 Duration: 191ms
16 118ms 1s277ms 145ms 6,047 14m42s select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 29 00 24 3s102ms 129ms 08 60 7s955ms 132ms 09 388 52s585ms 135ms 10 827 2m 145ms 11 1,182 2m52s 145ms 12 944 2m27s 156ms 13 662 1m34s 143ms 14 505 1m11s 141ms 15 532 1m20s 150ms 16 260 36s875ms 141ms 17 146 21s684ms 148ms 18 246 35s70ms 142ms 19 141 20s686ms 146ms 20 95 13s745ms 144ms 21 24 3s266ms 136ms 22 11 1s464ms 133ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:26 Duration: 1s277ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:02 Duration: 853ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 32)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-29 12:29:23 Duration: 767ms
17 81ms 657ms 100ms 23,616 39m32s select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 29 00 62 5s532ms 89ms 08 242 23s132ms 95ms 09 2,189 3m27s 94ms 10 2,196 3m41s 101ms 11 2,212 3m40s 99ms 12 2,485 4m17s 103ms 13 2,763 4m35s 99ms 14 2,678 4m21s 97ms 15 3,410 5m57s 104ms 16 1,024 1m41s 98ms 17 840 1m26s 102ms 18 1,028 1m45s 102ms 19 1,439 2m28s 103ms 20 547 55s537ms 101ms 21 227 21s107ms 92ms 22 274 25s145ms 91ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7893583)) AND (("cash_track"."id" not in (6281432, 6288845, 6304891, 6331587, 6331587)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 12:28:55 Duration: 657ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7897634)) AND (("cash_track"."id" not in (6307755, 6313278, 6314226, 6331583, 6331583)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 12:28:53 Duration: 311ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7871924)) AND (("cash_track"."id" not in (6116535, 6148181, 6153923, 6348579, 6348579)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-29 15:33:42 Duration: 284ms
18 38ms 115ms 48ms 45,269 36m51s select "collection_policy".id from "collection_policy" where (("collection_policy"."shipping_id" = ?) and ("collection_policy"."state" = ?)) order by "collection_policy"."id";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 29 00 37 1s693ms 45ms 02 6 285ms 47ms 06 7 335ms 47ms 07 21 949ms 45ms 08 276 12s456ms 45ms 09 2,819 2m12s 46ms 10 3,049 2m26s 48ms 11 3,038 2m29s 49ms 12 5,139 4m21s 50ms 13 3,632 2m56s 48ms 14 5,320 4m16s 48ms 15 8,072 6m43s 49ms 16 4,786 3m47s 47ms 17 5,095 4m10s 49ms 18 1,560 1m16s 49ms 19 1,031 50s406ms 48ms 20 919 43s542ms 47ms 21 377 17s24ms 45ms 22 85 3s947ms 46ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3973266) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 17:22:09 Duration: 115ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 4035646) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:51:58 Duration: 109ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3966072) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-29 15:33:04 Duration: 96ms
19 34ms 96ms 43ms 17,053 12m28s select "collection_policy".id from "collection_policy" where ("collection_policy"."shipping_id" = ?) order by "collection_policy"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 29 08 89 3s339ms 37ms 09 1,030 41s730ms 40ms 10 1,246 54s18ms 43ms 11 1,224 53s185ms 43ms 12 1,997 1m35s 48ms 13 1,074 47s248ms 43ms 14 2,082 1m30s 43ms 15 2,882 2m8s 44ms 16 2,007 1m24s 42ms 17 2,365 1m44s 44ms 18 552 24s163ms 43ms 19 234 9s992ms 42ms 20 139 5s718ms 41ms 21 132 5s468ms 41ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3874290) ORDER BY "collection_policy"."id";
Date: 2024-12-29 15:19:23 Duration: 96ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3843456) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:30:09 Duration: 79ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3821132) ORDER BY "collection_policy"."id";
Date: 2024-12-29 12:30:10 Duration: 77ms
20 29ms 219ms 40ms 149,846 1h39m54s select "shipping_policy_items".id from "shipping_policy_items" where ("shipping_policy_items"."shipping_policy_id" in (...)) order by "shipping_policy_items"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 29 00 3,814 2m22s 37ms 01 3,096 1m55s 37ms 02 2,512 1m33s 37ms 03 3,226 2m1s 37ms 04 2,052 1m16s 37ms 05 1,653 1m1s 37ms 06 2,060 1m16s 37ms 07 895 33s744ms 37ms 08 2,146 1m20s 37ms 09 8,302 5m18s 38ms 10 12,295 8m16s 40ms 11 13,041 8m48s 40ms 12 12,993 9m9s 42ms 13 11,053 7m18s 39ms 14 10,349 6m48s 39ms 15 11,551 7m55s 41ms 16 8,551 5m35s 39ms 17 8,264 5m41s 41ms 18 8,206 5m40s 41ms 19 9,578 6m32s 41ms 20 8,272 5m35s 40ms 21 3,595 2m21s 39ms 22 2,342 1m30s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (4035558)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:58 Duration: 219ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3909283)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:28:57 Duration: 191ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3523517)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-29 12:29:24 Duration: 175ms
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
- 20,411,799 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1513 FATAL entries
- 9213 ERROR entries
- 0 WARNING entries
- 1892 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,756 Max number of times the same event was reported
- 12,618 Total events found
Rank Times reported Error 1 4,756 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 29 00 11 01 22 02 9 03 6 04 3 05 8 06 15 07 11 08 57 09 152 10 337 11 517 12 710 13 544 14 591 15 608 16 452 17 354 18 164 19 61 20 41 21 65 22 18 - 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 = 'dd46f9aa25b9bdc2497a014fc741104571fca56f', last_update = '2024-12-28 23:19:12.399812',exp_date = '2024-12-29 00:04:12.399817', logged_in = 'TRUE' where id = 823
Date: 2024-12-29 00:19:12
Statement: update res_users set sid = '4704e2036bca263889d83eca69a4b2ebfc35c290', last_update = '2024-12-28 23:23:44.192525',exp_date = '2024-12-29 00:08:44.192527', logged_in = 'TRUE' where id = 1065
Date: 2024-12-29 00:23:44
Statement: update res_users set sid = '839fd3322976548947c5e50ee3118af71adcab4e', last_update = '2024-12-28 23:24:18.071130',exp_date = '2024-12-29 00:09:18.071134', logged_in = 'TRUE' where id = 869
Date: 2024-12-29 00:24:18
2 4,433 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 29 00 10 01 20 02 7 03 5 04 2 05 4 06 13 07 10 08 55 09 146 10 320 11 501 12 676 13 492 14 561 15 591 16 437 17 330 18 119 19 52 20 34 21 30 22 18 - 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 "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 (5172714, 5442116, 5150098, 5441780, 5416767, 5448166, 5364954, 5448149, 5448013, 5442111, 5447186, 5284540, 5448244, 5201301, 5226762, 5409499, 5146908, 5447189, 5137903, 5440400, 5448012, 5448011, 5157249, 5189927, 5189692, 5220025, 5243169, 5445753, 5265113, 5258892, 5202873, 5334881, 5296618, 5444762, 5444741, 5240786, 5197344, 5150343, 5445913, 5158115, 5442855, 5215957, 5245255, 5433482, 5418050, 5241814, 5193254, 5441259, 5184458, 5438924, 5164583)
Date: 2024-12-29 00:19:12
Statement: SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) AND (("shipping_policy"."last_warehouse" in (SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 112)))) OR ((((("shipping_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("shipping_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."last_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("shipping_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100
Date: 2024-12-29 00:23:44
Statement: SELECT "ir_actions"."id" AS "id", "ir_actions"."type" AS "type" FROM "ir_actions" WHERE "ir_actions".id IN (661)
Date: 2024-12-29 00:24:18
3 1,345 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 29 08 9 09 56 10 107 11 156 12 342 13 50 14 106 15 231 16 159 17 44 19 23 20 30 21 32 - LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
Statement: UPDATE "res_users" SET "exp_date" = '2024-12-29 20:58:18.366092', "last_update" = '2024-12-29 20:13:18.366114', "sid" = 'ba109d385ecc1cf69bedae1804e2ea94b9105668', "write_date" = '2024-12-29 20:13:18.043308', "write_uid" = 1041 WHERE id IN (1041)
Date: 2024-12-29 21:22:03
Statement: UPDATE "res_users" SET "exp_date" = '2024-12-29 21:03:03.392630', "last_update" = '2024-12-29 20:18:03.392650', "sid" = 'ba109d385ecc1cf69bedae1804e2ea94b9105668', "write_date" = '2024-12-29 20:18:03.061088', "write_uid" = 1041 WHERE id IN (1041)
Date: 2024-12-29 21:22:03
Statement: UPDATE "res_users" SET "exp_date" = '2024-12-29 20:52:01.633874', "last_update" = '2024-12-29 20:07:01.633899', "sid" = 'ba109d385ecc1cf69bedae1804e2ea94b9105668', "write_date" = '2024-12-29 20:07:01.289648', "write_uid" = 1 WHERE id IN (1041)
Date: 2024-12-29 21:22:03
4 1,345 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 29 08 9 09 56 10 107 11 156 12 342 13 50 14 106 15 231 16 159 17 44 19 23 20 30 21 32 5 367 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 29 08 3 09 13 10 26 11 40 12 86 13 15 14 25 15 60 16 36 17 23 18 1 19 14 20 5 21 10 22 10 6 179 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #6
Day Hour Count Dec 29 08 1 09 5 10 11 11 17 12 42 13 10 14 13 15 38 16 22 17 14 19 6 7 78 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Dec 29 17 78 - 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: 2024-12-29 17:20:01
Statement: update res_users set sid = '64909aaee62bf477c29fc30187956865336cdd99', last_update = '2024-12-29 16:18:34.439339',exp_date = '2024-12-29 17:03:34.439344', logged_in = 'TRUE' where id = 1270
Date: 2024-12-29 17:20:01
Statement: update res_users set sid = '64909aaee62bf477c29fc30187956865336cdd99', last_update = '2024-12-29 16:18:39.677552',exp_date = '2024-12-29 17:03:39.677556', logged_in = 'TRUE' where id = 1270
Date: 2024-12-29 17:20:01
8 28 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Dec 29 17 28 - 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 "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL )) ORDER BY "res_partner"."display_name" ASC,"res_partner"."id" DESC LIMIT 8
Date: 2024-12-29 17:20:01
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2024-12-29 17:20:01
Statement: SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8678391')) ORDER BY "shipping_policy"."id" DESC
Date: 2024-12-29 17:20:01
9 20 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #9
Day Hour Count Dec 29 17 20 10 20 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #10
Day Hour Count Dec 29 09 2 10 2 13 3 14 8 20 5 11 12 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #11
Day Hour Count Dec 29 09 2 11 2 14 2 15 5 17 1 - ERROR: null value in column "code" of relation "res_country_state" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
Detail: Failing row contains (4399, 65, 862, 862, 777, null, 2024-12-29 08:14:53.497652, 2024-12-29 08:14:53.497652).
Statement: INSERT INTO "res_country_state" ("country_id", "create_date", "create_uid", "name", "write_date", "write_uid") VALUES (65, '2024-12-29 08:14:53.497652', 862, '777', '2024-12-29 08:14:53.497652', 862) RETURNING "id"Date: 2024-12-29 09:14:53
Detail: Failing row contains (5456209, null, 825, 825, null, ناين ويست, null, null, t, 2024-12-29 08:15:36.925553, 2024-12-29 08:15:36.925553, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2024-12-29 08:15:36.925553', 825, 'ناين ويست', '2024-12-29 08:15:36.925553', 825) RETURNING "id"Date: 2024-12-29 09:15:36
Detail: Failing row contains (5456253, null, 827, 827, null, مد, null, null, t, 2024-12-29 10:48:55.677725, 2024-12-29 10:48:55.677725, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2024-12-29 10:48:55.677725', 827, 'مد', '2024-12-29 10:48:55.677725', 827) RETURNING "id"Date: 2024-12-29 11:48:55
12 6 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #12
Day Hour Count Dec 29 17 6 - ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
Context: parallel worker
Statement: SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND (("res_partner"."type_employee" = 'driver') AND ("res_partner"."type_driver" = 'out'))) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false ) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL )) ORDER BY "res_partner"."display_name" ASC,"res_partner"."id" DESC LIMIT 8Date: 2024-12-29 17:20:01
Context: parallel worker
Statement: SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '466134')) ORDER BY "shipping_policy"."id" DESCDate: 2024-12-29 17:20:01
Context: parallel worker
Statement: SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '8678391')) ORDER BY "shipping_policy"."id" DESCDate: 2024-12-29 17:20:01
13 6 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #13
Day Hour Count Dec 29 08 3 11 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: 2024-12-29 08:48:56
14 3 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Dec 29 18 2 19 1 - ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 163
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('9302500',)
Date: 2024-12-29 18:08:27
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 ('2468555',)
Date: 2024-12-29 19:49:08
15 3 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #15
Day Hour Count Dec 29 01 1 09 1 21 1 16 3 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #16
Day Hour Count Dec 29 01 1 09 1 21 1 17 3 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #17
Day Hour Count Dec 29 17 3 18 3 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #18
Day Hour Count Dec 29 01 1 09 1 21 1 19 2 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #19
Day Hour Count Dec 29 12 1 19 1 - ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 2509143 waits for ShareLock on transaction 4025952; blocked by process 2509101. Process 2509101 waits for ShareLock on transaction 4025895; blocked by process 2509143. Process 2509143: update shipping_policy set count_search=2 where id=3516578 Process 2509101: UPDATE "shipping_policy" SET "state_collection" = 'confirm', "write_date" = '2024-12-29 11:32:42.614251', "write_uid" = 1077 WHERE id IN (3734612, 3734600, 3731393, 3728173, 3727824, 3727822, 3727554, 3727547, 3726197, 3726192, 3725986, 3725497, 3724376, 3719464, 3718850, 3707162, 3268925, 3734605, 3734592, 3734587, 3733810, 3729863, 3728411, 3726703, 3725473, 3724404, 3722279, 3721366, 3720889, 3716679, 3714643, 3712879, 3711485, 3710730, 3710051, 3709947, 3709943, 3708935, 3707194, 3706451, 3706321, 3706314, 3702934, 3702925, 3683551, 3677585, 3737009, 3734608, 3734604, 3734599, 3734596, 3734579, 3733370, 3728618, 3727127, 3724876, 3723893, 3723333, 3722085, 3721848, 3721836, 3721422, 3719646, 3718432, 3714521, 3714515, 3713840, 3709950, 3692885, 3733827, 3731955, 3728474, 3724642, 3724219, 3721859, 3721847, 3720141, 3717518, 3716551, 3715025, 3713887, 3712627, 3711442, 3711435, 3709186, 3708488, 3708226, 3705582, 3704207, 3702919, 3678120, 3676029, 3734593, 3734586, 3726564, 3726198, 3724699, 3720151, 371
Context: while updating tuple (63547,48) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=2 where id=3516578Date: 2024-12-29 12:33:30
Detail: Process 79197 waits for ShareLock on transaction 4103568; blocked by process 79001. Process 79001 waits for ShareLock on transaction 4103546; blocked by process 79197. Process 79197: update shipping_policy set count_search=3 where id=4005820 Process 79001: UPDATE "shipping_policy" SET "collection_amount_receive" = '85', "create_cash_policy_button" = false, "return_button" = false, "total_collection_amount" = true, "write_date" = '2024-12-29 18:48:06.636535', "write_uid" = 933 WHERE id IN (4024031, 4017233, 4007512)
Context: while updating tuple (88369,2) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=3 where id=4005820Date: 2024-12-29 19:48:46
20 1 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #20
Day Hour Count Dec 29 05 1 21 1 FATAL: received unencrypted data after SSL request
Times Reported Most Frequent Error / Event #21
Day Hour Count Dec 29 00 1 - FATAL: received unencrypted data after SSL request
Detail: This could be either a client-software bug or evidence of an attempted man-in-the-middle attack.
Date: 2024-12-29 00:20:03
22 1 FATAL: unsupported frontend protocol 65107.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #22
Day Hour Count Dec 29 09 1 23 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #23
Day Hour Count Dec 29 17 1 24 1 FATAL: unsupported frontend protocol 16.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #24
Day Hour Count Dec 29 17 1 25 1 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #25
Day Hour Count Dec 29 20 1 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM "delegate_track" WHERE id IN (124684)
Date: 2024-12-29 20:00:19