pgBadger-
Global information
- Generated on Mon Dec 19 23:50:22 2022
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 49,337 log entries in 21s
- Log start from 2022-12-18 00:01:50 to 2022-12-18 23:59:53
-
Overview
Global Stats
- 98 Number of unique normalized queries
- 1,241 Number of queries
- 7m17s Total query duration
- 2022-12-18 00:39:28 First query
- 2022-12-18 23:10:40 Last query
- 7 queries/s at 2022-12-18 16:22:12 Query peak
- 7m17s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 7m17s Execute total duration
- 15,558 Number of events
- 5 Number of unique normalized events
- 9,604 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
- 1,241 Average queries per session
- 7m17s 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
- 7 queries/s Query Peak
- 2022-12-18 16:22:12 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2022-12-18 16:22:12 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2022-12-18 09:00:40 Date
Queries duration
Key values
- 7m17s 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) Dec 18 00 1 0ms 377ms 377ms 0ms 0ms 377ms 01 0 0ms 0ms 0ms 0ms 0ms 0ms 02 0 0ms 0ms 0ms 0ms 0ms 0ms 03 13 0ms 1s211ms 600ms 0ms 540ms 5s163ms 04 1 0ms 373ms 373ms 0ms 0ms 373ms 05 1 0ms 354ms 354ms 0ms 0ms 354ms 06 0 0ms 0ms 0ms 0ms 0ms 0ms 07 0 0ms 0ms 0ms 0ms 0ms 0ms 08 30 0ms 2s38ms 303ms 0ms 397ms 5s598ms 09 47 0ms 20s31ms 2s179ms 0ms 0ms 56s317ms 10 150 0ms 434ms 379ms 0ms 174ms 54s115ms 11 789 0ms 258ms 229ms 8s225ms 10s35ms 16s400ms 12 11 0ms 247ms 227ms 0ms 0ms 1s595ms 13 28 0ms 390ms 217ms 0ms 390ms 3s493ms 14 0 0ms 0ms 0ms 0ms 0ms 0ms 15 6 0ms 681ms 488ms 0ms 666ms 1s340ms 16 16 0ms 1s15ms 420ms 0ms 862ms 4s785ms 17 6 0ms 602ms 429ms 0ms 588ms 602ms 18 23 0ms 636ms 380ms 895ms 1s81ms 1s685ms 19 91 0ms 967ms 479ms 2s208ms 2s407ms 2s893ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 1 0ms 378ms 378ms 0ms 0ms 378ms 22 0 0ms 0ms 0ms 0ms 0ms 0ms 23 27 0ms 367ms 224ms 0ms 0ms 6s53ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 18 00 1 0 377ms 0ms 0ms 0ms 01 0 0 0ms 0ms 0ms 0ms 02 0 0 0ms 0ms 0ms 0ms 03 13 0 600ms 0ms 0ms 2s99ms 04 1 0 373ms 0ms 0ms 0ms 05 1 0 354ms 0ms 0ms 0ms 06 0 0 0ms 0ms 0ms 0ms 07 0 0 0ms 0ms 0ms 0ms 08 30 0 303ms 0ms 0ms 3s117ms 09 1 46 2s179ms 0ms 0ms 45s998ms 10 150 0 379ms 0ms 0ms 2s659ms 11 789 0 229ms 6s690ms 8s225ms 10s93ms 12 11 0 227ms 0ms 0ms 911ms 13 28 0 217ms 0ms 0ms 2s200ms 14 0 0 0ms 0ms 0ms 0ms 15 6 0 488ms 0ms 0ms 925ms 16 16 0 420ms 0ms 0ms 1s75ms 17 6 0 429ms 0ms 0ms 600ms 18 10 0 502ms 0ms 588ms 721ms 19 52 0 515ms 770ms 1s280ms 2s14ms 20 0 0 0ms 0ms 0ms 0ms 21 1 0 378ms 0ms 0ms 0ms 22 0 0 0ms 0ms 0ms 0ms 23 27 0 224ms 0ms 0ms 0ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Dec 18 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 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 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 13 0 0 286ms 0ms 0ms 483ms 19 0 37 2 0 432ms 0ms 493ms 1s393ms 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 Dec 18 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 Dec 18 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 Dec 18 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 Dec 18 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 Dec 18 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) Dec 18 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 Dec 18 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 Dec 18 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 Dec 18 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
- 1,143 Total read queries
- 98 Total write queries
Queries by database
Key values
- unknown Main database
- 1,241 Requests
- 7m17s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 1,241 Requests
User Request type Count Duration unknown Total 1,241 7m17s copy to 46 1m42s delete 2 272ms select 1,143 5m14s update 50 20s300ms Duration by user
Key values
- 7m17s (unknown) Main time consuming user
User Request type Count Duration unknown Total 1,241 7m17s copy to 46 1m42s delete 2 272ms select 1,143 5m14s update 50 20s300ms Queries by host
Key values
- unknown Main host
- 1,241 Requests
- 7m17s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 1,241 Requests
- 7m17s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2022-12-18 17:54:44 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 1,134 100-500ms duration
Slowest individual queries
Rank Duration Query 1 20s31ms 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: 2022-12-18 09:01:38 ]
2 15s845ms 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) TO stdout;[ Date: 2022-12-18 09:00:40 ]
3 10s873ms 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: 2022-12-18 09:01:02 ]
4 10s631ms 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: 2022-12-18 09:00:51 ]
5 5s74ms COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty) TO stdout;[ Date: 2022-12-18 09:00:18 ]
6 4s940ms 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: 2022-12-18 09:01:10 ]
7 3s837ms 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: 2022-12-18 09:01:49 ]
8 3s406ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2022-12-18 09:00:12 ]
9 3s365ms 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, apply_discount, discount_total) TO stdout;[ Date: 2022-12-18 09:00:08 ]
10 2s659ms 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: 2022-12-18 09:01:17 ]
11 2s449ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2022-12-18 09:01:45 ]
12 2s38ms select ill.item_demand_plan_id, ARRAY_AGG(DISTINCT ill.product_id) as products from item_list_line as ill where ill.active = True and COALESCE(ill.method, 111) != 111 and ill.method not in ( select id from res_forecast_method where name in ('Not Enought data size', 'No compatable Model Found')) and ill.item_demand_plan_id in ( select idp.id from item_demand_plan as idp where idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '30 day') group by ill.item_demand_plan_id;[ Date: 2022-12-18 08:30:04 ]
13 1s552ms COPY public.product_warehouse_inventory (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) TO stdout;[ Date: 2022-12-18 09:01:14 ]
14 1s360ms 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, discount_due_date, apply_discount, sequence_generated, open_invoice, edi_split_lock, edi_billed) TO stdout;[ Date: 2022-12-18 09:00:05 ]
15 1s286ms 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: 2022-12-18 09:01:04 ]
16 1s211ms SELECT "sale_history_line".id FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%bud mckee%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) ORDER BY "sale_history_line"."invoice_date" DESC LIMIT 80;[ Date: 2022-12-18 03:30:07 ]
17 1s78ms select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '30 day' and ill.method not in ( select id from res_forecast_method where name in ('Not Enought data size', 'No compatable Model Found')) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;[ Date: 2022-12-18 08:30:25 ]
18 1s49ms SELECT count(1) FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%bud mckee%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private'))))));[ Date: 2022-12-18 03:30:08 ]
19 1s15ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;[ Date: 2022-12-18 16:22:12 ]
20 1s15ms SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE (((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND ("sale_history_line"."user_id" in ( SELECT "res_users".id FROM "res_users" LEFT JOIN "res_partner" AS "res_users__partner_id" ON ("res_users"."partner_id" = "res_users__partner_id"."id") WHERE (unaccent ("res_users__partner_id"."name"::text) ilike unaccent ('%bud mckee%')) AND (("res_users"."share" IS NULL or "res_users"."share" = false) OR EXISTS ( SELECT 1 FROM "res_company_users_rel" AS "res_users__company_ids" WHERE "res_users__company_ids"."user_id" = "res_users".id AND "res_users__company_ids"."cid" IN (1))) AND (((("res_users__partner_id"."partner_share" IS NULL or "res_users__partner_id"."partner_share" = false) OR ("res_users__partner_id"."company_id" in (1))) OR "res_users__partner_id"."company_id" IS NULL) AND (((("res_users__partner_id"."type" != 'private') OR "res_users__partner_id"."type" IS NULL) OR "res_users__partner_id"."type" IS NULL) OR ("res_users__partner_id"."type" = 'private')))))) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;[ Date: 2022-12-18 03:30:59 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3m2s 796 220ms 258ms 229ms 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 pt.discontinued = 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 pt.discontinued = false and pt.never_stock = true;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 18 11 789 3m 229ms 12 7 1s595ms 227ms -
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 = 3037 and pt.discontinued = 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 = 3037 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:30:13 Duration: 258ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2952 and pt.discontinued = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2952 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:58:10 Duration: 251ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3098 and pt.discontinued = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3098 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:56:37 Duration: 249ms
2 56s230ms 145 373ms 434ms 387ms 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 #2
Day Hour Count Duration Avg duration Dec 18 10 145 56s230ms 387ms -
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 = 280 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:08 Duration: 434ms
-
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 = 1209 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:06 Duration: 432ms
-
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 = 636 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:09 Duration: 427ms
3 20s31ms 1 20s31ms 20s31ms 20s31ms 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 #3
Day Hour Count Duration Avg duration Dec 18 09 1 20s31ms 20s31ms -
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: 2022-12-18 09:01:38 Duration: 20s31ms
4 18s84ms 30 581ms 685ms 602ms select "stock_move".id from "stock_move" left join "stock_move" AS "stock_move__sm_line_id" on ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move__sm_line_id"."sequence" desc, "stock_move__sm_line_id"."id" desc limit ?;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 18 19 30 18s84ms 602ms -
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00524%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00524%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00524%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:26:36 Duration: 685ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00245%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00245%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00245%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:08:15 Duration: 644ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/00497%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/00497%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00497%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:18:30 Duration: 643ms
5 15s845ms 1 15s845ms 15s845ms 15s845ms 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) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 18 09 1 15s845ms 15s845ms -
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) TO stdout;
Date: 2022-12-18 09:00:40 Duration: 15s845ms
6 13s114ms 22 583ms 636ms 596ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Dec 18 16 2 1s205ms 602ms 17 3 1s791ms 597ms 18 8 4s774ms 596ms 19 9 5s343ms 593ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00020%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00020%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00020%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 18:49:16 Duration: 636ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00169%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00169%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00169%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 19:01:55 Duration: 618ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%02-G/INT/00024%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%02-G/INT/00024%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%02-G/INT/00024%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 16:46:39 Duration: 603ms
7 12s628ms 29 226ms 967ms 435ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Dec 18 18 7 1s904ms 272ms 19 22 10s724ms 487ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (159154, 159155, 159156, 159157);
Date: 2022-12-18 19:06:51 Duration: 967ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167708, 167709, 167710, 167711);
Date: 2022-12-18 19:11:01 Duration: 941ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144634, 156822, 167750, 167751);
Date: 2022-12-18 19:12:23 Duration: 917ms
8 10s873ms 1 10s873ms 10s873ms 10s873ms 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 #8
Day Hour Count Duration Avg duration Dec 18 09 1 10s873ms 10s873ms -
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: 2022-12-18 09:01:02 Duration: 10s873ms
9 10s631ms 1 10s631ms 10s631ms 10s631ms copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 18 09 1 10s631ms 10s631ms -
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: 2022-12-18 09:00:51 Duration: 10s631ms
10 6s623ms 27 218ms 367ms 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 #10
Day Hour Count Duration Avg duration Dec 18 08 9 2s118ms 235ms 13 9 2s140ms 237ms 23 9 2s364ms 262ms -
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: 2022-12-18 23:10:25 Duration: 367ms
-
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: 2022-12-18 13:27:11 Duration: 361ms
-
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: 2022-12-18 08:03:17 Duration: 346ms
11 6s287ms 16 224ms 705ms 392ms update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 18 18 5 1s585ms 317ms 19 11 4s702ms 427ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167796, 144245, 167798);
Date: 2022-12-18 19:19:46 Duration: 705ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167785, 167786, 144238);
Date: 2022-12-18 19:17:35 Duration: 697ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144643, 179341, 179342);
Date: 2022-12-18 19:12:24 Duration: 694ms
12 6s113ms 27 216ms 277ms 226ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 18 08 9 1s997ms 221ms 13 9 2s71ms 230ms 23 9 2s44ms 227ms -
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: 2022-12-18 13:27:02 Duration: 277ms
-
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: 2022-12-18 23:10:31 Duration: 237ms
-
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: 2022-12-18 23:10:40 Duration: 235ms
13 5s74ms 1 5s74ms 5s74ms 5s74ms copy public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 18 09 1 5s74ms 5s74ms -
COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty) TO stdout;
Date: 2022-12-18 09:00:18 Duration: 5s74ms
14 4s940ms 1 4s940ms 4s940ms 4s940ms 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 #14
Day Hour Count Duration Avg duration Dec 18 09 1 4s940ms 4s940ms -
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: 2022-12-18 09:01:10 Duration: 4s940ms
15 4s609ms 27 160ms 260ms 170ms 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 #15
Day Hour Count Duration Avg duration Dec 18 08 9 1s482ms 164ms 13 9 1s482ms 164ms 23 9 1s645ms 182ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2022-12-18 23:10:20 Duration: 260ms
-
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: 2022-12-18 23:10:21 Duration: 248ms
-
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: 2022-12-18 08:03:14 Duration: 177ms
16 3s837ms 1 3s837ms 3s837ms 3s837ms 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 #16
Day Hour Count Duration Avg duration Dec 18 09 1 3s837ms 3s837ms -
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: 2022-12-18 09:01:49 Duration: 3s837ms
17 3s406ms 1 3s406ms 3s406ms 3s406ms 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 #17
Day Hour Count Duration Avg duration Dec 18 09 1 3s406ms 3s406ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2022-12-18 09:00:12 Duration: 3s406ms
18 3s365ms 1 3s365ms 3s365ms 3s365ms 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, apply_discount, discount_total) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 18 09 1 3s365ms 3s365ms -
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, apply_discount, discount_total) TO stdout;
Date: 2022-12-18 09:00:08 Duration: 3s365ms
19 2s659ms 1 2s659ms 2s659ms 2s659ms 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;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 18 09 1 2s659ms 2s659ms -
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: 2022-12-18 09:01:17 Duration: 2s659ms
20 2s449ms 1 2s449ms 2s449ms 2s449ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 18 09 1 2s449ms 2s449ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2022-12-18 09:01:45 Duration: 2s449ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 796 3m2s 220ms 258ms 229ms 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 pt.discontinued = 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 pt.discontinued = false and pt.never_stock = true;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Dec 18 11 789 3m 229ms 12 7 1s595ms 227ms -
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 = 3037 and pt.discontinued = 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 = 3037 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:30:13 Duration: 258ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2952 and pt.discontinued = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2952 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:58:10 Duration: 251ms
-
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3098 and pt.discontinued = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3098 and pt.discontinued = False and pt.never_stock = True;
Date: 2022-12-18 11:56:37 Duration: 249ms
2 145 56s230ms 373ms 434ms 387ms 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 #2
Day Hour Count Duration Avg duration Dec 18 10 145 56s230ms 387ms -
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 = 280 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:08 Duration: 434ms
-
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 = 1209 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:06 Duration: 432ms
-
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 = 636 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:09 Duration: 427ms
3 30 18s84ms 581ms 685ms 602ms select "stock_move".id from "stock_move" left join "stock_move" AS "stock_move__sm_line_id" on ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move__sm_line_id"."sequence" desc, "stock_move__sm_line_id"."id" desc limit ?;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Dec 18 19 30 18s84ms 602ms -
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00524%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00524%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00524%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:26:36 Duration: 685ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00245%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00245%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00245%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:08:15 Duration: 644ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/00497%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/00497%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00497%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:18:30 Duration: 643ms
4 29 12s628ms 226ms 967ms 435ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Dec 18 18 7 1s904ms 272ms 19 22 10s724ms 487ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (159154, 159155, 159156, 159157);
Date: 2022-12-18 19:06:51 Duration: 967ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167708, 167709, 167710, 167711);
Date: 2022-12-18 19:11:01 Duration: 941ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144634, 156822, 167750, 167751);
Date: 2022-12-18 19:12:23 Duration: 917ms
5 27 6s623ms 218ms 367ms 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 Dec 18 08 9 2s118ms 235ms 13 9 2s140ms 237ms 23 9 2s364ms 262ms -
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: 2022-12-18 23:10:25 Duration: 367ms
-
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: 2022-12-18 13:27:11 Duration: 361ms
-
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: 2022-12-18 08:03:17 Duration: 346ms
6 27 6s113ms 216ms 277ms 226ms 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 Dec 18 08 9 1s997ms 221ms 13 9 2s71ms 230ms 23 9 2s44ms 227ms -
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: 2022-12-18 13:27:02 Duration: 277ms
-
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: 2022-12-18 23:10:31 Duration: 237ms
-
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: 2022-12-18 23:10:40 Duration: 235ms
7 27 4s609ms 160ms 260ms 170ms 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 Dec 18 08 9 1s482ms 164ms 13 9 1s482ms 164ms 23 9 1s645ms 182ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2022-12-18 23:10:20 Duration: 260ms
-
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: 2022-12-18 23:10:21 Duration: 248ms
-
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: 2022-12-18 08:03:14 Duration: 177ms
8 22 13s114ms 583ms 636ms 596ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Dec 18 16 2 1s205ms 602ms 17 3 1s791ms 597ms 18 8 4s774ms 596ms 19 9 5s343ms 593ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00020%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00020%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00020%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 18:49:16 Duration: 636ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00169%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00169%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00169%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 19:01:55 Duration: 618ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%02-G/INT/00024%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%02-G/INT/00024%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%02-G/INT/00024%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 16:46:39 Duration: 603ms
9 16 6s287ms 224ms 705ms 392ms update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 18 18 5 1s585ms 317ms 19 11 4s702ms 427ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167796, 144245, 167798);
Date: 2022-12-18 19:19:46 Duration: 705ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167785, 167786, 144238);
Date: 2022-12-18 19:17:35 Duration: 697ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144643, 179341, 179342);
Date: 2022-12-18 19:12:24 Duration: 694ms
10 9 1s531ms 123ms 244ms 170ms select count(so.id) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 18 10 4 544ms 136ms 16 5 986ms 197ms -
select count(so.id) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-06-18T13:01:41.051797'::timestamp and so.date_order <= '2022-12-18T13:01:41.051797'::timestamp and sol.product_id = 180561 and so.state in ('done', 'sale') and so.warehouse_id = 45;
Date: 2022-12-18 16:22:11 Duration: 244ms
-
select count(so.id) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-06-18T13:01:41.051797'::timestamp and so.date_order <= '2022-12-18T13:01:41.051797'::timestamp and sol.product_id = 174162 and so.state in ('done', 'sale') and so.warehouse_id = 45;
Date: 2022-12-18 16:22:11 Duration: 227ms
-
select count(so.id) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-06-18T13:01:41.051797'::timestamp and so.date_order <= '2022-12-18T13:01:41.051797'::timestamp and sol.product_id = 197974 and so.state in ('done', 'sale') and so.warehouse_id = 45;
Date: 2022-12-18 16:22:12 Duration: 199ms
11 6 2s293ms 373ms 397ms 382ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (true or "product_warehouse_inventory"."warehouse_id" is null) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 18 00 1 377ms 377ms 04 1 373ms 373ms 08 1 397ms 397ms 13 1 390ms 390ms 17 1 376ms 376ms 21 1 378ms 378ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 08:54:15 Duration: 397ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 13:01:41 Duration: 390ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 21:16:10 Duration: 378ms
12 5 1s383ms 225ms 470ms 276ms update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 18 18 1 229ms 229ms 19 4 1s153ms 288ms -
UPDATE "stock_move" SET "delay_alert_date" = '2022-11-17 22:50:13.933020', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (162155, 144644);
Date: 2022-12-18 19:12:24 Duration: 470ms
-
UPDATE "stock_move" SET "delay_alert_date" = '2022-12-08 11:53:32.548880', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167788);
Date: 2022-12-18 19:22:59 Duration: 231ms
-
UPDATE "stock_move" SET "delay_alert_date" = '2022-11-03 21:53:28.691412', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (125886);
Date: 2022-12-18 18:49:27 Duration: 229ms
13 4 509ms 126ms 130ms 127ms select "stock_move_line".id from "stock_move_line" left join "stock_move" AS "stock_move_line__related_core_stock_line_id" on ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") left join "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" on ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") left join "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" on ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") where ("stock_move_line"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...)))) and ("stock_move_line"."company_id" is null or ("stock_move_line"."company_id" in (...))) order by "stock_move_line__related_core_stock_line_id"."sequence" desc, "stock_move_line__related_core_stock_line_id"."id" desc, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" desc, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" asc limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Dec 18 19 4 509ms 127ms -
SELECT "stock_move_line".id FROM "stock_move_line" LEFT JOIN "stock_move" AS "stock_move_line__related_core_stock_line_id" ON ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") LEFT JOIN "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" ON ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") LEFT JOIN "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" ON ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") WHERE ("stock_move_line"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00308%')) AND ("stock_picking"."company_id" in (1)))) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line__related_core_stock_line_id"."sequence" DESC, "stock_move_line__related_core_stock_line_id"."id" DESC, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" DESC, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:11:18 Duration: 130ms
-
SELECT "stock_move_line".id FROM "stock_move_line" LEFT JOIN "stock_move" AS "stock_move_line__related_core_stock_line_id" ON ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") LEFT JOIN "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" ON ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") LEFT JOIN "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" ON ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") WHERE ("stock_move_line"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00497%')) AND ("stock_picking"."company_id" in (1)))) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line__related_core_stock_line_id"."sequence" DESC, "stock_move_line__related_core_stock_line_id"."id" DESC, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" DESC, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:18:38 Duration: 126ms
-
SELECT "stock_move_line".id FROM "stock_move_line" LEFT JOIN "stock_move" AS "stock_move_line__related_core_stock_line_id" ON ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") LEFT JOIN "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" ON ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") LEFT JOIN "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" ON ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") WHERE ("stock_move_line"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00203%')) AND ("stock_picking"."company_id" in (1)))) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line__related_core_stock_line_id"."sequence" DESC, "stock_move_line__related_core_stock_line_id"."id" DESC, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" DESC, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:20:45 Duration: 126ms
14 3 2s6ms 658ms 681ms 668ms 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 #14
Day Hour Count Duration Avg duration Dec 18 15 3 2s6ms 668ms -
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 ('%340-4095%')) 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 ('%340-4095%'))) 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 ('%340-4095%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%340-4095%')))))) 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: 2022-12-18 15:54:06 Duration: 681ms
-
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 ('%12357%')) 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 ('%12357%'))) 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 ('%12357%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%12357%')))))) 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: 2022-12-18 15:52:33 Duration: 666ms
-
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 ('%340-4029%')) 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 ('%340-4029%'))) 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 ('%340-4029%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%340-4029%')))))) 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: 2022-12-18 15:54:53 Duration: 658ms
15 3 766ms 247ms 260ms 255ms select "stock_move_line".id from "stock_move_line" where (unaccent ("stock_move_line"."reference"::text) ilike unaccent (?)) and ("stock_move_line"."company_id" is null or ("stock_move_line"."company_id" in (...))) order by "stock_move_line"."date" asc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 18 16 1 260ms 260ms 19 2 506ms 253ms -
SELECT "stock_move_line".id FROM "stock_move_line" WHERE (unaccent ("stock_move_line"."reference"::text) ilike unaccent ('%07-L/INT/00013%')) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 16:59:18 Duration: 260ms
-
SELECT "stock_move_line".id FROM "stock_move_line" WHERE (unaccent ("stock_move_line"."reference"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:06:03 Duration: 258ms
-
SELECT "stock_move_line".id FROM "stock_move_line" WHERE (unaccent ("stock_move_line"."reference"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:05:11 Duration: 247ms
16 3 658ms 199ms 242ms 219ms select min("stock_move_line".id) as id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", sum("stock_move_line"."purchase_qty") AS "purchase_qty", "stock_move_line"."product_id" AS "product_id" from "stock_move_line" left join "product_product" AS "stock_move_line__product_id" on ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") left join "product_template" AS "stock_move_line__product_id__product_tmpl_id" on ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") left join "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" on ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" and "stock_move_line__product_id__product_tmpl_id__name"."type" = ? and "stock_move_line__product_id__product_tmpl_id__name"."name" = ? and "stock_move_line__product_id__product_tmpl_id__name"."lang" = ? and "stock_move_line__product_id__product_tmpl_id__name"."value" != ?) where ("stock_move_line"."state" = ?) and ("stock_move_line"."company_id" is null or ("stock_move_line"."company_id" in (...))) group by "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" order by "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 18 12 1 215ms 215ms 16 1 242ms 242ms 17 1 199ms 199ms -
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", sum("stock_move_line"."purchase_qty") AS "purchase_qty", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80;
Date: 2022-12-18 16:46:10 Duration: 242ms
-
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", sum("stock_move_line"."purchase_qty") AS "purchase_qty", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80;
Date: 2022-12-18 12:52:00 Duration: 215ms
-
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", sum("stock_move_line"."qty_done") AS "qty_done", sum("stock_move_line"."purchase_qty") AS "purchase_qty", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 80;
Date: 2022-12-18 17:51:20 Duration: 199ms
17 3 655ms 207ms 228ms 218ms select min("stock_move_line".id) as id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" AS "product_id" from "stock_move_line" left join "product_product" AS "stock_move_line__product_id" on ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") left join "product_template" AS "stock_move_line__product_id__product_tmpl_id" on ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") left join "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" on ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" and "stock_move_line__product_id__product_tmpl_id__name"."type" = ? and "stock_move_line__product_id__product_tmpl_id__name"."name" = ? and "stock_move_line__product_id__product_tmpl_id__name"."lang" = ? and "stock_move_line__product_id__product_tmpl_id__name"."value" != ?) where ("stock_move_line"."state" = ?) and ("stock_move_line"."company_id" is null or ("stock_move_line"."company_id" in (...))) group by "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" order by "stock_move_line__product_id"."default_code", coalesce("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" limit ? offset ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 18 12 1 219ms 219ms 16 1 228ms 228ms 17 1 207ms 207ms -
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80;
Date: 2022-12-18 16:46:10 Duration: 228ms
-
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80;
Date: 2022-12-18 12:52:00 Duration: 219ms
-
SELECT min("stock_move_line".id) AS id, count("stock_move_line".id) AS "product_id_count", "stock_move_line"."product_id" as "product_id" FROM "stock_move_line" LEFT JOIN "product_product" AS "stock_move_line__product_id" ON ("stock_move_line"."product_id" = "stock_move_line__product_id"."id") LEFT JOIN "product_template" AS "stock_move_line__product_id__product_tmpl_id" ON ("stock_move_line__product_id"."product_tmpl_id" = "stock_move_line__product_id__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "stock_move_line__product_id__product_tmpl_id__name" ON ("stock_move_line__product_id__product_tmpl_id"."id" = "stock_move_line__product_id__product_tmpl_id__name"."res_id" AND "stock_move_line__product_id__product_tmpl_id__name"."type" = 'model' AND "stock_move_line__product_id__product_tmpl_id__name"."name" = 'product.template,name' AND "stock_move_line__product_id__product_tmpl_id__name"."lang" = 'en_US' AND "stock_move_line__product_id__product_tmpl_id__name"."value" != '') WHERE ("stock_move_line"."state" = 'done') AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) GROUP BY "stock_move_line"."product_id", "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" ORDER BY "stock_move_line__product_id"."default_code", COALESCE("stock_move_line__product_id__product_tmpl_id__name"."value", "stock_move_line__product_id__product_tmpl_id"."name"), "stock_move_line__product_id"."id" LIMIT 100000 OFFSET 80;
Date: 2022-12-18 17:51:21 Duration: 207ms
18 2 1s940ms 925ms 1s15ms 970ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:month" from "sale_history_line" where ((("sale_history_line"."is_shipping" is null or "sale_history_line"."is_shipping" = false) and ("sale_history_line"."manufacturing_usage" is null or "sale_history_line"."manufacturing_usage" = false)) 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:month" limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 18 16 2 1s940ms 970ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;
Date: 2022-12-18 16:22:12 Duration: 1s15ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;
Date: 2022-12-18 16:22:12 Duration: 925ms
19 2 1s184ms 589ms 595ms 592ms select "stock_move".id from "stock_move" left join "stock_move" AS "stock_move__sm_line_id" on ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 18 19 2 1s184ms 592ms -
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00447%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00447%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00447%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" LIMIT 80;
Date: 2022-12-18 19:30:51 Duration: 595ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/00728%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/00728%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" LIMIT 80;
Date: 2022-12-18 19:05:25 Duration: 589ms
20 2 527ms 263ms 264ms 263ms select "stock_move_line".id from "stock_move_line" left join "stock_move" AS "stock_move_line__related_core_stock_line_id" on ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") left join "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" on ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") left join "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" on ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") where (unaccent ("stock_move_line"."reference"::text) ilike unaccent (?)) and ("stock_move_line"."company_id" is null or ("stock_move_line"."company_id" in (...))) order by "stock_move_line__related_core_stock_line_id"."sequence" desc, "stock_move_line__related_core_stock_line_id"."id" desc, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" desc, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" asc limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 18 19 2 527ms 263ms -
SELECT "stock_move_line".id FROM "stock_move_line" LEFT JOIN "stock_move" AS "stock_move_line__related_core_stock_line_id" ON ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") LEFT JOIN "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" ON ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") LEFT JOIN "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" ON ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") WHERE (unaccent ("stock_move_line"."reference"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line__related_core_stock_line_id"."sequence" DESC, "stock_move_line__related_core_stock_line_id"."id" DESC, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" DESC, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:06:11 Duration: 264ms
-
SELECT "stock_move_line".id FROM "stock_move_line" LEFT JOIN "stock_move" AS "stock_move_line__related_core_stock_line_id" ON ("stock_move_line"."related_core_stock_line_id" = "stock_move_line__related_core_stock_line_id"."id") LEFT JOIN "stock_move_line" AS "stock_move_line__linked_has_core_ml_id" ON ("stock_move_line"."linked_has_core_ml_id" = "stock_move_line__linked_has_core_ml_id"."id") LEFT JOIN "stock_quant_package" AS "stock_move_line__linked_has_core_ml_id__result_package_id" ON ("stock_move_line__linked_has_core_ml_id"."result_package_id" = "stock_move_line__linked_has_core_ml_id__result_package_id"."id") WHERE (unaccent ("stock_move_line"."reference"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_move_line"."company_id" IS NULL OR ("stock_move_line"."company_id" in (1))) ORDER BY "stock_move_line__related_core_stock_line_id"."sequence" DESC, "stock_move_line__related_core_stock_line_id"."id" DESC, "stock_move_line__linked_has_core_ml_id__result_package_id"."name" DESC, "stock_move_line__linked_has_core_ml_id"."id", "stock_move_line"."date" ASC LIMIT 80;
Date: 2022-12-18 19:06:52 Duration: 263ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 20s31ms 20s31ms 20s31ms 1 20s31ms 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 #1
Day Hour Count Duration Avg duration Dec 18 09 1 20s31ms 20s31ms -
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: 2022-12-18 09:01:38 Duration: 20s31ms
2 15s845ms 15s845ms 15s845ms 1 15s845ms 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) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Dec 18 09 1 15s845ms 15s845ms -
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) TO stdout;
Date: 2022-12-18 09:00:40 Duration: 15s845ms
3 10s873ms 10s873ms 10s873ms 1 10s873ms 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 #3
Day Hour Count Duration Avg duration Dec 18 09 1 10s873ms 10s873ms -
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: 2022-12-18 09:01:02 Duration: 10s873ms
4 10s631ms 10s631ms 10s631ms 1 10s631ms 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 Dec 18 09 1 10s631ms 10s631ms -
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: 2022-12-18 09:00:51 Duration: 10s631ms
5 5s74ms 5s74ms 5s74ms 1 5s74ms copy public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Dec 18 09 1 5s74ms 5s74ms -
COPY public.company_transfer (id, to_ship, inventory_vendor, internal_reference, product_name, from_wh_on_reserve, on_hand, on_order, usage, to_warehouse, request_qty, request_date, open_qty, customer, order_date, document, product_id, create_uid, create_date, write_uid, write_date, act_open_qty, to_warehouse_htm, to_ship_htm, open_receiving, ready_to_rx, not_ready_to_rx, bo_qty_char, order_date_char, customer_id, document_char, ship_to_htm, warehouse_to_htm, cat_vendor_short_name, done_qty) TO stdout;
Date: 2022-12-18 09:00:18 Duration: 5s74ms
6 4s940ms 4s940ms 4s940ms 1 4s940ms 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 #6
Day Hour Count Duration Avg duration Dec 18 09 1 4s940ms 4s940ms -
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: 2022-12-18 09:01:10 Duration: 4s940ms
7 3s837ms 3s837ms 3s837ms 1 3s837ms 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 #7
Day Hour Count Duration Avg duration Dec 18 09 1 3s837ms 3s837ms -
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: 2022-12-18 09:01:49 Duration: 3s837ms
8 3s406ms 3s406ms 3s406ms 1 3s406ms 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 Dec 18 09 1 3s406ms 3s406ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2022-12-18 09:00:12 Duration: 3s406ms
9 3s365ms 3s365ms 3s365ms 1 3s365ms 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, apply_discount, discount_total) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Dec 18 09 1 3s365ms 3s365ms -
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, apply_discount, discount_total) TO stdout;
Date: 2022-12-18 09:00:08 Duration: 3s365ms
10 2s659ms 2s659ms 2s659ms 1 2s659ms 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;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Dec 18 09 1 2s659ms 2s659ms -
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: 2022-12-18 09:01:17 Duration: 2s659ms
11 2s449ms 2s449ms 2s449ms 1 2s449ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Dec 18 09 1 2s449ms 2s449ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2022-12-18 09:01:45 Duration: 2s449ms
12 925ms 1s15ms 970ms 2 1s940ms select min("sale_history_line".id) as id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc(?, "sale_history_line"."invoice_date"::timestamp) AS "invoice_date:month" from "sale_history_line" where ((("sale_history_line"."is_shipping" is null or "sale_history_line"."is_shipping" = false) and ("sale_history_line"."manufacturing_usage" is null or "sale_history_line"."manufacturing_usage" = false)) 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:month" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Dec 18 16 2 1s940ms 970ms -
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;
Date: 2022-12-18 16:22:12 Duration: 1s15ms
-
SELECT min("sale_history_line".id) AS id, count("sale_history_line".id) AS "invoice_date_count", sum("sale_history_line"."product_uom_qty") AS "product_uom_qty", sum("sale_history_line"."cost_price_unit") AS "cost_price_unit", sum("sale_history_line"."cost_subtotal") AS "cost_subtotal", sum("sale_history_line"."price_unit") AS "price_unit", sum("sale_history_line"."price_subtotal") AS "price_subtotal", sum("sale_history_line"."gross_profit") AS "gross_profit", date_trunc('month', "sale_history_line"."invoice_date"::timestamp) as "invoice_date:month" FROM "sale_history_line" WHERE ((("sale_history_line"."is_shipping" IS NULL or "sale_history_line"."is_shipping" = false) AND ("sale_history_line"."manufacturing_usage" IS NULL or "sale_history_line"."manufacturing_usage" = false)) AND (("sale_history_line"."invoice_date" >= '2022-01-01') AND ("sale_history_line"."invoice_date" <= '2022-12-31'))) GROUP BY date_trunc('month', "sale_history_line"."invoice_date"::timestamp) ORDER BY "invoice_date:month" LIMIT 80;
Date: 2022-12-18 16:22:12 Duration: 925ms
13 658ms 681ms 668ms 3 2s6ms 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 Dec 18 15 3 2s6ms 668ms -
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 ('%340-4095%')) 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 ('%340-4095%'))) 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 ('%340-4095%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%340-4095%')))))) 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: 2022-12-18 15:54:06 Duration: 681ms
-
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 ('%12357%')) 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 ('%12357%'))) 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 ('%12357%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%12357%')))))) 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: 2022-12-18 15:52:33 Duration: 666ms
-
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 ('%340-4029%')) 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 ('%340-4029%'))) 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 ('%340-4029%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%340-4029%')))))) 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: 2022-12-18 15:54:53 Duration: 658ms
14 581ms 685ms 602ms 30 18s84ms select "stock_move".id from "stock_move" left join "stock_move" AS "stock_move__sm_line_id" on ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move__sm_line_id"."sequence" desc, "stock_move__sm_line_id"."id" desc limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Dec 18 19 30 18s84ms 602ms -
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00524%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00524%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00524%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:26:36 Duration: 685ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00245%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00245%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00245%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:08:15 Duration: 644ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/00497%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/00497%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00497%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence" DESC, "stock_move__sm_line_id"."id" DESC LIMIT 80;
Date: 2022-12-18 19:18:30 Duration: 643ms
15 583ms 636ms 596ms 22 13s114ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Dec 18 16 2 1s205ms 602ms 17 3 1s791ms 597ms 18 8 4s774ms 596ms 19 9 5s343ms 593ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00020%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00020%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00020%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 18:49:16 Duration: 636ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00169%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00169%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00169%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 19:01:55 Duration: 618ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%02-G/INT/00024%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%02-G/INT/00024%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%02-G/INT/00024%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2022-12-18 16:46:39 Duration: 603ms
16 589ms 595ms 592ms 2 1s184ms select "stock_move".id from "stock_move" left join "stock_move" AS "stock_move__sm_line_id" on ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Dec 18 19 2 1s184ms 592ms -
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/00447%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/00447%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/00447%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" LIMIT 80;
Date: 2022-12-18 19:30:51 Duration: 595ms
-
SELECT "stock_move".id FROM "stock_move" LEFT JOIN "stock_move" AS "stock_move__sm_line_id" ON ("stock_move"."sm_line_id" = "stock_move__sm_line_id"."id") WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/00728%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/00728%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/00728%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move__sm_line_id"."sequence", "stock_move__sm_line_id"."id" LIMIT 80;
Date: 2022-12-18 19:05:25 Duration: 589ms
17 226ms 967ms 435ms 29 12s628ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Dec 18 18 7 1s904ms 272ms 19 22 10s724ms 487ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (159154, 159155, 159156, 159157);
Date: 2022-12-18 19:06:51 Duration: 967ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167708, 167709, 167710, 167711);
Date: 2022-12-18 19:11:01 Duration: 941ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144634, 156822, 167750, 167751);
Date: 2022-12-18 19:12:23 Duration: 917ms
18 224ms 705ms 392ms 16 6s287ms update "stock_move" set "delay_alert_date" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Dec 18 18 5 1s585ms 317ms 19 11 4s702ms 427ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167796, 144245, 167798);
Date: 2022-12-18 19:19:46 Duration: 705ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (167785, 167786, 144238);
Date: 2022-12-18 19:17:35 Duration: 697ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "write_uid" = 2, "write_date" = (now() at time zone 'UTC') WHERE id IN (144643, 179341, 179342);
Date: 2022-12-18 19:12:24 Duration: 694ms
19 373ms 434ms 387ms 145 56s230ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Dec 18 10 145 56s230ms 387ms -
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 = 280 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:08 Duration: 434ms
-
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 = 1209 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:06 Duration: 432ms
-
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 = 636 and ill.method not in (8, 7);
Date: 2022-12-18 10:35:09 Duration: 427ms
20 373ms 397ms 382ms 6 2s293ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (true or "product_warehouse_inventory"."warehouse_id" is null) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Dec 18 00 1 377ms 377ms 04 1 373ms 373ms 08 1 397ms 397ms 13 1 390ms 390ms 17 1 376ms 376ms 21 1 378ms 378ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 08:54:15 Duration: 397ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 13:01:41 Duration: 390ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (TRUE OR "product_warehouse_inventory"."warehouse_id" IS NULL) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2022-12-18 21:16:10 Duration: 378ms
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
- 26,611 Log entries
Events distribution
Key values
- 0 PANIC entries
- 5753 FATAL entries
- 9805 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 9,604 Max number of times the same event was reported
- 15,558 Total events found
Rank Times reported Error 1 9,604 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Dec 18 00 384 01 394 02 399 03 397 04 400 05 393 06 394 07 396 08 392 09 387 10 393 11 528 12 388 13 393 14 392 15 395 16 396 17 395 18 398 19 396 20 398 21 395 22 398 23 403 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "website_visitor"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=48 FOR UPDATE NOWAIT
Date: 2022-12-18 00:01:50
Statement: SELECT * FROM website_visitor where id = 1 FOR NO KEY UPDATE NOWAIT
Date: 2022-12-18 09:00:02
2 5,753 FATAL: database "..." does not exist
Times Reported Most Frequent Error / Event #2
Day Hour Count Dec 18 00 233 01 240 02 240 03 240 04 240 05 240 06 240 07 240 08 240 09 240 10 240 11 240 12 240 13 240 14 240 15 240 16 240 17 240 18 240 19 240 20 240 21 240 22 240 23 240 - FATAL: database "red_lab_sandbox_sep_20" does not exist
- FATAL: database "red_lab_sandbox2" does not exist
Date: 2022-12-18 00:01:53
Date: 2022-12-18 00:02:35
3 192 ERROR: database "..." does not exist
Times Reported Most Frequent Error / Event #3
Day Hour Count Dec 18 00 8 01 8 02 8 03 8 04 8 05 8 06 8 07 8 08 8 09 8 10 8 11 8 12 8 13 8 14 8 15 8 16 8 17 8 18 8 19 8 20 8 21 8 22 8 23 8 - ERROR: database "red_lab_sandbox2" does not exist
- ERROR: database "red_lab_sandbox_sep_20" does not exist
Statement: SELECT pg_database_size('red_lab_sandbox2')
Date: 2022-12-18 00:11:24
Statement: SELECT pg_database_size('red_lab_sandbox_sep_20')
Date: 2022-12-18 00:11:27
4 5 LOG: could not receive data from client: Connection reset by peer
Times Reported Most Frequent Error / Event #4
Day Hour Count Dec 18 00 1 04 1 08 1 13 1 17 1 - ERROR: could not receive data from client: Connection reset by peer
Date: 2022-12-18 00:39:14
5 4 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #5
Day Hour Count Dec 18 02 1 03 1 16 1 17 1 - ERROR: could not serialize access due to concurrent update
Statement: SELECT * FROM website_visitor where id = 652301 FOR NO KEY UPDATE NOWAIT
Date: 2022-12-18 02:58:41