pgBadger-
Global information
- Generated on Fri Sep 4 23:45:04 2026
- Log file: /var/lib/pgsql/16/data/log/postgresql.log
- Parsed 13,389 log entries in 2s
- Log start from 2026-09-04 02:00:10 to 2026-09-05 01:44:51
-
Overview
Global Stats
- 139 Number of unique normalized queries
- 715 Number of queries
- 1h41m59s Total query duration
- 2026-09-04 02:08:28 First query
- 2026-09-05 01:40:53 Last query
- 5 queries/s at 2026-09-04 15:14:16 Query peak
- 1h41m59s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h41m59s Execute total duration
- 2,769 Number of events
- 9 Number of unique normalized events
- 2,598 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
- 715 Average queries per session
- 1h41m59s 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
- 5 queries/s Query Peak
- 2026-09-04 15:14:16 Date
SELECT Traffic
Key values
- 5 queries/s Query Peak
- 2026-09-04 15:14:16 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 1 queries/s Query Peak
- 2026-09-04 08:46:30 Date
Queries duration
Key values
- 1h41m59s 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 04 02 14 0ms 9s528ms 4s831ms 3s424ms 6s399ms 30s416ms 03 2 0ms 3s624ms 3s529ms 0ms 0ms 3s624ms 04 1 0ms 3s374ms 3s374ms 0ms 0ms 3s374ms 05 2 0ms 32s814ms 18s103ms 0ms 0ms 32s814ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 1 0ms 6s586ms 6s586ms 0ms 0ms 6s586ms 08 44 0ms 13m49s 1m 1m35s 6m17s 13m52s 09 11 0ms 5s101ms 4s443ms 3s16ms 9s753ms 14s447ms 10 173 0ms 8s366ms 4s852ms 56s28ms 58s972ms 1m3s 11 39 0ms 11s545ms 4s354ms 9s479ms 13s651ms 25s830ms 12 28 0ms 19s553ms 5s751ms 11s234ms 13s490ms 41s418ms 13 16 0ms 14s459ms 5s989ms 4s1ms 13s399ms 14s459ms 14 19 0ms 14s549ms 8s185ms 13s618ms 14s58ms 23s297ms 15 69 0ms 12s82ms 6s266ms 31s729ms 55s965ms 1m32s 16 26 0ms 12s210ms 4s376ms 6s606ms 10s635ms 40s490ms 17 32 0ms 11s394ms 5s216ms 10s767ms 14s626ms 35s47ms 18 44 0ms 9s974ms 3s569ms 9s327ms 19s368ms 23s538ms 19 61 0ms 10s80ms 4s178ms 16s999ms 22s358ms 28s631ms 20 39 0ms 9s854ms 4s39ms 12s386ms 21s674ms 23s335ms 21 11 0ms 13s279ms 4s682ms 3s255ms 11s568ms 13s279ms 22 30 0ms 13s342ms 8s433ms 13s342ms 22s189ms 39s20ms 23 23 0ms 13s293ms 7s777ms 12s668ms 20s184ms 34s118ms Sep 05 00 17 0ms 10s290ms 3s866ms 3s476ms 13s402ms 19s486ms 01 13 0ms 4s218ms 3s548ms 3s164ms 3s541ms 32s14ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 02 14 0 4s831ms 0ms 3s424ms 14s393ms 03 2 0 3s529ms 0ms 0ms 3s433ms 04 1 0 3s374ms 0ms 0ms 0ms 05 1 0 3s391ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 1 0 6s586ms 0ms 0ms 0ms 08 13 31 1m 49s453ms 1m35s 6m31s 09 11 0 4s443ms 0ms 3s16ms 9s802ms 10 173 0 4s852ms 17s31ms 56s28ms 1m1s 11 39 0 4s354ms 6s964ms 9s479ms 13s734ms 12 28 0 5s751ms 4s890ms 11s234ms 15s948ms 13 16 0 5s989ms 3s451ms 4s1ms 13s906ms 14 19 0 8s185ms 6s225ms 13s618ms 14s549ms 15 69 0 6s266ms 7s311ms 31s729ms 1m8s 16 26 0 4s376ms 0ms 6s606ms 20s924ms 17 32 0 5s216ms 4s286ms 10s767ms 28s767ms 18 44 0 3s569ms 6s190ms 9s327ms 22s496ms 19 61 0 4s178ms 7s578ms 16s999ms 26s858ms 20 39 0 4s39ms 3s285ms 12s386ms 23s192ms 21 11 0 4s682ms 0ms 3s255ms 13s270ms 22 30 0 8s433ms 10s875ms 13s342ms 26s213ms 23 23 0 7s777ms 3s620ms 12s668ms 21s451ms Sep 05 00 17 0 3s866ms 0ms 3s476ms 15s459ms 01 13 0 3s548ms 0ms 3s164ms 32s14ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 1 0 0 32s814ms 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 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 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 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Sep 05 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 04 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 05 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% Day Hour Count Average / Second Sep 04 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 05 00 0 0.00/s 01 0 0.00/s Day Hour Count Average Duration Average idle time Sep 04 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 05 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
- 385,888 buffers Checkpoint Peak
- 2026-09-04 05:49:41 Date
- 270.061 seconds Highest write time
- 0.020 seconds Sync time
Checkpoints Wal files
Key values
- 180 files Wal files usage Peak
- 2026-09-04 05:49:41 Date
Checkpoints distance
Key values
- 5,753.19 Mo Distance Peak
- 2026-09-04 05:49:41 Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Sep 04 02 81,103 2,901.78s 0.029s 2,901.845s 03 94,375 3,167.484s 0.032s 3,167.551s 04 56,042 3,124.556s 0.027s 3,124.618s 05 449,063 2,934.506s 0.04s 2,934.627s 06 59,333 3,234.6s 0.028s 3,234.688s 07 34,149 2,522.535s 0.04s 2,522.632s 08 82,171 3,047.133s 0.059s 3,047.301s 09 87,353 3,239.593s 0.029s 3,239.664s 10 117,621 3,239.56s 0.042s 3,239.639s 11 135,666 2,969.895s 0.05s 2,969.986s 12 92,540 3,239.582s 0.03s 3,239.648s 13 126,216 3,239.519s 0.031s 3,239.591s 14 85,347 2,968.844s 0.049s 2,968.934s 15 100,324 3,239.574s 0.034s 3,239.653s 16 107,445 3,239.595s 0.038s 3,239.674s 17 140,916 2,969.291s 0.053s 2,969.388s 18 136,942 3,239.524s 0.035s 3,239.608s 19 104,910 3,133.532s 0.035s 3,133.609s 20 101,707 2,969.713s 0.049s 2,969.802s 21 99,038 3,202.465s 0.032s 3,202.537s 22 95,474 3,239.571s 0.033s 3,239.641s 23 84,093 2,969.495s 0.052s 2,969.587s Sep 05 00 80,053 3,103.475s 0.031s 3,103.541s 01 61,227 2,106.526s 0.019s 2,106.574s Day Hour Added Removed Recycled Synced files Longest sync Average sync Sep 04 02 0 0 35 2,819 0.002s 0.011s 03 0 0 41 2,890 0.002s 0.012s 04 0 0 25 2,446 0.002s 0.012s 05 0 3 203 2,389 0.007s 0.012s 06 0 12 14 2,046 0.002s 0.012s 07 0 14 0 1,841 0.010s 0.011s 08 0 30 2 2,853 0.013s 0.013s 09 0 0 38 3,139 0.002s 0.012s 10 0 0 48 3,934 0.007s 0.012s 11 0 0 57 3,895 0.016s 0.012s 12 0 0 39 3,449 0.002s 0.012s 13 0 0 52 3,684 0.002s 0.012s 14 0 0 37 3,848 0.011s 0.012s 15 0 0 42 3,928 0.002s 0.012s 16 0 0 43 4,070 0.002s 0.012s 17 0 0 59 4,202 0.007s 0.012s 18 0 0 60 4,287 0.002s 0.012s 19 0 0 45 4,211 0.003s 0.012s 20 0 0 43 3,944 0.012s 0.012s 21 0 0 38 3,778 0.002s 0.012s 22 0 0 42 3,683 0.002s 0.012s 23 0 0 35 3,831 0.007s 0.012s Sep 05 00 0 0 34 3,458 0.002s 0.012s 01 0 0 26 2,399 0.002s 0.009s Day Hour Count Avg time (sec) Sep 04 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 05 00 0 0s 01 0 0s Day Hour Mean distance Mean estimate Sep 04 02 52,060.73 kB 77,050.09 kB 03 55,872.25 kB 106,962.42 kB 04 34,241.00 kB 62,385.58 kB 05 281,802.25 kB 702,333.75 kB 06 34,277.42 kB 1,306,809.17 kB 07 21,839.18 kB 248,908.36 kB 08 39,501.54 kB 69,482.54 kB 09 52,167.42 kB 63,930.75 kB 10 65,591.25 kB 79,879.83 kB 11 77,669.08 kB 126,259.08 kB 12 53,976.17 kB 85,049.17 kB 13 70,556.58 kB 93,258.17 kB 14 50,479.67 kB 69,062.25 kB 15 56,852.17 kB 75,698.25 kB 16 59,889.67 kB 73,604.33 kB 17 80,176.25 kB 91,507.58 kB 18 81,619.17 kB 108,267.25 kB 19 61,462.83 kB 97,468.83 kB 20 58,362.83 kB 70,309.83 kB 21 52,591.83 kB 79,476.17 kB 22 56,471.75 kB 95,796.83 kB 23 48,615.08 kB 66,615.08 kB Sep 05 00 46,576.75 kB 68,999.75 kB 01 47,030.89 kB 82,449.11 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 04 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 05 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 04 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 05 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
- 683 Total read queries
- 32 Total write queries
Queries by database
Key values
- unknown Main database
- 715 Requests
- 1h41m59s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 715 Requests
User Request type Count Duration unknown Total 715 1h41m59s copy to 31 42m54s select 683 58m32s update 1 32s814ms Duration by user
Key values
- 1h41m59s (unknown) Main time consuming user
User Request type Count Duration unknown Total 715 1h41m59s copy to 31 42m54s select 683 58m32s update 1 32s814ms Queries by host
Key values
- unknown Main host
- 715 Requests
- 1h41m59s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 715 Requests
- 1h41m59s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2026-09-04 23:17:26 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 626 1000-10000ms duration
Slowest individual queries
Rank Duration Query 1 13m49s 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-04 08:26:05 ]
2 6m31s 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-04 08:32:40 ]
3 5m38s 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-04 08:45:20 ]
4 4m13s 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-04 08:38:47 ]
5 3m10s COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;[ Date: 2026-09-04 08:06:18 ]
6 1m7s COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout;[ Date: 2026-09-04 08:09:23 ]
7 1m COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout;[ Date: 2026-09-04 08:07:18 ]
8 54s168ms COPY public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) TO stdout;[ Date: 2026-09-04 08:33:38 ]
9 50s609ms COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout;[ Date: 2026-09-04 08:08:15 ]
10 46s189ms COPY public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) TO stdout;[ Date: 2026-09-04 08:39:34 ]
11 40s881ms COPY public.mail_followers (id, res_id, partner_id, res_model) TO stdout;[ Date: 2026-09-04 08:11:30 ]
12 38s615ms COPY public.urgent_customer (id, message_main_attachment_id, create_uid, write_uid, name, phone, code, address, active, create_date, write_date, v_10_id, receive_man_id_no, is_company, user_id) TO stdout;[ Date: 2026-09-04 08:45:59 ]
13 34s378ms COPY public.collection_policy (id, office_id, user_id, shipping_id, customer_id, create_uid, write_uid, type, state, action_date, confirm_date, create_date, write_date, amount, sale_model, active, differance_cash, is_sale, sale_model_policy, is_sale_policy) TO stdout;[ Date: 2026-09-04 08:10:27 ]
14 32s814ms update shipping_policy set active = '0' where from_office in (39, 13, 115, 58, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 126, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 35, 5, 8, 7, 1, 38, 121, 9, 84, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 41, 40, 52, 111, 53, 29, 85, 60, 49, 43, 70, 54, 61, 46, 11, 26, 23, 128, 77, 67, 62, 57, 59, 51, 55, 97, 30, 68, 101, 79, 66, 108, 83, 118, 95, 112, 120, 63, 69, 31, 129, 124, 12, 122, 37, 82, 20, 86) and review_state = 'reviewed' and archive_date is NOT NULL and archive_date >= '2026-08-01' and archive_date <= '2026-09-02';[ Date: 2026-09-04 05:43:28 ]
15 32s189ms COPY public.policy_search (id, create_uid, write_uid, name, model, model_char, search_domain, missing_data, create_date, write_date, type, count_search, filter_name, active_p, is_inventory) TO stdout;[ Date: 2026-09-04 08:34:13 ]
16 29s732ms COPY public.mail_mail (id, mail_message_id, fetchmail_server_id, create_uid, write_uid, email_cc, state, failure_type, body_html, "references", headers, email_to, failure_reason, is_notification, auto_delete, to_delete, scheduled_date, create_date, write_date) TO stdout;[ Date: 2026-09-04 08:12:14 ]
17 21s524ms COPY public.cash_transfer (id, message_main_attachment_id, office_id, shipping_co_id, customer_id, to_office_id, from_office_id, cash_policy_id, create_uid, write_uid, email_cc, type, state, state_string, name, create_date_transfer, receive_date, in_notes, out_notes, is_move_daily, create_date, write_date, amount, amount_in_cash_policy, active, is_more_year) TO stdout;[ Date: 2026-09-04 08:09:44 ]
18 19s553ms 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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 ]
19 18s284ms 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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 ]
20 17s264ms COPY public.res_partner (id, company_id, create_date, name, title, parent_id, user_id, state_id, country_id, industry_id, color, commercial_partner_id, create_uid, write_uid, display_name, ref, lang, tz, vat, company_registry, website, function, type, street, street2, zip, city, email, phone, mobile, commercial_company_name, company_name, date, comment, partner_latitude, partner_longitude, active, employee, is_company, partner_share, write_date, message_main_attachment_id, message_bounce, email_normalized, signup_type, signup_expiration, signup_token, office_id, office_driver_id, employee_traffic, code, type_employee, type_driver, v_10_id, x_is_client, x_precentage_office, website_id, is_published) TO stdout;[ Date: 2026-09-04 08:34:31 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 13m49s 1 13m49s 13m49s 13m49s 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 04 08 1 13m49s 13m49s -
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-04 08:26:05 Duration: 13m49s
2 8m7s 151 3s5ms 3s831ms 3s227ms 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 #2
Day Hour Count Duration Avg duration Sep 04 02 2 6s281ms 3s140ms 11 6 20s184ms 3s364ms 12 4 12s567ms 3s141ms 13 3 9s259ms 3s86ms 14 1 3s556ms 3s556ms 15 3 9s839ms 3s279ms 16 3 9s491ms 3s163ms 17 11 34s331ms 3s121ms 18 27 1m25s 3s178ms 19 35 1m51s 3s176ms 20 28 1m32s 3s318ms 21 7 23s116ms 3s302ms 23 5 16s808ms 3s361ms Sep 05 00 11 35s105ms 3s191ms 01 5 16s815ms 3s363ms -
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 (49))))))) 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 (49)))))) 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 (49)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) 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 (49))))))))) 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 (49)))))))) AND ("policy_number"."name"::text ilike '%1636393%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 20:02:15 Duration: 3s831ms
-
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 (81))))))) 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 (81)))))) 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 (81)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (81)))))) 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 (81))))))))) 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 (81)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:07:16 Duration: 3s786ms
-
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 (1))))))) 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 (1)))))) 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 (1)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1)))))) 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 (1))))))))) 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 (1)))))))) AND ("policy_number"."name"::text ilike '%14858%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 21:42:07 Duration: 3s678ms
3 7m22s 60 7s5ms 8s366ms 7s377ms 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 #3
Day Hour Count Duration Avg duration Sep 04 10 60 7m22s 7s377ms -
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 (23734553, 23503824, 23700803, 23520102, 23648315, 23301356, 23368536, 23696440, 23716162, 23300409, 23698095, 23609113, 23649521, 23671112, 23673641, 23738810, 23725432, 23276688, 23242419, 23697143, 23716035, 23371597, 23356187, 23730982, 23613660, 23574625, 23510052, 23568491, 23141157, 23706115, 23714661, 23537404);
Date: 2026-09-04 10:28:02 Duration: 8s366ms
-
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 (23175939, 23466249, 23607712, 23680524, 23070844, 23692404, 23716420, 23682024, 23295501, 23658001, 23544961, 23593977);
Date: 2026-09-04 10:32:21 Duration: 7s961ms
-
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 (23680853, 23681355, 23722905, 23648517);
Date: 2026-09-04 10:28:26 Duration: 7s939ms
4 7m3s 120 3s 5s101ms 3s532ms 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", "cash_policy"."state" asc, "cash_policy"."sender_name" asc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 09 10 44s376ms 4s437ms 10 107 6m9s 3s449ms 11 3 10s455ms 3s485ms -
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:59:24 Duration: 5s101ms
-
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:58:16 Duration: 5s40ms
-
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:58:59 Duration: 5s35ms
5 6m31s 1 6m31s 6m31s 6m31s 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 #5
Day Hour Count Duration Avg duration Sep 04 08 1 6m31s 6m31s -
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-04 08:32:40 Duration: 6m31s
6 6m8s 31 3s523ms 19s553ms 11s885ms 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 #6
Day Hour Count Duration Avg duration Sep 04 12 2 37s838ms 18s919ms 14 2 23s297ms 11s648ms 16 1 10s569ms 10s569ms 21 1 13s279ms 13s279ms 22 15 2m56s 11s796ms 23 10 1m46s 10s651ms -
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 19s553ms
-
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 18s284ms
-
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-04 22:21:12 Duration: 13s342ms
7 5m38s 1 5m38s 5m38s 5m38s 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 #7
Day Hour Count Duration Avg duration Sep 04 08 1 5m38s 5m38s -
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-04 08:45:20 Duration: 5m38s
8 4m13s 1 4m13s 4m13s 4m13s 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 #8
Day Hour Count Duration Avg duration Sep 04 08 1 4m13s 4m13s -
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-04 08:38:47 Duration: 4m13s
9 3m10s 1 3m10s 3m10s 3m10s copy public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 08 1 3m10s 3m10s -
COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;
Date: 2026-09-04 08:06:18 Duration: 3m10s
10 3m8s 24 5s254ms 10s290ms 7s865ms 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 #10
Day Hour Count Duration Avg duration Sep 04 02 5 36s13ms 7s202ms 15 5 41s379ms 8s275ms 17 4 31s409ms 7s852ms 18 2 19s786ms 9s893ms 22 6 44s571ms 7s428ms Sep 05 00 2 15s606ms 7s803ms -
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 '%1624092%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-05 00:52:10 Duration: 10s290ms
-
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 (67)))))) 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 '%1350018%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 17:52:42 Duration: 10s32ms
-
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 '%1068%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 15:00:59 Duration: 10s29ms
11 2m26s 11 11s59ms 14s549ms 13s331ms 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))))) 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"."policy_id", "shipping_policy"."inventory_date" desc, "shipping_policy"."notes" desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 13 4 54s787ms 13s696ms 14 7 1m31s 13s123ms -
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:19:42 Duration: 14s549ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 13:04:10 Duration: 14s459ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:18:06 Duration: 14s58ms
12 2m24s 17 5s378ms 10s167ms 8s521ms 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 #12
Day Hour Count Duration Avg duration Sep 04 17 1 9s606ms 9s606ms 19 10 1m25s 8s505ms 20 5 40s24ms 8s4ms 23 1 10s167ms 10s167ms -
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 '%1624131%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:49:49 Duration: 10s167ms
-
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 (39)))))) 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 '%1556592%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:54:09 Duration: 10s80ms
-
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 (39)))))) 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 '%1480030%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:50:02 Duration: 9s989ms
13 1m59s 12 8s495ms 12s467ms 9s939ms 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 #13
Day Hour Count Duration Avg duration Sep 04 08 4 43s97ms 10s774ms 11 3 30s546ms 10s182ms 12 1 10s175ms 10s175ms 15 1 8s792ms 8s792ms 17 2 18s171ms 9s85ms 21 1 8s495ms 8s495ms -
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:32 Duration: 12s467ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:51 Duration: 10s774ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:49 Duration: 10s238ms
14 1m51s 10 9s370ms 11s985ms 11s116ms 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" = ?))))) and ("shipping_policy"."policy_name"::text ilike ?)) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 15 10 1m51s 11s116ms -
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:11 Duration: 11s985ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:17 Duration: 11s967ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650301 1650302 1650303 1650304 1650305 1650306 1650307 1650308 1650309 1650310 1650311 1650312 1650313 1650314 1650315 1650316 1650317 1650318 1650319 1650320 1650321 1650322 1650323 1650324 1650325 1650326 1650327 1650328 1650329 1650330 1650331 1650332 1650333 1650334 1650335 1650336 1650337 1650338 1650339 1650340 1650341 1650342 1650343 1650344 1650345 1650346 1650347 1650348 1650349 1650350%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:32:35 Duration: 11s943ms
15 1m16s 21 3s309ms 4s134ms 3s662ms 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 #15
Day Hour Count Duration Avg duration Sep 04 02 1 3s562ms 3s562ms 11 3 11s485ms 3s828ms 13 2 7s79ms 3s539ms 14 4 14s603ms 3s650ms 15 5 17s648ms 3s529ms 16 2 7s468ms 3s734ms 17 1 3s970ms 3s970ms 20 1 4s134ms 4s134ms 21 1 3s544ms 3s544ms 23 1 3s424ms 3s424ms -
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-04 20:26:16 Duration: 4s134ms
-
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 (91)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) 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-04 11:00:45 Duration: 4s76ms
-
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 (69)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) 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-04 17:04:46 Duration: 3s970ms
16 1m7s 1 1m7s 1m7s 1m7s copy public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 08 1 1m7s 1m7s -
COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout;
Date: 2026-09-04 08:09:23 Duration: 1m7s
17 1m 1 1m 1m 1m copy public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 08 1 1m 1m -
COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout;
Date: 2026-09-04 08:07:18 Duration: 1m
18 54s168ms 1 54s168ms 54s168ms 54s168ms copy public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 08 1 54s168ms 54s168ms -
COPY public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) TO stdout;
Date: 2026-09-04 08:33:38 Duration: 54s168ms
19 50s609ms 1 50s609ms 50s609ms 50s609ms copy public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 08 1 50s609ms 50s609ms -
COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout;
Date: 2026-09-04 08:08:15 Duration: 50s609ms
20 46s189ms 1 46s189ms 46s189ms 46s189ms copy public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 08 1 46s189ms 46s189ms -
COPY public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) TO stdout;
Date: 2026-09-04 08:39:34 Duration: 46s189ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 151 8m7s 3s5ms 3s831ms 3s227ms 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 #1
Day Hour Count Duration Avg duration Sep 04 02 2 6s281ms 3s140ms 11 6 20s184ms 3s364ms 12 4 12s567ms 3s141ms 13 3 9s259ms 3s86ms 14 1 3s556ms 3s556ms 15 3 9s839ms 3s279ms 16 3 9s491ms 3s163ms 17 11 34s331ms 3s121ms 18 27 1m25s 3s178ms 19 35 1m51s 3s176ms 20 28 1m32s 3s318ms 21 7 23s116ms 3s302ms 23 5 16s808ms 3s361ms Sep 05 00 11 35s105ms 3s191ms 01 5 16s815ms 3s363ms -
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 (49))))))) 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 (49)))))) 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 (49)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (49)))))) 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 (49))))))))) 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 (49)))))))) AND ("policy_number"."name"::text ilike '%1636393%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 20:02:15 Duration: 3s831ms
-
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 (81))))))) 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 (81)))))) 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 (81)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (81)))))) 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 (81))))))))) 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 (81)))))))) AND ("policy_number"."name"::text ilike '%1%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:07:16 Duration: 3s786ms
-
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 (1))))))) 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 (1)))))) 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 (1)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (1)))))) 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 (1))))))))) 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 (1)))))))) AND ("policy_number"."name"::text ilike '%14858%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 21:42:07 Duration: 3s678ms
2 120 7m3s 3s 5s101ms 3s532ms 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", "cash_policy"."state" asc, "cash_policy"."sender_name" asc limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 09 10 44s376ms 4s437ms 10 107 6m9s 3s449ms 11 3 10s455ms 3s485ms -
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:59:24 Duration: 5s101ms
-
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:58:16 Duration: 5s40ms
-
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 (64)))) OR ("cash_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (64))))) 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"."state" ASC, "cash_policy"."sender_name" ASC LIMIT 200;
Date: 2026-09-04 09:58:59 Duration: 5s35ms
3 60 7m22s 7s5ms 8s366ms 7s377ms 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 #3
Day Hour Count Duration Avg duration Sep 04 10 60 7m22s 7s377ms -
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 (23734553, 23503824, 23700803, 23520102, 23648315, 23301356, 23368536, 23696440, 23716162, 23300409, 23698095, 23609113, 23649521, 23671112, 23673641, 23738810, 23725432, 23276688, 23242419, 23697143, 23716035, 23371597, 23356187, 23730982, 23613660, 23574625, 23510052, 23568491, 23141157, 23706115, 23714661, 23537404);
Date: 2026-09-04 10:28:02 Duration: 8s366ms
-
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 (23175939, 23466249, 23607712, 23680524, 23070844, 23692404, 23716420, 23682024, 23295501, 23658001, 23544961, 23593977);
Date: 2026-09-04 10:32:21 Duration: 7s961ms
-
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 (23680853, 23681355, 23722905, 23648517);
Date: 2026-09-04 10:28:26 Duration: 7s939ms
4 31 6m8s 3s523ms 19s553ms 11s885ms 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 #4
Day Hour Count Duration Avg duration Sep 04 12 2 37s838ms 18s919ms 14 2 23s297ms 11s648ms 16 1 10s569ms 10s569ms 21 1 13s279ms 13s279ms 22 15 2m56s 11s796ms 23 10 1m46s 10s651ms -
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 19s553ms
-
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 18s284ms
-
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-04 22:21:12 Duration: 13s342ms
5 24 3m8s 5s254ms 10s290ms 7s865ms 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 #5
Day Hour Count Duration Avg duration Sep 04 02 5 36s13ms 7s202ms 15 5 41s379ms 8s275ms 17 4 31s409ms 7s852ms 18 2 19s786ms 9s893ms 22 6 44s571ms 7s428ms Sep 05 00 2 15s606ms 7s803ms -
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 '%1624092%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-05 00:52:10 Duration: 10s290ms
-
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 (67)))))) 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 '%1350018%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 17:52:42 Duration: 10s32ms
-
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 '%1068%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 15:00:59 Duration: 10s29ms
6 21 1m16s 3s309ms 4s134ms 3s662ms 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 #6
Day Hour Count Duration Avg duration Sep 04 02 1 3s562ms 3s562ms 11 3 11s485ms 3s828ms 13 2 7s79ms 3s539ms 14 4 14s603ms 3s650ms 15 5 17s648ms 3s529ms 16 2 7s468ms 3s734ms 17 1 3s970ms 3s970ms 20 1 4s134ms 4s134ms 21 1 3s544ms 3s544ms 23 1 3s424ms 3s424ms -
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-04 20:26:16 Duration: 4s134ms
-
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 (91)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (111))))) 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-04 11:00:45 Duration: 4s76ms
-
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 (69)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (4))))) 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-04 17:04:46 Duration: 3s970ms
7 17 2m24s 5s378ms 10s167ms 8s521ms 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 04 17 1 9s606ms 9s606ms 19 10 1m25s 8s505ms 20 5 40s24ms 8s4ms 23 1 10s167ms 10s167ms -
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 '%1624131%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:49:49 Duration: 10s167ms
-
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 (39)))))) 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 '%1556592%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:54:09 Duration: 10s80ms
-
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 (39)))))) 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 '%1480030%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:50:02 Duration: 9s989ms
8 12 1m59s 8s495ms 12s467ms 9s939ms 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 #8
Day Hour Count Duration Avg duration Sep 04 08 4 43s97ms 10s774ms 11 3 30s546ms 10s182ms 12 1 10s175ms 10s175ms 15 1 8s792ms 8s792ms 17 2 18s171ms 9s85ms 21 1 8s495ms 8s495ms -
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:32 Duration: 12s467ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:51 Duration: 10s774ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:49 Duration: 10s238ms
9 12 40s596ms 3s73ms 3s864ms 3s383ms select count(*) 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" = ?)))));Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 08 4 13s789ms 3s447ms 11 3 10s441ms 3s480ms 12 1 3s315ms 3s315ms 15 1 3s352ms 3s352ms 17 2 6s625ms 3s312ms 21 1 3s73ms 3s73ms -
SELECT COUNT(*) 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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847)))));
Date: 2026-09-04 08:35:20 Duration: 3s864ms
-
SELECT COUNT(*) 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" = 2045))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 2045)))));
Date: 2026-09-04 11:47:45 Duration: 3s546ms
-
SELECT COUNT(*) 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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847)))));
Date: 2026-09-04 08:35:52 Duration: 3s479ms
10 11 2m26s 11s59ms 14s549ms 13s331ms 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))))) 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"."policy_id", "shipping_policy"."inventory_date" desc, "shipping_policy"."notes" desc limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 13 4 54s787ms 13s696ms 14 7 1m31s 13s123ms -
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:19:42 Duration: 14s549ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 13:04:10 Duration: 14s459ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:18:06 Duration: 14s58ms
11 11 45s902ms 3s549ms 5s733ms 4s172ms 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 #11
Day Hour Count Duration Avg duration Sep 04 17 1 5s19ms 5s19ms 19 6 22s746ms 3s791ms 20 3 13s169ms 4s389ms 23 1 4s966ms 4s966ms -
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 (39)))))) 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-04 20:01:06 Duration: 5s733ms
-
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))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 17:10:06 Duration: 5s19ms
-
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))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:49:42 Duration: 4s966ms
12 11 43s179ms 3s401ms 4s977ms 3s925ms 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 #12
Day Hour Count Duration Avg duration Sep 04 02 2 8s796ms 4s398ms 14 1 4s977ms 4s977ms 17 1 3s637ms 3s637ms 18 2 7s505ms 3s752ms 22 4 14s381ms 3s595ms Sep 05 00 1 3s880ms 3s880ms -
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)))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 14:59:55 Duration: 4s977ms
-
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)))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 02:08:28 Duration: 4s864ms
-
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)))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 18:48:04 Duration: 4s104ms
13 11 40s161ms 3s299ms 3s903ms 3s651ms 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 #13
Day Hour Count Duration Avg duration Sep 04 08 1 3s663ms 3s663ms 10 2 7s272ms 3s636ms 11 1 3s548ms 3s548ms 15 4 14s842ms 3s710ms 16 1 3s299ms 3s299ms 17 2 7s534ms 3s767ms -
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 (49)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (75))))) 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 102;
Date: 2026-09-04 17:46:08 Duration: 3s903ms
-
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 (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-04 15:20:56 Duration: 3s772ms
-
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 (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 150;
Date: 2026-09-04 15:23:18 Duration: 3s717ms
14 10 1m51s 9s370ms 11s985ms 11s116ms 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" = ?))))) and ("shipping_policy"."policy_name"::text ilike ?)) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 15 10 1m51s 11s116ms -
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:11 Duration: 11s985ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:17 Duration: 11s967ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650301 1650302 1650303 1650304 1650305 1650306 1650307 1650308 1650309 1650310 1650311 1650312 1650313 1650314 1650315 1650316 1650317 1650318 1650319 1650320 1650321 1650322 1650323 1650324 1650325 1650326 1650327 1650328 1650329 1650330 1650331 1650332 1650333 1650334 1650335 1650336 1650337 1650338 1650339 1650340 1650341 1650342 1650343 1650344 1650345 1650346 1650347 1650348 1650349 1650350%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:32:35 Duration: 11s943ms
15 10 43s234ms 3s702ms 4s822ms 4s323ms select count(*) 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" = ?))))) and ("shipping_policy"."policy_name"::text ilike ?));Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 15 10 43s234ms 4s323ms -
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%'));
Date: 2026-09-04 15:40:59 Duration: 4s822ms
-
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650301 1650302 1650303 1650304 1650305 1650306 1650307 1650308 1650309 1650310 1650311 1650312 1650313 1650314 1650315 1650316 1650317 1650318 1650319 1650320 1650321 1650322 1650323 1650324 1650325 1650326 1650327 1650328 1650329 1650330 1650331 1650332 1650333 1650334 1650335 1650336 1650337 1650338 1650339 1650340 1650341 1650342 1650343 1650344 1650345 1650346 1650347 1650348 1650349 1650350 %'));
Date: 2026-09-04 15:41:56 Duration: 4s729ms
-
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%عبدالله كشك %'));
Date: 2026-09-04 15:40:43 Duration: 4s674ms
16 10 34s818ms 3s22ms 4s218ms 3s481ms select min("shipping_policy".id) as id, count("shipping_policy".id) AS "customer_id_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."customer_id" AS "customer_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))))) group by "shipping_policy"."customer_id" order by "customer_id" limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 02 3 9s560ms 3s186ms Sep 05 01 7 25s258ms 3s608ms -
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "customer_id_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."customer_id" as "customer_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 (14, 15, 16, 17, 18, 40, 129, 130)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) GROUP BY "shipping_policy"."customer_id" ORDER BY "customer_id" LIMIT 80;
Date: 2026-09-05 01:40:28 Duration: 4s218ms
-
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "customer_id_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."customer_id" as "customer_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 (14, 15, 16, 17, 18, 40, 129, 130)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) GROUP BY "shipping_policy"."customer_id" ORDER BY "customer_id" LIMIT 80;
Date: 2026-09-05 01:40:12 Duration: 4s86ms
-
SELECT min("shipping_policy".id) AS id, count("shipping_policy".id) AS "customer_id_count", sum("shipping_policy"."total_no_items") AS "total_no_items", sum("shipping_policy"."x_total_shipping_price") AS "x_total_shipping_price", sum("shipping_policy"."x_total_shipping_price_written") AS "x_total_shipping_price_written", sum("shipping_policy"."x_collection_amount_sender") AS "x_collection_amount_sender", sum("shipping_policy"."x_collection_amount_receive") AS "x_collection_amount_receive", sum("shipping_policy"."x_total_amount_cash_lines") AS "x_total_amount_cash_lines", sum("shipping_policy"."x_cash_amount_written") AS "x_cash_amount_written", "shipping_policy"."customer_id" as "customer_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 (14, 15, 16, 17, 18, 40, 129, 130)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (39, 13, 115, 75, 28, 50, 123, 27, 64, 78, 102, 76, 16, 48, 73, 65, 22, 24, 110, 19, 81, 119, 32, 6, 3, 80, 4, 5, 8, 7, 1, 38, 9, 127, 113, 44, 10, 2, 36, 33, 34, 42, 114, 71, 17, 14, 74, 40, 52, 111, 29, 85, 60, 49, 43, 70, 54, 61, 11, 26, 23, 77, 68))))) OR ("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."client_office" = true))))) GROUP BY "shipping_policy"."customer_id" ORDER BY "customer_id" LIMIT 80;
Date: 2026-09-05 01:40:29 Duration: 3s756ms
17 9 32s73ms 3s338ms 3s762ms 3s563ms 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))))) 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 04 02 1 3s424ms 3s424ms 13 1 3s762ms 3s762ms 16 5 18s33ms 3s606ms 18 2 6s852ms 3s426ms -
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 (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))))) 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 (49)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 172;
Date: 2026-09-04 13:23:38 Duration: 3s762ms
-
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 (82, 118)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (36))))) 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 (36)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 16:35:39 Duration: 3s698ms
-
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 (97)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (70))))) 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 (70)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 16:03:42 Duration: 3s683ms
18 8 28s923ms 3s337ms 4s286ms 3s615ms 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))))) 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 #18
Day Hour Count Duration Avg duration Sep 04 11 1 3s434ms 3s434ms 13 3 10s715ms 3s571ms 17 1 4s286ms 4s286ms 18 3 10s486ms 3s495ms -
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))))) 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 (46)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 17:24:32 Duration: 4s286ms
-
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))))) 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 (46)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 18:17:33 Duration: 3s780ms
-
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 (62, 63, 113, 114)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (24, 110))))) 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 (24, 110)))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 13:53:23 Duration: 3s669ms
19 6 27s488ms 3s692ms 6s225ms 4s581ms 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 #19
Day Hour Count Duration Avg duration Sep 04 11 2 7s414ms 3s707ms 12 2 10s29ms 5s14ms 14 1 6s225ms 6s225ms 19 1 3s817ms 3s817ms -
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 (85)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71))))) 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-04 14:06:12 Duration: 6s225ms
-
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_to_client'))) 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))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 12:32:11 Duration: 5s546ms
-
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_to_client'))) 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))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 12:31:49 Duration: 4s483ms
20 6 19s153ms 3s23ms 3s411ms 3s192ms select "policy_number".id from "policy_number" where (((((((("policy_number"."active" = true) and ("policy_number"."package_id" = ?)) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."active" = true) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."done" is null or "policy_number"."done" = false)) and ("policy_number"."damaged" is null or "policy_number"."damaged" = false)) and (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."client_office" = true))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) or (("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))) and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...)))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."delegates_id" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))))) and ("policy_number"."notebook_id" in ( select "notebook".id from "notebook" where "notebook"."deliver_date" is not null and ("notebook"."office_id" in ( select "urgent_office".id from "urgent_office" where ("urgent_office"."id" in (...))))))) and ("policy_number"."name"::text ilike ?)) order by "policy_number"."id" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 13 1 3s123ms 3s123ms 18 5 16s30ms 3s206ms -
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 (29))))))) 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 (29)))))) 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 (29)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))))) 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 (29))))))))) 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 (29))))))) AND ("policy_number"."name"::text ilike '%15985%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 18:20:32 Duration: 3s411ms
-
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 (29))))))) 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 (29)))))) 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 (29)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (29)))))) 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 (29))))))))) 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 (29))))))) AND ("policy_number"."name"::text ilike '%1598502%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 18:20:33 Duration: 3s410ms
-
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 (123))))))) 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 (123)))))) 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 (123)))) AND ("notebook"."office_id" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (123)))))) 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 (123))))))))) 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 (123))))))) AND ("policy_number"."name"::text ilike '%1090744%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 13:14:47 Duration: 3s123ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 13m49s 13m49s 13m49s 1 13m49s 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 04 08 1 13m49s 13m49s -
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-04 08:26:05 Duration: 13m49s
2 6m31s 6m31s 6m31s 1 6m31s 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 04 08 1 6m31s 6m31s -
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-04 08:32:40 Duration: 6m31s
3 5m38s 5m38s 5m38s 1 5m38s 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 04 08 1 5m38s 5m38s -
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-04 08:45:20 Duration: 5m38s
4 4m13s 4m13s 4m13s 1 4m13s 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 04 08 1 4m13s 4m13s -
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-04 08:38:47 Duration: 4m13s
5 3m10s 3m10s 3m10s 1 3m10s 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 04 08 1 3m10s 3m10s -
COPY public.bus_bus (id, create_uid, write_uid, channel, message, create_date, write_date) TO stdout;
Date: 2026-09-04 08:06:18 Duration: 3m10s
6 1m7s 1m7s 1m7s 1 1m7s copy public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 08 1 1m7s 1m7s -
COPY public.cash_track (id, office_id, user_id, cash_policy_id, create_uid, write_uid, state, receive_man_id, action_date, create_date, write_date, action_date_time) TO stdout;
Date: 2026-09-04 08:09:23 Duration: 1m7s
7 1m 1m 1m 1 1m copy public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 08 1 1m 1m -
COPY public.cash_policy (id, message_main_attachment_id, notebook_package_id, policy_id, delegate_policy_id, from_office, to_office, from_state, to_state, customer_id, customer_receive_id, delivery_method_id, shipping_payment, shipping_payment_at_receive, total_paid_by_sender, total_paid_by_receiver, user_delivered_id, user_confirm_payment_id, create_uid, write_uid, name, pol_name, state, state_previous, sender_mob, sender_name, receive_mob, receive_name, sender_add, receive_add, receive_man_id, receive_man_id_no, cheque_desc, confirmation_code, source, create_date_policy, confirm_payment_date, receive_main_office_date, confirm_payment_main_office_date, suspended_date, payment_delivered_date, policy_delivered_date, archive_date, flag_date, notes, total_amount_cash_lines_at_receive, cash, cheques, active, old_system_policy, custom_shipping, paid, create_date, write_date, cash_amount, total_amount_cash_lines, v_10_id, sp_id_10, sp_id, attachment_date, count_search, policy_name, attachment_user, change_date_recievable, sale_id, is_more_year, x_delivery_10, x_daily_move_date, is_color_polciy_cash_after_confirm, is_block_delievery, x_total_amount_cash_lines_at_receive, x_shipping_payment_at_receive, x_shipping_payment, x_cash_amount, x_total_amount_cash_lines, x_is_update, x_total_paid_by_sender, x_total_paid_by_receiver, x_daily_movement_id, x_other_daily_movement_id, sale_policy_id) TO stdout;
Date: 2026-09-04 08:07:18 Duration: 1m
8 54s168ms 54s168ms 54s168ms 1 54s168ms copy public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 08 1 54s168ms 54s168ms -
COPY public.policy_number (id, notebook_id, office_id, delegate_id, package_id, create_uid, write_uid, name, reason, damaged, done, active, create_date, write_date, reason_date, from_poilcy, deliver_date, note, message_main_attachment_id) TO stdout;
Date: 2026-09-04 08:33:38 Duration: 54s168ms
9 50s609ms 50s609ms 50s609ms 1 50s609ms copy public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 08 1 50s609ms 50s609ms -
COPY public.cash_policy_tracking (id, create_uid, write_uid, name, shipping_id, cash_id, create_date, write_date) TO stdout;
Date: 2026-09-04 08:08:15 Duration: 50s609ms
10 46s189ms 46s189ms 46s189ms 1 46s189ms copy public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 08 1 46s189ms 46s189ms -
COPY public.shipping_policy_items (id, product_id, shipping_policy_id, amount, create_uid, write_uid, desc_name, change_reason, paid, create_date, write_date, shipping_cost, shipping_cost_basic, total_shipping_cost) TO stdout;
Date: 2026-09-04 08:39:34 Duration: 46s189ms
11 11s59ms 14s549ms 13s331ms 11 2m26s 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))))) 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"."policy_id", "shipping_policy"."inventory_date" desc, "shipping_policy"."notes" desc limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 13 4 54s787ms 13s696ms 14 7 1m31s 13s123ms -
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:19:42 Duration: 14s549ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 13:04:10 Duration: 14s459ms
-
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 (42)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (84))))) 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 (84)))))) ORDER BY "shipping_policy"."policy_id", "shipping_policy"."inventory_date" DESC, "shipping_policy"."notes" DESC LIMIT 100;
Date: 2026-09-04 14:18:06 Duration: 14s58ms
12 3s523ms 19s553ms 11s885ms 31 6m8s 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 04 12 2 37s838ms 18s919ms 14 2 23s297ms 11s648ms 16 1 10s569ms 10s569ms 21 1 13s279ms 13s279ms 22 15 2m56s 11s796ms 23 10 1m46s 10s651ms -
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 19s553ms
-
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 (41)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (32))))) 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-04 12:00:14 Duration: 18s284ms
-
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-04 22:21:12 Duration: 13s342ms
13 9s370ms 11s985ms 11s116ms 10 1m51s 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" = ?))))) and ("shipping_policy"."policy_name"::text ilike ?)) order by "shipping_policy"."id" desc limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 15 10 1m51s 11s116ms -
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:11 Duration: 11s985ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:41:17 Duration: 11s967ms
-
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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650301 1650302 1650303 1650304 1650305 1650306 1650307 1650308 1650309 1650310 1650311 1650312 1650313 1650314 1650315 1650316 1650317 1650318 1650319 1650320 1650321 1650322 1650323 1650324 1650325 1650326 1650327 1650328 1650329 1650330 1650331 1650332 1650333 1650334 1650335 1650336 1650337 1650338 1650339 1650340 1650341 1650342 1650343 1650344 1650345 1650346 1650347 1650348 1650349 1650350%')) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 15:32:35 Duration: 11s943ms
14 8s495ms 12s467ms 9s939ms 12 1m59s 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 #14
Day Hour Count Duration Avg duration Sep 04 08 4 43s97ms 10s774ms 11 3 30s546ms 10s182ms 12 1 10s175ms 10s175ms 15 1 8s792ms 8s792ms 17 2 18s171ms 9s85ms 21 1 8s495ms 8s495ms -
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:32 Duration: 12s467ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:51 Duration: 10s774ms
-
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" = 847))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 847))))) ORDER BY "shipping_policy"."id" DESC LIMIT 10;
Date: 2026-09-04 08:35:49 Duration: 10s238ms
15 5s378ms 10s167ms 8s521ms 17 2m24s 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 04 17 1 9s606ms 9s606ms 19 10 1m25s 8s505ms 20 5 40s24ms 8s4ms 23 1 10s167ms 10s167ms -
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 '%1624131%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:49:49 Duration: 10s167ms
-
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 (39)))))) 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 '%1556592%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:54:09 Duration: 10s80ms
-
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 (39)))))) 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 '%1480030%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 19:50:02 Duration: 9s989ms
16 5s254ms 10s290ms 7s865ms 24 3m8s 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 #16
Day Hour Count Duration Avg duration Sep 04 02 5 36s13ms 7s202ms 15 5 41s379ms 8s275ms 17 4 31s409ms 7s852ms 18 2 19s786ms 9s893ms 22 6 44s571ms 7s428ms Sep 05 00 2 15s606ms 7s803ms -
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 '%1624092%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-05 00:52:10 Duration: 10s290ms
-
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 (67)))))) 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 '%1350018%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 17:52:42 Duration: 10s32ms
-
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 '%1068%')) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 15:00:59 Duration: 10s29ms
17 7s5ms 8s366ms 7s377ms 60 7m22s 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 #17
Day Hour Count Duration Avg duration Sep 04 10 60 7m22s 7s377ms -
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 (23734553, 23503824, 23700803, 23520102, 23648315, 23301356, 23368536, 23696440, 23716162, 23300409, 23698095, 23609113, 23649521, 23671112, 23673641, 23738810, 23725432, 23276688, 23242419, 23697143, 23716035, 23371597, 23356187, 23730982, 23613660, 23574625, 23510052, 23568491, 23141157, 23706115, 23714661, 23537404);
Date: 2026-09-04 10:28:02 Duration: 8s366ms
-
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 (23175939, 23466249, 23607712, 23680524, 23070844, 23692404, 23716420, 23682024, 23295501, 23658001, 23544961, 23593977);
Date: 2026-09-04 10:32:21 Duration: 7s961ms
-
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 (23680853, 23681355, 23722905, 23648517);
Date: 2026-09-04 10:28:26 Duration: 7s939ms
18 3s692ms 6s225ms 4s581ms 6 27s488ms 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 #18
Day Hour Count Duration Avg duration Sep 04 11 2 7s414ms 3s707ms 12 2 10s29ms 5s14ms 14 1 6s225ms 6s225ms 19 1 3s817ms 3s817ms -
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 (85)))) OR ((((("shipping_policy"."to_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71)))) OR ("shipping_policy"."from_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71))))) OR ("shipping_policy"."last_office" in ( SELECT "urgent_office".id FROM "urgent_office" WHERE ("urgent_office"."id" in (71))))) 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-04 14:06:12 Duration: 6s225ms
-
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_to_client'))) 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))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 12:32:11 Duration: 5s546ms
-
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_to_client'))) 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))))) ORDER BY "shipping_policy"."id" DESC LIMIT 100;
Date: 2026-09-04 12:31:49 Duration: 4s483ms
19 3s702ms 4s822ms 4s323ms 10 43s234ms select count(*) 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" = ?))))) and ("shipping_policy"."policy_name"::text ilike ?));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 15 10 43s234ms 4s323ms -
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650302%'));
Date: 2026-09-04 15:40:59 Duration: 4s822ms
-
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%1650301 1650302 1650303 1650304 1650305 1650306 1650307 1650308 1650309 1650310 1650311 1650312 1650313 1650314 1650315 1650316 1650317 1650318 1650319 1650320 1650321 1650322 1650323 1650324 1650325 1650326 1650327 1650328 1650329 1650330 1650331 1650332 1650333 1650334 1650335 1650336 1650337 1650338 1650339 1650340 1650341 1650342 1650343 1650344 1650345 1650346 1650347 1650348 1650349 1650350 %'));
Date: 2026-09-04 15:41:56 Duration: 4s729ms
-
SELECT COUNT(*) 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" = 1340))) OR ("shipping_policy"."customer_receive_id" in ( SELECT "urgent_customer".id FROM "urgent_customer" WHERE ("urgent_customer"."user_id" = 1340))))) AND ("shipping_policy"."policy_name"::text ilike '%عبدالله كشك %'));
Date: 2026-09-04 15:40:43 Duration: 4s674ms
20 3s549ms 5s733ms 4s172ms 11 45s902ms 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 #20
Day Hour Count Duration Avg duration Sep 04 17 1 5s19ms 5s19ms 19 6 22s746ms 3s791ms 20 3 13s169ms 4s389ms 23 1 4s966ms 4s966ms -
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 (39)))))) 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-04 20:01:06 Duration: 5s733ms
-
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))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 17:10:06 Duration: 5s19ms
-
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))) ORDER BY "policy_number"."id" LIMIT 8;
Date: 2026-09-04 23:49:42 Duration: 4s966ms
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
- 6,825 Event entries
- (EVENTLOG entries are formaly LOG level entries that are not queries)
Events distribution (except queries)
Key values
- 0 PANIC entries
- 107 FATAL entries
- 2652 ERROR entries
- 0 WARNING entries
- 10 EVENTLOG entries
Most Frequent Errors/Events
Key values
- 2,598 Max number of times the same event was reported
- 2,769 Total events found
Rank Times reported Error 1 2,598 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 04 02 109 03 110 04 108 05 110 06 109 07 104 08 109 09 110 10 110 11 111 12 109 13 109 14 109 15 110 16 110 17 110 18 110 19 110 20 110 21 108 22 111 23 109 Sep 05 00 111 01 82 - 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-04 02:00:41
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-04 02:00:52
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-04 02:01:41
2 88 FATAL: terminating connection due to administrator command
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 04 05 8 07 1 08 15 11 13 14 9 17 12 20 18 23 12 - FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
- FATAL: terminating connection due to administrator command
Date: 2026-09-04 05:00:07
Date: 2026-09-04 05:00:07
Date: 2026-09-04 05:00:07
3 26 ERROR: syntax error at or near "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 04 02 1 05 1 07 1 08 1 09 4 10 1 11 2 12 4 13 2 14 5 16 2 23 2 - ERROR: syntax error at or near ")" at character 162
- ERROR: syntax error at or near ")" at character 158
- ERROR: syntax error at or near ")" at character 163
Statement: select po.id,policy.name from shipping_policy as po inner join policy_number as policy on policy.id=po.policy_id where policy.name in ('487782',)
Date: 2026-09-04 02:14:15
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 (' ',)
Date: 2026-09-04 05:46:34
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 ('1528917',)
Date: 2026-09-04 07:45:05
4 20 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #4
Day Hour Count Sep 04 02 1 03 1 04 1 06 1 07 12 10 1 23 1 Sep 05 00 2 - 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 "policy_tracking_missing" SET "count" = 1308, "shipping_id" = 23808568, "to_policy_id" = 55824276, "write_date" = '2026-09-04 00:09:50.303955', "write_uid" = 2111 WHERE id IN (24557)
Date: 2026-09-04 02:10:04
Statement: UPDATE "policy_tracking_missing" SET "count" = 907, "shipping_id" = 23810270, "to_policy_id" = 55927337, "write_date" = '2026-09-04 01:31:05.361192', "write_uid" = 2186 WHERE id IN (24560)
Date: 2026-09-04 03:31:29
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 02:02:30.032521', "write_uid" = 1951 WHERE id IN (23642771, 23491126, 23631465, 23672199, 23679944, 23680924, 23621693, 23340430, 23664250, 23602255, 23658473, 23599985, 23659007, 23532350, 23659588, 23677951, 23590156, 23595138, 23532351, 23642153, 23621549, 23563838, 23649105, 23660717, 23636447, 23625538, 23667470, 23667535, 23667747, 23668680, 23668975, 23669028, 23670055, 23670264, 23670977, 23671121, 23671268, 23671991, 23672206, 23672368, 23674844, 23674851, 23674855, 23675185, 23675603, 23675635, 23675637, 23675811, 23677184, 23677697, 23677964, 23679227, 23679228, 23679559, 23680925, 23532976, 23598015, 23625569, 23625579, 23630196, 23642355, 23644104, 23649177, 23653030, 23653109, 23653790, 23656987, 23657703, 23658405, 23658483, 23658539, 23659167, 23659366, 23660335, 23660750, 23660797, 23660824, 23661470)
Date: 2026-09-04 04:02:30
5 14 FATAL: the database system is shutting down
Times Reported Most Frequent Error / Event #5
Day Hour Count Sep 04 05 2 08 2 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-04 05:00:07
Date: 2026-09-04 05:00:07
Date: 2026-09-04 08:00:06
6 9 LOG: database system was shut down at ...
Times Reported Most Frequent Error / Event #6
Day Hour Count Sep 04 02 1 05 1 07 1 08 1 11 1 14 1 17 1 20 1 23 1 - LOG: database system was shut down at 2026-09-04 02:00:07 CEST
- LOG: database system was shut down at 2026-09-04 05:00:07 CEST
- LOG: database system was shut down at 2026-09-04 07:20:01 CEST
Date: 2026-09-04 02:00:10
Date: 2026-09-04 05:00:10
Date: 2026-09-04 07:22:16
7 8 ERROR: deadlock detected
Times Reported Most Frequent Error / Event #7
Day Hour Count Sep 04 22 5 Sep 05 00 3 - ERROR: deadlock detected
- ERROR: deadlock detected
- ERROR: deadlock detected
Detail: Process 3771113 waits for ShareLock on transaction 104070864; blocked by process 587280. Process 587280 waits for ShareLock on transaction 104070865; blocked by process 3771113. Process 3771113: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:33:53.601733', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709 Process 587280: update shipping_policy set state_collection='confirm' where id=23709278
Context: while updating tuple (160131,39) in relation "shipping_policy"
Hint: See server log for query details.
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:33:53.601733', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709289, 23709287, 23709285, 23709282, 23709280, 23709278, 23709274, 23709271, 23709267, 23709265, 23709263, 23709254, 23709252, 23709247, 23709238, 23709234, 23709226, 23709224, 23709221, 23709217, 23709215, 23709213, 23709211, 23709208, 23709202, 23709195, 23709184, 23709182, 23708708, 23708699, 23708698, 23708103, 23707760, 23707759, 23707756, 23707751, 23707745, 23707743, 23707742, 23707741, 23707740, 23707738, 23707731, 23707730, 23707728, 23707727, 23707726, 23707724, 23707723, 23707720, 23707719, 23707715, 23707706, 23707705, 23707703, 23707700, 23707696, 23707694, 23707693, 23707691, 23707690, 23707688, 23707677, 23707676, 23707671, 23707670, 23707667, 23707663, 23707662, 23707660, 23707657, 23707655, 23707653, 23707650, 23707646, 23707643, 23707635, 23707633, 23707628, 23707624, 23707623, 23707622, 23707621, 23707617, 23707616, 23707615, 23707614, 23707612, 23707609, 23707607, 23707605, 23707598, 23707597, 23707596, 23707592, 23707591, 23707589, 23707584, 23707576, 23707574, 23707548, 23707546, 23707544, 23707540, 23707535, 23707534, 23707525, 23707524, 23707521, 23707518, 23707515, 23707512, 23707148, 23706541, 23706284, 23706281, 23706279, 23706274, 23706273, 23706269, 23705709, 23705700, 23705696, 23705690, 23705689, 23705592, 23705394, 23705356, 23705078, 23705061, 23704846, 23704836, 23704834, 23704798, 23704695, 23704684, 23703896, 23703895, 23703891, 23703889, 23703888, 23703887, 23703886, 23703878, 23703877, 23703869, 23703126, 23703114, 23703107, 23703032, 23702759, 23702753, 23702750, 23702745, 23702744, 23702742, 23702740, 23702739, 23702734, 23702416, 23702412, 23702409, 23702398, 23702372, 23702336, 23702313, 23702307, 23701840, 23701042, 23701041, 23701039, 23701038, 23701036, 23700757, 23700750, 23700345, 23699834, 23699832, 23699827, 23699824, 23699823, 23699822, 23699821, 23699558, 23699554, 23699534, 23699475, 23699224, 23699223, 23699222, 23699215, 23699214, 23699211, 23699207, 23699206, 23699204, 23699203, 23699202, 23699201, 23699197, 23699196, 23699153, 23699152, 23699149, 23699146, 23699145, 23699144, 23699143, 23699142, 23699101, 23699069, 23699068, 23699019, 23698713, 23698683, 23698677, 23698666, 23698421, 23698418, 23698417, 23698414, 23698412, 23698411, 23698410, 23698368, 23698364, 23698361, 23698360, 23698354, 23698353, 23698352, 23698349, 23698348, 23698343, 23697721, 23697702, 23697657, 23697619, 23697616, 23697592, 23697579, 23697133, 23697058, 23697025, 23697015, 23696950, 23696939, 23696938, 23696903, 23696899, 23696768, 23696767, 23696712, 23696481, 23696434, 23696390, 23696351, 23696350, 23696161, 23696146, 23696058, 23695904, 23695894, 23695891, 23695883, 23695859, 23695697, 23695624, 23695588, 23695580, 23695160, 23695147, 23695125, 23695043, 23695022, 23694924, 23694784, 23694770, 23694720, 23694670, 23694657, 23694653, 23694651, 23694643, 23694637, 23694564, 23694174, 23694168, 23694166, 23694161, 23694139, 23694133, 23694117, 23694085, 23694072, 23694067, 23694021, 23693974, 23693973, 23693967, 23693959, 23693957, 23693955, 23693946, 23693934, 23693925, 23693919, 23693917, 23693906, 23693894, 23693890, 23693885, 23693884, 23693880, 23693828, 23693824, 23693782, 23693773, 23693723, 23693722, 23693710, 23693656, 23693627, 23693602, 23693581, 23693568, 23693558, 23693505, 23693497, 23693475, 23693458, 23693440, 23693339, 23693329, 23693253, 23693163, 23693070, 23692946, 23692913, 23692772, 23692769, 23692756, 23692753, 23692751, 23692689, 23692674, 23692635, 23692633, 23692521, 23692516, 23692501, 23692467, 23692441, 23692436, 23692435, 23692206, 23691800, 23691799, 23691798, 23691781, 23691548, 23691338, 23691114, 23691111, 23691110, 23690538, 23690537, 23690501, 23690495, 23690477, 23690464, 23690451, 23690449, 23690430, 23690288, 23690235, 23690229, 23690192, 23690164, 23690136, 23690126, 23690108, 23690082, 23690038, 23690022, 23689975, 23689961, 23689943, 23689799, 23689777, 23689773, 23689755, 23689678, 23689630, 23689614, 23689460, 23689420, 23689352, 23689324, 23689035, 23688950, 23688684, 23688683, 23688417, 23687883, 23687803, 23687780, 23687765, 23687680, 23687665, 23687497, 23687459, 23687450, 23687437, 23687429, 23687207, 23687128, 23687061, 23687029, 23687027, 23687020, 23686982, 23686208, 23686151, 23686043, 23686036, 23686022, 23685969, 23685892, 23685890, 23685887, 23685885, 23685884, 23685762, 23685734, 23685640, 23685625, 23685613, 23685365, 23685268, 23685122, 23685026, 23685017, 23684999, 23684957, 23684934, 23684932, 23684922, 23684830, 23684797, 23684767, 23684763, 23684751, 23684228, 23684220, 23684037, 23684033, 23683994, 23683817, 23683416, 23683407, 23683379, 23683358, 23683346, 23683178, 23683174, 23683154, 23683142, 23683101, 23683099, 23683071, 23683070, 23683066, 23683002, 23682990, 23682973, 23682961, 23682854, 23682839, 23682834, 23682720, 23682709, 23682706, 23682701, 23682644, 23682550, 23682521, 23682488, 23682439, 23682428, 23682247, 23682009, 23681795, 23681794, 23681793, 23681791, 23681637, 23681634, 23681629, 23681625, 23681562, 23681560, 23681472, 23681434, 23681251, 23681215, 23681025, 23680761, 23680760, 23680751, 23680741, 23680738, 23680718, 23680690, 23680689, 23680674, 23680058, 23680046, 23680037, 23680030, 23680029, 23679281, 23679247, 23678351, 23678345, 23677521, 23677414, 23677403, 23676714, 23676699, 23676293, 23676289, 23675723, 23675712, 23674584, 23674152, 23673912, 23673467, 23673440, 23672869, 23671086, 23670185, 23669063, 23667797, 23667704, 23667159, 23666965, 23666874, 23666838, 23666828, 23666634, 23666594, 23665640, 23665558, 23665539, 23665536, 23665190, 23665183, 23664633, 23664508, 23664507, 23664415, 23664285, 23664243, 23664061, 23663830, 23663829, 23663737, 23663718, 23663625, 23663602, 23663554, 23662943, 23662811, 23662810, 23662601, 23662507, 23660489, 23660109, 23659232, 23658989, 23658682, 23658655, 23658651, 23658335, 23658331, 23657725, 23657681, 23657394, 23657389, 23657380, 23657071, 23656586, 23653721, 23653644, 23653214, 23652626, 23652607, 23651166, 23651162, 23651139, 23651127, 23651053, 23651012, 23650831, 23649682, 23649669, 23648619, 23648609, 23648595, 23648328, 23645252, 23642545, 23642528, 23642482, 23642340, 23642288, 23641192, 23639822, 23639787, 23638906, 23638424, 23638264, 23636929, 23635471, 23634949, 23634654, 23634155, 23632833, 23631555, 23630957, 23630572, 23630176, 23628845, 23628378, 23626582, 23626204, 23626178, 23624576, 23624574, 23619605, 23618246, 23618124, 23617868, 23606821, 23603333, 23602206, 23601022, 23597841, 23597094, 23596633, 23595320, 23593736, 23593418, 23593408, 23590867, 23590442, 23588593, 23584651, 23579787, 23575404, 23571178, 23568353, 23566071, 23557056, 23554449, 23553826, 23547580, 23511942, 23506474, 23506429, 23493099, 23479887, 23472241, 23470282, 23391741, 23386949, 23339864, 23308787, 23264721, 23260752, 23183995, 22935130)Date: 2026-09-04 22:33:56
Detail: Process 3932800 waits for ShareLock on transaction 104070864; blocked by process 587280. Process 587280 waits for ShareLock on transaction 104070866; blocked by process 3932800. Process 3932800: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:33:57.113731', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709 Process 587280: update shipping_policy set state_collection='confirm' where id=23707622
Context: while updating tuple (161411,37) in relation "shipping_policy"
Hint: See server log for query details.
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:33:57.113731', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709289, 23709287, 23709285, 23709282, 23709280, 23709278, 23709274, 23709271, 23709267, 23709265, 23709263, 23709254, 23709252, 23709247, 23709238, 23709234, 23709226, 23709224, 23709221, 23709217, 23709215, 23709213, 23709211, 23709208, 23709202, 23709195, 23709184, 23709182, 23708708, 23708699, 23708698, 23708103, 23707760, 23707759, 23707756, 23707751, 23707745, 23707743, 23707742, 23707741, 23707740, 23707738, 23707731, 23707730, 23707728, 23707727, 23707726, 23707724, 23707723, 23707720, 23707719, 23707715, 23707706, 23707705, 23707703, 23707700, 23707696, 23707694, 23707693, 23707691, 23707690, 23707688, 23707677, 23707676, 23707671, 23707670, 23707667, 23707663, 23707662, 23707660, 23707657, 23707655, 23707653, 23707650, 23707646, 23707643, 23707635, 23707633, 23707628, 23707624, 23707623, 23707622, 23707621, 23707617, 23707616, 23707615, 23707614, 23707612, 23707609, 23707607, 23707605, 23707598, 23707597, 23707596, 23707592, 23707591, 23707589, 23707584, 23707576, 23707574, 23707548, 23707546, 23707544, 23707540, 23707535, 23707534, 23707525, 23707524, 23707521, 23707518, 23707515, 23707512, 23707148, 23706541, 23706284, 23706281, 23706279, 23706274, 23706273, 23706269, 23705709, 23705700, 23705696, 23705690, 23705689, 23705592, 23705394, 23705356, 23705078, 23705061, 23704846, 23704836, 23704834, 23704798, 23704695, 23704684, 23703896, 23703895, 23703891, 23703889, 23703888, 23703887, 23703886, 23703878, 23703877, 23703869, 23703126, 23703114, 23703107, 23703032, 23702759, 23702753, 23702750, 23702745, 23702744, 23702742, 23702740, 23702739, 23702734, 23702416, 23702412, 23702409, 23702398, 23702372, 23702336, 23702313, 23702307, 23701840, 23701042, 23701041, 23701039, 23701038, 23701036, 23700757, 23700750, 23700345, 23699834, 23699832, 23699827, 23699824, 23699823, 23699822, 23699821, 23699558, 23699554, 23699534, 23699475, 23699224, 23699223, 23699222, 23699215, 23699214, 23699211, 23699207, 23699206, 23699204, 23699203, 23699202, 23699201, 23699197, 23699196, 23699153, 23699152, 23699149, 23699146, 23699145, 23699144, 23699143, 23699142, 23699101, 23699069, 23699068, 23699019, 23698713, 23698683, 23698677, 23698666, 23698421, 23698418, 23698417, 23698414, 23698412, 23698411, 23698410, 23698368, 23698364, 23698361, 23698360, 23698354, 23698353, 23698352, 23698349, 23698348, 23698343, 23697721, 23697702, 23697657, 23697619, 23697616, 23697592, 23697579, 23697133, 23697058, 23697025, 23697015, 23696950, 23696939, 23696938, 23696903, 23696899, 23696768, 23696767, 23696712, 23696481, 23696434, 23696390, 23696351, 23696350, 23696161, 23696146, 23696058, 23695904, 23695894, 23695891, 23695883, 23695859, 23695697, 23695624, 23695588, 23695580, 23695160, 23695147, 23695125, 23695043, 23695022, 23694924, 23694784, 23694770, 23694720, 23694670, 23694657, 23694653, 23694651, 23694643, 23694637, 23694564, 23694174, 23694168, 23694166, 23694161, 23694139, 23694133, 23694117, 23694085, 23694072, 23694067, 23694021, 23693974, 23693973, 23693967, 23693959, 23693957, 23693955, 23693946, 23693934, 23693925, 23693919, 23693917, 23693906, 23693894, 23693890, 23693885, 23693884, 23693880, 23693828, 23693824, 23693782, 23693773, 23693723, 23693722, 23693710, 23693656, 23693627, 23693602, 23693581, 23693568, 23693558, 23693505, 23693497, 23693475, 23693458, 23693440, 23693339, 23693329, 23693253, 23693163, 23693070, 23692946, 23692913, 23692772, 23692769, 23692756, 23692753, 23692751, 23692689, 23692674, 23692635, 23692633, 23692521, 23692516, 23692501, 23692467, 23692441, 23692436, 23692435, 23692206, 23691800, 23691799, 23691798, 23691781, 23691548, 23691338, 23691114, 23691111, 23691110, 23690538, 23690537, 23690501, 23690495, 23690477, 23690464, 23690451, 23690449, 23690430, 23690288, 23690235, 23690229, 23690192, 23690164, 23690136, 23690126, 23690108, 23690082, 23690038, 23690022, 23689975, 23689961, 23689943, 23689799, 23689777, 23689773, 23689755, 23689678, 23689630, 23689614, 23689460, 23689420, 23689352, 23689324, 23689035, 23688950, 23688684, 23688683, 23688417, 23687883, 23687803, 23687780, 23687765, 23687680, 23687665, 23687497, 23687459, 23687450, 23687437, 23687429, 23687207, 23687128, 23687061, 23687029, 23687027, 23687020, 23686982, 23686208, 23686151, 23686043, 23686036, 23686022, 23685969, 23685892, 23685890, 23685887, 23685885, 23685884, 23685762, 23685734, 23685640, 23685625, 23685613, 23685365, 23685268, 23685122, 23685026, 23685017, 23684999, 23684957, 23684934, 23684932, 23684922, 23684830, 23684797, 23684767, 23684763, 23684751, 23684228, 23684220, 23684037, 23684033, 23683994, 23683817, 23683416, 23683407, 23683379, 23683358, 23683346, 23683178, 23683174, 23683154, 23683142, 23683101, 23683099, 23683071, 23683070, 23683066, 23683002, 23682990, 23682973, 23682961, 23682854, 23682839, 23682834, 23682720, 23682709, 23682706, 23682701, 23682644, 23682550, 23682521, 23682488, 23682439, 23682428, 23682247, 23682009, 23681795, 23681794, 23681793, 23681791, 23681637, 23681634, 23681629, 23681625, 23681562, 23681560, 23681472, 23681434, 23681251, 23681215, 23681025, 23680761, 23680760, 23680751, 23680741, 23680738, 23680718, 23680690, 23680689, 23680674, 23680058, 23680046, 23680037, 23680030, 23680029, 23679281, 23679247, 23678351, 23678345, 23677521, 23677414, 23677403, 23676714, 23676699, 23676293, 23676289, 23675723, 23675712, 23674584, 23674152, 23673912, 23673467, 23673440, 23672869, 23671086, 23670185, 23669063, 23667797, 23667704, 23667159, 23666965, 23666874, 23666838, 23666828, 23666634, 23666594, 23665640, 23665558, 23665539, 23665536, 23665190, 23665183, 23664633, 23664508, 23664507, 23664415, 23664285, 23664243, 23664061, 23663830, 23663829, 23663737, 23663718, 23663625, 23663602, 23663554, 23662943, 23662811, 23662810, 23662601, 23662507, 23660489, 23660109, 23659232, 23658989, 23658682, 23658655, 23658651, 23658335, 23658331, 23657725, 23657681, 23657394, 23657389, 23657380, 23657071, 23656586, 23653721, 23653644, 23653214, 23652626, 23652607, 23651166, 23651162, 23651139, 23651127, 23651053, 23651012, 23650831, 23649682, 23649669, 23648619, 23648609, 23648595, 23648328, 23645252, 23642545, 23642528, 23642482, 23642340, 23642288, 23641192, 23639822, 23639787, 23638906, 23638424, 23638264, 23636929, 23635471, 23634949, 23634654, 23634155, 23632833, 23631555, 23630957, 23630572, 23630176, 23628845, 23628378, 23626582, 23626204, 23626178, 23624576, 23624574, 23619605, 23618246, 23618124, 23617868, 23606821, 23603333, 23602206, 23601022, 23597841, 23597094, 23596633, 23595320, 23593736, 23593418, 23593408, 23590867, 23590442, 23588593, 23584651, 23579787, 23575404, 23571178, 23568353, 23566071, 23557056, 23554449, 23553826, 23547580, 23511942, 23506474, 23506429, 23493099, 23479887, 23472241, 23470282, 23391741, 23386949, 23339864, 23308787, 23264721, 23260752, 23183995, 22935130)Date: 2026-09-04 22:33:59
Detail: Process 585681 waits for ShareLock on transaction 104070864; blocked by process 587280. Process 587280 waits for ShareLock on transaction 104070868; blocked by process 585681. Process 585681: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:34:03.679873', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709 Process 587280: update shipping_policy set state_collection='confirm' where id=23696950
Context: while updating tuple (167702,26) in relation "shipping_policy"
Hint: See server log for query details.
Statement: UPDATE "shipping_policy" SET "archive_date" = '2026-09-04', "state" = 'archive', "write_date" = '2026-09-04 20:34:03.679873', "write_uid" = 2117 WHERE id IN (23714163, 23713567, 23713022, 23713020, 23712052, 23712051, 23712050, 23712048, 23712045, 23712044, 23712042, 23712040, 23712039, 23710270, 23710269, 23710265, 23710263, 23710261, 23710258, 23710256, 23710255, 23710253, 23710250, 23710249, 23710247, 23710242, 23709749, 23709748, 23709747, 23709745, 23709643, 23709642, 23709640, 23709636, 23709634, 23709632, 23709631, 23709630, 23709628, 23709626, 23709625, 23709619, 23709618, 23709617, 23709615, 23709608, 23709607, 23709602, 23709601, 23709599, 23709597, 23709596, 23709595, 23709592, 23709514, 23709513, 23709493, 23709492, 23709482, 23709361, 23709358, 23709357, 23709356, 23709353, 23709352, 23709351, 23709347, 23709346, 23709338, 23709335, 23709332, 23709331, 23709330, 23709327, 23709326, 23709323, 23709322, 23709321, 23709318, 23709309, 23709307, 23709306, 23709304, 23709303, 23709295, 23709291, 23709289, 23709287, 23709285, 23709282, 23709280, 23709278, 23709274, 23709271, 23709267, 23709265, 23709263, 23709254, 23709252, 23709247, 23709238, 23709234, 23709226, 23709224, 23709221, 23709217, 23709215, 23709213, 23709211, 23709208, 23709202, 23709195, 23709184, 23709182, 23708708, 23708699, 23708698, 23708103, 23707760, 23707759, 23707756, 23707751, 23707745, 23707743, 23707742, 23707741, 23707740, 23707738, 23707731, 23707730, 23707728, 23707727, 23707726, 23707724, 23707723, 23707720, 23707719, 23707715, 23707706, 23707705, 23707703, 23707700, 23707696, 23707694, 23707693, 23707691, 23707690, 23707688, 23707677, 23707676, 23707671, 23707670, 23707667, 23707663, 23707662, 23707660, 23707657, 23707655, 23707653, 23707650, 23707646, 23707643, 23707635, 23707633, 23707628, 23707624, 23707623, 23707622, 23707621, 23707617, 23707616, 23707615, 23707614, 23707612, 23707609, 23707607, 23707605, 23707598, 23707597, 23707596, 23707592, 23707591, 23707589, 23707584, 23707576, 23707574, 23707548, 23707546, 23707544, 23707540, 23707535, 23707534, 23707525, 23707524, 23707521, 23707518, 23707515, 23707512, 23707148, 23706541, 23706284, 23706281, 23706279, 23706274, 23706273, 23706269, 23705709, 23705700, 23705696, 23705690, 23705689, 23705592, 23705394, 23705356, 23705078, 23705061, 23704846, 23704836, 23704834, 23704798, 23704695, 23704684, 23703896, 23703895, 23703891, 23703889, 23703888, 23703887, 23703886, 23703878, 23703877, 23703869, 23703126, 23703114, 23703107, 23703032, 23702759, 23702753, 23702750, 23702745, 23702744, 23702742, 23702740, 23702739, 23702734, 23702416, 23702412, 23702409, 23702398, 23702372, 23702336, 23702313, 23702307, 23701840, 23701042, 23701041, 23701039, 23701038, 23701036, 23700757, 23700750, 23700345, 23699834, 23699832, 23699827, 23699824, 23699823, 23699822, 23699821, 23699558, 23699554, 23699534, 23699475, 23699224, 23699223, 23699222, 23699215, 23699214, 23699211, 23699207, 23699206, 23699204, 23699203, 23699202, 23699201, 23699197, 23699196, 23699153, 23699152, 23699149, 23699146, 23699145, 23699144, 23699143, 23699142, 23699101, 23699069, 23699068, 23699019, 23698713, 23698683, 23698677, 23698666, 23698421, 23698418, 23698417, 23698414, 23698412, 23698411, 23698410, 23698368, 23698364, 23698361, 23698360, 23698354, 23698353, 23698352, 23698349, 23698348, 23698343, 23697721, 23697702, 23697657, 23697619, 23697616, 23697592, 23697579, 23697133, 23697058, 23697025, 23697015, 23696950, 23696939, 23696938, 23696903, 23696899, 23696768, 23696767, 23696712, 23696481, 23696434, 23696390, 23696351, 23696350, 23696161, 23696146, 23696058, 23695904, 23695894, 23695891, 23695883, 23695859, 23695697, 23695624, 23695588, 23695580, 23695160, 23695147, 23695125, 23695043, 23695022, 23694924, 23694784, 23694770, 23694720, 23694670, 23694657, 23694653, 23694651, 23694643, 23694637, 23694564, 23694174, 23694168, 23694166, 23694161, 23694139, 23694133, 23694117, 23694085, 23694072, 23694067, 23694021, 23693974, 23693973, 23693967, 23693959, 23693957, 23693955, 23693946, 23693934, 23693925, 23693919, 23693917, 23693906, 23693894, 23693890, 23693885, 23693884, 23693880, 23693828, 23693824, 23693782, 23693773, 23693723, 23693722, 23693710, 23693656, 23693627, 23693602, 23693581, 23693568, 23693558, 23693505, 23693497, 23693475, 23693458, 23693440, 23693339, 23693329, 23693253, 23693163, 23693070, 23692946, 23692913, 23692772, 23692769, 23692756, 23692753, 23692751, 23692689, 23692674, 23692635, 23692633, 23692521, 23692516, 23692501, 23692467, 23692441, 23692436, 23692435, 23692206, 23691800, 23691799, 23691798, 23691781, 23691548, 23691338, 23691114, 23691111, 23691110, 23690538, 23690537, 23690501, 23690495, 23690477, 23690464, 23690451, 23690449, 23690430, 23690288, 23690235, 23690229, 23690192, 23690164, 23690136, 23690126, 23690108, 23690082, 23690038, 23690022, 23689975, 23689961, 23689943, 23689799, 23689777, 23689773, 23689755, 23689678, 23689630, 23689614, 23689460, 23689420, 23689352, 23689324, 23689035, 23688950, 23688684, 23688683, 23688417, 23687883, 23687803, 23687780, 23687765, 23687680, 23687665, 23687497, 23687459, 23687450, 23687437, 23687429, 23687207, 23687128, 23687061, 23687029, 23687027, 23687020, 23686982, 23686208, 23686151, 23686043, 23686036, 23686022, 23685969, 23685892, 23685890, 23685887, 23685885, 23685884, 23685762, 23685734, 23685640, 23685625, 23685613, 23685365, 23685268, 23685122, 23685026, 23685017, 23684999, 23684957, 23684934, 23684932, 23684922, 23684830, 23684797, 23684767, 23684763, 23684751, 23684228, 23684220, 23684037, 23684033, 23683994, 23683817, 23683416, 23683407, 23683379, 23683358, 23683346, 23683178, 23683174, 23683154, 23683142, 23683101, 23683099, 23683071, 23683070, 23683066, 23683002, 23682990, 23682973, 23682961, 23682854, 23682839, 23682834, 23682720, 23682709, 23682706, 23682701, 23682644, 23682550, 23682521, 23682488, 23682439, 23682428, 23682247, 23682009, 23681795, 23681794, 23681793, 23681791, 23681637, 23681634, 23681629, 23681625, 23681562, 23681560, 23681472, 23681434, 23681251, 23681215, 23681025, 23680761, 23680760, 23680751, 23680741, 23680738, 23680718, 23680690, 23680689, 23680674, 23680058, 23680046, 23680037, 23680030, 23680029, 23679281, 23679247, 23678351, 23678345, 23677521, 23677414, 23677403, 23676714, 23676699, 23676293, 23676289, 23675723, 23675712, 23674584, 23674152, 23673912, 23673467, 23673440, 23672869, 23671086, 23670185, 23669063, 23667797, 23667704, 23667159, 23666965, 23666874, 23666838, 23666828, 23666634, 23666594, 23665640, 23665558, 23665539, 23665536, 23665190, 23665183, 23664633, 23664508, 23664507, 23664415, 23664285, 23664243, 23664061, 23663830, 23663829, 23663737, 23663718, 23663625, 23663602, 23663554, 23662943, 23662811, 23662810, 23662601, 23662507, 23660489, 23660109, 23659232, 23658989, 23658682, 23658655, 23658651, 23658335, 23658331, 23657725, 23657681, 23657394, 23657389, 23657380, 23657071, 23656586, 23653721, 23653644, 23653214, 23652626, 23652607, 23651166, 23651162, 23651139, 23651127, 23651053, 23651012, 23650831, 23649682, 23649669, 23648619, 23648609, 23648595, 23648328, 23645252, 23642545, 23642528, 23642482, 23642340, 23642288, 23641192, 23639822, 23639787, 23638906, 23638424, 23638264, 23636929, 23635471, 23634949, 23634654, 23634155, 23632833, 23631555, 23630957, 23630572, 23630176, 23628845, 23628378, 23626582, 23626204, 23626178, 23624576, 23624574, 23619605, 23618246, 23618124, 23617868, 23606821, 23603333, 23602206, 23601022, 23597841, 23597094, 23596633, 23595320, 23593736, 23593418, 23593408, 23590867, 23590442, 23588593, 23584651, 23579787, 23575404, 23571178, 23568353, 23566071, 23557056, 23554449, 23553826, 23547580, 23511942, 23506474, 23506429, 23493099, 23479887, 23472241, 23470282, 23391741, 23386949, 23339864, 23308787, 23264721, 23260752, 23183995, 22935130)Date: 2026-09-04 22:34:06
8 5 FATAL: terminating background worker "..." due to administrator command
Times Reported Most Frequent Error / Event #8
Day Hour Count Sep 04 07 5 - 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-04 07:20:01
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-04 07:20:01
Statement: select name from shipping_policy order by create_date desc limit 10
Date: 2026-09-04 07:20:01
9 1 LOG: could not send data to client: Broken pipe
Times Reported Most Frequent Error / Event #9
Day Hour Count Sep 04 07 1 - 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-04 07:20:01