pgBadger-
Global information
- Generated on Mon Mar 11 00:50:03 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 34,324 log entries in 2s
- Log start from 2024-03-10 00:06:05 to 2024-03-10 23:59:53
-
Overview
Global Stats
- 171 Number of unique normalized queries
- 14,206 Number of queries
- 1h36m35s Total query duration
- 2024-03-10 00:06:05 First query
- 2024-03-10 23:59:53 Last query
- 26 queries/s at 2024-03-10 17:44:52 Query peak
- 1h36m35s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 1h36m35s Execute total duration
- 1,300 Number of events
- 4 Number of unique normalized events
- 1,061 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
- 14,206 Average queries per session
- 1h36m35s 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
- 26 queries/s Query Peak
- 2024-03-10 17:44:52 Date
SELECT Traffic
Key values
- 26 queries/s Query Peak
- 2024-03-10 17:44:52 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 8 queries/s Query Peak
- 2024-03-10 11:19:43 Date
Queries duration
Key values
- 1h36m35s 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) Mar 10 00 204 0ms 21s670ms 1s626ms 28s218ms 1m1s 1m1s 01 173 0ms 21s644ms 1s653ms 28s183ms 28s421ms 28s484ms 02 296 0ms 21s551ms 1s93ms 28s192ms 28s676ms 29s579ms 03 173 0ms 21s544ms 958ms 28s137ms 30s879ms 30s879ms 04 162 0ms 21s560ms 1s776ms 28s106ms 28s228ms 28s228ms 05 166 0ms 21s567ms 1s748ms 28s255ms 36s882ms 36s882ms 06 206 0ms 21s612ms 1s468ms 28s131ms 28s193ms 28s253ms 07 176 0ms 21s762ms 986ms 28s77ms 28s153ms 36s492ms 08 165 0ms 21s789ms 1s760ms 28s56ms 28s159ms 28s431ms 09 317 0ms 3m49s 3s78ms 1m41s 1m54s 4m41s 10 3,679 120ms 21s662ms 219ms 40s272ms 52s495ms 1m 11 7,274 0ms 1s11ms 141ms 31s465ms 32s491ms 39s611ms 12 120 0ms 980ms 333ms 7s398ms 7s798ms 7s798ms 13 102 0ms 564ms 323ms 7s466ms 8s790ms 8s790ms 14 25 0ms 502ms 305ms 5s876ms 5s876ms 5s876ms 15 47 0ms 558ms 218ms 367ms 420ms 6s14ms 16 11 0ms 369ms 178ms 650ms 650ms 650ms 17 110 0ms 741ms 351ms 8s82ms 14s310ms 14s310ms 18 127 0ms 627ms 280ms 8s157ms 8s320ms 8s725ms 19 81 0ms 542ms 204ms 791ms 1s302ms 7s889ms 20 75 0ms 578ms 320ms 7s13ms 9s915ms 9s915ms 21 106 0ms 1s486ms 435ms 6s643ms 8s616ms 9s773ms 22 142 0ms 634ms 316ms 6s646ms 7s579ms 9s21ms 23 269 0ms 21s767ms 861ms 27s396ms 29s377ms 30s118ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 10 00 186 0 513ms 2s928ms 8s999ms 1m1s 01 153 0 150ms 1s791ms 1s983ms 2s112ms 02 276 0 221ms 2s497ms 5s89ms 9s584ms 03 163 0 212ms 3s789ms 5s807ms 6s106ms 04 142 0 179ms 1s812ms 3s420ms 4s71ms 05 146 0 187ms 1s803ms 1s925ms 10s334ms 06 186 0 213ms 1s873ms 2s42ms 12s287ms 07 166 0 252ms 1s775ms 7s751ms 9s946ms 08 144 0 188ms 1s815ms 1s828ms 9s168ms 09 196 101 2s401ms 49s43ms 1m41s 4m41s 10 727 0 226ms 7s580ms 9s684ms 20s875ms 11 1,107 0 206ms 6s11ms 7s837ms 10s591ms 12 120 0 333ms 6s679ms 7s398ms 7s798ms 13 102 0 323ms 3s110ms 7s466ms 8s790ms 14 25 0 305ms 1s630ms 5s876ms 5s876ms 15 47 0 218ms 293ms 367ms 6s14ms 16 11 0 178ms 451ms 650ms 650ms 17 110 0 351ms 4s673ms 8s82ms 14s310ms 18 127 0 280ms 2s391ms 8s157ms 8s725ms 19 81 0 204ms 533ms 791ms 7s889ms 20 75 0 320ms 552ms 7s13ms 9s915ms 21 98 0 449ms 3s400ms 6s643ms 9s773ms 22 136 0 319ms 2s245ms 6s646ms 9s21ms 23 193 0 247ms 2s278ms 3s266ms 11s295ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 10 00 0 0 18 0 13s132ms 26s186ms 26s269ms 26s441ms 01 0 0 20 0 13s150ms 26s148ms 26s328ms 26s431ms 02 0 0 20 0 13s126ms 0ms 26s230ms 26s313ms 03 0 0 10 0 13s129ms 0ms 26s232ms 26s319ms 04 0 0 20 0 13s116ms 26s180ms 26s264ms 26s301ms 05 0 0 20 0 13s138ms 26s244ms 26s277ms 26s548ms 06 0 0 20 0 13s136ms 26s187ms 26s281ms 26s402ms 07 0 0 10 0 13s177ms 0ms 0ms 26s378ms 08 0 1 20 0 12s539ms 26s142ms 26s238ms 26s543ms 09 0 0 20 0 13s140ms 26s124ms 26s228ms 26s657ms 10 0 2,932 20 0 218ms 21s520ms 26s307ms 27s378ms 11 0 6,167 0 0 129ms 14s988ms 24s566ms 29s475ms 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 8 0 0 252ms 0ms 0ms 1s287ms 22 0 6 0 0 238ms 0ms 0ms 715ms 23 0 66 10 0 2s417ms 2s119ms 5s333ms 26s479ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 10 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Mar 10 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Mar 10 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms 23 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
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Mar 10 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Mar 10 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Mar 10 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Mar 10 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 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 Mar 10 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 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
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Mar 10 00 0 0 01 0 0 02 0 0 03 0 0 04 0 0 05 0 0 06 0 0 07 0 0 08 0 0 09 0 0 10 0 0 11 0 0 12 0 0 13 0 0 14 0 0 15 0 0 16 0 0 17 0 0 18 0 0 19 0 0 20 0 0 21 0 0 22 0 0 23 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
- 4,717 Total read queries
- 9,489 Total write queries
Queries by database
Key values
- unknown Main database
- 14,206 Requests
- 1h36m35s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 14,206 Requests
User Request type Count Duration unknown Total 14,206 1h36m35s copy to 101 11m12s delete 208 45m33s select 4,717 19m13s update 9,180 20m35s Duration by user
Key values
- 1h36m35s (unknown) Main time consuming user
User Request type Count Duration unknown Total 14,206 1h36m35s copy to 101 11m12s delete 208 45m33s select 4,717 19m13s update 9,180 20m35s Queries by host
Key values
- unknown Main host
- 14,206 Requests
- 1h36m35s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 14,206 Requests
- 1h36m35s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-03-10 00:28:45 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 13,574 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m49s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-03-10 09:09:06 ]
2 1m45s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2024-03-10 09:03:26 ]
3 1m40s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2024-03-10 09:05:15 ]
4 28s638ms COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;[ Date: 2024-03-10 09:00:46 ]
5 21s789ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 08:06:41 ]
6 21s767ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 23:48:58 ]
7 21s762ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 07:54:38 ]
8 21s709ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 23:55:12 ]
9 21s670ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 00:54:29 ]
10 21s662ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 10:54:30 ]
11 21s654ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 09:06:30 ]
12 21s644ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 01:24:31 ]
13 21s639ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 08:12:33 ]
14 21s612ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 06:06:28 ]
15 21s611ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 10:24:54 ]
16 21s605ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 01:30:28 ]
17 21s600ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 01:54:30 ]
18 21s594ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 10:42:38 ]
19 21s587ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 01:36:31 ]
20 21s581ms DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);[ Date: 2024-03-10 00:06:29 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 37m16s 104 21s363ms 21s789ms 21s506ms delete from account_move_line where id in (...);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 10 00 9 3m13s 21s512ms 01 10 3m35s 21s531ms 02 10 3m34s 21s482ms 03 5 1m47s 21s480ms 04 10 3m34s 21s475ms 05 10 3m34s 21s484ms 06 10 3m35s 21s503ms 07 5 1m47s 21s569ms 08 10 3m34s 21s491ms 09 10 3m34s 21s481ms 10 10 3m35s 21s540ms 23 5 1m47s 21s590ms -
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 08:06:41 Duration: 21s789ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 23:48:58 Duration: 21s767ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 07:54:38 Duration: 21s762ms
2 19m39s 9,099 122ms 175ms 129ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 10 10 2,932 6m20s 129ms 11 6,167 13m19s 129ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209506) and warehouse_id = (43));
Date: 2024-03-10 11:03:35 Duration: 175ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209569) and warehouse_id = (42));
Date: 2024-03-10 10:48:11 Duration: 172ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (178318) and warehouse_id = (35));
Date: 2024-03-10 11:26:27 Duration: 166ms
3 8m16s 104 4s722ms 5s84ms 4s778ms delete from account_move where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 10 00 9 42s778ms 4s753ms 01 10 47s697ms 4s769ms 02 10 47s701ms 4s770ms 03 5 23s889ms 4s777ms 04 10 47s582ms 4s758ms 05 10 47s922ms 4s792ms 06 10 47s694ms 4s769ms 07 5 23s926ms 4s785ms 08 10 47s679ms 4s767ms 09 10 47s991ms 4s799ms 10 10 48s139ms 4s813ms 23 5 23s974ms 4s794ms -
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 09:24:38 Duration: 5s84ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 05:48:37 Duration: 5s50ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 10:48:40 Duration: 4s988ms
4 7m56s 1,530 120ms 741ms 311ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 10 00 31 11s201ms 361ms 01 33 5s150ms 156ms 02 107 30s107ms 281ms 03 69 20s359ms 295ms 04 21 7s491ms 356ms 05 26 9s555ms 367ms 06 66 22s18ms 333ms 07 80 29s52ms 363ms 08 24 9s292ms 387ms 09 74 22s362ms 302ms 10 102 33s451ms 327ms 11 55 15s128ms 275ms 12 102 33s573ms 329ms 13 102 32s952ms 323ms 14 25 7s627ms 305ms 15 47 10s255ms 218ms 16 8 1s311ms 163ms 17 110 38s664ms 351ms 18 86 25s704ms 298ms 19 62 13s835ms 223ms 20 67 22s975ms 342ms 21 49 14s374ms 293ms 22 127 41s443ms 326ms 23 57 19s103ms 335ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 741ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 10:55:16') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 10:56:07 Duration: 699ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:02') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1011"'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 695ms
5 3m49s 1 3m49s 3m49s 3m49s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 10 09 1 3m49s 3m49s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-10 09:09:06 Duration: 3m49s
6 2m44s 1,100 141ms 238ms 149ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 10 00 90 13s247ms 147ms 01 100 14s856ms 148ms 02 100 14s826ms 148ms 03 70 10s462ms 149ms 04 100 14s896ms 148ms 05 100 14s868ms 148ms 06 100 14s781ms 147ms 07 70 10s389ms 148ms 08 100 14s824ms 148ms 09 100 14s887ms 148ms 10 100 15s610ms 156ms 23 70 10s452ms 149ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261534, 1261533)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:25:02 Duration: 238ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261540, 1261539)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:42:47 Duration: 215ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261540, 1261539)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:42:46 Duration: 205ms
7 2m26s 452 316ms 387ms 324ms select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 10 10 147 47s863ms 325ms 11 305 1m39s 324ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:49 Duration: 387ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 11:13:54 Duration: 377ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:39 Duration: 374ms
8 1m45s 1 1m45s 1m45s 1m45s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 10 09 1 1m45s 1m45s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2024-03-10 09:03:26 Duration: 1m45s
9 1m40s 1 1m40s 1m40s 1m40s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 10 09 1 1m40s 1m40s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2024-03-10 09:05:15 Duration: 1m40s
10 1m2s 452 120ms 176ms 139ms select pwi.product_id, coalesce(pwi.lead_days, ?), coalesce(pwi.min_product_uom_qty, ?) as min_qty, coalesce(pwi.max_product_uom_qty, ?) as max_qty, coalesce(pwi.max_product_uom_qty, ?) - ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) as need_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pt.is_core, false) = false and coalesce(pwi.stocking_flag, false) = true and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < coalesce(pwi.max_product_uom_qty, ?) and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 10 10 147 20s487ms 139ms 11 305 42s408ms 139ms -
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 38 and pwi.inventory_vendor_id = 2906;
Date: 2024-03-10 11:08:52 Duration: 176ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 3080;
Date: 2024-03-10 11:45:01 Duration: 176ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 3080;
Date: 2024-03-10 11:28:58 Duration: 173ms
11 37s361ms 288 123ms 166ms 129ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 10 10 105 13s647ms 129ms 11 183 23s713ms 129ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3089 and pwi.warehouse_id = 41 and pwi.product_id not in (195986, 195869, 195759, 195755, 195753, 195752, 195182, 195171, 195165, 195164, 195053, 194958, 194845, 194841, 194788, 194661, 194660, 194629, 194628, 194603, 194562, 194529, 194125, 195758);
Date: 2024-03-10 11:44:03 Duration: 166ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2933 and pwi.warehouse_id = 43 and pwi.product_id not in (238963, 238947, 238919, 238912);
Date: 2024-03-10 10:57:20 Duration: 163ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3270 and pwi.warehouse_id = 46 and pwi.product_id not in (256752, 256753, 256757, 256508, 256510, 256758);
Date: 2024-03-10 11:21:26 Duration: 156ms
12 33s777ms 223 141ms 265ms 151ms select "account_move".id from "account_move" where ("account_move"."edi_810_id" in (...)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 10 00 18 2s691ms 149ms 01 20 2s988ms 149ms 02 20 2s979ms 148ms 03 15 2s319ms 154ms 04 20 3s 150ms 05 20 3s5ms 150ms 06 20 2s995ms 149ms 07 15 2s266ms 151ms 08 20 3s21ms 151ms 09 20 3s9ms 150ms 10 20 3s242ms 162ms 23 15 2s257ms 150ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46482, 46474, 46480, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:25:02 Duration: 265ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46474, 46480, 46482, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:48:11 Duration: 188ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46474, 46480, 46482, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 08:00:16 Duration: 187ms
13 31s690ms 33 264ms 4s117ms 960ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 10 23 33 31s690ms 960ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839082, 839084, 839093, 839079);
Date: 2024-03-10 23:52:34 Duration: 4s117ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 20.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839088, 839080);
Date: 2024-03-10 23:52:28 Duration: 1s966ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839098, 839086);
Date: 2024-03-10 23:52:38 Duration: 1s960ms
14 28s638ms 1 28s638ms 28s638ms 28s638ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 10 09 1 28s638ms 28s638ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;
Date: 2024-03-10 09:00:46 Duration: 28s638ms
15 21s157ms 1 21s157ms 21s157ms 21s157ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 10 09 1 21s157ms 21s157ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type) TO stdout;
Date: 2024-03-10 09:10:39 Duration: 21s157ms
16 20s818ms 165 122ms 147ms 126ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 10 10 43 5s438ms 126ms 11 122 15s380ms 126ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3037 and pwi.warehouse_id = 45;
Date: 2024-03-10 11:17:01 Duration: 147ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2925 and pwi.warehouse_id = 41;
Date: 2024-03-10 11:46:54 Duration: 140ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3074 and pwi.warehouse_id = 35;
Date: 2024-03-10 11:33:39 Duration: 139ms
17 18s402ms 10 1s463ms 1s982ms 1s840ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 10 00 10 18s402ms 1s840ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinder%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinder%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinder%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinder%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinder%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinder%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:29 Duration: 1s982ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinde%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinde%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinde%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinde%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:29 Duration: 1s937ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinders%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinders%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinders%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinders%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:30 Duration: 1s899ms
18 16s836ms 29 129ms 2s257ms 580ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 10 23 29 16s836ms 580ms -
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (446380, 408853, 333255);
Date: 2024-03-10 23:52:47 Duration: 2s257ms
-
UPDATE "stock_quant" SET "quantity" = 20.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (397724, 370069);
Date: 2024-03-10 23:52:45 Duration: 1s434ms
-
UPDATE "stock_quant" SET "quantity" = 6.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 366158, 162567);
Date: 2024-03-10 23:52:49 Duration: 1s404ms
19 16s427ms 9 1s461ms 1s966ms 1s825ms select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 10 00 9 16s427ms 1s825ms -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinde%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinde%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinde%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinde%'))));
Date: 2024-03-10 00:28:31 Duration: 1s966ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylin%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylin%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylin%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylin%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylin%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylin%'))));
Date: 2024-03-10 00:28:29 Duration: 1s916ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinders%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinders%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinders%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinders%'))));
Date: 2024-03-10 00:28:34 Duration: 1s867ms
20 16s210ms 1 16s210ms 16s210ms 16s210ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 09 1 16s210ms 16s210ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-10 09:01:10 Duration: 16s210ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 9,099 19m39s 122ms 175ms 129ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 10 10 2,932 6m20s 129ms 11 6,167 13m19s 129ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209506) and warehouse_id = (43));
Date: 2024-03-10 11:03:35 Duration: 175ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209569) and warehouse_id = (42));
Date: 2024-03-10 10:48:11 Duration: 172ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (178318) and warehouse_id = (35));
Date: 2024-03-10 11:26:27 Duration: 166ms
2 1,530 7m56s 120ms 741ms 311ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 10 00 31 11s201ms 361ms 01 33 5s150ms 156ms 02 107 30s107ms 281ms 03 69 20s359ms 295ms 04 21 7s491ms 356ms 05 26 9s555ms 367ms 06 66 22s18ms 333ms 07 80 29s52ms 363ms 08 24 9s292ms 387ms 09 74 22s362ms 302ms 10 102 33s451ms 327ms 11 55 15s128ms 275ms 12 102 33s573ms 329ms 13 102 32s952ms 323ms 14 25 7s627ms 305ms 15 47 10s255ms 218ms 16 8 1s311ms 163ms 17 110 38s664ms 351ms 18 86 25s704ms 298ms 19 62 13s835ms 223ms 20 67 22s975ms 342ms 21 49 14s374ms 293ms 22 127 41s443ms 326ms 23 57 19s103ms 335ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 741ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 10:55:16') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 10:56:07 Duration: 699ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:02') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1011"'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 695ms
3 1,100 2m44s 141ms 238ms 149ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 10 00 90 13s247ms 147ms 01 100 14s856ms 148ms 02 100 14s826ms 148ms 03 70 10s462ms 149ms 04 100 14s896ms 148ms 05 100 14s868ms 148ms 06 100 14s781ms 147ms 07 70 10s389ms 148ms 08 100 14s824ms 148ms 09 100 14s887ms 148ms 10 100 15s610ms 156ms 23 70 10s452ms 149ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261534, 1261533)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:25:02 Duration: 238ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261540, 1261539)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:42:47 Duration: 215ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (46482)) AND (("account_move"."id" not in (1261540, 1261539)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:42:46 Duration: 205ms
4 452 2m26s 316ms 387ms 324ms select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 10 10 147 47s863ms 325ms 11 305 1m39s 324ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:49 Duration: 387ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 11:13:54 Duration: 377ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:39 Duration: 374ms
5 452 1m2s 120ms 176ms 139ms select pwi.product_id, coalesce(pwi.lead_days, ?), coalesce(pwi.min_product_uom_qty, ?) as min_qty, coalesce(pwi.max_product_uom_qty, ?) as max_qty, coalesce(pwi.max_product_uom_qty, ?) - ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) as need_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pt.is_core, false) = false and coalesce(pwi.stocking_flag, false) = true and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < coalesce(pwi.max_product_uom_qty, ?) and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 10 10 147 20s487ms 139ms 11 305 42s408ms 139ms -
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 38 and pwi.inventory_vendor_id = 2906;
Date: 2024-03-10 11:08:52 Duration: 176ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 3080;
Date: 2024-03-10 11:45:01 Duration: 176ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 3080;
Date: 2024-03-10 11:28:58 Duration: 173ms
6 288 37s361ms 123ms 166ms 129ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 10 10 105 13s647ms 129ms 11 183 23s713ms 129ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3089 and pwi.warehouse_id = 41 and pwi.product_id not in (195986, 195869, 195759, 195755, 195753, 195752, 195182, 195171, 195165, 195164, 195053, 194958, 194845, 194841, 194788, 194661, 194660, 194629, 194628, 194603, 194562, 194529, 194125, 195758);
Date: 2024-03-10 11:44:03 Duration: 166ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2933 and pwi.warehouse_id = 43 and pwi.product_id not in (238963, 238947, 238919, 238912);
Date: 2024-03-10 10:57:20 Duration: 163ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3270 and pwi.warehouse_id = 46 and pwi.product_id not in (256752, 256753, 256757, 256508, 256510, 256758);
Date: 2024-03-10 11:21:26 Duration: 156ms
7 223 33s777ms 141ms 265ms 151ms select "account_move".id from "account_move" where ("account_move"."edi_810_id" in (...)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 10 00 18 2s691ms 149ms 01 20 2s988ms 149ms 02 20 2s979ms 148ms 03 15 2s319ms 154ms 04 20 3s 150ms 05 20 3s5ms 150ms 06 20 2s995ms 149ms 07 15 2s266ms 151ms 08 20 3s21ms 151ms 09 20 3s9ms 150ms 10 20 3s242ms 162ms 23 15 2s257ms 150ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46482, 46474, 46480, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:25:02 Duration: 265ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46474, 46480, 46482, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 10:48:11 Duration: 188ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46474, 46480, 46482, 46483, 46484, 46485, 46487, 46490, 46491, 46492, 46493, 46494, 46495, 46496, 46497, 46500, 46501, 46502, 46503, 46505, 46506, 46507, 46508, 46509, 46511, 46513, 46514, 46515, 46518, 46520, 46521, 46523, 46525, 46526, 46527, 46529, 46532, 46535, 46538, 46539)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-10 08:00:16 Duration: 187ms
8 165 20s818ms 122ms 147ms 126ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 10 10 43 5s438ms 126ms 11 122 15s380ms 126ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3037 and pwi.warehouse_id = 45;
Date: 2024-03-10 11:17:01 Duration: 147ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2925 and pwi.warehouse_id = 41;
Date: 2024-03-10 11:46:54 Duration: 140ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3074 and pwi.warehouse_id = 35;
Date: 2024-03-10 11:33:39 Duration: 139ms
9 104 37m16s 21s363ms 21s789ms 21s506ms delete from account_move_line where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 10 00 9 3m13s 21s512ms 01 10 3m35s 21s531ms 02 10 3m34s 21s482ms 03 5 1m47s 21s480ms 04 10 3m34s 21s475ms 05 10 3m34s 21s484ms 06 10 3m35s 21s503ms 07 5 1m47s 21s569ms 08 10 3m34s 21s491ms 09 10 3m34s 21s481ms 10 10 3m35s 21s540ms 23 5 1m47s 21s590ms -
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 08:06:41 Duration: 21s789ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 23:48:58 Duration: 21s767ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 07:54:38 Duration: 21s762ms
10 104 8m16s 4s722ms 5s84ms 4s778ms delete from account_move where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 10 00 9 42s778ms 4s753ms 01 10 47s697ms 4s769ms 02 10 47s701ms 4s770ms 03 5 23s889ms 4s777ms 04 10 47s582ms 4s758ms 05 10 47s922ms 4s792ms 06 10 47s694ms 4s769ms 07 5 23s926ms 4s785ms 08 10 47s679ms 4s767ms 09 10 47s991ms 4s799ms 10 10 48s139ms 4s813ms 23 5 23s974ms 4s794ms -
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 09:24:38 Duration: 5s84ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 05:48:37 Duration: 5s50ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 10:48:40 Duration: 4s988ms
11 102 12s867ms 120ms 150ms 126ms select id from product_warehouse_inventory where freeze_date is not null and freeze_date > ? and warehouse_id = ? and inventory_vendor_id = ? and qty_available < min_product_uom_qty;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 10 10 33 4s191ms 127ms 11 69 8s675ms 125ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-10 10:43:50' and warehouse_id = 42 and inventory_vendor_id = 2939 and qty_available < min_product_uom_qty;
Date: 2024-03-10 10:43:51 Duration: 150ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-10 10:57:49' and warehouse_id = 43 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-03-10 10:57:49 Duration: 144ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-10 11:13:03' and warehouse_id = 45 and inventory_vendor_id = 3080 and qty_available < min_product_uom_qty;
Date: 2024-03-10 11:13:03 Duration: 143ms
12 39 10s887ms 273ms 303ms 279ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 10 02 18 5s21ms 278ms 11 6 1s673ms 278ms 12 3 835ms 278ms 18 9 2s513ms 279ms 21 3 842ms 280ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:03 Duration: 303ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:19:51 Duration: 294ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:19:50 Duration: 292ms
13 38 4s979ms 120ms 164ms 131ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 10 02 2 269ms 134ms 04 1 145ms 145ms 07 1 126ms 126ms 09 1 128ms 128ms 10 1 123ms 123ms 11 1 132ms 132ms 18 2 307ms 153ms 19 13 1s695ms 130ms 20 8 1s33ms 129ms 21 7 895ms 127ms 22 1 121ms 121ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-10 18:26:16 Duration: 164ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-10 19:48:37 Duration: 155ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2024-03-10 20:56:52 Duration: 149ms
14 33 31s690ms 264ms 4s117ms 960ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 10 23 33 31s690ms 960ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839082, 839084, 839093, 839079);
Date: 2024-03-10 23:52:34 Duration: 4s117ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 20.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839088, 839080);
Date: 2024-03-10 23:52:28 Duration: 1s966ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839098, 839086);
Date: 2024-03-10 23:52:38 Duration: 1s960ms
15 30 6s136ms 201ms 208ms 204ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 10 02 9 1s836ms 204ms 11 6 1s223ms 203ms 12 3 609ms 203ms 18 9 1s847ms 205ms 19 3 619ms 206ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:51 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 19:04:03 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:46 Duration: 208ms
16 29 16s836ms 129ms 2s257ms 580ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 10 23 29 16s836ms 580ms -
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (446380, 408853, 333255);
Date: 2024-03-10 23:52:47 Duration: 2s257ms
-
UPDATE "stock_quant" SET "quantity" = 20.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (397724, 370069);
Date: 2024-03-10 23:52:45 Duration: 1s434ms
-
UPDATE "stock_quant" SET "quantity" = 6.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 366158, 162567);
Date: 2024-03-10 23:52:49 Duration: 1s404ms
17 27 7s556ms 275ms 289ms 279ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 10 02 9 2s504ms 278ms 11 6 1s686ms 281ms 12 3 843ms 281ms 18 9 2s522ms 280ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 11:58:54 Duration: 289ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 12:00:22 Duration: 283ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:40 Duration: 283ms
18 27 5s515ms 202ms 208ms 204ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 10 02 9 1s839ms 204ms 11 3 607ms 202ms 12 6 1s226ms 204ms 18 9 1s842ms 204ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:26 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:50 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:49 Duration: 207ms
19 26 9s331ms 351ms 414ms 358ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 10 23 26 9s331ms 358ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:49:15 Duration: 414ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-472a842/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:50:58 Duration: 387ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:50:13 Duration: 385ms
20 23 7s579ms 123ms 3s343ms 329ms select "mail_message".id from "mail_message" where ((((("mail_message"."id" in ( select "mail_message_res_partner_needaction_rel"."mail_message_id" from "mail_message_res_partner_needaction_rel" where ("mail_message_res_partner_needaction_rel"."notification_status" in (...)))) and ("mail_message"."author_id" = ?)) and ("mail_message"."res_id" != ?)) and "mail_message"."model" is not null) and (("mail_message"."message_type" != ?) or "mail_message"."message_type" is null)) order by "mail_message"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 21 1 1s248ms 1s248ms 23 22 6s331ms 287ms -
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19553)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 23:47:34 Duration: 3s343ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19537)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 21:12:58 Duration: 1s248ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19553)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 23:51:00 Duration: 182ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m49s 3m49s 3m49s 1 3m49s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Mar 10 09 1 3m49s 3m49s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-10 09:09:06 Duration: 3m49s
2 1m45s 1m45s 1m45s 1 1m45s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Mar 10 09 1 1m45s 1m45s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2024-03-10 09:03:26 Duration: 1m45s
3 1m40s 1m40s 1m40s 1 1m40s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 10 09 1 1m40s 1m40s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2024-03-10 09:05:15 Duration: 1m40s
4 28s638ms 28s638ms 28s638ms 1 28s638ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Mar 10 09 1 28s638ms 28s638ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;
Date: 2024-03-10 09:00:46 Duration: 28s638ms
5 21s363ms 21s789ms 21s506ms 104 37m16s delete from account_move_line where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 10 00 9 3m13s 21s512ms 01 10 3m35s 21s531ms 02 10 3m34s 21s482ms 03 5 1m47s 21s480ms 04 10 3m34s 21s475ms 05 10 3m34s 21s484ms 06 10 3m35s 21s503ms 07 5 1m47s 21s569ms 08 10 3m34s 21s491ms 09 10 3m34s 21s481ms 10 10 3m35s 21s540ms 23 5 1m47s 21s590ms -
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 08:06:41 Duration: 21s789ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 23:48:58 Duration: 21s767ms
-
DELETE FROM account_move_line WHERE id IN (4276939, 4276940, 4276941, 4276942, 4356123, 4356124, 4356125, 4356126, 4356127, 4356128, 4356129, 4356130, 4366025, 4366026);
Date: 2024-03-10 07:54:38 Duration: 21s762ms
6 21s157ms 21s157ms 21s157ms 1 21s157ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 10 09 1 21s157ms 21s157ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type) TO stdout;
Date: 2024-03-10 09:10:39 Duration: 21s157ms
7 16s210ms 16s210ms 16s210ms 1 16s210ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 10 09 1 16s210ms 16s210ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-03-10 09:01:10 Duration: 16s210ms
8 4s722ms 5s84ms 4s778ms 104 8m16s delete from account_move where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Mar 10 00 9 42s778ms 4s753ms 01 10 47s697ms 4s769ms 02 10 47s701ms 4s770ms 03 5 23s889ms 4s777ms 04 10 47s582ms 4s758ms 05 10 47s922ms 4s792ms 06 10 47s694ms 4s769ms 07 5 23s926ms 4s785ms 08 10 47s679ms 4s767ms 09 10 47s991ms 4s799ms 10 10 48s139ms 4s813ms 23 5 23s974ms 4s794ms -
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 09:24:38 Duration: 5s84ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 05:48:37 Duration: 5s50ms
-
DELETE FROM account_move WHERE id IN (1227784, 1247212, 1250051);
Date: 2024-03-10 10:48:40 Duration: 4s988ms
9 1s463ms 1s982ms 1s840ms 10 18s402ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 10 00 10 18s402ms 1s840ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinder%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinder%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinder%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinder%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinder%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinder%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:29 Duration: 1s982ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinde%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinde%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinde%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinde%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:29 Duration: 1s937ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinders%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinders%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinders%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinders%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2024-03-10 00:28:30 Duration: 1s899ms
10 1s461ms 1s966ms 1s825ms 9 16s427ms select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 10 00 9 16s427ms 1s825ms -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinde%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinde%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinde%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinde%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinde%'))));
Date: 2024-03-10 00:28:31 Duration: 1s966ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylin%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylin%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylin%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylin%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylin%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylin%'))));
Date: 2024-03-10 00:28:29 Duration: 1s916ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tailgate%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tailgate%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tailgate%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tailgate%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tailgate%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%air%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%air%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%air%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%air%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%air%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%air%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%cylinders%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%cylinders%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%cylinders%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%cylinders%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%cylinders%'))));
Date: 2024-03-10 00:28:34 Duration: 1s867ms
11 264ms 4s117ms 960ms 33 31s690ms update "stock_move" set "current_warehouse_qty" = ?.?, "date" = ?, "is_done" = true, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 10 23 33 31s690ms 960ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 4.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839082, 839084, 839093, 839079);
Date: 2024-03-10 23:52:34 Duration: 4s117ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 20.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839088, 839080);
Date: 2024-03-10 23:52:28 Duration: 1s966ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 6.0, "date" = '2024-03-10 23:52:16', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (839098, 839086);
Date: 2024-03-10 23:52:38 Duration: 1s960ms
12 129ms 2s257ms 580ms 29 16s836ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 10 23 29 16s836ms 580ms -
UPDATE "stock_quant" SET "quantity" = 4.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (446380, 408853, 333255);
Date: 2024-03-10 23:52:47 Duration: 2s257ms
-
UPDATE "stock_quant" SET "quantity" = 20.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (397724, 370069);
Date: 2024-03-10 23:52:45 Duration: 1s434ms
-
UPDATE "stock_quant" SET "quantity" = 6.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 366158, 162567);
Date: 2024-03-10 23:52:49 Duration: 1s404ms
13 351ms 414ms 358ms 26 9s331ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Mar 10 23 26 9s331ms 358ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:49:15 Duration: 414ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-472a842/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:50:58 Duration: 387ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-fb6cd24/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-10 23:50:13 Duration: 385ms
14 123ms 3s343ms 329ms 23 7s579ms select "mail_message".id from "mail_message" where ((((("mail_message"."id" in ( select "mail_message_res_partner_needaction_rel"."mail_message_id" from "mail_message_res_partner_needaction_rel" where ("mail_message_res_partner_needaction_rel"."notification_status" in (...)))) and ("mail_message"."author_id" = ?)) and ("mail_message"."res_id" != ?)) and "mail_message"."model" is not null) and (("mail_message"."message_type" != ?) or "mail_message"."message_type" is null)) order by "mail_message"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 10 21 1 1s248ms 1s248ms 23 22 6s331ms 287ms -
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19553)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 23:47:34 Duration: 3s343ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19537)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 21:12:58 Duration: 1s248ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 19553)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2024-03-10 23:51:00 Duration: 182ms
15 316ms 387ms 324ms 452 2m26s select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 10 10 147 47s863ms 325ms 11 305 1m39s 324ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 3105 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:49 Duration: 387ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 11:13:54 Duration: 377ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2929 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-10 10:42:39 Duration: 374ms
16 120ms 741ms 311ms 1,530 7m56s select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 10 00 31 11s201ms 361ms 01 33 5s150ms 156ms 02 107 30s107ms 281ms 03 69 20s359ms 295ms 04 21 7s491ms 356ms 05 26 9s555ms 367ms 06 66 22s18ms 333ms 07 80 29s52ms 363ms 08 24 9s292ms 387ms 09 74 22s362ms 302ms 10 102 33s451ms 327ms 11 55 15s128ms 275ms 12 102 33s573ms 329ms 13 102 32s952ms 323ms 14 25 7s627ms 305ms 15 47 10s255ms 218ms 16 8 1s311ms 163ms 17 110 38s664ms 351ms 18 86 25s704ms 298ms 19 62 13s835ms 223ms 20 67 22s975ms 342ms 21 49 14s374ms 293ms 22 127 41s443ms 326ms 23 57 19s103ms 335ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:01') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 741ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 10:55:16') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","mail.channel",553]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 10:56:07 Duration: 699ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-10 17:44:02') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1011"'))) ORDER BY "bus_bus"."id";
Date: 2024-03-10 17:44:52 Duration: 695ms
17 275ms 289ms 279ms 27 7s556ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 10 02 9 2s504ms 278ms 11 6 1s686ms 281ms 12 3 843ms 281ms 18 9 2s522ms 280ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 11:58:54 Duration: 289ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 12:00:22 Duration: 283ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:40 Duration: 283ms
18 273ms 303ms 279ms 39 10s887ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 10 02 18 5s21ms 278ms 11 6 1s673ms 278ms 12 3 835ms 278ms 18 9 2s513ms 279ms 21 3 842ms 280ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:03 Duration: 303ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:19:51 Duration: 294ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:19:50 Duration: 292ms
19 201ms 208ms 204ms 30 6s136ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Mar 10 02 9 1s836ms 204ms 11 6 1s223ms 203ms 12 3 609ms 203ms 18 9 1s847ms 205ms 19 3 619ms 206ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:51 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 19:04:03 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:46 Duration: 208ms
20 202ms 208ms 204ms 27 5s515ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 10 02 9 1s839ms 204ms 11 3 607ms 202ms 12 6 1s226ms 204ms 18 9 1s842ms 204ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 02:03:26 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:50 Duration: 208ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2024-03-10 18:55:49 Duration: 207ms
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
- 16,910 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1300 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1,061 Max number of times the same event was reported
- 1,300 Total events found
Rank Times reported Error 1 1,061 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 10 00 51 01 56 02 60 03 42 04 71 05 64 06 61 07 110 08 116 09 70 10 65 11 24 12 24 13 19 14 22 15 21 16 17 17 21 18 19 19 20 20 25 21 22 22 17 23 44 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=67 FOR UPDATE NOWAIT
Date: 2024-03-10 08:50:09
2 104 ERROR: new row for relation "..." violates check constraint "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 10 00 9 01 10 02 10 03 5 04 10 05 10 06 10 07 5 08 10 09 10 10 10 23 5 - ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_amount_currency_balance_sign"
Detail: Failing row contains (4270557, 1225862, /, 2024-02-20, 0090043801, draft, 2, 1, 2, 14, 50048, 10, , 1.00, -357.32, 0.00, 0.00, 360.93, -360.93, -357.32, -357.32, -357.32, f, f, 2024-03-01, 2, 30565, null, null, null, null, null, null, null, null, null, t, null, , -360.93, -357.32, null, null, null, null, null, t, 1, 2024-02-23 06:00:16.107708, 1, 2024-03-10 08:54:09.553419, null, null, null, null, null, null, null, 44, Akron, null, new_product, 1, 357.32, null, null, null, null, null, null, null, null, null, t, null, exception, null, null, null, null, null, f, f, null, f, f, f).
Statement: UPDATE "account_move_line" SET "amount_currency"='-357.32',"amount_residual_currency"='-357.32',"price_subtotal"='-357.32',"price_total"='-357.32',"price_unit"='-357.32',"sign_price_subtotal"='357.32',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (4270557)Date: 2024-03-10 08:54:44
3 104 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 10 00 9 01 10 02 10 03 5 04 10 05 10 06 10 07 5 08 10 09 10 10 10 23 5 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: INSERT INTO "edi_810_scheduler_details" ("id", "create_uid", "create_date", "write_uid", "write_date", "edi_810_ref", "rec_status", "total_time") VALUES (nextval('edi_810_scheduler_details_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), '0090043801', 'Match', '1.2612528800964355') RETURNING id
Date: 2024-03-10 08:54:44
4 31 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 10 00 1 02 1 03 1 04 1 10 2 12 2 13 1 14 1 17 1 19 8 22 10 23 2 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2024-03-10 02:46:15' WHERE id IN (74)
Date: 2024-03-10 02:46:15