pgBadger-
Global information
- Generated on Mon Jun 12 23:50:21 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 9,476 log entries in 20s
- Log start from 2023-06-11 00:03:38 to 2023-06-11 23:59:02
-
Overview
Global Stats
- 108 Number of unique normalized queries
- 2,249 Number of queries
- 15m23s Total query duration
- 2023-06-11 00:03:38 First query
- 2023-06-11 23:59:02 Last query
- 6 queries/s at 2023-06-11 23:40:17 Query peak
- 15m23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 15m23s Execute total duration
- 1,248 Number of events
- 5 Number of unique normalized events
- 357 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
- 2,249 Average queries per session
- 15m23s 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
- 6 queries/s Query Peak
- 2023-06-11 23:40:17 Date
SELECT Traffic
Key values
- 6 queries/s Query Peak
- 2023-06-11 23:40:17 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2023-06-11 09:00:52 Date
Queries duration
Key values
- 15m23s 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) Jun 11 00 16 0ms 180ms 169ms 535ms 578ms 578ms 01 3 0ms 145ms 141ms 0ms 423ms 423ms 02 318 0ms 773ms 191ms 2s233ms 2s351ms 3s328ms 03 529 0ms 248ms 184ms 3s622ms 3s779ms 4s742ms 04 21 0ms 866ms 216ms 1s264ms 1s365ms 1s365ms 05 10 0ms 179ms 159ms 535ms 535ms 535ms 06 16 0ms 178ms 157ms 530ms 531ms 531ms 07 9 0ms 177ms 155ms 529ms 738ms 738ms 08 223 0ms 798ms 169ms 5s362ms 6s366ms 7s665ms 09 268 0ms 3m42s 2s70ms 1m11s 1m17s 3m46s 10 3 0ms 250ms 247ms 0ms 742ms 742ms 11 2 0ms 190ms 155ms 0ms 311ms 311ms 12 7 0ms 247ms 195ms 626ms 738ms 738ms 13 12 0ms 249ms 228ms 739ms 740ms 740ms 14 7 0ms 196ms 163ms 553ms 594ms 594ms 15 21 0ms 250ms 175ms 736ms 742ms 742ms 16 5 0ms 183ms 161ms 0ms 807ms 807ms 17 168 0ms 251ms 183ms 2s172ms 2s636ms 2s893ms 18 533 0ms 249ms 184ms 2s350ms 2s728ms 4s70ms 19 7 0ms 245ms 206ms 534ms 731ms 731ms 20 10 0ms 242ms 185ms 586ms 723ms 723ms 21 11 0ms 246ms 172ms 543ms 620ms 735ms 22 8 0ms 146ms 135ms 388ms 423ms 423ms 23 42 0ms 1s668ms 304ms 2s808ms 6s988ms 6s988ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 11 00 16 0 169ms 532ms 535ms 578ms 01 3 0 141ms 0ms 0ms 423ms 02 318 0 191ms 2s175ms 2s233ms 3s328ms 03 529 0 184ms 3s223ms 3s622ms 4s742ms 04 19 0 212ms 565ms 866ms 1s264ms 05 10 0 159ms 521ms 535ms 535ms 06 16 0 157ms 528ms 530ms 531ms 07 9 0 155ms 0ms 529ms 738ms 08 223 0 169ms 3s466ms 5s362ms 7s665ms 09 197 71 2s70ms 50s981ms 1m8s 3m42s 10 3 0 247ms 0ms 0ms 742ms 11 2 0 155ms 0ms 0ms 311ms 12 7 0 195ms 0ms 626ms 738ms 13 12 0 228ms 533ms 739ms 740ms 14 7 0 163ms 0ms 553ms 594ms 15 21 0 175ms 572ms 736ms 742ms 16 5 0 161ms 0ms 0ms 807ms 17 168 0 183ms 1s988ms 2s172ms 2s893ms 18 533 0 184ms 2s23ms 2s350ms 2s729ms 19 7 0 206ms 0ms 534ms 731ms 20 10 0 185ms 0ms 586ms 723ms 21 11 0 172ms 0ms 543ms 735ms 22 8 0 135ms 0ms 388ms 423ms 23 42 0 304ms 727ms 2s808ms 6s988ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jun 11 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 2 0 0 249ms 0ms 0ms 499ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 0 0 0ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 0 0 0ms 0ms 0ms 0ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jun 11 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 Jun 11 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 Jun 11 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 Jun 11 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 Jun 11 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) Jun 11 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 Jun 11 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 Jun 11 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 Jun 11 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
- 2,176 Total read queries
- 73 Total write queries
Queries by database
Key values
- unknown Main database
- 2,249 Requests
- 15m23s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 2,249 Requests
User Request type Count Duration unknown Total 2,249 15m23s copy to 71 8m42s select 2,176 6m39s update 2 499ms Duration by user
Key values
- 15m23s (unknown) Main time consuming user
User Request type Count Duration unknown Total 2,249 15m23s copy to 71 8m42s select 2,176 6m39s update 2 499ms Queries by host
Key values
- unknown Main host
- 2,249 Requests
- 15m23s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 2,249 Requests
- 15m23s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-06-11 09:06:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,171 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m42s 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-06-11 09:06:57 ]
2 1m9s 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-06-11 09:02:02 ]
3 1m8s 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-06-11 09:03:14 ]
4 22s987ms 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-06-11 09:08:51 ]
5 20s930ms 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) TO stdout;[ Date: 2023-06-11 09:07:55 ]
6 14s17ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-06-11 09:08:28 ]
7 13s365ms 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) TO stdout;[ Date: 2023-06-11 09:00:23 ]
8 9s144ms 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-06-11 09:00:37 ]
9 5s639ms 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) TO stdout;[ Date: 2023-06-11 09:00:10 ]
10 4s570ms 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-06-11 09:07:08 ]
11 3s854ms 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-06-11 09:07:01 ]
12 3s830ms 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-06-11 09:00:48 ]
13 3s769ms 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-06-11 09:08:06 ]
14 3s371ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-06-11 09:00:41 ]
15 2s773ms 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-06-11 09:07:34 ]
16 2s563ms 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-06-11 09:08:13 ]
17 2s463ms COPY public.price_sheet_control (id, message_main_attachment_id, inventory_vendor_id, run_number, part_type_id, part_type_option, price_effective_date, description, report_name, price_sheet_load_notes, create_date, skip_man_cost_update, call_for_prise, state, process_option, import_vendor_id, cost_change_limit, is_duplicate_warn, active, product_catelog_exe_date, product_lib_exe_date, is_auto_process, is_auto_processing, is_auto_processed, file_json_data, cron_1_start, cron_1_end, prerun_report_name, is_auto_process_lib, create_uid, write_uid, write_date, lib_processing_start, lib_is_processing, ps_processing_start, use_field_tracking, catalog_in_progress, ps_catalog_start) TO stdout;[ Date: 2023-06-11 09:07:03 ]
18 2s392ms COPY public.back_up_product_warehouse_inventory_3_jun (id, company_id, warehouse_id, product_id, product_tmpl_id, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_shipped_not_invoiced, qty_in_transist, qty_mtd_sold, qty_ytd_sold, qty_ytd_transfer_another, qty_ytd_lost_sales, last_receive_date, qty_last_receive, qty_available_last_year, qty_sold_last_year, qty_ly_transfer_another, 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, discontinued, superceded, call_for_price, man_cost_update, obsolete, cat_prod_type, cat_part_type, can_be_sold, can_be_purchased, has_core, is_core, is_direct_order_product, core_product_id, inventory_vendor_id, categ_id, product_type, create_uid, create_date, write_uid, write_date, stocking_flag, freeze_date, product_uom, reorder_id, min_product_uom_qty, max_product_uom_qty, warehouse_name, last_used_date, intra_reserve_done, last_intra_company_receipt_date, last_intra_company_qty, lead_days, mtd_sold_system_qty, shipped_not_invoiced_system_qty, ytd_sold_qty, ytd_tran_qty, history_id, history_date, history_type, last_stock_flag_update, loc_check_qty, replenish_branch_id, rep_loc_check_qty, cron_last_stock_flag_update, unit_cost, message_main_attachment_id, branch_id) TO stdout;[ Date: 2023-06-11 09:00:28 ]
19 2s384ms COPY public.pwi_backup_may31 (id, company_id, warehouse_id, product_id, product_tmpl_id, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_shipped_not_invoiced, qty_in_transist, qty_mtd_sold, qty_ytd_sold, qty_ytd_transfer_another, qty_ytd_lost_sales, last_receive_date, qty_last_receive, qty_available_last_year, qty_sold_last_year, qty_ly_transfer_another, 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, discontinued, superceded, call_for_price, man_cost_update, obsolete, cat_prod_type, cat_part_type, can_be_sold, can_be_purchased, has_core, is_core, is_direct_order_product, core_product_id, inventory_vendor_id, categ_id, product_type, create_uid, create_date, write_uid, write_date, stocking_flag, freeze_date, product_uom, reorder_id, min_product_uom_qty, max_product_uom_qty, warehouse_name, last_used_date, intra_reserve_done, last_intra_company_receipt_date, last_intra_company_qty, lead_days, mtd_sold_system_qty, shipped_not_invoiced_system_qty, ytd_sold_qty, ytd_tran_qty, history_id, history_date, history_type, last_stock_flag_update, loc_check_qty, replenish_branch_id, rep_loc_check_qty, cron_last_stock_flag_update, unit_cost, message_main_attachment_id) TO stdout;[ Date: 2023-06-11 09:07:30 ]
20 2s384ms 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-06-11 09:08:08 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 4m30s 1,480 179ms 248ms 182ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 11 02 291 52s947ms 181ms 03 520 1m35s 183ms 17 153 27s854ms 182ms 18 515 1m34s 183ms 19 1 181ms 181ms -
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-44261d3/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 03:02:50 Duration: 248ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 03:36:02 Duration: 248ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-44261d3/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 17:49:33 Duration: 239ms
2 3m42s 1 3m42s 3m42s 3m42s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jun 11 09 1 3m42s 3m42s -
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-06-11 09:06:57 Duration: 3m42s
3 1m9s 1 1m9s 1m9s 1m9s 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 Jun 11 09 1 1m9s 1m9s -
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-06-11 09:02:02 Duration: 1m9s
4 1m8s 1 1m8s 1m8s 1m8s 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 Jun 11 09 1 1m8s 1m8s -
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-06-11 09:03:14 Duration: 1m8s
5 45s202ms 356 121ms 162ms 126ms 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 #5
Day Hour Count Duration Avg duration Jun 11 08 187 23s568ms 126ms 09 169 21s633ms 128ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:01:35 Duration: 162ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:03:24 Duration: 158ms
-
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 = 41 and pwi.inventory_vendor_id = 2915 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 = 41 and pwi.inventory_vendor_id = 2915 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 = 41 and pwi.inventory_vendor_id = 2915 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:06:26 Duration: 157ms
6 22s987ms 1 22s987ms 22s987ms 22s987ms 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 Jun 11 09 1 22s987ms 22s987ms -
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-06-11 09:08:51 Duration: 22s987ms
7 20s930ms 1 20s930ms 20s930ms 20s930ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 11 09 1 20s930ms 20s930ms -
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) TO stdout;
Date: 2023-06-11 09:07:55 Duration: 20s930ms
8 17s234ms 119 124ms 185ms 144ms 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 #8
Day Hour Count Duration Avg duration Jun 11 00 4 578ms 144ms 01 3 423ms 141ms 02 7 1s47ms 149ms 04 9 1s370ms 152ms 05 4 521ms 130ms 06 7 926ms 132ms 07 5 738ms 147ms 08 9 1s337ms 148ms 09 9 1s276ms 141ms 12 4 626ms 156ms 14 4 594ms 148ms 15 12 1s678ms 139ms 16 5 807ms 161ms 17 6 890ms 148ms 18 3 414ms 138ms 20 4 586ms 146ms 21 8 1s164ms 145ms 22 8 1s87ms 135ms 23 8 1s164ms 145ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 04:15:14') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19535]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",241]', '["pointspring_master","mail.channel",435]', '["pointspring_master","mail.channel",452]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",471]', '["pointspring_master","res.partner",19535]', '["pointspring_master","ir.needaction",19535]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 04:16:04 Duration: 185ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 16:25:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_11"', '["pointspring_master","calendar.alarm",14]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",16]', '["pointspring_master","mail.channel",348]', '["pointspring_master","mail.channel",349]', '["pointspring_master","mail.channel",350]', '["pointspring_master","mail.channel",351]', '["pointspring_master","mail.channel",352]', '["pointspring_master","mail.channel",354]', '["pointspring_master","mail.channel",355]', '["pointspring_master","mail.channel",356]', '["pointspring_master","mail.channel",357]', '["pointspring_master","mail.channel",358]', '["pointspring_master","mail.channel",362]', '["pointspring_master","mail.channel",363]', '["pointspring_master","mail.channel",364]', '["pointspring_master","mail.channel",365]', '["pointspring_master","mail.channel",366]', '["pointspring_master","mail.channel",367]', '["pointspring_master","mail.channel",368]', '["pointspring_master","mail.channel",370]', '["pointspring_master","mail.channel",371]', '["pointspring_master","mail.channel",372]', '["pointspring_master","mail.channel",373]', '["pointspring_master","mail.channel",374]', '["pointspring_master","mail.channel",375]', '["pointspring_master","mail.channel",377]', '["pointspring_master","mail.channel",378]', '["pointspring_master","mail.channel",379]', '["pointspring_master","mail.channel",380]', '["pointspring_master","mail.channel",381]', '["pointspring_master","mail.channel",382]', '["pointspring_master","mail.channel",383]', '["pointspring_master","mail.channel",384]', '["pointspring_master","mail.channel",385]', '["pointspring_master","mail.channel",386]', '["pointspring_master","mail.channel",387]', '["pointspring_master","mail.channel",388]', '["pointspring_master","mail.channel",389]', '["pointspring_master","mail.channel",390]', '["pointspring_master","mail.channel",391]', '["pointspring_master","mail.channel",392]', '["pointspring_master","mail.channel",393]', '["pointspring_master","mail.channel",394]', '["pointspring_master","mail.channel",395]', '["pointspring_master","mail.channel",396]', '["pointspring_master","mail.channel",397]', '["pointspring_master","mail.channel",398]', '["pointspring_master","mail.channel",399]', '["pointspring_master","mail.channel",400]', '["pointspring_master","mail.channel",401]', '["pointspring_master","mail.channel",402]', '["pointspring_master","mail.channel",403]', '["pointspring_master","mail.channel",404]', '["pointspring_master","mail.channel",405]', '["pointspring_master","mail.channel",406]', '["pointspring_master","mail.channel",407]', '["pointspring_master","mail.channel",408]', '["pointspring_master","mail.channel",409]', '["pointspring_master","mail.channel",410]', '["pointspring_master","mail.channel",411]', '["pointspring_master","mail.channel",412]', '["pointspring_master","mail.channel",413]', '["pointspring_master","mail.channel",414]', '["pointspring_master","mail.channel",415]', '["pointspring_master","mail.channel",418]', '["pointspring_master","mail.channel",423]', '["pointspring_master","mail.channel",426]', '["pointspring_master","mail.channel",427]', '["pointspring_master","mail.channel",428]', '["pointspring_master","mail.channel",429]', '["pointspring_master","mail.channel",434]', '["pointspring_master","mail.channel",456]', '["pointspring_master","mail.channel",462]', '["pointspring_master","mail.channel",467]', '["pointspring_master","mail.channel",474]', '["pointspring_master","mail.channel",477]', '["pointspring_master","mail.channel",478]', '["pointspring_master","mail.channel",481]', '["pointspring_master","mail.channel",486]', '["pointspring_master","mail.channel",510]', '["pointspring_master","res.partner",14]', '["pointspring_master","ir.needaction",14]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 16:26:22 Duration: 183ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 02:55:56') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_11"', '["pointspring_master","calendar.alarm",14]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",16]', '["pointspring_master","mail.channel",348]', '["pointspring_master","mail.channel",349]', '["pointspring_master","mail.channel",350]', '["pointspring_master","mail.channel",351]', '["pointspring_master","mail.channel",352]', '["pointspring_master","mail.channel",354]', '["pointspring_master","mail.channel",355]', '["pointspring_master","mail.channel",356]', '["pointspring_master","mail.channel",357]', '["pointspring_master","mail.channel",358]', '["pointspring_master","mail.channel",362]', '["pointspring_master","mail.channel",363]', '["pointspring_master","mail.channel",364]', '["pointspring_master","mail.channel",365]', '["pointspring_master","mail.channel",366]', '["pointspring_master","mail.channel",367]', '["pointspring_master","mail.channel",368]', '["pointspring_master","mail.channel",370]', '["pointspring_master","mail.channel",371]', '["pointspring_master","mail.channel",372]', '["pointspring_master","mail.channel",373]', '["pointspring_master","mail.channel",374]', '["pointspring_master","mail.channel",375]', '["pointspring_master","mail.channel",377]', '["pointspring_master","mail.channel",378]', '["pointspring_master","mail.channel",379]', '["pointspring_master","mail.channel",380]', '["pointspring_master","mail.channel",381]', '["pointspring_master","mail.channel",382]', '["pointspring_master","mail.channel",383]', '["pointspring_master","mail.channel",384]', '["pointspring_master","mail.channel",385]', '["pointspring_master","mail.channel",386]', '["pointspring_master","mail.channel",387]', '["pointspring_master","mail.channel",388]', '["pointspring_master","mail.channel",389]', '["pointspring_master","mail.channel",390]', '["pointspring_master","mail.channel",391]', '["pointspring_master","mail.channel",392]', '["pointspring_master","mail.channel",393]', '["pointspring_master","mail.channel",394]', '["pointspring_master","mail.channel",395]', '["pointspring_master","mail.channel",396]', '["pointspring_master","mail.channel",397]', '["pointspring_master","mail.channel",398]', '["pointspring_master","mail.channel",399]', '["pointspring_master","mail.channel",400]', '["pointspring_master","mail.channel",401]', '["pointspring_master","mail.channel",402]', '["pointspring_master","mail.channel",403]', '["pointspring_master","mail.channel",404]', '["pointspring_master","mail.channel",405]', '["pointspring_master","mail.channel",406]', '["pointspring_master","mail.channel",407]', '["pointspring_master","mail.channel",408]', '["pointspring_master","mail.channel",409]', '["pointspring_master","mail.channel",410]', '["pointspring_master","mail.channel",411]', '["pointspring_master","mail.channel",412]', '["pointspring_master","mail.channel",413]', '["pointspring_master","mail.channel",414]', '["pointspring_master","mail.channel",415]', '["pointspring_master","mail.channel",418]', '["pointspring_master","mail.channel",423]', '["pointspring_master","mail.channel",426]', '["pointspring_master","mail.channel",427]', '["pointspring_master","mail.channel",428]', '["pointspring_master","mail.channel",429]', '["pointspring_master","mail.channel",434]', '["pointspring_master","mail.channel",456]', '["pointspring_master","mail.channel",462]', '["pointspring_master","mail.channel",467]', '["pointspring_master","mail.channel",474]', '["pointspring_master","mail.channel",477]', '["pointspring_master","mail.channel",478]', '["pointspring_master","mail.channel",481]', '["pointspring_master","mail.channel",486]', '["pointspring_master","mail.channel",510]', '["pointspring_master","res.partner",14]', '["pointspring_master","ir.needaction",14]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 02:56:46 Duration: 175ms
9 14s17ms 1 14s17ms 14s17ms 14s17ms 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 Jun 11 09 1 14s17ms 14s17ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-06-11 09:08:28 Duration: 14s17ms
10 13s365ms 1 13s365ms 13s365ms 13s365ms 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) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 11 09 1 13s365ms 13s365ms -
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) TO stdout;
Date: 2023-06-11 09:00:23 Duration: 13s365ms
11 10s331ms 42 242ms 251ms 245ms 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 #11
Day Hour Count Duration Avg duration Jun 11 02 6 1s475ms 245ms 03 6 1s468ms 244ms 04 3 736ms 245ms 08 3 736ms 245ms 10 3 742ms 247ms 15 3 742ms 247ms 17 3 748ms 249ms 18 9 2s213ms 245ms 19 3 731ms 243ms 21 3 735ms 245ms -
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-06-11 17:30:32 Duration: 251ms
-
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-06-11 10:05:16 Duration: 250ms
-
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-06-11 15:44:38 Duration: 250ms
12 9s144ms 1 9s144ms 9s144ms 9s144ms 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 Jun 11 09 1 9s144ms 9s144ms -
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-06-11 09:00:37 Duration: 9s144ms
13 8s170ms 33 240ms 312ms 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" = ? 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 Jun 11 02 3 735ms 245ms 09 3 842ms 280ms 12 3 738ms 246ms 13 9 2s206ms 245ms 15 3 736ms 245ms 17 3 735ms 245ms 18 3 725ms 241ms 20 3 723ms 241ms 23 3 727ms 242ms -
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-06-11 09:00:15 Duration: 312ms
-
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-06-11 09:00:15 Duration: 267ms
-
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-06-11 09:00:15 Duration: 262ms
14 8s8ms 45 175ms 196ms 177ms 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 Jun 11 00 12 2s130ms 177ms 04 3 528ms 176ms 06 9 1s590ms 176ms 07 3 529ms 176ms 08 3 534ms 178ms 13 3 533ms 177ms 14 3 553ms 184ms 17 3 528ms 176ms 18 3 534ms 178ms 20 3 545ms 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-06-11 14:15:15 Duration: 196ms
-
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-06-11 20:44:00 Duration: 187ms
-
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-06-11 00:35:17 Duration: 180ms
15 7s749ms 10 738ms 816ms 774ms 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 #15
Day Hour Count Duration Avg duration Jun 11 08 6 4s591ms 765ms 09 4 3s158ms 789ms -
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 = 3660 and ill.method not in (8, 7);
Date: 2023-06-11 09:02:13 Duration: 816ms
-
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 = 3666 and ill.method not in (8, 7);
Date: 2023-06-11 09:05:32 Duration: 807ms
-
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 = 3664 and ill.method not in (8, 7);
Date: 2023-06-11 08:56:21 Duration: 798ms
16 6s76ms 10 591ms 629ms 607ms 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 #16
Day Hour Count Duration Avg duration Jun 11 08 6 3s623ms 603ms 09 4 2s452ms 613ms -
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 = 3666 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 09:05:31 Duration: 629ms
-
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 = 3667 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:52:39 Duration: 619ms
-
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 = 3661 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:55:01 Duration: 617ms
17 5s639ms 1 5s639ms 5s639ms 5s639ms 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) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 09 1 5s639ms 5s639ms -
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) TO stdout;
Date: 2023-06-11 09:00:10 Duration: 5s639ms
18 5s380ms 30 176ms 183ms 179ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 02 6 1s71ms 178ms 03 3 547ms 182ms 04 3 540ms 180ms 05 6 1s71ms 178ms 08 3 545ms 181ms 09 3 533ms 177ms 15 3 535ms 178ms 19 3 534ms 178ms -
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-06-11 03:00:05 Duration: 183ms
-
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-06-11 04:48:26 Duration: 183ms
-
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-06-11 03:00:04 Duration: 182ms
19 4s916ms 10 477ms 542ms 491ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 11 08 6 2s958ms 493ms 09 4 1s958ms 489ms -
select count(id) from item_list_line where item_demand_plan_id = 3667;
Date: 2023-06-11 08:52:39 Duration: 542ms
-
select count(id) from item_list_line where item_demand_plan_id = 3662;
Date: 2023-06-11 09:04:14 Duration: 504ms
-
select count(id) from item_list_line where item_demand_plan_id = 3669;
Date: 2023-06-11 09:00:11 Duration: 494ms
20 4s570ms 1 4s570ms 4s570ms 4s570ms 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 Jun 11 09 1 4s570ms 4s570ms -
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-06-11 09:07:08 Duration: 4s570ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 1,480 4m30s 179ms 248ms 182ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jun 11 02 291 52s947ms 181ms 03 520 1m35s 183ms 17 153 27s854ms 182ms 18 515 1m34s 183ms 19 1 181ms 181ms -
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-44261d3/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 03:02:50 Duration: 248ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-755b6ac/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 03:36:02 Duration: 248ms
-
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_frontend_lazy.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-44261d3/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-06-11 17:49:33 Duration: 239ms
2 356 45s202ms 121ms 162ms 126ms 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 Jun 11 08 187 23s568ms 126ms 09 169 21s633ms 128ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 45 and pwi.inventory_vendor_id = 3098 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:01:35 Duration: 162ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 35 and pwi.inventory_vendor_id = 2952 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:03:24 Duration: 158ms
-
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 = 41 and pwi.inventory_vendor_id = 2915 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 = 41 and pwi.inventory_vendor_id = 2915 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 = 41 and pwi.inventory_vendor_id = 2915 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-06-11 09:06:26 Duration: 157ms
3 119 17s234ms 124ms 185ms 144ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jun 11 00 4 578ms 144ms 01 3 423ms 141ms 02 7 1s47ms 149ms 04 9 1s370ms 152ms 05 4 521ms 130ms 06 7 926ms 132ms 07 5 738ms 147ms 08 9 1s337ms 148ms 09 9 1s276ms 141ms 12 4 626ms 156ms 14 4 594ms 148ms 15 12 1s678ms 139ms 16 5 807ms 161ms 17 6 890ms 148ms 18 3 414ms 138ms 20 4 586ms 146ms 21 8 1s164ms 145ms 22 8 1s87ms 135ms 23 8 1s164ms 145ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 04:15:14') AND ("bus_bus"."channel" in ('["pointspring_master","calendar.alarm",19535]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",241]', '["pointspring_master","mail.channel",435]', '["pointspring_master","mail.channel",452]', '["pointspring_master","mail.channel",460]', '["pointspring_master","mail.channel",471]', '["pointspring_master","res.partner",19535]', '["pointspring_master","ir.needaction",19535]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 04:16:04 Duration: 185ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 16:25:32') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_11"', '["pointspring_master","calendar.alarm",14]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",16]', '["pointspring_master","mail.channel",348]', '["pointspring_master","mail.channel",349]', '["pointspring_master","mail.channel",350]', '["pointspring_master","mail.channel",351]', '["pointspring_master","mail.channel",352]', '["pointspring_master","mail.channel",354]', '["pointspring_master","mail.channel",355]', '["pointspring_master","mail.channel",356]', '["pointspring_master","mail.channel",357]', '["pointspring_master","mail.channel",358]', '["pointspring_master","mail.channel",362]', '["pointspring_master","mail.channel",363]', '["pointspring_master","mail.channel",364]', '["pointspring_master","mail.channel",365]', '["pointspring_master","mail.channel",366]', '["pointspring_master","mail.channel",367]', '["pointspring_master","mail.channel",368]', '["pointspring_master","mail.channel",370]', '["pointspring_master","mail.channel",371]', '["pointspring_master","mail.channel",372]', '["pointspring_master","mail.channel",373]', '["pointspring_master","mail.channel",374]', '["pointspring_master","mail.channel",375]', '["pointspring_master","mail.channel",377]', '["pointspring_master","mail.channel",378]', '["pointspring_master","mail.channel",379]', '["pointspring_master","mail.channel",380]', '["pointspring_master","mail.channel",381]', '["pointspring_master","mail.channel",382]', '["pointspring_master","mail.channel",383]', '["pointspring_master","mail.channel",384]', '["pointspring_master","mail.channel",385]', '["pointspring_master","mail.channel",386]', '["pointspring_master","mail.channel",387]', '["pointspring_master","mail.channel",388]', '["pointspring_master","mail.channel",389]', '["pointspring_master","mail.channel",390]', '["pointspring_master","mail.channel",391]', '["pointspring_master","mail.channel",392]', '["pointspring_master","mail.channel",393]', '["pointspring_master","mail.channel",394]', '["pointspring_master","mail.channel",395]', '["pointspring_master","mail.channel",396]', '["pointspring_master","mail.channel",397]', '["pointspring_master","mail.channel",398]', '["pointspring_master","mail.channel",399]', '["pointspring_master","mail.channel",400]', '["pointspring_master","mail.channel",401]', '["pointspring_master","mail.channel",402]', '["pointspring_master","mail.channel",403]', '["pointspring_master","mail.channel",404]', '["pointspring_master","mail.channel",405]', '["pointspring_master","mail.channel",406]', '["pointspring_master","mail.channel",407]', '["pointspring_master","mail.channel",408]', '["pointspring_master","mail.channel",409]', '["pointspring_master","mail.channel",410]', '["pointspring_master","mail.channel",411]', '["pointspring_master","mail.channel",412]', '["pointspring_master","mail.channel",413]', '["pointspring_master","mail.channel",414]', '["pointspring_master","mail.channel",415]', '["pointspring_master","mail.channel",418]', '["pointspring_master","mail.channel",423]', '["pointspring_master","mail.channel",426]', '["pointspring_master","mail.channel",427]', '["pointspring_master","mail.channel",428]', '["pointspring_master","mail.channel",429]', '["pointspring_master","mail.channel",434]', '["pointspring_master","mail.channel",456]', '["pointspring_master","mail.channel",462]', '["pointspring_master","mail.channel",467]', '["pointspring_master","mail.channel",474]', '["pointspring_master","mail.channel",477]', '["pointspring_master","mail.channel",478]', '["pointspring_master","mail.channel",481]', '["pointspring_master","mail.channel",486]', '["pointspring_master","mail.channel",510]', '["pointspring_master","res.partner",14]', '["pointspring_master","ir.needaction",14]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 16:26:22 Duration: 183ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-06-11 02:55:56') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_11"', '["pointspring_master","calendar.alarm",14]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",16]', '["pointspring_master","mail.channel",348]', '["pointspring_master","mail.channel",349]', '["pointspring_master","mail.channel",350]', '["pointspring_master","mail.channel",351]', '["pointspring_master","mail.channel",352]', '["pointspring_master","mail.channel",354]', '["pointspring_master","mail.channel",355]', '["pointspring_master","mail.channel",356]', '["pointspring_master","mail.channel",357]', '["pointspring_master","mail.channel",358]', '["pointspring_master","mail.channel",362]', '["pointspring_master","mail.channel",363]', '["pointspring_master","mail.channel",364]', '["pointspring_master","mail.channel",365]', '["pointspring_master","mail.channel",366]', '["pointspring_master","mail.channel",367]', '["pointspring_master","mail.channel",368]', '["pointspring_master","mail.channel",370]', '["pointspring_master","mail.channel",371]', '["pointspring_master","mail.channel",372]', '["pointspring_master","mail.channel",373]', '["pointspring_master","mail.channel",374]', '["pointspring_master","mail.channel",375]', '["pointspring_master","mail.channel",377]', '["pointspring_master","mail.channel",378]', '["pointspring_master","mail.channel",379]', '["pointspring_master","mail.channel",380]', '["pointspring_master","mail.channel",381]', '["pointspring_master","mail.channel",382]', '["pointspring_master","mail.channel",383]', '["pointspring_master","mail.channel",384]', '["pointspring_master","mail.channel",385]', '["pointspring_master","mail.channel",386]', '["pointspring_master","mail.channel",387]', '["pointspring_master","mail.channel",388]', '["pointspring_master","mail.channel",389]', '["pointspring_master","mail.channel",390]', '["pointspring_master","mail.channel",391]', '["pointspring_master","mail.channel",392]', '["pointspring_master","mail.channel",393]', '["pointspring_master","mail.channel",394]', '["pointspring_master","mail.channel",395]', '["pointspring_master","mail.channel",396]', '["pointspring_master","mail.channel",397]', '["pointspring_master","mail.channel",398]', '["pointspring_master","mail.channel",399]', '["pointspring_master","mail.channel",400]', '["pointspring_master","mail.channel",401]', '["pointspring_master","mail.channel",402]', '["pointspring_master","mail.channel",403]', '["pointspring_master","mail.channel",404]', '["pointspring_master","mail.channel",405]', '["pointspring_master","mail.channel",406]', '["pointspring_master","mail.channel",407]', '["pointspring_master","mail.channel",408]', '["pointspring_master","mail.channel",409]', '["pointspring_master","mail.channel",410]', '["pointspring_master","mail.channel",411]', '["pointspring_master","mail.channel",412]', '["pointspring_master","mail.channel",413]', '["pointspring_master","mail.channel",414]', '["pointspring_master","mail.channel",415]', '["pointspring_master","mail.channel",418]', '["pointspring_master","mail.channel",423]', '["pointspring_master","mail.channel",426]', '["pointspring_master","mail.channel",427]', '["pointspring_master","mail.channel",428]', '["pointspring_master","mail.channel",429]', '["pointspring_master","mail.channel",434]', '["pointspring_master","mail.channel",456]', '["pointspring_master","mail.channel",462]', '["pointspring_master","mail.channel",467]', '["pointspring_master","mail.channel",474]', '["pointspring_master","mail.channel",477]', '["pointspring_master","mail.channel",478]', '["pointspring_master","mail.channel",481]', '["pointspring_master","mail.channel",486]', '["pointspring_master","mail.channel",510]', '["pointspring_master","res.partner",14]', '["pointspring_master","ir.needaction",14]'))) ORDER BY "bus_bus"."id";
Date: 2023-06-11 02:56:46 Duration: 175ms
4 45 8s8ms 175ms 196ms 177ms 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 #4
Day Hour Count Duration Avg duration Jun 11 00 12 2s130ms 177ms 04 3 528ms 176ms 06 9 1s590ms 176ms 07 3 529ms 176ms 08 3 534ms 178ms 13 3 533ms 177ms 14 3 553ms 184ms 17 3 528ms 176ms 18 3 534ms 178ms 20 3 545ms 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-06-11 14:15:15 Duration: 196ms
-
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-06-11 20:44:00 Duration: 187ms
-
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-06-11 00:35:17 Duration: 180ms
5 42 10s331ms 242ms 251ms 245ms 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 #5
Day Hour Count Duration Avg duration Jun 11 02 6 1s475ms 245ms 03 6 1s468ms 244ms 04 3 736ms 245ms 08 3 736ms 245ms 10 3 742ms 247ms 15 3 742ms 247ms 17 3 748ms 249ms 18 9 2s213ms 245ms 19 3 731ms 243ms 21 3 735ms 245ms -
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-06-11 17:30:32 Duration: 251ms
-
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-06-11 10:05:16 Duration: 250ms
-
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-06-11 15:44:38 Duration: 250ms
6 33 8s170ms 240ms 312ms 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" = ? 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 #6
Day Hour Count Duration Avg duration Jun 11 02 3 735ms 245ms 09 3 842ms 280ms 12 3 738ms 246ms 13 9 2s206ms 245ms 15 3 736ms 245ms 17 3 735ms 245ms 18 3 725ms 241ms 20 3 723ms 241ms 23 3 727ms 242ms -
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-06-11 09:00:15 Duration: 312ms
-
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-06-11 09:00:15 Duration: 267ms
-
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-06-11 09:00:15 Duration: 262ms
7 30 5s380ms 176ms 183ms 179ms 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 #7
Day Hour Count Duration Avg duration Jun 11 02 6 1s71ms 178ms 03 3 547ms 182ms 04 3 540ms 180ms 05 6 1s71ms 178ms 08 3 545ms 181ms 09 3 533ms 177ms 15 3 535ms 178ms 19 3 534ms 178ms -
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-06-11 03:00:05 Duration: 183ms
-
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-06-11 04:48:26 Duration: 183ms
-
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-06-11 03:00:04 Duration: 182ms
8 10 7s749ms 738ms 816ms 774ms 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 #8
Day Hour Count Duration Avg duration Jun 11 08 6 4s591ms 765ms 09 4 3s158ms 789ms -
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 = 3660 and ill.method not in (8, 7);
Date: 2023-06-11 09:02:13 Duration: 816ms
-
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 = 3666 and ill.method not in (8, 7);
Date: 2023-06-11 09:05:32 Duration: 807ms
-
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 = 3664 and ill.method not in (8, 7);
Date: 2023-06-11 08:56:21 Duration: 798ms
9 10 6s76ms 591ms 629ms 607ms 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 #9
Day Hour Count Duration Avg duration Jun 11 08 6 3s623ms 603ms 09 4 2s452ms 613ms -
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 = 3666 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 09:05:31 Duration: 629ms
-
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 = 3667 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:52:39 Duration: 619ms
-
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 = 3661 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:55:01 Duration: 617ms
10 10 4s916ms 477ms 542ms 491ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jun 11 08 6 2s958ms 493ms 09 4 1s958ms 489ms -
select count(id) from item_list_line where item_demand_plan_id = 3667;
Date: 2023-06-11 08:52:39 Duration: 542ms
-
select count(id) from item_list_line where item_demand_plan_id = 3662;
Date: 2023-06-11 09:04:14 Duration: 504ms
-
select count(id) from item_list_line where item_demand_plan_id = 3669;
Date: 2023-06-11 09:00:11 Duration: 494ms
11 3 2s239ms 731ms 773ms 746ms 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"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jun 11 02 3 2s239ms 746ms -
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%566.ct6666%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%566.ct6666%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%566.ct6666%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%566.ct6666%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:42:00 Duration: 773ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%1r12-1097%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1r12-1097%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1r12-1097%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%1r12-1097%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:39:32 Duration: 734ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%566.ct666666%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%566.ct666666%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%566.ct666666%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%566.ct666666%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:41:46 Duration: 731ms
12 3 1s508ms 394ms 578ms 502ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year", "sale_history_line"."selling_branch" AS "selling_branch" from "sale_history_line" left join "res_branch" AS "sale_history_line__selling_branch" on ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" order by "invoice_date:year", "sale_history_line__selling_branch"."id";Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 11 23 3 1s508ms 502ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:17 Duration: 578ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:17 Duration: 536ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:08 Duration: 394ms
13 3 1s289ms 305ms 499ms 429ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year" from "sale_history_line" where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp) order by "invoice_date:year";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 11 23 3 1s289ms 429ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:17 Duration: 499ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:17 Duration: 484ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:08 Duration: 305ms
14 3 832ms 272ms 286ms 277ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" from "sale_history_line" where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?));Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jun 11 23 3 832ms 277ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'));
Date: 2023-06-11 23:40:17 Duration: 286ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'));
Date: 2023-06-11 23:40:17 Duration: 273ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'));
Date: 2023-06-11 23:40:07 Duration: 272ms
15 3 362ms 120ms 121ms 120ms 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"."website_id" in (...)) or "product_template"."website_id" is null)) and ((("product_template"."company_id" in (...)) or "product_template"."company_id" is null) and ((("product_template"."is_published" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and ("product_template"."sale_ok" = true))) order by coalesce("product_template__name"."value", "product_template"."name");Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 11 11 1 120ms 120ms 23 2 241ms 120ms -
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"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-06-11 23:19:23 Duration: 121ms
-
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"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-06-11 11:03:40 Duration: 120ms
-
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"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-06-11 23:19:28 Duration: 120ms
16 2 1s437ms 717ms 720ms 718ms 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"."is_core" is null or "product_template"."is_core" = false) and ((("product_template"."sale_ok" = true) or ("product_template"."purchase_ok" = true)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 11 02 2 1s437ms 718ms -
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"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%334-2087%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%334-2087%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%334-2087%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%334-2087%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:47:30 Duration: 720ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%w01-358-8864%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%w01-358-8864%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%w01-358-8864%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%w01-358-8864%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:34:20 Duration: 717ms
17 2 541ms 247ms 294ms 270ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" from "sale_history_line" where (("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)));Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 23 2 541ms 270ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')));
Date: 2023-06-11 23:39:54 Duration: 294ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')));
Date: 2023-06-11 23:40:01 Duration: 247ms
18 2 535ms 249ms 285ms 267ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year" from "sale_history_line" where (("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?))) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp) order by "invoice_date:year";Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 23 2 535ms 267ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'))) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:01 Duration: 285ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'))) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:39:55 Duration: 249ms
19 2 497ms 247ms 250ms 248ms select "sale_history_line".id from "sale_history_line" where ("sale_history_line"."selling_branch" in (...)) order by "sale_history_line"."invoice_date" desc limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 11 23 2 497ms 248ms -
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."selling_branch" in (44)) ORDER BY "sale_history_line"."invoice_date" DESC LIMIT 80;
Date: 2023-06-11 23:39:17 Duration: 250ms
-
SELECT "sale_history_line".id FROM "sale_history_line" WHERE ("sale_history_line"."selling_branch" in (44)) ORDER BY "sale_history_line"."invoice_date" DESC LIMIT 80;
Date: 2023-06-11 23:39:29 Duration: 247ms
20 2 433ms 208ms 225ms 216ms select count(?) from "sale_history_line" where ("sale_history_line"."selling_branch" in (...));Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 11 23 2 433ms 216ms -
SELECT count(1) FROM "sale_history_line" WHERE ("sale_history_line"."selling_branch" in (44));
Date: 2023-06-11 23:39:29 Duration: 225ms
-
SELECT count(1) FROM "sale_history_line" WHERE ("sale_history_line"."selling_branch" in (44));
Date: 2023-06-11 23:39:18 Duration: 208ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m42s 3m42s 3m42s 1 3m42s 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 Jun 11 09 1 3m42s 3m42s -
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-06-11 09:06:57 Duration: 3m42s
2 1m9s 1m9s 1m9s 1 1m9s 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 Jun 11 09 1 1m9s 1m9s -
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-06-11 09:02:02 Duration: 1m9s
3 1m8s 1m8s 1m8s 1 1m8s 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 Jun 11 09 1 1m8s 1m8s -
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-06-11 09:03:14 Duration: 1m8s
4 22s987ms 22s987ms 22s987ms 1 22s987ms 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 Jun 11 09 1 22s987ms 22s987ms -
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-06-11 09:08:51 Duration: 22s987ms
5 20s930ms 20s930ms 20s930ms 1 20s930ms 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) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jun 11 09 1 20s930ms 20s930ms -
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) TO stdout;
Date: 2023-06-11 09:07:55 Duration: 20s930ms
6 14s17ms 14s17ms 14s17ms 1 14s17ms 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 Jun 11 09 1 14s17ms 14s17ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-06-11 09:08:28 Duration: 14s17ms
7 13s365ms 13s365ms 13s365ms 1 13s365ms 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) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jun 11 09 1 13s365ms 13s365ms -
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) TO stdout;
Date: 2023-06-11 09:00:23 Duration: 13s365ms
8 9s144ms 9s144ms 9s144ms 1 9s144ms 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 Jun 11 09 1 9s144ms 9s144ms -
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-06-11 09:00:37 Duration: 9s144ms
9 5s639ms 5s639ms 5s639ms 1 5s639ms 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) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jun 11 09 1 5s639ms 5s639ms -
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) TO stdout;
Date: 2023-06-11 09:00:10 Duration: 5s639ms
10 4s570ms 4s570ms 4s570ms 1 4s570ms 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 #10
Day Hour Count Duration Avg duration Jun 11 09 1 4s570ms 4s570ms -
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-06-11 09:07:08 Duration: 4s570ms
11 738ms 816ms 774ms 10 7s749ms 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 #11
Day Hour Count Duration Avg duration Jun 11 08 6 4s591ms 765ms 09 4 3s158ms 789ms -
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 = 3660 and ill.method not in (8, 7);
Date: 2023-06-11 09:02:13 Duration: 816ms
-
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 = 3666 and ill.method not in (8, 7);
Date: 2023-06-11 09:05:32 Duration: 807ms
-
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 = 3664 and ill.method not in (8, 7);
Date: 2023-06-11 08:56:21 Duration: 798ms
12 731ms 773ms 746ms 3 2s239ms 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"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jun 11 02 3 2s239ms 746ms -
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%566.ct6666%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%566.ct6666%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%566.ct6666%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%566.ct6666%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:42:00 Duration: 773ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%1r12-1097%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%1r12-1097%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%1r12-1097%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%1r12-1097%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:39:32 Duration: 734ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%566.ct666666%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%566.ct666666%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%566.ct666666%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%566.ct666666%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:41:46 Duration: 731ms
13 717ms 720ms 718ms 2 1s437ms 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"."is_core" is null or "product_template"."is_core" = false) and ((("product_template"."sale_ok" = true) or ("product_template"."purchase_ok" = true)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jun 11 02 2 1s437ms 718ms -
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"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%334-2087%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%334-2087%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%334-2087%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%334-2087%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:47:30 Duration: 720ms
-
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"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%w01-358-8864%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%w01-358-8864%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%w01-358-8864%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%w01-358-8864%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-06-11 02:34:20 Duration: 717ms
14 591ms 629ms 607ms 10 6s76ms 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 Jun 11 08 6 3s623ms 603ms 09 4 2s452ms 613ms -
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 = 3666 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 09:05:31 Duration: 629ms
-
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 = 3667 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:52:39 Duration: 619ms
-
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 = 3661 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-06-11 08:55:01 Duration: 617ms
15 394ms 578ms 502ms 3 1s508ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year", "sale_history_line"."selling_branch" AS "selling_branch" from "sale_history_line" left join "res_branch" AS "sale_history_line__selling_branch" on ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" order by "invoice_date:year", "sale_history_line__selling_branch"."id";Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jun 11 23 3 1s508ms 502ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:17 Duration: 578ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:17 Duration: 536ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year", "sale_history_line"."selling_branch" as "selling_branch" FROM "sale_history_line" LEFT JOIN "res_branch" AS "sale_history_line__selling_branch" ON ("sale_history_line"."selling_branch" = "sale_history_line__selling_branch"."id") WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp), "sale_history_line"."selling_branch", "sale_history_line__selling_branch"."id" ORDER BY "invoice_date:year", "sale_history_line__selling_branch"."id";
Date: 2023-06-11 23:40:08 Duration: 394ms
16 477ms 542ms 491ms 10 4s916ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jun 11 08 6 2s958ms 493ms 09 4 1s958ms 489ms -
select count(id) from item_list_line where item_demand_plan_id = 3667;
Date: 2023-06-11 08:52:39 Duration: 542ms
-
select count(id) from item_list_line where item_demand_plan_id = 3662;
Date: 2023-06-11 09:04:14 Duration: 504ms
-
select count(id) from item_list_line where item_demand_plan_id = 3669;
Date: 2023-06-11 09:00:11 Duration: 494ms
17 305ms 499ms 429ms 3 1s289ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year" from "sale_history_line" where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp) order by "invoice_date:year";Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jun 11 23 3 1s289ms 429ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:17 Duration: 499ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:17 Duration: 484ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:08 Duration: 305ms
18 272ms 286ms 277ms 3 832ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" from "sale_history_line" where (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?));Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jun 11 23 3 832ms 277ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'));
Date: 2023-06-11 23:40:17 Duration: 286ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'));
Date: 2023-06-11 23:40:17 Duration: 273ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'));
Date: 2023-06-11 23:40:07 Duration: 272ms
19 247ms 294ms 270ms 2 541ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" from "sale_history_line" where (("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?)));Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jun 11 23 2 541ms 270ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')));
Date: 2023-06-11 23:39:54 Duration: 294ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31')));
Date: 2023-06-11 23:40:01 Duration: 247ms
20 249ms 285ms 267ms 2 535ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:year" from "sale_history_line" where (("sale_history_line"."selling_branch" in (...)) and (("sale_history_line"."invoice_date" >= ?) and ("sale_history_line"."invoice_date" <= ?))) group by date_trunc(?, "sale_history_line"."invoice_date"::timestamp) order by "invoice_date:year";Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jun 11 23 2 535ms 267ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'))) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:40:01 Duration: 285ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "__count", sum("sale_history_line"."price_subtotal") AS "price_subtotal", date_trunc('year', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:year" FROM "sale_history_line" WHERE (("sale_history_line"."selling_branch" in (44)) AND (("sale_history_line"."invoice_date" >= '2023-01-01') AND ("sale_history_line"."invoice_date" <= '2023-12-31'))) GROUP BY date_trunc('year', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:year";
Date: 2023-06-11 23:39:55 Duration: 249ms
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
- 4,746 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 1248 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 357 Max number of times the same event was reported
- 1,248 Total events found
Rank Times reported Error 1 357 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Jun 11 00 10 01 10 02 9 03 9 04 10 05 9 06 13 07 22 08 57 09 54 10 12 11 11 12 17 13 12 14 12 15 10 16 9 17 9 18 11 19 9 20 10 21 11 22 10 23 11 - 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=77 FOR UPDATE NOWAIT
Date: 2023-06-11 00:30:06
2 325 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #2
Day Hour Count Jun 11 00 10 01 10 02 13 03 10 04 10 05 10 06 10 07 10 08 10 09 10 10 90 11 10 12 10 13 10 14 10 15 10 16 10 17 10 18 12 19 10 20 10 21 10 22 10 23 10 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT f.name, d.json_value FROM ir_default d JOIN ir_model_fields f ON d.field_id=f.id WHERE f.model='edi.810.scheduler.details' AND (d.user_id IS NULL OR d.user_id=1) AND (d.company_id IS NULL OR d.company_id=1) AND d.condition IS NULL ORDER BY d.user_id, d.company_id, d.id
Date: 2023-06-11 00:05:08
3 300 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #3
Day Hour Count Jun 11 02 30 03 85 06 1 07 2 11 1 12 4 14 3 16 4 17 40 18 117 19 1 21 7 22 3 23 2 - ERROR: could not serialize access due to concurrent update
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (2927195) FOR NO KEY UPDATE SKIP LOCKED )
Date: 2023-06-11 02:27:50
4 265 ERROR: column "..." does not exist
Times Reported Most Frequent Error / Event #4
Day Hour Count Jun 11 00 11 01 11 02 11 03 11 04 11 05 11 06 11 07 11 08 11 09 11 10 12 11 11 12 11 13 11 14 11 15 11 16 11 17 11 18 11 19 11 20 11 21 11 22 11 23 11 - ERROR: column purchase_order.internalpicking_count does not exist at character 2066
Statement: SELECT "purchase_order"."id" as "id", "purchase_order"."name" as "name", "purchase_order"."priority" as "priority", "purchase_order"."partner_ref" as "partner_ref", "purchase_order"."date_order" as "date_order", "purchase_order"."date_approve" as "date_approve", "purchase_order"."dest_address_id" as "dest_address_id", "purchase_order"."currency_id" as "currency_id", "purchase_order"."state" as "state", "purchase_order"."notes" as "notes", "purchase_order"."invoice_count" as "invoice_count", "purchase_order"."invoice_status" as "invoice_status", "purchase_order"."date_planned" as "date_planned", "purchase_order"."date_calendar_start" as "date_calendar_start", "purchase_order"."amount_untaxed" as "amount_untaxed", "purchase_order"."amount_tax" as "amount_tax", "purchase_order"."amount_total" as "amount_total", "purchase_order"."fiscal_position_id" as "fiscal_position_id", "purchase_order"."payment_term_id" as "payment_term_id", "purchase_order"."user_id" as "user_id", "purchase_order"."company_id" as "company_id", "purchase_order"."currency_rate" as "currency_rate", "purchase_order"."mail_reminder_confirmed" as "mail_reminder_confirmed", "purchase_order"."mail_reception_confirmed" as "mail_reception_confirmed", "purchase_order"."requisition_id" as "requisition_id", "purchase_order"."incoterm_id" as "incoterm_id", "purchase_order"."picking_count" as "picking_count", "purchase_order"."picking_type_id" as "picking_type_id", "purchase_order"."group_id" as "group_id", "purchase_order"."effective_date" as "effective_date", "purchase_order"."branch_id" as "branch_id", "purchase_order"."purchase_part_id" as "purchase_part_id", "purchase_order"."purchase_product_qty" as "purchase_product_qty", "purchase_order"."purchase_action" as "purchase_action", "purchase_order"."sent_via" as "sent_via", "purchase_order"."comment" as "comment", "purchase_order"."ship_via" as "ship_via", "purchase_order"."type_of_purchase" as "type_of_purchase", "purchase_order"."to_check_negative" as "to_check_negative", "purchase_order"."shipment_id" as "shipment_id", "purchase_order"."internalpicking_count" as "internalpicking_count", "purchase_order"."sh_repair_order_id" as "sh_repair_order_id", "purchase_order"."sh_sale_order_id" as "sh_sale_order_id", "purchase_order"."rtv_picking_type_id" as "rtv_picking_type_id", "purchase_order"."purchase_type" as "purchase_type", "purchase_order"."linked_purchase_id" as "linked_purchase_id", "purchase_order"."special_instruction" as "special_instruction", "purchase_order"."origin" as "origin", "purchase_order"."terms_condition" as "terms_condition", "purchase_order"."is_rtv_order" as "is_rtv_order", "purchase_order"."rtv_purchase_id" as "rtv_purchase_id", "purchase_order"."rtv_picking_count" as "rtv_picking_count", "purchase_order"."order_priority" as "order_priority", "purchase_order"."partner_id" as "partner_id", "purchase_order"."return_count" as "return_count", "purchase_order"."return_count_original" as "return_count_original", "purchase_order"."vendor_supply_plan_id" as "vendor_supply_plan_id", "purchase_order"."method_of_payment" as "method_of_payment", "purchase_order"."reference_no_qualifier" as "reference_no_qualifier", "purchase_order"."reference_no" as "reference_no", "purchase_order"."legacy_po_num" as "legacy_po_num", "purchase_order"."ref_for_997" as "ref_for_997", "purchase_order"."not_received_855" as "not_received_855", "purchase_order"."not_received_856" as "not_received_856", "purchase_order"."not_received_997" as "not_received_997", "purchase_order"."not_received_810" as "not_received_810", "purchase_order"."expects_855" as "expects_855", "purchase_order"."expects_856" as "expects_856", "purchase_order"."expects_997" as "expects_997", "purchase_order"."expects_810" as "expects_810", "purchase_order"."dont_send_850" as "dont_send_850", "purchase_order"."message_main_attachment_id" as "message_main_attachment_id", "purchase_order"."access_token" as "access_token", "purchase_order"."create_uid" as "create_uid", "purchase_order"."create_date" as "create_date", "purchase_order"."write_uid" as "write_uid", "purchase_order"."write_date" as "write_date" FROM "purchase_order" WHERE "purchase_order".id IN (5946, 72, 6161, 6431, 6365, 2412, 6447, 6470, 6476, 6300, 5988, 6848, 6609, 6255, 4055, 6714, 6913, 7078, 4782, 7070, 7135, 5700, 7183, 7189, 7160, 7421, 4347, 4346, 7267, 7403, 7305, 5573, 7412, 7217, 6419, 7432, 478, 2179)
Date: 2023-06-11 00:05:08
5 1 ERROR: operator does not exist: integer = boolean
Times Reported Most Frequent Error / Event #5
Day Hour Count Jun 11 07 1 - ERROR: operator does not exist: integer = boolean at character 98
Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Statement: (select destination_branch_id from forecast_replenishment where product_tmpl_id=false and source_branch_id = 39 order by id desc limit 1) UNION ALL (select destination_branch_id from forecast_replenishment where product_id=false and source_branch_id = 39 order by id desc limit 1)Date: 2023-06-11 07:51:01