pgBadger-
Global information
- Generated on Mon Jan 22 00:50:04 2024
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 114,221 log entries in 3s
- Log start from 2024-01-21 00:03:26 to 2024-01-21 23:59:59
-
Overview
Global Stats
- 193 Number of unique normalized queries
- 38,871 Number of queries
- 2h55m23s Total query duration
- 2024-01-21 00:03:26 First query
- 2024-01-21 23:59:59 Last query
- 21 queries/s at 2024-01-21 16:51:36 Query peak
- 2h55m23s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h55m23s Execute total duration
- 4,921 Number of events
- 3 Number of unique normalized events
- 4,331 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
- 38,871 Average queries per session
- 2h55m23s 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
- 21 queries/s Query Peak
- 2024-01-21 16:51:36 Date
SELECT Traffic
Key values
- 21 queries/s Query Peak
- 2024-01-21 16:51:36 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 7 queries/s Query Peak
- 2024-01-21 16:31:28 Date
Queries duration
Key values
- 2h55m23s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 21 00 42 0ms 455ms 277ms 5s382ms 5s382ms 5s382ms 01 135 0ms 474ms 221ms 3s614ms 4s524ms 5s41ms 02 89 0ms 498ms 272ms 4s330ms 4s407ms 6s28ms 03 116 0ms 4s357ms 244ms 4s800ms 5s666ms 7s148ms 04 63 0ms 465ms 247ms 5s153ms 5s188ms 5s188ms 05 122 0ms 457ms 219ms 3s254ms 3s935ms 4s892ms 06 113 0ms 392ms 205ms 1s207ms 2s983ms 4s73ms 07 361 0ms 11s212ms 320ms 9s533ms 11s216ms 14s335ms 08 1,880 120ms 485ms 288ms 13s799ms 16s823ms 17s491ms 09 1,521 0ms 3m50s 744ms 56s773ms 1m43s 4m16s 10 4,121 120ms 4s136ms 171ms 35s287ms 40s79ms 1m16s 11 10,889 120ms 5s27ms 174ms 45s120ms 47s413ms 50s106ms 12 1,534 120ms 451ms 311ms 11s205ms 11s843ms 13s647ms 13 1,707 120ms 475ms 301ms 11s662ms 12s127ms 13s717ms 14 1,504 120ms 474ms 306ms 9s810ms 10s640ms 11s125ms 15 1,919 120ms 2s967ms 299ms 12s907ms 14s277ms 30s920ms 16 2,119 120ms 6s405ms 303ms 21s704ms 23s655ms 36s153ms 17 1,578 120ms 507ms 294ms 11s24ms 13s126ms 14s698ms 18 1,463 120ms 509ms 303ms 10s30ms 11s16ms 13s82ms 19 1,479 120ms 823ms 306ms 11s94ms 12s822ms 14s658ms 20 1,760 120ms 1s347ms 302ms 12s978ms 15s43ms 22s686ms 21 1,529 120ms 1s749ms 327ms 10s499ms 12s595ms 54s381ms 22 1,425 120ms 438ms 312ms 10s51ms 10s469ms 13s178ms 23 1,402 120ms 11s44ms 319ms 10s874ms 12s882ms 17s519ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 21 00 42 0 277ms 4s310ms 5s382ms 5s382ms 01 135 0 221ms 1s405ms 3s614ms 5s41ms 02 89 0 272ms 3s338ms 4s330ms 6s28ms 03 114 0 195ms 1s276ms 3s285ms 5s666ms 04 63 0 247ms 3s55ms 5s153ms 5s188ms 05 122 0 219ms 1s92ms 3s254ms 4s892ms 06 113 0 205ms 853ms 1s207ms 4s73ms 07 359 0 287ms 7s550ms 9s73ms 11s216ms 08 1,880 0 288ms 11s694ms 13s799ms 16s974ms 09 1,425 96 744ms 12s62ms 44s904ms 1m45s 10 1,507 0 222ms 10s313ms 17s501ms 31s822ms 11 4,823 0 212ms 20s69ms 24s443ms 30s80ms 12 1,534 0 311ms 9s768ms 11s205ms 12s415ms 13 1,707 0 301ms 10s511ms 11s662ms 13s52ms 14 1,504 0 306ms 9s288ms 9s810ms 11s103ms 15 1,852 0 297ms 11s382ms 12s907ms 14s876ms 16 1,710 0 285ms 9s989ms 11s407ms 17s369ms 17 1,578 0 294ms 9s760ms 11s24ms 13s413ms 18 1,463 0 303ms 8s973ms 10s30ms 11s146ms 19 1,479 0 306ms 9s78ms 11s94ms 14s551ms 20 1,710 0 301ms 10s781ms 12s978ms 18s716ms 21 1,529 0 327ms 8s858ms 10s499ms 16s544ms 22 1,425 0 312ms 8s920ms 10s51ms 11s468ms 23 1,398 0 307ms 8s739ms 9s392ms 12s823ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jan 21 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 2 0 2s983ms 0ms 0ms 5s966ms 04 0 0 0 0 0ms 0ms 0ms 0ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 0 2 0 6s411ms 0ms 0ms 0ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 2,613 0 0 142ms 7s401ms 16s514ms 25s900ms 11 0 6,066 0 0 144ms 13s256ms 21s743ms 33s453ms 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 26 40 1 0 338ms 0ms 0ms 2s338ms 16 177 229 3 0 380ms 1s17ms 6s614ms 12s707ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 4 46 0 0 330ms 0ms 368ms 2s83ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 4 0 4s628ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jan 21 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jan 21 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jan 21 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jan 21 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jan 21 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jan 21 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jan 21 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jan 21 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jan 21 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
- 29,561 Total read queries
- 9,310 Total write queries
Queries by database
Key values
- unknown Main database
- 38,871 Requests
- 2h55m23s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 38,871 Requests
User Request type Count Duration unknown Total 38,871 2h55m23s copy to 96 12m12s cte 1 313ms delete 12 38s787ms insert 207 1m30s select 29,561 2h18m27s update 8,994 22m34s Duration by user
Key values
- 2h55m23s (unknown) Main time consuming user
User Request type Count Duration unknown Total 38,871 2h55m23s copy to 96 12m12s cte 1 313ms delete 12 38s787ms insert 207 1m30s select 29,561 2h18m27s update 8,994 22m34s Queries by host
Key values
- unknown Main host
- 38,871 Requests
- 2h55m23s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 38,871 Requests
- 2h55m23s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2024-01-21 16:34:21 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 38,550 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m50s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-01-21 09:08:38 ]
2 1m37s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2024-01-21 09:03:07 ]
3 1m32s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2024-01-21 09:04:47 ]
4 1m3s COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2024-01-21 09:12:20 ]
5 40s481ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2024-01-21 09:11:17 ]
6 25s751ms COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax, auto_reconcile, is_writeoff, is_extra_line, is_carry_forward) TO stdout;[ Date: 2024-01-21 09:00:41 ]
7 20s694ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id, inventory_vendor_id, product_type) TO stdout;[ Date: 2024-01-21 09:10:03 ]
8 15s200ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-01-21 09:01:04 ]
9 11s212ms DELETE FROM account_move_line WHERE id IN (4040125, 4040126, 4040127, 4040128, 4040129, 4040130, 4040131, 4040132);[ Date: 2024-01-21 07:06:37 ]
10 11s44ms DELETE FROM account_move_line WHERE id IN (4040135, 4040136, 4040137, 4040138, 4040139, 4040140, 4040141, 4040142);[ Date: 2024-01-21 23:07:35 ]
11 10s998ms COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type, from_ar, auto_reconcile, related_payment_id, discount_amount_applied) TO stdout;[ Date: 2024-01-21 09:00:16 ]
12 8s702ms COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-01-21 09:08:47 ]
13 7s699ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2024-01-21 09:01:12 ]
14 7s202ms COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core, inventory_vendor_id) TO stdout;[ Date: 2024-01-21 09:10:21 ]
15 6s405ms UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775488, 775490, 775492, 775494, 775475, 775477, 775479, 775481, 775482, 775484, 775486);[ Date: 2024-01-21 16:46:53 ]
16 5s390ms COPY public.forecasted_data (id, date, min_product_uom_qty, max_product_uom_qty, item_supply_plan_id, po_qty, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, default_code, ext_cost, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_mtd_sold, lead_days, mon_1_qty, mon_2_qty, mon_3_qty, mon_4_qty, mon_5_qty, mon_6_qty, mon_7_qty, mon_8_qty, mon_9_qty, mon_10_qty, mon_11_qty, mon_12_qty, seasonal, stocking_flag, freeze_date, warehouse_min_product_uom_qty, is_forcast, modify_qty, req_po_qty, supercede_product_id, superceded, final_branch_id, po_id, unit_ext_cost, is_freeze, qty_in_transist, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, is_new_stock_product, ref_id, ref, product_name, is_stock_flag_product, class_code_id, sft_stk_qty, need_qty_with_sft_stk) TO stdout;[ Date: 2024-01-21 09:01:23 ]
17 5s124ms COPY public.stock_move_line (id, picking_id, move_id, company_id, product_id, product_uom_id, product_qty, product_uom_qty, qty_done, package_id, package_level_id, lot_id, lot_name, result_package_id, date, owner_id, location_id, location_dest_id, state, reference, description_picking, create_uid, create_date, write_uid, write_date, workorder_id, production_id, related_core_sale_line_id, related_sale_line_id, related_core_purchase_line_id, related_purchase_line_id, related_core_stock_line_id, move_options, purchase_qty, related_repair_line_id, related_core_repair_line_id, branch_id, related_core_bom_line_id, related_bom_line_id, related_raw_material_production_id, linked_has_core_ml_id, order_purchase_qty, current_warehouse_qty, description) TO stdout;[ Date: 2024-01-21 09:10:26 ]
18 5s27ms SELECT min("account_aged_receivable".id) AS id, count("account_aged_receivable".id) AS "__count", max("account_aged_receivable"."partner_name") AS "partner_name", max("account_aged_receivable"."partner_trust") AS "partner_trust", max("account_aged_receivable"."report_date") AS "report_date", max("account_aged_receivable"."move_name") AS "move_name", max("account_aged_receivable"."journal_code") AS "journal_code", max("account_aged_receivable"."account_name") AS "account_name", max("account_aged_receivable"."account_code") AS "account_code", sum("account_aged_receivable"."period0") AS "period0", sum("account_aged_receivable"."period1") AS "period1", sum("account_aged_receivable"."period2") AS "period2", sum("account_aged_receivable"."period3") AS "period3", sum("account_aged_receivable"."period4") AS "period4", sum("account_aged_receivable"."period5") AS "period5", max("account_aged_receivable"."branch_name") AS "branch_name", max("account_aged_receivable"."sale_person_name") AS "sale_person_name", max("account_aged_receivable"."invoice_date") AS "invoice_date", min("account_aged_receivable"."date") AS "date", sum("account_aged_receivable"."debit") AS "debit", sum("account_aged_receivable"."credit") AS "credit", sum("account_aged_receivable"."balance") AS "balance", "account_aged_receivable"."partner_id" as "partner_id" FROM ( SELECT account_move_line.id, account_move_line.move_id, account_move_line.name, account_move_line.account_id, account_move_line.journal_id, account_move_line.company_id, account_move_line.currency_id, account_move_line.analytic_account_id, account_move_line.display_type, account_move_line.date, account_move_line.debit, account_move_line.credit, account_move_line.balance, account_move_line.partner_id AS partner_id, partner.name AS partner_name, COALESCE(trust_property.value_text, 'normal') AS partner_trust, COALESCE(account_move_line.currency_id, journal.currency_id) AS report_currency_id, account_move_line.payment_id AS payment_id, COALESCE(account_move_line.date_maturity, account_move_line.date) AS report_date, account_move_line.expected_pay_date AS expected_pay_date, move.move_type AS move_type, move.name AS move_name, move.branch_name AS branch_name, move.branch_id AS branch_id, move.date AS invoice_date, partner_users.name AS sale_person_name, journal.code AS journal_code, account.name AS account_name, account.code AS account_code, CASE WHEN period_table.period_index = 0 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period0, CASE WHEN period_table.period_index = 1 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period1, CASE WHEN period_table.period_index = 2 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period2, CASE WHEN period_table.period_index = 3 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period3, CASE WHEN period_table.period_index = 4 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period4, CASE WHEN period_table.period_index = 5 THEN 1 * ROUND((account_move_line.balance - COALESCE(SUM(part_debit.amount), 0) + COALESCE(SUM(part_credit.amount), 0)) * currency_table.rate, currency_table.precision) ELSE 0 END AS period5 FROM account_move_line JOIN account_move move ON account_move_line.move_id = move.id JOIN account_journal journal ON journal.id = account_move_line.journal_id JOIN account_account account ON account.id = account_move_line.account_id LEFT JOIN res_partner partner ON partner.id = account_move_line.partner_id LEFT JOIN res_users users ON users.id = partner.user_id LEFT JOIN res_partner partner_users ON partner_users.id = users.partner_id LEFT JOIN ir_property trust_property ON (trust_property.res_id = 'res.partner,' || account_move_line.partner_id AND trust_property.name = 'trust' AND trust_property.company_id = account_move_line.company_id) JOIN ( VALUES (1, 1.0, 2)) AS currency_table (company_id, rate, precision) ON currency_table.company_id = account_move_line.company_id LEFT JOIN LATERAL ( SELECT part.amount, part.debit_move_id FROM account_partial_reconcile part WHERE part.max_date <= '2024-01-21') part_debit ON part_debit.debit_move_id = account_move_line.id LEFT JOIN LATERAL ( SELECT part.amount, part.credit_move_id FROM account_partial_reconcile part WHERE part.max_date <= '2024-01-21') part_credit ON part_credit.credit_move_id = account_move_line.id JOIN ( VALUES (NULL, '2024-01-21', 0), ('2024-01-20', '2023-12-22', 1), ('2023-12-21', '2023-11-22', 2), ('2023-11-21', '2023-10-23', 3), ('2023-10-22', '2023-09-23', 4), ('2023-09-22', NULL, 5)) AS period_table (date_start, date_stop, period_index) ON (period_table.date_start IS NULL OR COALESCE(account_move_line.date_maturity, account_move_line.date) <= DATE(period_table.date_start)) AND (period_table.date_stop IS NULL OR COALESCE(account_move_line.date_maturity, account_move_line.date) >= DATE(period_table.date_stop)) WHERE account.internal_type = 'receivable' GROUP BY account_move_line.id, partner.id, trust_property.id, journal.id, move.id, account.id, partner_users.name, period_table.period_index, currency_table.rate, currency_table.precision) AS "account_aged_receivable" WHERE (((((("account_aged_receivable"."display_type" not in ('line_section', 'line_note')) OR "account_aged_receivable"."display_type" IS NULL) AND ("account_aged_receivable"."move_id" in ( SELECT "account_move".id FROM "account_move" WHERE (("account_move"."state" != 'cancel') OR "account_move"."state" IS NULL) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1)))))) AND ("account_aged_receivable"."company_id" = 1)) AND ("account_aged_receivable"."date" <= '2024-01-21')) AND ("account_aged_receivable"."move_id" in ( SELECT "account_move".id FROM "account_move" WHERE ("account_move"."state" = 'posted') AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1)))))) GROUP BY "account_aged_receivable"."partner_id" ORDER BY "partner_name", "report_date" asc, "move_name" desc;[ Date: 2024-01-21 11:03:12 ]
19 4s941ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2024-01-21 09:08:55 ]
20 4s920ms COPY public.stock_valuation_layer (id, company_id, product_id, quantity, unit_cost, value, remaining_qty, remaining_value, description, stock_valuation_layer_id, stock_move_id, account_move_id, create_uid, create_date, write_uid, write_date, move_options, other_action, final_action) TO stdout;[ Date: 2024-01-21 09:10:36 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h45m25s 19,188 318ms 580ms 329ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 21 07 249 1m21s 328ms 08 1,348 7m24s 329ms 09 1,027 5m40s 331ms 10 165 56s779ms 344ms 11 1,157 6m33s 340ms 12 1,330 7m16s 328ms 13 1,409 7m43s 329ms 14 1,271 6m57s 328ms 15 1,500 8m15s 330ms 16 1,211 6m39s 329ms 17 1,202 6m34s 328ms 18 1,241 6m48s 329ms 19 1,220 6m40s 328ms 20 1,205 6m35s 328ms 21 1,214 6m38s 328ms 22 1,250 6m48s 326ms 23 1,189 6m30s 328ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 16:51:36 Duration: 580ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 11:02:38 Duration: 547ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 09:00:46 Duration: 547ms
2 20m52s 8,688 133ms 300ms 144ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 21 10 2,612 6m12s 142ms 11 6,066 14m38s 144ms 16 10 1s456ms 145ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209211) and warehouse_id = (35));
Date: 2024-01-21 10:43:47 Duration: 300ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (256736) and warehouse_id = (46));
Date: 2024-01-21 11:52:15 Duration: 213ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (216433) and warehouse_id = (43));
Date: 2024-01-21 11:34:36 Duration: 211ms
3 13m54s 5,111 120ms 502ms 163ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 21 00 42 11s666ms 277ms 01 135 29s867ms 221ms 02 89 24s219ms 272ms 03 73 16s506ms 226ms 04 63 15s597ms 247ms 05 103 21s448ms 208ms 06 74 12s325ms 166ms 07 43 8s744ms 203ms 08 424 1m8s 161ms 09 352 46s905ms 133ms 10 328 51s84ms 155ms 11 891 2m2s 137ms 12 138 22s498ms 163ms 13 250 38s68ms 152ms 14 190 31s349ms 164ms 15 268 40s602ms 151ms 16 156 25s63ms 160ms 17 325 56s208ms 172ms 18 192 26s645ms 138ms 19 180 31s323ms 174ms 20 360 58s551ms 162ms 21 231 42s943ms 185ms 22 112 19s346ms 172ms 23 92 12s902ms 140ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 21:58:35') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_969"', '["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 21:59:26 Duration: 502ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 02:37:48') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1235"'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 02:38:39 Duration: 498ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 16:08:27') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 16:09:17 Duration: 482ms
4 3m50s 1 3m50s 3m50s 3m50s 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 #4
Day Hour Count Duration Avg duration Jan 21 09 1 3m50s 3m50s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-01-21 09:08:38 Duration: 3m50s
5 3m45s 788 273ms 431ms 285ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? 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 #5
Day Hour Count Duration Avg duration Jan 21 07 12 3s421ms 285ms 08 99 28s454ms 287ms 09 42 11s867ms 282ms 10 30 8s564ms 285ms 11 48 14s306ms 298ms 12 66 18s923ms 286ms 13 45 12s746ms 283ms 14 42 12s39ms 286ms 15 27 7s605ms 281ms 16 12 3s379ms 281ms 17 51 14s531ms 284ms 18 30 8s603ms 286ms 19 53 14s996ms 282ms 20 66 18s826ms 285ms 21 48 13s674ms 284ms 22 63 17s993ms 285ms 23 54 15s277ms 282ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 08:34:03 Duration: 431ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 20:33:32 Duration: 419ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 14:49:12 Duration: 408ms
6 3m7s 523 345ms 607ms 359ms select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 21 10 143 51s281ms 358ms 11 377 2m15s 359ms 16 3 1s67ms 355ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:08:32 Duration: 607ms
-
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 = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:46:22 Duration: 487ms
-
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 = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 10:47:23 Duration: 480ms
7 2m47s 1,239 120ms 392ms 135ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 21 10 216 27s487ms 127ms 11 781 1m40s 128ms 15 47 6s420ms 136ms 16 195 33s692ms 172ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (238997, 239078, 239141, 239226, 238992, 239077, 239215)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:05:41 Duration: 392ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (238997, 239078, 239141, 239226, 238992, 239077, 239215)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:11:03 Duration: 385ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (239049, 239078, 239103)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:11:03 Duration: 328ms
8 1m37s 1 1m37s 1m37s 1m37s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 21 09 1 1m37s 1m37s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2024-01-21 09:03:07 Duration: 1m37s
9 1m32s 1 1m32s 1m32s 1m32s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 21 09 1 1m32s 1m32s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2024-01-21 09:04:47 Duration: 1m32s
10 1m26s 523 147ms 258ms 165ms select pwi.product_id, coalesce(pwi.lead_days, ?), coalesce(pwi.min_product_uom_qty, ?) as min_qty, coalesce(pwi.max_product_uom_qty, ?) as max_qty, coalesce(pwi.max_product_uom_qty, ?) - ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) as need_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pt.is_core, false) = false and coalesce(pwi.stocking_flag, false) = true and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < coalesce(pwi.max_product_uom_qty, ?) and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 21 10 143 23s659ms 165ms 11 377 1m2s 165ms 16 3 483ms 161ms -
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2954;
Date: 2024-01-21 11:00:06 Duration: 258ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 46 and pwi.inventory_vendor_id = 2994;
Date: 2024-01-21 11:47:12 Duration: 217ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-21 11:44:12 Duration: 203ms
11 1m15s 126 144ms 1s121ms 597ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 21 15 15 8s953ms 596ms 16 111 1m6s 597ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 48, 1, '2024-01-25 16:46:29.295215', 45, 211027, false, 461, 468, 'new_product', '13-T/INT/12973', '13-T/INT/12973', 324987, 357, '0', 'make_to_stock', 238952, 1, '4.00', true, 10, 40, 'waiting', 9139, 45) RETURNING id;
Date: 2024-01-21 16:46:36 Duration: 1s121ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-23 16:34:35.633714', 41, 211021, false, 429, 468, 'new_product', '09-B/INT/10091', '09-B/INT/10091', 324981, 325, '0', 'make_to_stock', 238906, 1, '5.00', true, 10, 40, 'waiting', 9119, 41) RETURNING id;
Date: 2024-01-21 16:34:39 Duration: 1s88ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 56, 1, '2024-01-21 16:49:21', 46, 211029, false, 487, 468, 'new_product', '14-D/INT/01649', '14-D/INT/01649', 324989, 367, '0', 'make_to_stock', 238919, 1, '15.00', true, 10, 40, 'waiting', 9146, 46) RETURNING id;
Date: 2024-01-21 16:49:22 Duration: 1s87ms
12 1m12s 520 133ms 181ms 140ms select id from product_warehouse_inventory where freeze_date is not null and freeze_date > ? and warehouse_id = ? and inventory_vendor_id = ? and qty_available < min_product_uom_qty;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 21 10 144 20s266ms 140ms 11 376 52s672ms 140ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 11:27:53' and warehouse_id = 43 and inventory_vendor_id = 3098 and qty_available < min_product_uom_qty;
Date: 2024-01-21 11:27:54 Duration: 181ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 11:43:50' and warehouse_id = 44 and inventory_vendor_id = 2951 and qty_available < min_product_uom_qty;
Date: 2024-01-21 11:43:51 Duration: 180ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 10:52:58' and warehouse_id = 36 and inventory_vendor_id = 3084 and qty_available < min_product_uom_qty;
Date: 2024-01-21 10:52:58 Duration: 179ms
13 1m10s 523 128ms 182ms 134ms select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > ? and warehouse_id = ? and ((coalesce(qty_available, ?) + coalesce(qty_on_order, ?)) - coalesce(qty_reserve, ?)) < ? and inventory_vendor_id = ? and coalesce(superceded, false) = false and coalesce(discontinued, false) = false and coalesce(is_core, false) = false;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 21 10 144 19s353ms 134ms 11 376 50s634ms 134ms 16 3 469ms 156ms -
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 41 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2934 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 16:01:58 Duration: 182ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 36 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2957 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 10:53:01 Duration: 180ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 43 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2947 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 11:26:32 Duration: 172ms
14 1m3s 1 1m3s 1m3s 1m3s 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 #14
Day Hour Count Duration Avg duration Jan 21 09 1 1m3s 1m3s -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2024-01-21 09:12:20 Duration: 1m3s
15 47s479ms 37 146ms 6s405ms 1s283ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 21 15 5 5s602ms 1s120ms 16 23 39s271ms 1s707ms 20 9 2s604ms 289ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775488, 775490, 775492, 775494, 775475, 775477, 775479, 775481, 775482, 775484, 775486);
Date: 2024-01-21 16:46:53 Duration: 6s405ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775457, 775459, 775447, 775449, 775451, 775453, 775455);
Date: 2024-01-21 16:43:29 Duration: 4s130ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775403, 775405, 775407, 775409, 775411, 775413);
Date: 2024-01-21 16:34:49 Duration: 3s569ms
16 45s104ms 289 148ms 198ms 156ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 21 10 88 13s674ms 155ms 11 201 31s430ms 156ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3045 and pwi.warehouse_id = 36 and pwi.product_id not in (177742);
Date: 2024-01-21 10:52:07 Duration: 198ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3035 and pwi.warehouse_id = 45 and pwi.product_id not in (254211, 252378, 172567, 172224, 172212, 172061, 172038, 171754, 171752, 171772, 171996);
Date: 2024-01-21 11:36:17 Duration: 196ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2933 and pwi.warehouse_id = 42 and pwi.product_id not in (238852, 238893, 238912, 238950, 238892, 238904, 238902, 238875);
Date: 2024-01-21 11:21:10 Duration: 195ms
17 40s481ms 1 40s481ms 40s481ms 40s481ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 21 09 1 40s481ms 40s481ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2024-01-21 09:11:17 Duration: 40s481ms
18 35s571ms 231 148ms 198ms 153ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 21 10 55 8s448ms 153ms 11 176 27s122ms 154ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3091 and pwi.warehouse_id = 41;
Date: 2024-01-21 11:09:21 Duration: 198ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3036 and pwi.warehouse_id = 41;
Date: 2024-01-21 11:12:42 Duration: 186ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3106 and pwi.warehouse_id = 45;
Date: 2024-01-21 11:42:30 Duration: 184ms
19 30s971ms 4 4s357ms 11s212ms 7s742ms delete from account_move_line where id in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 21 03 1 4s357ms 4s357ms 07 1 11s212ms 11s212ms 23 2 15s402ms 7s701ms -
DELETE FROM account_move_line WHERE id IN (4040125, 4040126, 4040127, 4040128, 4040129, 4040130, 4040131, 4040132);
Date: 2024-01-21 07:06:37 Duration: 11s212ms
-
DELETE FROM account_move_line WHERE id IN (4040135, 4040136, 4040137, 4040138, 4040139, 4040140, 4040141, 4040142);
Date: 2024-01-21 23:07:35 Duration: 11s44ms
-
DELETE FROM account_move_line WHERE id IN (4040120, 4040121, 4040122);
Date: 2024-01-21 03:12:17 Duration: 4s357ms
20 30s317ms 47 620ms 759ms 645ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 21 20 47 30s317ms 645ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4494973%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%449-4973%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%449-4973%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:49:30 Duration: 759ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:22 Duration: 707ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:14 Duration: 702ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 19,188 1h45m25s 318ms 580ms 329ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 21 07 249 1m21s 328ms 08 1,348 7m24s 329ms 09 1,027 5m40s 331ms 10 165 56s779ms 344ms 11 1,157 6m33s 340ms 12 1,330 7m16s 328ms 13 1,409 7m43s 329ms 14 1,271 6m57s 328ms 15 1,500 8m15s 330ms 16 1,211 6m39s 329ms 17 1,202 6m34s 328ms 18 1,241 6m48s 329ms 19 1,220 6m40s 328ms 20 1,205 6m35s 328ms 21 1,214 6m38s 328ms 22 1,250 6m48s 326ms 23 1,189 6m30s 328ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 16:51:36 Duration: 580ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 11:02:38 Duration: 547ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 09:00:46 Duration: 547ms
2 8,688 20m52s 133ms 300ms 144ms update product_warehouse_inventory set sft_stk_qty = ? where id = ( select id from product_warehouse_inventory where product_id = (?) and warehouse_id = (?));Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 21 10 2,612 6m12s 142ms 11 6,066 14m38s 144ms 16 10 1s456ms 145ms -
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209211) and warehouse_id = (35));
Date: 2024-01-21 10:43:47 Duration: 300ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (256736) and warehouse_id = (46));
Date: 2024-01-21 11:52:15 Duration: 213ms
-
update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (216433) and warehouse_id = (43));
Date: 2024-01-21 11:34:36 Duration: 211ms
3 5,111 13m54s 120ms 502ms 163ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 21 00 42 11s666ms 277ms 01 135 29s867ms 221ms 02 89 24s219ms 272ms 03 73 16s506ms 226ms 04 63 15s597ms 247ms 05 103 21s448ms 208ms 06 74 12s325ms 166ms 07 43 8s744ms 203ms 08 424 1m8s 161ms 09 352 46s905ms 133ms 10 328 51s84ms 155ms 11 891 2m2s 137ms 12 138 22s498ms 163ms 13 250 38s68ms 152ms 14 190 31s349ms 164ms 15 268 40s602ms 151ms 16 156 25s63ms 160ms 17 325 56s208ms 172ms 18 192 26s645ms 138ms 19 180 31s323ms 174ms 20 360 58s551ms 162ms 21 231 42s943ms 185ms 22 112 19s346ms 172ms 23 92 12s902ms 140ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 21:58:35') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_969"', '["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 21:59:26 Duration: 502ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 02:37:48') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1235"'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 02:38:39 Duration: 498ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 16:08:27') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 16:09:17 Duration: 482ms
4 1,239 2m47s 120ms 392ms 135ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where ("product_warehouse_inventory"."product_id" in (...)) order by "product_warehouse_inventory"."warehouse_name";Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 21 10 216 27s487ms 127ms 11 781 1m40s 128ms 15 47 6s420ms 136ms 16 195 33s692ms 172ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (238997, 239078, 239141, 239226, 238992, 239077, 239215)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:05:41 Duration: 392ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (238997, 239078, 239141, 239226, 238992, 239077, 239215)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:11:03 Duration: 385ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (239049, 239078, 239103)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2024-01-21 16:11:03 Duration: 328ms
5 788 3m45s 273ms 431ms 285ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? 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 #5
Day Hour Count Duration Avg duration Jan 21 07 12 3s421ms 285ms 08 99 28s454ms 287ms 09 42 11s867ms 282ms 10 30 8s564ms 285ms 11 48 14s306ms 298ms 12 66 18s923ms 286ms 13 45 12s746ms 283ms 14 42 12s39ms 286ms 15 27 7s605ms 281ms 16 12 3s379ms 281ms 17 51 14s531ms 284ms 18 30 8s603ms 286ms 19 53 14s996ms 282ms 20 66 18s826ms 285ms 21 48 13s674ms 284ms 22 63 17s993ms 285ms 23 54 15s277ms 282ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 08:34:03 Duration: 431ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 20:33:32 Duration: 419ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 14:49:12 Duration: 408ms
6 523 3m7s 345ms 607ms 359ms select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 21 10 143 51s281ms 358ms 11 377 2m15s 359ms 16 3 1s67ms 355ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:08:32 Duration: 607ms
-
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 = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:46:22 Duration: 487ms
-
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 = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 10:47:23 Duration: 480ms
7 523 1m26s 147ms 258ms 165ms select pwi.product_id, coalesce(pwi.lead_days, ?), coalesce(pwi.min_product_uom_qty, ?) as min_qty, coalesce(pwi.max_product_uom_qty, ?) as max_qty, coalesce(pwi.max_product_uom_qty, ?) - ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) as need_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pt.is_core, false) = false and coalesce(pwi.stocking_flag, false) = true and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < coalesce(pwi.max_product_uom_qty, ?) and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jan 21 10 143 23s659ms 165ms 11 377 1m2s 165ms 16 3 483ms 161ms -
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2954;
Date: 2024-01-21 11:00:06 Duration: 258ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 46 and pwi.inventory_vendor_id = 2994;
Date: 2024-01-21 11:47:12 Duration: 217ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-21 11:44:12 Duration: 203ms
8 523 1m10s 128ms 182ms 134ms select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > ? and warehouse_id = ? and ((coalesce(qty_available, ?) + coalesce(qty_on_order, ?)) - coalesce(qty_reserve, ?)) < ? and inventory_vendor_id = ? and coalesce(superceded, false) = false and coalesce(discontinued, false) = false and coalesce(is_core, false) = false;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 21 10 144 19s353ms 134ms 11 376 50s634ms 134ms 16 3 469ms 156ms -
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 41 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2934 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 16:01:58 Duration: 182ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 36 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2957 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 10:53:01 Duration: 180ms
-
select id, qty_reserve, product_id, product_tmpl_id from product_warehouse_inventory where qty_reserve > 0 and warehouse_id = 43 and ((COALESCE(qty_available, 0) + COALESCE(qty_on_order, 0)) - COALESCE(qty_reserve, 0)) < 0 and inventory_vendor_id = 2947 and COALESCE(superceded, False) = False and COALESCE(discontinued, False) = False and COALESCE(is_core, False) = False;
Date: 2024-01-21 11:26:32 Duration: 172ms
9 520 1m12s 133ms 181ms 140ms select id from product_warehouse_inventory where freeze_date is not null and freeze_date > ? and warehouse_id = ? and inventory_vendor_id = ? and qty_available < min_product_uom_qty;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 21 10 144 20s266ms 140ms 11 376 52s672ms 140ms -
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 11:27:53' and warehouse_id = 43 and inventory_vendor_id = 3098 and qty_available < min_product_uom_qty;
Date: 2024-01-21 11:27:54 Duration: 181ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 11:43:50' and warehouse_id = 44 and inventory_vendor_id = 2951 and qty_available < min_product_uom_qty;
Date: 2024-01-21 11:43:51 Duration: 180ms
-
select id from product_warehouse_inventory where freeze_date is not null and freeze_date > '2024-01-21 10:52:58' and warehouse_id = 36 and inventory_vendor_id = 3084 and qty_available < min_product_uom_qty;
Date: 2024-01-21 10:52:58 Duration: 179ms
10 289 45s104ms 148ms 198ms 156ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 21 10 88 13s674ms 155ms 11 201 31s430ms 156ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3045 and pwi.warehouse_id = 36 and pwi.product_id not in (177742);
Date: 2024-01-21 10:52:07 Duration: 198ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3035 and pwi.warehouse_id = 45 and pwi.product_id not in (254211, 252378, 172567, 172224, 172212, 172061, 172038, 171754, 171752, 171772, 171996);
Date: 2024-01-21 11:36:17 Duration: 196ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2933 and pwi.warehouse_id = 42 and pwi.product_id not in (238852, 238893, 238912, 238950, 238892, 238904, 238902, 238875);
Date: 2024-01-21 11:21:10 Duration: 195ms
11 231 35s571ms 148ms 198ms 153ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 21 10 55 8s448ms 153ms 11 176 27s122ms 154ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3091 and pwi.warehouse_id = 41;
Date: 2024-01-21 11:09:21 Duration: 198ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3036 and pwi.warehouse_id = 41;
Date: 2024-01-21 11:12:42 Duration: 186ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3106 and pwi.warehouse_id = 45;
Date: 2024-01-21 11:42:30 Duration: 184ms
12 126 1m15s 144ms 1s121ms 597ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 21 15 15 8s953ms 596ms 16 111 1m6s 597ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 48, 1, '2024-01-25 16:46:29.295215', 45, 211027, false, 461, 468, 'new_product', '13-T/INT/12973', '13-T/INT/12973', 324987, 357, '0', 'make_to_stock', 238952, 1, '4.00', true, 10, 40, 'waiting', 9139, 45) RETURNING id;
Date: 2024-01-21 16:46:36 Duration: 1s121ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-23 16:34:35.633714', 41, 211021, false, 429, 468, 'new_product', '09-B/INT/10091', '09-B/INT/10091', 324981, 325, '0', 'make_to_stock', 238906, 1, '5.00', true, 10, 40, 'waiting', 9119, 41) RETURNING id;
Date: 2024-01-21 16:34:39 Duration: 1s88ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 56, 1, '2024-01-21 16:49:21', 46, 211029, false, 487, 468, 'new_product', '14-D/INT/01649', '14-D/INT/01649', 324989, 367, '0', 'make_to_stock', 238919, 1, '15.00', true, 10, 40, 'waiting', 9146, 46) RETURNING id;
Date: 2024-01-21 16:49:22 Duration: 1s87ms
13 107 21s771ms 120ms 408ms 203ms select "forecasted_data".id from "forecasted_data" where ("forecasted_data"."item_supply_plan_id" in (...)) order by "forecasted_data"."id";Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jan 21 10 1 159ms 159ms 11 3 577ms 192ms 15 2 249ms 124ms 16 101 20s784ms 205ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33677, 32897)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:11:03 Duration: 408ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33364, 33192)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:09:17 Duration: 384ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33660, 33025)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:11:03 Duration: 368ms
14 99 27s992ms 277ms 359ms 282ms 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 #14
Day Hour Count Duration Avg duration Jan 21 05 18 5s182ms 287ms 06 39 10s941ms 280ms 07 9 2s520ms 280ms 16 3 863ms 287ms 19 12 3s378ms 281ms 23 18 5s105ms 283ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:47:21 Duration: 359ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:47:22 Duration: 308ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:50:31 Duration: 296ms
15 95 17s742ms 137ms 445ms 186ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 21 15 16 2s444ms 152ms 16 78 15s148ms 194ms 20 1 149ms 149ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2933, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '10-I/INT/21753', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775441, 775445, 775437);
Date: 2024-01-21 16:38:28 Duration: 445ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2933, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '13-T/INT/12973', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775496, 775507, 775500);
Date: 2024-01-21 16:46:55 Duration: 436ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2931, "is_done" = false, "picking_code" = 'internal', "product_qty" = 4.0, "reference" = '07-L/INT/04230', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775452, 775460);
Date: 2024-01-21 16:43:30 Duration: 312ms
16 91 12s862ms 125ms 185ms 141ms select "account_move".id from "account_move" where (("account_move"."edi_810_id" in (...)) and (("account_move"."id" not in (...)) or "account_move"."id" is null)) order by "account_move"."invoice_date_due";Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 21 03 30 4s248ms 141ms 07 31 4s300ms 138ms 23 30 4s314ms 143ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (44067)) AND (("account_move"."id" not in (1024588, 1065137)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-21 23:49:19 Duration: 185ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (42029)) AND (("account_move"."id" not in (1055628, 1123141)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-21 03:18:17 Duration: 167ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."edi_810_id" in (38347)) AND (("account_move"."id" not in (1144934)) OR "account_move"."id" IS NULL)) ORDER BY "account_move"."invoice_date_due";
Date: 2024-01-21 03:06:17 Duration: 165ms
17 77 14s340ms 146ms 324ms 186ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 21 15 11 2s135ms 194ms 16 66 12s205ms 184ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 46, 1, '2024-01-25 16:43:10.183087', 43, 211025, true, 445, 468, 'new_product', '11-N/INT/21538', '11-N/INT/21538', 324985, 341, '0', 'make_to_stock', 237202, 1, '4.00', true, 10, 40, 'waiting', 9128, 43) RETURNING id;
Date: 2024-01-21 16:43:15 Duration: 324ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 46, 1, '2024-01-25 16:43:10.183087', 43, 211025, true, 445, 468, 'new_product', '11-N/INT/21538', '11-N/INT/21538', 324985, 341, '0', 'make_to_stock', 237221, 1, '2.00', true, 10, 40, 'waiting', 9130, 43) RETURNING id;
Date: 2024-01-21 16:43:13 Duration: 314ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 38, 1, '2024-01-22 16:24:23.576952', 36, 211015, true, 389, 468, 'new_product', '03-C/INT/15917', '03-C/INT/15917', 324975, 285, '0', 'make_to_stock', 237202, 1, '20.00', true, 10, 40, 'waiting', 9101, 36) RETURNING id;
Date: 2024-01-21 16:24:28 Duration: 309ms
18 61 11s931ms 140ms 352ms 195ms update "stock_move" set "sm_line_id" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 21 15 8 1s682ms 210ms 16 53 10s248ms 193ms -
UPDATE "stock_move" SET "sm_line_id" = 775447, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775448);
Date: 2024-01-21 16:43:22 Duration: 352ms
-
UPDATE "stock_move" SET "sm_line_id" = 775451, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775452);
Date: 2024-01-21 16:43:23 Duration: 318ms
-
UPDATE "stock_move" SET "sm_line_id" = 775385, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775386);
Date: 2024-01-21 16:31:23 Duration: 315ms
19 47 30s317ms 620ms 759ms 645ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 21 20 47 30s317ms 645ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4494973%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%449-4973%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%449-4973%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:49:30 Duration: 759ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:22 Duration: 707ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:14 Duration: 702ms
20 37 47s479ms 146ms 6s405ms 1s283ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 21 15 5 5s602ms 1s120ms 16 23 39s271ms 1s707ms 20 9 2s604ms 289ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775488, 775490, 775492, 775494, 775475, 775477, 775479, 775481, 775482, 775484, 775486);
Date: 2024-01-21 16:46:53 Duration: 6s405ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775457, 775459, 775447, 775449, 775451, 775453, 775455);
Date: 2024-01-21 16:43:29 Duration: 4s130ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775403, 775405, 775407, 775409, 775411, 775413);
Date: 2024-01-21 16:34:49 Duration: 3s569ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m50s 3m50s 3m50s 1 3m50s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jan 21 09 1 3m50s 3m50s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2024-01-21 09:08:38 Duration: 3m50s
2 1m37s 1m37s 1m37s 1 1m37s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jan 21 09 1 1m37s 1m37s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2024-01-21 09:03:07 Duration: 1m37s
3 1m32s 1m32s 1m32s 1 1m32s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jan 21 09 1 1m32s 1m32s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2024-01-21 09:04:47 Duration: 1m32s
4 1m3s 1m3s 1m3s 1 1m3s copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jan 21 09 1 1m3s 1m3s -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2024-01-21 09:12:20 Duration: 1m3s
5 40s481ms 40s481ms 40s481ms 1 40s481ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jan 21 09 1 40s481ms 40s481ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2024-01-21 09:11:17 Duration: 40s481ms
6 4s357ms 11s212ms 7s742ms 4 30s971ms delete from account_move_line where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jan 21 03 1 4s357ms 4s357ms 07 1 11s212ms 11s212ms 23 2 15s402ms 7s701ms -
DELETE FROM account_move_line WHERE id IN (4040125, 4040126, 4040127, 4040128, 4040129, 4040130, 4040131, 4040132);
Date: 2024-01-21 07:06:37 Duration: 11s212ms
-
DELETE FROM account_move_line WHERE id IN (4040135, 4040136, 4040137, 4040138, 4040139, 4040140, 4040141, 4040142);
Date: 2024-01-21 23:07:35 Duration: 11s44ms
-
DELETE FROM account_move_line WHERE id IN (4040120, 4040121, 4040122);
Date: 2024-01-21 03:12:17 Duration: 4s357ms
7 146ms 6s405ms 1s283ms 37 47s479ms 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 Jan 21 15 5 5s602ms 1s120ms 16 23 39s271ms 1s707ms 20 9 2s604ms 289ms -
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775488, 775490, 775492, 775494, 775475, 775477, 775479, 775481, 775482, 775484, 775486);
Date: 2024-01-21 16:46:53 Duration: 6s405ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775457, 775459, 775447, 775449, 775451, 775453, 775455);
Date: 2024-01-21 16:43:29 Duration: 4s130ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775403, 775405, 775407, 775409, 775411, 775413);
Date: 2024-01-21 16:34:49 Duration: 3s569ms
8 620ms 759ms 645ms 47 30s317ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where ((("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and ("product_product__product_tmpl_id"."sale_ok" is not null and "product_product__product_tmpl_id"."sale_ok" != false)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jan 21 20 47 30s317ms 645ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%4494973%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%449-4973%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%449-4973%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:49:30 Duration: 759ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:22 Duration: 707ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE ((("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%a4707q%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%a4707q%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%a4707q%'))) AND ("product_product__product_tmpl_id"."sale_ok" IS NOT NULL and "product_product__product_tmpl_id"."sale_ok" != false)) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2024-01-21 20:47:14 Duration: 702ms
9 144ms 1s121ms 597ms 126 1m15s insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jan 21 15 15 8s953ms 596ms 16 111 1m6s 597ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 48, 1, '2024-01-25 16:46:29.295215', 45, 211027, false, 461, 468, 'new_product', '13-T/INT/12973', '13-T/INT/12973', 324987, 357, '0', 'make_to_stock', 238952, 1, '4.00', true, 10, 40, 'waiting', 9139, 45) RETURNING id;
Date: 2024-01-21 16:46:36 Duration: 1s121ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 44, 1, '2024-01-23 16:34:35.633714', 41, 211021, false, 429, 468, 'new_product', '09-B/INT/10091', '09-B/INT/10091', 324981, 325, '0', 'make_to_stock', 238906, 1, '5.00', true, 10, 40, 'waiting', 9119, 41) RETURNING id;
Date: 2024-01-21 16:34:39 Duration: 1s88ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 56, 1, '2024-01-21 16:49:21', 46, 211029, false, 487, 468, 'new_product', '14-D/INT/01649', '14-D/INT/01649', 324989, 367, '0', 'make_to_stock', 238919, 1, '15.00', true, 10, 40, 'waiting', 9146, 46) RETURNING id;
Date: 2024-01-21 16:49:22 Duration: 1s87ms
10 345ms 607ms 359ms 523 3m7s select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pt.min_product_uom_qty > ? and pwi.stocking_flag = true and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) <= ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, abs(((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?))) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < ? and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = true and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false union all select pwi.product_id, coalesce(pwi.qty_on_perm_order, ?) as min_product_uom_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where pt.is_core = false and pwi.stocking_flag = true and coalesce(pwi.qty_on_perm_order, ?) > ? and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - (coalesce(pwi.qty_reserve, ?) + coalesce(pwi.qty_on_perm_order, ?))) < ? and pt.discontinued = false and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ? and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jan 21 10 143 51s281ms 358ms 11 377 2m15s 359ms 16 3 1s67ms 355ms -
select pwi.product_id, pt.min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pt.min_product_uom_qty > 0 and pwi.stocking_flag = True and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) <= 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 41 and pwi.inventory_vendor_id = 2970 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:08:32 Duration: 607ms
-
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 = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2982 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 11:46:22 Duration: 487ms
-
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 = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 36 and pwi.inventory_vendor_id = 3078 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2024-01-21 10:47:23 Duration: 480ms
11 318ms 580ms 329ms 19,188 1h45m25s select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jan 21 07 249 1m21s 328ms 08 1,348 7m24s 329ms 09 1,027 5m40s 331ms 10 165 56s779ms 344ms 11 1,157 6m33s 340ms 12 1,330 7m16s 328ms 13 1,409 7m43s 329ms 14 1,271 6m57s 328ms 15 1,500 8m15s 330ms 16 1,211 6m39s 329ms 17 1,202 6m34s 328ms 18 1,241 6m48s 329ms 19 1,220 6m40s 328ms 20 1,205 6m35s 328ms 21 1,214 6m38s 328ms 22 1,250 6m48s 326ms 23 1,189 6m30s 328ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 16:51:36 Duration: 580ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-a54df00/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 11:02:38 Duration: 547ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2024-01-21 09:00:46 Duration: 547ms
12 273ms 431ms 285ms 788 3m45s select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jan 21 07 12 3s421ms 285ms 08 99 28s454ms 287ms 09 42 11s867ms 282ms 10 30 8s564ms 285ms 11 48 14s306ms 298ms 12 66 18s923ms 286ms 13 45 12s746ms 283ms 14 42 12s39ms 286ms 15 27 7s605ms 281ms 16 12 3s379ms 281ms 17 51 14s531ms 284ms 18 30 8s603ms 286ms 19 53 14s996ms 282ms 20 66 18s826ms 285ms 21 48 13s674ms 284ms 22 63 17s993ms 285ms 23 54 15s277ms 282ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 08:34:03 Duration: 431ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 20:33:32 Duration: 419ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2024-01-21 14:49:12 Duration: 408ms
13 277ms 359ms 282ms 99 27s992ms 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 #13
Day Hour Count Duration Avg duration Jan 21 05 18 5s182ms 287ms 06 39 10s941ms 280ms 07 9 2s520ms 280ms 16 3 863ms 287ms 19 12 3s378ms 281ms 23 18 5s105ms 283ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:47:21 Duration: 359ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:47:22 Duration: 308ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2024-01-21 05:50:31 Duration: 296ms
14 120ms 408ms 203ms 107 21s771ms select "forecasted_data".id from "forecasted_data" where ("forecasted_data"."item_supply_plan_id" in (...)) order by "forecasted_data"."id";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jan 21 10 1 159ms 159ms 11 3 577ms 192ms 15 2 249ms 124ms 16 101 20s784ms 205ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33677, 32897)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:11:03 Duration: 408ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33364, 33192)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:09:17 Duration: 384ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (33660, 33025)) ORDER BY "forecasted_data"."id";
Date: 2024-01-21 16:11:03 Duration: 368ms
15 140ms 352ms 195ms 61 11s931ms update "stock_move" set "sm_line_id" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jan 21 15 8 1s682ms 210ms 16 53 10s248ms 193ms -
UPDATE "stock_move" SET "sm_line_id" = 775447, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775448);
Date: 2024-01-21 16:43:22 Duration: 352ms
-
UPDATE "stock_move" SET "sm_line_id" = 775451, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775452);
Date: 2024-01-21 16:43:23 Duration: 318ms
-
UPDATE "stock_move" SET "sm_line_id" = 775385, "state" = 'assigned', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775386);
Date: 2024-01-21 16:31:23 Duration: 315ms
16 137ms 445ms 186ms 95 17s742ms update "stock_move" set "delay_alert_date" = ?, "inventory_vendor_id" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jan 21 15 16 2s444ms 152ms 16 78 15s148ms 194ms 20 1 149ms 149ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2933, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '10-I/INT/21753', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775441, 775445, 775437);
Date: 2024-01-21 16:38:28 Duration: 445ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2933, "is_done" = false, "picking_code" = 'internal', "product_qty" = 2.0, "reference" = '13-T/INT/12973', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775496, 775507, 775500);
Date: 2024-01-21 16:46:55 Duration: 436ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "inventory_vendor_id" = 2931, "is_done" = false, "picking_code" = 'internal', "product_qty" = 4.0, "reference" = '07-L/INT/04230', "scrapped" = false, "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (775452, 775460);
Date: 2024-01-21 16:43:30 Duration: 312ms
17 146ms 324ms 186ms 77 14s340ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jan 21 15 11 2s135ms 194ms 16 66 12s205ms 184ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 46, 1, '2024-01-25 16:43:10.183087', 43, 211025, true, 445, 468, 'new_product', '11-N/INT/21538', '11-N/INT/21538', 324985, 341, '0', 'make_to_stock', 237202, 1, '4.00', true, 10, 40, 'waiting', 9128, 43) RETURNING id;
Date: 2024-01-21 16:43:15 Duration: 324ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 46, 1, '2024-01-25 16:43:10.183087', 43, 211025, true, 445, 468, 'new_product', '11-N/INT/21538', '11-N/INT/21538', 324985, 341, '0', 'make_to_stock', 237221, 1, '2.00', true, 10, 40, 'waiting', 9130, 43) RETURNING id;
Date: 2024-01-21 16:43:13 Duration: 314ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "transfer_line_id", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 996, (now() at time zone 'UTC'), 996, (now() at time zone 'UTC'), false, NULL, 38, 1, '2024-01-22 16:24:23.576952', 36, 211015, true, 389, 468, 'new_product', '03-C/INT/15917', '03-C/INT/15917', 324975, 285, '0', 'make_to_stock', 237202, 1, '20.00', true, 10, 40, 'waiting', 9101, 36) RETURNING id;
Date: 2024-01-21 16:24:28 Duration: 309ms
18 147ms 258ms 165ms 523 1m26s select pwi.product_id, coalesce(pwi.lead_days, ?), coalesce(pwi.min_product_uom_qty, ?) as min_qty, coalesce(pwi.max_product_uom_qty, ?) as max_qty, coalesce(pwi.max_product_uom_qty, ?) - ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) as need_qty from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pt.is_core, false) = false and coalesce(pwi.stocking_flag, false) = true and coalesce(pt.discontinued, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and ((coalesce(pwi.qty_available, ?) + coalesce(pwi.qty_on_order, ?)) - coalesce(pwi.qty_reserve, ?)) < coalesce(pwi.max_product_uom_qty, ?) and pwi.warehouse_id = ? and pwi.inventory_vendor_id = ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jan 21 10 143 23s659ms 165ms 11 377 1m2s 165ms 16 3 483ms 161ms -
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 37 and pwi.inventory_vendor_id = 2954;
Date: 2024-01-21 11:00:06 Duration: 258ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 46 and pwi.inventory_vendor_id = 2994;
Date: 2024-01-21 11:47:12 Duration: 217ms
-
select pwi.product_id, COALESCE(pwi.lead_days, 7), COALESCE(pwi.min_product_uom_qty, 0) as min_qty, COALESCE(pwi.max_product_uom_qty, 0) as max_qty, COALESCE(pwi.max_product_uom_qty, 0) - ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) as need_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pt.is_core, False) = False and COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < COALESCE(pwi.max_product_uom_qty, 0) and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2983;
Date: 2024-01-21 11:44:12 Duration: 203ms
19 120ms 502ms 163ms 5,111 13m54s select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jan 21 00 42 11s666ms 277ms 01 135 29s867ms 221ms 02 89 24s219ms 272ms 03 73 16s506ms 226ms 04 63 15s597ms 247ms 05 103 21s448ms 208ms 06 74 12s325ms 166ms 07 43 8s744ms 203ms 08 424 1m8s 161ms 09 352 46s905ms 133ms 10 328 51s84ms 155ms 11 891 2m2s 137ms 12 138 22s498ms 163ms 13 250 38s68ms 152ms 14 190 31s349ms 164ms 15 268 40s602ms 151ms 16 156 25s63ms 160ms 17 325 56s208ms 172ms 18 192 26s645ms 138ms 19 180 31s323ms 174ms 20 360 58s551ms 162ms 21 231 42s943ms 185ms 22 112 19s346ms 172ms 23 92 12s902ms 140ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 21:58:35') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_969"', '["pointspring_master","calendar.alarm",19507]', '["pointspring_master","mail.channel",78]', '["pointspring_master","mail.channel",79]', '["pointspring_master","mail.channel",80]', '["pointspring_master","mail.channel",81]', '["pointspring_master","mail.channel",82]', '["pointspring_master","mail.channel",527]', '["pointspring_master","res.partner",19507]', '["pointspring_master","ir.needaction",19507]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 21:59:26 Duration: 502ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 02:37:48') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1235"'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 02:38:39 Duration: 498ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-01-21 16:08:27') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1015"', '["pointspring_master","calendar.alarm",19553]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",346]', '["pointspring_master","mail.channel",347]', '["pointspring_master","mail.channel",457]', '["pointspring_master","res.partner",19553]', '["pointspring_master","ir.needaction",19553]'))) ORDER BY "bus_bus"."id";
Date: 2024-01-21 16:09:17 Duration: 482ms
20 148ms 198ms 156ms 289 45s104ms select pwi.product_id from product_warehouse_inventory pwi left join product_product as pp on pwi.product_id = pp.id left join product_template as pt on pt.id = pp.product_tmpl_id where coalesce(pwi.stocking_flag, false) = true and coalesce(pt.is_core, false) = false and coalesce(pt.discontinued, false) = false and coalesce(pt.never_stock, false) = false and coalesce(pt.superceded, false) = false and coalesce(pt.obsolete, false) = false and pwi.inventory_vendor_id = ? and pwi.warehouse_id = ? and pwi.product_id not in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jan 21 10 88 13s674ms 155ms 11 201 31s430ms 156ms -
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3045 and pwi.warehouse_id = 36 and pwi.product_id not in (177742);
Date: 2024-01-21 10:52:07 Duration: 198ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 3035 and pwi.warehouse_id = 45 and pwi.product_id not in (254211, 252378, 172567, 172224, 172212, 172061, 172038, 171754, 171752, 171772, 171996);
Date: 2024-01-21 11:36:17 Duration: 196ms
-
select pwi.product_id from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where COALESCE(pwi.stocking_flag, False) = True and COALESCE(pt.is_core, False) = False and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False and pwi.inventory_vendor_id = 2933 and pwi.warehouse_id = 42 and pwi.product_id not in (238852, 238893, 238912, 238950, 238892, 238904, 238902, 238875);
Date: 2024-01-21 11:21:10 Duration: 195ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 48,713 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 4921 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 4,331 Max number of times the same event was reported
- 4,921 Total events found
Rank Times reported Error 1 4,331 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #1
Day Hour Count Jan 21 06 3 07 66 08 362 09 239 10 35 11 230 12 322 13 334 14 277 15 407 16 259 17 272 18 247 19 265 20 248 21 272 22 253 23 240 - ERROR: could not serialize access due to concurrent update
Statement: DELETE FROM ir_attachment WHERE id IN ( SELECT id FROM ir_attachment WHERE id in (4696758, 4696757) FOR NO KEY UPDATE SKIP LOCKED )
Date: 2024-01-21 22:50:08
2 518 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #2
Day Hour Count Jan 21 00 19 01 21 02 21 03 20 04 18 05 20 06 23 07 27 08 25 09 26 10 22 11 20 12 17 13 21 14 23 15 21 16 20 17 25 18 28 19 20 20 19 21 21 22 20 23 21 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=67 FOR UPDATE NOWAIT
Date: 2024-01-21 22:50:21
3 72 ERROR: current transaction is aborted, commands ignored until end of transaction block
Times Reported Most Frequent Error / Event #3
Day Hour Count Jan 21 07 2 08 3 09 5 10 4 11 4 12 2 13 4 14 2 15 10 16 5 17 3 18 4 19 6 20 3 21 3 22 6 23 6 - ERROR: current transaction is aborted, commands ignored until end of transaction block
Statement: SELECT "ir_ui_view".id FROM "ir_ui_view" LEFT JOIN "website" AS "ir_ui_view__website_id" ON ("ir_ui_view"."website_id" = "ir_ui_view__website_id"."id") WHERE (("ir_ui_view"."active" = true) AND (("ir_ui_view"."key" = 'http_routing.http_error') AND (("ir_ui_view"."website_id" in (1)) OR "ir_ui_view"."website_id" IS NULL))) ORDER BY "ir_ui_view__website_id"."id" LIMIT 1
Date: 2024-01-21 22:58:21