pgBadger-
Global information
- Generated on Thu Dec 19 23:47:38 2024
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 47,654,087 log entries in 2m37s
- Log start from 2024-12-19 00:00:00 to 2024-12-19 22:45:01
-
Overview
Global Stats
- 21,585 Number of unique normalized queries
- 20,390,737 Number of queries
- 7d5h34m26s Total query duration
- 2024-12-19 00:00:00 First query
- 2024-12-19 22:45:01 Last query
- 7,666 queries/s at 2024-12-19 11:53:12 Query peak
- 7d5h34m26s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7d5h34m26s Execute total duration
- 11,998 Number of events
- 25 Number of unique normalized events
- 4,801 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,390,737 Average queries per session
- 7d5h34m26s 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,666 queries/s Query Peak
- 2024-12-19 11:53:12 Date
SELECT Traffic
Key values
- 4,827 queries/s Query Peak
- 2024-12-19 11:53:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1,968 queries/s Query Peak
- 2024-12-19 11:53:12 Date
Queries duration
Key values
- 7d5h34m26s 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 19 00 338,024 0ms 4s447ms 13ms 2m24s 2m49s 4m 01 302,722 0ms 1m51s 21ms 3m9s 4m1s 6m5s 02 208,890 0ms 1s602ms 16ms 2m15s 2m30s 2m56s 03 230,046 0ms 1s528ms 21ms 2m48s 4m31s 5m14s 04 253,175 0ms 1s595ms 23ms 2m58s 3m21s 5m20s 05 274,089 0ms 4s614ms 24ms 3m39s 4m7s 4m23s 06 246,539 0ms 524ms 14ms 1m46s 1m51s 2m28s 07 210,384 0ms 4s261ms 7ms 56s315ms 1m2s 1m7s 08 515,529 0ms 5m37s 47ms 3m44s 56m41s 1h58m4s 09 1,208,351 0ms 34m18s 40ms 5m 59m41s 8h30m16s 10 1,536,651 0ms 20m13s 20ms 6m29s 59m33s 2h24m58s 11 1,879,270 0ms 17m28s 21ms 11m56s 43m55s 3h17m6s 12 1,854,193 0ms 18m57s 26ms 7m3s 1h37m34s 4h54m13s 13 1,689,493 0ms 16m57s 17ms 5m35s 30m57s 3h15m2s 14 1,618,513 0ms 14m56s 18ms 5m41s 26m41s 3h45m25s 15 1,629,752 0ms 15m19s 28ms 5m30s 1h54m16s 4h50m13s 16 1,416,099 0ms 34m59s 38ms 6m23s 1h34m30s 5h22m3s 17 1,212,333 0ms 32m13s 39ms 9m2s 12m31s 7h16m4s 18 1,214,439 0ms 19m54s 39ms 11m14s 1h16m8s 3h15s 19 925,082 0ms 1m38s 26ms 12m47s 15m10s 19m52s 20 663,572 0ms 59m59s 27ms 8m20s 9m20s 1h3m52s 21 591,648 0ms 19m3s 49ms 4m59s 5m46s 5h22m33s 22 371,943 0ms 42m8s 179ms 4m3s 2h30m41s 7h48m16s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 19 00 184,865 0 24ms 1m48s 2m24s 2m53s 01 163,210 0 38ms 2m36s 3m 4m 02 102,368 0 33ms 1m40s 2m14s 2m48s 03 112,680 0 44ms 2m7s 2m48s 4m53s 04 127,633 0 47ms 2m37s 2m58s 3m26s 05 140,925 0 46ms 2m54s 3m39s 4m18s 06 127,182 0 27ms 1m26s 1m46s 2m22s 07 112,128 0 13ms 42s744ms 56s71ms 1m4s 08 316,363 0 14ms 1m49s 2m25s 3m43s 09 737,206 0 11ms 3m9s 4m24s 5m32s 10 923,292 0 13ms 4m44s 5m24s 7m13s 11 1,129,288 0 17ms 7m31s 8m17s 11m54s 12 1,119,390 0 12ms 5m14s 6m2s 7m1s 13 1,017,007 0 12ms 4m27s 5m6s 5m49s 14 951,367 0 12ms 4m36s 5m12s 5m41s 15 973,350 0 10ms 4m3s 4m42s 6m24s 16 840,291 0 14ms 4m42s 5m41s 6m6s 17 714,325 0 23ms 6m2s 7m27s 9m23s 18 731,674 0 30ms 7m45s 8m38s 11m12s 19 529,215 0 45ms 9m53s 12m45s 15m46s 20 375,220 0 38ms 5m45s 6m41s 9m19s 21 349,938 0 27ms 4m4s 4m53s 5m46s 22 218,617 0 23ms 2m45s 3m22s 4m43s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 19 00 26,565 4,756 155 0 0ms 131ms 184ms 284ms 01 30,791 6,577 142 0 6ms 179ms 244ms 590ms 02 13,845 3,945 141 0 0ms 91ms 124ms 187ms 03 18,558 5,456 143 0 0ms 119ms 162ms 316ms 04 24,154 6,297 133 0 0ms 143ms 192ms 246ms 05 27,742 7,195 139 0 0ms 165ms 209ms 331ms 06 15,797 4,179 136 0 0ms 87ms 114ms 162ms 07 6,088 2,710 228 0 0ms 41ms 59ms 79ms 08 17,894 6,864 443 0 787ms 128ms 215ms 55m29s 09 43,313 16,441 728 0 668ms 286ms 360ms 58m56s 10 65,035 22,422 838 0 209ms 412ms 502ms 57m31s 11 88,575 28,991 831 0 165ms 632ms 763ms 41m56s 12 76,026 26,073 796 0 342ms 470ms 563ms 1h34m31s 13 65,069 24,820 765 1 181ms 381ms 482ms 29m55s 14 67,446 23,366 765 1 199ms 394ms 449ms 24m35s 15 61,649 22,111 765 1 424ms 363ms 488ms 1h52m 16 58,736 22,369 696 0 506ms 437ms 30s929ms 1h32m49s 17 67,387 23,079 686 0 342ms 483ms 698ms 3m47s 18 90,431 26,696 783 2 212ms 601ms 919ms 1h11m17s 19 78,503 30,584 572 0 2ms 594ms 691ms 56s494ms 20 60,612 12,431 501 0 49ms 326ms 441ms 1s217ms 21 46,553 13,956 352 0 317ms 265ms 357ms 434ms 22 25,936 6,702 294 0 1s875ms 195ms 245ms 6h54m12s Day Hour Prepare Bind Bind/Prepare Percentage of prepare Dec 19 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 19 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 19 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
- 161,568 buffers Checkpoint Peak
- 2024-12-19 13:36:22 Date
- 270.063 seconds Highest write time
- 0.176 seconds Sync time
Checkpoints Wal files
Key values
- 67 files Wal files usage Peak
- 2024-12-19 13:36:22 Date
Checkpoints distance
Key values
- 2,154.98 Mo Distance Peak
- 2024-12-19 13:36:22 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Dec 19 00 158,497 3,239.615s 0.041s 3,239.701s 01 153,618 3,239.578s 0.036s 3,239.66s 02 98,601 3,239.498s 0.027s 3,239.574s 03 139,986 3,239.589s 0.037s 3,239.68s 04 173,414 3,239.621s 0.037s 3,239.707s 05 170,447 3,239.53s 0.035s 3,239.629s 06 108,152 3,202.572s 0.031s 3,202.645s 07 85,152 3,084.447s 0.028s 3,084.509s 08 125,573 3,222.606s 0.058s 3,222.706s 09 352,158 3,239.54s 0.052s 3,239.661s 10 462,099 3,239.446s 0.056s 3,239.576s 11 632,156 3,239.496s 0.069s 3,239.659s 12 544,665 3,239.581s 0.042s 3,239.706s 13 705,926 3,239.291s 0.226s 3,239.62s 14 456,067 3,239.486s 0.047s 3,239.609s 15 488,125 3,239.565s 0.065s 3,239.707s 16 392,820 3,239.511s 0.068s 3,239.657s 17 338,206 2,889.437s 0.066s 2,889.577s 18 357,237 3,239.473s 0.049s 3,239.599s 19 338,969 3,239.541s 0.051s 3,239.664s 20 358,282 3,239.571s 0.047s 3,239.69s 21 243,821 3,239.529s 0.053s 3,239.634s 22 136,099 2,429.603s 0.038s 2,429.68s Day Hour Added Removed Recycled Synced files Longest sync Average sync Dec 19 00 0 0 66 3,838 0.002s 0.012s 01 0 0 67 3,487 0.002s 0.012s 02 0 0 42 2,381 0.002s 0.012s 03 0 0 59 2,347 0.002s 0.012s 04 0 0 74 2,495 0.002s 0.012s 05 0 0 76 2,710 0.003s 0.012s 06 0 0 46 2,402 0.002s 0.012s 07 0 0 35 2,769 0.002s 0.012s 08 0 0 50 3,615 0.015s 0.012s 09 0 0 146 4,944 0.003s 0.012s 10 0 0 193 5,131 0.005s 0.012s 11 0 0 272 5,241 0.003s 0.012s 12 0 0 237 5,326 0.003s 0.012s 13 0 0 305 5,464 0.010s 0.012s 14 0 0 183 5,383 0.003s 0.012s 15 0 0 196 5,569 0.002s 0.012s 16 0 0 159 5,813 0.003s 0.012s 17 0 0 140 5,346 0.009s 0.012s 18 0 0 155 5,370 0.002s 0.012s 19 0 0 146 5,027 0.002s 0.012s 20 0 0 153 4,792 0.003s 0.012s 21 0 0 107 4,740 0.003s 0.012s 22 0 0 59 3,630 0.002s 0.009s Day Hour Count Avg time (sec) Dec 19 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 19 00 89,418.83 kB 154,921.08 kB 01 91,328.00 kB 127,359.00 kB 02 57,930.17 kB 100,576.75 kB 03 80,663.42 kB 116,772.08 kB 04 101,352.33 kB 125,008.75 kB 05 103,258.92 kB 151,823.17 kB 06 63,002.42 kB 110,965.42 kB 07 46,929.42 kB 82,795.33 kB 08 68,853.92 kB 83,536.42 kB 09 190,761.33 kB 215,999.11 kB 10 269,420.00 kB 312,302.18 kB 11 376,063.90 kB 423,416.30 kB 12 322,159.50 kB 406,735.40 kB 13 416,331.17 kB 638,279.33 kB 14 250,427.00 kB 578,804.67 kB 15 267,640.17 kB 360,696.92 kB 16 217,157.58 kB 268,080.25 kB 17 191,563.33 kB 251,678.83 kB 18 220,669.73 kB 243,456.36 kB 19 198,826.50 kB 265,701.25 kB 20 209,228.92 kB 280,139.08 kB 21 146,469.83 kB 247,995.83 kB 22 107,722.00 kB 165,264.33 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 19 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 19 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 - 0 sec Highest CPU-cost vacuum
-
Locks
Locks by types
Key values
- unknown Main Lock Type
- 0 locks Total
Most frequent waiting queries (N)
Rank Count Total time Min time Max time Avg duration Query NO DATASET
Queries that waited the most
Rank Wait time Query NO DATASET
-
Queries
Queries by type
Key values
- 11,997,534 Total read queries
- 5,687,966 Total write queries
Queries by database
Key values
- unknown Main database
- 20,390,737 Requests
- 7d5h34m26s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 20,390,737 Requests
User Request type Count Duration unknown Total 20,390,737 7d5h34m26s copy from 5 12ms cte 30,611 6s517ms ddl 2,752 379ms delete 11,032 22s800ms insert 1,076,705 5m30s others 2,705,237 2m4s select 11,997,534 2d17h57m tcl 4,218,841 2m52s update 348,020 4d11h26m28s Duration by user
Key values
- 7d5h34m26s (unknown) Main time consuming user
User Request type Count Duration unknown Total 20,390,737 7d5h34m26s copy from 5 12ms cte 30,611 6s517ms ddl 2,752 379ms delete 11,032 22s800ms insert 1,076,705 5m30s others 2,705,237 2m4s select 11,997,534 2d17h57m tcl 4,218,841 2m52s update 348,020 4d11h26m28s Queries by host
Key values
- unknown Main host
- 20,390,737 Requests
- 7d5h34m26s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 20,390,737 Requests
- 7d5h34m26s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-12-19 10:40:02 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 19,092,446 0-1ms duration
Slowest individual queries
Rank Duration Query 1 59m59s update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-19 18:42:34.756946', exp_date = '2024-12-19 19:27:34.756949', logged_in = 'TRUE' where id = 1037;[ Date: 2024-12-19 20:42:34 ]
2 42m8s update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861630', exp_date = '2024-12-19 21:02:54.861633', logged_in = 'TRUE' where id = 1076;[ Date: 2024-12-19 22:00:03 ]
3 42m8s update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861518', exp_date = '2024-12-19 21:02:54.861522', logged_in = 'TRUE' where id = 1076;[ Date: 2024-12-19 22:00:03 ]
4 34m59s update res_users set sid = '83d136a99363f129920fa68a50c96a82233986d1', last_update = '2024-12-19 14:37:22.062865', exp_date = '2024-12-19 15:22:22.062868', logged_in = 'TRUE' where id = 951;[ Date: 2024-12-19 16:12:21 ]
5 34m58s update res_users set sid = '83d136a99363f129920fa68a50c96a82233986d1', last_update = '2024-12-19 14:37:23.194615', exp_date = '2024-12-19 15:22:23.194617', logged_in = 'TRUE' where id = 951;[ Date: 2024-12-19 16:12:21 ]
6 34m57s update res_users set sid = 'd51a7c8dae23220e6bb1a9279f089c7c2de5de6e', last_update = '2024-12-19 14:37:24.187757', exp_date = '2024-12-19 15:22:24.187760', logged_in = 'TRUE' where id = 1315;[ Date: 2024-12-19 16:12:21 ]
7 34m18s update res_users set sid = '5bcc9f20323f0bd43e9b0802e13c04330334ce7b', last_update = '2024-12-19 08:20:02.246751', exp_date = '2024-12-19 09:05:02.246759', logged_in = 'TRUE' where id = 1103;[ Date: 2024-12-19 09:54:20 ]
8 34m18s update res_users set sid = '5bcc9f20323f0bd43e9b0802e13c04330334ce7b', last_update = '2024-12-19 08:20:02.242835', exp_date = '2024-12-19 09:05:02.242838', logged_in = 'TRUE' where id = 1103;[ Date: 2024-12-19 09:54:20 ]
9 34m2s update res_users set sid = 'a30d4389d73d6ce447ffc4842e6dae39308d2562', last_update = '2024-12-19 08:20:18.053089', exp_date = '2024-12-19 09:05:18.053091', logged_in = 'TRUE' where id = 1103;[ Date: 2024-12-19 09:54:20 ]
10 33m57s UPDATE "res_users" SET "exp_date" = '2024-12-19 09:05:22.453434', "last_update" = '2024-12-19 08:20:22.453456', "write_date" = '2024-12-19 08:20:22.124016', "write_uid" = 1 WHERE id IN (959);[ Date: 2024-12-19 09:54:20 ]
11 33m55s update res_users set sid = 'a30d4389d73d6ce447ffc4842e6dae39308d2562', last_update = '2024-12-19 08:20:24.578276', exp_date = '2024-12-19 09:05:24.578280', logged_in = 'TRUE' where id = 1103;[ Date: 2024-12-19 09:54:20 ]
12 33m35s update res_users set sid = '5bcc9f20323f0bd43e9b0802e13c04330334ce7b', last_update = '2024-12-19 08:20:45.117852', exp_date = '2024-12-19 09:05:45.117855', logged_in = 'TRUE' where id = 1103;[ Date: 2024-12-19 09:54:20 ]
13 32m53s update res_users set sid = '83d136a99363f129920fa68a50c96a82233986d1', last_update = '2024-12-19 14:39:28.107719', exp_date = '2024-12-19 15:24:28.107722', logged_in = 'TRUE' where id = 951;[ Date: 2024-12-19 16:12:21 ]
14 32m13s update res_users set sid = '671e3d39efaee5a2b0ba7c843a1c0281c78828cc', last_update = '2024-12-19 16:22:07.424967', exp_date = '2024-12-19 17:07:07.424970', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
15 32m13s update res_users set sid = '671e3d39efaee5a2b0ba7c843a1c0281c78828cc', last_update = '2024-12-19 16:22:07.424845', exp_date = '2024-12-19 17:07:07.424848', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
16 32m12s update res_users set sid = '671e3d39efaee5a2b0ba7c843a1c0281c78828cc', last_update = '2024-12-19 16:22:08.909447', exp_date = '2024-12-19 17:07:08.909449', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
17 32m11s update res_users set sid = '83d136a99363f129920fa68a50c96a82233986d1', last_update = '2024-12-19 14:40:09.630507', exp_date = '2024-12-19 15:25:09.630512', logged_in = 'TRUE' where id = 951;[ Date: 2024-12-19 16:12:21 ]
18 32m update res_users set sid = '2594d0ea9939464c3cec23bd642c98beacf4e03f', last_update = '2024-12-19 16:22:20.509272', exp_date = '2024-12-19 17:07:20.509276', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
19 31m55s update res_users set sid = '2594d0ea9939464c3cec23bd642c98beacf4e03f', last_update = '2024-12-19 16:22:25.634232', exp_date = '2024-12-19 17:07:25.634236', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
20 31m41s update res_users set sid = '2594d0ea9939464c3cec23bd642c98beacf4e03f', last_update = '2024-12-19 16:22:38.950486', exp_date = '2024-12-19 17:07:38.950490', logged_in = 'TRUE' where id = 1049;[ Date: 2024-12-19 17:54:20 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4d9h31m51s 84,351 0ms 59m59s 4s503ms 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 19 00 871 189ms 0ms 01 736 173ms 0ms 02 637 135ms 0ms 03 791 172ms 0ms 04 794 176ms 0ms 05 775 170ms 0ms 06 752 161ms 0ms 07 594 125ms 0ms 08 1,804 5h26m3s 10s844ms 09 5,635 10h37m27s 6s787ms 10 6,689 5h2m44s 2s715ms 11 9,098 5h25m19s 2s145ms 12 9,121 9h29m14s 3s744ms 13 8,408 4h31m44s 1s939ms 14 8,116 5h1m12s 2s226ms 15 6,755 9h36m21s 5s119ms 16 6,012 11h26m3s 6s846ms 17 4,861 8h39m17s 6s409ms 18 4,292 6h56m42s 5s825ms 19 2,791 3m24s 73ms 20 1,912 1h37s 1s902ms 21 1,755 5h6m19s 10s472ms 22 1,152 17h9m16s 53s608ms -
update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-19 18:42:34.756946', exp_date = '2024-12-19 19:27:34.756949', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-19 20:42:34 Duration: 59m59s
-
update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861630', exp_date = '2024-12-19 21:02:54.861633', logged_in = 'TRUE' where id = 1076;
Date: 2024-12-19 22:00:03 Duration: 42m8s
-
update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861518', exp_date = '2024-12-19 21:02:54.861522', logged_in = 'TRUE' where id = 1076;
Date: 2024-12-19 22:00:03 Duration: 42m8s
2 1d7h59m41s 262,100 365ms 3s419ms 439ms 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 19 00 6,040 40m59s 407ms 01 8,679 1h1s 414ms 02 5,233 34m43s 398ms 03 8,485 56m37s 400ms 04 9,870 1h5m44s 399ms 05 9,405 1h3m49s 407ms 06 5,672 37m23s 395ms 07 2,153 14m1s 390ms 08 5,746 37m53s 395ms 09 10,049 1h8m15s 407ms 10 14,425 1h42m15s 425ms 11 20,326 2h39m9s 469ms 12 15,520 1h51m9s 429ms 13 12,913 1h31m41s 426ms 14 11,961 1h25m26s 428ms 15 10,648 1h14m36s 420ms 16 11,649 1h22m58s 427ms 17 17,394 2h13m14s 459ms 18 21,027 2h52m3s 490ms 19 17,655 2h26m53s 499ms 20 20,498 2h36m21s 457ms 21 10,869 1h21m32s 450ms 22 5,883 42m49s 436ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3711468)) AND (("shipping_track"."id" not in (30294845, 30295308, 30295622, 30333920, 30418597, 30418653, 30442569, 30442726, 30443011, 30487649, 30487649)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:46 Duration: 3s419ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3689091)) AND (("shipping_track"."id" not in (30064231, 30065425, 30066872, 30421835, 30422046, 30422237, 30601941, 30601941)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:02 Duration: 3s361ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3749546)) AND (("shipping_track"."id" not in (30601963, 30601963)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:01 Duration: 3s313ms
3 8h8m48s 133,787 170ms 1s624ms 219ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 19 00 805 2m30s 186ms 01 1,281 4m 188ms 02 1,700 5m18s 187ms 03 2,782 8m45s 188ms 04 3,363 10m36s 189ms 05 3,224 10m17s 191ms 06 2,085 6m29s 187ms 07 728 2m15s 186ms 08 3,073 9m38s 188ms 09 4,953 16m13s 196ms 10 9,202 31m1s 202ms 11 11,351 41m30s 219ms 12 4,107 14m1s 204ms 13 7,508 25m12s 201ms 14 5,728 19m11s 200ms 15 5,701 19m3s 200ms 16 10,133 34m9s 202ms 17 10,372 37m58s 219ms 18 10,571 39m56s 226ms 19 34,095 2h27m4s 258ms 20 746 2m35s 207ms 21 105 22s86ms 210ms 22 174 35s70ms 201ms -
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" = '9435546')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:15:05 Duration: 1s624ms
-
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" = '9379871')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:15:18 Duration: 1s619ms
-
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" = '9169980')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 11:27:09 Duration: 1s610ms
4 5h43m41s 46,111 371ms 4s913ms 447ms select "shipping_track".id from "shipping_track" where ("shipping_track"."shipping_id" in (...)) order by "shipping_track"."id";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 19 00 252 1m48s 431ms 01 281 1m59s 425ms 02 104 47s580ms 457ms 03 182 1m21s 447ms 04 180 1m22s 457ms 05 208 1m35s 460ms 06 232 1m39s 431ms 07 566 3m44s 397ms 08 1,427 9m39s 406ms 09 3,355 23m21s 417ms 10 3,513 25m38s 438ms 11 4,346 35m26s 489ms 12 3,989 29m36s 445ms 13 4,172 30m12s 434ms 14 3,997 28m55s 434ms 15 3,126 22m16s 427ms 16 3,145 22m36s 431ms 17 3,118 24m 462ms 18 3,666 29m27s 482ms 19 2,227 18m36s 501ms 20 1,895 14m11s 449ms 21 1,299 9m23s 434ms 22 831 5m58s 431ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3689091, 3716989, 3720980, 3721248, 3727320, 3727855, 3729415, 3729489)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:14:59 Duration: 4s913ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3736783, 3736750, 3736723, 3736702, 3736680, 3736675)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:47 Duration: 3s544ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3706567, 3706568)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:49 Duration: 3s393ms
5 3h55m13s 59,332 92ms 903ms 237ms select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 19 00 2,435 7m49s 192ms 01 4,704 15m30s 197ms 02 1,039 3m34s 206ms 03 847 3m 213ms 04 1,464 5m29s 225ms 05 3,134 12m25s 237ms 06 582 2m16s 234ms 07 74 16s671ms 225ms 08 26 5s687ms 218ms 09 76 18s192ms 239ms 10 478 1m40s 210ms 11 606 2m29s 246ms 12 102 26s503ms 259ms 13 588 2m14s 228ms 14 1,358 5m20s 235ms 15 1,078 4m25s 246ms 16 2,919 12m17s 252ms 17 5,450 23m35s 259ms 18 10,114 44m48s 265ms 19 6,472 27m9s 251ms 20 5,910 22m22s 227ms 21 6,938 24m55s 215ms 22 2,938 12m41s 259ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'جمال')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-19 17:24:06 Duration: 903ms
-
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-19 17:24:06 Duration: 901ms
-
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-19 19:11:03 Duration: 881ms
6 2h48m11s 10,104 250ms 1s910ms 998ms 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 19 00 705 11m5s 944ms 01 449 7m6s 950ms 02 286 4m30s 946ms 03 9 8s599ms 955ms 09 2 1s946ms 973ms 10 32 32s144ms 1s4ms 11 71 1m21s 1s151ms 12 6 6s559ms 1s93ms 13 53 53s226ms 1s4ms 14 236 3m58s 1s11ms 15 253 4m13s 1s2ms 16 469 7m40s 981ms 17 1,037 17m54s 1s36ms 18 1,184 20m35s 1s43ms 19 1,730 29m53s 1s36ms 20 1,481 25m 1s12ms 21 1,361 21m17s 938ms 22 740 11m49s 958ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9526064')) 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 (51))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:44:38 Duration: 1s910ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9547154')) 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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:15:41 Duration: 1s848ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9547158')) 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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:16:04 Duration: 1s812ms
7 1h43m47s 20,041 219ms 2s45ms 310ms 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 #7
Day Hour Count Duration Avg duration Dec 19 00 535 2m28s 278ms 01 1,945 9m6s 281ms 02 244 1m7s 278ms 03 415 1m57s 283ms 04 741 3m27s 279ms 05 1,586 7m30s 284ms 06 295 1m22s 279ms 07 39 10s418ms 267ms 08 15 4s236ms 282ms 09 43 12s175ms 283ms 10 212 1m6s 312ms 11 251 1m21s 326ms 12 54 15s836ms 293ms 13 244 1m16s 312ms 14 460 2m19s 302ms 15 305 1m33s 306ms 16 1,032 5m10s 301ms 17 1,737 9m25s 325ms 18 3,926 22m21s 341ms 19 1,530 8m59s 352ms 20 1,506 7m55s 316ms 21 2,178 10m54s 300ms 22 748 3m37s 290ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9351639')) 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-19 19:15:39 Duration: 2s45ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9511508')) 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-19 19:15:56 Duration: 1s947ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9432177')) 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-19 19:16:02 Duration: 1s873ms
8 1h42m49s 152,665 30ms 242ms 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 #8
Day Hour Count Duration Avg duration Dec 19 00 2,807 1m45s 37ms 01 3,366 2m7s 37ms 02 1,535 57s452ms 37ms 03 1,900 1m12s 38ms 04 3,118 1m58s 37ms 05 3,009 1m55s 38ms 06 2,339 1m28s 38ms 07 902 33s614ms 37ms 08 3,195 2m2s 38ms 09 7,262 4m45s 39ms 10 10,851 7m17s 40ms 11 15,689 11m33s 44ms 12 12,750 8m37s 40ms 13 10,858 7m17s 40ms 14 9,533 6m21s 40ms 15 8,766 5m47s 39ms 16 8,134 5m23s 39ms 17 10,246 6m55s 40ms 18 12,360 8m37s 41ms 19 8,346 6m2s 43ms 20 6,086 3m59s 39ms 21 5,848 3m45s 38ms 22 3,765 2m24s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3636844, 3000150)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:59 Duration: 242ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3701074, 3651694, 3636225)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:41 Duration: 223ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3711422)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:46 Duration: 218ms
9 1h42m19s 23,358 177ms 938ms 262ms select "collection_policy".id from "collection_policy" where (("collection_policy"."type" = ?) and ("collection_policy"."shipping_id" in ( select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where ("shipping_policy__policy_id"."name" = ?)))) order by "collection_policy"."id";Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 19 08 855 3m18s 232ms 09 862 3m39s 254ms 10 2,638 11m21s 258ms 11 4,993 22m49s 274ms 12 1,418 6m10s 261ms 13 2,884 12m8s 252ms 14 1,450 6m26s 266ms 15 2,055 8m46s 256ms 16 2,953 12m12s 248ms 17 1,144 5m20s 279ms 18 1,419 6m44s 285ms 19 687 3m21s 293ms -
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" = '9386518')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:38 Duration: 938ms
-
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" = '471418')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 19:16:05 Duration: 884ms
-
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" = '9320660')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 19:16:04 Duration: 835ms
10 1h6m25s 403 0ms 15m43s 9s890ms update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 19 00 5 2ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 04 1 0ms 0ms 05 3 1ms 0ms 06 6 1ms 0ms 07 4 0ms 0ms 08 17 4m29s 15s864ms 09 42 1m23s 1s999ms 10 44 4m39s 6s341ms 11 44 49ms 1ms 12 38 15m9s 23s924ms 13 35 55s986ms 1s599ms 14 24 3m21s 8s382ms 15 38 20m42s 32s700ms 16 18 20ms 1ms 17 15 16ms 1ms 18 25 31ms 1ms 19 15 11ms 0ms 20 8 3ms 0ms 21 10 15m43s 1m34s 22 5 4ms 0ms -
UPDATE "res_users" SET "exp_date" = '2024-12-19 20:44:36.801447', "last_update" = '2024-12-19 19:59:36.801471', "sid" = '0808a382f8bec08db0ff2770b5aa991f82f1c38e', "write_date" = '2024-12-19 19:59:36.377449', "write_uid" = 1 WHERE id IN (857);
Date: 2024-12-19 21:15:20 Duration: 15m43s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 14:49:45.434906', "last_update" = '2024-12-19 14:04:45.434925', "sid" = '2c4d8cf313bf70533867357f752d391f5b6e4758', "write_date" = '2024-12-19 14:04:45.084747', "write_uid" = 1 WHERE id IN (837);
Date: 2024-12-19 15:12:21 Duration: 7m35s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 11:53:30.648531', "last_update" = '2024-12-19 11:08:30.648556', "sid" = '1786866e18a16fdd31dd3b5e8ce7ed95129115db', "write_date" = '2024-12-19 11:08:30.312010', "write_uid" = 1 WHERE id IN (909);
Date: 2024-12-19 12:14:21 Duration: 5m50s
11 46m31s 14,032 173ms 367ms 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" = ?)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) or ((((("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))) or ("shipping_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 19 00 126 23s621ms 187ms 01 72 13s500ms 187ms 02 68 12s747ms 187ms 03 477 1m29s 187ms 04 805 2m32s 189ms 05 196 37s768ms 192ms 06 854 2m40s 187ms 07 274 51s213ms 186ms 08 1,228 3m51s 188ms 09 1,252 4m8s 198ms 10 1,141 3m52s 203ms 11 1,108 4m 216ms 12 1,029 3m28s 202ms 13 893 3m1s 203ms 14 1,387 4m36s 199ms 15 1,122 3m38s 195ms 16 612 2m 196ms 17 522 1m47s 206ms 18 335 1m12s 217ms 19 84 19s278ms 229ms 20 306 1m4s 209ms 21 90 19s53ms 211ms 22 51 10s444ms 204ms -
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" = '9483770')) 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 (66)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) 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-19 19:14:36 Duration: 367ms
-
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" = '9488282')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:27:25 Duration: 307ms
-
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" = '9307192')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:27:24 Duration: 298ms
12 38m37s 12,272 170ms 243ms 188ms select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) and ("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."id" in (...)))) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 19 00 618 1m55s 186ms 01 1,208 3m47s 188ms 02 1,610 5m1s 187ms 03 2,281 7m10s 188ms 04 2,411 7m36s 189ms 05 2,494 7m57s 191ms 06 1,092 3m23s 186ms 07 435 1m21s 186ms 22 123 24s735ms 201ms -
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" = '9504904')) 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-19 05:24:35 Duration: 243ms
-
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" = '9050657')) 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-19 05:24:35 Duration: 241ms
-
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" = '9389363')) 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-19 04:39:30 Duration: 233ms
13 37m57s 49,878 35ms 273ms 45ms 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 19 01 5 224ms 44ms 06 13 549ms 42ms 07 78 3s331ms 42ms 08 2,008 1m24s 42ms 09 2,224 1m37s 43ms 10 4,266 3m10s 44ms 11 7,988 6m28s 48ms 12 3,487 2m40s 45ms 13 5,950 4m27s 44ms 14 3,103 2m18s 44ms 15 3,511 2m37s 44ms 16 4,478 3m20s 44ms 17 7,211 5m27s 45ms 18 3,025 2m19s 46ms 19 1,814 1m30s 50ms 20 248 11s16ms 44ms 21 322 13s963ms 43ms 22 147 6s431ms 43ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3607736) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:39 Duration: 273ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3606972) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:55 Duration: 265ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3599709) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:57 Duration: 265ms
14 34m39s 22,198 76ms 394ms 93ms select "cash_track".id from "cash_track" where (("cash_track"."cash_policy_id" in (...)) and (("cash_track"."id" not in (...)) or "cash_track"."id" is null)) order by "cash_track"."id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 19 00 31 2s651ms 85ms 07 92 8s398ms 91ms 08 304 27s874ms 91ms 09 1,197 1m50s 92ms 10 1,919 2m58s 93ms 11 2,042 3m23s 99ms 12 3,297 5m7s 93ms 13 2,952 4m32s 92ms 14 2,502 3m48s 91ms 15 2,468 3m43s 90ms 16 1,196 1m51s 93ms 17 1,153 1m50s 96ms 18 1,079 1m48s 100ms 19 455 45s515ms 100ms 20 707 1m7s 95ms 21 371 33s717ms 90ms 22 433 38s381ms 88ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7799849)) AND (("cash_track"."id" not in (5575166, 5581104, 5602437, 5926673, 5926677, 5926677)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:40 Duration: 394ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7847068)) AND (("cash_track"."id" not in (5926681)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:47 Duration: 354ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7847069)) AND (("cash_track"."id" not in (5926706)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:48 Duration: 308ms
15 34m19s 49 0ms 33m57s 42s40ms update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 19 01 2 0ms 0ms 04 1 0ms 0ms 08 3 4ms 1ms 09 4 34m19s 8m34s 10 8 14ms 1ms 11 7 7ms 1ms 12 6 8ms 1ms 13 1 1ms 1ms 14 2 1ms 0ms 15 3 0ms 0ms 16 2 1ms 0ms 17 2 1ms 0ms 19 3 3ms 1ms 20 3 0ms 0ms 21 2 3ms 1ms -
UPDATE "res_users" SET "exp_date" = '2024-12-19 09:05:22.453434', "last_update" = '2024-12-19 08:20:22.453456', "write_date" = '2024-12-19 08:20:22.124016', "write_uid" = 1 WHERE id IN (959);
Date: 2024-12-19 09:54:20 Duration: 33m57s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 09:03:58.585604', "last_update" = '2024-12-19 08:18:58.585620', "write_date" = '2024-12-19 08:18:58.267000', "write_uid" = 1 WHERE id IN (959);
Date: 2024-12-19 09:19:20 Duration: 22s48ms
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 19:35:28.117132', "last_update" = '2024-12-19 18:50:28.117155', "write_date" = '2024-12-19 18:50:27.719301', "write_uid" = 1 WHERE id IN (909);
Date: 2024-12-19 19:50:28 Duration: 3ms
16 29m17s 3,893 336ms 676ms 451ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 19 09 289 1m59s 411ms 11 1,197 8m57s 449ms 12 2,024 15m32s 460ms 16 27 12s983ms 480ms 18 4 1s781ms 445ms 19 151 1m10s 466ms 21 201 1m23s 414ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9194043')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:10 Duration: 676ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266619')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:10 Duration: 676ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266625')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:15 Duration: 676ms
17 16m58s 305 450ms 4s498ms 3s338ms 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 #17
Day Hour Count Duration Avg duration Dec 19 07 6 4s455ms 742ms 08 6 19s403ms 3s233ms 09 30 1m33s 3s103ms 10 1 3s173ms 3s173ms 11 11 38s927ms 3s538ms 12 8 29s171ms 3s646ms 13 18 1m3s 3s516ms 14 17 1m 3s552ms 15 22 1m7s 3s68ms 16 22 1m12s 3s303ms 17 32 1m49s 3s432ms 18 52 3m8s 3s628ms 19 30 1m45s 3s500ms 20 18 59s907ms 3s328ms 21 16 52s264ms 3s266ms 22 16 50s539ms 3s158ms -
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 (68))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))))) AND ("policy_number"."name"::text ilike '%8432882%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 18:08:12 Duration: 4s498ms
-
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 (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))))) AND ("policy_number"."name"::text ilike '%9058545%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 19:30:18 Duration: 4s476ms
-
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 (10))))))) 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 (10)))))) 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 (10)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10)))))) 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 (10))))))))) 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 (10)))))))) AND ("policy_number"."name"::text ilike '%9096427%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 18:06:48 Duration: 4s448ms
18 14m48s 6,085 120ms 1s170ms 146ms select "res_partner".id from "res_partner" where (("res_partner"."active" = true) and ("res_partner"."office_id" = ?)) and ((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or (("res_partner"."company_id" in (...)) or "res_partner"."company_id" is null)) and ((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null)) order by "res_partner"."display_name" asc, "res_partner"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 19 00 67 8s768ms 130ms 01 10 1s325ms 132ms 06 1 130ms 130ms 07 20 2s669ms 133ms 08 85 11s446ms 134ms 09 367 51s36ms 139ms 10 667 1m36s 144ms 11 1,308 3m29s 160ms 12 945 2m16s 144ms 13 522 1m15s 144ms 14 456 1m4s 140ms 15 406 56s883ms 140ms 16 252 35s552ms 141ms 17 199 29s732ms 149ms 18 176 26s90ms 148ms 19 126 18s832ms 149ms 20 24 3s448ms 143ms 21 292 40s442ms 138ms 22 162 21s14ms 129ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 66)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-19 11:26:51 Duration: 1s170ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-19 11:26:45 Duration: 1s27ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) 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-19 11:26:38 Duration: 908ms
19 13m16s 19,352 31ms 196ms 41ms 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 19 08 768 29s724ms 38ms 09 864 34s589ms 40ms 10 2,444 1m37s 40ms 11 3,111 2m17s 44ms 12 1,118 46s100ms 41ms 13 2,310 1m32s 40ms 14 1,537 1m2s 40ms 15 1,541 1m 39ms 16 1,912 1m17s 40ms 17 1,942 1m21s 42ms 18 1,153 47s609ms 41ms 19 652 27s646ms 42ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3600214) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:43 Duration: 196ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3551832) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:56 Duration: 186ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3538553) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:56 Duration: 124ms
20 13m4s 3,890 175ms 307ms 201ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 19 09 289 55s317ms 191ms 11 1,197 3m59s 200ms 12 2,025 6m49s 202ms 16 27 5s631ms 208ms 19 151 33s299ms 220ms 21 201 40s976ms 203ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '7960681')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:16:06 Duration: 307ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9194043')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:09 Duration: 283ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266619')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112, 12)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112, 12))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:09 Duration: 280ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,703,578 2m4s 0ms 14ms 0ms discard all;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 19 00 49,954 2s272ms 0ms 01 42,642 2s9ms 0ms 02 36,816 1s630ms 0ms 03 37,874 1s832ms 0ms 04 38,347 1s936ms 0ms 05 39,230 1s984ms 0ms 06 39,156 1s944ms 0ms 07 35,544 1s566ms 0ms 08 66,312 2s793ms 0ms 09 155,198 6s762ms 0ms 10 199,664 9s464ms 0ms 11 238,882 11s781ms 0ms 12 240,324 10s990ms 0ms 13 224,419 10s231ms 0ms 14 222,421 10s550ms 0ms 15 220,975 9s575ms 0ms 16 194,941 8s263ms 0ms 17 158,695 7s727ms 0ms 18 142,667 6s416ms 0ms 19 113,869 5s865ms 0ms 20 86,215 4s193ms 0ms 21 71,677 3s77ms 0ms 22 47,756 1s786ms 0ms -
DISCARD ALL;
Date: 2024-12-19 11:52:12 Duration: 14ms
-
DISCARD ALL;
Date: 2024-12-19 19:30:29 Duration: 1ms
-
DISCARD ALL;
Date: 2024-12-19 20:48:01 Duration: 1ms
2 2,110,073 30s22ms 0ms 15ms 0ms begin isolation level repeatable read;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 19 00 35,640 548ms 0ms 01 29,553 486ms 0ms 02 25,863 402ms 0ms 03 27,656 448ms 0ms 04 28,291 475ms 0ms 05 29,423 489ms 0ms 06 30,029 472ms 0ms 07 26,806 383ms 0ms 08 53,040 735ms 0ms 09 126,354 1s689ms 0ms 10 161,126 2s351ms 0ms 11 194,630 2s945ms 0ms 12 194,004 2s700ms 0ms 13 177,218 2s466ms 0ms 14 175,552 2s478ms 0ms 15 174,171 2s265ms 0ms 16 148,010 1s974ms 0ms 17 123,164 1s731ms 0ms 18 109,898 1s509ms 0ms 19 85,857 1s375ms 0ms 20 64,138 934ms 0ms 21 53,909 716ms 0ms 22 35,741 440ms 0ms -
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-19 09:30:51 Duration: 15ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-19 11:52:12 Duration: 14ms
-
BEGIN ISOLATION LEVEL REPEATABLE READ;
Date: 2024-12-19 11:34:32 Duration: 1ms
3 1,376,983 13s606ms 0ms 13ms 0ms rollback;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 19 00 25,658 241ms 0ms 01 22,098 222ms 0ms 02 19,046 178ms 0ms 03 19,502 189ms 0ms 04 19,820 201ms 0ms 05 20,278 207ms 0ms 06 20,263 200ms 0ms 07 18,425 164ms 0ms 08 34,221 319ms 0ms 09 79,002 757ms 0ms 10 101,362 1s28ms 0ms 11 121,932 1s342ms 0ms 12 122,024 1s191ms 0ms 13 113,838 1s132ms 0ms 14 112,951 1s120ms 0ms 15 111,889 1s22ms 0ms 16 98,812 960ms 0ms 17 80,424 822ms 0ms 18 72,450 749ms 0ms 19 57,861 606ms 0ms 20 43,871 408ms 0ms 21 36,754 331ms 0ms 22 24,502 205ms 0ms -
ROLLBACK;
Date: 2024-12-19 11:52:12 Duration: 13ms
-
ROLLBACK;
Date: 2024-12-19 10:58:51 Duration: 1ms
-
ROLLBACK;
Date: 2024-12-19 14:55:25 Duration: 0ms
4 1,360,872 4m 0ms 16ms 0ms select payload from http_sessions where sid = ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 19 00 25,032 4s281ms 0ms 01 21,310 4s1ms 0ms 02 18,389 3s24ms 0ms 03 18,900 3s400ms 0ms 04 19,137 3s667ms 0ms 05 19,625 3s744ms 0ms 06 19,610 3s390ms 0ms 07 17,794 2s478ms 0ms 08 33,371 5s747ms 0ms 09 78,350 14s26ms 0ms 10 100,638 18s743ms 0ms 11 120,669 23s81ms 0ms 12 121,197 21s507ms 0ms 13 113,262 20s369ms 0ms 14 112,127 19s702ms 0ms 15 111,285 18s55ms 0ms 16 97,991 17s189ms 0ms 17 79,852 14s542ms 0ms 18 71,685 12s704ms 0ms 19 57,238 10s304ms 0ms 20 43,421 7s110ms 0ms 21 36,034 5s727ms 0ms 22 23,955 3s805ms 0ms -
SELECT payload FROM http_sessions WHERE sid = '3128bef48580a051a9de4eae8ff9b18960dc4259';
Date: 2024-12-19 13:35:08 Duration: 16ms
-
SELECT payload FROM http_sessions WHERE sid = '82c5dbada4bf662fec0ae111dbcc182f938e913f';
Date: 2024-12-19 12:44:50 Duration: 15ms
-
SELECT payload FROM http_sessions WHERE sid = '30265fae7515fafc953fe227fcd10313494a029c';
Date: 2024-12-19 15:10:24 Duration: 14ms
5 1,351,198 1m59s 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 19 00 25,030 2s110ms 0ms 01 21,342 1s847ms 0ms 02 18,475 1s515ms 0ms 03 19,021 1s652ms 0ms 04 19,229 1s727ms 0ms 05 19,677 1s762ms 0ms 06 19,633 1s699ms 0ms 07 17,846 1s397ms 0ms 08 33,089 2s749ms 0ms 09 77,493 6s712ms 0ms 10 99,683 9s72ms 0ms 11 119,234 11s259ms 0ms 12 119,986 10s516ms 0ms 13 112,142 10s50ms 0ms 14 111,131 9s950ms 0ms 15 110,395 9s118ms 0ms 16 97,392 8s626ms 0ms 17 79,322 7s354ms 0ms 18 71,289 6s597ms 0ms 19 56,932 5s366ms 0ms 20 43,150 3s661ms 0ms 21 35,842 2s915ms 0ms 22 23,865 1s854ms 0ms -
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-19 12:00:10 Duration: 1ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-19 14:27:09 Duration: 0ms
-
SELECT base_registry_signaling.last_value, base_cache_signaling.last_value FROM base_registry_signaling, base_cache_signaling;
Date: 2024-12-19 12:50:39 Duration: 0ms
6 958,813 2m13s 0ms 11ms 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 19 00 12,670 1s891ms 0ms 01 9,045 1s499ms 0ms 02 8,127 1s329ms 0ms 03 9,539 1s563ms 0ms 04 9,955 1s643ms 0ms 05 10,545 1s707ms 0ms 06 11,986 1s813ms 0ms 07 10,182 1s507ms 0ms 08 23,376 3s58ms 0ms 09 62,943 8s194ms 0ms 10 78,757 11s80ms 0ms 11 94,744 14s140ms 0ms 12 96,330 13s386ms 0ms 13 83,786 11s425ms 0ms 14 84,252 11s213ms 0ms 15 87,102 10s619ms 0ms 16 63,874 8s242ms 0ms 17 54,890 7s883ms 0ms 18 48,098 6s629ms 0ms 19 36,482 5s982ms 0ms 20 26,637 4s259ms 0ms 21 21,562 3s66ms 0ms 22 13,931 1s744ms 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 (901);
Date: 2024-12-19 17:21:55 Duration: 11ms
-
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-19 17:21:55 Duration: 11ms
-
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 (855);
Date: 2024-12-19 17:21:55 Duration: 11ms
7 731,749 2m8s 0ms 32ms 0ms commit;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 19 00 9,980 1s753ms 0ms 01 7,456 1s457ms 0ms 02 6,817 1s155ms 0ms 03 8,154 1s647ms 0ms 04 8,473 1s723ms 0ms 05 9,142 1s781ms 0ms 06 9,768 1s683ms 0ms 07 8,381 1s156ms 0ms 08 18,684 2s847ms 0ms 09 47,226 7s464ms 0ms 10 59,680 10s74ms 0ms 11 72,570 14s51ms 0ms 12 71,855 12s630ms 0ms 13 63,290 11s534ms 0ms 14 62,499 10s464ms 0ms 15 62,168 9s696ms 0ms 16 49,053 8s78ms 0ms 17 42,653 7s344ms 0ms 18 37,358 6s928ms 0ms 19 27,978 5s297ms 0ms 20 20,262 4s248ms 0ms 21 17,127 3s198ms 0ms 22 11,175 2s212ms 0ms -
COMMIT;
Date: 2024-12-19 17:01:39 Duration: 32ms
-
COMMIT;
Date: 2024-12-19 13:30:44 Duration: 30ms
-
COMMIT;
Date: 2024-12-19 15:31:09 Duration: 30ms
8 584,145 1m18s 0ms 14ms 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 19 00 8,996 1s110ms 0ms 01 7,304 777ms 0ms 02 4,659 591ms 0ms 03 4,854 747ms 0ms 04 5,322 671ms 0ms 05 6,193 694ms 0ms 06 6,964 873ms 0ms 07 5,029 554ms 0ms 08 11,848 1s540ms 0ms 09 37,465 4s724ms 0ms 10 47,205 6s511ms 0ms 11 54,307 9s28ms 0ms 12 58,644 8s412ms 0ms 13 48,066 6s517ms 0ms 14 50,740 6s898ms 0ms 15 56,812 6s693ms 0ms 16 36,014 4s370ms 0ms 17 34,071 4s218ms 0ms 18 32,488 4s517ms 0ms 19 23,811 3s504ms 0ms 20 18,810 2s455ms 0ms 21 15,553 1s652ms 0ms 22 8,990 969ms 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 (5173936, 5188300, 5247518, 5439475, 5192543, 5439385, 5136885, 5429561);
Date: 2024-12-19 10:42:11 Duration: 14ms
-
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 (5099947, 5099009, 5104872, 5099761, 5099102, 5099138, 5108535, 5117827, 5099254, 5146334, 5099008, 5105592, 5103766, 5104338, 5099049, 5099585, 5206898, 5101463, 5100901, 5106438, 5116698, 5100561, 5099007, 5101219, 5099609, 5099170, 5113489, 5100420, 5106641, 5101878, 5102214, 5101185, 5099642, 5100564);
Date: 2024-12-19 17:21:55 Duration: 4ms
-
SELECT "urgent_customer"."id" AS "id", "urgent_customer"."message_main_attachment_id" AS "message_main_attachment_id", "urgent_customer"."name" AS "name", "urgent_customer"."phone" AS "phone", "urgent_customer"."code" AS "code", "urgent_customer"."address" AS "address", "urgent_customer"."active" AS "active", "urgent_customer"."receive_man_id_no" AS "receive_man_id_no", "urgent_customer"."create_uid" AS "create_uid", "urgent_customer"."create_date" AS "create_date", "urgent_customer"."write_uid" AS "write_uid", "urgent_customer"."write_date" AS "write_date", "urgent_customer"."v_10_id" AS "v_10_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (5099319, 5099009, 5099010, 5099007, 5154668, 5173828, 5099187, 5102626, 5099391, 5147623, 5107441, 5173935, 5099170, 5170997, 5113389, 5151263, 5100163, 5104072, 5105204, 5099427, 5101088, 5099158, 5099013, 5099117, 5099309, 5102053, 5100800, 5173833, 5099134, 5103025, 5099662, 5100170, 5169484, 5113251, 5167521, 5099035, 5112606, 5101757, 5140543, 5105201, 5099254, 5103520, 5106988, 5099006, 5104549, 5102581, 5099654, 5131703, 5168962, 5099103, 5099037, 5099195, 5101166, 5119250, 5182719, 5099815, 5098996, 5099444, 5100776, 5120631, 5100477, 5148386, 5114634, 5099181, 5110053, 5100740, 5099206, 5182718, 5102366);
Date: 2024-12-19 17:21:56 Duration: 4ms
9 577,643 36s937ms 0ms 14ms 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 19 00 7,193 425ms 0ms 01 5,291 334ms 0ms 02 3,447 200ms 0ms 03 3,576 214ms 0ms 04 4,068 257ms 0ms 05 4,211 267ms 0ms 06 6,922 375ms 0ms 07 6,049 311ms 0ms 08 14,019 739ms 0ms 09 36,973 2s144ms 0ms 10 46,412 3s16ms 0ms 11 55,852 4s179ms 0ms 12 57,123 3s628ms 0ms 13 50,360 3s292ms 0ms 14 51,807 3s421ms 0ms 15 57,712 3s389ms 0ms 16 38,162 2s456ms 0ms 17 34,217 2s137ms 0ms 18 31,233 2s194ms 0ms 19 22,219 1s597ms 0ms 20 17,256 1s43ms 0ms 21 14,415 816ms 0ms 22 9,126 492ms 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 (123);
Date: 2024-12-19 11:52:12 Duration: 14ms
-
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, 80, 4, 35, 5, 8, 121, 9, 127, 44, 10, 2, 36, 42, 114, 71, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 59, 97, 101, 108, 118, 120, 129, 124, 122, 112);
Date: 2024-12-19 15:46:34 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 (41, 60, 27);
Date: 2024-12-19 19:24:33 Duration: 1ms
10 404,897 1m13s 0ms 11ms 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 19 00 4,527 781ms 0ms 01 2,908 530ms 0ms 02 2,221 391ms 0ms 03 2,224 426ms 0ms 04 2,619 502ms 0ms 05 2,894 539ms 0ms 06 3,835 681ms 0ms 07 4,396 677ms 0ms 08 11,491 1s842ms 0ms 09 29,207 4s823ms 0ms 10 33,239 6s95ms 0ms 11 39,457 8s133ms 0ms 12 40,843 7s491ms 0ms 13 36,555 6s655ms 0ms 14 36,293 6s556ms 0ms 15 38,919 6s699ms 0ms 16 28,458 4s985ms 0ms 17 23,217 4s400ms 0ms 18 20,195 4s36ms 0ms 19 15,594 3s236ms 0ms 20 11,725 2s66ms 0ms 21 8,669 1s457ms 0ms 22 5,411 917ms 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-19 17:21:55 Duration: 11ms
-
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-19 10:19:54 Duration: 4ms
-
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 (8007467);
Date: 2024-12-19 17:21:55 Duration: 2ms
11 395,042 2m7s 0ms 4ms 0ms select r.id from ir_rule r join ir_model m on (r.model_id = m.id) where m.model = ? and r.active and r.perm_read and (r.id in ( select rule_group_id from rule_group_rel rg join res_groups_users_rel gu on (rg.group_id = gu.gid) where gu.uid = ?) or r.global) order by r.id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 19 00 4,338 1s313ms 0ms 01 2,909 880ms 0ms 02 1,535 471ms 0ms 03 1,320 449ms 0ms 04 1,705 572ms 0ms 05 1,428 457ms 0ms 06 1,517 490ms 0ms 07 2,294 682ms 0ms 08 11,557 3s442ms 0ms 09 26,828 8s131ms 0ms 10 33,960 11s91ms 0ms 11 42,035 14s633ms 0ms 12 43,204 14s41ms 0ms 13 39,979 13s60ms 0ms 14 31,428 10s337ms 0ms 15 31,751 9s674ms 0ms 16 31,861 9s969ms 0ms 17 22,788 7s517ms 0ms 18 25,935 8s767ms 0ms 19 12,764 4s625ms 0ms 20 7,123 2s188ms 0ms 21 10,132 2s874ms 0ms 22 6,651 1s806ms 0ms -
SELECT r.id FROM ir_rule r JOIN ir_model m ON (r.model_id = m.id) WHERE m.model = 'res.lang' AND r.active AND r.perm_read AND (r.id IN ( SELECT rule_group_id FROM rule_group_rel rg JOIN res_groups_users_rel gu ON (rg.group_id = gu.gid) WHERE gu.uid = 999) OR r.global) ORDER BY r.id;
Date: 2024-12-19 17:21:55 Duration: 4ms
-
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 = 855) OR r.global) ORDER BY r.id;
Date: 2024-12-19 18:43:41 Duration: 2ms
-
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 = 947) OR r.global) ORDER BY r.id;
Date: 2024-12-19 12:22:29 Duration: 2ms
12 296,362 51s526ms 0ms 3ms 0ms select ? from res_groups_users_rel where uid = ? and gid in ( select res_id from ir_model_data where module = ? and name = ? and model = ?);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 19 00 3,503 522ms 0ms 01 2,337 334ms 0ms 02 1,767 226ms 0ms 03 1,933 247ms 0ms 04 2,078 270ms 0ms 05 1,581 214ms 0ms 06 1,642 228ms 0ms 07 1,747 261ms 0ms 08 10,825 1s644ms 0ms 09 22,030 3s500ms 0ms 10 26,227 4s644ms 0ms 11 30,211 5s919ms 0ms 12 30,919 5s635ms 0ms 13 26,875 4s948ms 0ms 14 23,073 4s72ms 0ms 15 23,285 3s861ms 0ms 16 22,973 3s933ms 0ms 17 16,568 2s925ms 0ms 18 19,035 3s615ms 0ms 19 9,475 1s744ms 0ms 20 5,428 832ms 0ms 21 7,458 1s149ms 0ms 22 5,392 791ms 0ms -
SELECT 1 FROM res_groups_users_rel WHERE uid = 999 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_user' AND model = 'res.groups');
Date: 2024-12-19 17:21:55 Duration: 3ms
-
SELECT 1 FROM res_groups_users_rel WHERE uid = 901 AND gid IN ( SELECT res_id FROM ir_model_data WHERE module = 'base' AND name = 'group_allow_export' AND model = 'res.groups');
Date: 2024-12-19 13:27:27 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-19 18:20:22 Duration: 2ms
13 270,430 1m8s 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 #13
Day Hour Count Duration Avg duration Dec 19 00 3,996 982ms 0ms 01 4,062 986ms 0ms 02 1,939 498ms 0ms 03 1,925 622ms 0ms 04 2,379 687ms 0ms 05 3,148 843ms 0ms 06 2,753 782ms 0ms 07 2,122 523ms 0ms 08 5,027 1s416ms 0ms 09 15,569 4s41ms 0ms 10 20,057 5s337ms 0ms 11 23,199 7s429ms 0ms 12 26,025 6s604ms 0ms 13 22,454 5s231ms 0ms 14 23,908 5s760ms 0ms 15 27,808 6s318ms 0ms 16 16,820 3s882ms 0ms 17 15,807 3s926ms 0ms 18 16,700 4s459ms 0ms 19 11,542 3s310ms 0ms 20 9,871 2s372ms 0ms 21 8,308 1s855ms 0ms 22 5,011 1s77ms 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 (41595638, 41480586, 41314964, 41489363, 41489605, 41703292, 41427137, 41711504, 41013172, 32640280, 41731862, 41679646, 41412251, 41579218, 32639604, 32633742, 41510920, 41350769, 41641603, 41506290, 41635345, 41629093, 41640326, 41628850, 41608162, 41660575, 41660490, 41434042, 41568359, 41518468, 41664108, 41661810, 41485518, 41664044, 41073486, 41663872, 41663870, 41564019, 41617895, 41677279, 41230490, 41677046, 41546712, 41424074, 41169235, 41304484, 41639430, 41637333, 41661102, 41542666, 41542445);
Date: 2024-12-19 17:21:55 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 (41506957, 41649293, 41614517, 41614535, 41484135, 41596057, 41535251, 41286389, 41516623, 41277207, 41447695, 41625651, 32637507, 41630151, 41171109, 41625465, 41641599, 41625035, 41637506, 41614232, 41511838, 41501782, 41137691, 41201920, 41368959, 41368961, 41373170, 41447399, 41504283, 41510454, 41535803, 41537514, 41548042, 41548045, 41548389, 41549533, 41567803, 41568196, 41571624, 41571789, 41596172, 41597523, 41606651, 41613823, 41614952, 41629217, 41629843, 41634409, 41636735, 41637000, 41638658, 41638708, 41638872, 41659773, 41660712, 41661016, 41664751, 41441022, 41442530, 41569455, 41566729, 41350773, 41440128, 41556553, 41262438, 41390337, 41499331, 41620004, 41591837, 41486663, 41386991, 41420658, 41518026, 41586291, 41588897, 41590580, 41593804, 41612300, 41650211, 41666856, 41646699, 41404391, 41579726, 41581135, 41592925, 41593975, 41603595, 41649994, 41530786, 41225529);
Date: 2024-12-19 11:52:12 Duration: 15ms
-
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 (41622864, 41566414, 41579502, 41566458, 32637472, 32638241, 41523054, 41681092, 32639378, 41314714, 41504366, 41625501, 41647945, 41511582, 41625582, 41561317, 41278818, 41584974, 41623017, 41326184, 41223134, 41118873, 41223227, 41537853, 39409512, 41386422, 40896638, 41381162, 41022169, 32638135, 41380765, 41251884, 41415738, 41133362, 41488745, 41034965, 41643246, 41678805, 41625378, 41601454, 41467253, 41331927, 41416511, 41503709, 41623423, 41561328, 41624232, 41579014, 41560713, 41662152, 41251876, 41314922, 41427024, 32636987, 41566063, 41119524, 32638714, 41614261, 32638015, 41679744, 41501837, 32637419, 41502581, 32636429, 41600754, 32637463, 32638693, 40919356, 41353222, 41575101, 41411675, 32637423, 41648543, 41386074, 41090590, 41448446, 41584997, 41625169, 41661848, 41601595, 41098756, 41012821, 41467466, 41489602, 41012831, 40720690, 41012828, 41679750, 41623547, 41098751, 41622997, 41565661, 41623429, 41489208, 41504485, 40463285, 41622769, 32638243, 41626355, 41623445, 41679851, 41710960, 41502978, 41615247, 41223232, 41661795, 41532673, 41539562, 41661857, 41447805, 41622881, 41278717, 32635499, 32635143, 41661859, 41626352, 41648247, 41614217, 41411663, 41502973, 41600941, 41533381, 40775383, 32637386, 41662413, 41561959, 41584899, 41522739, 41532671, 41625591, 41131320, 41623025, 41421374, 41615355, 41418167, 40264983, 41421372, 41585187, 41485515, 41625369, 32639102, 32637436, 41357218, 41352783, 41625030, 41467164, 41585170, 41316362, 41346531, 41386298, 32639110, 41130083, 32638221, 32637599, 32638939, 41369630, 41579481, 41579212, 41346072, 41502321, 41647695, 32638705, 32638669, 41538033, 41392978, 41608603, 41119325, 41710961, 32637495, 41522798, 32638344, 41585179, 41533382, 40775381, 41012991, 41661861, 41678903, 41523430, 41622911, 41503832, 41523428, 41579483, 41537900, 41625379, 41622906, 41415720, 41131317, 32638727, 41522731, 41316048, 41625165, 41625499, 41184219, 41661796, 41642949, 41467385, 41626393, 41506445, 41485509, 41625607);
Date: 2024-12-19 11:52:12 Duration: 15ms
14 262,100 1d7h59m41s 365ms 3s419ms 439ms 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 19 00 6,040 40m59s 407ms 01 8,679 1h1s 414ms 02 5,233 34m43s 398ms 03 8,485 56m37s 400ms 04 9,870 1h5m44s 399ms 05 9,405 1h3m49s 407ms 06 5,672 37m23s 395ms 07 2,153 14m1s 390ms 08 5,746 37m53s 395ms 09 10,049 1h8m15s 407ms 10 14,425 1h42m15s 425ms 11 20,326 2h39m9s 469ms 12 15,520 1h51m9s 429ms 13 12,913 1h31m41s 426ms 14 11,961 1h25m26s 428ms 15 10,648 1h14m36s 420ms 16 11,649 1h22m58s 427ms 17 17,394 2h13m14s 459ms 18 21,027 2h52m3s 490ms 19 17,655 2h26m53s 499ms 20 20,498 2h36m21s 457ms 21 10,869 1h21m32s 450ms 22 5,883 42m49s 436ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3711468)) AND (("shipping_track"."id" not in (30294845, 30295308, 30295622, 30333920, 30418597, 30418653, 30442569, 30442726, 30443011, 30487649, 30487649)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:46 Duration: 3s419ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3689091)) AND (("shipping_track"."id" not in (30064231, 30065425, 30066872, 30421835, 30422046, 30422237, 30601941, 30601941)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:02 Duration: 3s361ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3749546)) AND (("shipping_track"."id" not in (30601963, 30601963)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:01 Duration: 3s313ms
15 202,548 16s715ms 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 19 00 2,681 248ms 0ms 01 1,637 120ms 0ms 02 1,405 86ms 0ms 03 1,495 92ms 0ms 04 1,608 105ms 0ms 05 1,558 100ms 0ms 06 2,372 137ms 0ms 07 1,815 96ms 0ms 08 4,196 243ms 0ms 09 13,380 785ms 0ms 10 16,934 1s226ms 0ms 11 19,543 1s813ms 0ms 12 21,310 1s711ms 0ms 13 17,627 1s510ms 0ms 14 18,817 1s655ms 0ms 15 22,787 1s771ms 0ms 16 12,646 915ms 0ms 17 11,093 864ms 0ms 18 9,656 1s27ms 0ms 19 7,314 959ms 0ms 20 5,634 601ms 0ms 21 4,279 482ms 0ms 22 2,761 157ms 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-19 19:27:51 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-19 17:21:55 Duration: 1ms
-
SELECT "notebook_package"."id" AS "id", "notebook_package"."name" AS "name", "notebook_package"."locked" AS "locked", "notebook_package"."start" AS "start", "notebook_package"."state" AS "state", "notebook_package"."active" AS "active", "notebook_package"."create_uid" AS "create_uid", "notebook_package"."create_date" AS "create_date", "notebook_package"."write_uid" AS "write_uid", "notebook_package"."write_date" AS "write_date", "notebook_package"."v_10_id" AS "v_10_id" FROM "notebook_package" WHERE "notebook_package".id IN (2);
Date: 2024-12-19 11:41:26 Duration: 0ms
16 169,429 9s703ms 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 19 00 1,884 97ms 0ms 01 1,213 62ms 0ms 02 609 29ms 0ms 03 570 29ms 0ms 04 656 34ms 0ms 05 505 26ms 0ms 06 656 35ms 0ms 07 1,012 52ms 0ms 08 4,978 264ms 0ms 09 11,692 627ms 0ms 10 14,714 857ms 0ms 11 17,710 1s126ms 0ms 12 18,813 1s94ms 0ms 13 17,417 1s10ms 0ms 14 13,602 781ms 0ms 15 13,879 730ms 0ms 16 13,685 764ms 0ms 17 9,513 558ms 0ms 18 10,901 673ms 0ms 19 5,183 330ms 0ms 20 2,868 152ms 0ms 21 4,376 218ms 0ms 22 2,993 143ms 0ms -
SELECT "ir_rule"."id" AS "id", "ir_rule"."name" AS "name", "ir_rule"."active" AS "active", "ir_rule"."model_id" AS "model_id", "ir_rule"."domain_force" AS "domain_force", "ir_rule"."perm_read" AS "perm_read", "ir_rule"."perm_write" AS "perm_write", "ir_rule"."perm_create" AS "perm_create", "ir_rule"."perm_unlink" AS "perm_unlink", "ir_rule"."create_uid" AS "create_uid", "ir_rule"."create_date" AS "create_date", "ir_rule"."write_uid" AS "write_uid", "ir_rule"."write_date" AS "write_date", "ir_rule"."global" AS "global" FROM "ir_rule" WHERE "ir_rule".id IN (2, 10);
Date: 2024-12-19 12:41:30 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 (98, 99);
Date: 2024-12-19 14:26:23 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 (96);
Date: 2024-12-19 20:47:02 Duration: 0ms
17 166,998 1m37s 0ms 19ms 0ms select "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."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 #17
Day Hour Count Duration Avg duration Dec 19 00 1,143 797ms 0ms 01 550 347ms 0ms 02 124 72ms 0ms 03 210 130ms 0ms 04 223 134ms 0ms 05 258 151ms 0ms 06 565 233ms 0ms 07 859 298ms 0ms 08 3,309 1s594ms 0ms 09 7,268 3s900ms 0ms 10 9,989 5s536ms 0ms 11 13,730 9s889ms 0ms 12 12,129 8s738ms 0ms 13 13,224 7s936ms 0ms 14 12,715 9s58ms 0ms 15 10,068 6s329ms 0ms 16 11,149 5s782ms 0ms 17 12,566 6s456ms 0ms 18 11,916 6s727ms 0ms 19 25,522 13s304ms 0ms 20 15,823 7s701ms 0ms 21 2,617 1s446ms 0ms 22 1,041 655ms 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"."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 (3531843, 3501665, 3550004, 2006102, 3546558, 3534823, 3546563, 3537700, 3527673, 3441204, 3537866, 3549352, 2590986, 3064827, 3548485, 3537843, 3545263, 3545302, 3550013, 2874255, 3247280, 3305281, 3531822, 3549520, 3441176, 3524913, 3463282, 3546561, 3548787, 3545290, 3489073, 3531818, 3527670, 3512424, 3537699, 3527667, 3442544, 3527672, 3527736, 3525217, 3386286, 3539622, 3549776, 3534817, 3527669, 3531828, 3527677, 3565537, 3458273, 3548788, 3534824, 3548789, 3531859, 3474689, 3419001, 3493548, 3489057, 3489062, 3474412, 3534821, 3333892, 3474686, 3247831, 3493546, 3489064, 3489065, 3524897, 3474609, 3263304, 3419003, 3386275, 3458266, 3207958, 3332504, 3395508, 3438635, 3379682, 3438634, 2771934, 3438638, 3489063, 3459222, 3294273, 3438637, 3458283, 3093070, 3431172, 3431174, 3388987, 3372439, 3423215, 3440684, 3458286, 3474608, 3374043, 3474688, 3474604, 3463512, 3140757, 3438639, 3458281, 3474611, 3431181, 3474692, 3474690, 3474406, 3458277, 3459100, 3431169, 3474448, 3474694, 3474445, 3474451, 3428376, 3295036, 3419015, 3431183, 3392500, 3429853, 3349141, 3428320, 3418998, 3423212, 3431185, 3422261, 3431146, 3442351, 3431177, 3228703, 3321502, 3349130, 3189042, 3233851, 3155380, 3225016, 3321504, 3325126, 3295022, 3294261, 3275244, 3295033, 3219586, 3192698, 3188818, 3122744, 3082030, 3082032, 2580858);
Date: 2024-12-19 19:45:44 Duration: 19ms
-
SELECT "shipping_policy"."id" AS "id", "shipping_policy"."message_main_attachment_id" AS "message_main_attachment_id", "shipping_policy"."v_10_id" AS "v_10_id", "shipping_policy"."notes" AS "notes", "shipping_policy"."search_name" AS "search_name", "shipping_policy"."active" AS "active", "shipping_policy"."policy_name" AS "policy_name", "shipping_policy"."state_id" AS "state_id", "shipping_policy"."d_date" AS "d_date", "shipping_policy"."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 (3531717, 3559397, 3544346, 3511627, 3496398, 3502495, 3559761, 3547564, 3473977, 3544349, 3564161, 3420841, 3523536, 3266258, 3544268, 3559760, 3502645, 3544265, 2341175, 3457343, 3544280, 3559396, 3531720, 3559264, 3559390, 3564184, 3523589, 3328926, 3496328, 3466057, 3523481, 3428809, 3560611, 3511626, 3537385, 3564159, 3555373, 3541768, 3473873, 3330718, 3509006, 3437244, 3544354, 3314102, 3437685, 3472222, 3461978, 3515392, 3196334, 3437858, 3428691, 3490534, 3490587, 3502631, 3442545, 3507332, 3511613, 3473896, 3507422, 3496380, 3507431, 3490520, 3496395, 3511581, 3517649, 3496422, 2993572, 3328697, 3513883, 3547554, 3527564, 3544267, 3511625, 3507684, 3502437, 3466076, 3478781, 3437699, 3442695, 3437736, 3477610, 3442458, 3490510, 3358065, 3437682, 3511601, 3246862, 3437299, 3461950, 3473950, 3461945, 3355151, 3370436, 3335124, 3471881, 3472282, 3479253, 3473942, 3437689, 3437729, 3474661, 3471862, 3473983, 3437693, 3473956, 3437692, 3437733, 3473973, 3434922, 3437743, 3442680, 3134879, 3314573, 3303790, 3442682, 3346439, 3395337, 3437746, 3434917, 3442633, 3437740, 3442686, 3442373, 3334680, 3346301, 3314572, 3276137, 3395336, 3341223, 3311893, 3335556, 3364437, 3334674, 3341220, 3358577, 3346303, 3340960, 3362612, 3335198, 3305757, 3255000, 3327174, 3335101, 3335097, 3335096, 3327208, 3250616, 3327206, 3242055, 3262635, 3282878, 3184039, 2958128, 2779501, 3061430, 2722247, 3021778, 2670469, 2722243, 2770356, 2770355, 2770362, 2722241, 2770354, 2770363, 2722245, 2722224);
Date: 2024-12-19 12:40:53 Duration: 18ms
-
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"."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 (3566471, 3555179, 3550979, 3548266, 3546349, 3546204, 3541510, 3541261, 3535734, 3534643, 3530691, 3526831, 3524074, 3522552, 3520522, 3520466, 3520114, 3512823, 3502392, 3497349, 3491091, 3488837, 3486646, 3484794, 3483912, 3474503, 3467296, 3448918, 3445378, 3438750, 3438017);
Date: 2024-12-19 12:24:07 Duration: 16ms
18 162,824 20s403ms 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 #18
Day Hour Count Duration Avg duration Dec 19 00 1,818 206ms 0ms 01 1,189 134ms 0ms 02 596 63ms 0ms 03 570 65ms 0ms 04 648 74ms 0ms 05 495 56ms 0ms 06 638 73ms 0ms 07 1,000 115ms 0ms 08 4,883 555ms 0ms 09 11,502 1s338ms 0ms 10 14,205 1s811ms 0ms 11 16,952 2s376ms 0ms 12 18,067 2s294ms 0ms 13 16,662 2s121ms 0ms 14 13,109 1s649ms 0ms 15 13,372 1s530ms 0ms 16 13,084 1s601ms 0ms 17 9,102 1s169ms 0ms 18 10,382 1s419ms 0ms 19 4,929 704ms 0ms 20 2,600 302ms 0ms 21 4,126 445ms 0ms 22 2,895 295ms 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 (13) 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-19 15:37:34 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 (17) 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-19 18:43:41 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 (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-19 11:46:13 Duration: 1ms
19 152,665 1h42m49s 30ms 242ms 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 #19
Day Hour Count Duration Avg duration Dec 19 00 2,807 1m45s 37ms 01 3,366 2m7s 37ms 02 1,535 57s452ms 37ms 03 1,900 1m12s 38ms 04 3,118 1m58s 37ms 05 3,009 1m55s 38ms 06 2,339 1m28s 38ms 07 902 33s614ms 37ms 08 3,195 2m2s 38ms 09 7,262 4m45s 39ms 10 10,851 7m17s 40ms 11 15,689 11m33s 44ms 12 12,750 8m37s 40ms 13 10,858 7m17s 40ms 14 9,533 6m21s 40ms 15 8,766 5m47s 39ms 16 8,134 5m23s 39ms 17 10,246 6m55s 40ms 18 12,360 8m37s 41ms 19 8,346 6m2s 43ms 20 6,086 3m59s 39ms 21 5,848 3m45s 38ms 22 3,765 2m24s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3636844, 3000150)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:59 Duration: 242ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3701074, 3651694, 3636225)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:41 Duration: 223ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3711422)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:46 Duration: 218ms
20 142,638 28s606ms 0ms 1ms 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 19 00 1,522 283ms 0ms 01 947 176ms 0ms 02 510 90ms 0ms 03 549 103ms 0ms 04 601 114ms 0ms 05 547 103ms 0ms 06 660 124ms 0ms 07 813 153ms 0ms 08 4,171 771ms 0ms 09 10,033 1s876ms 0ms 10 12,880 2s581ms 0ms 11 15,231 3s290ms 0ms 12 15,910 3s194ms 0ms 13 14,191 2s897ms 0ms 14 11,277 2s302ms 0ms 15 11,573 2s188ms 0ms 16 11,131 2s188ms 0ms 17 8,232 1s708ms 0ms 18 8,934 1s906ms 0ms 19 4,433 995ms 0ms 20 2,384 468ms 0ms 21 3,600 647ms 0ms 22 2,509 439ms 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 (1280) 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-19 17:21:55 Duration: 1ms
-
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 (856) 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-19 17:21:55 Duration: 1ms
-
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 (1300) 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-19 19:16:16 Duration: 1ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 0ms 33m57s 42s40ms 49 34m19s update "res_users" set "exp_date" = ?, "last_update" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 19 01 2 0ms 0ms 04 1 0ms 0ms 08 3 4ms 1ms 09 4 34m19s 8m34s 10 8 14ms 1ms 11 7 7ms 1ms 12 6 8ms 1ms 13 1 1ms 1ms 14 2 1ms 0ms 15 3 0ms 0ms 16 2 1ms 0ms 17 2 1ms 0ms 19 3 3ms 1ms 20 3 0ms 0ms 21 2 3ms 1ms -
UPDATE "res_users" SET "exp_date" = '2024-12-19 09:05:22.453434', "last_update" = '2024-12-19 08:20:22.453456', "write_date" = '2024-12-19 08:20:22.124016', "write_uid" = 1 WHERE id IN (959);
Date: 2024-12-19 09:54:20 Duration: 33m57s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 09:03:58.585604', "last_update" = '2024-12-19 08:18:58.585620', "write_date" = '2024-12-19 08:18:58.267000', "write_uid" = 1 WHERE id IN (959);
Date: 2024-12-19 09:19:20 Duration: 22s48ms
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 19:35:28.117132', "last_update" = '2024-12-19 18:50:28.117155', "write_date" = '2024-12-19 18:50:27.719301', "write_uid" = 1 WHERE id IN (909);
Date: 2024-12-19 19:50:28 Duration: 3ms
2 0ms 15m43s 9s890ms 403 1h6m25s update "res_users" set "exp_date" = ?, "last_update" = ?, "sid" = ?, "write_date" = ?, "write_uid" = ? where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 19 00 5 2ms 0ms 01 3 0ms 0ms 02 3 0ms 0ms 04 1 0ms 0ms 05 3 1ms 0ms 06 6 1ms 0ms 07 4 0ms 0ms 08 17 4m29s 15s864ms 09 42 1m23s 1s999ms 10 44 4m39s 6s341ms 11 44 49ms 1ms 12 38 15m9s 23s924ms 13 35 55s986ms 1s599ms 14 24 3m21s 8s382ms 15 38 20m42s 32s700ms 16 18 20ms 1ms 17 15 16ms 1ms 18 25 31ms 1ms 19 15 11ms 0ms 20 8 3ms 0ms 21 10 15m43s 1m34s 22 5 4ms 0ms -
UPDATE "res_users" SET "exp_date" = '2024-12-19 20:44:36.801447', "last_update" = '2024-12-19 19:59:36.801471', "sid" = '0808a382f8bec08db0ff2770b5aa991f82f1c38e', "write_date" = '2024-12-19 19:59:36.377449', "write_uid" = 1 WHERE id IN (857);
Date: 2024-12-19 21:15:20 Duration: 15m43s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 14:49:45.434906', "last_update" = '2024-12-19 14:04:45.434925', "sid" = '2c4d8cf313bf70533867357f752d391f5b6e4758', "write_date" = '2024-12-19 14:04:45.084747', "write_uid" = 1 WHERE id IN (837);
Date: 2024-12-19 15:12:21 Duration: 7m35s
-
UPDATE "res_users" SET "exp_date" = '2024-12-19 11:53:30.648531', "last_update" = '2024-12-19 11:08:30.648556', "sid" = '1786866e18a16fdd31dd3b5e8ce7ed95129115db', "write_date" = '2024-12-19 11:08:30.312010', "write_uid" = 1 WHERE id IN (909);
Date: 2024-12-19 12:14:21 Duration: 5m50s
3 0ms 59m59s 4s503ms 84,351 4d9h31m51s update res_users set sid = ?, last_update = ?, exp_date = ?, logged_in = ? where id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 19 00 871 189ms 0ms 01 736 173ms 0ms 02 637 135ms 0ms 03 791 172ms 0ms 04 794 176ms 0ms 05 775 170ms 0ms 06 752 161ms 0ms 07 594 125ms 0ms 08 1,804 5h26m3s 10s844ms 09 5,635 10h37m27s 6s787ms 10 6,689 5h2m44s 2s715ms 11 9,098 5h25m19s 2s145ms 12 9,121 9h29m14s 3s744ms 13 8,408 4h31m44s 1s939ms 14 8,116 5h1m12s 2s226ms 15 6,755 9h36m21s 5s119ms 16 6,012 11h26m3s 6s846ms 17 4,861 8h39m17s 6s409ms 18 4,292 6h56m42s 5s825ms 19 2,791 3m24s 73ms 20 1,912 1h37s 1s902ms 21 1,755 5h6m19s 10s472ms 22 1,152 17h9m16s 53s608ms -
update res_users set sid = 'c66d1c8d63042b7405589e0958f16cc76ea00b60', last_update = '2024-12-19 18:42:34.756946', exp_date = '2024-12-19 19:27:34.756949', logged_in = 'TRUE' where id = 1037;
Date: 2024-12-19 20:42:34 Duration: 59m59s
-
update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861630', exp_date = '2024-12-19 21:02:54.861633', logged_in = 'TRUE' where id = 1076;
Date: 2024-12-19 22:00:03 Duration: 42m8s
-
update res_users set sid = '19174e87874f14979eeafcd14b7e1a496d2881d8', last_update = '2024-12-19 20:17:54.861518', exp_date = '2024-12-19 21:02:54.861522', logged_in = 'TRUE' where id = 1076;
Date: 2024-12-19 22:00:03 Duration: 42m8s
4 450ms 4s498ms 3s338ms 305 16m58s select "policy_number".id from "policy_number" where ((("policy_number"."active" = true) and (((((("policy_number"."package_id" = ?) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 19 07 6 4s455ms 742ms 08 6 19s403ms 3s233ms 09 30 1m33s 3s103ms 10 1 3s173ms 3s173ms 11 11 38s927ms 3s538ms 12 8 29s171ms 3s646ms 13 18 1m3s 3s516ms 14 17 1m 3s552ms 15 22 1m7s 3s68ms 16 22 1m12s 3s303ms 17 32 1m49s 3s432ms 18 52 3m8s 3s628ms 19 30 1m45s 3s500ms 20 18 59s907ms 3s328ms 21 16 52s264ms 3s266ms 22 16 50s539ms 3s158ms -
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 (68))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (68)))))))) AND ("policy_number"."name"::text ilike '%8432882%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 18:08:12 Duration: 4s498ms
-
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 (13))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (13)))))))) AND ("policy_number"."name"::text ilike '%9058545%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 19:30:18 Duration: 4s476ms
-
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 (10))))))) 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 (10)))))) 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 (10)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10)))))) 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 (10))))))))) 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 (10)))))))) AND ("policy_number"."name"::text ilike '%9096427%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2024-12-19 18:06:48 Duration: 4s448ms
5 250ms 1s910ms 998ms 10,104 2h48m11s select "policy_number".id from "policy_number" where ((((((("policy_number"."active" = true) and ("policy_number"."name" = ?)) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) order by "policy_number"."id";Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 19 00 705 11m5s 944ms 01 449 7m6s 950ms 02 286 4m30s 946ms 03 9 8s599ms 955ms 09 2 1s946ms 973ms 10 32 32s144ms 1s4ms 11 71 1m21s 1s151ms 12 6 6s559ms 1s93ms 13 53 53s226ms 1s4ms 14 236 3m58s 1s11ms 15 253 4m13s 1s2ms 16 469 7m40s 981ms 17 1,037 17m54s 1s36ms 18 1,184 20m35s 1s43ms 19 1,730 29m53s 1s36ms 20 1,481 25m 1s12ms 21 1,361 21m17s 938ms 22 740 11m49s 958ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9526064')) 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 (51))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:44:38 Duration: 1s910ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9547154')) 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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:15:41 Duration: 1s848ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9547158')) 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 (60))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (60))))))))) ORDER BY "policy_number"."id";
Date: 2024-12-19 19:16:04 Duration: 1s812ms
6 336ms 676ms 451ms 3,893 29m17s select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) order by "cash_policy"."id" desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 19 09 289 1m59s 411ms 11 1,197 8m57s 449ms 12 2,024 15m32s 460ms 16 27 12s983ms 480ms 18 4 1s781ms 445ms 19 151 1m10s 466ms 21 201 1m23s 414ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9194043')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:10 Duration: 676ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266619')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:10 Duration: 676ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266625')) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:15 Duration: 676ms
7 371ms 4s913ms 447ms 46,111 5h43m41s 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 19 00 252 1m48s 431ms 01 281 1m59s 425ms 02 104 47s580ms 457ms 03 182 1m21s 447ms 04 180 1m22s 457ms 05 208 1m35s 460ms 06 232 1m39s 431ms 07 566 3m44s 397ms 08 1,427 9m39s 406ms 09 3,355 23m21s 417ms 10 3,513 25m38s 438ms 11 4,346 35m26s 489ms 12 3,989 29m36s 445ms 13 4,172 30m12s 434ms 14 3,997 28m55s 434ms 15 3,126 22m16s 427ms 16 3,145 22m36s 431ms 17 3,118 24m 462ms 18 3,666 29m27s 482ms 19 2,227 18m36s 501ms 20 1,895 14m11s 449ms 21 1,299 9m23s 434ms 22 831 5m58s 431ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3689091, 3716989, 3720980, 3721248, 3727320, 3727855, 3729415, 3729489)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:14:59 Duration: 4s913ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3736783, 3736750, 3736723, 3736702, 3736680, 3736675)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:47 Duration: 3s544ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3706567, 3706568)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:49 Duration: 3s393ms
8 365ms 3s419ms 439ms 262,100 1d7h59m41s 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 19 00 6,040 40m59s 407ms 01 8,679 1h1s 414ms 02 5,233 34m43s 398ms 03 8,485 56m37s 400ms 04 9,870 1h5m44s 399ms 05 9,405 1h3m49s 407ms 06 5,672 37m23s 395ms 07 2,153 14m1s 390ms 08 5,746 37m53s 395ms 09 10,049 1h8m15s 407ms 10 14,425 1h42m15s 425ms 11 20,326 2h39m9s 469ms 12 15,520 1h51m9s 429ms 13 12,913 1h31m41s 426ms 14 11,961 1h25m26s 428ms 15 10,648 1h14m36s 420ms 16 11,649 1h22m58s 427ms 17 17,394 2h13m14s 459ms 18 21,027 2h52m3s 490ms 19 17,655 2h26m53s 499ms 20 20,498 2h36m21s 457ms 21 10,869 1h21m32s 450ms 22 5,883 42m49s 436ms -
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3711468)) AND (("shipping_track"."id" not in (30294845, 30295308, 30295622, 30333920, 30418597, 30418653, 30442569, 30442726, 30443011, 30487649, 30487649)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 11:26:46 Duration: 3s419ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3689091)) AND (("shipping_track"."id" not in (30064231, 30065425, 30066872, 30421835, 30422046, 30422237, 30601941, 30601941)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:02 Duration: 3s361ms
-
SELECT "shipping_track".id FROM "shipping_track" WHERE (("shipping_track"."shipping_id" in (3749546)) AND (("shipping_track"."id" not in (30601963, 30601963)) OR "shipping_track"."id" IS NULL)) ORDER BY "shipping_track"."id";
Date: 2024-12-19 19:15:01 Duration: 3s313ms
9 219ms 2s45ms 310ms 20,041 1h43m47s 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 19 00 535 2m28s 278ms 01 1,945 9m6s 281ms 02 244 1m7s 278ms 03 415 1m57s 283ms 04 741 3m27s 279ms 05 1,586 7m30s 284ms 06 295 1m22s 279ms 07 39 10s418ms 267ms 08 15 4s236ms 282ms 09 43 12s175ms 283ms 10 212 1m6s 312ms 11 251 1m21s 326ms 12 54 15s836ms 293ms 13 244 1m16s 312ms 14 460 2m19s 302ms 15 305 1m33s 306ms 16 1,032 5m10s 301ms 17 1,737 9m25s 325ms 18 3,926 22m21s 341ms 19 1,530 8m59s 352ms 20 1,506 7m55s 316ms 21 2,178 10m54s 300ms 22 748 3m37s 290ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9351639')) 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-19 19:15:39 Duration: 2s45ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9511508')) 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-19 19:15:56 Duration: 1s947ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."name" = '9432177')) 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-19 19:16:02 Duration: 1s873ms
10 177ms 938ms 262ms 23,358 1h42m19s 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 19 08 855 3m18s 232ms 09 862 3m39s 254ms 10 2,638 11m21s 258ms 11 4,993 22m49s 274ms 12 1,418 6m10s 261ms 13 2,884 12m8s 252ms 14 1,450 6m26s 266ms 15 2,055 8m46s 256ms 16 2,953 12m12s 248ms 17 1,144 5m20s 279ms 18 1,419 6m44s 285ms 19 687 3m21s 293ms -
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" = '9386518')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:38 Duration: 938ms
-
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" = '471418')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 19:16:05 Duration: 884ms
-
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" = '9320660')))) ORDER BY "collection_policy"."id";
Date: 2024-12-19 19:16:04 Duration: 835ms
11 92ms 903ms 237ms 59,332 3h55m13s select "urgent_customer".id from "urgent_customer" where (("urgent_customer"."active" = true) and ("urgent_customer"."name" = ?)) order by "urgent_customer"."id" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 19 00 2,435 7m49s 192ms 01 4,704 15m30s 197ms 02 1,039 3m34s 206ms 03 847 3m 213ms 04 1,464 5m29s 225ms 05 3,134 12m25s 237ms 06 582 2m16s 234ms 07 74 16s671ms 225ms 08 26 5s687ms 218ms 09 76 18s192ms 239ms 10 478 1m40s 210ms 11 606 2m29s 246ms 12 102 26s503ms 259ms 13 588 2m14s 228ms 14 1,358 5m20s 235ms 15 1,078 4m25s 246ms 16 2,919 12m17s 252ms 17 5,450 23m35s 259ms 18 10,114 44m48s 265ms 19 6,472 27m9s 251ms 20 5,910 22m22s 227ms 21 6,938 24m55s 215ms 22 2,938 12m41s 259ms -
SELECT "urgent_customer".id FROM "urgent_customer" WHERE (("urgent_customer"."active" = true) AND ("urgent_customer"."name" = 'جمال')) ORDER BY "urgent_customer"."id" LIMIT 1;
Date: 2024-12-19 17:24:06 Duration: 903ms
-
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-19 17:24:06 Duration: 901ms
-
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-19 19:11:03 Duration: 881ms
12 170ms 1s624ms 219ms 133,787 8h8m48s select "shipping_policy".id from "shipping_policy" left join "policy_number" AS "shipping_policy__policy_id" on ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") where (("shipping_policy"."active" = true) and ("shipping_policy__policy_id"."name" = ?)) order by "shipping_policy"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 19 00 805 2m30s 186ms 01 1,281 4m 188ms 02 1,700 5m18s 187ms 03 2,782 8m45s 188ms 04 3,363 10m36s 189ms 05 3,224 10m17s 191ms 06 2,085 6m29s 187ms 07 728 2m15s 186ms 08 3,073 9m38s 188ms 09 4,953 16m13s 196ms 10 9,202 31m1s 202ms 11 11,351 41m30s 219ms 12 4,107 14m1s 204ms 13 7,508 25m12s 201ms 14 5,728 19m11s 200ms 15 5,701 19m3s 200ms 16 10,133 34m9s 202ms 17 10,372 37m58s 219ms 18 10,571 39m56s 226ms 19 34,095 2h27m4s 258ms 20 746 2m35s 207ms 21 105 22s86ms 210ms 22 174 35s70ms 201ms -
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" = '9435546')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:15:05 Duration: 1s624ms
-
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" = '9379871')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:15:18 Duration: 1s619ms
-
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" = '9169980')) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 11:27:09 Duration: 1s610ms
13 175ms 307ms 201ms 3,890 13m4s select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and ("cash_policy__policy_id"."name" = ?)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."id" desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 19 09 289 55s317ms 191ms 11 1,197 3m59s 200ms 12 2,025 6m49s 202ms 16 27 5s631ms 208ms 19 151 33s299ms 220ms 21 201 40s976ms 203ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '7960681')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (95))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:16:06 Duration: 307ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9194043')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (26))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:09 Duration: 283ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ("cash_policy__policy_id"."name" = '9266619')) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112, 12)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 127, 113, 44, 10, 2, 36, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 70, 61, 46, 11, 77, 26, 62, 51, 55, 30, 67, 66, 79, 68, 95, 128, 83, 112, 12))))) OR ("cash_policy__policy_id"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))))) ORDER BY "cash_policy"."id" DESC;
Date: 2024-12-19 12:17:09 Duration: 280ms
14 173ms 367ms 198ms 14,032 46m31s 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 19 00 126 23s621ms 187ms 01 72 13s500ms 187ms 02 68 12s747ms 187ms 03 477 1m29s 187ms 04 805 2m32s 189ms 05 196 37s768ms 192ms 06 854 2m40s 187ms 07 274 51s213ms 186ms 08 1,228 3m51s 188ms 09 1,252 4m8s 198ms 10 1,141 3m52s 203ms 11 1,108 4m 216ms 12 1,029 3m28s 202ms 13 893 3m1s 203ms 14 1,387 4m36s 199ms 15 1,122 3m38s 195ms 16 612 2m 196ms 17 522 1m47s 206ms 18 335 1m12s 217ms 19 84 19s278ms 229ms 20 306 1m4s 209ms 21 90 19s53ms 211ms 22 51 10s444ms 204ms -
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" = '9483770')) 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 (66)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (66))))) 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-19 19:14:36 Duration: 367ms
-
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" = '9488282')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:27:25 Duration: 307ms
-
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" = '9307192')) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (11, 12, 14, 15, 16, 17, 18, 28, 34, 35, 36, 37, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (27))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) ORDER BY "shipping_policy"."id" DESC;
Date: 2024-12-19 19:27:24 Duration: 298ms
15 170ms 243ms 188ms 12,272 38m37s 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 19 00 618 1m55s 186ms 01 1,208 3m47s 188ms 02 1,610 5m1s 187ms 03 2,281 7m10s 188ms 04 2,411 7m36s 189ms 05 2,494 7m57s 191ms 06 1,092 3m23s 186ms 07 435 1m21s 186ms 22 123 24s735ms 201ms -
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" = '9504904')) 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-19 05:24:35 Duration: 243ms
-
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" = '9050657')) 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-19 05:24:35 Duration: 241ms
-
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" = '9389363')) 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-19 04:39:30 Duration: 233ms
16 120ms 1s170ms 146ms 6,085 14m48s 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 19 00 67 8s768ms 130ms 01 10 1s325ms 132ms 06 1 130ms 130ms 07 20 2s669ms 133ms 08 85 11s446ms 134ms 09 367 51s36ms 139ms 10 667 1m36s 144ms 11 1,308 3m29s 160ms 12 945 2m16s 144ms 13 522 1m15s 144ms 14 456 1m4s 140ms 15 406 56s883ms 140ms 16 252 35s552ms 141ms 17 199 29s732ms 149ms 18 176 26s90ms 148ms 19 126 18s832ms 149ms 20 24 3s448ms 143ms 21 292 40s442ms 138ms 22 162 21s14ms 129ms -
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 66)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-19 11:26:51 Duration: 1s170ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 126)) AND ((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR (("res_partner"."company_id" in (1)) OR "res_partner"."company_id" IS NULL)) AND ((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL)) ORDER BY "res_partner"."display_name" ASC, "res_partner"."id" DESC;
Date: 2024-12-19 11:26:45 Duration: 1s27ms
-
SELECT "res_partner".id FROM "res_partner" WHERE (("res_partner"."active" = true) AND ("res_partner"."office_id" = 65)) 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-19 11:26:38 Duration: 908ms
17 76ms 394ms 93ms 22,198 34m39s 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 19 00 31 2s651ms 85ms 07 92 8s398ms 91ms 08 304 27s874ms 91ms 09 1,197 1m50s 92ms 10 1,919 2m58s 93ms 11 2,042 3m23s 99ms 12 3,297 5m7s 93ms 13 2,952 4m32s 92ms 14 2,502 3m48s 91ms 15 2,468 3m43s 90ms 16 1,196 1m51s 93ms 17 1,153 1m50s 96ms 18 1,079 1m48s 100ms 19 455 45s515ms 100ms 20 707 1m7s 95ms 21 371 33s717ms 90ms 22 433 38s381ms 88ms -
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7799849)) AND (("cash_track"."id" not in (5575166, 5581104, 5602437, 5926673, 5926677, 5926677)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:40 Duration: 394ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7847068)) AND (("cash_track"."id" not in (5926681)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:47 Duration: 354ms
-
SELECT "cash_track".id FROM "cash_track" WHERE (("cash_track"."cash_policy_id" in (7847069)) AND (("cash_track"."id" not in (5926706)) OR "cash_track"."id" IS NULL)) ORDER BY "cash_track"."id";
Date: 2024-12-19 11:26:48 Duration: 308ms
18 35ms 273ms 45ms 49,878 37m57s 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 19 01 5 224ms 44ms 06 13 549ms 42ms 07 78 3s331ms 42ms 08 2,008 1m24s 42ms 09 2,224 1m37s 43ms 10 4,266 3m10s 44ms 11 7,988 6m28s 48ms 12 3,487 2m40s 45ms 13 5,950 4m27s 44ms 14 3,103 2m18s 44ms 15 3,511 2m37s 44ms 16 4,478 3m20s 44ms 17 7,211 5m27s 45ms 18 3,025 2m19s 46ms 19 1,814 1m30s 50ms 20 248 11s16ms 44ms 21 322 13s963ms 43ms 22 147 6s431ms 43ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3607736) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:39 Duration: 273ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3606972) AND ("collection_policy"."state" = 'confirm')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:55 Duration: 265ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE (("collection_policy"."shipping_id" = 3599709) AND ("collection_policy"."state" = 'draft')) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:57 Duration: 265ms
19 31ms 196ms 41ms 19,352 13m16s 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 19 08 768 29s724ms 38ms 09 864 34s589ms 40ms 10 2,444 1m37s 40ms 11 3,111 2m17s 44ms 12 1,118 46s100ms 41ms 13 2,310 1m32s 40ms 14 1,537 1m2s 40ms 15 1,541 1m 39ms 16 1,912 1m17s 40ms 17 1,942 1m21s 42ms 18 1,153 47s609ms 41ms 19 652 27s646ms 42ms -
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3600214) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:43 Duration: 196ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3551832) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:56 Duration: 186ms
-
SELECT "collection_policy".id FROM "collection_policy" WHERE ("collection_policy"."shipping_id" = 3538553) ORDER BY "collection_policy"."id";
Date: 2024-12-19 11:26:56 Duration: 124ms
20 30ms 242ms 40ms 152,665 1h42m49s 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 19 00 2,807 1m45s 37ms 01 3,366 2m7s 37ms 02 1,535 57s452ms 37ms 03 1,900 1m12s 38ms 04 3,118 1m58s 37ms 05 3,009 1m55s 38ms 06 2,339 1m28s 38ms 07 902 33s614ms 37ms 08 3,195 2m2s 38ms 09 7,262 4m45s 39ms 10 10,851 7m17s 40ms 11 15,689 11m33s 44ms 12 12,750 8m37s 40ms 13 10,858 7m17s 40ms 14 9,533 6m21s 40ms 15 8,766 5m47s 39ms 16 8,134 5m23s 39ms 17 10,246 6m55s 40ms 18 12,360 8m37s 41ms 19 8,346 6m2s 43ms 20 6,086 3m59s 39ms 21 5,848 3m45s 38ms 22 3,765 2m24s 38ms -
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3636844, 3000150)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:59 Duration: 242ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3701074, 3651694, 3636225)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:41 Duration: 223ms
-
SELECT "shipping_policy_items".id FROM "shipping_policy_items" WHERE ("shipping_policy_items"."shipping_policy_id" in (3711422)) ORDER BY "shipping_policy_items"."id" DESC;
Date: 2024-12-19 11:26:46 Duration: 218ms
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,412,766 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1140 FATAL entries
- 9353 ERROR entries
- 0 WARNING entries
- 1505 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 4,801 Max number of times the same event was reported
- 11,998 Total events found
Rank Times reported Error 1 4,801 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 19 00 11 01 10 02 8 03 7 04 13 05 8 06 7 07 18 08 105 09 276 10 329 11 938 12 542 13 588 14 615 15 304 16 371 17 205 18 215 19 111 20 65 21 28 22 27 - 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 = 'c29e8dfc7936e50b344f468eda3383dd9eadc99c', last_update = '2024-12-18 23:07:22.306118',exp_date = '2024-12-18 23:52:22.306121', logged_in = 'TRUE' where id = 901
Date: 2024-12-19 00:07:22
Statement: update res_users set sid = '2f67e636907635d883d6e6938de56c41630db212', last_update = '2024-12-18 23:08:48.843433',exp_date = '2024-12-18 23:53:48.843437', logged_in = 'TRUE' where id = 915
Date: 2024-12-19 00:08:53
Statement: update res_users set sid = '73d6290c718914199632bad47a8a017506d2761a', last_update = '2024-12-18 23:14:26.687373',exp_date = '2024-12-18 23:59:26.687375', logged_in = 'TRUE' where id = 1245
Date: 2024-12-19 00:14:26
2 4,500 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 19 00 11 01 10 02 7 03 4 04 7 05 4 06 7 07 18 08 103 09 260 10 313 11 880 12 521 13 562 14 595 15 288 16 345 17 175 18 200 19 84 20 52 21 27 22 27 - ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
- ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT active, id, login, password, totp_secret, (SELECT value FROM ir_config_parameter WHERE key='database.secret') FROM res_users WHERE id=901
Date: 2024-12-19 00:07:22
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"."pol_name" = '9439319'))) 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 (2)))) OR ("shipping_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) OR ("shipping_policy"."last_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (2))))) 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-19 00:08:53
Statement: SELECT active, id, login, password, totp_secret, (SELECT value FROM ir_config_parameter WHERE key='database.secret') FROM res_users WHERE id=1245
Date: 2024-12-19 00:14:26
3 962 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 19 08 114 09 69 10 79 11 111 12 92 13 72 14 79 15 72 16 92 17 46 18 52 21 24 22 60 4 962 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 19 08 114 09 69 10 79 11 111 12 92 13 72 14 79 15 72 16 92 17 46 18 52 21 24 22 60 5 352 ERROR: unexpected EOF on client connection with an open transaction
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 19 08 16 09 30 10 19 11 17 12 43 13 23 14 18 15 28 16 68 17 18 18 42 20 1 21 9 22 20 6 190 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #6
Day Hour Count Dec 19 08 6 09 18 10 9 11 7 12 19 13 13 14 9 15 12 16 41 17 11 18 30 21 5 22 10 7 95 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #7
Day Hour Count Dec 19 17 95 - 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-19 17:20:02
Statement: update res_users set sid = '802ef13dca3b265fbb769aa54a0d911958ca48f3', last_update = '2024-12-19 16:10:07.938692',exp_date = '2024-12-19 16:55:07.938696', logged_in = 'TRUE' where id = 854
Date: 2024-12-19 17:20:02
Context: while updating tuple (21,11) in relation "res_users"
Statement: update res_users set sid = '802ef13dca3b265fbb769aa54a0d911958ca48f3', last_update = '2024-12-19 16:09:55.610617',exp_date = '2024-12-19 16:54:55.610620', logged_in = 'TRUE' where id = 854Date: 2024-12-19 17:20:02
8 32 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Dec 19 17 32 - FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
- FATAL: terminating background worker "parallel worker" due to administrator command
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2024-12-19 17:20:02
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" = '9376589')) ORDER BY "shipping_policy"."id" DESC
Date: 2024-12-19 17:20:02
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" = '8973779')) ORDER BY "shipping_policy"."id" DESC
Date: 2024-12-19 17:20:02
9 28 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Dec 19 02 7 05 3 09 2 10 3 11 1 12 9 19 1 21 2 - ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 163
- ERROR: syntax error at or near ")" at character 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 ('9136298',)
Date: 2024-12-19 02:14:13
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 ('9374322',)
Date: 2024-12-19 02:28:13
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 ('9166008',)
Date: 2024-12-19 02:32:07
10 22 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #10
Day Hour Count Dec 19 17 22 11 9 FATAL: password authentication failed for user "..."
Times Reported Most Frequent Error / Event #11
Day Hour Count Dec 19 05 6 08 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-19 05:03:16
12 7 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #12
Day Hour Count Dec 19 17 7 - ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
- ERROR: terminating background worker "parallel worker" due to administrator command
Context: parallel worker
Statement: SELECT "shipping_policy".id FROM "shipping_policy" LEFT JOIN "policy_number" AS "shipping_policy__policy_id" ON ("shipping_policy"."policy_id" = "shipping_policy__policy_id"."id") WHERE (("shipping_policy"."active" = true) AND ("shipping_policy__policy_id"."name" = '9376589')) ORDER BY "shipping_policy"."id" DESCDate: 2024-12-19 17:20:02
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" = '8973779')) ORDER BY "shipping_policy"."id" DESCDate: 2024-12-19 17:20:02
Context: parallel worker
Statement: SELECT "shipping_track".id FROM "shipping_track" WHERE ("shipping_track"."shipping_id" in (3621559)) ORDER BY "shipping_track"."id"Date: 2024-12-19 17:20:02
13 6 FATAL: unsupported frontend protocol 0.0: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #13
Day Hour Count Dec 19 08 1 15 1 20 1 22 3 14 4 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Dec 19 21 4 - ERROR: could not create unique index "bank_deposit_deposite_2_name"
Detail: Key (name)=(431308) is duplicated.
Statement: ALTER TABLE "bank_deposit" ADD CONSTRAINT "bank_deposit_deposite_2_name" UNIQUE (name)Date: 2024-12-19 21:54:28
15 4 ERROR: null value in column "..." of relation "..." violates not-null constraint
Times Reported Most Frequent Error / Event #15
Day Hour Count Dec 19 09 2 16 2 - ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
- ERROR: null value in column "name" of relation "urgent_customer" violates not-null constraint
Detail: Failing row contains (5440693, null, 825, 825, null, كتالينا, null, null, t, 2024-12-19 08:46:32.250568, 2024-12-19 08:46:32.250568, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2024-12-19 08:46:32.250568', 825, 'كتالينا', '2024-12-19 08:46:32.250568', 825) RETURNING "id"Date: 2024-12-19 09:46:32
Detail: Failing row contains (5440696, null, 825, 825, null, محمد ثابت, null, null, t, 2024-12-19 08:48:49.691815, 2024-12-19 08:48:49.691815, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2024-12-19 08:48:49.691815', 825, 'محمد ثابت', '2024-12-19 08:48:49.691815', 825) RETURNING "id"Date: 2024-12-19 09:48:49
Detail: Failing row contains (5440890, null, 822, 822, null, 01025346256, null, null, t, 2024-12-19 15:15:10.475226, 2024-12-19 15:15:10.475226, null, null).
Statement: INSERT INTO "urgent_customer" ("active", "create_date", "create_uid", "phone", "write_date", "write_uid") VALUES (true, '2024-12-19 15:15:10.475226', 822, '01025346256', '2024-12-19 15:15:10.475226', 822) RETURNING "id"Date: 2024-12-19 16:15:10
16 4 FATAL: unsupported frontend protocol 255.255: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #16
Day Hour Count Dec 19 08 1 15 1 20 1 22 1 17 4 FATAL: no PostgreSQL user name specified in startup packet
Times Reported Most Frequent Error / Event #17
Day Hour Count Dec 19 04 1 08 1 15 1 20 1 18 3 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #18
Day Hour Count Dec 19 08 1 15 2 19 3 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #19
Day Hour Count Dec 19 16 3 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 3617439 waits for ShareLock on transaction 2741894; blocked by process 3617430. Process 3617430 waits for ShareLock on transaction 2741898; blocked by process 3617439. Process 3617439: update shipping_policy set count_search=7 where id=3678340 Process 3617430: update shipping_policy set count_search=5 where id=3688586
Context: while updating tuple (80997,34) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=7 where id=3678340Date: 2024-12-19 16:27:28
Detail: Process 3675357 waits for ShareLock on transaction 2746239; blocked by process 3675158. Process 3675158 waits for ShareLock on transaction 2746182; blocked by process 3675357. Process 3675357: update shipping_policy set count_search=2 where id=3655863 Process 3675158: update shipping_policy set count_search=2 where id=3655928
Context: while updating tuple (50701,27) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=2 where id=3655863Date: 2024-12-19 16:54:12
Detail: Process 3675106 waits for ShareLock on transaction 2746888; blocked by process 3675108. Process 3675108 waits for ShareLock on transaction 2746907; blocked by process 3675106. Process 3675106: update shipping_policy set count_search=3 where id=3652230 Process 3675108: UPDATE "shipping_policy" SET "review_date" = '2024-12-19', "review_state" = 'reviewed', "write_date" = '2024-12-19 15:57:13.066529', "write_uid" = 1241 WHERE id IN (3655956, 3655954, 3655953, 3655952, 3655951, 3655926, 3654436, 3654429, 3654423, 3654415, 3654410, 3654402, 3654393, 3654387, 3654380, 3654374, 3654368, 3654363, 3654358, 3654352, 3654348, 3654345, 3654341, 3654337, 3654334, 3654330, 3654327, 3654325, 3654323, 3654321, 3654319, 3654315, 3654314, 3654312, 3654309, 3654305, 3654301, 3654298, 3654295, 3654292, 3654289, 3654286, 3654284, 3654280, 3654278, 3654275, 3654272, 3654267, 3654264, 3654260, 3654258, 3654256, 3654254, 3654252, 3654250, 3654248, 3654246, 3654244, 3654243, 3654241, 3654239, 3654236, 3654232, 3654227, 3654222, 3654219, 3654216, 3654212, 3654208, 3654204, 3654200, 3654196, 3654192, 3654188, 3654185, 3654182, 3654179, 3654175, 3654172, 3654168, 3654164, 3654161, 3654160, 3654158, 3654156, 3654153, 3654149, 3654145, 3654142, 3654138, 3654135, 3654131, 3654128, 3654123, 3654120, 365
Context: while updating tuple (60197,14) in relation "shipping_policy"
Hint: See server log for query details.
Statement: update shipping_policy set count_search=3 where id=3652230Date: 2024-12-19 16:58:52
20 3 ERROR: bigint out of range
Times Reported Most Frequent Error / Event #20
Day Hour Count Dec 19 09 3 - ERROR: bigint out of range
- ERROR: bigint out of range
- ERROR: bigint out of range
Statement: SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" != 'cancel') OR "shipping_policy"."state" IS NULL)) ORDER BY "shipping_policy"."id" DESC LIMIT 100333333333333330000
Date: 2024-12-19 09:42:08
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"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%طنطا%'))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100333333333333330000
Date: 2024-12-19 09:43:10
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"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%طنطا%'))) AND ("shipping_policy"."create_date" = '2024-12-17')))) ORDER BY "shipping_policy"."id" DESC LIMIT 100333333333333330000
Date: 2024-12-19 09:43:40
21 2 FATAL: unsupported frontend protocol 65363.19778: server supports 3.0 to 3.0
Times Reported Most Frequent Error / Event #21
Day Hour Count Dec 19 15 1 22 1 22 2 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #22
Day Hour Count Dec 19 18 2 - ERROR: could not serialize access due to concurrent delete
Statement: DELETE FROM "delegate_track" WHERE id IN (114465)
Date: 2024-12-19 18:28:15
23 1 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #23
Day Hour Count Dec 19 17 1 24 1 ERROR: invalid input syntax for type integer: ...
Times Reported Most Frequent Error / Event #24
Day Hour Count Dec 19 00 1 - ERROR: invalid input syntax for type integer: "s" at character 4571
Statement: 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"."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 ('s')
Date: 2024-12-19 00:59:42
25 1 FATAL: the database system is starting up
Times Reported Most Frequent Error / Event #25
Day Hour Count Dec 19 17 1