pgBadger-
Global information
- Generated on Mon Jul 24 23:50:22 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 2,852 log entries in 21s
- Log start from 2023-07-23 00:02:56 to 2023-07-23 23:59:03
-
Overview
Global Stats
- 105 Number of unique normalized queries
- 608 Number of queries
- 13m28s Total query duration
- 2023-07-23 00:02:56 First query
- 2023-07-23 23:59:03 Last query
- 4 queries/s at 2023-07-23 09:00:29 Query peak
- 13m28s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 13m28s Execute total duration
- 469 Number of events
- 2 Number of unique normalized events
- 467 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
- 608 Average queries per session
- 13m28s 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
- 4 queries/s Query Peak
- 2023-07-23 09:00:29 Date
SELECT Traffic
Key values
- 3 queries/s Query Peak
- 2023-07-23 06:44:39 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2023-07-23 09:00:29 Date
Queries duration
Key values
- 13m28s 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) Jul 23 00 13 0ms 1s887ms 726ms 6s101ms 6s101ms 6s101ms 01 2 0ms 155ms 151ms 155ms 155ms 155ms 02 8 0ms 182ms 163ms 543ms 543ms 543ms 03 1 0ms 219ms 219ms 219ms 219ms 219ms 04 6 0ms 915ms 500ms 1s508ms 1s508ms 1s508ms 05 0 0ms 0ms 0ms 0ms 0ms 0ms 06 7 0ms 1s916ms 573ms 3s159ms 3s159ms 3s159ms 07 5 0ms 2s648ms 1s509ms 3s816ms 3s816ms 3s816ms 08 151 0ms 1s897ms 352ms 8s147ms 11s698ms 11s698ms 09 324 0ms 3m44s 1s965ms 1m23s 4m28s 4m28s 10 10 0ms 18s654ms 3s949ms 20s835ms 20s835ms 20s835ms 11 6 0ms 254ms 212ms 750ms 750ms 750ms 12 11 0ms 1s50ms 647ms 4s14ms 4s14ms 4s14ms 13 2 0ms 146ms 145ms 146ms 146ms 146ms 14 5 0ms 1s894ms 708ms 3s130ms 3s130ms 3s130ms 15 7 0ms 2s638ms 1s118ms 3s830ms 3s830ms 3s830ms 16 4 0ms 1s770ms 798ms 2s852ms 2s852ms 2s852ms 17 4 0ms 158ms 145ms 281ms 281ms 281ms 18 1 0ms 141ms 141ms 141ms 141ms 141ms 19 6 0ms 245ms 197ms 732ms 732ms 732ms 20 6 0ms 247ms 213ms 740ms 740ms 740ms 21 18 0ms 900ms 804ms 14s172ms 14s172ms 14s172ms 22 3 0ms 1s755ms 987ms 2s836ms 2s836ms 2s836ms 23 8 0ms 2s638ms 1s164ms 3s859ms 3s859ms 3s859ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 23 00 9 0 386ms 732ms 1s832ms 1s832ms 01 2 0 151ms 148ms 155ms 155ms 02 8 0 163ms 160ms 543ms 543ms 03 1 0 219ms 219ms 219ms 219ms 04 2 0 909ms 915ms 915ms 915ms 05 0 0 0ms 0ms 0ms 0ms 06 5 0 170ms 158ms 543ms 543ms 07 1 0 122ms 0ms 122ms 122ms 08 147 0 321ms 4s382ms 8s147ms 11s698ms 09 247 77 1s965ms 58s996ms 1m17s 4m24s 10 3 0 184ms 0ms 552ms 552ms 11 6 0 212ms 209ms 750ms 750ms 12 11 0 647ms 2s403ms 4s14ms 4s14ms 13 2 0 145ms 144ms 146ms 146ms 14 3 0 137ms 141ms 146ms 146ms 15 3 0 132ms 124ms 150ms 150ms 16 2 0 170ms 120ms 220ms 220ms 17 4 0 145ms 158ms 281ms 281ms 18 1 0 141ms 0ms 141ms 141ms 19 6 0 197ms 165ms 732ms 732ms 20 6 0 213ms 541ms 740ms 740ms 21 18 0 804ms 163ms 14s172ms 14s172ms 22 1 0 125ms 0ms 125ms 125ms 23 4 0 433ms 701ms 706ms 706ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 23 00 0 0 4 0 1s491ms 0ms 0ms 5s967ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 4 0 0 296ms 591ms 593ms 593ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 2 0 1s579ms 0ms 0ms 3s159ms 07 0 0 4 0 1s855ms 0ms 3s693ms 3s729ms 08 0 0 4 0 1s494ms 0ms 0ms 5s976ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 7 0 5s563ms 0ms 18s111ms 20s835ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 2 0 1s565ms 0ms 0ms 3s130ms 15 0 0 4 0 1s858ms 0ms 3s709ms 3s725ms 16 0 0 2 0 1s426ms 0ms 0ms 2s852ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 2 0 1s418ms 0ms 0ms 2s836ms 23 0 0 4 0 1s895ms 0ms 3s721ms 3s859ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 23 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 Jul 23 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 Jul 23 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 Jul 23 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 Jul 23 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) Jul 23 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 Jul 23 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 Jul 23 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 Jul 23 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
- 492 Total read queries
- 116 Total write queries
Queries by database
Key values
- unknown Main database
- 608 Requests
- 13m28s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 608 Requests
User Request type Count Duration unknown Total 608 13m28s copy to 77 9m16s delete 35 1m25s select 492 2m45s update 4 1s184ms Duration by user
Key values
- 13m28s (unknown) Main time consuming user
User Request type Count Duration unknown Total 608 13m28s copy to 77 9m16s delete 35 1m25s select 492 2m45s update 4 1s184ms Queries by host
Key values
- unknown Main host
- 608 Requests
- 13m28s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 608 Requests
- 13m28s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-07-23 09:06:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 466 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m44s 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: 2023-07-23 09:07:15 ]
2 1m13s 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: 2023-07-23 09:02:13 ]
3 1m13s 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: 2023-07-23 09:03:30 ]
4 27s855ms 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: 2023-07-23 09:09:24 ]
5 21s368ms 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) TO stdout;[ Date: 2023-07-23 09:08:18 ]
6 18s654ms DELETE FROM account_move_line WHERE id IN (2648908, 2648909, 2648910, 2648911, 2648912, 2648913, 2648914, 2648915, 2648916, 2648917, 2648918, 2648919, 2648920, 2648921, 2648922, 2648923, 2648924, 2648925, 2648926, 2765159, 2765160);[ Date: 2023-07-23 10:24:05 ]
7 17s400ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-07-23 09:08:57 ]
8 15s719ms 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) TO stdout;[ Date: 2023-07-23 09:00:27 ]
9 13s281ms DELETE FROM account_move_line WHERE id IN (2761988, 2761989, 2761990, 2761991, 2761992, 2761993, 2761994, 2761995, 2761996, 2761997, 2761998, 2761999, 2762000, 2761792, 2761793);[ Date: 2023-07-23 10:23:29 ]
10 10s532ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-23 09:00:42 ]
11 6s473ms 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) TO stdout;[ Date: 2023-07-23 09:00:11 ]
12 5s177ms 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: 2023-07-23 09:07:21 ]
13 4s681ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2023-07-23 09:07:27 ]
14 4s395ms 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) TO stdout;[ Date: 2023-07-23 09:08:30 ]
15 4s207ms 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) TO stdout;[ Date: 2023-07-23 09:00:54 ]
16 3s744ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-23 09:00:47 ]
17 3s8ms COPY public.stock_valuation_layer (id, company_id, product_id, quantity, unit_cost, value, remaining_qty, remaining_value, description, stock_valuation_layer_id, stock_move_id, account_move_id, create_uid, create_date, write_uid, write_date, move_options, other_action, final_action) TO stdout;[ Date: 2023-07-23 09:08:39 ]
18 2s863ms COPY public.sale_history_data (id, contact_reference, contact_name, customer_id, 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, invoice_id, note, user_id, create_uid, create_date, write_uid, write_date, history_id, history_date, history_type, manufacturing_usage) TO stdout;[ Date: 2023-07-23 09:07:57 ]
19 2s786ms COPY public.stock_move_line (id, picking_id, move_id, company_id, product_id, product_uom_id, product_qty, product_uom_qty, qty_done, package_id, package_level_id, lot_id, lot_name, result_package_id, date, owner_id, location_id, location_dest_id, state, reference, description_picking, create_uid, create_date, write_uid, write_date, workorder_id, production_id, related_core_sale_line_id, related_sale_line_id, related_core_purchase_line_id, related_purchase_line_id, related_core_stock_line_id, move_options, purchase_qty, related_repair_line_id, related_core_repair_line_id, branch_id, related_core_bom_line_id, related_bom_line_id, related_raw_material_production_id, linked_has_core_ml_id, order_purchase_qty, current_warehouse_qty) TO stdout;[ Date: 2023-07-23 09:08:33 ]
20 2s648ms DELETE FROM account_move_line WHERE id IN (2768180, 2768181, 2768182);[ Date: 2023-07-23 07:41:12 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3m44s 1 3m44s 3m44s 3m44s 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 Jul 23 09 1 3m44s 3m44s -
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: 2023-07-23 09:07:15 Duration: 3m44s
2 1m46s 357 289ms 348ms 297ms 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 #2
Day Hour Count Duration Avg duration Jul 23 08 130 38s288ms 294ms 09 227 1m8s 299ms -
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 = 38 and pwi.inventory_vendor_id = 2928 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 = 38 and pwi.inventory_vendor_id = 2928 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 = 38 and pwi.inventory_vendor_id = 2928 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:00:06 Duration: 348ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:09:27 Duration: 338ms
-
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 = 38 and pwi.inventory_vendor_id = 2934 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 = 38 and pwi.inventory_vendor_id = 2934 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 = 38 and pwi.inventory_vendor_id = 2934 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:00:17 Duration: 337ms
3 1m13s 1 1m13s 1m13s 1m13s 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 #3
Day Hour Count Duration Avg duration Jul 23 09 1 1m13s 1m13s -
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: 2023-07-23 09:02:13 Duration: 1m13s
4 1m13s 1 1m13s 1m13s 1m13s 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 #4
Day Hour Count Duration Avg duration Jul 23 09 1 1m13s 1m13s -
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: 2023-07-23 09:03:30 Duration: 1m13s
5 1m5s 19 883ms 18s654ms 3s421ms delete from account_move_line where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 00 2 3s637ms 1s818ms 06 1 1s916ms 1s916ms 07 2 5s266ms 2s633ms 08 2 3s646ms 1s823ms 10 5 34s587ms 6s917ms 14 1 1s894ms 1s894ms 15 2 5s267ms 2s633ms 16 1 1s770ms 1s770ms 22 1 1s755ms 1s755ms 23 2 5s259ms 2s629ms -
DELETE FROM account_move_line WHERE id IN (2648908, 2648909, 2648910, 2648911, 2648912, 2648913, 2648914, 2648915, 2648916, 2648917, 2648918, 2648919, 2648920, 2648921, 2648922, 2648923, 2648924, 2648925, 2648926, 2765159, 2765160);
Date: 2023-07-23 10:24:05 Duration: 18s654ms
-
DELETE FROM account_move_line WHERE id IN (2761988, 2761989, 2761990, 2761991, 2761992, 2761993, 2761994, 2761995, 2761996, 2761997, 2761998, 2761999, 2762000, 2761792, 2761793);
Date: 2023-07-23 10:23:29 Duration: 13s281ms
-
DELETE FROM account_move_line WHERE id IN (2768180, 2768181, 2768182);
Date: 2023-07-23 07:41:12 Duration: 2s648ms
6 27s855ms 1 27s855ms 27s855ms 27s855ms 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 #6
Day Hour Count Duration Avg duration Jul 23 09 1 27s855ms 27s855ms -
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: 2023-07-23 09:09:24 Duration: 27s855ms
7 21s368ms 1 21s368ms 21s368ms 21s368ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 09 1 21s368ms 21s368ms -
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) TO stdout;
Date: 2023-07-23 09:08:18 Duration: 21s368ms
8 20s306ms 16 1s76ms 2s180ms 1s269ms delete from account_move where id in (...);Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 23 00 2 2s330ms 1s165ms 06 1 1s242ms 1s242ms 07 2 2s156ms 1s78ms 08 2 2s329ms 1s164ms 10 2 4s358ms 2s179ms 14 1 1s236ms 1s236ms 15 2 2s167ms 1s83ms 16 1 1s81ms 1s81ms 22 1 1s81ms 1s81ms 23 2 2s321ms 1s160ms -
DELETE FROM account_move WHERE id IN (737310, 773294);
Date: 2023-07-23 10:24:07 Duration: 2s180ms
-
DELETE FROM account_move WHERE id IN (772532, 772481);
Date: 2023-07-23 10:23:31 Duration: 2s178ms
-
DELETE FROM account_move WHERE id IN (773826);
Date: 2023-07-23 08:05:10 Duration: 1s246ms
9 17s400ms 1 17s400ms 17s400ms 17s400ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 09 1 17s400ms 17s400ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-07-23 09:08:57 Duration: 17s400ms
10 15s719ms 1 15s719ms 15s719ms 15s719ms 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) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 09 1 15s719ms 15s719ms -
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) TO stdout;
Date: 2023-07-23 09:00:27 Duration: 15s719ms
11 10s627ms 12 879ms 900ms 885ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 21 12 10s627ms 885ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:25 Duration: 900ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:29 Duration: 886ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:19 Duration: 886ms
12 10s532ms 1 10s532ms 10s532ms 10s532ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 09 1 10s532ms 10s532ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-23 09:00:42 Duration: 10s532ms
13 8s128ms 10 788ms 833ms 812ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 23 08 4 3s235ms 808ms 09 6 4s892ms 815ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3689 and ill.method not in (8, 7);
Date: 2023-07-23 09:01:15 Duration: 833ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3690 and ill.method not in (8, 7);
Date: 2023-07-23 09:03:13 Duration: 826ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3685 and ill.method not in (8, 7);
Date: 2023-07-23 08:57:24 Duration: 824ms
14 6s514ms 10 630ms 692ms 651ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true and ill.item_demand_plan_id = ? group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 08 4 2s580ms 645ms 09 6 3s933ms 655ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3687 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:00:51 Duration: 692ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3690 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:03:12 Duration: 676ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3692 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:09:23 Duration: 658ms
15 6s473ms 1 6s473ms 6s473ms 6s473ms 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) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 23 09 1 6s473ms 6s473ms -
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) TO stdout;
Date: 2023-07-23 09:00:11 Duration: 6s473ms
16 5s709ms 6 809ms 1s50ms 951ms select min("account_move_line".id) as id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" AS "move_id" from "account_move_line" left join "account_move" AS "account_move_line__move_id" on ("account_move_line"."move_id" = "account_move_line__move_id"."id") where ((("account_move_line"."display_type" not in (...)) or "account_move_line"."display_type" is null) and ("account_move_line"."parent_state" = ?)) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) group by "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" order by "account_move_line__move_id"."invoice_date_due" limit ? offset ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 12 6 5s709ms 951ms -
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 400080;
Date: 2023-07-23 12:18:07 Duration: 1s50ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 500080;
Date: 2023-07-23 12:18:10 Duration: 1s39ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 300080;
Date: 2023-07-23 12:18:05 Duration: 991ms
17 5s496ms 37 120ms 165ms 148ms 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 #17
Day Hour Count Duration Avg duration Jul 23 00 1 151ms 151ms 01 2 303ms 151ms 02 5 763ms 152ms 06 2 309ms 154ms 08 2 299ms 149ms 09 1 157ms 157ms 11 2 313ms 156ms 12 1 162ms 162ms 13 2 291ms 145ms 14 3 412ms 137ms 15 2 275ms 137ms 16 1 120ms 120ms 17 4 581ms 145ms 18 1 141ms 141ms 19 3 450ms 150ms 21 2 309ms 154ms 22 1 125ms 125ms 23 2 325ms 162ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 19:02:24') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 19:03:14 Duration: 165ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 11:20:46') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 11:21:36 Duration: 165ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 23:22:46') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 23:23:36 Duration: 163ms
18 5s179ms 10 507ms 579ms 517ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 08 4 2s118ms 529ms 09 6 3s61ms 510ms -
select count(id) from item_list_line where item_demand_plan_id = 3683;
Date: 2023-07-23 08:52:27 Duration: 579ms
-
select count(id) from item_list_line where item_demand_plan_id = 3684;
Date: 2023-07-23 08:55:21 Duration: 516ms
-
select count(id) from item_list_line where item_demand_plan_id = 3691;
Date: 2023-07-23 09:06:37 Duration: 515ms
19 5s177ms 1 5s177ms 5s177ms 5s177ms 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;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 09 1 5s177ms 5s177ms -
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: 2023-07-23 09:07:21 Duration: 5s177ms
20 4s681ms 1 4s681ms 4s681ms 4s681ms copy public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 09 1 4s681ms 4s681ms -
COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;
Date: 2023-07-23 09:07:27 Duration: 4s681ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 357 1m46s 289ms 348ms 297ms 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 #1
Day Hour Count Duration Avg duration Jul 23 08 130 38s288ms 294ms 09 227 1m8s 299ms -
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 = 38 and pwi.inventory_vendor_id = 2928 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 = 38 and pwi.inventory_vendor_id = 2928 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 = 38 and pwi.inventory_vendor_id = 2928 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:00:06 Duration: 348ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 2978 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:09:27 Duration: 338ms
-
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 = 38 and pwi.inventory_vendor_id = 2934 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 = 38 and pwi.inventory_vendor_id = 2934 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 = 38 and pwi.inventory_vendor_id = 2934 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-07-23 09:00:17 Duration: 337ms
2 37 5s496ms 120ms 165ms 148ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 23 00 1 151ms 151ms 01 2 303ms 151ms 02 5 763ms 152ms 06 2 309ms 154ms 08 2 299ms 149ms 09 1 157ms 157ms 11 2 313ms 156ms 12 1 162ms 162ms 13 2 291ms 145ms 14 3 412ms 137ms 15 2 275ms 137ms 16 1 120ms 120ms 17 4 581ms 145ms 18 1 141ms 141ms 19 3 450ms 150ms 21 2 309ms 154ms 22 1 125ms 125ms 23 2 325ms 162ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 19:02:24') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 19:03:14 Duration: 165ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 11:20:46') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 11:21:36 Duration: 165ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-23 23:22:46') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-23 23:23:36 Duration: 163ms
3 19 1m5s 883ms 18s654ms 3s421ms delete from account_move_line where id in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 23 00 2 3s637ms 1s818ms 06 1 1s916ms 1s916ms 07 2 5s266ms 2s633ms 08 2 3s646ms 1s823ms 10 5 34s587ms 6s917ms 14 1 1s894ms 1s894ms 15 2 5s267ms 2s633ms 16 1 1s770ms 1s770ms 22 1 1s755ms 1s755ms 23 2 5s259ms 2s629ms -
DELETE FROM account_move_line WHERE id IN (2648908, 2648909, 2648910, 2648911, 2648912, 2648913, 2648914, 2648915, 2648916, 2648917, 2648918, 2648919, 2648920, 2648921, 2648922, 2648923, 2648924, 2648925, 2648926, 2765159, 2765160);
Date: 2023-07-23 10:24:05 Duration: 18s654ms
-
DELETE FROM account_move_line WHERE id IN (2761988, 2761989, 2761990, 2761991, 2761992, 2761993, 2761994, 2761995, 2761996, 2761997, 2761998, 2761999, 2762000, 2761792, 2761793);
Date: 2023-07-23 10:23:29 Duration: 13s281ms
-
DELETE FROM account_move_line WHERE id IN (2768180, 2768181, 2768182);
Date: 2023-07-23 07:41:12 Duration: 2s648ms
4 16 20s306ms 1s76ms 2s180ms 1s269ms delete from account_move where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 23 00 2 2s330ms 1s165ms 06 1 1s242ms 1s242ms 07 2 2s156ms 1s78ms 08 2 2s329ms 1s164ms 10 2 4s358ms 2s179ms 14 1 1s236ms 1s236ms 15 2 2s167ms 1s83ms 16 1 1s81ms 1s81ms 22 1 1s81ms 1s81ms 23 2 2s321ms 1s160ms -
DELETE FROM account_move WHERE id IN (737310, 773294);
Date: 2023-07-23 10:24:07 Duration: 2s180ms
-
DELETE FROM account_move WHERE id IN (772532, 772481);
Date: 2023-07-23 10:23:31 Duration: 2s178ms
-
DELETE FROM account_move WHERE id IN (773826);
Date: 2023-07-23 08:05:10 Duration: 1s246ms
5 12 10s627ms 879ms 900ms 885ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 21 12 10s627ms 885ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:25 Duration: 900ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:29 Duration: 886ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:19 Duration: 886ms
6 12 2s177ms 179ms 184ms 181ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 23 06 3 543ms 181ms 10 3 552ms 184ms 12 3 540ms 180ms 20 3 541ms 180ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-23 10:51:44 Duration: 184ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-23 10:51:44 Duration: 184ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-23 10:51:45 Duration: 183ms
7 10 8s128ms 788ms 833ms 812ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 08 4 3s235ms 808ms 09 6 4s892ms 815ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3689 and ill.method not in (8, 7);
Date: 2023-07-23 09:01:15 Duration: 833ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3690 and ill.method not in (8, 7);
Date: 2023-07-23 09:03:13 Duration: 826ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3685 and ill.method not in (8, 7);
Date: 2023-07-23 08:57:24 Duration: 824ms
8 10 6s514ms 630ms 692ms 651ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true and ill.item_demand_plan_id = ? group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 23 08 4 2s580ms 645ms 09 6 3s933ms 655ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3687 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:00:51 Duration: 692ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3690 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:03:12 Duration: 676ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3692 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 09:09:23 Duration: 658ms
9 10 5s179ms 507ms 579ms 517ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 08 4 2s118ms 529ms 09 6 3s61ms 510ms -
select count(id) from item_list_line where item_demand_plan_id = 3683;
Date: 2023-07-23 08:52:27 Duration: 579ms
-
select count(id) from item_list_line where item_demand_plan_id = 3684;
Date: 2023-07-23 08:55:21 Duration: 516ms
-
select count(id) from item_list_line where item_demand_plan_id = 3691;
Date: 2023-07-23 09:06:37 Duration: 515ms
10 9 2s218ms 243ms 254ms 246ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 08 3 736ms 245ms 11 3 750ms 250ms 19 3 732ms 244ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-23 11:46:14 Duration: 254ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-23 11:46:15 Duration: 248ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-23 11:46:15 Duration: 248ms
11 6 5s709ms 809ms 1s50ms 951ms select min("account_move_line".id) as id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" AS "move_id" from "account_move_line" left join "account_move" AS "account_move_line__move_id" on ("account_move_line"."move_id" = "account_move_line__move_id"."id") where ((("account_move_line"."display_type" not in (...)) or "account_move_line"."display_type" is null) and ("account_move_line"."parent_state" = ?)) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) group by "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" order by "account_move_line__move_id"."invoice_date_due" limit ? offset ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 12 6 5s709ms 951ms -
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 400080;
Date: 2023-07-23 12:18:07 Duration: 1s50ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 500080;
Date: 2023-07-23 12:18:10 Duration: 1s39ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 300080;
Date: 2023-07-23 12:18:05 Duration: 991ms
12 4 838ms 209ms 210ms 209ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 00 3 629ms 209ms 11 1 209ms 209ms -
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.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-210dda0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-23 00:43:33 Duration: 210ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-23 00:43:34 Duration: 209ms
-
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.report_assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-210dda0/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-23 00:43:34 Duration: 209ms
13 3 740ms 245ms 247ms 246ms 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 #13
Day Hour Count Duration Avg duration Jul 23 20 3 740ms 246ms -
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: 2023-07-23 20:16:29 Duration: 247ms
-
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: 2023-07-23 20:16:28 Duration: 247ms
-
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: 2023-07-23 20:16:29 Duration: 245ms
14 3 543ms 179ms 182ms 181ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 02 3 543ms 181ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-23 02:34:02 Duration: 182ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-23 02:34:02 Duration: 181ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-23 02:34:02 Duration: 179ms
15 3 377ms 120ms 133ms 125ms 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 #15
Day Hour Count Duration Avg duration Jul 23 00 1 133ms 133ms 07 1 122ms 122ms 15 1 120ms 120ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (32672)) AND (("account_move"."id" not in (773357)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2023-07-23 00:05:09 Duration: 133ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (32017)) AND (("account_move"."id" not in (760607, 766641, 766642)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2023-07-23 07:47:06 Duration: 122ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (32089)) AND (("account_move"."id" not in (760662, 760661)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2023-07-23 15:47:09 Duration: 120ms
16 2 1s819ms 903ms 915ms 909ms select distinct idp.id as item_demand_plan_id from item_demand_plan idp left join item_list_line as ill on idp.id = ill.item_demand_plan_id left join forecasted_data as fd on idp.id = fd.item_demand_plan_id where idp.fetch_data_done = true and idp.active = true and idp.create_date > current_timestamp - interval ? and ill.method not in (...) and idp.id not in ( select item_demand_plan_id from item_list_line where coalesce(method, ?) = ?) and fd.id is null group by idp.id, ill.method;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 04 2 1s819ms 909ms -
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-23 04:00:03 Duration: 915ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-23 04:30:04 Duration: 903ms
17 2 1s773ms 885ms 887ms 886ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 23 21 2 1s773ms 886ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%501%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%501%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%501%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%501%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%501%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%501%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-07-23 21:32:17 Duration: 887ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-07-23 21:32:18 Duration: 885ms
18 2 1s771ms 885ms 886ms 885ms select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 21 2 1s771ms 885ms -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%501%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%501%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%501%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%501%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%501%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%501%'))));
Date: 2023-07-23 21:32:18 Duration: 886ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%'))));
Date: 2023-07-23 21:32:19 Duration: 885ms
19 2 1s407ms 701ms 706ms 703ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 23 2 1s407ms 703ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 23:59:03 Duration: 706ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 23:55:03 Duration: 701ms
20 2 698ms 348ms 350ms 349ms update item_demand_plan set is_start_forecast = false where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where method in (...) and idp.fetch_data_done = true and idp.active = true group by ill.item_demand_plan_id intersect select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = true group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand left join item_demand_plan as idp2 on data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = true);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 04 2 698ms 349ms -
update item_demand_plan set is_start_forecast = False where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where method in (7, 8) and idp.fetch_data_done = True and idp.active = True group by ill.item_demand_plan_id INTERSECT select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = True group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand LEFT JOIN item_demand_plan as idp2 ON data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = True);
Date: 2023-07-23 04:00:02 Duration: 350ms
-
update item_demand_plan set is_start_forecast = False where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where method in (7, 8) and idp.fetch_data_done = True and idp.active = True group by ill.item_demand_plan_id INTERSECT select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = True group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand LEFT JOIN item_demand_plan as idp2 ON data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = True);
Date: 2023-07-23 04:30:03 Duration: 348ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m44s 3m44s 3m44s 1 3m44s 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 Jul 23 09 1 3m44s 3m44s -
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: 2023-07-23 09:07:15 Duration: 3m44s
2 1m13s 1m13s 1m13s 1 1m13s 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 Jul 23 09 1 1m13s 1m13s -
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: 2023-07-23 09:02:13 Duration: 1m13s
3 1m13s 1m13s 1m13s 1 1m13s 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 Jul 23 09 1 1m13s 1m13s -
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: 2023-07-23 09:03:30 Duration: 1m13s
4 27s855ms 27s855ms 27s855ms 1 27s855ms 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 Jul 23 09 1 27s855ms 27s855ms -
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: 2023-07-23 09:09:24 Duration: 27s855ms
5 21s368ms 21s368ms 21s368ms 1 21s368ms 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) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 23 09 1 21s368ms 21s368ms -
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) TO stdout;
Date: 2023-07-23 09:08:18 Duration: 21s368ms
6 17s400ms 17s400ms 17s400ms 1 17s400ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 23 09 1 17s400ms 17s400ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-07-23 09:08:57 Duration: 17s400ms
7 15s719ms 15s719ms 15s719ms 1 15s719ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 23 09 1 15s719ms 15s719ms -
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) TO stdout;
Date: 2023-07-23 09:00:27 Duration: 15s719ms
8 10s532ms 10s532ms 10s532ms 1 10s532ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 23 09 1 10s532ms 10s532ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-23 09:00:42 Duration: 10s532ms
9 6s473ms 6s473ms 6s473ms 1 6s473ms 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) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 23 09 1 6s473ms 6s473ms -
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) TO stdout;
Date: 2023-07-23 09:00:11 Duration: 6s473ms
10 5s177ms 5s177ms 5s177ms 1 5s177ms 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;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 23 09 1 5s177ms 5s177ms -
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: 2023-07-23 09:07:21 Duration: 5s177ms
11 4s681ms 4s681ms 4s681ms 1 4s681ms copy public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 23 09 1 4s681ms 4s681ms -
COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;
Date: 2023-07-23 09:07:27 Duration: 4s681ms
12 883ms 18s654ms 3s421ms 19 1m5s delete from account_move_line where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 23 00 2 3s637ms 1s818ms 06 1 1s916ms 1s916ms 07 2 5s266ms 2s633ms 08 2 3s646ms 1s823ms 10 5 34s587ms 6s917ms 14 1 1s894ms 1s894ms 15 2 5s267ms 2s633ms 16 1 1s770ms 1s770ms 22 1 1s755ms 1s755ms 23 2 5s259ms 2s629ms -
DELETE FROM account_move_line WHERE id IN (2648908, 2648909, 2648910, 2648911, 2648912, 2648913, 2648914, 2648915, 2648916, 2648917, 2648918, 2648919, 2648920, 2648921, 2648922, 2648923, 2648924, 2648925, 2648926, 2765159, 2765160);
Date: 2023-07-23 10:24:05 Duration: 18s654ms
-
DELETE FROM account_move_line WHERE id IN (2761988, 2761989, 2761990, 2761991, 2761992, 2761993, 2761994, 2761995, 2761996, 2761997, 2761998, 2761999, 2762000, 2761792, 2761793);
Date: 2023-07-23 10:23:29 Duration: 13s281ms
-
DELETE FROM account_move_line WHERE id IN (2768180, 2768181, 2768182);
Date: 2023-07-23 07:41:12 Duration: 2s648ms
13 1s76ms 2s180ms 1s269ms 16 20s306ms delete from account_move where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 23 00 2 2s330ms 1s165ms 06 1 1s242ms 1s242ms 07 2 2s156ms 1s78ms 08 2 2s329ms 1s164ms 10 2 4s358ms 2s179ms 14 1 1s236ms 1s236ms 15 2 2s167ms 1s83ms 16 1 1s81ms 1s81ms 22 1 1s81ms 1s81ms 23 2 2s321ms 1s160ms -
DELETE FROM account_move WHERE id IN (737310, 773294);
Date: 2023-07-23 10:24:07 Duration: 2s180ms
-
DELETE FROM account_move WHERE id IN (772532, 772481);
Date: 2023-07-23 10:23:31 Duration: 2s178ms
-
DELETE FROM account_move WHERE id IN (773826);
Date: 2023-07-23 08:05:10 Duration: 1s246ms
14 809ms 1s50ms 951ms 6 5s709ms select min("account_move_line".id) as id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" AS "move_id" from "account_move_line" left join "account_move" AS "account_move_line__move_id" on ("account_move_line"."move_id" = "account_move_line__move_id"."id") where ((("account_move_line"."display_type" not in (...)) or "account_move_line"."display_type" is null) and ("account_move_line"."parent_state" = ?)) and ("account_move_line"."company_id" is null or ("account_move_line"."company_id" in (...))) group by "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" order by "account_move_line__move_id"."invoice_date_due" limit ? offset ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 23 12 6 5s709ms 951ms -
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 400080;
Date: 2023-07-23 12:18:07 Duration: 1s50ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 500080;
Date: 2023-07-23 12:18:10 Duration: 1s39ms
-
SELECT min("account_move_line".id) AS id, count("account_move_line".id) AS "move_id_count", "account_move_line"."move_id" as "move_id" FROM "account_move_line" LEFT JOIN "account_move" AS "account_move_line__move_id" ON ("account_move_line"."move_id" = "account_move_line__move_id"."id") WHERE ((("account_move_line"."display_type" not in ('line_section', 'line_note')) OR "account_move_line"."display_type" IS NULL) AND ("account_move_line"."parent_state" = 'posted')) AND ("account_move_line"."company_id" IS NULL OR ("account_move_line"."company_id" in (1))) GROUP BY "account_move_line"."move_id", "account_move_line__move_id"."invoice_date_due" ORDER BY "account_move_line__move_id"."invoice_date_due" LIMIT 100000 OFFSET 300080;
Date: 2023-07-23 12:18:05 Duration: 991ms
15 903ms 915ms 909ms 2 1s819ms select distinct idp.id as item_demand_plan_id from item_demand_plan idp left join item_list_line as ill on idp.id = ill.item_demand_plan_id left join forecasted_data as fd on idp.id = fd.item_demand_plan_id where idp.fetch_data_done = true and idp.active = true and idp.create_date > current_timestamp - interval ? and ill.method not in (...) and idp.id not in ( select item_demand_plan_id from item_list_line where coalesce(method, ?) = ?) and fd.id is null group by idp.id, ill.method;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 23 04 2 1s819ms 909ms -
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-23 04:00:03 Duration: 915ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-23 04:30:04 Duration: 903ms
16 885ms 887ms 886ms 2 1s773ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 23 21 2 1s773ms 886ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%501%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%501%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%501%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%501%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%501%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%501%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-07-23 21:32:17 Duration: 887ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-07-23 21:32:18 Duration: 885ms
17 885ms 886ms 885ms 2 1s771ms select count(?) from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 23 21 2 1s771ms 885ms -
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%501%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%501%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%501%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%501%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%501%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%501%'))));
Date: 2023-07-23 21:32:18 Duration: 886ms
-
SELECT count(1) FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%'))));
Date: 2023-07-23 21:32:19 Duration: 885ms
18 879ms 900ms 885ms 12 10s627ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 23 21 12 10s627ms 885ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:25 Duration: 900ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:29 Duration: 886ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%5015%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%5015%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%5015%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%5015%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%5015%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-23 21:32:19 Duration: 886ms
19 788ms 833ms 812ms 10 8s128ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 23 08 4 3s235ms 808ms 09 6 4s892ms 815ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3689 and ill.method not in (8, 7);
Date: 2023-07-23 09:01:15 Duration: 833ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3690 and ill.method not in (8, 7);
Date: 2023-07-23 09:03:13 Duration: 826ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3685 and ill.method not in (8, 7);
Date: 2023-07-23 08:57:24 Duration: 824ms
20 701ms 706ms 703ms 2 1s407ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 23 23 2 1s407ms 703ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 23:59:03 Duration: 706ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-07-23 23:55:03 Duration: 701ms
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
- 1,546 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 469 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 467 Max number of times the same event was reported
- 469 Total events found
Rank Times reported Error 1 467 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 23 00 11 01 15 02 12 03 14 04 11 05 11 06 11 07 39 08 63 09 97 10 19 11 11 12 12 13 14 14 13 15 16 16 11 17 10 18 13 19 8 20 13 21 15 22 14 23 14 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=58 FOR UPDATE NOWAIT
Date: 2023-07-23 00:05:04
2 2 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 23 21 2 - 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 (17537, 17538, 17541, 17542, 13713, 13714, 18071, 18072)
Date: 2023-07-23 21:32:22