pgBadger-
Global information
- Generated on Mon Mar 18 00:50:04 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 29,739 log entries in 3s
- Log start from 2024-03-17 00:06:16 to 2024-03-17 23:56:30
-
Overview
Global Stats
- 191 Number of unique normalized queries
- 12,954 Number of queries
- 52m56s Total query duration
- 2024-03-17 00:06:16 First query
- 2024-03-17 23:56:30 Last query
- 14 queries/s at 2024-03-17 11:44:48 Query peak
- 52m56s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 52m56s Execute total duration
- 927 Number of events
- 4 Number of unique normalized events
- 592 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
- 12,954 Average queries per session
- 52m56s 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
- 14 queries/s Query Peak
- 2024-03-17 11:44:48 Date
SELECT Traffic
Key values
- 12 queries/s Query Peak
- 2024-03-17 14:14:57 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 7 queries/s Query Peak
- 2024-03-17 10:42:56 Date
Queries duration
Key values
- 52m56s 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 17 00 75 0ms 1s564ms 344ms 2s167ms 2s355ms 2s355ms 01 73 0ms 1s560ms 369ms 2s210ms 2s329ms 2s342ms 02 63 0ms 1s576ms 410ms 2s207ms 2s211ms 4s376ms 03 81 0ms 4s610ms 410ms 2s204ms 2s220ms 6s552ms 04 419 0ms 2s249ms 502ms 7s928ms 8s486ms 16s844ms 05 93 0ms 1s546ms 389ms 2s384ms 4s229ms 6s193ms 06 69 0ms 1s570ms 361ms 2s181ms 2s301ms 2s301ms 07 71 0ms 1s666ms 327ms 2s195ms 4s819ms 4s819ms 08 81 0ms 1s545ms 364ms 2s212ms 2s399ms 2s711ms 09 171 0ms 3m49s 4s152ms 1m38s 1m54s 4m45s 10 3,454 120ms 19s824ms 167ms 33s410ms 36s355ms 42s921ms 11 7,634 120ms 1s748ms 159ms 33s241ms 34s895ms 41s737ms 12 59 0ms 360ms 229ms 1s454ms 1s702ms 8s785ms 13 10 0ms 380ms 241ms 654ms 1s762ms 1s762ms 14 60 0ms 416ms 250ms 2s301ms 3s360ms 3s360ms 15 26 0ms 397ms 218ms 2s177ms 2s177ms 2s177ms 16 37 0ms 828ms 288ms 1s699ms 1s870ms 1s880ms 17 11 0ms 411ms 230ms 2s402ms 2s402ms 2s402ms 18 48 0ms 362ms 236ms 2s940ms 5s877ms 5s877ms 19 56 0ms 15s350ms 872ms 5s440ms 32s775ms 32s775ms 20 127 0ms 2s133ms 364ms 5s282ms 8s32ms 11s953ms 21 51 0ms 990ms 276ms 2s958ms 3s530ms 3s530ms 22 89 0ms 1s935ms 367ms 7s267ms 7s569ms 7s569ms 23 96 0ms 4s606ms 365ms 2s411ms 2s596ms 6s623ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 17 00 66 0 180ms 979ms 1s416ms 1s879ms 01 63 0 183ms 636ms 677ms 2s342ms 02 53 0 196ms 637ms 673ms 2s826ms 03 71 0 223ms 964ms 1s436ms 1s968ms 04 240 0 242ms 1s609ms 2s483ms 3s150ms 05 73 0 194ms 1s192ms 1s337ms 2s691ms 06 59 0 160ms 764ms 980ms 1s39ms 07 64 0 191ms 1s305ms 1s361ms 3s153ms 08 70 0 194ms 656ms 1s648ms 2s399ms 09 58 103 4s314ms 49s686ms 1m38s 4m45s 10 658 0 235ms 7s226ms 10s517ms 25s511ms 11 1,354 0 219ms 7s737ms 9s80ms 12s383ms 12 59 0 229ms 623ms 1s454ms 8s785ms 13 10 0 241ms 0ms 654ms 1s762ms 14 60 0 250ms 2s170ms 2s301ms 3s360ms 15 26 0 218ms 1s845ms 2s177ms 2s177ms 16 37 0 288ms 1s138ms 1s699ms 1s880ms 17 11 0 230ms 136ms 2s402ms 2s402ms 18 48 0 236ms 1s628ms 2s940ms 5s877ms 19 54 0 808ms 1s571ms 2s170ms 32s775ms 20 85 0 331ms 2s931ms 3s520ms 6s664ms 21 51 0 276ms 2s308ms 2s958ms 3s530ms 22 74 0 360ms 2s931ms 3s455ms 7s321ms 23 87 0 206ms 877ms 1s732ms 2s596ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Mar 17 00 0 0 9 0 1s545ms 1s537ms 1s542ms 1s564ms 01 0 0 10 0 1s539ms 1s532ms 1s539ms 1s560ms 02 0 0 10 0 1s543ms 1s530ms 1s542ms 1s576ms 03 0 0 9 0 1s893ms 0ms 1s535ms 6s245ms 04 0 169 10 0 850ms 3s131ms 3s854ms 7s660ms 05 0 10 10 0 1s102ms 1s536ms 1s541ms 3s874ms 06 0 0 10 0 1s543ms 1s537ms 1s543ms 1s570ms 07 0 0 7 0 1s563ms 0ms 1s538ms 1s666ms 08 0 1 10 0 1s448ms 1s535ms 1s538ms 1s545ms 09 0 0 10 0 1s542ms 1s536ms 1s539ms 1s558ms 10 0 2,786 10 0 151ms 13s678ms 20s937ms 35s624ms 11 0 6,280 0 0 146ms 17s4ms 23s504ms 31s364ms 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 1 1 0 2s601ms 0ms 0ms 4s955ms 20 0 42 0 0 431ms 0ms 501ms 11s953ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 15 0 0 401ms 0ms 0ms 5s525ms 23 0 0 9 0 1s901ms 0ms 1s535ms 1s558ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Mar 17 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 17 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 17 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 17 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 17 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 17 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 17 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 17 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 17 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
- 3,431 Total read queries
- 9,523 Total write queries
Queries by database
Key values
- unknown Main database
- 12,954 Requests
- 52m56s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 12,954 Requests
User Request type Count Duration unknown Total 12,954 52m56s copy to 103 11m25s cte 1 364ms delete 115 3m7s select 3,431 13m29s update 9,304 24m53s Duration by user
Key values
- 52m56s (unknown) Main time consuming user
User Request type Count Duration unknown Total 12,954 52m56s copy to 103 11m25s cte 1 364ms delete 115 3m7s select 3,431 13m29s update 9,304 24m53s Queries by host
Key values
- unknown Main host
- 12,954 Requests
- 52m56s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 12,954 Requests
- 52m56s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-03-17 05:03:33 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 12,518 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-17 09:09:02 ]
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-17 09:03:26 ]
3 1m37s 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-17 09:05:12 ]
4 28s975ms 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-17 09:00:47 ]
5 21s215ms 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-17 09:10:36 ]
6 19s824ms select count(id) from item_list_line where item_demand_plan_id = 3847;[ Date: 2024-03-17 10:36:44 ]
7 16s318ms 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-17 09:01:11 ]
8 16s142ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2024-03-17 09:11:29 ]
9 15s350ms select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;[ Date: 2024-03-17 19:50:23 ]
10 14s229ms select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;[ Date: 2024-03-17 19:50:23 ]
11 12s225ms COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type, from_ar, auto_reconcile, related_payment_id, discount_amount_applied) TO stdout;[ Date: 2024-03-17 09:00:18 ]
12 9s494ms COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-03-17 09:09:13 ]
13 8s894ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-03-17 09:01:21 ]
14 8s145ms COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core, inventory_vendor_id) TO stdout;[ Date: 2024-03-17 09:10:56 ]
15 6s628ms COPY public.forecasted_data (id, date, min_product_uom_qty, max_product_uom_qty, item_supply_plan_id, po_qty, 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, default_code, ext_cost, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_mtd_sold, lead_days, mon_1_qty, mon_2_qty, mon_3_qty, mon_4_qty, mon_5_qty, mon_6_qty, mon_7_qty, mon_8_qty, mon_9_qty, mon_10_qty, mon_11_qty, mon_12_qty, seasonal, stocking_flag, freeze_date, warehouse_min_product_uom_qty, is_forcast, modify_qty, req_po_qty, supercede_product_id, superceded, final_branch_id, po_id, unit_ext_cost, is_freeze, qty_in_transist, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, is_new_stock_product, ref_id, ref, product_name, is_stock_flag_product, class_code_id, sft_stk_qty, need_qty_with_sft_stk) TO stdout;[ Date: 2024-03-17 09:01:33 ]
16 5s727ms COPY public.stock_move_line (id, picking_id, move_id, company_id, product_id, product_uom_id, product_qty, product_uom_qty, qty_done, package_id, package_level_id, lot_id, lot_name, result_package_id, date, owner_id, location_id, location_dest_id, state, reference, description_picking, create_uid, create_date, write_uid, write_date, workorder_id, production_id, related_core_sale_line_id, related_sale_line_id, related_core_purchase_line_id, related_purchase_line_id, related_core_stock_line_id, move_options, purchase_qty, related_repair_line_id, related_core_repair_line_id, branch_id, related_core_bom_line_id, related_bom_line_id, related_raw_material_production_id, linked_has_core_ml_id, order_purchase_qty, current_warehouse_qty, description) TO stdout;[ Date: 2024-03-17 09:11:01 ]
17 5s617ms COPY public.stock_valuation_layer (id, company_id, product_id, quantity, unit_cost, value, remaining_qty, remaining_value, description, stock_valuation_layer_id, stock_move_id, account_move_id, create_uid, create_date, write_uid, write_date, move_options, other_action, final_action) TO stdout;[ Date: 2024-03-17 09:11:13 ]
18 5s89ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2024-03-17 09:09:21 ]
19 5s42ms COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2024-03-17 09:11:34 ]
20 4s955ms DELETE FROM sale_order_line WHERE id IN (362330);[ Date: 2024-03-17 19:52:05 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 22m5s 9,066 138ms 285ms 146ms 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 17 10 2,786 6m47s 146ms 11 6,280 15m17s 146ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209268) and warehouse_id = (37));
Date: 2024-03-17 11:44:48 Duration: 285ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (227380) and warehouse_id = (45));
Date: 2024-03-17 11:14:57 Duration: 198ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (189594) and warehouse_id = (42));
Date: 2024-03-17 10:40:26 Duration: 195ms
2 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 #2
Day Hour Count Duration Avg duration Mar 17 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-17 09:09:02 Duration: 3m49s
3 2m59s 112 1s524ms 4s610ms 1s598ms delete from account_move_line where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Mar 17 00 9 13s912ms 1s545ms 01 10 15s399ms 1s539ms 02 10 15s433ms 1s543ms 03 8 15s406ms 1s925ms 04 10 15s494ms 1s549ms 05 10 15s388ms 1s538ms 06 10 15s436ms 1s543ms 07 7 10s941ms 1s563ms 08 10 15s386ms 1s538ms 09 10 15s425ms 1s542ms 10 10 15s433ms 1s543ms 23 8 15s395ms 1s924ms -
DELETE FROM account_move_line WHERE id IN (4514444, 4514445, 4514446);
Date: 2024-03-17 03:12:13 Duration: 4s610ms
-
DELETE FROM account_move_line WHERE id IN (4514863, 4514864, 4514865);
Date: 2024-03-17 23:12:17 Duration: 4s606ms
-
DELETE FROM account_move_line WHERE id IN (4514869);
Date: 2024-03-17 07:30:20 Duration: 1s666ms
4 2m57s 510 338ms 414ms 347ms 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 17 10 155 53s876ms 347ms 11 355 2m3s 347ms -
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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:23:09 Duration: 414ms
-
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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 10:49:39 Duration: 392ms
-
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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:35:14 Duration: 389ms
5 2m25s 651 120ms 446ms 223ms 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 #5
Day Hour Count Duration Avg duration Mar 17 00 30 6s344ms 211ms 01 20 4s671ms 233ms 02 9 2s336ms 259ms 03 24 5s198ms 216ms 04 19 4s615ms 242ms 05 24 5s428ms 226ms 06 19 3s230ms 170ms 07 27 6s559ms 242ms 08 29 7s258ms 250ms 09 17 2s629ms 154ms 10 24 4s384ms 182ms 11 33 7s367ms 223ms 12 23 4s770ms 207ms 13 7 1s762ms 251ms 14 60 15s15ms 250ms 15 26 5s689ms 218ms 16 24 5s217ms 217ms 17 10 2s402ms 240ms 18 12 2s555ms 212ms 19 41 8s787ms 214ms 20 52 10s535ms 202ms 21 48 11s130ms 231ms 22 49 12s391ms 252ms 23 24 5s 208ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 11:43:57') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19566]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",431]', '["pointspring_master","mail.channel",505]', '["pointspring_master","mail.channel",523]', '["pointspring_master","res.partner",19566]', '["pointspring_master","ir.needaction",19566]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 11:44:48 Duration: 446ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19575]', '["pointspring_master","mail.channel",56]', '["pointspring_master","mail.channel",57]', '["pointspring_master","mail.channel",58]', '["pointspring_master","mail.channel",65]', '["pointspring_master","mail.channel",504]', '["pointspring_master","mail.channel",605]', '["pointspring_master","res.partner",19575]', '["pointspring_master","ir.needaction",19575]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 441ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19568]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",248]', '["pointspring_master","mail.channel",285]', '["pointspring_master","mail.channel",526]', '["pointspring_master","mail.channel",561]', '["pointspring_master","mail.channel",607]', '["pointspring_master","res.partner",19568]', '["pointspring_master","ir.needaction",19568]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 430ms
6 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 #6
Day Hour Count Duration Avg duration Mar 17 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-17 09:03:26 Duration: 1m45s
7 1m37s 1 1m37s 1m37s 1m37s 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 #7
Day Hour Count Duration Avg duration Mar 17 09 1 1m37s 1m37s -
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-17 09:05:12 Duration: 1m37s
8 1m22s 85 309ms 2s249ms 975ms 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 #8
Day Hour Count Duration Avg duration Mar 17 04 78 1m16s 982ms 05 3 2s570ms 856ms 20 4 3s654ms 913ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849731, 849735);
Date: 2024-03-17 04:15:51 Duration: 2s249ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849725, 849727);
Date: 2024-03-17 04:15:47 Duration: 2s196ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 24.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849738, 849732);
Date: 2024-03-17 04:15:53 Duration: 1s576ms
9 1m13s 510 126ms 184ms 143ms 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 #9
Day Hour Count Duration Avg duration Mar 17 10 155 22s290ms 143ms 11 355 50s838ms 143ms -
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 = 3062;
Date: 2024-03-17 11:52:12 Duration: 184ms
-
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 = 3043;
Date: 2024-03-17 11:50:08 Duration: 181ms
-
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 = 2973;
Date: 2024-03-17 11:51:31 Duration: 170ms
10 41s79ms 305 128ms 154ms 134ms 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 #10
Day Hour Count Duration Avg duration Mar 17 10 103 13s808ms 134ms 11 202 27s270ms 135ms -
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 = 2970 and pwi.warehouse_id = 46 and pwi.product_id not in (177345);
Date: 2024-03-17 11:20:38 Duration: 154ms
-
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 = 3085 and pwi.warehouse_id = 43 and pwi.product_id not in (188015, 187912, 187910, 187909, 187887, 187824, 187682, 187581);
Date: 2024-03-17 11:05:25 Duration: 154ms
-
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 = 2983 and pwi.warehouse_id = 43 and pwi.product_id not in (210100, 210099, 210088, 210041, 209721, 209373, 209436, 209537, 209462, 209259, 209513, 209335, 209438);
Date: 2024-03-17 11:08:38 Duration: 154ms
11 40s77ms 111 355ms 437ms 361ms 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 #11
Day Hour Count Duration Avg duration Mar 17 04 95 34s338ms 361ms 05 6 2s144ms 357ms 16 3 1s70ms 356ms 19 3 1s67ms 355ms 22 3 1s98ms 366ms 23 1 358ms 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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:48:17 Duration: 437ms
-
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.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:32:52 Duration: 426ms
-
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/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:44:06 Duration: 403ms
12 38s171ms 246 145ms 209ms 155ms 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 #12
Day Hour Count Duration Avg duration Mar 17 00 18 2s808ms 156ms 01 20 3s99ms 154ms 02 20 3s165ms 158ms 03 19 2s957ms 155ms 04 20 3s157ms 157ms 05 20 3s79ms 153ms 06 20 3s81ms 154ms 07 19 2s911ms 153ms 08 20 3s40ms 152ms 09 20 3s19ms 150ms 10 24 3s879ms 161ms 23 26 3s970ms 152ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:17 Duration: 209ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 00:18:15 Duration: 205ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 04:00:11 Duration: 194ms
13 36s313ms 231 145ms 210ms 157ms 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 #13
Day Hour Count Duration Avg duration Mar 17 00 18 2s759ms 153ms 01 20 3s134ms 156ms 02 20 3s141ms 157ms 03 18 2s808ms 156ms 04 20 3s170ms 158ms 05 20 3s139ms 156ms 06 20 3s167ms 158ms 07 17 2s626ms 154ms 08 20 3s207ms 160ms 09 20 3s113ms 155ms 10 20 3s214ms 160ms 23 18 2s832ms 157ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:15 Duration: 210ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 08:36:15 Duration: 202ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 06:42:32 Duration: 197ms
14 32s167ms 51 143ms 1s615ms 630ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Mar 17 04 47 30s7ms 638ms 05 4 2s160ms 540ms -
UPDATE "stock_quant" SET "quantity" = 8.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 414351);
Date: 2024-03-17 04:15:58 Duration: 1s615ms
-
UPDATE "stock_quant" SET "quantity" = 12.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357570, 366159);
Date: 2024-03-17 04:16:01 Duration: 1s610ms
-
UPDATE "stock_quant" SET "quantity" = 24.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357571, 56679);
Date: 2024-03-17 04:16:02 Duration: 974ms
15 29s579ms 2 14s229ms 15s350ms 14s789ms select * from ( select a.id, ? from product_template as a where a.is_core = false and (a.name ilike ? or a.condensed_internal_ref ilike ?) and a.inventory_vendor_id = ? union all select b.id, ? from product_library as b where (b.name ilike ? or b.default_code ilike ? or b.condensed_product_name ilike ?) and b.inventory_vendor_id = ?) n;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 17 19 2 29s579ms 14s789ms -
select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;
Date: 2024-03-17 19:50:23 Duration: 15s350ms
-
select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;
Date: 2024-03-17 19:50:23 Duration: 14s229ms
16 28s975ms 1 28s975ms 28s975ms 28s975ms 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 #16
Day Hour Count Duration Avg duration Mar 17 09 1 28s975ms 28s975ms -
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-17 09:00:47 Duration: 28s975ms
17 27s238ms 11 733ms 19s824ms 2s476ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 17 10 5 22s774ms 4s554ms 11 6 4s463ms 743ms -
select count(id) from item_list_line where item_demand_plan_id = 3847;
Date: 2024-03-17 10:36:44 Duration: 19s824ms
-
select count(id) from item_list_line where item_demand_plan_id = 3851;
Date: 2024-03-17 11:19:30 Duration: 748ms
-
select count(id) from item_list_line where item_demand_plan_id = 3840;
Date: 2024-03-17 11:29:27 Duration: 745ms
18 26s870ms 205 127ms 154ms 131ms 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 #18
Day Hour Count Duration Avg duration Mar 17 10 51 6s672ms 130ms 11 154 20s197ms 131ms -
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 = 3289 and pwi.warehouse_id = 46;
Date: 2024-03-17 11:22:37 Duration: 154ms
-
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 = 2973 and pwi.warehouse_id = 44;
Date: 2024-03-17 10:58:22 Duration: 151ms
-
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 = 3050 and pwi.warehouse_id = 43;
Date: 2024-03-17 11:03:40 Duration: 150ms
19 24s309ms 191 120ms 155ms 127ms 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 #19
Day Hour Count Duration Avg duration Mar 17 10 60 7s600ms 126ms 11 131 16s709ms 127ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:17:26' and warehouse_id = 45 and inventory_vendor_id = 3025 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:17:26 Duration: 155ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:37:56' and warehouse_id = 35 and inventory_vendor_id = 3105 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:37:56 Duration: 153ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:45:28' and warehouse_id = 37 and inventory_vendor_id = 2985 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:45:29 Duration: 146ms
20 23s997ms 37 630ms 679ms 648ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Mar 17 19 3 1s976ms 658ms 20 18 11s584ms 643ms 22 16 10s436ms 652ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A4707QVL20KBLSShoeKi%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:57 Duration: 679ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707qvl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707qvl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707qvl%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:22 Duration: 674ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%ES597%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ES597%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ES597%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 19:51:32 Duration: 670ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 9,066 22m5s 138ms 285ms 146ms 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 17 10 2,786 6m47s 146ms 11 6,280 15m17s 146ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209268) and warehouse_id = (37));
Date: 2024-03-17 11:44:48 Duration: 285ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (227380) and warehouse_id = (45));
Date: 2024-03-17 11:14:57 Duration: 198ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (189594) and warehouse_id = (42));
Date: 2024-03-17 10:40:26 Duration: 195ms
2 651 2m25s 120ms 446ms 223ms 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 17 00 30 6s344ms 211ms 01 20 4s671ms 233ms 02 9 2s336ms 259ms 03 24 5s198ms 216ms 04 19 4s615ms 242ms 05 24 5s428ms 226ms 06 19 3s230ms 170ms 07 27 6s559ms 242ms 08 29 7s258ms 250ms 09 17 2s629ms 154ms 10 24 4s384ms 182ms 11 33 7s367ms 223ms 12 23 4s770ms 207ms 13 7 1s762ms 251ms 14 60 15s15ms 250ms 15 26 5s689ms 218ms 16 24 5s217ms 217ms 17 10 2s402ms 240ms 18 12 2s555ms 212ms 19 41 8s787ms 214ms 20 52 10s535ms 202ms 21 48 11s130ms 231ms 22 49 12s391ms 252ms 23 24 5s 208ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 11:43:57') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19566]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",431]', '["pointspring_master","mail.channel",505]', '["pointspring_master","mail.channel",523]', '["pointspring_master","res.partner",19566]', '["pointspring_master","ir.needaction",19566]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 11:44:48 Duration: 446ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19575]', '["pointspring_master","mail.channel",56]', '["pointspring_master","mail.channel",57]', '["pointspring_master","mail.channel",58]', '["pointspring_master","mail.channel",65]', '["pointspring_master","mail.channel",504]', '["pointspring_master","mail.channel",605]', '["pointspring_master","res.partner",19575]', '["pointspring_master","ir.needaction",19575]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 441ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19568]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",248]', '["pointspring_master","mail.channel",285]', '["pointspring_master","mail.channel",526]', '["pointspring_master","mail.channel",561]', '["pointspring_master","mail.channel",607]', '["pointspring_master","res.partner",19568]', '["pointspring_master","ir.needaction",19568]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 430ms
3 510 2m57s 338ms 414ms 347ms 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 #3
Day Hour Count Duration Avg duration Mar 17 10 155 53s876ms 347ms 11 355 2m3s 347ms -
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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:23:09 Duration: 414ms
-
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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 10:49:39 Duration: 392ms
-
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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:35:14 Duration: 389ms
4 510 1m13s 126ms 184ms 143ms 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 #4
Day Hour Count Duration Avg duration Mar 17 10 155 22s290ms 143ms 11 355 50s838ms 143ms -
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 = 3062;
Date: 2024-03-17 11:52:12 Duration: 184ms
-
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 = 3043;
Date: 2024-03-17 11:50:08 Duration: 181ms
-
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 = 2973;
Date: 2024-03-17 11:51:31 Duration: 170ms
5 305 41s79ms 128ms 154ms 134ms 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 #5
Day Hour Count Duration Avg duration Mar 17 10 103 13s808ms 134ms 11 202 27s270ms 135ms -
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 = 2970 and pwi.warehouse_id = 46 and pwi.product_id not in (177345);
Date: 2024-03-17 11:20:38 Duration: 154ms
-
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 = 3085 and pwi.warehouse_id = 43 and pwi.product_id not in (188015, 187912, 187910, 187909, 187887, 187824, 187682, 187581);
Date: 2024-03-17 11:05:25 Duration: 154ms
-
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 = 2983 and pwi.warehouse_id = 43 and pwi.product_id not in (210100, 210099, 210088, 210041, 209721, 209373, 209436, 209537, 209462, 209259, 209513, 209335, 209438);
Date: 2024-03-17 11:08:38 Duration: 154ms
6 246 38s171ms 145ms 209ms 155ms 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 17 00 18 2s808ms 156ms 01 20 3s99ms 154ms 02 20 3s165ms 158ms 03 19 2s957ms 155ms 04 20 3s157ms 157ms 05 20 3s79ms 153ms 06 20 3s81ms 154ms 07 19 2s911ms 153ms 08 20 3s40ms 152ms 09 20 3s19ms 150ms 10 24 3s879ms 161ms 23 26 3s970ms 152ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:17 Duration: 209ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 00:18:15 Duration: 205ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 04:00:11 Duration: 194ms
7 231 36s313ms 145ms 210ms 157ms 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 17 00 18 2s759ms 153ms 01 20 3s134ms 156ms 02 20 3s141ms 157ms 03 18 2s808ms 156ms 04 20 3s170ms 158ms 05 20 3s139ms 156ms 06 20 3s167ms 158ms 07 17 2s626ms 154ms 08 20 3s207ms 160ms 09 20 3s113ms 155ms 10 20 3s214ms 160ms 23 18 2s832ms 157ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:15 Duration: 210ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 08:36:15 Duration: 202ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 06:42:32 Duration: 197ms
8 205 26s870ms 127ms 154ms 131ms 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 17 10 51 6s672ms 130ms 11 154 20s197ms 131ms -
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 = 3289 and pwi.warehouse_id = 46;
Date: 2024-03-17 11:22:37 Duration: 154ms
-
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 = 2973 and pwi.warehouse_id = 44;
Date: 2024-03-17 10:58:22 Duration: 151ms
-
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 = 3050 and pwi.warehouse_id = 43;
Date: 2024-03-17 11:03:40 Duration: 150ms
9 191 24s309ms 120ms 155ms 127ms 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 #9
Day Hour Count Duration Avg duration Mar 17 10 60 7s600ms 126ms 11 131 16s709ms 127ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:17:26' and warehouse_id = 45 and inventory_vendor_id = 3025 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:17:26 Duration: 155ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:37:56' and warehouse_id = 35 and inventory_vendor_id = 3105 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:37:56 Duration: 153ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-03-17 11:45:28' and warehouse_id = 37 and inventory_vendor_id = 2985 and qty_available < min_product_uom_qty;
Date: 2024-03-17 11:45:29 Duration: 146ms
10 112 2m59s 1s524ms 4s610ms 1s598ms delete from account_move_line where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 17 00 9 13s912ms 1s545ms 01 10 15s399ms 1s539ms 02 10 15s433ms 1s543ms 03 8 15s406ms 1s925ms 04 10 15s494ms 1s549ms 05 10 15s388ms 1s538ms 06 10 15s436ms 1s543ms 07 7 10s941ms 1s563ms 08 10 15s386ms 1s538ms 09 10 15s425ms 1s542ms 10 10 15s433ms 1s543ms 23 8 15s395ms 1s924ms -
DELETE FROM account_move_line WHERE id IN (4514444, 4514445, 4514446);
Date: 2024-03-17 03:12:13 Duration: 4s610ms
-
DELETE FROM account_move_line WHERE id IN (4514863, 4514864, 4514865);
Date: 2024-03-17 23:12:17 Duration: 4s606ms
-
DELETE FROM account_move_line WHERE id IN (4514869);
Date: 2024-03-17 07:30:20 Duration: 1s666ms
11 111 40s77ms 355ms 437ms 361ms 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 #11
Day Hour Count Duration Avg duration Mar 17 04 95 34s338ms 361ms 05 6 2s144ms 357ms 16 3 1s70ms 356ms 19 3 1s67ms 355ms 22 3 1s98ms 366ms 23 1 358ms 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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:48:17 Duration: 437ms
-
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.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:32:52 Duration: 426ms
-
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/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:44:06 Duration: 403ms
12 108 13s346ms 120ms 133ms 123ms select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > ? and warehouse_id = ? and ((coalesce(qty_available, ?) + coalesce(qty_on_order, ?)) - coalesce(qty_reserve, ?)) < ? and inventory_vendor_id = ? and coalesce(superceded, false) = false and coalesce(discontinued, false) = false and coalesce(is_core, false) = false;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Mar 17 10 45 5s558ms 123ms 11 63 7s788ms 123ms -
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 38 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2978 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-03-17 11:01:23 Duration: 133ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 46 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 3021 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-03-17 11:21:07 Duration: 132ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 39 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2949 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-03-17 10:55:59 Duration: 132ms
13 85 1m22s 309ms 2s249ms 975ms 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 17 04 78 1m16s 982ms 05 3 2s570ms 856ms 20 4 3s654ms 913ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849731, 849735);
Date: 2024-03-17 04:15:51 Duration: 2s249ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849725, 849727);
Date: 2024-03-17 04:15:47 Duration: 2s196ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 24.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849738, 849732);
Date: 2024-03-17 04:15:53 Duration: 1s576ms
14 77 11s838ms 120ms 353ms 153ms 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 17 04 73 11s127ms 152ms 05 3 392ms 130ms 16 1 317ms 317ms -
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-17 04:07:34 Duration: 353ms
-
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" = 19499)) 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-17 16:02:22 Duration: 317ms
-
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-17 04:17:03 Duration: 204ms
15 51 32s167ms 143ms 1s615ms 630ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Mar 17 04 47 30s7ms 638ms 05 4 2s160ms 540ms -
UPDATE "stock_quant" SET "quantity" = 8.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 414351);
Date: 2024-03-17 04:15:58 Duration: 1s615ms
-
UPDATE "stock_quant" SET "quantity" = 12.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357570, 366159);
Date: 2024-03-17 04:16:01 Duration: 1s610ms
-
UPDATE "stock_quant" SET "quantity" = 24.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357571, 56679);
Date: 2024-03-17 04:16:02 Duration: 974ms
16 37 23s997ms 630ms 679ms 648ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Mar 17 19 3 1s976ms 658ms 20 18 11s584ms 643ms 22 16 10s436ms 652ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A4707QVL20KBLSShoeKi%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:57 Duration: 679ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707qvl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707qvl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707qvl%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:22 Duration: 674ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%ES597%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ES597%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ES597%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 19:51:32 Duration: 670ms
17 26 15s877ms 388ms 1s695ms 610ms update "stock_quant" set "company_id" = ?, "inventory_vendor_id" = ?, "is_core" = false, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Mar 17 04 26 15s877ms 610ms -
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3069, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451294, 451295);
Date: 2024-03-17 04:41:13 Duration: 1s695ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3035, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451284, 451285);
Date: 2024-03-17 04:24:04 Duration: 910ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3109, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451280);
Date: 2024-03-17 04:11:07 Duration: 848ms
18 25 3s148ms 120ms 164ms 125ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Mar 17 10 5 617ms 123ms 11 20 2s530ms 126ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (203519)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-03-17 11:50:11 Duration: 164ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (239141, 239043, 239100, 239198, 239082, 239079, 238994)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-03-17 11:09:56 Duration: 133ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (255696)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-03-17 11:21:49 Duration: 131ms
19 18 5s63ms 279ms 285ms 281ms 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 #19
Day Hour Count Duration Avg duration Mar 17 12 9 2s526ms 280ms 18 9 2s537ms 281ms -
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-17 18:43:13 Duration: 285ms
-
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-17 18:43:13 Duration: 284ms
-
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-17 18:43:13 Duration: 283ms
20 18 5s10ms 273ms 281ms 278ms 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 #20
Day Hour Count Duration Avg duration Mar 17 12 9 2s504ms 278ms 18 9 2s506ms 278ms -
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-17 18:42:06 Duration: 281ms
-
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-17 12:49:31 Duration: 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-17 18:42:39 Duration: 280ms
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 17 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-17 09:09:02 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 17 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-17 09:03:26 Duration: 1m45s
3 1m37s 1m37s 1m37s 1 1m37s 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 17 09 1 1m37s 1m37s -
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-17 09:05:12 Duration: 1m37s
4 28s975ms 28s975ms 28s975ms 1 28s975ms 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 17 09 1 28s975ms 28s975ms -
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-17 09:00:47 Duration: 28s975ms
5 14s229ms 15s350ms 14s789ms 2 29s579ms select * from ( select a.id, ? from product_template as a where a.is_core = false and (a.name ilike ? or a.condensed_internal_ref ilike ?) and a.inventory_vendor_id = ? union all select b.id, ? from product_library as b where (b.name ilike ? or b.default_code ilike ? or b.condensed_product_name ilike ?) and b.inventory_vendor_id = ?) n;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Mar 17 19 2 29s579ms 14s789ms -
select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;
Date: 2024-03-17 19:50:23 Duration: 15s350ms
-
select * from ( select a.id, 'product.template' from product_template as a where a.is_core = False and (a.name ilike '%ES597%' or a.condensed_internal_ref ilike '%ES597%') and a.inventory_vendor_id = 3029 union all select b.id, 'product.library' from product_library as b where (b.name ilike '%ES597%' or b.default_code ilike '%ES597%' or b.condensed_product_name ilike '%ES597%') and b.inventory_vendor_id = 3029) n;
Date: 2024-03-17 19:50:23 Duration: 14s229ms
6 733ms 19s824ms 2s476ms 11 27s238ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Mar 17 10 5 22s774ms 4s554ms 11 6 4s463ms 743ms -
select count(id) from item_list_line where item_demand_plan_id = 3847;
Date: 2024-03-17 10:36:44 Duration: 19s824ms
-
select count(id) from item_list_line where item_demand_plan_id = 3851;
Date: 2024-03-17 11:19:30 Duration: 748ms
-
select count(id) from item_list_line where item_demand_plan_id = 3840;
Date: 2024-03-17 11:29:27 Duration: 745ms
7 1s524ms 4s610ms 1s598ms 112 2m59s delete from account_move_line where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Mar 17 00 9 13s912ms 1s545ms 01 10 15s399ms 1s539ms 02 10 15s433ms 1s543ms 03 8 15s406ms 1s925ms 04 10 15s494ms 1s549ms 05 10 15s388ms 1s538ms 06 10 15s436ms 1s543ms 07 7 10s941ms 1s563ms 08 10 15s386ms 1s538ms 09 10 15s425ms 1s542ms 10 10 15s433ms 1s543ms 23 8 15s395ms 1s924ms -
DELETE FROM account_move_line WHERE id IN (4514444, 4514445, 4514446);
Date: 2024-03-17 03:12:13 Duration: 4s610ms
-
DELETE FROM account_move_line WHERE id IN (4514863, 4514864, 4514865);
Date: 2024-03-17 23:12:17 Duration: 4s606ms
-
DELETE FROM account_move_line WHERE id IN (4514869);
Date: 2024-03-17 07:30:20 Duration: 1s666ms
8 309ms 2s249ms 975ms 85 1m22s 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 #8
Day Hour Count Duration Avg duration Mar 17 04 78 1m16s 982ms 05 3 2s570ms 856ms 20 4 3s654ms 913ms -
UPDATE "stock_move" SET "current_warehouse_qty" = 12.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849731, 849735);
Date: 2024-03-17 04:15:51 Duration: 2s249ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 8.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849725, 849727);
Date: 2024-03-17 04:15:47 Duration: 2s196ms
-
UPDATE "stock_move" SET "current_warehouse_qty" = 24.0, "date" = '2024-03-17 04:15:37', "is_done" = true, "state" = 'done', "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (849738, 849732);
Date: 2024-03-17 04:15:53 Duration: 1s576ms
9 630ms 679ms 648ms 37 23s997ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Mar 17 19 3 1s976ms 658ms 20 18 11s584ms 643ms 22 16 10s436ms 652ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%A4707QVL20KBLSShoeKi%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%[A4707QVL20K] BLS Shoe Ki%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:57 Duration: 679ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707qvl%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707qvl%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707qvl%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 22:46:22 Duration: 674ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%ES597%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%ES597%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%ES597%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-03-17 19:51:32 Duration: 670ms
10 143ms 1s615ms 630ms 51 32s167ms update "stock_quant" set "quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Mar 17 04 47 30s7ms 638ms 05 4 2s160ms 540ms -
UPDATE "stock_quant" SET "quantity" = 8.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (238242, 414351);
Date: 2024-03-17 04:15:58 Duration: 1s615ms
-
UPDATE "stock_quant" SET "quantity" = 12.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357570, 366159);
Date: 2024-03-17 04:16:01 Duration: 1s610ms
-
UPDATE "stock_quant" SET "quantity" = 24.0, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (357571, 56679);
Date: 2024-03-17 04:16:02 Duration: 974ms
11 388ms 1s695ms 610ms 26 15s877ms update "stock_quant" set "company_id" = ?, "inventory_vendor_id" = ?, "is_core" = false, "warehouse_id" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Mar 17 04 26 15s877ms 610ms -
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3069, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451294, 451295);
Date: 2024-03-17 04:41:13 Duration: 1s695ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3035, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451284, 451285);
Date: 2024-03-17 04:24:04 Duration: 910ms
-
UPDATE "stock_quant" SET "company_id" = 1, "inventory_vendor_id" = 3109, "is_core" = false, "warehouse_id" = 38, "write_uid" = 1015, "write_date" = (now() at time zone 'UTC') WHERE id IN (451280);
Date: 2024-03-17 04:11:07 Duration: 848ms
12 355ms 437ms 361ms 111 40s77ms 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 #12
Day Hour Count Duration Avg duration Mar 17 04 95 34s338ms 361ms 05 6 2s144ms 357ms 16 3 1s70ms 356ms 19 3 1s67ms 355ms 22 3 1s98ms 366ms 23 1 358ms 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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:48:17 Duration: 437ms
-
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.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:32:52 Duration: 426ms
-
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/%-03cb21f/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-03-17 04:44:06 Duration: 403ms
13 338ms 414ms 347ms 510 2m57s 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 #13
Day Hour Count Duration Avg duration Mar 17 10 155 53s876ms 347ms 11 355 2m3s 347ms -
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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 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 = 46 and pwi.inventory_vendor_id = 3270 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:23:09 Duration: 414ms
-
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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 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 = 36 and pwi.inventory_vendor_id = 3019 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 10:49:39 Duration: 392ms
-
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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 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 = 35 and pwi.inventory_vendor_id = 2973 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-03-17 11:35:14 Duration: 389ms
14 279ms 285ms 281ms 18 5s63ms 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 #14
Day Hour Count Duration Avg duration Mar 17 12 9 2s526ms 280ms 18 9 2s537ms 281ms -
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-17 18:43:13 Duration: 285ms
-
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-17 18:43:13 Duration: 284ms
-
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-17 18:43:13 Duration: 283ms
15 273ms 281ms 278ms 18 5s10ms 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 #15
Day Hour Count Duration Avg duration Mar 17 12 9 2s504ms 278ms 18 9 2s506ms 278ms -
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-17 18:42:06 Duration: 281ms
-
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-17 12:49:31 Duration: 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-17 18:42:39 Duration: 280ms
16 120ms 446ms 223ms 651 2m25s 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 17 00 30 6s344ms 211ms 01 20 4s671ms 233ms 02 9 2s336ms 259ms 03 24 5s198ms 216ms 04 19 4s615ms 242ms 05 24 5s428ms 226ms 06 19 3s230ms 170ms 07 27 6s559ms 242ms 08 29 7s258ms 250ms 09 17 2s629ms 154ms 10 24 4s384ms 182ms 11 33 7s367ms 223ms 12 23 4s770ms 207ms 13 7 1s762ms 251ms 14 60 15s15ms 250ms 15 26 5s689ms 218ms 16 24 5s217ms 217ms 17 10 2s402ms 240ms 18 12 2s555ms 212ms 19 41 8s787ms 214ms 20 52 10s535ms 202ms 21 48 11s130ms 231ms 22 49 12s391ms 252ms 23 24 5s 208ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 11:43:57') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19566]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",431]', '["pointspring_master","mail.channel",505]', '["pointspring_master","mail.channel",523]', '["pointspring_master","res.partner",19566]', '["pointspring_master","ir.needaction",19566]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 11:44:48 Duration: 446ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19575]', '["pointspring_master","mail.channel",56]', '["pointspring_master","mail.channel",57]', '["pointspring_master","mail.channel",58]', '["pointspring_master","mail.channel",65]', '["pointspring_master","mail.channel",504]', '["pointspring_master","mail.channel",605]', '["pointspring_master","res.partner",19575]', '["pointspring_master","ir.needaction",19575]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 441ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-03-17 21:49:49') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19568]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",248]', '["pointspring_master","mail.channel",285]', '["pointspring_master","mail.channel",526]', '["pointspring_master","mail.channel",561]', '["pointspring_master","mail.channel",607]', '["pointspring_master","res.partner",19568]', '["pointspring_master","ir.needaction",19568]'))) ORDER BY "bus_bus"."id";
Date: 2024-03-17 21:50:40 Duration: 430ms
17 145ms 210ms 157ms 231 36s313ms 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 #17
Day Hour Count Duration Avg duration Mar 17 00 18 2s759ms 153ms 01 20 3s134ms 156ms 02 20 3s141ms 157ms 03 18 2s808ms 156ms 04 20 3s170ms 158ms 05 20 3s139ms 156ms 06 20 3s167ms 158ms 07 17 2s626ms 154ms 08 20 3s207ms 160ms 09 20 3s113ms 155ms 10 20 3s214ms 160ms 23 18 2s832ms 157ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:15 Duration: 210ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 08:36:15 Duration: 202ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (46362, 46400, 46414, 46415, 46424, 46480, 46484, 46508, 46526, 46527, 46542, 46591, 46610, 46616, 46624, 46627, 46641, 46645, 46653, 46661, 46666, 46683, 46689, 46699, 46737, 46754, 46757, 46762, 46780, 46818, 46829, 46842, 46848, 46852, 46889, 46924, 46948, 46982, 46998, 47008)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 06:42:32 Duration: 197ms
18 145ms 209ms 155ms 246 38s171ms 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 #18
Day Hour Count Duration Avg duration Mar 17 00 18 2s808ms 156ms 01 20 3s99ms 154ms 02 20 3s165ms 158ms 03 19 2s957ms 155ms 04 20 3s157ms 157ms 05 20 3s79ms 153ms 06 20 3s81ms 154ms 07 19 2s911ms 153ms 08 20 3s40ms 152ms 09 20 3s19ms 150ms 10 24 3s879ms 161ms 23 26 3s970ms 152ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 10:54:17 Duration: 209ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 00:18:15 Duration: 205ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (47008)) AND (("account_move"."id" not in (1239326)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-03-17 04:00:11 Duration: 194ms
19 120ms 353ms 153ms 77 11s838ms 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 #19
Day Hour Count Duration Avg duration Mar 17 04 73 11s127ms 152ms 05 3 392ms 130ms 16 1 317ms 317ms -
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-17 04:07:34 Duration: 353ms
-
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" = 19499)) 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-17 16:02:22 Duration: 317ms
-
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-17 04:17:03 Duration: 204ms
20 138ms 285ms 146ms 9,066 22m5s 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 #20
Day Hour Count Duration Avg duration Mar 17 10 2,786 6m47s 146ms 11 6,280 15m17s 146ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209268) and warehouse_id = (37));
Date: 2024-03-17 11:44:48 Duration: 285ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (227380) and warehouse_id = (45));
Date: 2024-03-17 11:14:57 Duration: 198ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (189594) and warehouse_id = (42));
Date: 2024-03-17 10:40:26 Duration: 195ms
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
- 14,918 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 927 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 592 Max number of times the same event was reported
- 927 Total events found
Rank Times reported Error 1 592 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Mar 17 00 23 01 30 02 25 03 27 04 23 05 36 06 34 07 22 08 27 09 23 10 30 11 22 12 17 13 20 14 20 15 20 16 22 17 20 18 26 19 27 20 23 21 21 22 22 23 32 - 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-17 12:50:18
2 115 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Mar 17 00 2 01 11 02 9 04 20 05 2 12 16 13 10 15 3 16 20 19 11 20 3 21 3 23 5 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2024-03-17 12:50:01' WHERE id IN (33)
Date: 2024-03-17 12:50:01
3 110 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count Mar 17 00 9 01 10 02 10 03 7 04 10 05 10 06 10 07 7 08 10 09 10 10 10 23 7 - 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'), '658320824B', 'Match', '3.105468511581421') RETURNING id
Date: 2024-03-17 04:54:13
4 110 ERROR: new row for relation "..." violates check constraint "..."
Times Reported Most Frequent Error / Event #4
Day Hour Count Mar 17 00 9 01 10 02 10 03 7 04 10 05 10 06 10 07 7 08 10 09 10 10 10 23 7 - ERROR: new row for relation "account_move_line" violates check constraint "account_move_line_check_amount_currency_balance_sign"
Detail: Failing row contains (4330352, 1239326, /, 2024-02-27, 658320824B, draft, 2, 1, 2, 14, 50048, 10, , 1.00, -566.69, 0.00, 0.00, 578.25, -578.25, -566.69, -566.69, -566.69, f, f, 2024-04-27, 2, 30608, null, null, null, null, null, null, null, null, null, t, null, , -578.25, -566.69, null, null, null, null, null, t, 1050, 2024-02-29 14:44:41.157952, 1, 2024-03-17 04:54:09.078097, null, null, null, null, null, null, null, 56, Indiana, null, new_product, 1, 566.69, 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"='-566.69',"amount_residual_currency"='-566.69',"price_subtotal"='-566.69',"price_total"='-566.69',"price_unit"='-566.69',"sign_price_subtotal"='566.69',"write_uid"=1,"write_date"=(now() at time zone 'UTC') WHERE id IN (4330352)Date: 2024-03-17 04:54:13