pgBadger-
Global information
- Generated on Tue Sep 5 23:50:19 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 47,262 log entries in 18s
- Log start from 2023-09-04 00:00:07 to 2023-09-04 23:59:03
-
Overview
Global Stats
- 210 Number of unique normalized queries
- 15,682 Number of queries
- 2h21m1s Total query duration
- 2023-09-04 00:01:01 First query
- 2023-09-04 23:59:03 Last query
- 58 queries/s at 2023-09-04 17:05:41 Query peak
- 2h21m1s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 2h21m1s Execute total duration
- 483 Number of events
- 3 Number of unique normalized events
- 463 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
- 15,682 Average queries per session
- 2h21m1s 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
- 58 queries/s Query Peak
- 2023-09-04 17:05:41 Date
SELECT Traffic
Key values
- 58 queries/s Query Peak
- 2023-09-04 17:05:41 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 5 queries/s Query Peak
- 2023-09-04 18:02:43 Date
Queries duration
Key values
- 2h21m1s 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) Sep 04 00 46 0ms 227ms 181ms 1s526ms 1s532ms 1s532ms 01 78 0ms 276ms 180ms 1s518ms 1s730ms 1s730ms 02 71 0ms 239ms 187ms 1s716ms 3s886ms 3s886ms 03 44 0ms 301ms 193ms 1s574ms 1s740ms 1s740ms 04 69 0ms 908ms 214ms 1s703ms 2s519ms 2s519ms 05 231 0ms 876ms 487ms 13s684ms 13s957ms 16s901ms 06 2,881 120ms 4s632ms 556ms 37s611ms 38s951ms 1m 07 3,333 120ms 18s126ms 561ms 38s339ms 40s238ms 43s58ms 08 3,464 120ms 2s79ms 558ms 38s44ms 39s282ms 41s793ms 09 2,954 120ms 3m48s 743ms 1m12s 1m53s 4m27s 10 198 0ms 2s917ms 324ms 4s460ms 4s733ms 6s688ms 11 73 0ms 276ms 179ms 1s638ms 1s640ms 1s760ms 12 71 0ms 277ms 194ms 1s511ms 2s932ms 2s932ms 13 56 0ms 215ms 179ms 1s507ms 1s652ms 1s652ms 14 54 0ms 223ms 181ms 1s683ms 3s78ms 3s78ms 15 73 0ms 17s967ms 497ms 1s599ms 3s355ms 20s941ms 16 1,196 0ms 3s696ms 218ms 10s719ms 35s38ms 1m32s 17 294 0ms 1s527ms 221ms 2s255ms 8s47ms 28s137ms 18 87 0ms 273ms 211ms 1s951ms 9s125ms 9s125ms 19 34 0ms 903ms 303ms 1s702ms 5s537ms 5s537ms 20 151 0ms 2s963ms 301ms 5s113ms 5s188ms 10s204ms 21 47 0ms 261ms 187ms 1s454ms 1s523ms 1s523ms 22 55 0ms 216ms 169ms 1s506ms 1s538ms 1s538ms 23 122 0ms 17s992ms 950ms 20s706ms 1m19s 1m19s Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 00 46 0 181ms 1s346ms 1s526ms 1s532ms 01 78 0 180ms 1s514ms 1s518ms 1s730ms 02 71 0 187ms 1s552ms 1s716ms 3s886ms 03 44 0 193ms 1s564ms 1s574ms 1s740ms 04 65 0 212ms 1s682ms 1s703ms 2s9ms 05 228 0 490ms 11s1ms 13s684ms 16s901ms 06 2,858 0 559ms 35s784ms 37s491ms 41s105ms 07 3,299 0 559ms 36s287ms 37s579ms 40s118ms 08 3,424 0 563ms 36s476ms 37s785ms 39s743ms 09 2,791 83 760ms 32s659ms 39s927ms 1m33s 10 192 0 325ms 3s195ms 4s309ms 6s532ms 11 73 0 179ms 1s417ms 1s638ms 1s760ms 12 71 0 194ms 1s492ms 1s511ms 2s932ms 13 56 0 179ms 1s480ms 1s507ms 1s652ms 14 54 0 181ms 1s555ms 1s683ms 3s78ms 15 66 0 191ms 1s498ms 1s543ms 1s766ms 16 1,098 0 200ms 5s80ms 8s510ms 1m32s 17 248 0 208ms 1s617ms 2s114ms 28s137ms 18 49 0 188ms 1s505ms 1s508ms 1s951ms 19 34 0 303ms 1s601ms 1s702ms 5s537ms 20 97 0 180ms 1s533ms 1s548ms 3s486ms 21 47 0 187ms 1s324ms 1s454ms 1s523ms 22 55 0 169ms 1s338ms 1s506ms 1s538ms 23 117 0 796ms 1s509ms 1s680ms 1m19s Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Sep 04 00 0 0 0 0 0ms 0ms 0ms 0ms 01 0 0 0 0 0ms 0ms 0ms 0ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 4 0 0 254ms 0ms 0ms 510ms 05 0 3 0 0 266ms 0ms 0ms 495ms 06 0 5 0 0 311ms 0ms 0ms 308ms 07 0 1 4 0 4s604ms 0ms 0ms 326ms 08 0 3 0 0 315ms 0ms 0ms 306ms 09 0 2 0 0 163ms 0ms 0ms 0ms 10 0 2 0 0 505ms 0ms 0ms 389ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 1 2 4 0 3s380ms 0ms 230ms 19s174ms 16 30 68 0 0 428ms 573ms 1s463ms 6s696ms 17 0 46 0 0 287ms 0ms 0ms 4s214ms 18 0 38 0 0 240ms 0ms 0ms 9s125ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 29 25 0 0 520ms 941ms 2s580ms 5s144ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 1 4 0 4s548ms 0ms 0ms 19s199ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Sep 04 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 Sep 04 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 Sep 04 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 Sep 04 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 Sep 04 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) Sep 04 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 Sep 04 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 Sep 04 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 Sep 04 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
- 15,161 Total read queries
- 521 Total write queries
Queries by database
Key values
- unknown Main database
- 15,682 Requests
- 2h21m1s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 15,698 Requests
User Request type Count Duration unknown Total 15,698 2h21m5s copy to 83 10m13s cte 166 23s439ms delete 12 1m7s insert 60 21s35ms select 15,177 2h7m40s update 200 1m18s Duration by user
Key values
- 2h21m5s (unknown) Main time consuming user
User Request type Count Duration unknown Total 15,698 2h21m5s copy to 83 10m13s cte 166 23s439ms delete 12 1m7s insert 60 21s35ms select 15,177 2h7m40s update 200 1m18s Queries by host
Key values
- unknown Main host
- 15,698 Requests
- 2h21m5s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 15,682 Requests
- 2h21m1s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-09-04 10:12:38 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 12,021 500-1000ms duration
Slowest individual queries
Rank Duration Query 1 3m48s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-09-04 09:07:49 ]
2 1m28s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-09-04 09:02:35 ]
3 1m20s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2023-09-04 09:04:00 ]
4 34s521ms COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2023-09-04 09:10:21 ]
5 21s897ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;[ Date: 2023-09-04 09:09:00 ]
6 21s858ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-09-04 09:09:46 ]
7 18s270ms 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) TO stdout;[ Date: 2023-09-04 09:00:30 ]
8 18s126ms DELETE FROM account_move_line WHERE id IN (3059042, 3059043, 3059044, 3059045, 3059046, 3059047, 3059048, 3059049, 3059050, 3059051, 3059052, 3059053, 3059054, 3059055, 3059056, 3059057, 3059058);[ Date: 2023-09-04 07:23:19 ]
9 17s992ms DELETE FROM account_move_line WHERE id IN (3059080, 3059081, 3059082, 3059083, 3059084, 3059085, 3059086, 3059087, 3059088, 3059089, 3059090, 3059091, 3059092, 3059093, 3059094, 3059095, 3059096);[ Date: 2023-09-04 23:23:30 ]
10 17s967ms DELETE FROM account_move_line WHERE id IN (3059061, 3059062, 3059063, 3059064, 3059065, 3059066, 3059067, 3059068, 3059069, 3059070, 3059071, 3059072, 3059073, 3059074, 3059075, 3059076, 3059077);[ Date: 2023-09-04 15:23:37 ]
11 11s559ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-09-04 09:00:48 ]
12 7s467ms 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) TO stdout;[ Date: 2023-09-04 09:00:12 ]
13 6s235ms COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-09-04 09:07:56 ]
14 5s5ms COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core) TO stdout;[ Date: 2023-09-04 09:09:14 ]
15 4s867ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2023-09-04 09:08:02 ]
16 4s758ms COPY public.forecasted_data (id, date, min_product_uom_qty, max_product_uom_qty, item_supply_plan_id, po_qty, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, default_code, ext_cost, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_mtd_sold, lead_days, mon_1_qty, mon_2_qty, mon_3_qty, mon_4_qty, mon_5_qty, mon_6_qty, mon_7_qty, mon_8_qty, mon_9_qty, mon_10_qty, mon_11_qty, mon_12_qty, seasonal, stocking_flag, freeze_date, warehouse_min_product_uom_qty, is_forcast, modify_qty, req_po_qty, supercede_product_id, superceded, final_branch_id, po_id, unit_ext_cost, is_freeze, qty_in_transist, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, is_new_stock_product, ref_id, ref, product_name, is_stock_flag_product) TO stdout;[ Date: 2023-09-04 09:01:01 ]
17 4s632ms select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;[ Date: 2023-09-04 06:00:35 ]
18 4s574ms select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;[ Date: 2023-09-04 06:08:43 ]
19 4s538ms select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;[ Date: 2023-09-04 06:08:19 ]
20 4s286ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-09-04 09:00:53 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 1h47m4s 11,447 512ms 2s79ms 561ms select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 05 112 59s341ms 529ms 06 2,660 24m42s 557ms 07 3,056 28m36s 561ms 08 3,263 30m49s 566ms 09 2,356 21m57s 559ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 172061 and item_demand_plan_id = 3741 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 08:28:19 Duration: 2s79ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 197478 and item_demand_plan_id = 3749 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 07:14:48 Duration: 1s370ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 223270 and item_demand_plan_id = 3750 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 09:44:01 Duration: 1s151ms
2 4m 1,305 120ms 355ms 184ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 00 46 8s358ms 181ms 01 74 13s217ms 178ms 02 71 13s314ms 187ms 03 41 7s615ms 185ms 04 55 9s799ms 178ms 05 45 7s897ms 175ms 06 73 13s593ms 186ms 07 57 10s921ms 191ms 08 55 11s162ms 202ms 09 38 8s153ms 214ms 10 39 6s924ms 177ms 11 60 10s726ms 178ms 12 46 8s374ms 182ms 13 56 10s45ms 179ms 14 54 9s825ms 181ms 15 50 9s324ms 186ms 16 100 19s139ms 191ms 17 61 11s628ms 190ms 18 43 7s861ms 182ms 19 26 4s779ms 183ms 20 57 10s119ms 177ms 21 44 8s40ms 182ms 22 52 8s790ms 169ms 23 62 11s90ms 178ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 17:04:50') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_991"', '["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 17:05:41 Duration: 355ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 09:41:27') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1027"', '["pointspring_master","calendar.alarm",19565]', '["pointspring_master","mail.channel",168]', '["pointspring_master","mail.channel",169]', '["pointspring_master","mail.channel",170]', '["pointspring_master","mail.channel",171]', '["pointspring_master","mail.channel",172]', '["pointspring_master","mail.channel",173]', '["pointspring_master","mail.channel",174]', '["pointspring_master","mail.channel",438]', '["pointspring_master","mail.channel",439]', '["pointspring_master","mail.channel",490]', '["pointspring_master","mail.channel",536]', '["pointspring_master","res.partner",19565]', '["pointspring_master","ir.needaction",19565]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 09:42:17 Duration: 339ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 09:43:11') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_2"', '["pointspring_master","calendar.alarm",3]', '["pointspring_master","mail.channel",2]', '["pointspring_master","mail.channel",3]', '["pointspring_master","mail.channel",6]', '["pointspring_master","mail.channel",17]', '["pointspring_master","mail.channel",18]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",20]', '["pointspring_master","mail.channel",21]', '["pointspring_master","mail.channel",22]', '["pointspring_master","mail.channel",23]', '["pointspring_master","mail.channel",24]', '["pointspring_master","mail.channel",25]', '["pointspring_master","mail.channel",26]', '["pointspring_master","mail.channel",27]', '["pointspring_master","mail.channel",28]', '["pointspring_master","mail.channel",29]', '["pointspring_master","mail.channel",30]', '["pointspring_master","mail.channel",31]', '["pointspring_master","mail.channel",32]', '["pointspring_master","mail.channel",33]', '["pointspring_master","mail.channel",34]', '["pointspring_master","mail.channel",35]', '["pointspring_master","mail.channel",36]', '["pointspring_master","mail.channel",37]', '["pointspring_master","mail.channel",38]', '["pointspring_master","mail.channel",39]', '["pointspring_master","mail.channel",40]', '["pointspring_master","mail.channel",41]', '["pointspring_master","mail.channel",42]', '["pointspring_master","mail.channel",43]', '["pointspring_master","mail.channel",44]', '["pointspring_master","mail.channel",45]', '["pointspring_master","mail.channel",46]', '["pointspring_master","mail.channel",47]', '["pointspring_master","mail.channel",48]', '["pointspring_master","mail.channel",49]', '["pointspring_master","mail.channel",50]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",54]', '["pointspring_master","mail.channel",55]', '["pointspring_master","mail.channel",56]', '["pointspring_master","mail.channel",57]', '["pointspring_master","mail.channel",58]', '["pointspring_master","mail.channel",59]', '["pointspring_master","mail.channel",60]', '["pointspring_master","mail.channel",61]', '["pointspring_master","mail.channel",62]', '["pointspring_master","mail.channel",63]', '["pointspring_master","mail.channel",64]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",67]', '["pointspring_master","mail.channel",68]', '["pointspring_master","mail.channel",69]', '["pointspring_master","mail.channel",70]', '["pointspring_master","mail.channel",71]', '["pointspring_master","mail.channel",72]', '["pointspring_master","mail.channel",73]', '["pointspring_master","mail.channel",74]', '["pointspring_master","mail.channel",75]', '["pointspring_master","mail.channel",76]', '["pointspring_master","mail.channel",77]', '["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",83]', '["pointspring_master","mail.channel",84]', '["pointspring_master","mail.channel",85]', '["pointspring_master","mail.channel",86]', '["pointspring_master","mail.channel",87]', '["pointspring_master","mail.channel",88]', '["pointspring_master","mail.channel",89]', '["pointspring_master","mail.channel",90]', '["pointspring_master","mail.channel",91]', '["pointspring_master","mail.channel",92]', '["pointspring_master","mail.channel",93]', '["pointspring_master","mail.channel",94]', '["pointspring_master","mail.channel",95]', '["pointspring_master","mail.channel",96]', '["pointspring_master","mail.channel",97]', '["pointspring_master","mail.channel",98]', '["pointspring_master","mail.channel",99]', '["pointspring_master","mail.channel",100]', '["pointspring_master","mail.channel",101]', '["pointspring_master","mail.channel",102]', '["pointspring_master","mail.channel",103]', '["pointspring_master","mail.channel",104]', '["pointspring_master","mail.channel",105]', '["pointspring_master","mail.channel",106]', '["pointspring_master","mail.channel",107]', '["pointspring_master","mail.channel",108]', '["pointspring_master","mail.channel",109]', '["pointspring_master","mail.channel",110]', '["pointspring_master","mail.channel",111]', '["pointspring_master","mail.channel",112]', '["pointspring_master","mail.channel",113]', '["pointspring_master","mail.channel",114]', '["pointspring_master","mail.channel",115]', '["pointspring_master","mail.channel",116]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",121]', '["pointspring_master","mail.channel",122]', '["pointspring_master","mail.channel",123]', '["pointspring_master","mail.channel",124]', '["pointspring_master","mail.channel",125]', '["pointspring_master","mail.channel",126]', '["pointspring_master","mail.channel",127]', '["pointspring_master","mail.channel",128]', '["pointspring_master","mail.channel",129]', '["pointspring_master","mail.channel",130]', '["pointspring_master","mail.channel",131]', '["pointspring_master","mail.channel",132]', '["pointspring_master","mail.channel",133]', '["pointspring_master","mail.channel",134]', '["pointspring_master","mail.channel",135]', '["pointspring_master","mail.channel",136]', '["pointspring_master","mail.channel",137]', '["pointspring_master","mail.channel",138]', '["pointspring_master","mail.channel",139]', '["pointspring_master","mail.channel",141]', '["pointspring_master","mail.channel",142]', '["pointspring_master","mail.channel",143]', '["pointspring_master","mail.channel",144]', '["pointspring_master","mail.channel",145]', '["pointspring_master","mail.channel",146]', '["pointspring_master","mail.channel",147]', '["pointspring_master","mail.channel",148]', '["pointspring_master","mail.channel",149]', '["pointspring_master","mail.channel",150]', '["pointspring_master","mail.channel",151]', '["pointspring_master","mail.channel",152]', '["pointspring_master","mail.channel",153]', '["pointspring_master","mail.channel",154]', '["pointspring_master","mail.channel",155]', '["pointspring_master","mail.channel",156]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",161]', '["pointspring_master","mail.channel",162]', '["pointspring_master","mail.channel",163]', '["pointspring_master","mail.channel",164]', '["pointspring_master","mail.channel",165]', '["pointspring_master","mail.channel",166]', '["pointspring_master","mail.channel",167]', '["pointspring_master","mail.channel",168]', '["pointspring_master","mail.channel",169]', '["pointspring_master","mail.channel",170]', '["pointspring_master","mail.channel",171]', '["pointspring_master","mail.channel",172]', '["pointspring_master","mail.channel",173]', '["pointspring_master","mail.channel",174]', '["pointspring_master","mail.channel",175]', '["pointspring_master","mail.channel",176]', '["pointspring_master","mail.channel",177]', '["pointspring_master","mail.channel",178]', '["pointspring_master","mail.channel",179]', '["pointspring_master","mail.channel",180]', '["pointspring_master","mail.channel",181]', '["pointspring_master","mail.channel",182]', '["pointspring_master","mail.channel",183]', '["pointspring_master","mail.channel",184]', '["pointspring_master","mail.channel",185]', '["pointspring_master","mail.channel",186]', '["pointspring_master","mail.channel",187]', '["pointspring_master","mail.channel",188]', '["pointspring_master","mail.channel",189]', '["pointspring_master","mail.channel",190]', '["pointspring_master","mail.channel",191]', '["pointspring_master","mail.channel",192]', '["pointspring_master","mail.channel",193]', '["pointspring_master","mail.channel",194]', '["pointspring_master","mail.channel",195]', '["pointspring_master","mail.channel",196]', '["pointspring_master","mail.channel",197]', '["pointspring_master","mail.channel",198]', '["pointspring_master","mail.channel",199]', '["pointspring_master","mail.channel",200]', '["pointspring_master","mail.channel",201]', '["pointspring_master","mail.channel",202]', '["pointspring_master","mail.channel",234]', '["pointspring_master","mail.channel",235]', '["pointspring_master","mail.channel",236]', '["pointspring_master","mail.channel",237]', '["pointspring_master","mail.channel",238]', '["pointspring_master","mail.channel",239]', '["pointspring_master","mail.channel",240]', '["pointspring_master","mail.channel",241]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",243]', '["pointspring_master","mail.channel",244]', '["pointspring_master","mail.channel",245]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",318]', '["pointspring_master","mail.channel",319]', '["pointspring_master","mail.channel",320]', '["pointspring_master","mail.channel",321]', '["pointspring_master","mail.channel",322]', '["pointspring_master","mail.channel",323]', '["pointspring_master","mail.channel",324]', '["pointspring_master","mail.channel",325]', '["pointspring_master","mail.channel",326]', '["pointspring_master","mail.channel",327]', '["pointspring_master","mail.channel",328]', '["pointspring_master","mail.channel",331]', '["pointspring_master","mail.channel",332]', '["pointspring_master","mail.channel",333]', '["pointspring_master","mail.channel",334]', '["pointspring_master","mail.channel",335]', '["pointspring_master","mail.channel",345]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",445]', '["pointspring_master","mail.channel",446]', '["pointspring_master","mail.channel",447]', '["pointspring_master","mail.channel",492]', '["pointspring_master","mail.channel",493]', '["pointspring_master","mail.channel",494]', '["pointspring_master","res.partner",3]', '["pointspring_master","ir.needaction",3]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 09:44:01 Duration: 331ms
3 3m48s 1 3m48s 3m48s 3m48s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Sep 04 09 1 3m48s 3m48s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-09-04 09:07:49 Duration: 3m48s
4 2m29s 148 781ms 1s959ms 1s10ms select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Sep 04 05 15 12s376ms 825ms 06 21 23s17ms 1s96ms 07 29 31s6ms 1s69ms 08 15 14s188ms 945ms 09 65 1m6s 1s21ms 10 3 2s627ms 875ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3741 and active = True;
Date: 2023-09-04 06:52:46 Duration: 1s959ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3749 and active = True;
Date: 2023-09-04 07:14:46 Duration: 1s745ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3751 and active = True;
Date: 2023-09-04 07:03:56 Duration: 1s726ms
5 2m2s 152 661ms 1s447ms 805ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 05 15 10s337ms 689ms 06 21 16s480ms 784ms 07 29 25s245ms 870ms 08 15 12s62ms 804ms 09 67 54s682ms 816ms 10 5 3s571ms 714ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3741 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:57 Duration: 1s447ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3751 and ill.method not in (8, 7);
Date: 2023-09-04 07:14:48 Duration: 1s329ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3749 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:58 Duration: 1s247ms
6 1m53s 148 619ms 1s258ms 767ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true and ill.item_demand_plan_id = ? group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 05 15 9s488ms 632ms 06 21 17s558ms 836ms 07 25 21s104ms 844ms 08 15 10s944ms 729ms 09 67 51s310ms 765ms 10 5 3s188ms 637ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 07:03:57 Duration: 1s258ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3741 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 09:31:58 Duration: 1s256ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 06:52:46 Duration: 1s242ms
7 1m35s 152 482ms 3s77ms 630ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 05 15 7s647ms 509ms 06 21 16s31ms 763ms 07 29 19s824ms 683ms 08 15 8s551ms 570ms 09 67 40s955ms 611ms 10 5 2s809ms 561ms -
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 06:52:48 Duration: 3s77ms
-
select count(id) from item_list_line where item_demand_plan_id = 3741;
Date: 2023-09-04 07:14:47 Duration: 1s378ms
-
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 07:03:58 Duration: 1s270ms
8 1m35s 496 120ms 366ms 192ms 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 #8
Day Hour Count Duration Avg duration Sep 04 16 403 1m17s 191ms 17 73 14s886ms 203ms 20 20 3s435ms 171ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23900, 23687, 23249)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:51 Duration: 366ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23731, 23415)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:51 Duration: 333ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23798, 22807)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:52 Duration: 324ms
9 1m28s 1 1m28s 1m28s 1m28s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 09 1 1m28s 1m28s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-09-04 09:02:35 Duration: 1m28s
10 1m20s 1 1m20s 1m20s 1m20s 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 #10
Day Hour Count Duration Avg duration Sep 04 09 1 1m20s 1m20s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-09-04 09:04:00 Duration: 1m20s
11 1m9s 305 181ms 330ms 228ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 16 305 1m9s 228ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:44:19 Duration: 330ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:28:59 Duration: 327ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:28:59 Duration: 326ms
12 1m2s 349 120ms 319ms 178ms 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 #12
Day Hour Count Duration Avg duration Sep 04 08 1 120ms 120ms 09 2 258ms 129ms 16 265 47s551ms 179ms 17 71 13s29ms 183ms 20 10 1s464ms 146ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (209612, 209706, 209805, 209879)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 17:05:40 Duration: 319ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (190526, 190550, 190567)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 16:58:55 Duration: 307ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (210734, 210735, 210715, 210946, 210885)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 17:05:42 Duration: 305ms
13 1m 6 2s127ms 18s126ms 10s84ms delete from account_move_line where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 07 2 20s254ms 10s127ms 15 2 20s112ms 10s56ms 23 2 20s138ms 10s69ms -
DELETE FROM account_move_line WHERE id IN (3059042, 3059043, 3059044, 3059045, 3059046, 3059047, 3059048, 3059049, 3059050, 3059051, 3059052, 3059053, 3059054, 3059055, 3059056, 3059057, 3059058);
Date: 2023-09-04 07:23:19 Duration: 18s126ms
-
DELETE FROM account_move_line WHERE id IN (3059080, 3059081, 3059082, 3059083, 3059084, 3059085, 3059086, 3059087, 3059088, 3059089, 3059090, 3059091, 3059092, 3059093, 3059094, 3059095, 3059096);
Date: 2023-09-04 23:23:30 Duration: 17s992ms
-
DELETE FROM account_move_line WHERE id IN (3059061, 3059062, 3059063, 3059064, 3059065, 3059066, 3059067, 3059068, 3059069, 3059070, 3059071, 3059072, 3059073, 3059074, 3059075, 3059076, 3059077);
Date: 2023-09-04 15:23:37 Duration: 17s967ms
14 48s964ms 173 258ms 418ms 283ms 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 #14
Day Hour Count Duration Avg duration Sep 04 08 22 6s381ms 290ms 09 49 15s168ms 309ms 10 84 22s100ms 263ms 17 18 5s314ms 295ms -
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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:10 Duration: 418ms
-
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 = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 08:58:25 Duration: 412ms
-
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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:02 Duration: 409ms
15 34s521ms 1 34s521ms 34s521ms 34s521ms copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 09 1 34s521ms 34s521ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-09-04 09:10:21 Duration: 34s521ms
16 33s530ms 42 187ms 3s696ms 798ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 15 1 445ms 445ms 16 26 21s623ms 831ms 17 2 851ms 425ms 20 13 10s610ms 816ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570321, 570322, 570323, 570324, 570325, 570326, 570327);
Date: 2023-09-04 16:26:50 Duration: 3s696ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570307, 570308, 570309, 570310, 570311, 570312, 570313);
Date: 2023-09-04 16:17:14 Duration: 3s546ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (570497, 570481, 570483, 570485, 570487, 570489, 570491, 570493, 570495);
Date: 2023-09-04 20:42:36 Duration: 2s963ms
17 23s3ms 13 859ms 4s632ms 1s769ms select distinct idp.id as item_demand_plan_id from item_demand_plan idp left join item_list_line as ill on idp.id = ill.item_demand_plan_id left join forecasted_data as fd on idp.id = fd.item_demand_plan_id where idp.fetch_data_done = true and idp.active = true and idp.create_date > current_timestamp - interval ? and ill.method not in (...) and idp.id not in ( select item_demand_plan_id from item_list_line where coalesce(method, ?) = ?) and fd.id is null group by idp.id, ill.method;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 04 2 1s785ms 892ms 05 2 1s736ms 868ms 06 5 15s684ms 3s136ms 07 1 1s1ms 1s1ms 08 3 2s795ms 931ms -
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:00:35 Duration: 4s632ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:08:43 Duration: 4s574ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:08:19 Duration: 4s538ms
18 22s148ms 12 1s818ms 1s866ms 1s845ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 23 12 22s148ms 1s845ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tubing%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tubing%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tubing%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tubing%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tubing%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tubing%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:27 Duration: 1s866ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%exhaust%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%exhaust%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%exhaust%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%exhaust%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%exhaust%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%exhaust%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:46 Duration: 1s865ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tubi%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tubi%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tubi%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tubi%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tubi%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tubi%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:26 Duration: 1s864ms
19 21s897ms 1 21s897ms 21s897ms 21s897ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Sep 04 09 1 21s897ms 21s897ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;
Date: 2023-09-04 09:09:00 Duration: 21s897ms
20 21s858ms 1 21s858ms 21s858ms 21s858ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 09 1 21s858ms 21s858ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-09-04 09:09:46 Duration: 21s858ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 11,447 1h47m4s 512ms 2s79ms 561ms select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Sep 04 05 112 59s341ms 529ms 06 2,660 24m42s 557ms 07 3,056 28m36s 561ms 08 3,263 30m49s 566ms 09 2,356 21m57s 559ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 172061 and item_demand_plan_id = 3741 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 08:28:19 Duration: 2s79ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 197478 and item_demand_plan_id = 3749 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 07:14:48 Duration: 1s370ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 223270 and item_demand_plan_id = 3750 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 09:44:01 Duration: 1s151ms
2 1,305 4m 120ms 355ms 184ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Sep 04 00 46 8s358ms 181ms 01 74 13s217ms 178ms 02 71 13s314ms 187ms 03 41 7s615ms 185ms 04 55 9s799ms 178ms 05 45 7s897ms 175ms 06 73 13s593ms 186ms 07 57 10s921ms 191ms 08 55 11s162ms 202ms 09 38 8s153ms 214ms 10 39 6s924ms 177ms 11 60 10s726ms 178ms 12 46 8s374ms 182ms 13 56 10s45ms 179ms 14 54 9s825ms 181ms 15 50 9s324ms 186ms 16 100 19s139ms 191ms 17 61 11s628ms 190ms 18 43 7s861ms 182ms 19 26 4s779ms 183ms 20 57 10s119ms 177ms 21 44 8s40ms 182ms 22 52 8s790ms 169ms 23 62 11s90ms 178ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 17:04:50') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_991"', '["pointspring_master","calendar.alarm",19529]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",485]', '["pointspring_master","res.partner",19529]', '["pointspring_master","ir.needaction",19529]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 17:05:41 Duration: 355ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 09:41:27') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1027"', '["pointspring_master","calendar.alarm",19565]', '["pointspring_master","mail.channel",168]', '["pointspring_master","mail.channel",169]', '["pointspring_master","mail.channel",170]', '["pointspring_master","mail.channel",171]', '["pointspring_master","mail.channel",172]', '["pointspring_master","mail.channel",173]', '["pointspring_master","mail.channel",174]', '["pointspring_master","mail.channel",438]', '["pointspring_master","mail.channel",439]', '["pointspring_master","mail.channel",490]', '["pointspring_master","mail.channel",536]', '["pointspring_master","res.partner",19565]', '["pointspring_master","ir.needaction",19565]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 09:42:17 Duration: 339ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-09-04 09:43:11') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_2"', '["pointspring_master","calendar.alarm",3]', '["pointspring_master","mail.channel",2]', '["pointspring_master","mail.channel",3]', '["pointspring_master","mail.channel",6]', '["pointspring_master","mail.channel",17]', '["pointspring_master","mail.channel",18]', '["pointspring_master","mail.channel",19]', '["pointspring_master","mail.channel",20]', '["pointspring_master","mail.channel",21]', '["pointspring_master","mail.channel",22]', '["pointspring_master","mail.channel",23]', '["pointspring_master","mail.channel",24]', '["pointspring_master","mail.channel",25]', '["pointspring_master","mail.channel",26]', '["pointspring_master","mail.channel",27]', '["pointspring_master","mail.channel",28]', '["pointspring_master","mail.channel",29]', '["pointspring_master","mail.channel",30]', '["pointspring_master","mail.channel",31]', '["pointspring_master","mail.channel",32]', '["pointspring_master","mail.channel",33]', '["pointspring_master","mail.channel",34]', '["pointspring_master","mail.channel",35]', '["pointspring_master","mail.channel",36]', '["pointspring_master","mail.channel",37]', '["pointspring_master","mail.channel",38]', '["pointspring_master","mail.channel",39]', '["pointspring_master","mail.channel",40]', '["pointspring_master","mail.channel",41]', '["pointspring_master","mail.channel",42]', '["pointspring_master","mail.channel",43]', '["pointspring_master","mail.channel",44]', '["pointspring_master","mail.channel",45]', '["pointspring_master","mail.channel",46]', '["pointspring_master","mail.channel",47]', '["pointspring_master","mail.channel",48]', '["pointspring_master","mail.channel",49]', '["pointspring_master","mail.channel",50]', '["pointspring_master","mail.channel",51]', '["pointspring_master","mail.channel",52]', '["pointspring_master","mail.channel",53]', '["pointspring_master","mail.channel",54]', '["pointspring_master","mail.channel",55]', '["pointspring_master","mail.channel",56]', '["pointspring_master","mail.channel",57]', '["pointspring_master","mail.channel",58]', '["pointspring_master","mail.channel",59]', '["pointspring_master","mail.channel",60]', '["pointspring_master","mail.channel",61]', '["pointspring_master","mail.channel",62]', '["pointspring_master","mail.channel",63]', '["pointspring_master","mail.channel",64]', '["pointspring_master","mail.channel",66]', '["pointspring_master","mail.channel",67]', '["pointspring_master","mail.channel",68]', '["pointspring_master","mail.channel",69]', '["pointspring_master","mail.channel",70]', '["pointspring_master","mail.channel",71]', '["pointspring_master","mail.channel",72]', '["pointspring_master","mail.channel",73]', '["pointspring_master","mail.channel",74]', '["pointspring_master","mail.channel",75]', '["pointspring_master","mail.channel",76]', '["pointspring_master","mail.channel",77]', '["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",83]', '["pointspring_master","mail.channel",84]', '["pointspring_master","mail.channel",85]', '["pointspring_master","mail.channel",86]', '["pointspring_master","mail.channel",87]', '["pointspring_master","mail.channel",88]', '["pointspring_master","mail.channel",89]', '["pointspring_master","mail.channel",90]', '["pointspring_master","mail.channel",91]', '["pointspring_master","mail.channel",92]', '["pointspring_master","mail.channel",93]', '["pointspring_master","mail.channel",94]', '["pointspring_master","mail.channel",95]', '["pointspring_master","mail.channel",96]', '["pointspring_master","mail.channel",97]', '["pointspring_master","mail.channel",98]', '["pointspring_master","mail.channel",99]', '["pointspring_master","mail.channel",100]', '["pointspring_master","mail.channel",101]', '["pointspring_master","mail.channel",102]', '["pointspring_master","mail.channel",103]', '["pointspring_master","mail.channel",104]', '["pointspring_master","mail.channel",105]', '["pointspring_master","mail.channel",106]', '["pointspring_master","mail.channel",107]', '["pointspring_master","mail.channel",108]', '["pointspring_master","mail.channel",109]', '["pointspring_master","mail.channel",110]', '["pointspring_master","mail.channel",111]', '["pointspring_master","mail.channel",112]', '["pointspring_master","mail.channel",113]', '["pointspring_master","mail.channel",114]', '["pointspring_master","mail.channel",115]', '["pointspring_master","mail.channel",116]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",121]', '["pointspring_master","mail.channel",122]', '["pointspring_master","mail.channel",123]', '["pointspring_master","mail.channel",124]', '["pointspring_master","mail.channel",125]', '["pointspring_master","mail.channel",126]', '["pointspring_master","mail.channel",127]', '["pointspring_master","mail.channel",128]', '["pointspring_master","mail.channel",129]', '["pointspring_master","mail.channel",130]', '["pointspring_master","mail.channel",131]', '["pointspring_master","mail.channel",132]', '["pointspring_master","mail.channel",133]', '["pointspring_master","mail.channel",134]', '["pointspring_master","mail.channel",135]', '["pointspring_master","mail.channel",136]', '["pointspring_master","mail.channel",137]', '["pointspring_master","mail.channel",138]', '["pointspring_master","mail.channel",139]', '["pointspring_master","mail.channel",141]', '["pointspring_master","mail.channel",142]', '["pointspring_master","mail.channel",143]', '["pointspring_master","mail.channel",144]', '["pointspring_master","mail.channel",145]', '["pointspring_master","mail.channel",146]', '["pointspring_master","mail.channel",147]', '["pointspring_master","mail.channel",148]', '["pointspring_master","mail.channel",149]', '["pointspring_master","mail.channel",150]', '["pointspring_master","mail.channel",151]', '["pointspring_master","mail.channel",152]', '["pointspring_master","mail.channel",153]', '["pointspring_master","mail.channel",154]', '["pointspring_master","mail.channel",155]', '["pointspring_master","mail.channel",156]', '["pointspring_master","mail.channel",157]', '["pointspring_master","mail.channel",158]', '["pointspring_master","mail.channel",159]', '["pointspring_master","mail.channel",160]', '["pointspring_master","mail.channel",161]', '["pointspring_master","mail.channel",162]', '["pointspring_master","mail.channel",163]', '["pointspring_master","mail.channel",164]', '["pointspring_master","mail.channel",165]', '["pointspring_master","mail.channel",166]', '["pointspring_master","mail.channel",167]', '["pointspring_master","mail.channel",168]', '["pointspring_master","mail.channel",169]', '["pointspring_master","mail.channel",170]', '["pointspring_master","mail.channel",171]', '["pointspring_master","mail.channel",172]', '["pointspring_master","mail.channel",173]', '["pointspring_master","mail.channel",174]', '["pointspring_master","mail.channel",175]', '["pointspring_master","mail.channel",176]', '["pointspring_master","mail.channel",177]', '["pointspring_master","mail.channel",178]', '["pointspring_master","mail.channel",179]', '["pointspring_master","mail.channel",180]', '["pointspring_master","mail.channel",181]', '["pointspring_master","mail.channel",182]', '["pointspring_master","mail.channel",183]', '["pointspring_master","mail.channel",184]', '["pointspring_master","mail.channel",185]', '["pointspring_master","mail.channel",186]', '["pointspring_master","mail.channel",187]', '["pointspring_master","mail.channel",188]', '["pointspring_master","mail.channel",189]', '["pointspring_master","mail.channel",190]', '["pointspring_master","mail.channel",191]', '["pointspring_master","mail.channel",192]', '["pointspring_master","mail.channel",193]', '["pointspring_master","mail.channel",194]', '["pointspring_master","mail.channel",195]', '["pointspring_master","mail.channel",196]', '["pointspring_master","mail.channel",197]', '["pointspring_master","mail.channel",198]', '["pointspring_master","mail.channel",199]', '["pointspring_master","mail.channel",200]', '["pointspring_master","mail.channel",201]', '["pointspring_master","mail.channel",202]', '["pointspring_master","mail.channel",234]', '["pointspring_master","mail.channel",235]', '["pointspring_master","mail.channel",236]', '["pointspring_master","mail.channel",237]', '["pointspring_master","mail.channel",238]', '["pointspring_master","mail.channel",239]', '["pointspring_master","mail.channel",240]', '["pointspring_master","mail.channel",241]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",243]', '["pointspring_master","mail.channel",244]', '["pointspring_master","mail.channel",245]', '["pointspring_master","mail.channel",249]', '["pointspring_master","mail.channel",250]', '["pointspring_master","mail.channel",251]', '["pointspring_master","mail.channel",318]', '["pointspring_master","mail.channel",319]', '["pointspring_master","mail.channel",320]', '["pointspring_master","mail.channel",321]', '["pointspring_master","mail.channel",322]', '["pointspring_master","mail.channel",323]', '["pointspring_master","mail.channel",324]', '["pointspring_master","mail.channel",325]', '["pointspring_master","mail.channel",326]', '["pointspring_master","mail.channel",327]', '["pointspring_master","mail.channel",328]', '["pointspring_master","mail.channel",331]', '["pointspring_master","mail.channel",332]', '["pointspring_master","mail.channel",333]', '["pointspring_master","mail.channel",334]', '["pointspring_master","mail.channel",335]', '["pointspring_master","mail.channel",345]', '["pointspring_master","mail.channel",419]', '["pointspring_master","mail.channel",420]', '["pointspring_master","mail.channel",421]', '["pointspring_master","mail.channel",445]', '["pointspring_master","mail.channel",446]', '["pointspring_master","mail.channel",447]', '["pointspring_master","mail.channel",492]', '["pointspring_master","mail.channel",493]', '["pointspring_master","mail.channel",494]', '["pointspring_master","res.partner",3]', '["pointspring_master","ir.needaction",3]'))) ORDER BY "bus_bus"."id";
Date: 2023-09-04 09:44:01 Duration: 331ms
3 496 1m35s 120ms 366ms 192ms 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 #3
Day Hour Count Duration Avg duration Sep 04 16 403 1m17s 191ms 17 73 14s886ms 203ms 20 20 3s435ms 171ms -
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23900, 23687, 23249)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:51 Duration: 366ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23731, 23415)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:51 Duration: 333ms
-
SELECT "forecasted_data".id FROM "forecasted_data" WHERE ("forecasted_data"."item_supply_plan_id" in (23798, 22807)) ORDER BY "forecasted_data"."id";
Date: 2023-09-04 16:58:52 Duration: 324ms
4 349 1m2s 120ms 319ms 178ms 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 Sep 04 08 1 120ms 120ms 09 2 258ms 129ms 16 265 47s551ms 179ms 17 71 13s29ms 183ms 20 10 1s464ms 146ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (209612, 209706, 209805, 209879)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 17:05:40 Duration: 319ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (190526, 190550, 190567)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 16:58:55 Duration: 307ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (210734, 210735, 210715, 210946, 210885)) ORDER BY "product_warehouse_inventory"."warehouse_name";
Date: 2023-09-04 17:05:42 Duration: 305ms
5 305 1m9s 181ms 330ms 228ms select id from product_warehouse_inventory where coalesce(loc_check_qty, ?) < coalesce(max_product_uom_qty, ?);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 16 305 1m9s 228ms -
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:44:19 Duration: 330ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:28:59 Duration: 327ms
-
select id from product_warehouse_inventory where COALESCE(loc_check_qty, 0) < COALESCE(max_product_uom_qty, 0);
Date: 2023-09-04 16:28:59 Duration: 326ms
6 173 48s964ms 258ms 418ms 283ms 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 Sep 04 08 22 6s381ms 290ms 09 49 15s168ms 309ms 10 84 22s100ms 263ms 17 18 5s314ms 295ms -
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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:10 Duration: 418ms
-
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 = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 08:58:25 Duration: 412ms
-
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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:02 Duration: 409ms
7 152 2m2s 661ms 1s447ms 805ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 05 15 10s337ms 689ms 06 21 16s480ms 784ms 07 29 25s245ms 870ms 08 15 12s62ms 804ms 09 67 54s682ms 816ms 10 5 3s571ms 714ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3741 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:57 Duration: 1s447ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3751 and ill.method not in (8, 7);
Date: 2023-09-04 07:14:48 Duration: 1s329ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3749 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:58 Duration: 1s247ms
8 152 1m35s 482ms 3s77ms 630ms select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 05 15 7s647ms 509ms 06 21 16s31ms 763ms 07 29 19s824ms 683ms 08 15 8s551ms 570ms 09 67 40s955ms 611ms 10 5 2s809ms 561ms -
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 06:52:48 Duration: 3s77ms
-
select count(id) from item_list_line where item_demand_plan_id = 3741;
Date: 2023-09-04 07:14:47 Duration: 1s378ms
-
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 07:03:58 Duration: 1s270ms
9 148 2m29s 781ms 1s959ms 1s10ms select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 05 15 12s376ms 825ms 06 21 23s17ms 1s96ms 07 29 31s6ms 1s69ms 08 15 14s188ms 945ms 09 65 1m6s 1s21ms 10 3 2s627ms 875ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3741 and active = True;
Date: 2023-09-04 06:52:46 Duration: 1s959ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3749 and active = True;
Date: 2023-09-04 07:14:46 Duration: 1s745ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3751 and active = True;
Date: 2023-09-04 07:03:56 Duration: 1s726ms
10 148 1m53s 619ms 1s258ms 767ms select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true and ill.item_demand_plan_id = ? group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 05 15 9s488ms 632ms 06 21 17s558ms 836ms 07 25 21s104ms 844ms 08 15 10s944ms 729ms 09 67 51s310ms 765ms 10 5 3s188ms 637ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 07:03:57 Duration: 1s258ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3741 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 09:31:58 Duration: 1s256ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 06:52:46 Duration: 1s242ms
11 118 19s510ms 133ms 319ms 165ms select "mail_message".id from "mail_message" where ((((("mail_message"."id" in ( select "mail_message_res_partner_needaction_rel"."mail_message_id" from "mail_message_res_partner_needaction_rel" where ("mail_message_res_partner_needaction_rel"."notification_status" in (...)))) and ("mail_message"."author_id" = ?)) and ("mail_message"."res_id" != ?)) and "mail_message"."model" is not null) and (("mail_message"."message_type" != ?) or "mail_message"."message_type" is null)) order by "mail_message"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 05 2 345ms 172ms 06 14 2s634ms 188ms 07 24 3s846ms 160ms 08 5 747ms 149ms 09 56 8s897ms 158ms 10 6 1s53ms 175ms 11 1 184ms 184ms 12 1 179ms 179ms 15 3 566ms 188ms 17 5 919ms 183ms 20 1 136ms 136ms -
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-09-04 09:08:23 Duration: 319ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-09-04 06:52:44 Duration: 270ms
-
SELECT "mail_message".id FROM "mail_message" WHERE ((((("mail_message"."id" in ( SELECT "mail_message_res_partner_needaction_rel"."mail_message_id" FROM "mail_message_res_partner_needaction_rel" WHERE ("mail_message_res_partner_needaction_rel"."notification_status" in ('bounce', 'exception')))) AND ("mail_message"."author_id" = 3)) AND ("mail_message"."res_id" != 0)) AND "mail_message"."model" IS NOT NULL) AND (("mail_message"."message_type" != 'user_notification') OR "mail_message"."message_type" IS NULL)) ORDER BY "mail_message"."id" DESC;
Date: 2023-09-04 09:31:54 Duration: 244ms
12 114 15s718ms 120ms 470ms 137ms with data as ( select id, row_number() over w as rnum from forecasted_data where product_id = ? and item_demand_plan_id = ? and date::date = date ? and active = true and is_forcast = true window w as (partition by product_id, date, min_product_uom_qty, max_product_uom_qty order by id)) select id from data where rnum > ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 06 18 2s539ms 141ms 07 29 4s425ms 152ms 08 37 4s752ms 128ms 09 30 4s1ms 133ms -
with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 197466 and item_demand_plan_id = 3749 AND date::date = DATE '2023-09-30' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;
Date: 2023-09-04 07:14:46 Duration: 470ms
-
with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 171912 and item_demand_plan_id = 3741 AND date::date = DATE '2023-09-30' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;
Date: 2023-09-04 06:52:46 Duration: 285ms
-
with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 226881 and item_demand_plan_id = 3751 AND date::date = DATE '2023-09-30' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;
Date: 2023-09-04 07:16:45 Duration: 235ms
13 58 17s375ms 232ms 578ms 299ms update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "state" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 16 28 9s611ms 343ms 17 30 7s764ms 258ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '10-I/INT/14974', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570365);
Date: 2023-09-04 16:54:39 Duration: 578ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '04-V/INT/06782', "scrapped" = false, "state" = 'confirmed', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570416, 570415);
Date: 2023-09-04 17:45:47 Duration: 510ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/06561', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570417, 570418);
Date: 2023-09-04 17:45:48 Duration: 504ms
14 52 7s721ms 141ms 175ms 148ms with t as ( select db.datname, coalesce(t.query, ?) query, coalesce(t.queryid, ?) queryid, coalesce(t.calls, ?) calls, coalesce(t.total_time, ?) total_time, coalesce(t.mean_time, ?) mean_time, coalesce(t.percentage, ?) percentage from pg_database db natural right join ( select query, queryid, calls, round(total_exec_time::numeric, ?) as total_time, round(mean_exec_time::numeric, ?) as mean_time, round((? * total_exec_time / sum(total_exec_time) over ())::numeric, ?) as percentage from pg_stat_statements order by mean_time desc limit ?) t where not db.datistemplate ) select json_object_agg(datname, row_to_json(t)) from t;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 09 48 7s116ms 148ms 10 4 605ms 151ms -
WITH T AS ( SELECT db.datname, coalesce(T.query, '') query, coalesce(T.queryid, 0) queryid, coalesce(T.calls, 0) calls, coalesce(T.total_time, 0) total_time, coalesce(T.mean_time, 0) mean_time, coalesce(T.percentage, 0) percentage FROM pg_database db NATURAL RIGHT JOIN ( SELECT query, queryid, calls, round(total_exec_time::numeric, 2) AS total_time, round(mean_exec_time::numeric, 2) AS mean_time, round((100 * total_exec_time / sum(total_exec_time) OVER ())::numeric, 2) AS percentage FROM pg_stat_statements ORDER BY mean_time DESC LIMIT 3) T WHERE NOT db.datistemplate ) SELECT json_object_agg(datname, row_to_json(T)) FROM T;
Date: 2023-09-04 09:34:17 Duration: 175ms
-
WITH T AS ( SELECT db.datname, coalesce(T.query, '') query, coalesce(T.queryid, 0) queryid, coalesce(T.calls, 0) calls, coalesce(T.total_time, 0) total_time, coalesce(T.mean_time, 0) mean_time, coalesce(T.percentage, 0) percentage FROM pg_database db NATURAL RIGHT JOIN ( SELECT query, queryid, calls, round(total_exec_time::numeric, 2) AS total_time, round(mean_exec_time::numeric, 2) AS mean_time, round((100 * total_exec_time / sum(total_exec_time) OVER ())::numeric, 2) AS percentage FROM pg_stat_statements ORDER BY mean_time DESC LIMIT 3) T WHERE NOT db.datistemplate ) SELECT json_object_agg(datname, row_to_json(T)) FROM T;
Date: 2023-09-04 09:54:17 Duration: 169ms
-
WITH T AS ( SELECT db.datname, coalesce(T.query, '') query, coalesce(T.queryid, 0) queryid, coalesce(T.calls, 0) calls, coalesce(T.total_time, 0) total_time, coalesce(T.mean_time, 0) mean_time, coalesce(T.percentage, 0) percentage FROM pg_database db NATURAL RIGHT JOIN ( SELECT query, queryid, calls, round(total_exec_time::numeric, 2) AS total_time, round(mean_exec_time::numeric, 2) AS mean_time, round((100 * total_exec_time / sum(total_exec_time) OVER ())::numeric, 2) AS percentage FROM pg_stat_statements ORDER BY mean_time DESC LIMIT 3) T WHERE NOT db.datistemplate ) SELECT json_object_agg(datname, row_to_json(T)) FROM T;
Date: 2023-09-04 09:52:18 Duration: 164ms
15 42 33s530ms 187ms 3s696ms 798ms 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 Sep 04 15 1 445ms 445ms 16 26 21s623ms 831ms 17 2 851ms 425ms 20 13 10s610ms 816ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570321, 570322, 570323, 570324, 570325, 570326, 570327);
Date: 2023-09-04 16:26:50 Duration: 3s696ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570307, 570308, 570309, 570310, 570311, 570312, 570313);
Date: 2023-09-04 16:17:14 Duration: 3s546ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (570497, 570481, 570483, 570485, 570487, 570489, 570491, 570493, 570495);
Date: 2023-09-04 20:42:36 Duration: 2s963ms
16 37 8s879ms 232ms 251ms 239ms update "stock_move" set "product_qty" = ?.?, "scrapped" = false, "sequence" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Sep 04 18 37 8s879ms 239ms -
UPDATE "stock_move" SET "product_qty" = 2.0, "scrapped" = false, "sequence" = 50, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570434);
Date: 2023-09-04 18:02:41 Duration: 251ms
-
UPDATE "stock_move" SET "product_qty" = 1.0, "scrapped" = false, "sequence" = 65, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570426);
Date: 2023-09-04 18:02:39 Duration: 250ms
-
UPDATE "stock_move" SET "product_qty" = 1.0, "scrapped" = false, "sequence" = 85, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570427);
Date: 2023-09-04 18:02:40 Duration: 250ms
17 31 7s107ms 120ms 352ms 229ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."inventory_vendor_id" = ?) and (("product_warehouse_inventory"."warehouse_id" = ?) and (((("product_warehouse_inventory"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where ("psd_custom_inventory_vendor"."purchase_agent_user" = ?))) and ("product_warehouse_inventory"."stocking_flag" is null or "product_warehouse_inventory"."stocking_flag" = false)) and "product_warehouse_inventory"."replenish_branch_id" is not null) and ("product_warehouse_inventory"."qty_reserve" > ?.?)))) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 15 6 1s88ms 181ms 16 25 6s19ms 240ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3108) AND (("product_warehouse_inventory"."warehouse_id" = 36) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-09-04 16:05:33 Duration: 352ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3057) AND (("product_warehouse_inventory"."warehouse_id" = 36) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-09-04 16:05:33 Duration: 351ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."inventory_vendor_id" = 3041) AND (("product_warehouse_inventory"."warehouse_id" = 36) AND (((("product_warehouse_inventory"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE ("psd_custom_inventory_vendor"."purchase_agent_user" = 1012))) AND ("product_warehouse_inventory"."stocking_flag" IS NULL or "product_warehouse_inventory"."stocking_flag" = false)) AND "product_warehouse_inventory"."replenish_branch_id" IS NOT NULL) AND ("product_warehouse_inventory"."qty_reserve" > 0.0)))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-09-04 16:05:33 Duration: 315ms
18 31 6s471ms 188ms 460ms 208ms insert into "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") values (nextval(?), ?, (now() at time zone ?), ?, (now() at time zone ?), false, null, ?, ?, ?, ?, ?, false, ?, ?, ?, ?, null, ?, ?, ?, ?, ?, ?, ?, ?, true, ?, ?, ?, ?) returning id;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Sep 04 15 1 455ms 455ms 16 30 6s15ms 200ms -
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 39, 1, '2023-09-04 16:03:20.385088', 37, 148135, false, 397, 468, 'new_product', '04-V/INT/06778', NULL, 'Warehouse Inventory Transfer to Fairmont', 225582, 293, '0', 'make_to_stock', 221128, 1, '1.00', true, 10, 43, 'draft', 37) RETURNING id;
Date: 2023-09-04 16:03:20 Duration: 460ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 46, 1, '2023-09-05 15:57:59.021021', 43, 148133, false, 445, 468, 'new_product', '11-N/INT/15112', NULL, 'Warehouse Inventory Transfer to New Castle', 225580, 341, '0', 'make_to_stock', 175949, 1, '2.00', true, 10, 42, 'draft', 43) RETURNING id;
Date: 2023-09-04 15:57:59 Duration: 455ms
-
INSERT INTO "stock_move" ("id", "create_uid", "create_date", "write_uid", "write_date", "additional", "bom_action", "branch_id", "company_id", "date", "dest_warehouse_id", "group_id", "is_core", "location_dest_id", "location_id", "move_options", "name", "note", "origin", "picking_id", "picking_type_id", "priority", "procure_method", "product_id", "product_uom", "product_uom_qty", "propagate_cancel", "sequence", "src_warehouse_id", "state", "warehouse_id") VALUES (nextval('stock_move_id_seq'), 1012, (now() at time zone 'UTC'), 1012, (now() at time zone 'UTC'), false, NULL, 50, 1, '2023-09-04 16:26:40.014873', 44, 148143, false, 453, 468, 'new_product', '12-S/INT/05400', NULL, 'Warehouse Inventory Transfer to Sarver', 225590, 349, '0', 'make_to_stock', 186213, 1, '3.00', true, 10, 42, 'draft', 44) RETURNING id;
Date: 2023-09-04 16:26:40 Duration: 201ms
19 30 7s866ms 241ms 464ms 262ms 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 #19
Day Hour Count Duration Avg duration Sep 04 01 1 276ms 276ms 05 2 516ms 258ms 07 6 1s701ms 283ms 10 2 523ms 261ms 11 5 1s285ms 257ms 12 4 1s35ms 258ms 17 2 518ms 259ms 18 5 1s245ms 249ms 20 3 762ms 254ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/website.assets_wysiwyg.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-79ef89c/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 07:18:49 Duration: 464ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/website.assets_editor.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-d46bd21/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 12:42:23 Duration: 277ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 01:50:08 Duration: 276ms
20 27 14s168ms 412ms 600ms 524ms 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 #20
Day Hour Count Duration Avg duration Sep 04 20 27 14s168ms 524ms -
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, 45, 1, '2023-09-08 20:51:27.653565', 42, 148187, false, 437, 468, 'new_product', '10-I/INT/14977', '10-I/INT/14977', 225646, 333, '0', 'make_to_stock', 239103, 1, '8.00', true, 10, 40, 'waiting', 7013, 42) RETURNING id;
Date: 2023-09-04 20:51:29 Duration: 600ms
-
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, 45, 1, '2023-09-08 20:51:27.653565', 42, 148187, false, 437, 468, 'new_product', '10-I/INT/14977', '10-I/INT/14977', 225646, 333, '0', 'make_to_stock', 239077, 1, '8.00', true, 10, 40, 'waiting', 7012, 42) RETURNING id;
Date: 2023-09-04 20:51:28 Duration: 591ms
-
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, 39, 1, '2023-09-04 20:44:09.284008', 37, 148181, false, 397, 468, 'new_product', '04-V/INT/06785', '04-V/INT/06785', 225640, 293, '0', 'make_to_stock', 239012, 1, '2.00', true, 10, 40, 'waiting', 7003, 37) RETURNING id;
Date: 2023-09-04 20:44:09 Duration: 585ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m48s 3m48s 3m48s 1 3m48s 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 Sep 04 09 1 3m48s 3m48s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-09-04 09:07:49 Duration: 3m48s
2 1m28s 1m28s 1m28s 1 1m28s 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 Sep 04 09 1 1m28s 1m28s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-09-04 09:02:35 Duration: 1m28s
3 1m20s 1m20s 1m20s 1 1m20s 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 Sep 04 09 1 1m20s 1m20s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-09-04 09:04:00 Duration: 1m20s
4 34s521ms 34s521ms 34s521ms 1 34s521ms 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 Sep 04 09 1 34s521ms 34s521ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-09-04 09:10:21 Duration: 34s521ms
5 21s897ms 21s897ms 21s897ms 1 21s897ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Sep 04 09 1 21s897ms 21s897ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;
Date: 2023-09-04 09:09:00 Duration: 21s897ms
6 21s858ms 21s858ms 21s858ms 1 21s858ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Sep 04 09 1 21s858ms 21s858ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-09-04 09:09:46 Duration: 21s858ms
7 2s127ms 18s126ms 10s84ms 6 1m delete from account_move_line where id in (...);Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Sep 04 07 2 20s254ms 10s127ms 15 2 20s112ms 10s56ms 23 2 20s138ms 10s69ms -
DELETE FROM account_move_line WHERE id IN (3059042, 3059043, 3059044, 3059045, 3059046, 3059047, 3059048, 3059049, 3059050, 3059051, 3059052, 3059053, 3059054, 3059055, 3059056, 3059057, 3059058);
Date: 2023-09-04 07:23:19 Duration: 18s126ms
-
DELETE FROM account_move_line WHERE id IN (3059080, 3059081, 3059082, 3059083, 3059084, 3059085, 3059086, 3059087, 3059088, 3059089, 3059090, 3059091, 3059092, 3059093, 3059094, 3059095, 3059096);
Date: 2023-09-04 23:23:30 Duration: 17s992ms
-
DELETE FROM account_move_line WHERE id IN (3059061, 3059062, 3059063, 3059064, 3059065, 3059066, 3059067, 3059068, 3059069, 3059070, 3059071, 3059072, 3059073, 3059074, 3059075, 3059076, 3059077);
Date: 2023-09-04 15:23:37 Duration: 17s967ms
8 1s818ms 1s866ms 1s845ms 12 22s148ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__description_sale" on ("product_template"."id" = "product_template__description_sale"."res_id" and "product_template__description_sale"."type" = ? and "product_template__description_sale"."name" = ? and "product_template__description_sale"."lang" = ? and "product_template__description_sale"."value" != ?) left join "ir_translation" AS "product_template__description" on ("product_template"."id" = "product_template__description"."res_id" and "product_template__description"."type" = ? and "product_template__description"."name" = ? and "product_template__description"."lang" = ? and "product_template__description"."value" != ?) left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (((((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?))) and (((((unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?)))))) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" where (("product_product"."active" = true) and (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)))))) or ("product_template"."inventory_vendor_id" in ( select "psd_custom_inventory_vendor".id from "psd_custom_inventory_vendor" where (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent (?))))) or unaccent (coalesce("product_template__description"."value", "product_template"."description")) ilike unaccent (?)) or unaccent (coalesce("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent (?)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Sep 04 23 12 22s148ms 1s845ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tubing%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tubing%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tubing%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tubing%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tubing%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tubing%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:27 Duration: 1s866ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%exhaust%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%exhaust%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%exhaust%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%exhaust%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%exhaust%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%exhaust%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:46 Duration: 1s865ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__description_sale" ON ("product_template"."id" = "product_template__description_sale"."res_id" AND "product_template__description_sale"."type" = 'model' AND "product_template__description_sale"."name" = 'product.template,description_sale' AND "product_template__description_sale"."lang" = 'en_US' AND "product_template__description_sale"."value" != '') LEFT JOIN "ir_translation" AS "product_template__description" ON ("product_template"."id" = "product_template__description"."res_id" AND "product_template__description"."type" = 'model' AND "product_template__description"."name" = 'product.template,description' AND "product_template__description"."lang" = 'en_US' AND "product_template__description"."value" != '') LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (((((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%Stainless%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%Stainless%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%Stainless%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%Stainless%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%Stainless%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%steel%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%steel%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%steel%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%steel%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%steel%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%flex%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%flex%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%flex%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%flex%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%flex%'))) AND (((((unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%tubi%') OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%tubi%')))))) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%tubi%')))))) OR ("product_template"."inventory_vendor_id" in ( SELECT "psd_custom_inventory_vendor".id FROM "psd_custom_inventory_vendor" WHERE (unaccent ("psd_custom_inventory_vendor"."name"::text) ilike unaccent ('%tubi%'))))) OR unaccent (COALESCE("product_template__description"."value", "product_template"."description")) ilike unaccent ('%tubi%')) OR unaccent (COALESCE("product_template__description_sale"."value", "product_template"."description_sale")) ilike unaccent ('%tubi%')))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC LIMIT 5;
Date: 2023-09-04 23:43:26 Duration: 1s864ms
9 859ms 4s632ms 1s769ms 13 23s3ms select distinct idp.id as item_demand_plan_id from item_demand_plan idp left join item_list_line as ill on idp.id = ill.item_demand_plan_id left join forecasted_data as fd on idp.id = fd.item_demand_plan_id where idp.fetch_data_done = true and idp.active = true and idp.create_date > current_timestamp - interval ? and ill.method not in (...) and idp.id not in ( select item_demand_plan_id from item_list_line where coalesce(method, ?) = ?) and fd.id is null group by idp.id, ill.method;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Sep 04 04 2 1s785ms 892ms 05 2 1s736ms 868ms 06 5 15s684ms 3s136ms 07 1 1s1ms 1s1ms 08 3 2s795ms 931ms -
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:00:35 Duration: 4s632ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:08:43 Duration: 4s574ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '3 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-09-04 06:08:19 Duration: 4s538ms
10 781ms 1s959ms 1s10ms 148 2m29s select count(id) as total_count from item_list_line where item_demand_plan_id = ? and active = true;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Sep 04 05 15 12s376ms 825ms 06 21 23s17ms 1s96ms 07 29 31s6ms 1s69ms 08 15 14s188ms 945ms 09 65 1m6s 1s21ms 10 3 2s627ms 875ms -
select count(id) as total_count from item_list_line where item_demand_plan_id = 3741 and active = True;
Date: 2023-09-04 06:52:46 Duration: 1s959ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3749 and active = True;
Date: 2023-09-04 07:14:46 Duration: 1s745ms
-
select count(id) as total_count from item_list_line where item_demand_plan_id = 3751 and active = True;
Date: 2023-09-04 07:03:56 Duration: 1s726ms
11 661ms 1s447ms 805ms 152 2m2s select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Sep 04 05 15 10s337ms 689ms 06 21 16s480ms 784ms 07 29 25s245ms 870ms 08 15 12s62ms 804ms 09 67 54s682ms 816ms 10 5 3s571ms 714ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3741 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:57 Duration: 1s447ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3751 and ill.method not in (8, 7);
Date: 2023-09-04 07:14:48 Duration: 1s329ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3749 and ill.method not in (8, 7);
Date: 2023-09-04 07:03:58 Duration: 1s247ms
12 187ms 3s696ms 798ms 42 33s530ms update "stock_move" set "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Sep 04 15 1 445ms 445ms 16 26 21s623ms 831ms 17 2 851ms 425ms 20 13 10s610ms 816ms -
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570321, 570322, 570323, 570324, 570325, 570326, 570327);
Date: 2023-09-04 16:26:50 Duration: 3s696ms
-
UPDATE "stock_move" SET "state" = 'waiting', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570307, 570308, 570309, 570310, 570311, 570312, 570313);
Date: 2023-09-04 16:17:14 Duration: 3s546ms
-
UPDATE "stock_move" SET "state" = 'confirmed', "write_uid" = 996, "write_date" = (now() at time zone 'UTC') WHERE id IN (570497, 570481, 570483, 570485, 570487, 570489, 570491, 570493, 570495);
Date: 2023-09-04 20:42:36 Duration: 2s963ms
13 619ms 1s258ms 767ms 148 1m53s select ill.item_demand_plan_id from item_list_line ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where ill.method is null and idp.active = true and ill.item_demand_plan_id = ? group by ill.item_demand_plan_id having count(ill.id) > ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Sep 04 05 15 9s488ms 632ms 06 21 17s558ms 836ms 07 25 21s104ms 844ms 08 15 10s944ms 729ms 09 67 51s310ms 765ms 10 5 3s188ms 637ms -
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 07:03:57 Duration: 1s258ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3741 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 09:31:58 Duration: 1s256ms
-
select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3749 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;
Date: 2023-09-04 06:52:46 Duration: 1s242ms
14 482ms 3s77ms 630ms 152 1m35s select count(id) from item_list_line where item_demand_plan_id = ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Sep 04 05 15 7s647ms 509ms 06 21 16s31ms 763ms 07 29 19s824ms 683ms 08 15 8s551ms 570ms 09 67 40s955ms 611ms 10 5 2s809ms 561ms -
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 06:52:48 Duration: 3s77ms
-
select count(id) from item_list_line where item_demand_plan_id = 3741;
Date: 2023-09-04 07:14:47 Duration: 1s378ms
-
select count(id) from item_list_line where item_demand_plan_id = 3751;
Date: 2023-09-04 07:03:58 Duration: 1s270ms
15 512ms 2s79ms 561ms 11,447 1h47m4s select date_part(?, invoice_date) as year, date_part(?, invoice_date) as month, date_part(?, invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = ? and item_demand_plan_id = ? group by product_id, date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date) order by date_part(?, invoice_date), date_part(?, invoice_date), date_part(?, invoice_date);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Sep 04 05 112 59s341ms 529ms 06 2,660 24m42s 557ms 07 3,056 28m36s 561ms 08 3,263 30m49s 566ms 09 2,356 21m57s 559ms -
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 172061 and item_demand_plan_id = 3741 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 08:28:19 Duration: 2s79ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 197478 and item_demand_plan_id = 3749 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 07:14:48 Duration: 1s370ms
-
select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 223270 and item_demand_plan_id = 3750 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);
Date: 2023-09-04 09:44:01 Duration: 1s151ms
16 412ms 600ms 524ms 27 14s168ms 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 #16
Day Hour Count Duration Avg duration Sep 04 20 27 14s168ms 524ms -
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, 45, 1, '2023-09-08 20:51:27.653565', 42, 148187, false, 437, 468, 'new_product', '10-I/INT/14977', '10-I/INT/14977', 225646, 333, '0', 'make_to_stock', 239103, 1, '8.00', true, 10, 40, 'waiting', 7013, 42) RETURNING id;
Date: 2023-09-04 20:51:29 Duration: 600ms
-
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, 45, 1, '2023-09-08 20:51:27.653565', 42, 148187, false, 437, 468, 'new_product', '10-I/INT/14977', '10-I/INT/14977', 225646, 333, '0', 'make_to_stock', 239077, 1, '8.00', true, 10, 40, 'waiting', 7012, 42) RETURNING id;
Date: 2023-09-04 20:51:28 Duration: 591ms
-
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, 39, 1, '2023-09-04 20:44:09.284008', 37, 148181, false, 397, 468, 'new_product', '04-V/INT/06785', '04-V/INT/06785', 225640, 293, '0', 'make_to_stock', 239012, 1, '2.00', true, 10, 40, 'waiting', 7003, 37) RETURNING id;
Date: 2023-09-04 20:44:09 Duration: 585ms
17 232ms 578ms 299ms 58 17s375ms update "stock_move" set "delay_alert_date" = ?, "is_done" = false, "picking_code" = ?, "product_qty" = ?.?, "reference" = ?, "scrapped" = false, "state" = ?, "unit_factor" = ?.?, "weight" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Sep 04 16 28 9s611ms 343ms 17 30 7s764ms 258ms -
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '10-I/INT/14974', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570365);
Date: 2023-09-04 16:54:39 Duration: 578ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '04-V/INT/06782', "scrapped" = false, "state" = 'confirmed', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570416, 570415);
Date: 2023-09-04 17:45:47 Duration: 510ms
-
UPDATE "stock_move" SET "delay_alert_date" = NULL, "is_done" = false, "picking_code" = 'internal', "product_qty" = 1.0, "reference" = '09-B/INT/06561', "scrapped" = false, "state" = 'waiting', "unit_factor" = 1.0, "weight" = '0.00', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570417, 570418);
Date: 2023-09-04 17:45:48 Duration: 504ms
18 258ms 418ms 283ms 173 48s964ms 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 #18
Day Hour Count Duration Avg duration Sep 04 08 22 6s381ms 290ms 09 49 15s168ms 309ms 10 84 22s100ms 263ms 17 18 5s314ms 295ms -
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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 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 = 43 and pwi.inventory_vendor_id = 2940 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:10 Duration: 418ms
-
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 = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, abs(((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0))) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = False and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - COALESCE(pwi.qty_reserve, 0)) < 0 and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.discontinued, False) = False and COALESCE(pt.never_stock, False) = True and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False UNION ALL select pwi.product_id, COALESCE(pwi.qty_on_perm_order, 0) as min_product_uom_qty from product_warehouse_inventory pwi LEFT JOIN product_product as pp ON pwi.product_id = pp.id LEFT JOIN product_template as pt ON pt.id = pp.product_tmpl_id where pt.is_core = False and pwi.stocking_flag = True and COALESCE(pwi.qty_on_perm_order, 0) > 0 and ((COALESCE(pwi.qty_available, 0) + COALESCE(pwi.qty_on_order, 0)) - (COALESCE(pwi.qty_reserve, 0) + COALESCE(pwi.qty_on_perm_order, 0))) < 0 and pt.discontinued = False and pwi.warehouse_id = 44 and pwi.inventory_vendor_id = 2965 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 08:58:25 Duration: 412ms
-
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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 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 = 43 and pwi.inventory_vendor_id = 3106 and COALESCE(pt.superceded, False) = False and COALESCE(pt.obsolete, False) = False;
Date: 2023-09-04 09:03:02 Duration: 409ms
19 241ms 464ms 262ms 30 7s866ms 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 #19
Day Hour Count Duration Avg duration Sep 04 01 1 276ms 276ms 05 2 516ms 258ms 07 6 1s701ms 283ms 10 2 523ms 261ms 11 5 1s285ms 257ms 12 4 1s35ms 258ms 17 2 518ms 259ms 18 5 1s245ms 249ms 20 3 762ms 254ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/website.assets_wysiwyg.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-79ef89c/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 07:18:49 Duration: 464ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/website.assets_editor.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-d46bd21/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 12:42:23 Duration: 277ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-09-04 01:50:08 Duration: 276ms
20 232ms 251ms 239ms 37 8s879ms update "stock_move" set "product_qty" = ?.?, "scrapped" = false, "sequence" = ?, "state" = ?, "write_uid" = ?, "write_date" = (now() at time zone ?) where id in (...);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Sep 04 18 37 8s879ms 239ms -
UPDATE "stock_move" SET "product_qty" = 2.0, "scrapped" = false, "sequence" = 50, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570434);
Date: 2023-09-04 18:02:41 Duration: 251ms
-
UPDATE "stock_move" SET "product_qty" = 1.0, "scrapped" = false, "sequence" = 65, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570426);
Date: 2023-09-04 18:02:39 Duration: 250ms
-
UPDATE "stock_move" SET "product_qty" = 1.0, "scrapped" = false, "sequence" = 85, "state" = 'assigned', "write_uid" = 1012, "write_date" = (now() at time zone 'UTC') WHERE id IN (570427);
Date: 2023-09-04 18:02:40 Duration: 250ms
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
- 16,657 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 483 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 463 Max number of times the same event was reported
- 483 Total events found
Rank Times reported Error 1 463 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Sep 04 00 17 01 15 02 24 03 18 04 19 05 18 06 17 07 16 08 24 09 15 10 28 11 24 12 17 13 18 14 21 15 32 16 19 17 16 18 18 19 16 20 14 21 20 22 16 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: 2023-09-04 23:50:39
2 18 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Sep 04 02 1 08 1 10 3 11 6 16 1 17 1 18 1 20 2 22 1 23 1 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-09-04 02:50:05' WHERE id IN (33)
Date: 2023-09-04 02:50:05
3 2 ERROR: could not create unique index "..."
Times Reported Most Frequent Error / Event #3
Day Hour Count Sep 04 10 2 - ERROR: could not create unique index "vendor_account_master_unique_acc_no"
Detail: Key (account_number)=(P10394) is duplicated.
Statement: ALTER TABLE "vendor_account_master" ADD CONSTRAINT "vendor_account_master_unique_acc_no" unique (account_number)Date: 2023-09-04 10:12:01