pgBadger-
Global information
- Generated on Sat Jul 15 23:50:19 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 1,974 log entries in 18s
- Log start from 2023-07-15 00:00:19 to 2023-07-15 23:47:03
-
Overview
Global Stats
- 106 Number of unique normalized queries
- 358 Number of queries
- 11m49s Total query duration
- 2023-07-15 00:05:12 First query
- 2023-07-15 23:02:11 Last query
- 4 queries/s at 2023-07-15 09:00:47 Query peak
- 11m49s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 11m49s Execute total duration
- 361 Number of events
- 2 Number of unique normalized events
- 358 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
- 358 Average queries per session
- 11m49s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 4 queries/s Query Peak
- 2023-07-15 09:00:47 Date
SELECT Traffic
Key values
- 4 queries/s Query Peak
- 2023-07-15 01:05:25 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 4 queries/s Query Peak
- 2023-07-15 09:00:47 Date
Queries duration
Key values
- 11m49s Total query duration
Prepared queries ratio
Key values
- 0.00 Ratio of bind vs prepare
- 0.00 % Ratio between prepared and "usual" statements
General Activity
↑ Back to the top of the General Activity tableDay Hour Count Min duration Max duration Avg duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 00 11 0ms 4s431ms 754ms 6s703ms 6s703ms 6s703ms 01 59 0ms 2s497ms 520ms 8s42ms 8s292ms 8s292ms 02 25 0ms 251ms 205ms 2s699ms 2s699ms 2s699ms 03 4 0ms 163ms 148ms 289ms 289ms 289ms 04 9 0ms 956ms 389ms 1s551ms 1s551ms 1s551ms 05 2 0ms 155ms 150ms 155ms 155ms 155ms 06 5 0ms 1s865ms 708ms 3s85ms 3s85ms 3s85ms 07 9 0ms 2s714ms 915ms 258ms 7s541ms 7s541ms 08 6 0ms 172ms 149ms 172ms 172ms 172ms 09 81 0ms 3m43s 6s785ms 1m17s 4m23s 4m23s 10 24 0ms 12s127ms 1s691ms 14s921ms 21s532ms 21s532ms 11 4 0ms 162ms 146ms 162ms 162ms 162ms 12 6 0ms 718ms 339ms 1s434ms 1s434ms 1s434ms 13 50 0ms 729ms 581ms 2s840ms 2s868ms 3s497ms 14 11 0ms 1s729ms 641ms 726ms 2s799ms 2s799ms 15 7 0ms 2s709ms 1s142ms 7s551ms 7s551ms 7s551ms 16 0 0ms 0ms 0ms 0ms 0ms 0ms 17 5 0ms 177ms 154ms 531ms 531ms 531ms 18 8 0ms 215ms 169ms 408ms 408ms 408ms 19 9 0ms 204ms 186ms 1s226ms 1s226ms 1s226ms 20 3 0ms 249ms 246ms 740ms 740ms 740ms 21 11 0ms 247ms 182ms 734ms 734ms 734ms 22 8 0ms 1s849ms 531ms 3s60ms 3s60ms 3s60ms 23 1 0ms 139ms 139ms 139ms 139ms 139ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 00 9 0 177ms 410ms 412ms 412ms 01 59 0 520ms 3s179ms 8s42ms 8s292ms 02 25 0 205ms 739ms 2s699ms 2s699ms 03 4 0 148ms 160ms 289ms 289ms 04 5 0 462ms 906ms 956ms 956ms 05 2 0 150ms 146ms 155ms 155ms 06 3 0 152ms 0ms 458ms 458ms 07 5 0 139ms 145ms 149ms 258ms 08 6 0 149ms 168ms 172ms 172ms 09 5 76 6s785ms 1m11s 1m17s 4m23s 10 11 0 208ms 535ms 727ms 730ms 11 4 0 146ms 148ms 162ms 162ms 12 6 0 339ms 166ms 1s434ms 1s434ms 13 50 0 581ms 2s139ms 2s840ms 3s497ms 14 9 0 472ms 711ms 721ms 726ms 15 3 0 148ms 149ms 151ms 151ms 16 0 0 0ms 0ms 0ms 0ms 17 5 0 154ms 121ms 531ms 531ms 18 8 0 169ms 341ms 408ms 408ms 19 9 0 186ms 303ms 1s226ms 1s226ms 20 3 0 246ms 0ms 740ms 740ms 21 11 0 182ms 532ms 734ms 734ms 22 6 0 198ms 302ms 733ms 733ms 23 1 0 139ms 0ms 139ms 139ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Jul 15 00 0 0 2 0 3s351ms 0ms 0ms 6s703ms 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 297ms 0ms 594ms 595ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 2 0 1s542ms 0ms 0ms 3s85ms 07 0 0 4 0 1s885ms 0ms 0ms 7s541ms 08 0 0 0 0 0ms 0ms 0ms 0ms 09 0 0 0 0 0ms 0ms 0ms 0ms 10 0 0 13 0 2s946ms 0ms 1s857ms 21s532ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 0 0 0 0ms 0ms 0ms 0ms 14 0 0 2 0 1s399ms 0ms 0ms 2s799ms 15 0 0 4 0 1s887ms 0ms 0ms 7s551ms 16 0 0 0 0 0ms 0ms 0ms 0ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 0 0 0ms 0ms 0ms 0ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 2 0 1s530ms 0ms 0ms 3s60ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Jul 15 00 0 0 0.00 0.00% 01 0 0 0.00 0.00% 02 0 0 0.00 0.00% 03 0 0 0.00 0.00% 04 0 0 0.00 0.00% 05 0 0 0.00 0.00% 06 0 0 0.00 0.00% 07 0 0 0.00 0.00% 08 0 0 0.00 0.00% 09 0 0 0.00 0.00% 10 0 0 0.00 0.00% 11 0 0 0.00 0.00% 12 0 0 0.00 0.00% 13 0 0 0.00 0.00% 14 0 0 0.00 0.00% 15 0 0 0.00 0.00% 16 0 0 0.00 0.00% 17 0 0 0.00 0.00% 18 0 0 0.00 0.00% 19 0 0 0.00 0.00% 20 0 0 0.00 0.00% 21 0 0 0.00 0.00% 22 0 0 0.00 0.00% 23 0 0 0.00 0.00% Day Hour Count Average / Second Jul 15 00 0 0.00/s 01 0 0.00/s 02 0 0.00/s 03 0 0.00/s 04 0 0.00/s 05 0 0.00/s 06 0 0.00/s 07 0 0.00/s 08 0 0.00/s 09 0 0.00/s 10 0 0.00/s 11 0 0.00/s 12 0 0.00/s 13 0 0.00/s 14 0 0.00/s 15 0 0.00/s 16 0 0.00/s 17 0 0.00/s 18 0 0.00/s 19 0 0.00/s 20 0 0.00/s 21 0 0.00/s 22 0 0.00/s 23 0 0.00/s Day Hour Count Average Duration Average idle time Jul 15 00 0 0ms 0ms 01 0 0ms 0ms 02 0 0ms 0ms 03 0 0ms 0ms 04 0 0ms 0ms 05 0 0ms 0ms 06 0 0ms 0ms 07 0 0ms 0ms 08 0 0ms 0ms 09 0 0ms 0ms 10 0 0ms 0ms 11 0 0ms 0ms 12 0 0ms 0ms 13 0 0ms 0ms 14 0 0ms 0ms 15 0 0ms 0ms 16 0 0ms 0ms 17 0 0ms 0ms 18 0 0ms 0ms 19 0 0ms 0ms 20 0 0ms 0ms 21 0 0ms 0ms 22 0 0ms 0ms 23 0 0ms 0ms -
Connections
Established Connections
Key values
- 0 connections Connection Peak
- Date
Connections per database
Key values
- unknown Main Database
- 0 connections Total
Connections per user
Key values
- unknown Main User
- 0 connections Total
-
Sessions
Simultaneous sessions
Key values
- 0 sessions Session Peak
- Date
Histogram of session times
Key values
- duration
Sessions per database
Key values
- unknown Main Database
- 0 sessions Total
Sessions per user
Key values
- unknown Main User
- 0 sessions Total
Sessions per host
Key values
- unknown Main Host
- 0 sessions Total
-
Checkpoints / Restartpoints
Checkpoints Buffers
Key values
- 0 buffers Checkpoint Peak
- Date
- seconds Highest write time
- seconds Sync time
Checkpoint write buffers (5 minutes period)
NO DATASET
Checkpoints Wal files
Key values
- 0 files Wal files usage Peak
- Date
Checkpoint Wal files usage (5 minutes period)
NO DATASET
Checkpoints distance
Key values
- 0 Mo Distance Peak
- Date
Checkpoints Activity
↑ Back to the top of the Checkpoint Activity tableDay Hour Written buffers Write time Sync time Total time Jul 15 00 0 0s 0s 0s 01 0 0s 0s 0s 02 0 0s 0s 0s 03 0 0s 0s 0s 04 0 0s 0s 0s 05 0 0s 0s 0s 06 0 0s 0s 0s 07 0 0s 0s 0s 08 0 0s 0s 0s 09 0 0s 0s 0s 10 0 0s 0s 0s 11 0 0s 0s 0s 12 0 0s 0s 0s 13 0 0s 0s 0s 14 0 0s 0s 0s 15 0 0s 0s 0s 16 0 0s 0s 0s 17 0 0s 0s 0s 18 0 0s 0s 0s 19 0 0s 0s 0s 20 0 0s 0s 0s 21 0 0s 0s 0s 22 0 0s 0s 0s 23 0 0s 0s 0s Day Hour Added Removed Recycled Synced files Longest sync Average sync Jul 15 00 0 0 0 0 0s 0s 01 0 0 0 0 0s 0s 02 0 0 0 0 0s 0s 03 0 0 0 0 0s 0s 04 0 0 0 0 0s 0s 05 0 0 0 0 0s 0s 06 0 0 0 0 0s 0s 07 0 0 0 0 0s 0s 08 0 0 0 0 0s 0s 09 0 0 0 0 0s 0s 10 0 0 0 0 0s 0s 11 0 0 0 0 0s 0s 12 0 0 0 0 0s 0s 13 0 0 0 0 0s 0s 14 0 0 0 0 0s 0s 15 0 0 0 0 0s 0s 16 0 0 0 0 0s 0s 17 0 0 0 0 0s 0s 18 0 0 0 0 0s 0s 19 0 0 0 0 0s 0s 20 0 0 0 0 0s 0s 21 0 0 0 0 0s 0s 22 0 0 0 0 0s 0s 23 0 0 0 0 0s 0s Day Hour Count Avg time (sec) Jul 15 00 0 0s 01 0 0s 02 0 0s 03 0 0s 04 0 0s 05 0 0s 06 0 0s 07 0 0s 08 0 0s 09 0 0s 10 0 0s 11 0 0s 12 0 0s 13 0 0s 14 0 0s 15 0 0s 16 0 0s 17 0 0s 18 0 0s 19 0 0s 20 0 0s 21 0 0s 22 0 0s 23 0 0s Day Hour Mean distance Mean estimate Jul 15 00 0.00 kB 0.00 kB 01 0.00 kB 0.00 kB 02 0.00 kB 0.00 kB 03 0.00 kB 0.00 kB 04 0.00 kB 0.00 kB 05 0.00 kB 0.00 kB 06 0.00 kB 0.00 kB 07 0.00 kB 0.00 kB 08 0.00 kB 0.00 kB 09 0.00 kB 0.00 kB 10 0.00 kB 0.00 kB 11 0.00 kB 0.00 kB 12 0.00 kB 0.00 kB 13 0.00 kB 0.00 kB 14 0.00 kB 0.00 kB 15 0.00 kB 0.00 kB 16 0.00 kB 0.00 kB 17 0.00 kB 0.00 kB 18 0.00 kB 0.00 kB 19 0.00 kB 0.00 kB 20 0.00 kB 0.00 kB 21 0.00 kB 0.00 kB 22 0.00 kB 0.00 kB 23 0.00 kB 0.00 kB -
Temporary Files
Size of temporary files
Key values
- 0 Temp Files size Peak
- Date
Size of temporary files (5 minutes period)
NO DATASET
Number of temporary files
Key values
- 0 per second Temp Files Peak
- Date
Number of temporary files (5 minutes period)
NO DATASET
Temporary Files Activity
↑ Back to the top of the Temporary Files Activity tableDay Hour Count Total size Average size Jul 15 00 0 0 0 01 0 0 0 02 0 0 0 03 0 0 0 04 0 0 0 05 0 0 0 06 0 0 0 07 0 0 0 08 0 0 0 09 0 0 0 10 0 0 0 11 0 0 0 12 0 0 0 13 0 0 0 14 0 0 0 15 0 0 0 16 0 0 0 17 0 0 0 18 0 0 0 19 0 0 0 20 0 0 0 21 0 0 0 22 0 0 0 23 0 0 0 -
Vacuums
Vacuums / Analyzes Distribution
Key values
- 0 sec Highest CPU-cost vacuum
Table
Database - Date
- 0 sec Highest CPU-cost analyze
Table
Database - Date
Autovacuum actions (5 minutes period)
NO DATASET
Analyzes per table
Key values
- unknown (0) Main table analyzed (database )
- 0 analyzes Total
Vacuums per table
Key values
- unknown (0) Main table vacuumed on database
- 0 vacuums Total
Tuples removed per table
Key values
- unknown (0) Main table with removed tuples on database
- 0 tuples Total removed
Pages removed per table
Key values
- unknown (0) Main table with removed pages on database unknown
- 0 pages Total removed
Autovacuum Activity
↑ Back to the top of the Autovacuum Activity tableDay Hour VACUUMs ANALYZEs Jul 15 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
- 249 Total read queries
- 109 Total write queries
Queries by database
Key values
- unknown Main database
- 358 Requests
- 11m49s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 29,097 Requests
User Request type Count Duration unknown Total 29,097 3h42m19s copy to 152 18m17s cte 401 1m16s ddl 7 53s508ms delete 318 11m45s insert 217 41s345ms select 18,699 2h10m50s update 9,303 58m34s Duration by user
Key values
- 3h42m19s (unknown) Main time consuming user
User Request type Count Duration unknown Total 29,097 3h42m19s copy to 152 18m17s cte 401 1m16s ddl 7 53s508ms delete 318 11m45s insert 217 41s345ms select 18,699 2h10m50s update 9,303 58m34s Queries by host
Key values
- unknown Main host
- 29,097 Requests
- 3h42m19s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 358 Requests
- 11m49s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-07-15 05:18:45 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 219 100-500ms duration
Slowest individual queries
Rank Duration Query 1 3m43s COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-15 09:07:10 ]
2 1m13s COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;[ Date: 2023-07-15 09:02:11 ]
3 1m11s COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;[ Date: 2023-07-15 09:03:27 ]
4 26s766ms COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;[ Date: 2023-07-15 09:09:16 ]
5 21s266ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;[ Date: 2023-07-15 09:08:12 ]
6 16s788ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-07-15 09:08:50 ]
7 15s158ms COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax) TO stdout;[ Date: 2023-07-15 09:00:25 ]
8 12s127ms DELETE FROM account_move_line WHERE id IN (2717406, 2717407, 2717394, 2717395, 2717396, 2717397, 2717398, 2717399, 2717400, 2717401, 2717402, 2717403, 2717404, 2717405);[ Date: 2023-07-15 10:17:56 ]
9 11s260ms DELETE FROM account_move_line WHERE id IN (2720856, 2720857, 2720858, 2720859, 2720860, 2720861, 2720862, 2720863, 2720864, 2720865, 2720866, 2720867, 2720868);[ Date: 2023-07-15 10:18:11 ]
10 10s447ms COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-15 09:00:41 ]
11 6s256ms COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type) TO stdout;[ Date: 2023-07-15 09:00:10 ]
12 4s725ms COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-15 09:07:15 ]
13 4s659ms COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;[ Date: 2023-07-15 09:07:22 ]
14 4s431ms DELETE FROM account_move_line WHERE id IN (2475522, 2475523, 2718148, 2718149, 2718150);[ Date: 2023-07-15 00:05:12 ]
15 4s261ms COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core) TO stdout;[ Date: 2023-07-15 09:08:24 ]
16 4s93ms COPY public.forecasted_data (id, date, min_product_uom_qty, max_product_uom_qty, item_supply_plan_id, po_qty, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, default_code, ext_cost, qty_available, qty_reserve, qty_on_order, qty_on_perm_order, qty_mtd_sold, lead_days, mon_1_qty, mon_2_qty, mon_3_qty, mon_4_qty, mon_5_qty, mon_6_qty, mon_7_qty, mon_8_qty, mon_9_qty, mon_10_qty, mon_11_qty, mon_12_qty, seasonal, stocking_flag, freeze_date, warehouse_min_product_uom_qty, is_forcast, modify_qty, req_po_qty, supercede_product_id, superceded, final_branch_id, po_id, unit_ext_cost, is_freeze, qty_in_transist, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, is_new_stock_product, ref_id, ref, product_name, is_stock_flag_product) TO stdout;[ Date: 2023-07-15 09:00:52 ]
17 3s682ms COPY public.bus_bus (id, channel, message, create_uid, create_date, write_uid, write_date) TO stdout;[ Date: 2023-07-15 09:00:45 ]
18 3s439ms DELETE FROM account_move_line WHERE id IN (2716942, 2716943, 2696034, 2696035);[ Date: 2023-07-15 10:17:31 ]
19 2s918ms COPY public.stock_valuation_layer (id, company_id, product_id, quantity, unit_cost, value, remaining_qty, remaining_value, description, stock_valuation_layer_id, stock_move_id, account_move_id, create_uid, create_date, write_uid, write_date, move_options, other_action, final_action) TO stdout;[ Date: 2023-07-15 09:08:33 ]
20 2s854ms COPY public.sale_history_data (id, contact_reference, contact_name, customer_id, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, invoice_id, note, user_id, create_uid, create_date, write_uid, write_date, history_id, history_date, history_type, manufacturing_usage) TO stdout;[ Date: 2023-07-15 09:07:51 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 3m43s 1 3m43s 3m43s 3m43s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 09 1 3m43s 3m43s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:07:10 Duration: 3m43s
2 1m13s 1 1m13s 1m13s 1m13s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 09 1 1m13s 1m13s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-07-15 09:02:11 Duration: 1m13s
3 1m11s 1 1m11s 1m11s 1m11s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 09 1 1m11s 1m11s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-07-15 09:03:27 Duration: 1m11s
4 53s448ms 18 857ms 12s127ms 2s969ms delete from account_move_line where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 00 1 4s431ms 4s431ms 06 1 1s865ms 1s865ms 07 2 5s281ms 2s640ms 10 10 33s11ms 3s301ms 14 1 1s729ms 1s729ms 15 2 5s279ms 2s639ms 22 1 1s849ms 1s849ms -
DELETE FROM account_move_line WHERE id IN (2717406, 2717407, 2717394, 2717395, 2717396, 2717397, 2717398, 2717399, 2717400, 2717401, 2717402, 2717403, 2717404, 2717405);
Date: 2023-07-15 10:17:56 Duration: 12s127ms
-
DELETE FROM account_move_line WHERE id IN (2720856, 2720857, 2720858, 2720859, 2720860, 2720861, 2720862, 2720863, 2720864, 2720865, 2720866, 2720867, 2720868);
Date: 2023-07-15 10:18:11 Duration: 11s260ms
-
DELETE FROM account_move_line WHERE id IN (2475522, 2475523, 2718148, 2718149, 2718150);
Date: 2023-07-15 00:05:12 Duration: 4s431ms
5 29s418ms 41 703ms 729ms 717ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and ((("product_template"."sale_ok" = true) or ("product_template"."purchase_ok" = true)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 12 2 1s434ms 717ms 13 34 24s410ms 717ms 14 5 3s574ms 714ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%22-p-127%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%22-p-127%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%22-p-127%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%22-p-127%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:10:40 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%3149325229%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3149325229%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%3149325229%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3149325229%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:23:08 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%500007-24%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%500007-24%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%500007-24%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%500007-24%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:49:31 Duration: 728ms
6 26s766ms 1 26s766ms 26s766ms 26s766ms copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 09 1 26s766ms 26s766ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:09:16 Duration: 26s766ms
7 21s266ms 1 21s266ms 21s266ms 21s266ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 09 1 21s266ms 21s266ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;
Date: 2023-07-15 09:08:12 Duration: 21s266ms
8 16s788ms 1 16s788ms 16s788ms 16s788ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 09 1 16s788ms 16s788ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-07-15 09:08:50 Duration: 16s788ms
9 15s605ms 11 1s51ms 2s271ms 1s418ms delete from account_move where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 00 1 2s271ms 2s271ms 06 1 1s220ms 1s220ms 07 2 2s260ms 1s130ms 10 3 5s299ms 1s766ms 14 1 1s70ms 1s70ms 15 2 2s272ms 1s136ms 22 1 1s210ms 1s210ms -
DELETE FROM account_move WHERE id IN (685659, 758084);
Date: 2023-07-15 00:05:14 Duration: 2s271ms
-
DELETE FROM account_move WHERE id IN (757692, 751302);
Date: 2023-07-15 10:17:33 Duration: 2s119ms
-
DELETE FROM account_move WHERE id IN (757849, 757848);
Date: 2023-07-15 10:17:58 Duration: 2s115ms
10 15s158ms 1 15s158ms 15s158ms 15s158ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 09 1 15s158ms 15s158ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax) TO stdout;
Date: 2023-07-15 09:00:25 Duration: 15s158ms
11 10s447ms 1 10s447ms 10s447ms 10s447ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 09 1 10s447ms 10s447ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:00:41 Duration: 10s447ms
12 10s118ms 68 123ms 178ms 148ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 00 2 276ms 138ms 01 6 910ms 151ms 02 3 435ms 145ms 03 4 595ms 148ms 04 3 448ms 149ms 05 2 301ms 150ms 07 3 436ms 145ms 08 5 774ms 154ms 09 4 587ms 146ms 10 2 299ms 149ms 11 4 586ms 146ms 12 4 605ms 151ms 13 6 881ms 146ms 14 1 140ms 140ms 15 3 445ms 148ms 18 4 608ms 152ms 19 3 450ms 150ms 21 5 737ms 147ms 22 3 458ms 152ms 23 1 139ms 139ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 22:14:04') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 22:14:54 Duration: 178ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 08:02:12') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_958"', '["pointspring_master","calendar.alarm",19496]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",34]', '["pointspring_master","mail.channel",43]', '["pointspring_master","mail.channel",47]', '["pointspring_master","mail.channel",330]', '["pointspring_master","mail.channel",353]', '["pointspring_master","mail.channel",450]', '["pointspring_master","res.partner",19496]', '["pointspring_master","ir.needaction",19496]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 08:03:02 Duration: 172ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 08:20:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1005"', '["pointspring_master","calendar.alarm",19543]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",31]', '["pointspring_master","mail.channel",48]', '["pointspring_master","mail.channel",287]', '["pointspring_master","mail.channel",329]', '["pointspring_master","mail.channel",353]', '["pointspring_master","mail.channel",360]', '["pointspring_master","mail.channel",361]', '["pointspring_master","mail.channel",470]', '["pointspring_master","mail.channel",501]', '["pointspring_master","mail.channel",502]', '["pointspring_master","res.partner",19543]', '["pointspring_master","ir.needaction",19543]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 08:21:48 Duration: 168ms
13 9s395ms 5 1s873ms 1s886ms 1s879ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and (((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 01 5 9s395ms 1s879ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:03:50 Duration: 1s886ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:02:09 Duration: 1s879ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:56 Duration: 1s878ms
14 7s458ms 3 2s479ms 2s497ms 2s486ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and ((((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 01 3 7s458ms 2s486ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:05:28 Duration: 2s497ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-0088%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-0088%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:14 Duration: 2s481ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:06:20 Duration: 2s479ms
15 6s459ms 37 170ms 176ms 174ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 01 37 6s459ms 174ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.ref) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.vat) ilike unaccent ('T-RINV-00789')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-RINV-00789%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:03:48 Duration: 176ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.ref) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.vat) ilike unaccent ('T-rINV-00789')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-rINV-00789%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:05:12 Duration: 175ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.ref) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.vat) ilike unaccent ('T-INV-07398')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-INV-07398%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:01:06 Duration: 175ms
16 6s256ms 1 6s256ms 6s256ms 6s256ms copy public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type) to stdout;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 09 1 6s256ms 6s256ms -
COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type) TO stdout;
Date: 2023-07-15 09:00:10 Duration: 6s256ms
17 5s141ms 21 241ms 251ms 244ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 02 6 1s475ms 245ms 10 6 1s458ms 243ms 20 3 740ms 246ms 21 3 734ms 244ms 22 3 733ms 244ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:11:33 Duration: 251ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:54 Duration: 249ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 20:05:37 Duration: 249ms
18 4s725ms 1 4s725ms 4s725ms 4s725ms copy public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 09 1 4s725ms 4s725ms -
COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:07:15 Duration: 4s725ms
19 4s659ms 1 4s659ms 4s659ms 4s659ms copy public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) to stdout;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 09 1 4s659ms 4s659ms -
COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;
Date: 2023-07-15 09:07:22 Duration: 4s659ms
20 4s261ms 1 4s261ms 4s261ms 4s261ms 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;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 09 1 4s261ms 4s261ms -
COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core) TO stdout;
Date: 2023-07-15 09:08:24 Duration: 4s261ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 68 10s118ms 123ms 178ms 148ms select "bus_bus".id from "bus_bus" where (("bus_bus"."create_date" > ?) and ("bus_bus"."channel" in (...))) order by "bus_bus"."id";Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 00 2 276ms 138ms 01 6 910ms 151ms 02 3 435ms 145ms 03 4 595ms 148ms 04 3 448ms 149ms 05 2 301ms 150ms 07 3 436ms 145ms 08 5 774ms 154ms 09 4 587ms 146ms 10 2 299ms 149ms 11 4 586ms 146ms 12 4 605ms 151ms 13 6 881ms 146ms 14 1 140ms 140ms 15 3 445ms 148ms 18 4 608ms 152ms 19 3 450ms 150ms 21 5 737ms 147ms 22 3 458ms 152ms 23 1 139ms 139ms -
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 22:14:04') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_982"', '["pointspring_master","calendar.alarm",19520]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",117]', '["pointspring_master","mail.channel",118]', '["pointspring_master","mail.channel",119]', '["pointspring_master","mail.channel",120]', '["pointspring_master","mail.channel",337]', '["pointspring_master","res.partner",19520]', '["pointspring_master","ir.needaction",19520]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 22:14:54 Duration: 178ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 08:02:12') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_958"', '["pointspring_master","calendar.alarm",19496]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",34]', '["pointspring_master","mail.channel",43]', '["pointspring_master","mail.channel",47]', '["pointspring_master","mail.channel",330]', '["pointspring_master","mail.channel",353]', '["pointspring_master","mail.channel",450]', '["pointspring_master","res.partner",19496]', '["pointspring_master","ir.needaction",19496]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 08:03:02 Duration: 172ms
-
SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-15 08:20:58') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1005"', '["pointspring_master","calendar.alarm",19543]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",31]', '["pointspring_master","mail.channel",48]', '["pointspring_master","mail.channel",287]', '["pointspring_master","mail.channel",329]', '["pointspring_master","mail.channel",353]', '["pointspring_master","mail.channel",360]', '["pointspring_master","mail.channel",361]', '["pointspring_master","mail.channel",470]', '["pointspring_master","mail.channel",501]', '["pointspring_master","mail.channel",502]', '["pointspring_master","res.partner",19543]', '["pointspring_master","ir.needaction",19543]'))) ORDER BY "bus_bus"."id";
Date: 2023-07-15 08:21:48 Duration: 168ms
2 41 29s418ms 703ms 729ms 717ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and ((("product_template"."sale_ok" = true) or ("product_template"."purchase_ok" = true)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 12 2 1s434ms 717ms 13 34 24s410ms 717ms 14 5 3s574ms 714ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%22-p-127%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%22-p-127%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%22-p-127%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%22-p-127%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:10:40 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%3149325229%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3149325229%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%3149325229%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3149325229%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:23:08 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%500007-24%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%500007-24%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%500007-24%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%500007-24%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:49:31 Duration: 728ms
3 37 6s459ms 170ms 176ms 174ms select res_partner.id from "res_partner" where ("res_partner"."active" = true) and (((("res_partner"."partner_share" is null or "res_partner"."partner_share" = false) or ("res_partner"."company_id" in (...))) or "res_partner"."company_id" is null) and (((("res_partner"."type" != ?) or "res_partner"."type" is null) or "res_partner"."type" is null) or ("res_partner"."type" = ?))) and (unaccent (res_partner.email) ilike unaccent (?) or unaccent (res_partner.display_name) ilike unaccent (?) or unaccent (res_partner.ref) ilike unaccent (?) or unaccent (res_partner.vat) ilike unaccent (?)) unaccent (res_partner.display_name);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 01 37 6s459ms 174ms -
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.ref) ilike unaccent ('%T-RINV-00789%') OR unaccent (res_partner.vat) ilike unaccent ('T-RINV-00789')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-RINV-00789%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:03:48 Duration: 176ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.ref) ilike unaccent ('%T-rINV-00789%') OR unaccent (res_partner.vat) ilike unaccent ('T-rINV-00789')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-rINV-00789%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:05:12 Duration: 175ms
-
SELECT res_partner.id FROM "res_partner" WHERE ("res_partner"."active" = true) AND (((("res_partner"."partner_share" IS NULL or "res_partner"."partner_share" = false) OR ("res_partner"."company_id" in (1))) OR "res_partner"."company_id" IS NULL) AND (((("res_partner"."type" != 'private') OR "res_partner"."type" IS NULL) OR "res_partner"."type" IS NULL) OR ("res_partner"."type" = 'private'))) AND (unaccent (res_partner.email) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.display_name) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.ref) ilike unaccent ('%T-INV-07398%') OR unaccent (res_partner.vat) ilike unaccent ('T-INV-07398')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%T-INV-07398%') desc, unaccent (res_partner.display_name);
Date: 2023-07-15 01:01:06 Duration: 175ms
4 21 5s141ms 241ms 251ms 244ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") asc, "product_template"."id" desc;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 02 6 1s475ms 245ms 10 6 1s458ms 243ms 20 3 740ms 246ms 21 3 734ms 244ms 22 3 733ms 244ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:11:33 Duration: 251ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:54 Duration: 249ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-07-15 20:05:37 Duration: 249ms
5 18 53s448ms 857ms 12s127ms 2s969ms delete from account_move_line where id in (...);Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 00 1 4s431ms 4s431ms 06 1 1s865ms 1s865ms 07 2 5s281ms 2s640ms 10 10 33s11ms 3s301ms 14 1 1s729ms 1s729ms 15 2 5s279ms 2s639ms 22 1 1s849ms 1s849ms -
DELETE FROM account_move_line WHERE id IN (2717406, 2717407, 2717394, 2717395, 2717396, 2717397, 2717398, 2717399, 2717400, 2717401, 2717402, 2717403, 2717404, 2717405);
Date: 2023-07-15 10:17:56 Duration: 12s127ms
-
DELETE FROM account_move_line WHERE id IN (2720856, 2720857, 2720858, 2720859, 2720860, 2720861, 2720862, 2720863, 2720864, 2720865, 2720866, 2720867, 2720868);
Date: 2023-07-15 10:18:11 Duration: 11s260ms
-
DELETE FROM account_move_line WHERE id IN (2475522, 2475523, 2718148, 2718149, 2718150);
Date: 2023-07-15 00:05:12 Duration: 4s431ms
6 14 2s867ms 203ms 208ms 204ms 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 #6
Day Hour Count Duration Avg duration Jul 15 00 5 1s27ms 205ms 01 1 205ms 205ms 18 2 408ms 204ms 19 6 1s226ms 204ms -
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.report_assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-5826980/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-15 00:30:11 Duration: 208ms
-
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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-4bc622a/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-15 01:00:13 Duration: 205ms
-
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_backend.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-3fe4f6b/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-07-15 00:48:16 Duration: 205ms
7 12 2s148ms 177ms 183ms 179ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" desc, "product_template"."id" desc;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 02 3 541ms 180ms 10 3 535ms 178ms 13 3 534ms 178ms 14 3 537ms 179ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:49 Duration: 183ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-15 14:49:53 Duration: 179ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" DESC, "product_template"."id" DESC;
Date: 2023-07-15 13:29:39 Duration: 179ms
8 12 2s140ms 176ms 182ms 178ms select "product_template".id from "product_template" where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, "product_template"."list_price" asc, "product_template"."id" desc;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 02 6 1s76ms 179ms 17 3 531ms 177ms 21 3 532ms 177ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:10:22 Duration: 182ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:52 Duration: 180ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."list_price" ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:52 Duration: 179ms
9 11 15s605ms 1s51ms 2s271ms 1s418ms delete from account_move where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 00 1 2s271ms 2s271ms 06 1 1s220ms 1s220ms 07 2 2s260ms 1s130ms 10 3 5s299ms 1s766ms 14 1 1s70ms 1s70ms 15 2 2s272ms 1s136ms 22 1 1s210ms 1s210ms -
DELETE FROM account_move WHERE id IN (685659, 758084);
Date: 2023-07-15 00:05:14 Duration: 2s271ms
-
DELETE FROM account_move WHERE id IN (757692, 751302);
Date: 2023-07-15 10:17:33 Duration: 2s119ms
-
DELETE FROM account_move WHERE id IN (757849, 757848);
Date: 2023-07-15 10:17:58 Duration: 2s115ms
10 6 1s475ms 243ms 249ms 245ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null))) order by coalesce("product_template"."is_published", false) desc, coalesce("product_template__name"."value", "product_template"."name") desc, "product_template"."id" desc;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 02 6 1s475ms 245ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:57 Duration: 249ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-07-15 02:16:57 Duration: 246ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;
Date: 2023-07-15 02:15:58 Duration: 245ms
11 6 747ms 120ms 138ms 124ms select "product_template".id from "product_template" where (("product_template"."active" = true) and ((("product_template"."sale_ok" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and exists ( select ? from "product_public_category_product_template_rel" AS "product_template__public_categ_ids" where "product_template__public_categ_ids"."product_template_id" = "product_template".id and "product_template__public_categ_ids"."product_public_category_id" in (...)))) order by coalesce("product_template"."is_published", false) desc, "product_template"."website_sequence" asc, "product_template"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 02 1 123ms 123ms 07 2 258ms 129ms 08 1 123ms 123ms 17 2 241ms 120ms -
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND EXISTS ( SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template".id AND "product_template__public_categ_ids"."product_public_category_id" IN (12382, 12625, 12626, 12627, 12628, 12629, 12630, 12631, 12632, 12633, 12634, 12635, 12636, 12637, 12638, 12639, 12640, 12641, 12642, 12643, 12645, 12646, 12647, 12648, 12649, 12651, 12652, 12655, 12656, 12657, 12658, 12659, 12660, 12661, 12662, 12663, 12664, 12665, 12666, 12667, 12668, 12669, 12670, 12671, 12672, 12673, 12674, 12676, 12677, 12678, 12680, 12681, 12682, 12684, 12686, 12687, 12688, 12689, 12690, 12692, 12694, 12695, 12696, 12697, 12698, 12699, 12700, 12701, 12702, 12703, 12704, 12705, 12706, 12707, 12708, 12709, 12710, 12711, 12712, 12714, 12715, 12716, 12717, 12718, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12728, 12730, 12731, 12732, 12734, 12735, 12736, 12748, 12750, 12751, 12752, 12753, 12754, 12755, 12756, 12757, 12758, 12759, 12761, 12762, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12772, 12773, 12774, 12775, 12776, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12791, 12792, 12793, 12795, 12796, 12797, 12799, 12800, 12801, 12802, 12804, 12806, 12807, 12808, 12810, 12811, 12812, 12813, 12814, 12815, 12816, 12817, 12819, 12820, 12821, 12822, 12823, 12824, 12825, 12826, 12827, 12828, 12830, 12831, 12832, 12833, 12834, 12835, 12836, 12838, 12839, 12840, 12842, 12843, 12844, 12846, 12847, 12848, 12850, 12851, 12852, 12853, 12854, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863, 12865, 12866, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858, 13859, 13860, 13862, 13863, 13864, 13865, 13866, 13867, 13868, 13869, 13870, 13871, 13872, 13874, 13875, 13876, 13877, 13878, 13879, 13880, 13881, 13882, 13883, 13884, 13885, 13886, 13889, 13890, 13891, 13892, 13893, 13894, 13895, 13896, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13904, 13905, 13906, 13907, 13908, 13909, 13910, 13911, 13912, 13913, 13914, 13915, 13916, 13917, 13918, 13919, 13920, 13921, 13922, 13923, 13924, 13925, 13926, 13927, 13928, 13929, 13930, 13931, 13932, 13934, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13945, 13946, 13947, 13948, 13949, 13950, 13951, 13952, 13953, 13954, 13955, 13956, 13957, 13958, 13959, 13960, 13961, 13962, 13963, 13964, 13965, 13967, 13968, 13969, 13971, 13972, 13973, 13974, 13975, 13976, 13978, 13979, 13980, 13981, 13982, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13992, 13993, 13994, 13995, 13996, 13997, 13998, 13999, 14000, 14001, 14002, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14010, 14011, 14012, 14013, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14021, 14022, 14023, 14024, 14025, 14026, 14027, 14028, 14029, 14030, 14031, 14032, 14033, 14034, 14035, 14036, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047, 14048, 14049, 14050, 14051, 14052, 14053, 14054, 14055, 14056, 14058, 14059, 14061, 14062, 14063, 14065, 14066, 14068, 14069, 14070, 14071, 14072, 14084, 14085, 14086, 14087, 14088, 14089, 14090, 14091, 14092, 14093, 14094, 14095, 14097, 14098, 14099, 14100, 14101, 14102, 14103, 14104, 14105, 14106, 14107, 14108, 14109, 14111, 14112, 14113, 14114, 14115, 14116, 14117, 14119, 14120, 14121, 14122, 14123, 14124, 14125, 14126, 14127, 14128, 14129, 14130, 14131, 14132, 14133, 14134, 14135, 14136, 14137, 14138, 14139, 14140, 14142, 14143, 14144, 14145, 14146, 14147, 14148, 14149, 14150, 14151, 14152, 14153, 14154, 14155, 14156, 14157, 14158, 14159, 14160, 14161, 14162, 14163, 14164, 14165, 14166, 14167, 14168, 14169, 14170, 14172, 14173, 14174, 14175, 14176, 14178, 14179, 14180, 14181, 14182, 14185, 14186, 14187, 14188, 14189, 14190, 14191, 14192, 14193, 14194, 14195, 14196, 14197, 14198, 14199, 14200, 14201, 14202, 14203, 14205, 14206, 14207, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14216, 14217, 14219, 14220, 14221, 14222, 14223, 14224, 14225, 14226, 14227, 14228, 14229, 14230, 14231, 14232, 14233, 14234, 14235, 14236, 14237, 14238, 14239, 14240, 14241, 14242, 14243, 14244, 14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14257, 14258, 14259, 14260, 14261, 14262, 14264, 14265, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278, 14279, 14280, 14281, 14282, 14283, 14285, 14286, 14287, 14288, 14289, 14290, 14291, 14292, 14294, 14295, 14296, 14297, 14299, 14300, 14301, 14302, 14303, 14304, 14305, 14306, 14307, 14308, 14309, 14310, 14311, 14312, 14313, 14314, 14316, 14317, 14318, 14320, 14321, 14322, 14323, 14324, 14325, 14326, 14327, 14328, 14329, 14332, 14335, 14336, 14345, 14346, 14347, 14348)))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-15 07:38:45 Duration: 138ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND EXISTS ( SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template".id AND "product_template__public_categ_ids"."product_public_category_id" IN (12382, 12625, 12626, 12627, 12628, 12629, 12630, 12631, 12632, 12633, 12634, 12635, 12636, 12637, 12638, 12639, 12640, 12641, 12642, 12643, 12645, 12646, 12647, 12648, 12649, 12651, 12652, 12655, 12656, 12657, 12658, 12659, 12660, 12661, 12662, 12663, 12664, 12665, 12666, 12667, 12668, 12669, 12670, 12671, 12672, 12673, 12674, 12676, 12677, 12678, 12680, 12681, 12682, 12684, 12686, 12687, 12688, 12689, 12690, 12692, 12694, 12695, 12696, 12697, 12698, 12699, 12700, 12701, 12702, 12703, 12704, 12705, 12706, 12707, 12708, 12709, 12710, 12711, 12712, 12714, 12715, 12716, 12717, 12718, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12728, 12730, 12731, 12732, 12734, 12735, 12736, 12748, 12750, 12751, 12752, 12753, 12754, 12755, 12756, 12757, 12758, 12759, 12761, 12762, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12772, 12773, 12774, 12775, 12776, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12791, 12792, 12793, 12795, 12796, 12797, 12799, 12800, 12801, 12802, 12804, 12806, 12807, 12808, 12810, 12811, 12812, 12813, 12814, 12815, 12816, 12817, 12819, 12820, 12821, 12822, 12823, 12824, 12825, 12826, 12827, 12828, 12830, 12831, 12832, 12833, 12834, 12835, 12836, 12838, 12839, 12840, 12842, 12843, 12844, 12846, 12847, 12848, 12850, 12851, 12852, 12853, 12854, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863, 12865, 12866, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858, 13859, 13860, 13862, 13863, 13864, 13865, 13866, 13867, 13868, 13869, 13870, 13871, 13872, 13874, 13875, 13876, 13877, 13878, 13879, 13880, 13881, 13882, 13883, 13884, 13885, 13886, 13889, 13890, 13891, 13892, 13893, 13894, 13895, 13896, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13904, 13905, 13906, 13907, 13908, 13909, 13910, 13911, 13912, 13913, 13914, 13915, 13916, 13917, 13918, 13919, 13920, 13921, 13922, 13923, 13924, 13925, 13926, 13927, 13928, 13929, 13930, 13931, 13932, 13934, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13945, 13946, 13947, 13948, 13949, 13950, 13951, 13952, 13953, 13954, 13955, 13956, 13957, 13958, 13959, 13960, 13961, 13962, 13963, 13964, 13965, 13967, 13968, 13969, 13971, 13972, 13973, 13974, 13975, 13976, 13978, 13979, 13980, 13981, 13982, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13992, 13993, 13994, 13995, 13996, 13997, 13998, 13999, 14000, 14001, 14002, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14010, 14011, 14012, 14013, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14021, 14022, 14023, 14024, 14025, 14026, 14027, 14028, 14029, 14030, 14031, 14032, 14033, 14034, 14035, 14036, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047, 14048, 14049, 14050, 14051, 14052, 14053, 14054, 14055, 14056, 14058, 14059, 14061, 14062, 14063, 14065, 14066, 14068, 14069, 14070, 14071, 14072, 14084, 14085, 14086, 14087, 14088, 14089, 14090, 14091, 14092, 14093, 14094, 14095, 14097, 14098, 14099, 14100, 14101, 14102, 14103, 14104, 14105, 14106, 14107, 14108, 14109, 14111, 14112, 14113, 14114, 14115, 14116, 14117, 14119, 14120, 14121, 14122, 14123, 14124, 14125, 14126, 14127, 14128, 14129, 14130, 14131, 14132, 14133, 14134, 14135, 14136, 14137, 14138, 14139, 14140, 14142, 14143, 14144, 14145, 14146, 14147, 14148, 14149, 14150, 14151, 14152, 14153, 14154, 14155, 14156, 14157, 14158, 14159, 14160, 14161, 14162, 14163, 14164, 14165, 14166, 14167, 14168, 14169, 14170, 14172, 14173, 14174, 14175, 14176, 14178, 14179, 14180, 14181, 14182, 14185, 14186, 14187, 14188, 14189, 14190, 14191, 14192, 14193, 14194, 14195, 14196, 14197, 14198, 14199, 14200, 14201, 14202, 14203, 14205, 14206, 14207, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14216, 14217, 14219, 14220, 14221, 14222, 14223, 14224, 14225, 14226, 14227, 14228, 14229, 14230, 14231, 14232, 14233, 14234, 14235, 14236, 14237, 14238, 14239, 14240, 14241, 14242, 14243, 14244, 14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14257, 14258, 14259, 14260, 14261, 14262, 14264, 14265, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278, 14279, 14280, 14281, 14282, 14283, 14285, 14286, 14287, 14288, 14289, 14290, 14291, 14292, 14294, 14295, 14296, 14297, 14299, 14300, 14301, 14302, 14303, 14304, 14305, 14306, 14307, 14308, 14309, 14310, 14311, 14312, 14313, 14314, 14316, 14317, 14318, 14320, 14321, 14322, 14323, 14324, 14325, 14326, 14327, 14328, 14329, 14332, 14335, 14336, 14345, 14346, 14347, 14348)))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-15 02:17:00 Duration: 123ms
-
SELECT "product_template".id FROM "product_template" WHERE (("product_template"."active" = true) AND ((("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND EXISTS ( SELECT 1 FROM "product_public_category_product_template_rel" AS "product_template__public_categ_ids" WHERE "product_template__public_categ_ids"."product_template_id" = "product_template".id AND "product_template__public_categ_ids"."product_public_category_id" IN (12382, 12625, 12626, 12627, 12628, 12629, 12630, 12631, 12632, 12633, 12634, 12635, 12636, 12637, 12638, 12639, 12640, 12641, 12642, 12643, 12645, 12646, 12647, 12648, 12649, 12651, 12652, 12655, 12656, 12657, 12658, 12659, 12660, 12661, 12662, 12663, 12664, 12665, 12666, 12667, 12668, 12669, 12670, 12671, 12672, 12673, 12674, 12676, 12677, 12678, 12680, 12681, 12682, 12684, 12686, 12687, 12688, 12689, 12690, 12692, 12694, 12695, 12696, 12697, 12698, 12699, 12700, 12701, 12702, 12703, 12704, 12705, 12706, 12707, 12708, 12709, 12710, 12711, 12712, 12714, 12715, 12716, 12717, 12718, 12719, 12720, 12721, 12722, 12723, 12724, 12725, 12726, 12728, 12730, 12731, 12732, 12734, 12735, 12736, 12748, 12750, 12751, 12752, 12753, 12754, 12755, 12756, 12757, 12758, 12759, 12761, 12762, 12764, 12765, 12766, 12767, 12768, 12769, 12770, 12771, 12772, 12773, 12774, 12775, 12776, 12778, 12779, 12780, 12781, 12782, 12783, 12784, 12785, 12786, 12787, 12788, 12789, 12790, 12791, 12792, 12793, 12795, 12796, 12797, 12799, 12800, 12801, 12802, 12804, 12806, 12807, 12808, 12810, 12811, 12812, 12813, 12814, 12815, 12816, 12817, 12819, 12820, 12821, 12822, 12823, 12824, 12825, 12826, 12827, 12828, 12830, 12831, 12832, 12833, 12834, 12835, 12836, 12838, 12839, 12840, 12842, 12843, 12844, 12846, 12847, 12848, 12850, 12851, 12852, 12853, 12854, 12856, 12857, 12858, 12859, 12860, 12861, 12862, 12863, 12865, 12866, 13835, 13836, 13837, 13838, 13839, 13840, 13841, 13842, 13843, 13844, 13845, 13846, 13847, 13848, 13849, 13850, 13851, 13852, 13853, 13854, 13855, 13856, 13857, 13858, 13859, 13860, 13862, 13863, 13864, 13865, 13866, 13867, 13868, 13869, 13870, 13871, 13872, 13874, 13875, 13876, 13877, 13878, 13879, 13880, 13881, 13882, 13883, 13884, 13885, 13886, 13889, 13890, 13891, 13892, 13893, 13894, 13895, 13896, 13897, 13898, 13899, 13900, 13901, 13902, 13903, 13904, 13905, 13906, 13907, 13908, 13909, 13910, 13911, 13912, 13913, 13914, 13915, 13916, 13917, 13918, 13919, 13920, 13921, 13922, 13923, 13924, 13925, 13926, 13927, 13928, 13929, 13930, 13931, 13932, 13934, 13935, 13936, 13937, 13938, 13939, 13940, 13941, 13942, 13943, 13944, 13945, 13946, 13947, 13948, 13949, 13950, 13951, 13952, 13953, 13954, 13955, 13956, 13957, 13958, 13959, 13960, 13961, 13962, 13963, 13964, 13965, 13967, 13968, 13969, 13971, 13972, 13973, 13974, 13975, 13976, 13978, 13979, 13980, 13981, 13982, 13984, 13985, 13986, 13987, 13988, 13989, 13990, 13991, 13992, 13993, 13994, 13995, 13996, 13997, 13998, 13999, 14000, 14001, 14002, 14003, 14004, 14005, 14006, 14007, 14008, 14009, 14010, 14011, 14012, 14013, 14014, 14015, 14016, 14017, 14018, 14019, 14020, 14021, 14022, 14023, 14024, 14025, 14026, 14027, 14028, 14029, 14030, 14031, 14032, 14033, 14034, 14035, 14036, 14038, 14039, 14040, 14041, 14042, 14043, 14044, 14045, 14046, 14047, 14048, 14049, 14050, 14051, 14052, 14053, 14054, 14055, 14056, 14058, 14059, 14061, 14062, 14063, 14065, 14066, 14068, 14069, 14070, 14071, 14072, 14084, 14085, 14086, 14087, 14088, 14089, 14090, 14091, 14092, 14093, 14094, 14095, 14097, 14098, 14099, 14100, 14101, 14102, 14103, 14104, 14105, 14106, 14107, 14108, 14109, 14111, 14112, 14113, 14114, 14115, 14116, 14117, 14119, 14120, 14121, 14122, 14123, 14124, 14125, 14126, 14127, 14128, 14129, 14130, 14131, 14132, 14133, 14134, 14135, 14136, 14137, 14138, 14139, 14140, 14142, 14143, 14144, 14145, 14146, 14147, 14148, 14149, 14150, 14151, 14152, 14153, 14154, 14155, 14156, 14157, 14158, 14159, 14160, 14161, 14162, 14163, 14164, 14165, 14166, 14167, 14168, 14169, 14170, 14172, 14173, 14174, 14175, 14176, 14178, 14179, 14180, 14181, 14182, 14185, 14186, 14187, 14188, 14189, 14190, 14191, 14192, 14193, 14194, 14195, 14196, 14197, 14198, 14199, 14200, 14201, 14202, 14203, 14205, 14206, 14207, 14208, 14209, 14210, 14211, 14212, 14213, 14214, 14215, 14216, 14217, 14219, 14220, 14221, 14222, 14223, 14224, 14225, 14226, 14227, 14228, 14229, 14230, 14231, 14232, 14233, 14234, 14235, 14236, 14237, 14238, 14239, 14240, 14241, 14242, 14243, 14244, 14245, 14246, 14247, 14248, 14249, 14250, 14251, 14252, 14253, 14254, 14255, 14256, 14257, 14258, 14259, 14260, 14261, 14262, 14264, 14265, 14267, 14268, 14269, 14270, 14271, 14272, 14273, 14274, 14275, 14276, 14277, 14278, 14279, 14280, 14281, 14282, 14283, 14285, 14286, 14287, 14288, 14289, 14290, 14291, 14292, 14294, 14295, 14296, 14297, 14299, 14300, 14301, 14302, 14303, 14304, 14305, 14306, 14307, 14308, 14309, 14310, 14311, 14312, 14313, 14314, 14316, 14317, 14318, 14320, 14321, 14322, 14323, 14324, 14325, 14326, 14327, 14328, 14329, 14332, 14335, 14336, 14345, 14346, 14347, 14348)))) ORDER BY COALESCE("product_template"."is_published", false) DESC, "product_template"."website_sequence" ASC, "product_template"."id" DESC;
Date: 2023-07-15 08:45:08 Duration: 123ms
12 5 9s395ms 1s873ms 1s886ms 1s879ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and (((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 01 5 9s395ms 1s879ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:03:50 Duration: 1s886ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:02:09 Duration: 1s879ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:56 Duration: 1s878ms
13 3 7s458ms 2s479ms 2s497ms 2s486ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and ((((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 01 3 7s458ms 2s486ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:05:28 Duration: 2s497ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-0088%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-0088%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:14 Duration: 2s481ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:06:20 Duration: 2s479ms
14 3 368ms 120ms 126ms 122ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and ((("product_template"."company_id" in (...)) or "product_template"."company_id" is null) and ((("product_template"."is_published" = true) and (("product_template"."website_id" in (...)) or "product_template"."website_id" is null)) and ("product_template"."sale_ok" = true))) order by coalesce("product_template__name"."value", "product_template"."name");Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 06 2 242ms 121ms 18 1 126ms 126ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-07-15 18:31:00 Duration: 126ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-07-15 06:12:34 Duration: 121ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ((("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) AND ((("product_template"."is_published" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL)) AND ("product_template"."sale_ok" = true))) ORDER BY COALESCE("product_template__name"."value", "product_template"."name");
Date: 2023-07-15 06:12:39 Duration: 120ms
15 2 2s536ms 1s267ms 1s268ms 1s268ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and ((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 01 2 2s536ms 1s268ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:01:42 Duration: 1s268ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:39 Duration: 1s267ms
16 2 1s863ms 906ms 956ms 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 ? and ill.method not in (...) and idp.id not in ( select item_demand_plan_id from item_list_line where coalesce(method, ?) = ?) and fd.id is null group by idp.id, ill.method;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 04 2 1s863ms 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 '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-15 04:30:03 Duration: 956ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-15 04:00:03 Duration: 906ms
17 2 1s451ms 722ms 728ms 725ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 13 2 1s451ms 725ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%65152b%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%65152b%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%65152b%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%65152b%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:55:30 Duration: 728ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%3687%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3687%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%3687%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3687%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:52:59 Duration: 722ms
18 2 1s340ms 668ms 672ms 670ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Jul 15 01 2 1s340ms 670ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:01:33 Duration: 672ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:24 Duration: 668ms
19 2 1s196ms 592ms 603ms 598ms select "account_move".id from "account_move" where (("account_move"."move_type" = ?) and (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 01 2 1s196ms 598ms -
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."move_type" = 'out_invoice') AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:00:52 Duration: 603ms
-
SELECT "account_move".id FROM "account_move" WHERE (("account_move"."move_type" = 'out_invoice') AND (((((unaccent ("account_move"."name"::text) ilike unaccent ('%07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%07398%'))) OR FALSE)) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:00:37 Duration: 592ms
20 2 701ms 350ms 351ms 350ms update item_demand_plan set is_start_forecast = false where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill left join item_demand_plan as idp on ill.item_demand_plan_id = idp.id where method in (...) and idp.fetch_data_done = true and idp.active = true group by ill.item_demand_plan_id intersect select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = true group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand left join item_demand_plan as idp2 on data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = true);Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 04 2 701ms 350ms -
update item_demand_plan set is_start_forecast = False where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where method in (7, 8) and idp.fetch_data_done = True and idp.active = True group by ill.item_demand_plan_id INTERSECT select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = True group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand LEFT JOIN item_demand_plan as idp2 ON data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = True);
Date: 2023-07-15 04:30:02 Duration: 351ms
-
update item_demand_plan set is_start_forecast = False where id in ( with data_demand as ( select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where method in (7, 8) and idp.fetch_data_done = True and idp.active = True group by ill.item_demand_plan_id INTERSECT select ill.item_demand_plan_id as item_demand_plan_id, count(ill.id) as total_count from item_list_line as ill where ill.active = True group by ill.item_demand_plan_id ) select data_demand.item_demand_plan_id from data_demand LEFT JOIN item_demand_plan as idp2 ON data_demand.item_demand_plan_id = idp2.id where idp2.is_start_forecast = True);
Date: 2023-07-15 04:00:02 Duration: 350ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 3m43s 3m43s 3m43s 1 3m43s copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Jul 15 09 1 3m43s 3m43s -
COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:07:10 Duration: 3m43s
2 1m13s 1m13s 1m13s 1 1m13s copy public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Jul 15 09 1 1m13s 1m13s -
COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;
Date: 2023-07-15 09:02:11 Duration: 1m13s
3 1m11s 1m11s 1m11s 1 1m11s copy public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) to stdout;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Jul 15 09 1 1m11s 1m11s -
COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;
Date: 2023-07-15 09:03:27 Duration: 1m11s
4 26s766ms 26s766ms 26s766ms 1 26s766ms copy public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Jul 15 09 1 26s766ms 26s766ms -
COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:09:16 Duration: 26s766ms
5 21s266ms 21s266ms 21s266ms 1 21s266ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) to stdout;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Jul 15 09 1 21s266ms 21s266ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;
Date: 2023-07-15 09:08:12 Duration: 21s266ms
6 16s788ms 16s788ms 16s788ms 1 16s788ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Jul 15 09 1 16s788ms 16s788ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-07-15 09:08:50 Duration: 16s788ms
7 15s158ms 15s158ms 15s158ms 1 15s158ms copy public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Jul 15 09 1 15s158ms 15s158ms -
COPY public.account_move_line (id, move_id, move_name, date, ref, parent_state, journal_id, company_id, company_currency_id, account_id, account_root_id, sequence, name, quantity, price_unit, discount, debit, credit, balance, amount_currency, price_subtotal, price_total, reconciled, blocked, date_maturity, currency_id, partner_id, product_uom_id, product_id, reconcile_model_id, payment_id, statement_line_id, statement_id, tax_line_id, tax_group_id, tax_base_amount, tax_exigible, tax_repartition_line_id, tax_audit, amount_residual, amount_residual_currency, full_reconcile_id, matching_number, analytic_account_id, display_type, is_rounding_line, exclude_from_invoice_tab, create_uid, create_date, write_uid, write_date, expected_pay_date, internal_note, next_action_date, followup_line_id, followup_date, is_anglo_saxon_line, purchase_line_id, branch_id, branch_name, vehicle_id, move_options, sign_product_qty, sign_price_subtotal, new_product_qty, sale_line_id, child_sale_line_id, main_invoice_line_id, core_bank_transaction, is_rtv_line, core_qty, rebate_amount, cost_price, is_visible_in_report, is_labour, can_be_paid, bal_core_bank_id, repair_line_id, inv_back_order_qty, sale_back_order_qty, product_pricelist_item_id, is_discount, is_sale_tax) TO stdout;
Date: 2023-07-15 09:00:25 Duration: 15s158ms
8 10s447ms 10s447ms 10s447ms 1 10s447ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Jul 15 09 1 10s447ms 10s447ms -
COPY public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:00:41 Duration: 10s447ms
9 6s256ms 6s256ms 6s256ms 1 6s256ms copy public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type) to stdout;Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Jul 15 09 1 6s256ms 6s256ms -
COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date, partner_address_type) TO stdout;
Date: 2023-07-15 09:00:10 Duration: 6s256ms
10 4s725ms 4s725ms 4s725ms 1 4s725ms copy public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Jul 15 09 1 4s725ms 4s725ms -
COPY public.price_sheet (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, additional_description_sale, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, active, volume, is_exception, create_uid, create_date, write_uid, write_date) TO stdout;
Date: 2023-07-15 09:07:15 Duration: 4s725ms
11 4s659ms 4s659ms 4s659ms 1 4s659ms copy public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) to stdout;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Jul 15 09 1 4s659ms 4s659ms -
COPY public.product_library (id, price_sheet_control_id, inventory_vendor_id, vendor_short_name, part_type_id, part_type_option, default_code, name, description_sale, description, condensed_product_name, manufacturer_product_name, weight, uom_id, standard_price, current_cost, rebate_cost, purchase_cost, list_price, better, best, list_jobber, core_part_no, cores_per_part, core_cost, core_price_part_dmg_1, core_price_part_dmg_2, used_core_description, man_cost_update, call_for_prise, product_update_date, standard_carton_quantity, additional_description_sale, active, volume, is_exception, create_uid, create_date, write_uid, write_date, library_duplicate_check) TO stdout;
Date: 2023-07-15 09:07:22 Duration: 4s659ms
12 4s261ms 4s261ms 4s261ms 1 4s261ms 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;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Jul 15 09 1 4s261ms 4s261ms -
COPY public.stock_move (id, name, sequence, priority, create_date, date, date_deadline, company_id, product_id, description_picking, product_qty, product_uom_qty, product_uom, location_id, location_dest_id, partner_id, picking_id, note, state, price_unit, origin, procure_method, scrapped, group_id, rule_id, propagate_cancel, delay_alert_date, picking_type_id, inventory_id, origin_returned_move_id, restrict_partner_id, warehouse_id, additional, reference, package_level_id, next_serial, next_serial_count, orderpoint_id, create_uid, write_uid, write_date, to_refund, sale_line_id, purchase_line_id, created_purchase_line_id, is_done, created_production_id, production_id, raw_material_production_id, unbuild_id, consume_unbuild_id, operation_id, workorder_id, bom_line_id, byproduct_id, unit_factor, branch_id, weight, move_options, related_core_sale_line_id, related_core_purchase_line_id, sm_line_id, core_qty, bom_action, mrp_core_move, repair_id, repair_line_id, related_core_repair_line_id, related_bom_line_id, mrp_finish_core_move, picking_code, transfer_line_id, src_warehouse_id, dest_warehouse_id, current_warehouse_qty, is_core) TO stdout;
Date: 2023-07-15 09:08:24 Duration: 4s261ms
13 857ms 12s127ms 2s969ms 18 53s448ms delete from account_move_line where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Jul 15 00 1 4s431ms 4s431ms 06 1 1s865ms 1s865ms 07 2 5s281ms 2s640ms 10 10 33s11ms 3s301ms 14 1 1s729ms 1s729ms 15 2 5s279ms 2s639ms 22 1 1s849ms 1s849ms -
DELETE FROM account_move_line WHERE id IN (2717406, 2717407, 2717394, 2717395, 2717396, 2717397, 2717398, 2717399, 2717400, 2717401, 2717402, 2717403, 2717404, 2717405);
Date: 2023-07-15 10:17:56 Duration: 12s127ms
-
DELETE FROM account_move_line WHERE id IN (2720856, 2720857, 2720858, 2720859, 2720860, 2720861, 2720862, 2720863, 2720864, 2720865, 2720866, 2720867, 2720868);
Date: 2023-07-15 10:18:11 Duration: 11s260ms
-
DELETE FROM account_move_line WHERE id IN (2475522, 2475523, 2718148, 2718149, 2718150);
Date: 2023-07-15 00:05:12 Duration: 4s431ms
14 2s479ms 2s497ms 2s486ms 3 7s458ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and ((((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Jul 15 01 3 7s458ms 2s486ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:05:28 Duration: 2s497ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-0088%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-0088%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-0088%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:14 Duration: 2s481ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00889%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00889%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00889%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:06:20 Duration: 2s479ms
15 1s873ms 1s886ms 1s879ms 5 9s395ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and (((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false)) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Jul 15 01 5 9s395ms 1s879ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:03:50 Duration: 1s886ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-RINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-RINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-RINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:02:09 Duration: 1s879ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND (((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE)) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-rINV-00789%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-rINV-00789%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-rINV-00789%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:56 Duration: 1s878ms
16 1s51ms 2s271ms 1s418ms 11 15s605ms delete from account_move where id in (...);Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Jul 15 00 1 2s271ms 2s271ms 06 1 1s220ms 1s220ms 07 2 2s260ms 1s130ms 10 3 5s299ms 1s766ms 14 1 1s70ms 1s70ms 15 2 2s272ms 1s136ms 22 1 1s210ms 1s210ms -
DELETE FROM account_move WHERE id IN (685659, 758084);
Date: 2023-07-15 00:05:14 Duration: 2s271ms
-
DELETE FROM account_move WHERE id IN (757692, 751302);
Date: 2023-07-15 10:17:33 Duration: 2s119ms
-
DELETE FROM account_move WHERE id IN (757849, 757848);
Date: 2023-07-15 10:17:58 Duration: 2s115ms
17 1s267ms 1s268ms 1s268ms 2 2s536ms select "account_move".id from "account_move" where (((("account_move"."move_type" in (...)) or ("account_move"."non_inventory_entry" = true)) and ("account_move"."move_type" in (...))) and ((((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false) or (((((unaccent ("account_move"."name"::text) ilike unaccent (?)) or (unaccent ("account_move"."invoice_origin"::text) ilike unaccent (?))) or (unaccent ("account_move"."ref"::text) ilike unaccent (?))) or (unaccent ("account_move"."payment_reference"::text) ilike unaccent (?))) or false))) and ("account_move"."company_id" is null or ("account_move"."company_id" in (...))) order by "account_move"."invoice_date_due" limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Jul 15 01 2 2s536ms 1s268ms -
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:01:42 Duration: 1s268ms
-
SELECT "account_move".id FROM "account_move" WHERE (((("account_move"."move_type" in ('out_invoice', 'out_refund')) OR ("account_move"."non_inventory_entry" = true)) AND ("account_move"."move_type" in ('out_invoice', 'out_refund'))) AND ((((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-07398%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-07398%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-07398%'))) OR FALSE) OR (((((unaccent ("account_move"."name"::text) ilike unaccent ('%T-INV-08477%')) OR (unaccent ("account_move"."invoice_origin"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."ref"::text) ilike unaccent ('%T-INV-08477%'))) OR (unaccent ("account_move"."payment_reference"::text) ilike unaccent ('%T-INV-08477%'))) OR FALSE))) AND ("account_move"."company_id" IS NULL OR ("account_move"."company_id" in (1))) ORDER BY "account_move"."invoice_date_due" LIMIT 80;
Date: 2023-07-15 01:04:39 Duration: 1s267ms
18 906ms 956ms 931ms 2 1s863ms 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 #18
Day Hour Count Duration Avg duration Jul 15 04 2 1s863ms 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 '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-15 04:30:03 Duration: 956ms
-
select DISTINCT idp.id as item_demand_plan_id from item_demand_plan idp LEFT JOIN item_list_line AS ill ON idp.id = ill.item_demand_plan_id LEFT JOIN forecasted_data AS fd ON idp.id = fd.item_demand_plan_id WHERE idp.fetch_data_done = True and idp.active = True and idp.create_date > current_timestamp - interval '2 day' and ill.method not in (7, 8) and idp.id not in ( select item_demand_plan_id from item_list_line where COALESCE(method, 111) = 111) and fd.id is null group by idp.id, ill.method;
Date: 2023-07-15 04:00:03 Duration: 906ms
19 722ms 728ms 725ms 2 1s451ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and (("product_template"."type" in (...)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Jul 15 13 2 1s451ms 725ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%65152b%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%65152b%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%65152b%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%65152b%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:55:30 Duration: 728ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND (("product_template"."type" in ('consu', 'product')) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%3687%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3687%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%3687%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3687%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:52:59 Duration: 722ms
20 703ms 729ms 717ms 41 29s418ms select "product_template".id from "product_template" left join "ir_translation" AS "product_template__name" on ("product_template"."id" = "product_template__name"."res_id" and "product_template__name"."type" = ? and "product_template__name"."name" = ? and "product_template__name"."lang" = ? and "product_template__name"."value" != ?) where (("product_template"."active" = true) and (("product_template"."is_core" is null or "product_template"."is_core" = false) and ((("product_template"."sale_ok" = true) or ("product_template"."purchase_ok" = true)) and (((((unaccent ("product_template"."default_code"::text) ilike unaccent (?)) or ("product_template"."id" in ( select "product_product"."product_tmpl_id" from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") where (("product_product"."active" = true) and (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null)))) or unaccent (coalesce("product_template__name"."value", "product_template"."name")) ilike unaccent (?)) or false) or (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent (?)))))) and (("product_template"."company_id" in (...)) or "product_template"."company_id" is null) order by coalesce("product_template__name"."value", "product_template"."name") limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Jul 15 12 2 1s434ms 717ms 13 34 24s410ms 717ms 14 5 3s574ms 714ms -
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%22-p-127%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%22-p-127%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%22-p-127%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%22-p-127%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:10:40 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%3149325229%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%3149325229%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%3149325229%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%3149325229%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:23:08 Duration: 729ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."is_core" IS NULL or "product_template"."is_core" = false) AND ((("product_template"."sale_ok" = true) OR ("product_template"."purchase_ok" = true)) AND (((((unaccent ("product_template"."default_code"::text) ilike unaccent ('%500007-24%')) OR ("product_template"."id" IN ( SELECT "product_product"."product_tmpl_id" FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") WHERE (("product_product"."active" = true) AND (unaccent ("product_product"."default_code"::text) ilike unaccent ('%500007-24%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL)))) OR unaccent (COALESCE("product_template__name"."value", "product_template"."name")) ilike unaccent ('%500007-24%')) OR FALSE) OR (unaccent ("product_template"."condensed_internal_ref"::text) ilike unaccent ('%500007-24%')))))) AND (("product_template"."company_id" in (1)) OR "product_template"."company_id" IS NULL) ORDER BY COALESCE("product_template__name"."value", "product_template"."name") LIMIT 80;
Date: 2023-07-15 13:49:31 Duration: 728ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 1,080 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 361 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 358 Max number of times the same event was reported
- 361 Total events found
Rank Times reported Error 1 358 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Jul 15 00 26 01 39 02 16 03 11 04 9 05 15 06 11 07 23 08 17 09 14 10 22 11 13 12 11 13 9 14 10 15 17 16 11 17 14 18 11 19 13 20 13 21 13 22 15 23 5 - ERROR: could not obtain lock on row in relation "ir_cron"
- ERROR: could not obtain lock on row in relation "website_visitor"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=68 FOR UPDATE NOWAIT
Date: 2023-07-15 00:00:19
Statement: SELECT * FROM website_visitor where id = 4642515 FOR NO KEY UPDATE NOWAIT
Date: 2023-07-15 08:44:59
2 3 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Jul 15 00 1 08 1 19 1 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-07-15 00:48:19',"last_presence"='2023-07-15 00:48:18.741350' WHERE id IN (17)
Date: 2023-07-15 00:48:19