pgBadger-
Global information
- Generated on Sun Sep 13 23:45:50 2026
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 39,710 log entries in 49s
- Log start from 2026-09-13 02:00:10 to 2026-09-14 01:44:41
-
Overview
Global Stats
- 169 Number of unique normalized queries
- 2,265 Number of queries
- 14h14m23s Total query duration
- 2026-09-13 02:05:20 First query
- 2026-09-14 01:38:45 Last query
- 496 queries/s at 2026-09-13 10:52:24 Query peak
- 14h14m23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 14h14m23s Execute total duration
- 9,036 Number of events
- 19 Number of unique normalized events
- 5,742 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
- 2,265 Average queries per session
- 14h14m23s 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
- 496 queries/s Query Peak
- 2026-09-13 10:52:24 Date
SELECT Traffic
Key values
- 493 queries/s Query Peak
- 2026-09-13 10:52:24 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2026-09-13 11:22:22 Date
Queries duration
Key values
- 14h14m23s 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) Sep 13 02 6 0ms 1m15s 19s734ms 0ms 13s606ms 1m15s 03 2 0ms 11s69ms 10s344ms 0ms 0ms 11s69ms 04 4 0ms 11s549ms 8s18ms 0ms 0ms 32s72ms 05 3 0ms 13s438ms 6s857ms 0ms 0ms 16s808ms 06 5 0ms 3s882ms 3s692ms 0ms 3s656ms 7s606ms 07 5 0ms 5s359ms 3s914ms 0ms 5s359ms 7s403ms 08 48 0ms 14m3s 55s110ms 1m37s 5m35s 14m6s 09 165 0ms 2m54s 12s205ms 1m1s 2m41s 16m35s 10 751 0ms 1m17s 34s725ms 27s607ms 5m7s 6h14m31s 11 536 0ms 1m6s 30s690ms 12s754ms 28s119ms 4h30m19s 12 126 0ms 17s190ms 7s59ms 58s319ms 1m6s 1m30s 13 70 0ms 13s16ms 4s15ms 13s16ms 17s70ms 30s114ms 14 60 0ms 13s415ms 4s517ms 16s255ms 22s884ms 40s956ms 15 25 0ms 11s672ms 4s81ms 11s590ms 13s716ms 15s859ms 16 25 0ms 14s338ms 6s140ms 11s888ms 14s338ms 34s620ms 17 35 0ms 11s683ms 4s109ms 13s268ms 16s257ms 21s463ms 18 94 0ms 6s160ms 3s879ms 23s812ms 27s66ms 57s329ms 19 138 0ms 12s741ms 4s888ms 32s328ms 33s910ms 4m29s 20 37 0ms 10s100ms 4s868ms 15s813ms 16s119ms 57s445ms 21 53 0ms 1m55s 8s38ms 25s749ms 30s880ms 1m55s 22 25 0ms 13s82ms 4s889ms 12s879ms 16s408ms 20s383ms 23 34 0ms 9s646ms 3s986ms 12s623ms 27s386ms 30s856ms Sep 14 00 10 0ms 12s413ms 5s30ms 6s786ms 12s413ms 13s219ms 01 8 0ms 9s606ms 6s413ms 7s875ms 12s975ms 27s341ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 13 02 3 0 3s39ms 0ms 0ms 3s98ms 03 2 0 10s344ms 0ms 0ms 9s619ms 04 4 0 8s18ms 0ms 0ms 0ms 05 3 0 6s857ms 0ms 0ms 3s763ms 06 5 0 3s692ms 0ms 0ms 3s758ms 07 5 0 3s914ms 0ms 0ms 6s809ms 08 17 31 55s110ms 49s211ms 1m37s 6m40s 09 155 0 9s601ms 14s750ms 51s609ms 1m1s 10 746 0 34s663ms 4s8ms 23s955ms 6h11m9s 11 533 0 30s539ms 8s181ms 12s754ms 31s867ms 12 126 0 7s59ms 23s91ms 58s319ms 1m15s 13 70 0 4s15ms 10s390ms 13s16ms 18s70ms 14 60 0 4s517ms 8s702ms 16s255ms 40s956ms 15 25 0 4s81ms 6s880ms 11s590ms 15s859ms 16 25 0 6s140ms 3s932ms 11s888ms 34s620ms 17 35 0 4s109ms 5s100ms 13s268ms 21s463ms 18 91 0 3s819ms 10s287ms 20s612ms 57s329ms 19 137 0 4s886ms 16s187ms 32s328ms 4m24s 20 37 0 4s868ms 6s130ms 15s813ms 57s445ms 21 52 0 5s968ms 14s476ms 22s368ms 31s813ms 22 25 0 4s889ms 9s265ms 12s879ms 20s383ms 23 34 0 3s986ms 6s405ms 12s623ms 30s856ms Sep 14 00 10 0 5s30ms 0ms 6s786ms 13s219ms 01 8 0 6s413ms 0ms 7s875ms 27s341ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 13 02 0 3 0 0 36s430ms 0ms 0ms 13s606ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 10 0 52s577ms 0ms 0ms 49s859ms 10 1 2 0 0 46s498ms 0ms 0ms 14s871ms 11 2 0 0 0 53s335ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 2 0 0 0 5s443ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 1 0 0 1m55s 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 14 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 13 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% 23 0 0 0.00 0.00% Sep 14 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% Day Hour Count Average / Second Sep 13 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 23 0 0.00/s Sep 14 00 0 0.00/s 01 0 0.00/s Day Hour Count Average Duration Average idle time Sep 13 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 23 0 0ms 0ms Sep 14 00 0 0ms 0ms 01 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
- 1,016,562 buffers Checkpoint Peak
- 2026-09-13 12:39:40 Date
- 270.046 seconds Highest write time
- 0.423 seconds Sync time
Checkpoints Wal files
Key values
- 270 files Wal files usage Peak
- 2026-09-13 03:03:05 Date
Checkpoints distance
Key values
- 8,638.59 Mo Distance Peak
- 2026-09-13 03:03:05 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 13 02 699,504 2,877.271s 0.042s 2,877.455s 03 870,268 3,095.962s 0.042s 3,096.157s 04 82,745 3,029.546s 0.032s 3,029.66s 05 81,460 2,683.848s 0.04s 2,683.992s 06 38,996 2,227.825s 0.02s 2,227.907s 07 55,309 2,729.327s 0.039s 2,729.446s 08 135,407 2,969.21s 0.04s 2,969.377s 09 552,247 2,585.24s 0.041s 2,585.431s 10 852,795 1,467.35s 0.102s 1,467.677s 11 1,631,103 3,023.005s 0.532s 3,024.402s 12 3,132,829 3,239.276s 0.101s 3,239.609s 13 277,334 3,239.514s 0.042s 3,239.689s 14 253,548 2,969.79s 0.058s 2,969.907s 15 198,815 3,239.531s 0.048s 3,239.633s 16 179,672 3,239.508s 0.048s 3,239.611s 17 202,810 2,969.11s 0.063s 2,969.236s 18 286,141 3,239.549s 0.06s 3,239.718s 19 289,979 3,239.458s 0.067s 3,239.605s 20 237,025 2,969.468s 0.062s 2,969.59s 21 1,139,762 3,036.9s 0.1s 3,037.377s 22 190,631 3,239.463s 0.039s 3,239.647s 23 190,237 3,189.547s 0.068s 3,189.779s Sep 14 00 132,934 3,239.534s 0.035s 3,239.679s 01 82,693 2,429.575s 0.028s 2,429.677s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 13 02 0 3 308 3,001 0.010s 0.012s 03 0 22 333 2,375 0.002s 0.012s 04 0 27 0 2,283 0.002s 0.012s 05 0 31 0 1,984 0.006s 0.012s 06 0 17 0 1,317 0.002s 0.01s 07 0 22 0 1,985 0.009s 0.012s 08 0 48 0 2,962 0.006s 0.012s 09 0 55 0 2,917 0.003s 0.012s 10 0 23 622 2,000 0.058s 0.015s 11 0 353 343 4,430 0.421s 0.015s 12 0 7 799 5,385 0.003s 0.012s 13 0 38 92 4,868 0.003s 0.012s 14 0 0 105 5,094 0.004s 0.012s 15 0 0 79 4,950 0.002s 0.012s 16 0 0 75 4,947 0.003s 0.012s 17 0 0 84 4,970 0.006s 0.012s 18 0 0 116 5,208 0.004s 0.012s 19 0 0 123 5,389 0.003s 0.012s 20 0 0 99 5,043 0.007s 0.012s 21 0 80 554 4,410 0.008s 0.012s 22 0 77 0 4,306 0.002s 0.012s 23 0 75 0 4,766 0.011s 0.013s Sep 14 00 0 45 0 3,753 0.002s 0.012s 01 0 34 0 2,690 0.002s 0.009s Day Hour Count Avg time (sec) Sep 13 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 23 0 0s Sep 14 00 0 0s 01 0 0s Day Hour Mean distance Mean estimate Sep 13 02 424,604.33 kB 453,124.50 kB 03 485,393.42 kB 2,717,543.08 kB 04 36,415.83 kB 796,383.42 kB 05 43,204.17 kB 104,967.92 kB 06 26,863.20 kB 70,163.20 kB 07 30,673.67 kB 57,984.17 kB 08 64,667.58 kB 85,484.00 kB 09 75,758.00 kB 137,610.08 kB 10 459,736.50 kB 1,021,155.57 kB 11 876,817.38 kB 1,385,902.38 kB 12 1,100,583.25 kB 1,303,829.00 kB 13 177,972.08 kB 907,330.33 kB 14 143,451.33 kB 208,686.67 kB 15 106,937.67 kB 164,119.00 kB 16 102,748.58 kB 138,538.08 kB 17 115,251.08 kB 129,478.67 kB 18 158,458.83 kB 173,232.42 kB 19 167,226.50 kB 250,145.25 kB 20 135,268.92 kB 199,042.17 kB 21 865,793.25 kB 2,299,120.75 kB 22 105,478.67 kB 1,407,335.75 kB 23 93,953.23 kB 212,969.08 kB Sep 14 00 61,913.33 kB 110,323.83 kB 01 61,771.00 kB 98,917.56 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Sep 13 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 23 0 0 0 Sep 14 00 0 0 0 01 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
Vacuum throughput per table
Key values
- unknown (0) Max CPU elapsed for vacuum on database
- unknown (0 ms) Max I/O read time for vacuum on database
- unknown (0 ms) Max I/O write time for vacuum on database
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 Sep 13 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 23 0 0 Sep 14 00 0 0 01 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
- 2,208 Total read queries
- 57 Total write queries
Queries by database
Key values
- unknown Main database
- 2,265 Requests
- 14h14m23s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 2,265 Requests
User Request type Count Duration unknown Total 2,265 14h14m23s copy to 31 42m27s ddl 5 2m38s delete 10 8m45s insert 5 2m12s select 2,208 13h12m30s update 6 5m49s Duration by user
Key values
- 14h14m23s (unknown) Main time consuming user
User Request type Count Duration unknown Total 2,265 14h14m23s copy to 31 42m27s ddl 5 2m38s delete 10 8m45s insert 5 2m12s select 2,208 13h12m30s update 6 5m49s Queries by host
Key values
- unknown Main host
- 2,265 Requests
- 14h14m23s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 2,265 Requests
- 14h14m23s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-13 23:20:11 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,256 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 14m3s COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout;[ Date: 2026-09-13 08:26:21 ]
2 6m40s COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout;[ Date: 2026-09-13 08:33:05 ]
3 5m15s COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout;[ Date: 2026-09-13 08:44:59 ]
4 3m59s COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout;[ Date: 2026-09-13 08:38:52 ]
5 3m14s COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;[ Date: 2026-09-13 08:06:22 ]
6 2m54s DELETE FROM "res_users" WHERE id IN (2023);[ Date: 2026-09-13 09:14:16 ]
7 2m41s DELETE FROM "res_users" WHERE id IN (2027);[ Date: 2026-09-13 09:17:43 ]
8 1m55s update cash_policy set is_more_year = 't' where archive_date is not null and archive_date < (NOW() - INTERVAL '1 year');[ Date: 2026-09-13 21:21:34 ]
9 1m17s UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');[ Date: 2026-09-13 10:52:24 ]
10 1m17s ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";[ Date: 2026-09-13 10:52:24 ]
11 1m17s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 939;[ Date: 2026-09-13 10:52:24 ]
12 1m16s SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);[ Date: 2026-09-13 10:52:24 ]
13 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1044;[ Date: 2026-09-13 10:52:24 ]
14 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1830;[ Date: 2026-09-13 10:52:24 ]
15 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1837;[ Date: 2026-09-13 10:52:24 ]
16 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1364;[ Date: 2026-09-13 10:52:24 ]
17 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1363;[ Date: 2026-09-13 10:52:24 ]
18 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 827;[ Date: 2026-09-13 10:52:24 ]
19 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1041;[ Date: 2026-09-13 10:52:24 ]
20 1m16s SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1775;[ Date: 2026-09-13 10:52:24 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 6h41m18s 535 3s124ms 1m16s 45s6ms select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 09 1 12s654ms 12s654ms 10 296 4h1m46s 49s8ms 11 238 2h39m19s 40s165ms -
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004724, 8009365, 8012095, 8008687, 8012079, 8008589, 8007322, 8011722, 8009366, 8011200, 8006416, 8004701, 8011296, 8010529) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8011893, 8012567, 8007226, 8010689, 8010372, 8012449, 8010214, 8012044) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004702, 8004708, 8004681, 8004661, 8004705, 8004686, 8004673, 8011535, 8004688, 8006361, 8004692, 8006343, 8004667, 8009171, 8006435, 8004805, 8006313, 8004691, 8012106, 8012080, 8004671, 8004703, 8010403, 8008167, 8004677, 8011623, 8012448, 8004652, 8004695, 8006342, 8004715, 8011934, 8004653, 8006416, 8008778, 8004701, 8007744, 8012066, 8011945, 8012077, 8011615, 8004672, 8004687, 8004693, 8011723, 8008777, 8010754, 8009731, 8004704) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
2 3h5m58s 290 3s64ms 1m17s 38s478ms select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 09 82 15m53s 11s624ms 10 161 2h5m19s 46s701ms 11 47 44m46s 57s158ms -
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 939;
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1044;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1830;
Date: 2026-09-13 10:52:24 Duration: 1m16s
3 1h53m45s 430 3s160ms 1m16s 15s874ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 09 1 12s635ms 12s635ms 10 229 54m7s 14s181ms 11 200 59m25s 17s828ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
4 14m51s 111 7s183ms 8s889ms 8s31ms select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 13 08 2 14s921ms 7s460ms 09 49 6m13s 7s613ms 12 60 8m23s 8s391ms -
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23936961, 23947700, 23848415);
Date: 2026-09-13 12:13:35 Duration: 8s889ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23837406, 23355483, 24026620, 23943208, 23843670, 23932250, 23796166, 23940368, 23971530, 23516757, 23834864, 23962110, 23761271, 23874229, 23965269, 23860956, 23943458, 23759366, 23927513, 23790389);
Date: 2026-09-13 12:14:20 Duration: 8s840ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23960367, 23961928, 23922223, 23780154, 23494267, 23889647, 23891929, 23867837, 23393532, 23940975, 23565359, 23581837, 23961631, 23930164, 23966774, 23682243, 23837773, 23966583, 23634151, 23429621, 23736600);
Date: 2026-09-13 12:12:51 Duration: 8s774ms
5 14m3s 1 14m3s 14m3s 14m3s copy public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 13 08 1 14m3s 14m3s -
COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout;
Date: 2026-09-13 08:26:21 Duration: 14m3s
6 13m6s 222 3s 7s514ms 3s542ms 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 #6
Day Hour Count Duration Avg duration Sep 13 02 3 9s117ms 3s39ms 11 6 21s210ms 3s535ms 12 10 33s559ms 3s355ms 13 11 37s804ms 3s436ms 14 5 19s17ms 3s803ms 15 4 13s716ms 3s429ms 16 4 12s902ms 3s225ms 17 11 36s29ms 3s275ms 18 61 3m52s 3s817ms 19 39 2m35s 3s982ms 20 19 1m 3s168ms 21 8 25s42ms 3s130ms 22 18 56s768ms 3s153ms 23 21 1m6s 3s178ms Sep 14 00 1 3s9ms 3s9ms 01 1 3s113ms 3s113ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (55))))))) 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 (55)))))) 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 (55)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (55)))))) 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 (55))))))))) 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 (55)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:29:27 Duration: 7s514ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (70))))))) 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 (70)))))) 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 (70)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))))) 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 (70))))))))) 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 (70)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:25:21 Duration: 6s758ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 14:50:47 Duration: 5s258ms
7 6m40s 1 6m40s 6m40s 6m40s copy public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 13 08 1 6m40s 6m40s -
COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout;
Date: 2026-09-13 08:33:05 Duration: 6m40s
8 5m35s 2 2m41s 2m54s 2m47s delete from "res_users" where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 13 09 2 5m35s 2m47s -
DELETE FROM "res_users" WHERE id IN (2023);
Date: 2026-09-13 09:14:16 Duration: 2m54s
-
DELETE FROM "res_users" WHERE id IN (2027);
Date: 2026-09-13 09:17:43 Duration: 2m41s
9 5m15s 1 5m15s 5m15s 5m15s copy public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 13 08 1 5m15s 5m15s -
COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout;
Date: 2026-09-13 08:44:59 Duration: 5m15s
10 5m3s 41 6s558ms 8s243ms 7s390ms select name from shipping_policy order by create_date desc limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 13 10 41 5m3s 7s390ms -
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s243ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s128ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s126ms
11 4m31s 34 4s757ms 10s457ms 7s994ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 13 16 3 30s824ms 10s274ms 20 13 1m31s 7s42ms 21 16 2m14s 8s397ms 23 2 15s97ms 7s548ms -
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%176874%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s457ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%1768742%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:43 Duration: 10s196ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%17687422%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s171ms
12 4m19s 21 3s284ms 17s190ms 12s368ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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"."policy_id" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 13 12 10 2m20s 14s55ms 14 1 13s54ms 13s54ms 15 1 11s672ms 11s672ms 21 2 28s590ms 14s295ms 22 5 58s607ms 11s721ms 23 2 7s255ms 3s627ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:19:14 Duration: 17s190ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (80)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 21:46:21 Duration: 15s228ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:49:09 Duration: 14s816ms
13 3m59s 1 3m59s 3m59s 3m59s copy public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 13 08 1 3m59s 3m59s -
COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout;
Date: 2026-09-13 08:38:52 Duration: 3m59s
14 3m14s 1 3m14s 3m14s 3m14s copy public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 08 1 3m14s 3m14s -
COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;
Date: 2026-09-13 08:06:22 Duration: 3m14s
15 3m12s 25 4s961ms 12s268ms 7s716ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 13 11 4 31s867ms 7s966ms 19 5 46s352ms 9s270ms 21 6 41s359ms 6s893ms 23 5 30s856ms 6s171ms Sep 14 00 1 9s352ms 9s352ms 01 4 33s134ms 8s283ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%186290%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 12s268ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%1862907%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 11s985ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%1849958%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 11:31:08 Duration: 11s841ms
16 3m1s 3 53s567ms 1m5s 1m select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 13 11 3 3m1s 1m -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (939);
Date: 2026-09-13 11:22:22 Duration: 1m5s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (854);
Date: 2026-09-13 11:22:22 Duration: 1m2s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (1940);
Date: 2026-09-13 11:22:22 Duration: 53s567ms
17 2m26s 3 3s651ms 1m17s 48s931ms alter table "res_users" drop constraint "res_users_login_key";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 13 10 2 1m20s 40s364ms 11 1 1m6s 1m6s -
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 11:22:22 Duration: 1m6s
-
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 10:46:24 Duration: 3s651ms
18 2m13s 12 8s950ms 12s741ms 11s106ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (("shipping_policy"."customer_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))) or ("shipping_policy"."customer_receive_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))))) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 13 04 2 22s831ms 11s415ms 10 1 11s975ms 11s975ms 11 4 42s398ms 10s599ms 12 1 11s818ms 11s818ms 17 1 11s683ms 11s683ms 19 1 12s741ms 12s741ms 20 1 8s950ms 8s950ms 21 1 10s877ms 10s877ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 19:15:15 Duration: 12s741ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 10:37:23 Duration: 11s975ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 12:15:28 Duration: 11s818ms
19 2m4s 2 47s326ms 1m17s 1m2s update ir_module_module set state = ? where state in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 13 10 2 2m4s 1m2s -
UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');
Date: 2026-09-13 10:52:24 Duration: 47s326ms
20 1m55s 2 53s619ms 1m2s 57s968ms select "res_users".id from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 13 10 1 1m2s 1m2s 11 1 53s619ms 53s619ms -
SELECT "res_users".id FROM "res_users" WHERE "res_users".id IN (1572);
Date: 2026-09-13 10:52:24 Duration: 1m2s
-
SELECT "res_users".id FROM "res_users" WHERE "res_users".id IN (1940);
Date: 2026-09-13 11:22:22 Duration: 53s619ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 535 6h41m18s 3s124ms 1m16s 45s6ms select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 09 1 12s654ms 12s654ms 10 296 4h1m46s 49s8ms 11 238 2h39m19s 40s165ms -
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004724, 8009365, 8012095, 8008687, 8012079, 8008589, 8007322, 8011722, 8009366, 8011200, 8006416, 8004701, 8011296, 8010529) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8011893, 8012567, 8007226, 8010689, 8010372, 8012449, 8010214, 8012044) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004702, 8004708, 8004681, 8004661, 8004705, 8004686, 8004673, 8011535, 8004688, 8006361, 8004692, 8006343, 8004667, 8009171, 8006435, 8004805, 8006313, 8004691, 8012106, 8012080, 8004671, 8004703, 8010403, 8008167, 8004677, 8011623, 8012448, 8004652, 8004695, 8006342, 8004715, 8011934, 8004653, 8006416, 8008778, 8004701, 8007744, 8012066, 8011945, 8012077, 8011615, 8004672, 8004687, 8004693, 8011723, 8008777, 8010754, 8009731, 8004704) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
2 430 1h53m45s 3s160ms 1m16s 15s874ms select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 09 1 12s635ms 12s635ms 10 229 54m7s 14s181ms 11 200 59m25s 17s828ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
3 290 3h5m58s 3s64ms 1m17s 38s478ms select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 09 82 15m53s 11s624ms 10 161 2h5m19s 46s701ms 11 47 44m46s 57s158ms -
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 939;
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1044;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1830;
Date: 2026-09-13 10:52:24 Duration: 1m16s
4 222 13m6s 3s 7s514ms 3s542ms 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 Sep 13 02 3 9s117ms 3s39ms 11 6 21s210ms 3s535ms 12 10 33s559ms 3s355ms 13 11 37s804ms 3s436ms 14 5 19s17ms 3s803ms 15 4 13s716ms 3s429ms 16 4 12s902ms 3s225ms 17 11 36s29ms 3s275ms 18 61 3m52s 3s817ms 19 39 2m35s 3s982ms 20 19 1m 3s168ms 21 8 25s42ms 3s130ms 22 18 56s768ms 3s153ms 23 21 1m6s 3s178ms Sep 14 00 1 3s9ms 3s9ms 01 1 3s113ms 3s113ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (55))))))) 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 (55)))))) 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 (55)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (55)))))) 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 (55))))))))) 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 (55)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:29:27 Duration: 7s514ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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 (70))))))) 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 (70)))))) 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 (70)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))))) 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 (70))))))))) 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 (70)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:25:21 Duration: 6s758ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."active" = true) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))) AND ("policy_number"."done" IS NULL or "policy_number"."done" = false)) AND ("policy_number"."damaged" IS NULL or "policy_number"."damaged" = false)) AND (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) OR (("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39))))))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 14:50:47 Duration: 5s258ms
5 111 14m51s 7s183ms 8s889ms 8s31ms select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 13 08 2 14s921ms 7s460ms 09 49 6m13s 7s613ms 12 60 8m23s 8s391ms -
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23936961, 23947700, 23848415);
Date: 2026-09-13 12:13:35 Duration: 8s889ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23837406, 23355483, 24026620, 23943208, 23843670, 23932250, 23796166, 23940368, 23971530, 23516757, 23834864, 23962110, 23761271, 23874229, 23965269, 23860956, 23943458, 23759366, 23927513, 23790389);
Date: 2026-09-13 12:14:20 Duration: 8s840ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23960367, 23961928, 23922223, 23780154, 23494267, 23889647, 23891929, 23867837, 23393532, 23940975, 23565359, 23581837, 23961631, 23930164, 23966774, 23682243, 23837773, 23966583, 23634151, 23429621, 23736600);
Date: 2026-09-13 12:12:51 Duration: 8s774ms
6 41 5m3s 6s558ms 8s243ms 7s390ms select name from shipping_policy order by create_date desc limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 13 10 41 5m3s 7s390ms -
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s243ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s128ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s126ms
7 34 4m31s 4s757ms 10s457ms 7s994ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 13 16 3 30s824ms 10s274ms 20 13 1m31s 7s42ms 21 16 2m14s 8s397ms 23 2 15s97ms 7s548ms -
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%176874%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s457ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%1768742%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:43 Duration: 10s196ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%17687422%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s171ms
8 33 1m53s 3s9ms 4s530ms 3s447ms 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") left join "urgent_office" AS "cash_policy__from_office" on ("cash_policy"."from_office" = "cash_policy__from_office"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."policy_id", "cash_policy"."create_date_policy" asc, "cash_policy__from_office"."new_code" asc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 13 13 17 56s463ms 3s321ms 14 16 57s293ms 3s580ms -
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") LEFT JOIN "urgent_office" AS "cash_policy__from_office" ON ("cash_policy"."from_office" = "cash_policy__from_office"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23))))) 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"."policy_id", "cash_policy"."create_date_policy" ASC, "cash_policy__from_office"."new_code" ASC LIMIT 200;
Date: 2026-09-13 14:00:56 Duration: 4s530ms
-
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") LEFT JOIN "urgent_office" AS "cash_policy__from_office" ON ("cash_policy"."from_office" = "cash_policy__from_office"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23))))) 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"."policy_id", "cash_policy"."create_date_policy" ASC, "cash_policy__from_office"."new_code" ASC LIMIT 200;
Date: 2026-09-13 14:08:09 Duration: 4s201ms
-
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") LEFT JOIN "urgent_office" AS "cash_policy__from_office" ON ("cash_policy"."from_office" = "cash_policy__from_office"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (23))))) 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"."policy_id", "cash_policy"."create_date_policy" ASC, "cash_policy__from_office"."new_code" ASC LIMIT 200;
Date: 2026-09-13 14:07:09 Duration: 4s44ms
9 25 3m12s 4s961ms 12s268ms 7s716ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 13 11 4 31s867ms 7s966ms 19 5 46s352ms 9s270ms 21 6 41s359ms 6s893ms 23 5 30s856ms 6s171ms Sep 14 00 1 9s352ms 9s352ms 01 4 33s134ms 8s283ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%186290%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 12s268ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%1862907%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 11s985ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%1849958%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 11:31:08 Duration: 11s841ms
10 24 1m33s 3s218ms 4s375ms 3s876ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."name"::text ilike ?))))) 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 limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 13 09 3 10s885ms 3s628ms 11 3 11s90ms 3s696ms 12 6 23s615ms 3s935ms 13 3 11s801ms 3s933ms 14 8 31s701ms 3s962ms 15 1 3s934ms 3s934ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%ارض%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (106)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) 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: 2026-09-13 14:49:54 Duration: 4s375ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%ارض%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (106)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (67))))) 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: 2026-09-13 14:49:20 Duration: 4s173ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%كفر الشيخ%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (56)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (16)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (16))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (16))))) 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: 2026-09-13 12:51:00 Duration: 4s127ms
11 21 4m19s 3s284ms 17s190ms 12s368ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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"."policy_id" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 13 12 10 2m20s 14s55ms 14 1 13s54ms 13s54ms 15 1 11s672ms 11s672ms 21 2 28s590ms 14s295ms 22 5 58s607ms 11s721ms 23 2 7s255ms 3s627ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:19:14 Duration: 17s190ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (80)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 21:46:21 Duration: 15s228ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:49:09 Duration: 14s816ms
12 21 1m12s 3s17ms 4s49ms 3s431ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."policy_id" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 13 11 1 3s363ms 3s363ms 13 2 7s202ms 3s601ms 14 6 21s30ms 3s505ms 15 1 3s952ms 3s952ms 16 2 6s571ms 3s285ms 18 9 29s944ms 3s327ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))) 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"."policy_id" LIMIT 200;
Date: 2026-09-13 13:07:59 Duration: 4s49ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (11))))) 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"."policy_id" LIMIT 200;
Date: 2026-09-13 15:44:08 Duration: 3s952ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (17))))) 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"."policy_id" LIMIT 200;
Date: 2026-09-13 14:59:06 Duration: 3s838ms
13 21 1m7s 3s32ms 3s908ms 3s228ms select "cash_policy".id from "cash_policy" left join "policy_number" AS "cash_policy__policy_id" on ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") where (("cash_policy"."active" = true) and (("cash_policy"."state" != ?) or "cash_policy"."state" is null)) and ((("cash_policy"."from_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) or ("cash_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))) or ("cash_policy__policy_id"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true)))))) order by "cash_policy"."name" asc limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 13 08 1 3s548ms 3s548ms 10 1 3s334ms 3s334ms 11 1 3s32ms 3s32ms 17 3 9s371ms 3s123ms 18 5 16s849ms 3s369ms 19 9 28s576ms 3s175ms 21 1 3s88ms 3s88ms -
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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"."name" ASC LIMIT 200;
Date: 2026-09-13 18:57:50 Duration: 3s908ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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"."name" ASC LIMIT 200;
Date: 2026-09-13 19:28:32 Duration: 3s565ms
-
SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND (("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL)) AND ((("cash_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (85))))) 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"."name" ASC LIMIT 200;
Date: 2026-09-13 08:31:34 Duration: 3s548ms
14 17 1m32s 3s655ms 12s754ms 5s425ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."state" = ?))) 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 limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 11 5 30s663ms 6s132ms 12 3 22s317ms 7s439ms 13 5 22s306ms 4s461ms 14 2 8s81ms 4s40ms 15 1 3s989ms 3s989ms 19 1 4s865ms 4s865ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (96)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) 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: 2026-09-13 11:42:03 Duration: 12s754ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_way'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (53, 54)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78))))) 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: 2026-09-13 12:42:54 Duration: 11s792ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (96)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) 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: 2026-09-13 12:34:21 Duration: 6s705ms
15 16 1m11s 3s561ms 7s238ms 4s466ms select "policy_number".id from "policy_number" where (("policy_number"."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"."office_id" in (...)))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 13 08 1 4s640ms 4s640ms 10 4 16s520ms 4s130ms 11 3 14s129ms 4s709ms 12 2 7s730ms 3s865ms 13 4 16s488ms 4s122ms 14 1 4s714ms 4s714ms 17 1 7s238ms 7s238ms -
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (24, 110)))) ORDER BY "policy_number"."id" LIMIT 80;
Date: 2026-09-13 17:07:09 Duration: 7s238ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (27)))) ORDER BY "policy_number"."id" LIMIT 80;
Date: 2026-09-13 10:42:11 Duration: 5s167ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (("policy_number"."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"."office_id" in (78, 69)))) ORDER BY "policy_number"."id" LIMIT 80;
Date: 2026-09-13 11:25:09 Duration: 5s53ms
16 15 58s538ms 3s606ms 4s870ms 3s902ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."to_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."name"::text ilike ?))))) 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 limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 13 09 2 7s550ms 3s775ms 11 2 7s849ms 3s924ms 12 1 3s798ms 3s798ms 13 1 3s852ms 3s852ms 14 2 7s797ms 3s898ms 16 2 7s572ms 3s786ms 17 2 7s954ms 3s977ms 19 1 4s870ms 4s870ms 21 2 7s293ms 3s646ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%وسط البلد%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (102)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (62))))) 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: 2026-09-13 19:26:29 Duration: 4s870ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%الاقصر%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (88)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41))))) 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: 2026-09-13 17:41:40 Duration: 4s75ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%شبين القنأطر%'))))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (99)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (46))))) 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: 2026-09-13 11:29:31 Duration: 3s941ms
17 15 56s852ms 3s222ms 4s180ms 3s790ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (("shipping_policy"."state" = ?) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and (("shipping_policy"."last_warehouse" in ( select "urgent_warehouse".id from "urgent_warehouse" where ("urgent_warehouse"."name"::text ilike ?))) or ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."name"::text ilike ?))))))) 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))))) or (("shipping_policy"."state" in (...)) and ("shipping_policy"."last_office" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 13 08 1 3s678ms 3s678ms 12 2 7s427ms 3s713ms 14 5 19s250ms 3s850ms 15 7 26s496ms 3s785ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'in_way') AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."name"::text ilike '%الزقازيق%'))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%الزقازيق%'))))))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-13 15:22:13 Duration: 4s180ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'in_way') AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."name"::text ilike '%الزقازيق%'))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%الزقازيق%'))))))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-13 14:05:20 Duration: 4s175ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."state" = 'in_way') AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."name"::text ilike '%الزقازيق%'))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."name"::text ilike '%الزقازيق%'))))))) AND ((("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (64)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19))))) 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))))) OR (("shipping_policy"."state" in ('in_way_to_client', 'wating')) AND ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (19)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-13 15:41:18 Duration: 4s85ms
18 13 1m1s 3s82ms 6s396ms 4s754ms 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"."is_company" AS "is_company", "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", "urgent_customer"."user_id" AS "user_id" from "urgent_customer" where "urgent_customer".id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 13 10 6 31s102ms 5s183ms 19 7 30s702ms 4s386ms -
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"."is_company" AS "is_company", "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", "urgent_customer"."user_id" AS "user_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (11777029, 9619947, 11735924);
Date: 2026-09-13 10:52:36 Duration: 6s396ms
-
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"."is_company" AS "is_company", "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", "urgent_customer"."user_id" AS "user_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (11777029, 9619947, 11735924);
Date: 2026-09-13 10:52:36 Duration: 6s175ms
-
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"."is_company" AS "is_company", "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", "urgent_customer"."user_id" AS "user_id" FROM "urgent_customer" WHERE "urgent_customer".id IN (11777029, 9619947, 11735924);
Date: 2026-09-13 10:52:36 Duration: 5s963ms
19 13 50s876ms 3s217ms 4s857ms 3s913ms 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 13 16 1 3s796ms 3s796ms 20 1 4s857ms 4s857ms 21 9 33s284ms 3s698ms 23 2 8s938ms 4s469ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28)))))) AND ("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" LIMIT 8;
Date: 2026-09-13 20:39:53 Duration: 4s857ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78)))))) AND ("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" LIMIT 8;
Date: 2026-09-13 23:14:46 Duration: 4s825ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78)))))) AND ("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" LIMIT 8;
Date: 2026-09-13 23:14:48 Duration: 4s112ms
20 12 2m13s 8s950ms 12s741ms 11s106ms select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (("shipping_policy"."customer_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))) or ("shipping_policy"."customer_receive_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))))) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 13 04 2 22s831ms 11s415ms 10 1 11s975ms 11s975ms 11 4 42s398ms 10s599ms 12 1 11s818ms 11s818ms 17 1 11s683ms 11s683ms 19 1 12s741ms 12s741ms 20 1 8s950ms 8s950ms 21 1 10s877ms 10s877ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 19:15:15 Duration: 12s741ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 10:37:23 Duration: 11s975ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 12:15:28 Duration: 11s818ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 14m3s 14m3s 14m3s 1 14m3s copy public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 13 08 1 14m3s 14m3s -
COPY public.mail_message (id, parent_id, res_id, subtype_id, mail_activity_type_id, author_id, author_guest_id, mail_server_id, create_uid, write_uid, subject, model, record_name, message_type, email_from, message_id, reply_to, email_layout_xmlid, body, is_internal, reply_to_force_new, email_add_signature, date, create_date, write_date) TO stdout;
Date: 2026-09-13 08:26:21 Duration: 14m3s
2 6m40s 6m40s 6m40s 1 6m40s copy public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 13 08 1 6m40s 6m40s -
COPY public.mail_tracking_value (id, field, old_value_integer, new_value_integer, currency_id, mail_message_id, tracking_sequence, create_uid, write_uid, field_desc, field_type, old_value_char, new_value_char, old_value_text, new_value_text, old_value_datetime, new_value_datetime, create_date, write_date, old_value_float, old_value_monetary, new_value_float, new_value_monetary) TO stdout;
Date: 2026-09-13 08:33:05 Duration: 6m40s
3 5m15s 5m15s 5m15s 1 5m15s copy public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 13 08 1 5m15s 5m15s -
COPY public.shipping_track (id, office_id, state_id, warehouse_id, next_office_id, next_warehouse_id, car_id, delegate_id, driver_id, user_id, shipping_id, cash_policy_id, create_uid, write_uid, state, receive_man_id_no, receive_man_id, action_date, change_date, create_date, write_date, supervious_ids) TO stdout;
Date: 2026-09-13 08:44:59 Duration: 5m15s
4 3m59s 3m59s 3m59s 1 3m59s copy public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 13 08 1 3m59s 3m59s -
COPY public.shipping_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, office_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, cash_policy_id, last_driver, last_office, last_car, last_office_warehouse, last_warehouse, destination_office, total_no_items, cancel_shipping_policy, create_uid, write_uid, search_name, name, pol_name, state, review_state, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, return_reason, wating_reason, scan_code, destination_type, state_collection, paid_by_customer, last_action, confirm_date, client_date, archive_date, cancel_date, return_date, wating_date, create_date, active, cash, cheques, total_collection_amount, new_destination_button, edit_cash_button, create_cash_policy_button, client_delivery_button, return_button, delegate_button, old_policy, review_date, write_date, total_amount_cash_lines, cash_amount, collection_amount_sender, collection_amount_receive, total_shipping_price, v_10_id, driver_id, delegate_id, out_date, attachment_date, count_search, notes, return_before, from_poilcy, x_from_poilcy, before_office_id, policy_name, x_review_date, state_id, attachment_user, d_date, d_unlink_delete, zero_date_change, zero_date_change_user, is_change_cash_price, transfer_date, is_imported, client_delivery_user, cash_amount_written, total_shipping_price_written, review_state_department, review_date_department, in_office_date, x_state_hold, x_date_sales, delivery_method_id, x_is_color, x_sales_move_date, x_return_office_id, privous_last_office, privous_last_warehouse, supervious_ids, x_direction_name, x_count_delivery, x_total_shipping_price, x_collection_amount_sender, x_collection_amount_receive, x_total_amount_cash_lines, x_total_shipping_price_written, x_collection_amount_left, x_cash_amount_written, x_is_block_delievery, x_is_update, x_is_inventory, delay_reason_id, return_reason_id, date_sales_policy, is_color_policy, sale_policy_id, x_date_hold, inventory_id, inventory_date) TO stdout;
Date: 2026-09-13 08:38:52 Duration: 3m59s
5 3m14s 3m14s 3m14s 1 3m14s copy public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 13 08 1 3m14s 3m14s -
COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;
Date: 2026-09-13 08:06:22 Duration: 3m14s
6 2m41s 2m54s 2m47s 2 5m35s delete from "res_users" where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 13 09 2 5m35s 2m47s -
DELETE FROM "res_users" WHERE id IN (2023);
Date: 2026-09-13 09:14:16 Duration: 2m54s
-
DELETE FROM "res_users" WHERE id IN (2027);
Date: 2026-09-13 09:17:43 Duration: 2m41s
7 47s326ms 1m17s 1m2s 2 2m4s update ir_module_module set state = ? where state in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 13 10 2 2m4s 1m2s -
UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
UPDATE ir_module_module SET state = 'installed' WHERE state IN ('to remove', 'to upgrade');
Date: 2026-09-13 10:52:24 Duration: 47s326ms
8 53s567ms 1m5s 1m 3 3m1s select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 13 11 3 3m1s 1m -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (939);
Date: 2026-09-13 11:22:22 Duration: 1m5s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (854);
Date: 2026-09-13 11:22:22 Duration: 1m2s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id" FROM "res_users" WHERE "res_users".id IN (1940);
Date: 2026-09-13 11:22:22 Duration: 53s567ms
9 53s619ms 1m2s 57s968ms 2 1m55s select "res_users".id from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 13 10 1 1m2s 1m2s 11 1 53s619ms 53s619ms -
SELECT "res_users".id FROM "res_users" WHERE "res_users".id IN (1572);
Date: 2026-09-13 10:52:24 Duration: 1m2s
-
SELECT "res_users".id FROM "res_users" WHERE "res_users".id IN (1940);
Date: 2026-09-13 11:22:22 Duration: 53s619ms
10 3s651ms 1m17s 48s931ms 3 2m26s alter table "res_users" drop constraint "res_users_login_key";Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 13 10 2 1m20s 40s364ms 11 1 1m6s 1m6s -
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 11:22:22 Duration: 1m6s
-
ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key";
Date: 2026-09-13 10:46:24 Duration: 3s651ms
11 3s124ms 1m16s 45s6ms 535 6h41m18s select u.partner_id as id, case when max(b.last_poll) is null then ? when age(now() at time zone ?, max(b.last_poll)) > interval ? then ? when age(now() at time zone ?, max(b.last_presence)) > interval ? then ? else ? end as status from bus_presence b right join res_users u on b.user_id = u.id where u.partner_id in (...) and u.active = ? group by u.partner_id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 13 09 1 12s654ms 12s654ms 10 296 4h1m46s 49s8ms 11 238 2h39m19s 40s165ms -
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004724, 8009365, 8012095, 8008687, 8012079, 8008589, 8007322, 8011722, 8009366, 8011200, 8006416, 8004701, 8011296, 8010529) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8011893, 8012567, 8007226, 8010689, 8010372, 8012449, 8010214, 8012044) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT U.partner_id as id, CASE WHEN max(B.last_poll) IS NULL THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_poll)) > interval '65 seconds' THEN 'offline' WHEN age(now() AT TIME ZONE 'UTC', max(B.last_presence)) > interval '1800 seconds' THEN 'away' ELSE 'online' END as status FROM bus_presence B RIGHT JOIN res_users U ON B.user_id = U.id WHERE U.partner_id IN (2, 8004702, 8004708, 8004681, 8004661, 8004705, 8004686, 8004673, 8011535, 8004688, 8006361, 8004692, 8006343, 8004667, 8009171, 8006435, 8004805, 8006313, 8004691, 8012106, 8012080, 8004671, 8004703, 8010403, 8008167, 8004677, 8011623, 8012448, 8004652, 8004695, 8006342, 8004715, 8011934, 8004653, 8006416, 8008778, 8004701, 8007744, 8012066, 8011945, 8012077, 8011615, 8004672, 8004687, 8004693, 8011723, 8008777, 8010754, 8009731, 8004704) AND U.active = 't' GROUP BY U.partner_id;
Date: 2026-09-13 10:52:24 Duration: 1m16s
12 3s64ms 1m17s 38s478ms 290 3h5m58s select active, id, login, password, totp_secret, ( select value from ir_config_parameter where key = ?) from res_users where id = ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 13 09 82 15m53s 11s624ms 10 161 2h5m19s 46s701ms 11 47 44m46s 57s158ms -
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 939;
Date: 2026-09-13 10:52:24 Duration: 1m17s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1044;
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT active, id, login, password, totp_secret, ( SELECT value FROM ir_config_parameter WHERE key = 'database.secret') FROM res_users WHERE id = 1830;
Date: 2026-09-13 10:52:24 Duration: 1m16s
13 3s160ms 1m16s 15s874ms 430 1h53m45s select "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" from "res_users" where "res_users".id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 13 09 1 12s635ms 12s635ms 10 229 54m7s 14s181ms 11 200 59m25s 17s828ms -
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
-
SELECT "res_users"."id" AS "id", "res_users"."partner_id" AS "partner_id", "res_users"."login" AS "login", "res_users"."signature" AS "signature", "res_users"."active" AS "active", "res_users"."action_id" AS "action_id", "res_users"."share" AS "share", "res_users"."company_id" AS "company_id", "res_users"."create_uid" AS "create_uid", "res_users"."create_date" AS "create_date", "res_users"."write_uid" AS "write_uid", "res_users"."write_date" AS "write_date", "res_users"."notification_type" AS "notification_type", "res_users"."odoobot_state" AS "odoobot_state", "res_users"."odoobot_failed" AS "odoobot_failed", "res_users"."website_id" AS "website_id" FROM "res_users" WHERE "res_users".id IN (4);
Date: 2026-09-13 10:52:24 Duration: 1m16s
14 3s284ms 17s190ms 12s368ms 21 4m19s select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and ((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false))) 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"."policy_id" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 13 12 10 2m20s 14s55ms 14 1 13s54ms 13s54ms 15 1 11s672ms 11s672ms 21 2 28s590ms 14s295ms 22 5 58s607ms 11s721ms 23 2 7s255ms 3s627ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:19:14 Duration: 17s190ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (80)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (10))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 21:46:21 Duration: 15s228ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND ((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (87)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (74))))) 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"."policy_id" LIMIT 100;
Date: 2026-09-13 12:49:09 Duration: 14s816ms
15 8s950ms 12s741ms 11s106ms 12 2m13s select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (("shipping_policy"."customer_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))) or ("shipping_policy"."customer_receive_id" in ( select "urgent_customer".id from "urgent_customer" where ("urgent_customer"."user_id" = ?))))) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 13 04 2 22s831ms 11s415ms 10 1 11s975ms 11s975ms 11 4 42s398ms 10s599ms 12 1 11s818ms 11s818ms 17 1 11s683ms 11s683ms 19 1 12s741ms 12s741ms 20 1 8s950ms 8s950ms 21 1 10s877ms 10s877ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 19:15:15 Duration: 12s741ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 10:37:23 Duration: 11s975ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (("shipping_policy"."customer_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 895))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-13 12:15:28 Duration: 11s818ms
16 7s183ms 8s889ms 8s31ms 111 14m51s select "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" from "shipping_report_details" where "shipping_report_details".id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 13 08 2 14s921ms 7s460ms 09 49 6m13s 7s613ms 12 60 8m23s 8s391ms -
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23936961, 23947700, 23848415);
Date: 2026-09-13 12:13:35 Duration: 8s889ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23837406, 23355483, 24026620, 23943208, 23843670, 23932250, 23796166, 23940368, 23971530, 23516757, 23834864, 23962110, 23761271, 23874229, 23965269, 23860956, 23943458, 23759366, 23927513, 23790389);
Date: 2026-09-13 12:14:20 Duration: 8s840ms
-
SELECT "shipping_report_details"."id" AS "id", "shipping_report_details"."last_office" AS "last_office", "shipping_report_details"."delegate_id" AS "delegate_id", "shipping_report_details"."last_car" AS "last_car", "shipping_report_details"."total_count" AS "total_count", "shipping_report_details"."received_count" AS "received_count", "shipping_report_details"."delay_count" AS "delay_count", "shipping_report_details"."out_date" AS "out_date" FROM "shipping_report_details" WHERE "shipping_report_details".id IN (23960367, 23961928, 23922223, 23780154, 23494267, 23889647, 23891929, 23867837, 23393532, 23940975, 23565359, 23581837, 23961631, 23930164, 23966774, 23682243, 23837773, 23966583, 23634151, 23429621, 23736600);
Date: 2026-09-13 12:12:51 Duration: 8s774ms
17 4s757ms 10s457ms 7s994ms 34 4m31s 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 13 16 3 30s824ms 10s274ms 20 13 1m31s 7s42ms 21 16 2m14s 8s397ms 23 2 15s97ms 7s548ms -
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%176874%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s457ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%1768742%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:43 Duration: 10s196ms
-
SELECT "policy_number".id FROM "policy_number" WHERE (((((((("policy_number"."active" = true) AND ("policy_number"."package_id" = 2425)) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (8)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL))) AND ("policy_number"."name"::text ilike '%17687422%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 16:18:42 Duration: 10s171ms
18 4s961ms 12s268ms 7s716ms 25 3m12s 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 ("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"."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 ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null)))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 13 11 4 31s867ms 7s966ms 19 5 46s352ms 9s270ms 21 6 41s359ms 6s893ms 23 5 30s856ms 6s171ms Sep 14 00 1 9s352ms 9s352ms 01 4 33s134ms 8s283ms -
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%186290%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 12s268ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (41)))))) AND ("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)))) AND ("policy_number"."name"::text ilike '%1862907%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 19:36:51 Duration: 11s985ms
-
SELECT "policy_number".id FROM "policy_number" WHERE ((("policy_number"."active" = true) AND (((((("policy_number"."package_id" = 2425) 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"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (51)))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."delegates_id" IS NOT NULL))))) AND ("policy_number"."notebook_id" in ( SELECT "notebook".id FROM "notebook" WHERE "notebook"."deliver_date" IS NOT NULL)))) AND ("policy_number"."name"::text ilike '%1849958%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-13 11:31:08 Duration: 11s841ms
19 6s558ms 8s243ms 7s390ms 41 5m3s select name from shipping_policy order by create_date desc limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 13 10 41 5m3s 7s390ms -
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s243ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s128ms
-
select name from shipping_policy order by create_date desc limit 10;
Date: 2026-09-13 10:36:26 Duration: 8s126ms
20 3s655ms 12s754ms 5s425ms 17 1m32s select "shipping_policy".id from "shipping_policy" where (("shipping_policy"."active" = true) and (((("shipping_policy"."state" not in (...)) or "shipping_policy"."state" is null) and ("shipping_policy"."x_is_inventory" is null or "shipping_policy"."x_is_inventory" = false)) and ("shipping_policy"."state" = ?))) 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 limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 13 11 5 30s663ms 6s132ms 12 3 22s317ms 7s439ms 13 5 22s306ms 4s461ms 14 2 8s81ms 4s40ms 15 1 3s989ms 3s989ms 19 1 4s865ms 4s865ms -
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (96)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) 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: 2026-09-13 11:42:03 Duration: 12s754ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_way'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (53, 54)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (78))))) 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: 2026-09-13 12:42:54 Duration: 11s792ms
-
SELECT "shipping_policy".id FROM "shipping_policy" WHERE (("shipping_policy"."active" = true) AND (((("shipping_policy"."state" not in ('cancel', 'hold')) OR "shipping_policy"."state" IS NULL) AND ("shipping_policy"."x_is_inventory" IS NULL or "shipping_policy"."x_is_inventory" = false)) AND ("shipping_policy"."state" = 'in_office'))) AND (("shipping_policy"."last_warehouse" in ( SELECT "urgent_warehouse".id FROM "urgent_warehouse" WHERE ("urgent_warehouse"."id" in (96)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49))))) 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: 2026-09-13 12:34:21 Duration: 6s705ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 19,610 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 1377 FATAL entries
- 6657 ERROR entries
- 0 WARNING entries
- 1002 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 5,742 Max number of times the same event was reported
- 9,036 Total events found
Rank Times reported Error 1 5,742 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 13 02 110 03 110 04 110 05 109 06 109 07 106 08 109 09 1,200 10 2,271 11 736 19 772 - ERROR: column res_partner.x_precentage_office does not exist at character 2190
- ERROR: column res_partner.x_precentage_office does not exist at character 2190
- ERROR: column res_partner.x_precentage_office does not exist at character 2190
Statement: 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"."x_is_client" AS "x_is_client", "res_partner"."x_precentage_office" AS "x_precentage_office", "res_partner"."signup_type" AS "signup_type", "res_partner"."signup_expiration" AS "signup_expiration" FROM "res_partner" WHERE "res_partner".id IN (2)
Date: 2026-09-13 02:00:25
Statement: 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"."x_is_client" AS "x_is_client", "res_partner"."x_precentage_office" AS "x_precentage_office", "res_partner"."signup_type" AS "signup_type", "res_partner"."signup_expiration" AS "signup_expiration" FROM "res_partner" WHERE "res_partner".id IN (2)
Date: 2026-09-13 02:01:18
Statement: 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"."x_is_client" AS "x_is_client", "res_partner"."x_precentage_office" AS "x_precentage_office", "res_partner"."signup_type" AS "signup_type", "res_partner"."signup_expiration" AS "signup_expiration" FROM "res_partner" WHERE "res_partner".id IN (2)
Date: 2026-09-13 02:01:33
2 990 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 13 07 1 09 2 10 503 11 458 18 1 19 21 22 4 - LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
- LOG: could not send data to client: Broken pipe
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 07:20:01
Date: 2026-09-13 09:10:10
Date: 2026-09-13 09:50:07
3 792 FATAL: connection to client lost
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 13 09 2 10 306 11 458 18 1 19 21 22 4 - FATAL: connection to client lost
- FATAL: connection to client lost
- FATAL: connection to client lost
Date: 2026-09-13 09:10:10
Date: 2026-09-13 09:50:07
Date: 2026-09-13 10:52:24
4 537 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 13 05 7 07 1 08 9 10 349 11 87 14 23 17 17 20 23 23 21 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Statement: select datname from pg_database where datdba=(select usesysid from pg_user where usename=current_user) and not datistemplate and datallowconn and datname not in ('template0', 'postgres') order by datname
Date: 2026-09-13 05:00:07
Date: 2026-09-13 05:00:07
Date: 2026-09-13 05:00:07
5 469 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 13 02 3 03 2 04 1 07 2 08 25 09 20 10 170 11 27 12 41 13 19 14 6 16 10 17 32 18 11 19 30 20 25 21 16 22 12 23 6 Sep 14 00 7 01 4 - ERROR: could not serialize access due to concurrent update
- ERROR: could not serialize access due to concurrent update
- ERROR: could not serialize access due to concurrent update
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-12', "state" = 'archive', "write_date" = '2026-09-13 00:42:01.407964', "write_uid" = 1951 WHERE id IN (23904941, 23916022, 23898311, 23882973, 23920649, 23866532, 23897596, 23885112, 23891114, 23901630, 23907284, 23909264, 23865073, 23913586, 23872238, 23869004, 23888827, 23841413, 23897590, 23830775, 23886017, 23869963, 23890106, 23889346, 23917313, 23891125, 23886068, 23919165, 23921414, 23907110, 23882414, 23909270, 23878167, 23823246, 23823260, 23823318, 23824115, 23824125, 23824988, 23826440, 23829416, 23829480, 23829739, 23830770, 23830861, 23831100, 23836593, 23839060, 23840199, 23840447, 23840659, 23843632)
Date: 2026-09-13 02:42:13
Statement: UPDATE "policy_tracking_missing" SET "count" = 1248, "shipping_id" = 24072454, "to_policy_id" = 56185206, "write_date" = '2026-09-13 00:52:53.645172', "write_uid" = 1001 WHERE id IN (25486)
Date: 2026-09-13 02:53:25
Statement: UPDATE "urgent_customer" SET "write_date" = '2026-09-13 00:53:25.218356', "write_uid" = 1001 WHERE id IN (5801307, 16483037, 7116711, 15046942, 5753250, 5753529, 5837375, 5585186, 5640159, 5855606, 10332697, 5104336, 5748435, 6283793, 14065224, 5793801, 6340453, 8417802, 6673345, 5702124, 5840362, 6468293, 16472261, 15433802, 8417840, 12032746, 5663350, 7542623, 15826736, 5839063, 5700357, 15251354, 13862526, 5751909, 6079021, 5119366, 5754954, 8848811, 6340450, 12927526, 16407399, 13253516, 5099266, 5696903, 11370950, 5856258, 5897279, 7486847, 6196592, 5699440, 6037940, 6634345, 15057191, 5100776, 14015787, 6007480, 6501970, 5798155, 5759502, 11373490, 6024252, 5758387, 15597257, 5943710, 5699601, 8366275, 8261778, 15309906, 5748120, 9903482, 6908605, 6040268, 8877828, 6003851, 16813878, 5704461, 10714863, 8710231, 12849077, 5908290, 11979248, 7512961, 16361333, 5699456, 5699688, 5933531, 13638455, 7485706, 5921778, 6610371, 16160316, 5688980, 10363403, 5663181, 5803555, 12790550, 5694879, 5704393, 15970875, 8512863, 5754145, 10823346, 5703071, 6033111, 5856678, 12289470, 8904546, 5754452, 14095829)
Date: 2026-09-13 02:53:59
6 153 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 13 10 89 11 12 18 12 19 30 20 10 - ERROR: could not create unique index "urgent_customer_customer_phone_name"
- ERROR: could not create unique index "urgent_customer_customer_phone_name"
- ERROR: could not create unique index "urgent_customer_customer_phone_name"
Detail: Key (phone)=( بدون رفم ) is duplicated.
Statement: ALTER TABLE "urgent_customer" ADD CONSTRAINT "urgent_customer_customer_phone_name" UNIQUE (phone)Date: 2026-09-13 10:51:06
Detail: Key (phone)=( بدون رفم ) is duplicated.
Context: parallel worker
Statement: ALTER TABLE "urgent_customer" ADD CONSTRAINT "urgent_customer_customer_phone_name" UNIQUE (phone)Date: 2026-09-13 10:51:06
Detail: Key (phone)=( - ) is duplicated.
Statement: ALTER TABLE "urgent_customer" ADD CONSTRAINT "urgent_customer_customer_phone_name" UNIQUE (phone)Date: 2026-09-13 10:51:06
7 115 ERROR: canceling statement due to lock timeout
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 13 09 106 10 9 - ERROR: canceling statement due to lock timeout
- ERROR: canceling statement due to lock timeout
- ERROR: canceling statement due to lock timeout
Statement: ALTER TABLE "res_users" DROP CONSTRAINT "res_users_login_key"
Date: 2026-09-13 09:21:21
Statement: ALTER TABLE "cash_policy" ADD COLUMN "is_update_amount" bool
Date: 2026-09-13 09:21:22
Statement: LOCK ir_attachment IN SHARE MODE
Date: 2026-09-13 09:21:32
8 86 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 13 03 1 06 2 07 1 08 1 09 9 10 8 11 10 12 9 13 12 14 3 15 6 16 5 17 3 18 4 19 2 20 1 Sep 14 00 9 - ERROR: syntax error at or near ")" at character 162
- ERROR: syntax error at or near ")" at character 162
- ERROR: syntax error at or near ")" at character 162
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('840966',)
Date: 2026-09-13 03:16:43
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 ('847492',)
Date: 2026-09-13 06:56:27
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('153726',)
Date: 2026-09-13 06:57:05
9 42 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 13 09 41 11 1 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron FOR UPDATE NOWAIT
Date: 2026-09-13 09:11:09
Statement: SELECT * FROM ir_cron FOR UPDATE NOWAIT
Date: 2026-09-13 09:11:15
Statement: SELECT * FROM ir_cron FOR UPDATE NOWAIT
Date: 2026-09-13 09:11:18
10 30 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #10
Day Hour Count Sep 13 04 1 10 8 14 5 16 5 19 9 20 1 Sep 14 00 1 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 3905469 waits for ShareLock on transaction 107368124; blocked by process 1183158. Process 1183158 waits for ShareLock on transaction 107368125; blocked by process 3905469. Process 3905469: UPDATE "shipping_policy" SET "archive_date" = '2026-09-13', "state" = 'archive', "write_date" = '2026-09-13 02:21:59.712189', "write_uid" = 1951 WHERE id IN (23953830, 23953535, 23953523, 23952855, 23952467, 23951649, 23950375, 23950176, 23949882, 23948133, 23945785, 23945775, 23945421, 23945267, 23943805, 23943770, 23943765, 23943757, 23943733, 23943726, 23942909, 23942724, 23942148, 23941939, 23941924, 23940752, 23940569, 23940542, 23937210, 23936944, 23936373, 23935109, 23935060, 23934521, 23933855, 23933405, 23931511, 23931336, 23931146, 23931128, 23930816, 23929247, 23928283, 23928266, 23928132, 23927124, 23926920, 23926569, 23926263, 23926201, 23925890, 23925889, 23925888, 23925705, 23922843, 23922840, 23922839, 23922826, 23922822, 23922821, 23922820, 23922811, 23922515, 23922510, 23922506, 23922504, 23921415, 23921413, 23921411, 23921410, 23921396, 23921392, 23921377, 23921376, 23921375, 23921373, 23921370, 23921350, 23920976, 23920899, 23920894, 23920888, 23920885, 23920672, 23920613, 23920602, 23920 Process 1183158: update shipping_policy set state_collection='confirm' where id=23899510
Context: while updating tuple (228023,11) in relation "shipping_policy"
Hint: See server log for query details.
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-13', "state" = 'archive', "write_date" = '2026-09-13 02:21:59.712189', "write_uid" = 1951 WHERE id IN (23953830, 23953535, 23953523, 23952855, 23952467, 23951649, 23950375, 23950176, 23949882, 23948133, 23945785, 23945775, 23945421, 23945267, 23943805, 23943770, 23943765, 23943757, 23943733, 23943726, 23942909, 23942724, 23942148, 23941939, 23941924, 23940752, 23940569, 23940542, 23937210, 23936944, 23936373, 23935109, 23935060, 23934521, 23933855, 23933405, 23931511, 23931336, 23931146, 23931128, 23930816, 23929247, 23928283, 23928266, 23928132, 23927124, 23926920, 23926569, 23926263, 23926201, 23925890, 23925889, 23925888, 23925705, 23922843, 23922840, 23922839, 23922826, 23922822, 23922821, 23922820, 23922811, 23922515, 23922510, 23922506, 23922504, 23921415, 23921413, 23921411, 23921410, 23921396, 23921392, 23921377, 23921376, 23921375, 23921373, 23921370, 23921350, 23920976, 23920899, 23920894, 23920888, 23920885, 23920672, 23920613, 23920602, 23920598, 23920573, 23920569, 23920518, 23920501, 23920497, 23920492, 23920483, 23920482, 23920480, 23920479, 23920476, 23920472, 23920470, 23920460, 23920457, 23920449, 23920418, 23920400, 23920398, 23920395, 23920390, 23920381, 23920379, 23920378, 23920377, 23920372, 23920370, 23920363, 23920360, 23920357, 23919811, 23918234, 23916240, 23916157, 23916021, 23915998, 23914297, 23914293, 23914288, 23914137, 23914121, 23913654, 23913615, 23913603, 23913598, 23913565, 23912791, 23912741, 23911849, 23910673, 23909613, 23908105, 23906636, 23905758, 23905725, 23905520, 23905373, 23905368, 23905322, 23904944, 23904936, 23904645, 23904629, 23904628, 23904620, 23904446, 23904267, 23904087, 23904068, 23904067, 23903228, 23902739, 23902606, 23902390, 23901896, 23901596, 23901550, 23901494, 23901100, 23900982, 23900677, 23899710, 23899510, 23899476, 23898992, 23898983, 23898423, 23898298, 23898293, 23898225, 23897960, 23897956, 23897883, 23897548, 23897356, 23896989, 23896287, 23895836, 23895794, 23895407, 23895276, 23895250, 23895244, 23895111, 23894721, 23894692, 23894362, 23893966, 23893920, 23893301, 23893195, 23893044, 23892972, 23892802, 23892226, 23892159, 23892142, 23892091, 23891318, 23891307, 23891190, 23891084, 23891013, 23890512, 23890102, 23890099, 23890096, 23890094, 23889840, 23889528, 23889090, 23888372, 23888366, 23887501, 23887447, 23886370, 23886292, 23886268, 23886235, 23885114, 23884806, 23884544, 23884369, 23882072, 23882012, 23881993, 23879031, 23876209, 23875760, 23875340, 23875128, 23874027, 23873395, 23872824, 23872016, 23871235, 23870405, 23870148, 23869878, 23869128, 23868669, 23867110, 23866534, 23864666, 23862092, 23860884, 23860528, 23860456, 23860206, 23859875, 23858867)Date: 2026-09-13 04:22:01
Detail: Process 680503 waits for ShareLock on transaction 107480070; blocked by process 680522. Process 680522 waits for ShareLock on transaction 107480086; blocked by process 681213. Process 681213 waits for ExclusiveLock on tuple (58,1) of relation 69497 of database 68672; blocked by process 680503. Process 680503: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade') Process 680522: INSERT INTO ir_model_data (module, name, model, res_id, noupdate) VALUES ('mail', 'selection__res_partner__activity_state__overdue', 'ir.model.fields.selection', 327, false), ('mail', 'selection__res_partner__activity_state__today', 'ir.model.fields.selection', 328, false), ('mail', 'selection__res_partner__activity_state__planned', 'ir.model.fields.selection', 329, false), ('mail', 'selection__res_partner__activity_exception_decoration__warning', 'ir.model.fields.selection', 330, false), ('mail', 'selection__res_partner__activity_exception_decoration__danger', 'ir.model.fields.selection', 331, false), ('base', 'selection__res_partner__type__contact', 'ir.model.fields.selection', 203, false), ('base', 'selection__res_partner__type__invoice', 'ir.model.fields.selection', 204, false), ('base', 'selection__res_partner__type__delivery', 'ir.model.fields.selection', 205, false), ('base', 'selection__res_partner__type__private', 'ir.model.fields.selection', 206, false), ('base', 'selection Process 681213: UPDATE "ir_module_module" SET "application" = true, "author" = 'Almoasher', "auto_install" = false, "contributors" = NULL, "description" = '{}' || COALESCE("description", '{}'::jsonb) || '{"en_US": " Urgent Cash Policy "}', "icon" = '/urgent_cash_policy/static/description/icon.png', "license" = 'LGPL-3', "maintainer" = NULL, "sequence" = 100, "shortdesc" = '{}' || COALESCE("shortdesc", '{}'::jsonb) || '{"en_US": "Urgent Cash Policy"}', "summary" = '{}' || COALESCE("summary", '{}'::jsonb) || '{"en_US": " Urgent Cash Policy "}', "to_buy" = false, "url" = '', "website" = 'http://almoasherbiz.com/', "write_date" = '2026-09-13 06:52:26.285667', "write_uid" = 1 WHERE id IN (484)
Context: while updating tuple (58,1) in relation "ir_module_module"
Hint: See server log for query details.
Statement: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')Date: 2026-09-13 10:52:27
Detail: Process 681270 waits for ExclusiveLock on tuple (58,1) of relation 69497 of database 68672; blocked by process 680566. Process 680566 waits for ShareLock on transaction 107480070; blocked by process 680522. Process 680522 waits for ShareLock on transaction 107480086; blocked by process 681213. Process 681213 waits for ExclusiveLock on tuple (58,1) of relation 69497 of database 68672; blocked by process 681270. Process 681270: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade') Process 680566: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade') Process 680522: INSERT INTO ir_model_data (module, name, model, res_id, noupdate) VALUES ('mail', 'selection__res_partner__activity_state__overdue', 'ir.model.fields.selection', 327, false), ('mail', 'selection__res_partner__activity_state__today', 'ir.model.fields.selection', 328, false), ('mail', 'selection__res_partner__activity_state__planned', 'ir.model.fields.selection', 329, false), ('mail', 'selection__res_partner__activity_exception_decoration__warning', 'ir.model.fields.selection', 330, false), ('mail', 'selection__res_partner__activity_exception_decoration__danger', 'ir.model.fields.selection', 331, false), ('base', 'selection__res_partner__type__contact', 'ir.model.fields.selection', 203, false), ('base', 'selection__res_partner__type__invoice', 'ir.model.fields.selection', 204, false), ('base', 'selection__res_partner__type__delivery', 'ir.model.fields.selection', 205, false), ('base', 'selection__res_partner__type__private', 'ir.model.fields.selection', 206, false), ('base', 'selection Process 681213: UPDATE "ir_module_module" SET "application" = true, "author" = 'Almoasher', "auto_install" = false, "contributors" = NULL, "description" = '{}' || COALESCE("description", '{}'::jsonb) || '{"en_US": " Urgent Cash Policy "}', "icon" = '/urgent_cash_policy/static/description/icon.png', "license" = 'LGPL-3', "maintainer" = NULL, "sequence" = 100, "shortdesc" = '{}' || COALESCE("shortdesc", '{}'::jsonb) || '{"en_US": "Urgent Cash Policy"}', "summary" = '{}' || COALESCE("summary", '{}'::jsonb) || '{"en_US": " Urgent Cash Policy "}', "to_buy" = false, "url" = '', "website" = 'http://almoasherbiz.com/', "write_date" = '2026-09-13 06:52:26.285667', "write_uid" = 1 WHERE id IN (484)
Hint: See server log for query details.
Statement: UPDATE ir_module_module SET state='installed' WHERE state IN ('to remove', 'to upgrade')Date: 2026-09-13 10:52:27
11 25 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #11
Day Hour Count Sep 13 07 5 10 6 18 2 19 6 20 6 - 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: 2026-09-13 07:20:01
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 07:20:01
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 07:20:01
12 23 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #12
Day Hour Count Sep 13 05 2 08 1 10 10 11 2 14 2 17 2 20 2 23 2 - FATAL: the database system is shutting down
- FATAL: the database system is shutting down
- FATAL: the database system is shutting down
Date: 2026-09-13 05:00:07
Date: 2026-09-13 05:00:07
Date: 2026-09-13 08:00:06
13 12 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #13
Day Hour Count Sep 13 02 1 05 1 07 1 08 1 10 3 11 1 14 1 17 1 20 1 23 1 - LOG: database system was shut down at 2026-09-13 02:00:07 CEST
- LOG: database system was shut down at 2026-09-13 05:00:07 CEST
- LOG: database system was shut down at 2026-09-13 07:20:02 CEST
Date: 2026-09-13 02:00:10
Date: 2026-09-13 05:00:11
Date: 2026-09-13 07:22:07
14 10 ERROR: duplicate key value violates unique constraint "..."
Times Reported Most Frequent Error / Event #14
Day Hour Count Sep 13 11 4 12 3 19 2 Sep 14 00 1 - ERROR: duplicate key value violates unique constraint "ir_filters_name_model_uid_unique_action_index"
- ERROR: duplicate key value violates unique constraint "ir_filters_name_model_uid_unique_action_index"
- ERROR: duplicate key value violates unique constraint "ir_filters_name_model_uid_unique_action_index"
Detail: Key (model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer), lower(name::text))=(cash.policy, -1, -1, الوكالة13) already exists.
Statement: INSERT INTO "ir_filters" ("active", "context", "create_date", "create_uid", "domain", "model_id", "name", "sort", "write_date", "write_uid") VALUES (true, '{}', '2026-09-13 07:42:55.987521', 1402, '[(''state'', ''!='', ''cancel''), (''id'', ''in'', [8300553, 11604688, 8307939, 11603350, 8322083, 11612628, 8307781, 11606160, 8337653, 8261214, 11623683, 8297849, 8291111, 11627501, 8270760, 11628182, 8315519, 11616465, 11605490, 11602624, 8314495, 8291791, 11619269, 8833186, 8824377, 11629339, 8833503, 11636617, 11628643, 11630211, 11635469, 8857039, 8844009, 11632851, 8852009, 8883328, 8880698, 11633930])]', 'cash.policy', 'الوكالة13', '[]', '2026-09-13 07:42:55.987521', 1402) RETURNING "id"Date: 2026-09-13 11:42:55
Detail: Key (model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer), lower(name::text))=(shipping.policy, -1, -1, شعبان13/9) already exists.
Statement: INSERT INTO "ir_filters" ("active", "context", "create_date", "create_uid", "domain", "model_id", "name", "sort", "write_date", "write_uid") VALUES (true, '{}', '2026-09-13 07:45:45.433196', 1485, '[(''id'', ''in'', [23975634, 7223205, 7097007, 24041631, 7159055, 24045560, 7272641, 24043832, 7571374, 24062664, 7391918, 24054015, 7429133, 24041694, 7708730, 24056629, 7562603, 24061088, 7495868, 24067110, 7658385, 24071150, 7312865, 23851799, 7364415, 24071185, 7866592, 24056188, 7523256, 24059003, 7494282, 24052957, 7494162, 24052991, 7746122, 24067071, 7547924, 24066141, 7438536, 24042253, 7470016, 24035257, 7689736, 24067025, 7679784, 24066959, 7211952, 24010177, 7359391, 24056119, 7715439, 24053346, 7474328, 24046113, 7470063, 24054133, 7440541, 24035244, 7457926, 24066500, 7529095, 24071238, 16056784, 24067023, 7701972, 24071214, 7654206, 24071217, 5901171, 23956501, 6004436, 24071165]), (''state'', ''!='', ''cancel''), (''x_is_inventory'', ''='', False)]', 'shipping.policy', 'شعبان13/9', '[]', '2026-09-13 07:45:45.433196', 1485) RETURNING "id"Date: 2026-09-13 11:45:45
Detail: Key (model_id, COALESCE(user_id, '-1'::integer), COALESCE(action_id, '-1'::integer), lower(name::text))=(shipping.policy, -1, -1, زياد13/9) already exists.
Statement: INSERT INTO "ir_filters" ("active", "context", "create_date", "create_uid", "domain", "model_id", "name", "sort", "write_date", "write_uid") VALUES (true, '{}', '2026-09-13 07:50:20.463899', 1485, '[(''id'', ''in'', [6363834, 24060450, 24066515, 6838243, 6582376, 24068386, 6867903, 24021433, 24013719, 7394689, 7274824, 24068067, 6999493, 24050250, 7361956, 24042444, 7222364, 24068061, 7943945, 23773832, 8138598, 23773764, 7269543, 23954085, 7692760, 23954133, 7429699, 24050851, 24049208, 7191610, 7402926, 23966529, 7423959, 24041481, 7418319, 24053451, 7341690, 24047358, 7293184, 24043044, 7500356, 24067342, 7325169, 23963586, 7305366, 24046943, 7355366, 24060420, 7534177, 24041561, 7798757, 24049723, 7911178, 24053999, 7653533, 24019120, 7447149, 24025298, 7384984, 24050283, 7472862, 24054132, 7658734, 24071209, 7706479, 24071230, 7536686, 24071201, 7393208, 24014536, 7430945, 24066501, 7550851, 24066954, 24062607, 5947466]), (''state'', ''!='', ''cancel''), (''x_is_inventory'', ''='', False)]', 'shipping.policy', 'زياد13/9', '[]', '2026-09-13 07:50:20.463899', 1485) RETURNING "id"Date: 2026-09-13 11:50:20
15 4 ERROR: canceling statement due to user request
Times Reported Most Frequent Error / Event #15
Day Hour Count Sep 13 10 4 - ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
- ERROR: canceling statement due to user request
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 10:35:47
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 10:35:47
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-13 10:36:08
16 3 ERROR: could not serialize access due to concurrent delete
Times Reported Most Frequent Error / Event #16
Day Hour Count Sep 13 11 3 - ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
- ERROR: could not serialize access due to concurrent delete
Statement: UPDATE "policy_search" SET "missing_data" = '', "search_domain" = '[(''state'', ''!='', ''cancel''), (''id'', ''in'', [11619174, 11622237, 8277397])]', "write_date" = '2026-09-13 09:27:03.905364', "write_uid" = 1799 WHERE id IN (2299889)
Date: 2026-09-13 11:27:03
Statement: UPDATE "policy_search" SET "missing_data" = '', "search_domain" = '[(''id'', ''in'', [6369675, 23266549, 6464877, 23724858, 23513632, 6593959, 23451319, 6204522, 23800069, 6204554, 6522641, 23621998, 23566350, 7302818, 6520167, 23296104, 6537875, 23466982, 6464890, 23424369, 23694190, 6425025, 6672379, 23562846, 6853904, 23809676, 8817993, 23514634, 6566639, 23972035, 23866172, 6786455, 6587440, 23443155, 23442754, 6938338, 23663384, 6659347, 23641268, 6659062, 23667128, 6875493, 23773774, 6659102, 23734854, 6628604, 23767448, 23862668, 6848684, 7581839, 23494518, 23650126, 6978550, 23506633, 6858862, 6858311, 23532532, 23711983, 7027137, 23464488, 6993697, 23635519, 6700791, 23597662, 7458545, 23574584, 6815764, 6870954, 23606838, 6709619, 23904777, 6933846, 23663422, 6934637, 23630055, 23665821, 6783951, 23639693, 6948581, 23791780, 6942728, 7771500, 23971879, 6971775, 23803462, 6846779, 23579903, 6940968, 23705353, 23529551, 6845380, 6878473, 23438412, 7048682, 23531582, 23734076, 6796713, 23769296, 6854411, 6982375, 23837568, 7013404, 23527092, 6877953, 23486490, 6879999, 23486491, 6920427, 23486464, 23680994, 6884668, 6876924, 24027521, 23875201, 6823879, 23497875, 7007339, 23459996, 7101100, 6984904, 23462187, 7043600, 23547814, 6947487, 23461578, 23491763, 6954675, 9237570, 23744691, 23753440, 7020311, 23549492, 6984758, 6984772, 23551406, 23866539, 7153077, 7010032, 23671556, 23579368, 7097331, 8248306, 24022755, 7291087, 23979014, 6992781, 23846978, 7288640, 23574386, 23517112, 7072014, 23934584, 7022615, 23787032, 7101070, 7227941, 23896026, 7038109, 23660248, 7042877, 23837887, 23638340, 7076372, 23921417, 7155916, 7136581, 23762580, 7033486, 23782939, 7333856, 23653948, 23762191, 7098257, 7220673, 23762169, 7153334, 23800816, 7065731, 23980438, 7058877, 23873177, 23627051, 7406323, 7089339, 23696412, 7105241, 23697683, 7169902, 23772497, 7044550, 23759433, 23663212, 7070759, 7122193, 23746094, 23758953, 7424366, 7118379, 23859102, 7330840, 23880423, 7357995, 23955418, 7266503, 23717708, 7094703, 23933556, 7304813, 23756437, 7305990, 23895826, 7231191, 23869072, 7261439, 23821562, 7508390, 23703291, 7423465, 23803142, 7245976, 23759155, 7281618, 23954784, 23747913, 7254479, 23834705, 7241695, 7933285, 23815616, 7457325, 23867041, 7793916, 23938395, 7198954, 23774383, 7203944, 23797378, 7272041, 23855305, 7395138, 23855765, 7477614, 23792202, 23890379, 7389935, 23952948, 7172076, 23899626, 7549267, 7681287, 23885878, 8377571, 23794262, 23886107, 7515325, 23901448, 7613446, 23885914, 7918859, 23954132, 7199921, 24025334, 7489589, 24025264, 7287809, 23804070, 7184541, 23904735, 7197789, 23884499, 23870730, 7208401, 23870733, 7208402, 7277287, 23961510, 7281294, 23870755, 23794914, 7185074, 23840361, 7217325, 23863191, 7369540, 23884314, 7477715, 7583568, 23977430, 23953139, 7261247, 7221231, 23954366, 7454829, 23835767, 7358692, 23976034, 7382037, 23968695, 7222930, 23990777, 7355889, 23983423, 23946890, 7430085, 7422473, 23984531, 23890739, 8948737, 7447421, 23975815, 7390297, 23824707, 7390722, 24022971, 23963804, 7450626, 7351673, 23925779, 7332386, 23907203, 7388091, 23993942, 7326826, 23976828, 7266112, 23938002, 7236853, 23966155, 7272618, 23992349, 7328388, 23869304, 7338905, 23905077, 7362504, 24004322, 7302105, 23892367, 7443448, 23947937, 7321777, 23852426, 7320228, 23896885, 7269822, 23908110, 7481460, 23977675, 7505853, 23943155, 7306826, 23850696, 7380903, 23924398, 7434971, 23953747, 7466076, 23922267, 7675092, 23896167, 8131335, 23992374, 7503806, 24023692, 7942115, 24009526, 7565480, 23980647, 7507550, 23980672, 7344058, 24013575, 7373589, 23968060, 7208501, 23976139, 7679291, 24002959, 7436403, 23968416, 7557992, 24036090, 23586018, 5576119, 23850098, 5963051, 6045037, 23886270, 6112815, 23991333, 23989229, 23992308, 7107103, 5949733, 24037785, 5954658, 23840437, 5839785, 23933369, 5926381, 23897820, 23826456, 5974417, 23862610, 6581883, 8293970, 23714143, 23752223, 23475403, 4585182]), (''state'', ''!='', ''cancel''), (''x_is_inventory'', ''='', False)]', "write_date" = '2026-09-13 09:40:37.053062', "write_uid" = 1840 WHERE id IN (2300052)
Date: 2026-09-13 11:40:37
Statement: UPDATE "policy_search" SET "missing_data" = '', "search_domain" = '[(''id'', ''in'', [6369675, 23266549, 6520167, 23296104, 6853904, 23809676, 6587440, 23443155, 23442754, 6938338, 6875493, 23773774, 23711983, 7027137, 23464488, 6993697, 6878473, 23438412, 23680994, 6884668, 23875201, 6823879, 23497875, 7007339, 8248306, 24022755, 7136581, 23762580, 7065731, 23980438, 7122193, 23746094, 7423465, 23803142, 7918859, 23954132, 7355889, 23983423, 23890739, 8948737, 7390722, 24022971, 7332386, 23907203, 7236853, 23966155, 7942115, 24009526, 7565480, 23980647, 7679291, 24002959, 6045037, 23886270, 6112815, 23991333, 23989229]), (''state'', ''!='', ''cancel''), (''x_is_inventory'', ''='', False)]', "write_date" = '2026-09-13 09:41:50.940480', "write_uid" = 1840 WHERE id IN (2300070)
Date: 2026-09-13 11:41:51
17 1 ERROR: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #17
Day Hour Count Sep 13 20 1 - ERROR: terminating background worker "parallel worker" due to administrator command
Context: parallel worker
Statement: SELECT "cash_policy".id FROM "cash_policy" LEFT JOIN "policy_number" AS "cash_policy__policy_id" ON ("cash_policy"."policy_id" = "cash_policy__policy_id"."id") WHERE (("cash_policy"."active" = true) AND ((("cash_policy"."state" != 'cancel') OR "cash_policy"."state" IS NULL) AND (("cash_policy"."policy_name" = '1716892') OR (("cash_policy"."policy_name" = '1716882') OR (("cash_policy"."policy_name" = '1616259') OR (("cash_policy"."policy_name" = '1616251') OR (("cash_policy"."policy_name" = '1616260') OR (("cash_policy"."policy_name" = '1616261') OR (("cash_policy"."policy_name" = '1616256') OR (("cash_policy"."policy_name" = '1341189') OR (("cash_policy"."policy_name" = '1616254') OR (("cash_policy"."policy_name" = '1616252') OR (("cash_policy"."policy_name" = '1616255') OR (("cash_policy"."policy_name" = '1341194') OR (("cash_policy"."policy_name" = '1341183') OR (("cash_policy"."policy_name" = '1341197') OR (("cash_policy"."policy_name" = '1341190') OR (("cash_policy"."policy_name" = '1341198') OR ("cash_policy"."policy_name" = '1098010'))))))))))))))))))) AND ((("cash_policy"."from_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28)))) OR ("cash_policy"."to_office" in (SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (28))))) 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 LIMIT 200Date: 2026-09-13 20:00:06
18 1 ERROR: column "..." of relation "..." already exists
Times Reported Most Frequent Error / Event #18
Day Hour Count Sep 13 10 1 - ERROR: column "is_update_amount" of relation "cash_policy" already exists
Statement: ALTER TABLE "cash_policy" ADD COLUMN "is_update_amount" bool
Date: 2026-09-13 10:51:06
19 1 ERROR: relation "..." already exists
Times Reported Most Frequent Error / Event #19
Day Hour Count Sep 13 09 1 - ERROR: relation "res_users_login_key" already exists
Statement: ALTER TABLE "res_users" ADD CONSTRAINT "res_users_login_key" UNIQUE (login)
Date: 2026-09-13 09:21:22