pgBadger-
Global information
- Generated on Mon Jan 29 00:50:03 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 80,471 log entries in 2s
- Log start from 2024-01-28 00:02:08 to 2024-01-28 23:59:30
-
Overview
Global Stats
- 194 Number of unique normalized queries
- 29,697 Number of queries
- 2h5m59s Total query duration
- 2024-01-28 00:02:08 First query
- 2024-01-28 23:59:30 Last query
- 35 queries/s at 2024-01-28 17:23:29 Query peak
- 2h5m59s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h5m59s Execute total duration
- 2,300 Number of events
- 3 Number of unique normalized events
- 1,676 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
- 29,697 Average queries per session
- 2h5m59s 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
- 35 queries/s Query Peak
- 2024-01-28 17:23:29 Date
SELECT Traffic
Key values
- 35 queries/s Query Peak
- 2024-01-28 17:23:29 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 8 queries/s Query Peak
- 2024-01-28 23:41:52 Date
Queries duration
Key values
- 2h5m59s 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) Jan 28 00 621 120ms 980ms 284ms 7s625ms 8s208ms 11s51ms 01 630 120ms 618ms 275ms 5s556ms 7s91ms 8s489ms 02 562 120ms 461ms 256ms 6s482ms 7s45ms 9s693ms 03 774 120ms 4s148ms 306ms 6s792ms 7s970ms 8s902ms 04 387 120ms 416ms 289ms 5s718ms 7s3ms 7s322ms 05 840 120ms 448ms 291ms 5s928ms 6s744ms 7s364ms 06 798 120ms 991ms 299ms 8s985ms 9s948ms 12s167ms 07 792 120ms 11s56ms 310ms 6s264ms 7s30ms 13s832ms 08 878 120ms 846ms 296ms 7s368ms 7s985ms 10s194ms 09 784 120ms 3m49s 1s191ms 50s744ms 1m35s 4m14s 10 4,640 120ms 1s69ms 169ms 33s180ms 39s128ms 49s769ms 11 10,499 120ms 1s90ms 152ms 37s318ms 40s857ms 50s125ms 12 992 120ms 453ms 260ms 6s764ms 10s663ms 34s732ms 13 495 120ms 397ms 280ms 5s385ms 5s760ms 5s898ms 14 99 0ms 1s776ms 516ms 896ms 3s590ms 37s344ms 15 172 0ms 435ms 240ms 1s786ms 2s41ms 4s632ms 16 283 0ms 812ms 259ms 2s486ms 6s93ms 10s256ms 17 1,031 120ms 8s494ms 396ms 12s397ms 36s488ms 2m3s 18 260 0ms 475ms 241ms 2s533ms 3s164ms 5s260ms 19 920 120ms 1s475ms 287ms 10s965ms 12s834ms 18s95ms 20 711 120ms 461ms 250ms 10s852ms 12s871ms 22s274ms 21 396 120ms 14s982ms 355ms 4s21ms 22s939ms 35s56ms 22 858 0ms 2s161ms 395ms 13s620ms 22s835ms 1m24s 23 1,275 120ms 11s75ms 349ms 19s692ms 20s458ms 40s289ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 28 00 621 0 284ms 5s99ms 7s625ms 8s834ms 01 630 0 275ms 4s616ms 5s556ms 7s147ms 02 562 0 256ms 5s325ms 6s482ms 8s101ms 03 772 0 299ms 5s473ms 6s792ms 8s891ms 04 387 0 289ms 3s986ms 5s718ms 7s183ms 05 840 0 291ms 5s483ms 5s928ms 7s126ms 06 798 0 299ms 7s346ms 8s985ms 10s791ms 07 790 0 295ms 5s785ms 6s177ms 7s30ms 08 876 0 295ms 6s318ms 7s368ms 8s13ms 09 688 96 1s191ms 6s977ms 45s 1m45s 10 1,740 0 221ms 11s629ms 13s913ms 16s666ms 11 3,334 0 182ms 14s166ms 16s581ms 20s972ms 12 827 0 284ms 5s483ms 6s599ms 10s663ms 13 495 0 280ms 5s40ms 5s385ms 5s838ms 14 99 0 516ms 259ms 896ms 37s344ms 15 172 0 240ms 1s670ms 1s786ms 4s632ms 16 283 0 259ms 1s795ms 2s486ms 7s477ms 17 932 0 384ms 7s387ms 11s369ms 1m21s 18 260 0 241ms 1s679ms 2s533ms 4s431ms 19 914 0 287ms 9s344ms 10s965ms 18s86ms 20 711 0 250ms 7s323ms 10s852ms 22s274ms 21 254 0 288ms 1s707ms 3s15ms 20s74ms 22 858 0 395ms 9s659ms 13s620ms 31s376ms 23 1,023 0 310ms 13s800ms 17s131ms 19s692ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 28 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 2 0 2s846ms 0ms 0ms 0ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 2 0 6s309ms 0ms 0ms 0ms 08 0 2 0 0 719ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 2,900 0 0 138ms 2s80ms 15s907ms 33s26ms 11 0 7,165 0 0 138ms 15s980ms 21s313ms 35s969ms 12 0 165 0 0 139ms 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 38 61 0 0 510ms 0ms 0ms 11s192ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 6 0 0 335ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 55 87 0 0 475ms 0ms 0ms 15s409ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 92 156 4 0 508ms 0ms 1s330ms 18s339ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 28 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 Jan 28 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 Jan 28 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 Jan 28 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 Jan 28 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) Jan 28 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 Jan 28 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 Jan 28 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 Jan 28 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
- 18,866 Total read queries
- 10,831 Total write queries
Queries by database
Key values
- unknown Main database
- 29,697 Requests
- 2h5m59s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 29,697 Requests
User Request type Count Duration unknown Total 29,697 2h5m59s copy to 96 12m17s delete 8 36s653ms insert 185 41s962ms select 18,866 1h25m35s update 10,542 26m47s Duration by user
Key values
- 2h5m59s (unknown) Main time consuming user
User Request type Count Duration unknown Total 29,697 2h5m59s copy to 96 12m17s delete 8 36s653ms insert 185 41s962ms select 18,866 1h25m35s update 10,542 26m47s Queries by host
Key values
- unknown Main host
- 29,697 Requests
- 2h5m59s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 29,697 Requests
- 2h5m59s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-01-28 08:19:56 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 29,085 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-01-28 09:08:38 ]
2 1m37s 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-01-28 09:03:08 ]
3 1m32s 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-01-28 09:04:48 ]
4 1m5s 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-01-28 09:12:26 ]
5 41s687ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2024-01-28 09:11:20 ]
6 26s19ms 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-01-28 09:00:42 ]
7 20s775ms 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-01-28 09:10:04 ]
8 15s324ms 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-01-28 09:01:04 ]
9 14s982ms UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784109, 784110, 784111, 784112, 784113, 784114, 784115, 784116, 784117, 784118, 784119, 784120, 784121, 784122, 784123);[ Date: 2024-01-28 21:43:11 ]
10 11s78ms 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-01-28 09:00:16 ]
11 11s75ms DELETE FROM account_move_line WHERE id IN (4084745, 4084746, 4084747, 4084748, 4084749, 4084750, 4084751, 4084752);[ Date: 2024-01-28 23:06:40 ]
12 11s56ms DELETE FROM account_move_line WHERE id IN (4084734, 4084735, 4084736, 4084737, 4084738, 4084739, 4084740, 4084741);[ Date: 2024-01-28 07:06:22 ]
13 9s264ms UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784175, 784176, 784177, 784178, 784179, 784180, 784181, 784182, 784183);[ Date: 2024-01-28 23:29:23 ]
14 8s896ms UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784136, 784137, 784138, 784139, 784140, 784141, 784142, 784143, 784144, 784145, 784146, 784147);[ Date: 2024-01-28 21:51:24 ]
15 8s656ms UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784199, 784200, 784201, 784202, 784203, 784204, 784205, 784206, 784207);[ Date: 2024-01-28 23:41:48 ]
16 8s632ms 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-01-28 09:08:48 ]
17 8s494ms UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784083, 784084, 784085, 784086, 784087, 784088, 784089, 784090, 784091);[ Date: 2024-01-28 17:23:14 ]
18 8s1ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-01-28 09:01:13 ]
19 7s360ms 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-01-28 09:10:23 ]
20 5s822ms 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-01-28 09:01:24 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 49m26s 8,909 323ms 618ms 333ms 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 #1
Day Hour Count Duration Avg duration Jan 28 00 444 2m27s 333ms 01 429 2m22s 332ms 02 335 1m51s 331ms 03 594 3m17s 331ms 04 291 1m36s 331ms 05 649 3m35s 332ms 06 596 3m17s 331ms 07 611 3m22s 331ms 08 696 3m51s 332ms 09 483 2m40s 333ms 10 506 2m49s 335ms 11 262 1m29s 340ms 12 595 3m17s 331ms 13 359 1m58s 330ms 14 2 653ms 326ms 15 1 370ms 370ms 16 45 15s14ms 333ms 17 351 1m57s 334ms 19 528 2m55s 332ms 20 270 1m30s 334ms 22 463 2m34s 334ms 23 399 2m14s 336ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 01:12:32 Duration: 618ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 10:50:00 Duration: 498ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 11:40:32 Duration: 483ms
2 23m38s 10,230 130ms 218ms 138ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 28 10 2,900 6m41s 138ms 11 7,165 16m34s 138ms 12 165 23s26ms 139ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209509) and warehouse_id = (46));
Date: 2024-01-28 11:32:16 Duration: 218ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209513) and warehouse_id = (46));
Date: 2024-01-28 11:32:16 Duration: 217ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (255915) and warehouse_id = (46));
Date: 2024-01-28 11:29:08 Duration: 193ms
3 12m20s 4,698 120ms 971ms 157ms 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 #3
Day Hour Count Duration Avg duration Jan 28 00 167 24s998ms 149ms 01 198 30s101ms 152ms 02 224 32s300ms 144ms 03 147 29s461ms 200ms 04 87 14s257ms 163ms 05 188 28s720ms 152ms 06 170 29s698ms 174ms 07 135 24s56ms 178ms 08 165 25s178ms 152ms 09 204 35s302ms 173ms 10 432 1m3s 146ms 11 872 1m57s 135ms 12 158 24s261ms 153ms 13 130 18s898ms 145ms 14 64 11s618ms 181ms 15 50 7s995ms 159ms 16 91 17s927ms 197ms 17 178 26s814ms 150ms 18 110 21s58ms 191ms 19 217 34s213ms 157ms 20 303 48s922ms 161ms 21 79 16s837ms 213ms 22 182 32s285ms 177ms 23 147 24s474ms 166ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:31') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:22 Duration: 971ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-28 17:10:22 Duration: 849ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:23 Duration: 716ms
4 5m34s 1,194 270ms 399ms 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" = ? 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 #4
Day Hour Count Duration Avg duration Jan 28 02 3 874ms 291ms 08 3 884ms 294ms 10 3 865ms 288ms 15 114 31s765ms 278ms 16 129 35s998ms 279ms 17 147 41s313ms 281ms 18 150 41s809ms 278ms 19 132 37s295ms 282ms 20 114 31s920ms 280ms 21 120 33s564ms 279ms 22 132 36s985ms 280ms 23 147 41s131ms 279ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = '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-01-28 20:19:40 Duration: 399ms
-
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-01-28 19:54:29 Duration: 352ms
-
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-01-28 22:11:28 Duration: 348ms
5 3m49s 1 3m49s 3m49s 3m49s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 28 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-01-28 09:08:38 Duration: 3m49s
6 2m49s 481 341ms 445ms 351ms 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 #6
Day Hour Count Duration Avg duration Jan 28 10 125 44s78ms 352ms 11 343 2m 351ms 12 13 4s570ms 351ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:46:01 Duration: 445ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:43:28 Duration: 444ms
-
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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 11:47:20 Duration: 414ms
7 2m47s 369 296ms 970ms 453ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 28 17 55 36s92ms 656ms 20 23 7s75ms 307ms 21 46 21s375ms 464ms 23 245 1m42s 418ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 970ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:29 Duration: 941ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 890ms
8 1m49s 126 346ms 1s465ms 870ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."inventory_vendor_id" = ?) and (("product_warehouse_inventory"."warehouse_id" = ?) and (((("product_warehouse_inventory"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where ("psd_custom_inventory_vendor"."purchase_agent_user" = ?))) and ("product_warehouse_inventory"."stocking_flag" is null or "product_warehouse_inventory"."stocking_flag" = false)) and "product_warehouse_inventory"."replenish_branch_id" is not null) and ("product_warehouse_inventory"."qty_reserve" > ?.?)))) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 28 17 126 1m49s 870ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2988) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s465ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2924) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s438ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3057) AND (("product_warehouse_inventory"."warehouse_id" = 37) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:23 Duration: 1s435ms
9 1m37s 1 1m37s 1m37s 1m37s 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 #9
Day Hour Count Duration Avg duration Jan 28 09 1 1m37s 1m37s -
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-01-28 09:03:08 Duration: 1m37s
10 1m35s 53 135ms 14s982ms 1s808ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 28 17 11 15s967ms 1s451ms 19 1 152ms 152ms 21 10 31s907ms 3s190ms 23 31 47s811ms 1s542ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784109, 784110, 784111, 784112, 784113, 784114, 784115, 784116, 784117, 784118, 784119, 784120, 784121, 784122, 784123);
Date: 2024-01-28 21:43:11 Duration: 14s982ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784175, 784176, 784177, 784178, 784179, 784180, 784181, 784182, 784183);
Date: 2024-01-28 23:29:23 Duration: 9s264ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784136, 784137, 784138, 784139, 784140, 784141, 784142, 784143, 784144, 784145, 784146, 784147);
Date: 2024-01-28 21:51:24 Duration: 8s896ms
11 1m32s 1 1m32s 1m32s 1m32s 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 #11
Day Hour Count Duration Avg duration Jan 28 09 1 1m32s 1m32s -
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-01-28 09:04:48 Duration: 1m32s
12 1m18s 481 146ms 215ms 164ms 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 #12
Day Hour Count Duration Avg duration Jan 28 10 125 20s535ms 164ms 11 343 56s251ms 163ms 12 13 2s98ms 161ms -
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 = 43 and pwi.inventory_vendor_id = 2905;
Date: 2024-01-28 11:10:19 Duration: 215ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 3080;
Date: 2024-01-28 11:58:14 Duration: 214ms
-
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 = 37 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-28 11:51:44 Duration: 211ms
13 1m17s 611 120ms 178ms 126ms 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 #13
Day Hour Count Duration Avg duration Jan 28 10 151 19s118ms 126ms 11 453 57s482ms 126ms 12 7 902ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (213465)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 10:53:32 Duration: 178ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (253910)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 11:27:27 Duration: 157ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (174033)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 11:36:24 Duration: 155ms
14 1m6s 481 131ms 178ms 138ms 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 #14
Day Hour Count Duration Avg duration Jan 28 10 125 17s404ms 139ms 11 343 47s629ms 138ms 12 13 1s758ms 135ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 10:50:05' and warehouse_id = 36 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 10:50:05 Duration: 178ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 11:55:43' and warehouse_id = 41 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 11:55:43 Duration: 167ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 11:36:16' and warehouse_id = 35 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 11:36:16 Duration: 167ms
15 1m5s 1 1m5s 1m5s 1m5s 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;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 28 09 1 1m5s 1m5s -
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-01-28 09:12:26 Duration: 1m5s
16 1m3s 481 126ms 175ms 132ms 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 #16
Day Hour Count Duration Avg duration Jan 28 10 125 16s572ms 132ms 11 343 45s490ms 132ms 12 13 1s719ms 132ms -
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 42 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2933 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 10:45:11 Duration: 175ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 36 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 3115 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 10:55:13 Duration: 165ms
-
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 = 3270 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 11:29:36 Duration: 161ms
17 58s309ms 98 281ms 1s57ms 594ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "state" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 28 17 28 17s852ms 637ms 21 31 16s844ms 543ms 23 39 23s612ms 605ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3057, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '04-V/INT/10278', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784059);
Date: 2024-01-28 17:22:35 Duration: 1s57ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3076, "is_done" = false, "picking_code" = 'internal', "product_qty" = 27.0, "reference" = '09-B/INT/10240', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784247);
Date: 2024-01-28 23:57:42 Duration: 1s41ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2939, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '10-I/INT/22033', "scrapped" = false, "state" = 'confirmed', "unit_factor" = 1.0, "weight" = '0.24', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784080, 784074);
Date: 2024-01-28 17:23:01 Duration: 1s36ms
18 47s457ms 307 147ms 200ms 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 = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 28 10 83 12s804ms 154ms 11 221 34s189ms 154ms 12 3 464ms 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 = 2952 and pwi.warehouse_id = 37 and pwi.product_id not in (220174, 219851, 219850, 219680, 219379, 219377, 219362, 218623, 218620, 218570, 218554, 218523, 218520, 218491, 218473, 218379, 217988, 217980, 217942, 217938, 217936, 217673, 217672, 217601, 217507, 217472, 217464, 217442, 217423, 217415, 217398, 217377, 217342, 217291, 217274, 217142, 217068, 217067, 217066, 217031, 217017, 216949, 216861, 216854, 216848, 216823, 216800, 216799, 216597, 216454, 216433, 216289, 216288, 216280, 216098, 216059, 215773, 215663, 215661, 215519, 215458, 215413, 215156, 215103, 215100, 215082, 214461, 214155, 214067, 213915, 213577, 216281, 219800, 217257, 217293, 217292, 217238, 260978, 215669, 217463, 218101);
Date: 2024-01-28 11:49:50 Duration: 200ms
-
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 = 2952 and pwi.warehouse_id = 43 and pwi.product_id not in (220161, 220144, 219851, 219800, 219703, 219377, 219318, 219127, 218554, 218048, 218009, 217938, 217839, 217480, 217291, 217274, 217189, 217096, 217068, 217067, 217066, 217017, 216922, 216858, 216826, 216793, 216776, 216701, 216653, 216579, 216568, 216554, 216443, 216433, 216414, 216375, 216280, 216174, 216059, 216049, 215663, 215650, 215340, 215140, 215096, 215084, 214757, 214705, 214043, 213903, 213601, 213427, 217866, 216115);
Date: 2024-01-28 11:05:31 Duration: 191ms
-
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 = 2986 and pwi.warehouse_id = 35 and pwi.product_id not in (227034);
Date: 2024-01-28 11:44:48 Duration: 184ms
19 41s687ms 1 41s687ms 41s687ms 41s687ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 28 09 1 41s687ms 41s687ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2024-01-28 09:11:20 Duration: 41s687ms
20 40s679ms 179 136ms 925ms 227ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 28 17 38 11s192ms 294ms 21 55 11s21ms 200ms 23 86 18s464ms 214ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 50, 1, '2024-01-29 17:22:14.914854', 44, 214032, false, 453, 468, 'new_product', '12-S/INT/07776', NULL, 'Warehouse Inventory Transfer to Sarver', 329841, 349, '0', 'make_to_stock', 188595, 1, '4.00', true, 10, 42, 'draft', 44) RETURNING id;
Date: 2024-01-28 17:22:16 Duration: 925ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-30 17:22:45.171387', 41, 214050, false, 429, 468, 'new_product', '09-B/INT/10237', NULL, 'Warehouse Inventory Transfer to Akron', 329859, 325, '0', 'make_to_stock', 228256, 1, '1.00', true, 10, 36, 'draft', 41) RETURNING id;
Date: 2024-01-28 17:22:46 Duration: 924ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 39, 1, '2024-01-29 17:22:26.437215', 37, 214040, false, 397, 468, 'new_product', '04-V/INT/10278', NULL, 'Warehouse Inventory Transfer to Fairmont', 329849, 293, '0', 'make_to_stock', 261112, 1, '2.00', true, 10, 43, 'draft', 37) RETURNING id;
Date: 2024-01-28 17:22:27 Duration: 896ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 10,230 23m38s 130ms 218ms 138ms 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 Jan 28 10 2,900 6m41s 138ms 11 7,165 16m34s 138ms 12 165 23s26ms 139ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209509) and warehouse_id = (46));
Date: 2024-01-28 11:32:16 Duration: 218ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209513) and warehouse_id = (46));
Date: 2024-01-28 11:32:16 Duration: 217ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (255915) and warehouse_id = (46));
Date: 2024-01-28 11:29:08 Duration: 193ms
2 8,909 49m26s 323ms 618ms 333ms 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 #2
Day Hour Count Duration Avg duration Jan 28 00 444 2m27s 333ms 01 429 2m22s 332ms 02 335 1m51s 331ms 03 594 3m17s 331ms 04 291 1m36s 331ms 05 649 3m35s 332ms 06 596 3m17s 331ms 07 611 3m22s 331ms 08 696 3m51s 332ms 09 483 2m40s 333ms 10 506 2m49s 335ms 11 262 1m29s 340ms 12 595 3m17s 331ms 13 359 1m58s 330ms 14 2 653ms 326ms 15 1 370ms 370ms 16 45 15s14ms 333ms 17 351 1m57s 334ms 19 528 2m55s 332ms 20 270 1m30s 334ms 22 463 2m34s 334ms 23 399 2m14s 336ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 01:12:32 Duration: 618ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 10:50:00 Duration: 498ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 11:40:32 Duration: 483ms
3 4,698 12m20s 120ms 971ms 157ms 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 #3
Day Hour Count Duration Avg duration Jan 28 00 167 24s998ms 149ms 01 198 30s101ms 152ms 02 224 32s300ms 144ms 03 147 29s461ms 200ms 04 87 14s257ms 163ms 05 188 28s720ms 152ms 06 170 29s698ms 174ms 07 135 24s56ms 178ms 08 165 25s178ms 152ms 09 204 35s302ms 173ms 10 432 1m3s 146ms 11 872 1m57s 135ms 12 158 24s261ms 153ms 13 130 18s898ms 145ms 14 64 11s618ms 181ms 15 50 7s995ms 159ms 16 91 17s927ms 197ms 17 178 26s814ms 150ms 18 110 21s58ms 191ms 19 217 34s213ms 157ms 20 303 48s922ms 161ms 21 79 16s837ms 213ms 22 182 32s285ms 177ms 23 147 24s474ms 166ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:31') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:22 Duration: 971ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-28 17:10:22 Duration: 849ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:23 Duration: 716ms
4 1,194 5m34s 270ms 399ms 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" = ? 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 #4
Day Hour Count Duration Avg duration Jan 28 02 3 874ms 291ms 08 3 884ms 294ms 10 3 865ms 288ms 15 114 31s765ms 278ms 16 129 35s998ms 279ms 17 147 41s313ms 281ms 18 150 41s809ms 278ms 19 132 37s295ms 282ms 20 114 31s920ms 280ms 21 120 33s564ms 279ms 22 132 36s985ms 280ms 23 147 41s131ms 279ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = '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-01-28 20:19:40 Duration: 399ms
-
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-01-28 19:54:29 Duration: 352ms
-
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-01-28 22:11:28 Duration: 348ms
5 611 1m17s 120ms 178ms 126ms 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 #5
Day Hour Count Duration Avg duration Jan 28 10 151 19s118ms 126ms 11 453 57s482ms 126ms 12 7 902ms 128ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (213465)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 10:53:32 Duration: 178ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (253910)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 11:27:27 Duration: 157ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (174033)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-28 11:36:24 Duration: 155ms
6 481 2m49s 341ms 445ms 351ms 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 #6
Day Hour Count Duration Avg duration Jan 28 10 125 44s78ms 352ms 11 343 2m 351ms 12 13 4s570ms 351ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:46:01 Duration: 445ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:43:28 Duration: 444ms
-
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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 11:47:20 Duration: 414ms
7 481 1m18s 146ms 215ms 164ms 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 #7
Day Hour Count Duration Avg duration Jan 28 10 125 20s535ms 164ms 11 343 56s251ms 163ms 12 13 2s98ms 161ms -
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 = 43 and pwi.inventory_vendor_id = 2905;
Date: 2024-01-28 11:10:19 Duration: 215ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 3080;
Date: 2024-01-28 11:58:14 Duration: 214ms
-
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 = 37 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-28 11:51:44 Duration: 211ms
8 481 1m6s 131ms 178ms 138ms 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 #8
Day Hour Count Duration Avg duration Jan 28 10 125 17s404ms 139ms 11 343 47s629ms 138ms 12 13 1s758ms 135ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 10:50:05' and warehouse_id = 36 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 10:50:05 Duration: 178ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 11:55:43' and warehouse_id = 41 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 11:55:43 Duration: 167ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-28 11:36:16' and warehouse_id = 35 and inventory_vendor_id = 2928 and qty_available < min_product_uom_qty;
Date: 2024-01-28 11:36:16 Duration: 167ms
9 481 1m3s 126ms 175ms 132ms 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 #9
Day Hour Count Duration Avg duration Jan 28 10 125 16s572ms 132ms 11 343 45s490ms 132ms 12 13 1s719ms 132ms -
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 42 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2933 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 10:45:11 Duration: 175ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 36 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 3115 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 10:55:13 Duration: 165ms
-
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 = 3270 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-28 11:29:36 Duration: 161ms
10 369 2m47s 296ms 970ms 453ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 28 17 55 36s92ms 656ms 20 23 7s75ms 307ms 21 46 21s375ms 464ms 23 245 1m42s 418ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 970ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:29 Duration: 941ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 890ms
11 307 47s457ms 147ms 200ms 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 = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 28 10 83 12s804ms 154ms 11 221 34s189ms 154ms 12 3 464ms 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 = 2952 and pwi.warehouse_id = 37 and pwi.product_id not in (220174, 219851, 219850, 219680, 219379, 219377, 219362, 218623, 218620, 218570, 218554, 218523, 218520, 218491, 218473, 218379, 217988, 217980, 217942, 217938, 217936, 217673, 217672, 217601, 217507, 217472, 217464, 217442, 217423, 217415, 217398, 217377, 217342, 217291, 217274, 217142, 217068, 217067, 217066, 217031, 217017, 216949, 216861, 216854, 216848, 216823, 216800, 216799, 216597, 216454, 216433, 216289, 216288, 216280, 216098, 216059, 215773, 215663, 215661, 215519, 215458, 215413, 215156, 215103, 215100, 215082, 214461, 214155, 214067, 213915, 213577, 216281, 219800, 217257, 217293, 217292, 217238, 260978, 215669, 217463, 218101);
Date: 2024-01-28 11:49:50 Duration: 200ms
-
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 = 2952 and pwi.warehouse_id = 43 and pwi.product_id not in (220161, 220144, 219851, 219800, 219703, 219377, 219318, 219127, 218554, 218048, 218009, 217938, 217839, 217480, 217291, 217274, 217189, 217096, 217068, 217067, 217066, 217017, 216922, 216858, 216826, 216793, 216776, 216701, 216653, 216579, 216568, 216554, 216443, 216433, 216414, 216375, 216280, 216174, 216059, 216049, 215663, 215650, 215340, 215140, 215096, 215084, 214757, 214705, 214043, 213903, 213601, 213427, 217866, 216115);
Date: 2024-01-28 11:05:31 Duration: 191ms
-
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 = 2986 and pwi.warehouse_id = 35 and pwi.product_id not in (227034);
Date: 2024-01-28 11:44:48 Duration: 184ms
12 179 40s679ms 136ms 925ms 227ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 28 17 38 11s192ms 294ms 21 55 11s21ms 200ms 23 86 18s464ms 214ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 50, 1, '2024-01-29 17:22:14.914854', 44, 214032, false, 453, 468, 'new_product', '12-S/INT/07776', NULL, 'Warehouse Inventory Transfer to Sarver', 329841, 349, '0', 'make_to_stock', 188595, 1, '4.00', true, 10, 42, 'draft', 44) RETURNING id;
Date: 2024-01-28 17:22:16 Duration: 925ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-30 17:22:45.171387', 41, 214050, false, 429, 468, 'new_product', '09-B/INT/10237', NULL, 'Warehouse Inventory Transfer to Akron', 329859, 325, '0', 'make_to_stock', 228256, 1, '1.00', true, 10, 36, 'draft', 41) RETURNING id;
Date: 2024-01-28 17:22:46 Duration: 924ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 39, 1, '2024-01-29 17:22:26.437215', 37, 214040, false, 397, 468, 'new_product', '04-V/INT/10278', NULL, 'Warehouse Inventory Transfer to Fairmont', 329849, 293, '0', 'make_to_stock', 261112, 1, '2.00', true, 10, 43, 'draft', 37) RETURNING id;
Date: 2024-01-28 17:22:27 Duration: 896ms
13 174 26s510ms 147ms 192ms 152ms 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 #13
Day Hour Count Duration Avg duration Jan 28 10 42 6s362ms 151ms 11 121 18s445ms 152ms 12 11 1s702ms 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 = 2992 and pwi.warehouse_id = 46;
Date: 2024-01-28 11:27:56 Duration: 192ms
-
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 = 2926 and pwi.warehouse_id = 37;
Date: 2024-01-28 11:53:45 Duration: 189ms
-
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 = 2963 and pwi.warehouse_id = 35;
Date: 2024-01-28 11:41:27 Duration: 177ms
14 126 1m49s 346ms 1s465ms 870ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."inventory_vendor_id" = ?) and (("product_warehouse_inventory"."warehouse_id" = ?) and (((("product_warehouse_inventory"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where ("psd_custom_inventory_vendor"."purchase_agent_user" = ?))) and ("product_warehouse_inventory"."stocking_flag" is null or "product_warehouse_inventory"."stocking_flag" = false)) and "product_warehouse_inventory"."replenish_branch_id" is not null) and ("product_warehouse_inventory"."qty_reserve" > ?.?)))) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 28 17 126 1m49s 870ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2988) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s465ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2924) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s438ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3057) AND (("product_warehouse_inventory"."warehouse_id" = 37) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:23 Duration: 1s435ms
15 98 58s309ms 281ms 1s57ms 594ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "state" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 28 17 28 17s852ms 637ms 21 31 16s844ms 543ms 23 39 23s612ms 605ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3057, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '04-V/INT/10278', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784059);
Date: 2024-01-28 17:22:35 Duration: 1s57ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3076, "is_done" = false, "picking_code" = 'internal', "product_qty" = 27.0, "reference" = '09-B/INT/10240', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784247);
Date: 2024-01-28 23:57:42 Duration: 1s41ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2939, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '10-I/INT/22033', "scrapped" = false, "state" = 'confirmed', "unit_factor" = 1.0, "weight" = '0.24', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784080, 784074);
Date: 2024-01-28 17:23:01 Duration: 1s36ms
16 88 13s149ms 132ms 186ms 149ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 28 00 4 640ms 160ms 03 21 3s56ms 145ms 04 5 725ms 145ms 06 6 968ms 161ms 07 24 3s700ms 154ms 08 6 904ms 150ms 23 22 3s154ms 143ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (42773)) AND (("account_move"."id" not in (1101345)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 07:18:30 Duration: 186ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (44982)) AND (("account_move"."id" not in (1161337)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 06:06:25 Duration: 185ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (44839)) AND (("account_move"."id" not in (1123107)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:06:15 Duration: 180ms
17 54 7s526ms 132ms 170ms 139ms update "stock_quant" set "reserved_quantity" = ?.?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 28 17 6 832ms 138ms 19 1 170ms 170ms 21 20 2s787ms 139ms 23 27 3s735ms 138ms -
UPDATE "stock_quant" SET "reserved_quantity" = 1.0, "write_uid" = 1035, "write_date" = (now() at time zone 'UTC') WHERE id IN (425333);
Date: 2024-01-28 19:20:11 Duration: 170ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 14.0, "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (47497);
Date: 2024-01-28 23:41:33 Duration: 152ms
-
UPDATE "stock_quant" SET "reserved_quantity" = 4.0, "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (239526);
Date: 2024-01-28 21:51:11 Duration: 146ms
18 53 1m35s 135ms 14s982ms 1s808ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 28 17 11 15s967ms 1s451ms 19 1 152ms 152ms 21 10 31s907ms 3s190ms 23 31 47s811ms 1s542ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784109, 784110, 784111, 784112, 784113, 784114, 784115, 784116, 784117, 784118, 784119, 784120, 784121, 784122, 784123);
Date: 2024-01-28 21:43:11 Duration: 14s982ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784175, 784176, 784177, 784178, 784179, 784180, 784181, 784182, 784183);
Date: 2024-01-28 23:29:23 Duration: 9s264ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784136, 784137, 784138, 784139, 784140, 784141, 784142, 784143, 784144, 784145, 784146, 784147);
Date: 2024-01-28 21:51:24 Duration: 8s896ms
19 51 7s422ms 133ms 292ms 145ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 28 17 9 1s274ms 141ms 21 7 995ms 142ms 23 35 5s152ms 147ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3076, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '05-F/INT/09795', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784222, 784223);
Date: 2024-01-28 23:50:29 Duration: 292ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3057, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/10238', "scrapped" = false, "unit_factor" = 1.0, "weight" = '104.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784239);
Date: 2024-01-28 23:57:28 Duration: 161ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2924, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/10238', "scrapped" = false, "unit_factor" = 1.0, "weight" = '22.50', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784238);
Date: 2024-01-28 23:57:28 Duration: 150ms
20 41 6s314ms 132ms 193ms 154ms 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 #20
Day Hour Count Duration Avg duration Jan 28 00 2 370ms 185ms 03 10 1s543ms 154ms 04 3 449ms 149ms 06 1 152ms 152ms 07 10 1s538ms 153ms 08 4 603ms 150ms 23 11 1s655ms 150ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (44834, 44833, 44836, 44838, 44839, 44841, 44846, 44847, 44849, 44855, 44856, 44857, 44860, 44864, 44869, 44871, 44874, 44875, 44876, 44877, 44879, 44880, 44883, 44886, 44888, 44889, 44893, 44895, 44896, 44897, 44898, 44902, 44906, 44908, 44910, 44913, 44915, 44916, 44918, 44919)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:06:15 Duration: 193ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (36309, 37132, 37969, 38235, 38347, 38801, 38804, 38875, 39175, 39320, 39454, 39758, 39978, 39982, 40114, 40174, 40178, 40193, 40235, 40379, 40385, 40530, 40563, 40682, 40824, 40953, 40983, 41027, 41036, 41043, 41051, 41060, 41088, 41144, 41150, 41193, 41206, 41207, 41222, 41295)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 23:06:27 Duration: 182ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (44923, 44920, 44926, 44930, 44931, 44933, 44935, 44937, 44938, 44939, 44940, 44941, 44942, 44943, 44944, 44945, 44947, 44950, 44951, 44953, 44955, 44957, 44959, 44961, 44963, 44964, 44965, 44966)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:12:23 Duration: 176ms
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 Jan 28 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-01-28 09:08:38 Duration: 3m49s
2 1m37s 1m37s 1m37s 1 1m37s 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 Jan 28 09 1 1m37s 1m37s -
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-01-28 09:03:08 Duration: 1m37s
3 1m32s 1m32s 1m32s 1 1m32s 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 Jan 28 09 1 1m32s 1m32s -
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-01-28 09:04:48 Duration: 1m32s
4 1m5s 1m5s 1m5s 1 1m5s 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;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 28 09 1 1m5s 1m5s -
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-01-28 09:12:26 Duration: 1m5s
5 41s687ms 41s687ms 41s687ms 1 41s687ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 28 09 1 41s687ms 41s687ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2024-01-28 09:11:20 Duration: 41s687ms
6 135ms 14s982ms 1s808ms 53 1m35s update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 28 17 11 15s967ms 1s451ms 19 1 152ms 152ms 21 10 31s907ms 3s190ms 23 31 47s811ms 1s542ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784109, 784110, 784111, 784112, 784113, 784114, 784115, 784116, 784117, 784118, 784119, 784120, 784121, 784122, 784123);
Date: 2024-01-28 21:43:11 Duration: 14s982ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784175, 784176, 784177, 784178, 784179, 784180, 784181, 784182, 784183);
Date: 2024-01-28 23:29:23 Duration: 9s264ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784136, 784137, 784138, 784139, 784140, 784141, 784142, 784143, 784144, 784145, 784146, 784147);
Date: 2024-01-28 21:51:24 Duration: 8s896ms
7 346ms 1s465ms 870ms 126 1m49s select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."inventory_vendor_id" = ?) and (("product_warehouse_inventory"."warehouse_id" = ?) and (((("product_warehouse_inventory"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where ("psd_custom_inventory_vendor"."purchase_agent_user" = ?))) and ("product_warehouse_inventory"."stocking_flag" is null or "product_warehouse_inventory"."stocking_flag" = false)) and "product_warehouse_inventory"."replenish_branch_id" is not null) and ("product_warehouse_inventory"."qty_reserve" > ?.?)))) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 28 17 126 1m49s 870ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2988) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s465ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 2924) AND (("product_warehouse_inventory"."warehouse_id" = 42) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:22 Duration: 1s438ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3057) AND (("product_warehouse_inventory"."warehouse_id" = 37) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2024-01-28 17:10:23 Duration: 1s435ms
8 281ms 1s57ms 594ms 98 58s309ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "state" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 28 17 28 17s852ms 637ms 21 31 16s844ms 543ms 23 39 23s612ms 605ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3057, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '04-V/INT/10278', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784059);
Date: 2024-01-28 17:22:35 Duration: 1s57ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3076, "is_done" = false, "picking_code" = 'internal', "product_qty" = 27.0, "reference" = '09-B/INT/10240', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784247);
Date: 2024-01-28 23:57:42 Duration: 1s41ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2939, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '10-I/INT/22033', "scrapped" = false, "state" = 'confirmed', "unit_factor" = 1.0, "weight" = '0.24', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784080, 784074);
Date: 2024-01-28 17:23:01 Duration: 1s36ms
9 296ms 970ms 453ms 369 2m47s select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 28 17 55 36s92ms 656ms 20 23 7s75ms 307ms 21 46 21s375ms 464ms 23 245 1m42s 418ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 970ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:29 Duration: 941ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2024-01-28 17:23:30 Duration: 890ms
10 341ms 445ms 351ms 481 2m49s 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 #10
Day Hour Count Duration Avg duration Jan 28 10 125 44s78ms 352ms 11 343 2m 351ms 12 13 4s570ms 351ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2983 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:46:01 Duration: 445ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 42 and pwi.inventory_vendor_id = 2949 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 10:43:28 Duration: 444ms
-
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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 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 = 37 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-28 11:47:20 Duration: 414ms
11 323ms 618ms 333ms 8,909 49m26s 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 Jan 28 00 444 2m27s 333ms 01 429 2m22s 332ms 02 335 1m51s 331ms 03 594 3m17s 331ms 04 291 1m36s 331ms 05 649 3m35s 332ms 06 596 3m17s 331ms 07 611 3m22s 331ms 08 696 3m51s 332ms 09 483 2m40s 333ms 10 506 2m49s 335ms 11 262 1m29s 340ms 12 595 3m17s 331ms 13 359 1m58s 330ms 14 2 653ms 326ms 15 1 370ms 370ms 16 45 15s14ms 333ms 17 351 1m57s 334ms 19 528 2m55s 332ms 20 270 1m30s 334ms 22 463 2m34s 334ms 23 399 2m14s 336ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 01:12:32 Duration: 618ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 10:50:00 Duration: 498ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-28 11:40:32 Duration: 483ms
12 270ms 399ms 280ms 1,194 5m34s 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 #12
Day Hour Count Duration Avg duration Jan 28 02 3 874ms 291ms 08 3 884ms 294ms 10 3 865ms 288ms 15 114 31s765ms 278ms 16 129 35s998ms 279ms 17 147 41s313ms 281ms 18 150 41s809ms 278ms 19 132 37s295ms 282ms 20 114 31s920ms 280ms 21 120 33s564ms 279ms 22 132 36s985ms 280ms 23 147 41s131ms 279ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = '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-01-28 20:19:40 Duration: 399ms
-
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-01-28 19:54:29 Duration: 352ms
-
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-01-28 22:11:28 Duration: 348ms
13 136ms 925ms 227ms 179 40s679ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 28 17 38 11s192ms 294ms 21 55 11s21ms 200ms 23 86 18s464ms 214ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 50, 1, '2024-01-29 17:22:14.914854', 44, 214032, false, 453, 468, 'new_product', '12-S/INT/07776', NULL, 'Warehouse Inventory Transfer to Sarver', 329841, 349, '0', 'make_to_stock', 188595, 1, '4.00', true, 10, 42, 'draft', 44) RETURNING id;
Date: 2024-01-28 17:22:16 Duration: 925ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-30 17:22:45.171387', 41, 214050, false, 429, 468, 'new_product', '09-B/INT/10237', NULL, 'Warehouse Inventory Transfer to Akron', 329859, 325, '0', 'make_to_stock', 228256, 1, '1.00', true, 10, 36, 'draft', 41) RETURNING id;
Date: 2024-01-28 17:22:46 Duration: 924ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 39, 1, '2024-01-29 17:22:26.437215', 37, 214040, false, 397, 468, 'new_product', '04-V/INT/10278', NULL, 'Warehouse Inventory Transfer to Fairmont', 329849, 293, '0', 'make_to_stock', 261112, 1, '2.00', true, 10, 43, 'draft', 37) RETURNING id;
Date: 2024-01-28 17:22:27 Duration: 896ms
14 146ms 215ms 164ms 481 1m18s 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 #14
Day Hour Count Duration Avg duration Jan 28 10 125 20s535ms 164ms 11 343 56s251ms 163ms 12 13 2s98ms 161ms -
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 = 43 and pwi.inventory_vendor_id = 2905;
Date: 2024-01-28 11:10:19 Duration: 215ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 3080;
Date: 2024-01-28 11:58:14 Duration: 214ms
-
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 = 37 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-28 11:51:44 Duration: 211ms
15 120ms 971ms 157ms 4,698 12m20s 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 #15
Day Hour Count Duration Avg duration Jan 28 00 167 24s998ms 149ms 01 198 30s101ms 152ms 02 224 32s300ms 144ms 03 147 29s461ms 200ms 04 87 14s257ms 163ms 05 188 28s720ms 152ms 06 170 29s698ms 174ms 07 135 24s56ms 178ms 08 165 25s178ms 152ms 09 204 35s302ms 173ms 10 432 1m3s 146ms 11 872 1m57s 135ms 12 158 24s261ms 153ms 13 130 18s898ms 145ms 14 64 11s618ms 181ms 15 50 7s995ms 159ms 16 91 17s927ms 197ms 17 178 26s814ms 150ms 18 110 21s58ms 191ms 19 217 34s213ms 157ms 20 303 48s922ms 161ms 21 79 16s837ms 213ms 22 182 32s285ms 177ms 23 147 24s474ms 166ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:31') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:22 Duration: 971ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_974"', '["pointspring_master","calendar.alarm",19512]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",489]', '["pointspring_master","mail.channel",557]', '["pointspring_master","res.partner",19512]', '["pointspring_master","ir.needaction",19512]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-28 17:10:22 Duration: 849ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-28 17:09:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["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-01-28 17:10:23 Duration: 716ms
16 147ms 200ms 154ms 307 47s457ms 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 #16
Day Hour Count Duration Avg duration Jan 28 10 83 12s804ms 154ms 11 221 34s189ms 154ms 12 3 464ms 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 = 2952 and pwi.warehouse_id = 37 and pwi.product_id not in (220174, 219851, 219850, 219680, 219379, 219377, 219362, 218623, 218620, 218570, 218554, 218523, 218520, 218491, 218473, 218379, 217988, 217980, 217942, 217938, 217936, 217673, 217672, 217601, 217507, 217472, 217464, 217442, 217423, 217415, 217398, 217377, 217342, 217291, 217274, 217142, 217068, 217067, 217066, 217031, 217017, 216949, 216861, 216854, 216848, 216823, 216800, 216799, 216597, 216454, 216433, 216289, 216288, 216280, 216098, 216059, 215773, 215663, 215661, 215519, 215458, 215413, 215156, 215103, 215100, 215082, 214461, 214155, 214067, 213915, 213577, 216281, 219800, 217257, 217293, 217292, 217238, 260978, 215669, 217463, 218101);
Date: 2024-01-28 11:49:50 Duration: 200ms
-
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 = 2952 and pwi.warehouse_id = 43 and pwi.product_id not in (220161, 220144, 219851, 219800, 219703, 219377, 219318, 219127, 218554, 218048, 218009, 217938, 217839, 217480, 217291, 217274, 217189, 217096, 217068, 217067, 217066, 217017, 216922, 216858, 216826, 216793, 216776, 216701, 216653, 216579, 216568, 216554, 216443, 216433, 216414, 216375, 216280, 216174, 216059, 216049, 215663, 215650, 215340, 215140, 215096, 215084, 214757, 214705, 214043, 213903, 213601, 213427, 217866, 216115);
Date: 2024-01-28 11:05:31 Duration: 191ms
-
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 = 2986 and pwi.warehouse_id = 35 and pwi.product_id not in (227034);
Date: 2024-01-28 11:44:48 Duration: 184ms
17 132ms 193ms 154ms 41 6s314ms 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 Jan 28 00 2 370ms 185ms 03 10 1s543ms 154ms 04 3 449ms 149ms 06 1 152ms 152ms 07 10 1s538ms 153ms 08 4 603ms 150ms 23 11 1s655ms 150ms -
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (44834, 44833, 44836, 44838, 44839, 44841, 44846, 44847, 44849, 44855, 44856, 44857, 44860, 44864, 44869, 44871, 44874, 44875, 44876, 44877, 44879, 44880, 44883, 44886, 44888, 44889, 44893, 44895, 44896, 44897, 44898, 44902, 44906, 44908, 44910, 44913, 44915, 44916, 44918, 44919)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:06:15 Duration: 193ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (36309, 37132, 37969, 38235, 38347, 38801, 38804, 38875, 39175, 39320, 39454, 39758, 39978, 39982, 40114, 40174, 40178, 40193, 40235, 40379, 40385, 40530, 40563, 40682, 40824, 40953, 40983, 41027, 41036, 41043, 41051, 41060, 41088, 41144, 41150, 41193, 41206, 41207, 41222, 41295)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 23:06:27 Duration: 182ms
-
SELECT "account_move".id FROM "account_move" WHERE ("account_move"."edi_810_id" in (44923, 44920, 44926, 44930, 44931, 44933, 44935, 44937, 44938, 44939, 44940, 44941, 44942, 44943, 44944, 44945, 44947, 44950, 44951, 44953, 44955, 44957, 44959, 44961, 44963, 44964, 44965, 44966)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:12:23 Duration: 176ms
18 147ms 192ms 152ms 174 26s510ms 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 Jan 28 10 42 6s362ms 151ms 11 121 18s445ms 152ms 12 11 1s702ms 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 = 2992 and pwi.warehouse_id = 46;
Date: 2024-01-28 11:27:56 Duration: 192ms
-
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 = 2926 and pwi.warehouse_id = 37;
Date: 2024-01-28 11:53:45 Duration: 189ms
-
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 = 2963 and pwi.warehouse_id = 35;
Date: 2024-01-28 11:41:27 Duration: 177ms
19 132ms 186ms 149ms 88 13s149ms 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 #19
Day Hour Count Duration Avg duration Jan 28 00 4 640ms 160ms 03 21 3s56ms 145ms 04 5 725ms 145ms 06 6 968ms 161ms 07 24 3s700ms 154ms 08 6 904ms 150ms 23 22 3s154ms 143ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (42773)) AND (("account_move"."id" not in (1101345)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 07:18:30 Duration: 186ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (44982)) AND (("account_move"."id" not in (1161337)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 06:06:25 Duration: 185ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (44839)) AND (("account_move"."id" not in (1123107)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-28 00:06:15 Duration: 180ms
20 133ms 292ms 145ms 51 7s422ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 28 17 9 1s274ms 141ms 21 7 995ms 142ms 23 35 5s152ms 147ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3076, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '05-F/INT/09795', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784222, 784223);
Date: 2024-01-28 23:50:29 Duration: 292ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 3057, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/10238', "scrapped" = false, "unit_factor" = 1.0, "weight" = '104.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784239);
Date: 2024-01-28 23:57:28 Duration: 161ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2924, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/10238', "scrapped" = false, "unit_factor" = 1.0, "weight" = '22.50', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (784238);
Date: 2024-01-28 23:57:28 Duration: 150ms
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
- 34,297 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 2300 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 1,676 Max number of times the same event was reported
- 2,300 Total events found
Rank Times reported Error 1 1,676 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 28 00 81 01 55 02 41 03 93 04 45 05 107 06 104 07 82 08 111 09 73 10 76 11 40 12 100 13 45 14 3 16 10 17 107 19 138 20 72 22 157 23 136 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "substitution_master_line" SET "write_uid"=4,"write_date"=(now() at time zone 'UTC') WHERE id IN (11585, 11586)
Date: 2024-01-28 14:30:31
2 596 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 28 00 19 01 19 02 19 03 21 04 20 05 17 06 19 07 88 08 67 09 19 10 21 11 19 12 22 13 22 14 22 15 17 16 20 17 21 18 17 19 18 20 18 21 22 22 27 23 22 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "website_visitor"
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-01-28 13:50:04
Statement: SELECT * FROM website_visitor where id = 11358193 FOR NO KEY UPDATE NOWAIT
Date: 2024-01-28 22:15:58
3 28 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 28 01 1 02 2 03 2 05 6 06 2 07 2 09 1 10 1 11 3 12 3 17 2 19 1 20 1 22 1 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = 'http_routing.http_error') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT 1
Date: 2024-01-28 02:08:42