pgBadger-
Global information
- Generated on Sat Apr 15 23:50:18 2023
- Log file: /var/log/postgresql/postgresql-14-main.log
- Parsed 8,521 log entries in 17s
- Log start from 2023-04-15 00:30:05 to 2023-04-15 23:40:06
-
Overview
Global Stats
- 136 Number of unique normalized queries
- 2,894 Number of queries
- 16m18s Total query duration
- 2023-04-15 00:30:05 First query
- 2023-04-15 23:35:08 Last query
- 7 queries/s at 2023-04-15 00:33:46 Query peak
- 16m18s Total query duration
- 0ms Prepare/parse total duration
- 0ms Bind total duration
- 16m18s Execute total duration
- 679 Number of events
- 2 Number of unique normalized events
- 675 Max number of times the same event was reported
- 0 Number of cancellation
- 0 Total number of automatic vacuums
- 0 Total number of automatic analyzes
- 0 Number temporary file
- 0 Max size of temporary file
- 0.00 B Average size of temporary file
- 0 Total number of sessions
- 0 sessions at Session peak
- 0ms Total duration of sessions
- 0ms Average duration of sessions
- 2,894 Average queries per session
- 16m18s Average queries duration per session
- n/a Average idle time per session
- 0 Total number of connections
- 1 Total number of databases
SQL Traffic
Key values
- 7 queries/s Query Peak
- 2023-04-15 00:33:46 Date
SELECT Traffic
Key values
- 7 queries/s Query Peak
- 2023-04-15 00:33:46 Date
INSERT/UPDATE/DELETE Traffic
Key values
- 3 queries/s Query Peak
- 2023-04-15 09:00:39 Date
Queries duration
Key values
- 16m18s 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) Apr 15 00 163 0ms 901ms 155ms 9s531ms 9s531ms 9s531ms 01 166 0ms 12s862ms 434ms 14s542ms 32s219ms 32s219ms 02 166 0ms 228ms 168ms 4s220ms 4s984ms 4s984ms 03 134 0ms 273ms 150ms 4s575ms 4s575ms 4s575ms 04 246 0ms 658ms 174ms 4s713ms 22s631ms 22s631ms 05 137 0ms 272ms 150ms 4s426ms 4s426ms 4s426ms 06 173 0ms 812ms 166ms 7s541ms 7s541ms 7s541ms 07 182 0ms 1s487ms 178ms 5s254ms 12s165ms 12s165ms 08 277 0ms 896ms 166ms 11s397ms 12s555ms 12s555ms 09 410 0ms 44s857ms 908ms 34s464ms 58s140ms 1m12s 10 90 0ms 16s936ms 1s198ms 31s826ms 31s826ms 31s826ms 11 1 0ms 146ms 146ms 146ms 146ms 146ms 12 5 0ms 149ms 139ms 287ms 287ms 287ms 13 27 0ms 870ms 347ms 1s933ms 4s824ms 4s824ms 14 1 0ms 140ms 140ms 140ms 140ms 140ms 15 8 0ms 849ms 713ms 5s572ms 5s572ms 5s572ms 16 2 0ms 890ms 872ms 1s745ms 1s745ms 1s745ms 17 88 0ms 576ms 372ms 3s100ms 3s309ms 4s892ms 18 90 0ms 1s636ms 483ms 5s436ms 5s667ms 8s67ms 19 17 0ms 554ms 402ms 2s167ms 2s167ms 2s167ms 20 0 0ms 0ms 0ms 0ms 0ms 0ms 21 0 0ms 0ms 0ms 0ms 0ms 0ms 22 219 0ms 274ms 161ms 8s744ms 8s744ms 8s744ms 23 292 0ms 339ms 154ms 13s96ms 13s96ms 13s96ms Day Hour SELECT COPY TO Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 15 00 161 0 146ms 6s133ms 9s531ms 9s531ms 01 155 0 163ms 4s589ms 5s169ms 6s48ms 02 166 0 168ms 4s159ms 4s220ms 4s984ms 03 134 0 150ms 4s521ms 4s575ms 4s575ms 04 243 0 171ms 4s124ms 4s713ms 22s631ms 05 137 0 150ms 4s364ms 4s426ms 4s426ms 06 173 0 166ms 7s174ms 7s541ms 7s541ms 07 179 0 169ms 4s822ms 5s254ms 10s30ms 08 275 0 161ms 5s767ms 11s397ms 12s555ms 09 339 60 896ms 8s433ms 34s344ms 1m12s 10 57 0 496ms 0ms 28s294ms 28s294ms 11 1 0 146ms 146ms 146ms 146ms 12 5 0 139ms 268ms 287ms 287ms 13 23 0 345ms 760ms 1s353ms 4s824ms 14 1 0 140ms 140ms 140ms 140ms 15 8 0 713ms 5s572ms 5s572ms 5s572ms 16 0 0 0ms 0ms 0ms 0ms 17 87 0 372ms 2s741ms 3s100ms 4s892ms 18 76 0 449ms 3s243ms 3s799ms 8s67ms 19 16 0 402ms 1s623ms 2s167ms 2s167ms 20 0 0 0ms 0ms 0ms 0ms 21 0 0 0ms 0ms 0ms 0ms 22 219 0 161ms 8s233ms 8s744ms 8s744ms 23 292 0 154ms 11s308ms 13s96ms 13s96ms Day Hour INSERT UPDATE DELETE COPY FROM Average Duration Latency Percentile(90) Latency Percentile(95) Latency Percentile(99) Apr 15 00 0 0 2 0 879ms 0ms 0ms 1s759ms 01 0 0 11 0 4s251ms 0ms 0ms 32s219ms 02 0 0 0 0 0ms 0ms 0ms 0ms 03 0 0 0 0 0ms 0ms 0ms 0ms 04 0 3 0 0 363ms 0ms 0ms 1s90ms 05 0 0 0 0 0ms 0ms 0ms 0ms 06 0 0 0 0 0ms 0ms 0ms 0ms 07 0 3 0 0 711ms 0ms 0ms 2s134ms 08 0 0 2 0 876ms 0ms 0ms 1s752ms 09 0 11 0 0 1s355ms 0ms 1s460ms 2s886ms 10 0 0 33 0 2s411ms 19s294ms 28s450ms 31s826ms 11 0 0 0 0 0ms 0ms 0ms 0ms 12 0 0 0 0 0ms 0ms 0ms 0ms 13 0 4 0 0 355ms 0ms 0ms 1s172ms 14 0 0 0 0 0ms 0ms 0ms 0ms 15 0 0 0 0 0ms 0ms 0ms 0ms 16 0 0 2 0 872ms 0ms 0ms 1s745ms 17 0 0 0 0 0ms 0ms 0ms 0ms 18 0 0 13 0 689ms 0ms 411ms 5s667ms 19 0 0 0 0 0ms 0ms 0ms 0ms 20 0 0 0 0 0ms 0ms 0ms 0ms 21 0 0 0 0 0ms 0ms 0ms 0ms 22 0 0 0 0 0ms 0ms 0ms 0ms 23 0 0 0 0 0ms 0ms 0ms 0ms Day Hour Prepare Bind Bind/Prepare Percentage of prepare Apr 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 Apr 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 Apr 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 Apr 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 Apr 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) Apr 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 Apr 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 Apr 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 Apr 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
- 2,747 Total read queries
- 147 Total write queries
Queries by database
Key values
- unknown Main database
- 2,894 Requests
- 16m18s (unknown)
- Main time consuming database
Queries by user
Key values
- unknown Main user
- 43,971 Requests
User Request type Count Duration unknown Total 43,971 9h1s copy to 120 7m18s cte 1,407 3m43s delete 291 8m27s insert 1,933 37m41s select 24,081 2h33m38s update 16,139 5h29m11s Duration by user
Key values
- 9h1s (unknown) Main time consuming user
User Request type Count Duration unknown Total 43,971 9h1s copy to 120 7m18s cte 1,407 3m43s delete 291 8m27s insert 1,933 37m41s select 24,081 2h33m38s update 16,139 5h29m11s Queries by host
Key values
- unknown Main host
- 43,971 Requests
- 9h1s (unknown)
- Main time consuming host
Queries by application
Key values
- unknown Main application
- 2,894 Requests
- 16m18s (unknown)
- Main time consuming application
Number of cancelled queries
Key values
- 0 per second Cancelled query Peak
- 2023-04-15 09:17:00 Date
Number of cancelled queries (5 minutes period)
NO DATASET
-
Top Queries
Histogram of query times
Key values
- 2,585 100-500ms duration
Slowest individual queries
Rank Duration Query 1 44s857ms 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-04-15 09:01:24 ]
2 25s594ms 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-04-15 09:02:18 ]
3 25s463ms 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-04-15 09:01:52 ]
4 20s61ms COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;[ Date: 2023-04-15 09:03:08 ]
5 16s936ms DELETE FROM account_move_line WHERE id IN (2095341, 2095342, 2090766, 2090767, 2090768, 2090769, 2090770, 2090771, 2090772, 2090773, 2090774, 2090775, 2090776, 2090777, 2090778, 2090779, 2090780, 2090781, 2090782, 2090783, 2090784, 2090785, 2090786, 2090787, 2090788, 2090789, 2090790, 2090791, 2090792, 2090793, 2090794, 2090795, 2090796, 2090797, 2090798, 2090799, 2090800, 2090801, 2090802, 2090803, 2090804);[ Date: 2023-04-15 10:29:26 ]
6 15s824ms 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-04-15 09:03:47 ]
7 12s862ms DELETE FROM account_move_line WHERE id IN (2100428, 2100429, 2100430, 2100431, 2100401, 2100402, 2100403, 2100404, 2100405, 2100406, 2100407, 2100408, 2100409, 2100410, 2100411, 2100412, 2100413, 2100414, 2100415, 2100416, 2100417, 2100418, 2100419, 2100420, 2100421, 2100422, 2100423, 2100424, 2100425, 2100426, 2100427);[ Date: 2023-04-15 01:11:20 ]
8 12s857ms DELETE FROM account_move_line WHERE id IN (2090291, 2090292, 2090293, 2090294, 2090295, 2090296, 2090297, 2090298, 2090299, 2090300, 2090301, 2090302, 2090303, 2090304, 2090305, 2090306, 2090307, 2090308, 2090309, 2090310, 2090311, 2090312, 2090313, 2090314, 2090315, 2090316, 2090317, 2097789, 2097790, 2097791, 2097792);[ Date: 2023-04-15 01:05:50 ]
9 12s397ms DELETE FROM account_move_line WHERE id IN (2100436, 2100437, 2100438, 2100439, 2100440, 2100441, 2100442, 2100443, 2100444, 2100445, 2100446, 2100447, 2100448, 2100449, 2100450, 2100451, 2100452, 2100453, 2100454, 2100455, 2100456, 2100457, 2100458, 2100459, 2100460, 2100461, 2100462, 2100463, 2100464, 2100465);[ Date: 2023-04-15 01:11:35 ]
10 10s773ms DELETE FROM account_move_line WHERE id IN (2098552, 2098553, 2067097, 2067098, 2067099, 2067100, 2067101, 2067102, 2067103, 2067104, 2067105, 2067106, 2067107, 2067108, 2067109, 2067110, 2067111, 2067112, 2067113, 2067114, 2067115, 2067116, 2067117, 2067118, 2067119, 2067120);[ Date: 2023-04-15 10:29:41 ]
11 9s963ms 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) TO stdout;[ Date: 2023-04-15 09:00:18 ]
12 9s460ms COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;[ Date: 2023-04-15 09:03:31 ]
13 8s127ms 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-04-15 09:00:27 ]
14 7s50ms DELETE FROM account_move_line WHERE id IN (2098012, 2098013, 2044240, 2044241, 2044242, 2044243, 2044244, 2044245, 2044246, 2044247, 2044248, 2044249, 2044250, 2044251, 2044252, 2044253, 2044254);[ Date: 2023-04-15 10:17:27 ]
15 4s575ms DELETE FROM account_move_line WHERE id IN (2084355, 2084356, 2084346, 2084347, 2084348, 2084349, 2084350, 2084351, 2084352, 2084353, 2084354);[ Date: 2023-04-15 10:17:09 ]
16 4s534ms DELETE FROM account_move_line WHERE id IN (2047481, 2047482, 2047483, 2047484, 2047485, 2047486, 2047487, 2047488, 2047489, 2047490, 2047491);[ Date: 2023-04-15 10:23:39 ]
17 4s471ms 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-04-15 09:02:27 ]
18 4s142ms DELETE FROM account_move_line WHERE id IN (2100517, 2100518, 2100519, 2100520, 2100521, 2100522, 2100523, 2100524, 2100525, 2100526);[ Date: 2023-04-15 10:17:15 ]
19 4s68ms COPY public.account_move (id, access_token, message_main_attachment_id, name, date, ref, narration, state, posted_before, move_type, to_check, journal_id, company_id, currency_id, partner_id, commercial_partner_id, is_move_sent, partner_bank_id, payment_reference, payment_id, statement_line_id, amount_untaxed, amount_tax, amount_total, amount_residual, amount_untaxed_signed, amount_tax_signed, amount_total_signed, amount_residual_signed, payment_state, tax_cash_basis_rec_id, tax_cash_basis_move_id, auto_post, reversed_entry_id, fiscal_position_id, invoice_user_id, invoice_date, invoice_date_due, invoice_origin, invoice_payment_term_id, invoice_incoterm_id, qr_code_method, invoice_source_email, invoice_partner_display_name, invoice_cash_rounding_id, secure_sequence_number, inalterable_hash, sequence_prefix, sequence_number, create_uid, create_date, write_uid, write_date, payment_state_before_switch, duplicated_vendor_ref, extract_state, extract_status_code, extract_remote_id, transfer_model_id, tax_closing_end_date, tax_report_control_error, asset_id, asset_remaining_value, asset_depreciated_value, asset_manually_modified, asset_value_change, campaign_id, source_id, medium_id, team_id, partner_shipping_id, stock_move_id, preferred_payment_method_id, website_id, branch_id, branch_name, invoice_action, sign_amount_total, sign_amount_residual, sign_amount_untaxed, invoice_part_id, invoice_product_qty, balance_entry, to_check_negative, non_inventory_entry, direct_order, warranty_invoice, email_send_eod, email_sent, order_type, carrier_id, release_to_pay, release_to_pay_manual, force_release_to_pay, invoice_origin_new, debit_origin_id, paid_by_vc, payment_details, expense_choice, edi_810_id, cash_tendered, change_amount, sequence_generated, open_invoice, edi_split_lock, edi_billed, is_edi_bill, payment_details_compute, edi_done_date) TO stdout;[ Date: 2023-04-15 09:00:08 ]
20 3s814ms 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-04-15 09:02:22 ]
Time consuming queries (N)
Rank Total duration Times executed Min duration Max duration Avg duration Query 1 5m56s 2,276 120ms 490ms 156ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 15 00 158 23s212ms 146ms 01 142 22s571ms 158ms 02 129 19s897ms 154ms 03 130 19s681ms 151ms 04 227 38s526ms 169ms 05 137 20s565ms 150ms 06 165 25s40ms 151ms 07 154 23s323ms 151ms 08 274 44s176ms 161ms 09 249 39s7ms 156ms 22 219 35s266ms 161ms 23 292 45s190ms 154ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T01:30:01.506401'::timestamp and so.date_order <= '2023-04-15T01:30:01.506401'::timestamp and sol.product_id = 207789 and so.state in ('done', 'sale') and so.warehouse_id = 42;
Date: 2023-04-15 01:33:46 Duration: 490ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T04:30:06.677805'::timestamp and so.date_order <= '2023-04-15T04:30:06.677805'::timestamp and sol.product_id = 210618 and so.state in ('done', 'sale') and so.warehouse_id = 42;
Date: 2023-04-15 04:30:24 Duration: 425ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T04:30:06.677805'::timestamp and so.date_order <= '2023-04-15T04:30:06.677805'::timestamp and sol.product_id = 247335 and so.state in ('done', 'sale') and so.warehouse_id = 45;
Date: 2023-04-15 04:30:32 Duration: 353ms
2 1m55s 43 407ms 16s936ms 2s679ms delete from account_move_line where id in (...);Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 15 00 1 857ms 857ms 01 7 41s30ms 5s861ms 08 1 856ms 856ms 10 22 1m5s 2s954ms 16 1 855ms 855ms 18 11 6s604ms 600ms -
DELETE FROM account_move_line WHERE id IN (2095341, 2095342, 2090766, 2090767, 2090768, 2090769, 2090770, 2090771, 2090772, 2090773, 2090774, 2090775, 2090776, 2090777, 2090778, 2090779, 2090780, 2090781, 2090782, 2090783, 2090784, 2090785, 2090786, 2090787, 2090788, 2090789, 2090790, 2090791, 2090792, 2090793, 2090794, 2090795, 2090796, 2090797, 2090798, 2090799, 2090800, 2090801, 2090802, 2090803, 2090804);
Date: 2023-04-15 10:29:26 Duration: 16s936ms
-
DELETE FROM account_move_line WHERE id IN (2100428, 2100429, 2100430, 2100431, 2100401, 2100402, 2100403, 2100404, 2100405, 2100406, 2100407, 2100408, 2100409, 2100410, 2100411, 2100412, 2100413, 2100414, 2100415, 2100416, 2100417, 2100418, 2100419, 2100420, 2100421, 2100422, 2100423, 2100424, 2100425, 2100426, 2100427);
Date: 2023-04-15 01:11:20 Duration: 12s862ms
-
DELETE FROM account_move_line WHERE id IN (2090291, 2090292, 2090293, 2090294, 2090295, 2090296, 2090297, 2090298, 2090299, 2090300, 2090301, 2090302, 2090303, 2090304, 2090305, 2090306, 2090307, 2090308, 2090309, 2090310, 2090311, 2090312, 2090313, 2090314, 2090315, 2090316, 2090317, 2097789, 2097790, 2097791, 2097792);
Date: 2023-04-15 01:05:50 Duration: 12s857ms
3 54s88ms 100 530ms 576ms 540ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 15 17 48 26s38ms 542ms 18 52 28s50ms 539ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPP%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPP%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPP%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:52:15 Duration: 576ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPPI%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPPI%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPPI%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:44:08 Duration: 562ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%571L%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%571.L%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%571.L%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:20:35 Duration: 562ms
4 44s857ms 1 44s857ms 44s857ms 44s857ms 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 #4
Day Hour Count Duration Avg duration Apr 15 09 1 44s857ms 44s857ms -
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-04-15 09:01:24 Duration: 44s857ms
5 42s846ms 18 2s348ms 2s438ms 2s380ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #5
Day Hour Count Duration Avg duration Apr 15 09 18 42s846ms 2s380ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:24:10 Duration: 2s438ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:28:33 Duration: 2s405ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:26:34 Duration: 2s398ms
6 28s294ms 57 487ms 548ms 496ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 15 10 57 28s294ms 496ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3028 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:06 Duration: 548ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3405 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:34 Duration: 510ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3251 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:18 Duration: 508ms
7 25s594ms 1 25s594ms 25s594ms 25s594ms 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 #7
Day Hour Count Duration Avg duration Apr 15 09 1 25s594ms 25s594ms -
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-04-15 09:02:18 Duration: 25s594ms
8 25s463ms 1 25s463ms 25s463ms 25s463ms 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 #8
Day Hour Count Duration Avg duration Apr 15 09 1 25s463ms 25s463ms -
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-04-15 09:01:52 Duration: 25s463ms
9 25s349ms 20 781ms 1s687ms 1s267ms delete from account_move where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 15 00 1 901ms 901ms 01 4 5s730ms 1s432ms 08 1 896ms 896ms 10 11 14s568ms 1s324ms 16 1 890ms 890ms 18 2 2s361ms 1s180ms -
DELETE FROM account_move WHERE id IN (569501, 568143);
Date: 2023-04-15 10:29:28 Duration: 1s687ms
-
DELETE FROM account_move WHERE id IN (568037, 570251);
Date: 2023-04-15 01:05:52 Duration: 1s684ms
-
DELETE FROM account_move WHERE id IN (570377, 570187);
Date: 2023-04-15 01:11:06 Duration: 1s679ms
10 20s61ms 1 20s61ms 20s61ms 20s61ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) to stdout;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 15 09 1 20s61ms 20s61ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-04-15 09:03:08 Duration: 20s61ms
11 19s146ms 12 1s578ms 1s666ms 1s595ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 15 09 12 19s146ms 1s595ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:28:36 Duration: 1s666ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02764%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:38:57 Duration: 1s598ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:22:32 Duration: 1s596ms
12 15s824ms 1 15s824ms 15s824ms 15s824ms 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 #12
Day Hour Count Duration Avg duration Apr 15 09 1 15s824ms 15s824ms -
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-04-15 09:03:47 Duration: 15s824ms
13 9s963ms 1 9s963ms 9s963ms 9s963ms 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) to stdout;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 15 09 1 9s963ms 9s963ms -
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) TO stdout;
Date: 2023-04-15 09:00:18 Duration: 9s963ms
14 9s460ms 1 9s460ms 9s460ms 9s460ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 15 09 1 9s460ms 9s460ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-04-15 09:03:31 Duration: 9s460ms
15 9s293ms 18 509ms 538ms 516ms select "stock_picking".id from "stock_picking" where (("stock_picking"."location_id" = ?) and (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 15 09 18 9s293ms 516ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:34:35 Duration: 538ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:24:11 Duration: 532ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:41:46 Duration: 524ms
16 8s808ms 11 795ms 811ms 800ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 15 09 11 8s808ms 800ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01534%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01534%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:44:38 Duration: 811ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:18:22 Duration: 805ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:16:17 Duration: 804ms
17 8s127ms 1 8s127ms 8s127ms 8s127ms copy public.base_import_import (id, res_model, file, file_name, file_type, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 15 09 1 8s127ms 8s127ms -
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-04-15 09:00:27 Duration: 8s127ms
18 7s33ms 13 534ms 554ms 541ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 15 18 3 1s622ms 540ms 19 10 5s411ms 541ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:07:14 Duration: 554ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%9705110%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%970-5110%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%970-5110%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:55:15 Duration: 543ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:09:01 Duration: 543ms
19 6s419ms 4 1s581ms 1s617ms 1s604ms select min("stock_move".id) as id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" AS "state" from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) group by "stock_move"."state" order by "state" limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 15 09 4 6s419ms 1s604ms -
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/01534%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:47:36 Duration: 1s617ms
-
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/01534%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:45:32 Duration: 1s615ms
-
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/04402%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/04402%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/04402%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:46:04 Duration: 1s604ms
20 6s95ms 36 167ms 172ms 169ms 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 #20
Day Hour Count Duration Avg duration Apr 15 17 24 4s66ms 169ms 18 7 1s183ms 169ms 19 5 845ms 169ms -
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 ('%I-01049%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01049%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01049%') OR unaccent (res_partner.vat) ilike unaccent ('I-01049')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01049%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:39:11 Duration: 172ms
-
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 ('%I-01109%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01109%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01109%') OR unaccent (res_partner.vat) ilike unaccent ('I-01109')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01109%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:57:08 Duration: 171ms
-
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 ('%G-00853%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-00853%') OR unaccent (res_partner.ref) ilike unaccent ('%G-00853%') OR unaccent (res_partner.vat) ilike unaccent ('G-00853')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-00853%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:57:01 Duration: 171ms
Most frequent queries (N)
Rank Times executed Total duration Min duration Max duration Avg duration Query 1 2,276 5m56s 120ms 490ms 156ms select count(distinct (so.id)) as total_orders from sale_order as so left join sale_order_line as sol on sol.order_id = so.id left join product_warehouse_inventory as pwi on pwi.product_id = sol.product_id left join stock_warehouse as sw on sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= ?::timestamp and so.date_order <= ?::timestamp and sol.product_id = ? and so.state in (...) and so.warehouse_id = ?;Times Reported Time consuming queries #1
Day Hour Count Duration Avg duration Apr 15 00 158 23s212ms 146ms 01 142 22s571ms 158ms 02 129 19s897ms 154ms 03 130 19s681ms 151ms 04 227 38s526ms 169ms 05 137 20s565ms 150ms 06 165 25s40ms 151ms 07 154 23s323ms 151ms 08 274 44s176ms 161ms 09 249 39s7ms 156ms 22 219 35s266ms 161ms 23 292 45s190ms 154ms -
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T01:30:01.506401'::timestamp and so.date_order <= '2023-04-15T01:30:01.506401'::timestamp and sol.product_id = 207789 and so.state in ('done', 'sale') and so.warehouse_id = 42;
Date: 2023-04-15 01:33:46 Duration: 490ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T04:30:06.677805'::timestamp and so.date_order <= '2023-04-15T04:30:06.677805'::timestamp and sol.product_id = 210618 and so.state in ('done', 'sale') and so.warehouse_id = 42;
Date: 2023-04-15 04:30:24 Duration: 425ms
-
select count(distinct (so.id)) as total_orders from sale_order as so LEFT JOIN sale_order_line as sol ON sol.order_id = so.id LEFT JOIN product_warehouse_inventory as pwi ON pwi.product_id = sol.product_id LEFT JOIN stock_warehouse as sw ON sw.id = so.warehouse_id and sw.id = pwi.warehouse_id where so.date_order >= '2022-10-15T04:30:06.677805'::timestamp and so.date_order <= '2023-04-15T04:30:06.677805'::timestamp and sol.product_id = 247335 and so.state in ('done', 'sale') and so.warehouse_id = 45;
Date: 2023-04-15 04:30:32 Duration: 353ms
2 100 54s88ms 530ms 576ms 540ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 15 17 48 26s38ms 542ms 18 52 28s50ms 539ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPP%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPP%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPP%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:52:15 Duration: 576ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPPI%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPPI%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPPI%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:44:08 Duration: 562ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%571L%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%571.L%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%571.L%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:20:35 Duration: 562ms
3 57 28s294ms 487ms 548ms 496ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #3
Day Hour Count Duration Avg duration Apr 15 10 57 28s294ms 496ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3028 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:06 Duration: 548ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3405 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:34 Duration: 510ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3251 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:18 Duration: 508ms
4 43 1m55s 407ms 16s936ms 2s679ms delete from account_move_line where id in (...);Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 15 00 1 857ms 857ms 01 7 41s30ms 5s861ms 08 1 856ms 856ms 10 22 1m5s 2s954ms 16 1 855ms 855ms 18 11 6s604ms 600ms -
DELETE FROM account_move_line WHERE id IN (2095341, 2095342, 2090766, 2090767, 2090768, 2090769, 2090770, 2090771, 2090772, 2090773, 2090774, 2090775, 2090776, 2090777, 2090778, 2090779, 2090780, 2090781, 2090782, 2090783, 2090784, 2090785, 2090786, 2090787, 2090788, 2090789, 2090790, 2090791, 2090792, 2090793, 2090794, 2090795, 2090796, 2090797, 2090798, 2090799, 2090800, 2090801, 2090802, 2090803, 2090804);
Date: 2023-04-15 10:29:26 Duration: 16s936ms
-
DELETE FROM account_move_line WHERE id IN (2100428, 2100429, 2100430, 2100431, 2100401, 2100402, 2100403, 2100404, 2100405, 2100406, 2100407, 2100408, 2100409, 2100410, 2100411, 2100412, 2100413, 2100414, 2100415, 2100416, 2100417, 2100418, 2100419, 2100420, 2100421, 2100422, 2100423, 2100424, 2100425, 2100426, 2100427);
Date: 2023-04-15 01:11:20 Duration: 12s862ms
-
DELETE FROM account_move_line WHERE id IN (2090291, 2090292, 2090293, 2090294, 2090295, 2090296, 2090297, 2090298, 2090299, 2090300, 2090301, 2090302, 2090303, 2090304, 2090305, 2090306, 2090307, 2090308, 2090309, 2090310, 2090311, 2090312, 2090313, 2090314, 2090315, 2090316, 2090317, 2097789, 2097790, 2097791, 2097792);
Date: 2023-04-15 01:05:50 Duration: 12s857ms
5 36 6s95ms 167ms 172ms 169ms 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 #5
Day Hour Count Duration Avg duration Apr 15 17 24 4s66ms 169ms 18 7 1s183ms 169ms 19 5 845ms 169ms -
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 ('%I-01049%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01049%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01049%') OR unaccent (res_partner.vat) ilike unaccent ('I-01049')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01049%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:39:11 Duration: 172ms
-
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 ('%I-01109%') OR unaccent (res_partner.display_name) ilike unaccent ('%I-01109%') OR unaccent (res_partner.ref) ilike unaccent ('%I-01109%') OR unaccent (res_partner.vat) ilike unaccent ('I-01109')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%I-01109%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:57:08 Duration: 171ms
-
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 ('%G-00853%') OR unaccent (res_partner.display_name) ilike unaccent ('%G-00853%') OR unaccent (res_partner.ref) ilike unaccent ('%G-00853%') OR unaccent (res_partner.vat) ilike unaccent ('G-00853')) -- don't panic, trust postgres bitmap ORDER BY unaccent (res_partner.display_name) ilike unaccent ('%G-00853%') desc, unaccent (res_partner.display_name);
Date: 2023-04-15 17:57:01 Duration: 171ms
6 20 25s349ms 781ms 1s687ms 1s267ms delete from account_move where id in (...);Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 15 00 1 901ms 901ms 01 4 5s730ms 1s432ms 08 1 896ms 896ms 10 11 14s568ms 1s324ms 16 1 890ms 890ms 18 2 2s361ms 1s180ms -
DELETE FROM account_move WHERE id IN (569501, 568143);
Date: 2023-04-15 10:29:28 Duration: 1s687ms
-
DELETE FROM account_move WHERE id IN (568037, 570251);
Date: 2023-04-15 01:05:52 Duration: 1s684ms
-
DELETE FROM account_move WHERE id IN (570377, 570187);
Date: 2023-04-15 01:11:06 Duration: 1s679ms
7 18 42s846ms 2s348ms 2s438ms 2s380ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 15 09 18 42s846ms 2s380ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:24:10 Duration: 2s438ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:28:33 Duration: 2s405ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:26:34 Duration: 2s398ms
8 18 9s293ms 509ms 538ms 516ms select "stock_picking".id from "stock_picking" where (("stock_picking"."location_id" = ?) and (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #8
Day Hour Count Duration Avg duration Apr 15 09 18 9s293ms 516ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:34:35 Duration: 538ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:24:11 Duration: 532ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:41:46 Duration: 524ms
9 18 4s31ms 220ms 228ms 223ms 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 #9
Day Hour Count Duration Avg duration Apr 15 02 18 4s31ms 223ms -
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-04-15 02:52:01 Duration: 228ms
-
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-04-15 02:51:13 Duration: 227ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-04-15 02:52:01 Duration: 226ms
10 18 3s970ms 218ms 224ms 220ms 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 Apr 15 02 18 3s970ms 220ms -
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-04-15 02:04:59 Duration: 224ms
-
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-04-15 02:04:15 Duration: 224ms
-
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-04-15 02:04:25 Duration: 221ms
11 17 2s276ms 132ms 145ms 133ms select "ir_attachment".id from "ir_attachment" where (("ir_attachment"."res_field" is null and (unaccent ("ir_attachment"."url"::text) like unaccent (?))) and (not ((unaccent ("ir_attachment"."url"::text) like unaccent (?))))) order by "ir_attachment"."id" desc;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 15 00 3 411ms 137ms 03 2 270ms 135ms 06 4 531ms 132ms 17 6 796ms 132ms 18 2 266ms 133ms -
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-04-15 00:30:10 Duration: 145ms
-
SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.js'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-03af1d2/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-15 03:58:02 Duration: 135ms
-
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/%-3c847d5/%%%'))))) ORDER BY "ir_attachment"."id" DESC;
Date: 2023-04-15 03:58:03 Duration: 134ms
12 13 7s33ms 534ms 554ms 541ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 15 18 3 1s622ms 540ms 19 10 5s411ms 541ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:07:14 Duration: 554ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%9705110%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%970-5110%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%970-5110%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:55:15 Duration: 543ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:09:01 Duration: 543ms
13 13 2s716ms 198ms 215ms 208ms select min("product_warehouse_inventory".id) as id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) AS "cron_last_stock_flag_update:month" from "product_warehouse_inventory" group by date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) order by "cron_last_stock_flag_update:month" limit ?;Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 15 04 6 1s238ms 206ms 13 7 1s478ms 211ms -
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-04-15 13:21:57 Duration: 215ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-04-15 13:18:02 Duration: 214ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:month" FROM "product_warehouse_inventory" GROUP BY date_trunc('month', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:month" LIMIT 80;
Date: 2023-04-15 04:19:00 Duration: 214ms
14 13 2s312ms 157ms 210ms 177ms select min("product_warehouse_inventory".id) as id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) AS "cron_last_stock_flag_update:day" from "product_warehouse_inventory" where (("product_warehouse_inventory"."cron_last_stock_flag_update" >= ?) and ("product_warehouse_inventory"."cron_last_stock_flag_update" < ?)) group by date_trunc(?, "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) order by "cron_last_stock_flag_update:day";Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 15 04 6 1s81ms 180ms 13 7 1s231ms 175ms -
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-03-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-04-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-04-15 04:19:38 Duration: 210ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-03-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-04-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-04-15 13:22:39 Duration: 195ms
-
SELECT min("product_warehouse_inventory".id) AS id, count("product_warehouse_inventory".id) AS "cron_last_stock_flag_update_count", sum("product_warehouse_inventory"."qty_available") AS "qty_available", sum("product_warehouse_inventory"."qty_reserve") AS "qty_reserve", sum("product_warehouse_inventory"."qty_on_order") AS "qty_on_order", sum("product_warehouse_inventory"."qty_on_perm_order") AS "qty_on_perm_order", sum("product_warehouse_inventory"."qty_shipped_not_invoiced") AS "qty_shipped_not_invoiced", sum("product_warehouse_inventory"."qty_in_transist") AS "qty_in_transist", sum("product_warehouse_inventory"."qty_available_last_year") AS "qty_available_last_year", sum("product_warehouse_inventory"."qty_mtd_sold") AS "qty_mtd_sold", sum("product_warehouse_inventory"."qty_ytd_sold") AS "qty_ytd_sold", sum("product_warehouse_inventory"."qty_ytd_transfer_another") AS "qty_ytd_transfer_another", sum("product_warehouse_inventory"."qty_ytd_lost_sales") AS "qty_ytd_lost_sales", sum("product_warehouse_inventory"."qty_last_receive") AS "qty_last_receive", sum("product_warehouse_inventory"."qty_sold_last_year") AS "qty_sold_last_year", sum("product_warehouse_inventory"."qty_ly_transfer_another") AS "qty_ly_transfer_another", sum("product_warehouse_inventory"."mon_1_qty") AS "mon_1_qty", sum("product_warehouse_inventory"."mon_2_qty") AS "mon_2_qty", sum("product_warehouse_inventory"."mon_3_qty") AS "mon_3_qty", sum("product_warehouse_inventory"."mon_4_qty") AS "mon_4_qty", sum("product_warehouse_inventory"."mon_5_qty") AS "mon_5_qty", sum("product_warehouse_inventory"."mon_6_qty") AS "mon_6_qty", sum("product_warehouse_inventory"."mon_7_qty") AS "mon_7_qty", sum("product_warehouse_inventory"."mon_8_qty") AS "mon_8_qty", sum("product_warehouse_inventory"."mon_9_qty") AS "mon_9_qty", sum("product_warehouse_inventory"."mon_10_qty") AS "mon_10_qty", sum("product_warehouse_inventory"."mon_11_qty") AS "mon_11_qty", sum("product_warehouse_inventory"."mon_12_qty") AS "mon_12_qty", sum("product_warehouse_inventory"."unit_cost") AS "unit_cost", sum("product_warehouse_inventory"."loc_check_qty") AS "loc_check_qty", sum("product_warehouse_inventory"."rep_loc_check_qty") AS "rep_loc_check_qty", sum("product_warehouse_inventory"."last_intra_company_qty") AS "last_intra_company_qty", date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) as "cron_last_stock_flag_update:day" FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."cron_last_stock_flag_update" >= '2023-04-01') AND ("product_warehouse_inventory"."cron_last_stock_flag_update" < '2023-05-01')) GROUP BY date_trunc('day', "product_warehouse_inventory"."cron_last_stock_flag_update"::timestamp) ORDER BY "cron_last_stock_flag_update:day";
Date: 2023-04-15 04:19:38 Duration: 195ms
15 12 19s146ms 1s578ms 1s666ms 1s595ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 15 09 12 19s146ms 1s595ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:28:36 Duration: 1s666ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02764%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:38:57 Duration: 1s598ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:22:32 Duration: 1s596ms
16 11 8s808ms 795ms 811ms 800ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 15 09 11 8s808ms 800ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01534%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01534%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:44:38 Duration: 811ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:18:22 Duration: 805ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:16:17 Duration: 804ms
17 11 2s129ms 190ms 207ms 193ms select "stock_picking".id from "stock_picking" where (("stock_picking"."location_id" = ?) and (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 15 09 11 2s129ms 193ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%')))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:42 Duration: 207ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%')))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:21 Duration: 199ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%')))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:18:04 Duration: 192ms
18 9 1s146ms 125ms 131ms 127ms select id from account_move_line where main_invoice_line_id = ? and product_id is not null;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 15 17 7 892ms 127ms 18 2 253ms 126ms -
select id from account_move_line where main_invoice_line_id = 1758562 and product_id is not null;
Date: 2023-04-15 17:58:07 Duration: 131ms
-
select id from account_move_line where main_invoice_line_id = 1750574 and product_id is not null;
Date: 2023-04-15 17:53:48 Duration: 130ms
-
select id from account_move_line where main_invoice_line_id = 1748767 and product_id is not null;
Date: 2023-04-15 17:44:12 Duration: 128ms
19 7 5s675ms 797ms 817ms 810ms select "stock_picking".id from "stock_picking" where (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 15 06 4 3s230ms 807ms 09 3 2s445ms 815ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:12 Duration: 817ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02966%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02966%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:09 Duration: 814ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02966%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02966%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:13:38 Duration: 812ms
20 7 1s10ms 136ms 153ms 144ms select "product_warehouse_inventory".id from "product_warehouse_inventory" where (("product_warehouse_inventory"."has_core" = true) or (("product_warehouse_inventory"."has_core" is null or "product_warehouse_inventory"."has_core" = false) and ("product_warehouse_inventory"."is_core" is null or "product_warehouse_inventory"."is_core" = false))) order by "product_warehouse_inventory"."warehouse_name" limit ?;Times Reported Time consuming queries #20
Day Hour Count Duration Avg duration Apr 15 03 1 142ms 142ms 04 1 144ms 144ms 07 1 147ms 147ms 11 1 146ms 146ms 12 1 136ms 136ms 13 1 153ms 153ms 14 1 140ms 140ms -
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."has_core" = true) OR (("product_warehouse_inventory"."has_core" IS NULL or "product_warehouse_inventory"."has_core" = false) AND ("product_warehouse_inventory"."is_core" IS NULL or "product_warehouse_inventory"."is_core" = false))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-04-15 13:17:48 Duration: 153ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."has_core" = true) OR (("product_warehouse_inventory"."has_core" IS NULL or "product_warehouse_inventory"."has_core" = false) AND ("product_warehouse_inventory"."is_core" IS NULL or "product_warehouse_inventory"."is_core" = false))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-04-15 07:25:16 Duration: 147ms
-
SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE (("product_warehouse_inventory"."has_core" = true) OR (("product_warehouse_inventory"."has_core" IS NULL or "product_warehouse_inventory"."has_core" = false) AND ("product_warehouse_inventory"."is_core" IS NULL or "product_warehouse_inventory"."is_core" = false))) ORDER BY "product_warehouse_inventory"."warehouse_name" LIMIT 80;
Date: 2023-04-15 11:56:46 Duration: 146ms
Normalized slowest queries (N)
Rank Min duration Max duration Avg duration Times executed Total duration Query 1 44s857ms 44s857ms 44s857ms 1 44s857ms 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 #1
Day Hour Count Duration Avg duration Apr 15 09 1 44s857ms 44s857ms -
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-04-15 09:01:24 Duration: 44s857ms
2 25s594ms 25s594ms 25s594ms 1 25s594ms copy public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) to stdout;Times Reported Time consuming queries #2
Day Hour Count Duration Avg duration Apr 15 09 1 25s594ms 25s594ms -
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-04-15 09:02:18 Duration: 25s594ms
3 25s463ms 25s463ms 25s463ms 1 25s463ms 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 Apr 15 09 1 25s463ms 25s463ms -
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-04-15 09:01:52 Duration: 25s463ms
4 20s61ms 20s61ms 20s61ms 1 20s61ms copy public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) to stdout;Times Reported Time consuming queries #4
Day Hour Count Duration Avg duration Apr 15 09 1 20s61ms 20s61ms -
COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage) TO stdout;
Date: 2023-04-15 09:03:08 Duration: 20s61ms
5 15s824ms 15s824ms 15s824ms 1 15s824ms 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 #5
Day Hour Count Duration Avg duration Apr 15 09 1 15s824ms 15s824ms -
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-04-15 09:03:47 Duration: 15s824ms
6 9s963ms 9s963ms 9s963ms 1 9s963ms 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) to stdout;Times Reported Time consuming queries #6
Day Hour Count Duration Avg duration Apr 15 09 1 9s963ms 9s963ms -
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) TO stdout;
Date: 2023-04-15 09:00:18 Duration: 9s963ms
7 9s460ms 9s460ms 9s460ms 1 9s460ms copy public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) to stdout;Times Reported Time consuming queries #7
Day Hour Count Duration Avg duration Apr 15 09 1 9s460ms 9s460ms -
COPY public.website_track (id, visitor_id, page_id, url, visit_datetime, product_id) TO stdout;
Date: 2023-04-15 09:03:31 Duration: 9s460ms
8 8s127ms 8s127ms 8s127ms 1 8s127ms 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 Apr 15 09 1 8s127ms 8s127ms -
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-04-15 09:00:27 Duration: 8s127ms
9 407ms 16s936ms 2s679ms 43 1m55s delete from account_move_line where id in (...);Times Reported Time consuming queries #9
Day Hour Count Duration Avg duration Apr 15 00 1 857ms 857ms 01 7 41s30ms 5s861ms 08 1 856ms 856ms 10 22 1m5s 2s954ms 16 1 855ms 855ms 18 11 6s604ms 600ms -
DELETE FROM account_move_line WHERE id IN (2095341, 2095342, 2090766, 2090767, 2090768, 2090769, 2090770, 2090771, 2090772, 2090773, 2090774, 2090775, 2090776, 2090777, 2090778, 2090779, 2090780, 2090781, 2090782, 2090783, 2090784, 2090785, 2090786, 2090787, 2090788, 2090789, 2090790, 2090791, 2090792, 2090793, 2090794, 2090795, 2090796, 2090797, 2090798, 2090799, 2090800, 2090801, 2090802, 2090803, 2090804);
Date: 2023-04-15 10:29:26 Duration: 16s936ms
-
DELETE FROM account_move_line WHERE id IN (2100428, 2100429, 2100430, 2100431, 2100401, 2100402, 2100403, 2100404, 2100405, 2100406, 2100407, 2100408, 2100409, 2100410, 2100411, 2100412, 2100413, 2100414, 2100415, 2100416, 2100417, 2100418, 2100419, 2100420, 2100421, 2100422, 2100423, 2100424, 2100425, 2100426, 2100427);
Date: 2023-04-15 01:11:20 Duration: 12s862ms
-
DELETE FROM account_move_line WHERE id IN (2090291, 2090292, 2090293, 2090294, 2090295, 2090296, 2090297, 2090298, 2090299, 2090300, 2090301, 2090302, 2090303, 2090304, 2090305, 2090306, 2090307, 2090308, 2090309, 2090310, 2090311, 2090312, 2090313, 2090314, 2090315, 2090316, 2090317, 2097789, 2097790, 2097791, 2097792);
Date: 2023-04-15 01:05:50 Duration: 12s857ms
10 2s348ms 2s438ms 2s380ms 18 42s846ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #10
Day Hour Count Duration Avg duration Apr 15 09 18 42s846ms 2s380ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:24:10 Duration: 2s438ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:28:33 Duration: 2s405ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%')))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:26:34 Duration: 2s398ms
11 1s581ms 1s617ms 1s604ms 4 6s419ms select min("stock_move".id) as id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" AS "state" from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) group by "stock_move"."state" order by "state" limit ?;Times Reported Time consuming queries #11
Day Hour Count Duration Avg duration Apr 15 09 4 6s419ms 1s604ms -
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/01534%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:47:36 Duration: 1s617ms
-
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%07-L/INT/01534%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:45:32 Duration: 1s615ms
-
SELECT min("stock_move".id) AS id, count("stock_move".id) AS "state_count", sum("stock_move"."product_uom_qty") AS "product_uom_qty", sum("stock_move"."current_warehouse_qty") AS "current_warehouse_qty", sum("stock_move"."price_unit") AS "price_unit", "stock_move"."state" as "state" FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%03-C/INT/04402%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%03-C/INT/04402%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%03-C/INT/04402%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) GROUP BY "stock_move"."state" ORDER BY "state" LIMIT 80;
Date: 2023-04-15 09:46:04 Duration: 1s604ms
12 1s578ms 1s666ms 1s595ms 12 19s146ms select "stock_move".id from "stock_move" where (((unaccent ("stock_move"."origin"::text) ilike unaccent (?)) or (unaccent ("stock_move"."name"::text) ilike unaccent (?))) or ("stock_move"."picking_id" in ( select "stock_picking".id from "stock_picking" where (unaccent ("stock_picking"."name"::text) ilike unaccent (?)) and ("stock_picking"."company_id" in (...))))) and ("stock_move"."company_id" in (...)) order by "stock_move"."sequence", "stock_move"."id" limit ?;Times Reported Time consuming queries #12
Day Hour Count Duration Avg duration Apr 15 09 12 19s146ms 1s595ms -
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:28:36 Duration: 1s666ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02764%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:38:57 Duration: 1s598ms
-
SELECT "stock_move".id FROM "stock_move" WHERE (((unaccent ("stock_move"."origin"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_move"."name"::text) ilike unaccent ('%05-F/INT/02966%'))) OR ("stock_move"."picking_id" in ( SELECT "stock_picking".id FROM "stock_picking" WHERE (unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) AND ("stock_picking"."company_id" in (1))))) AND ("stock_move"."company_id" in (1)) ORDER BY "stock_move"."sequence", "stock_move"."id" LIMIT 80;
Date: 2023-04-15 09:22:32 Duration: 1s596ms
13 781ms 1s687ms 1s267ms 20 25s349ms delete from account_move where id in (...);Times Reported Time consuming queries #13
Day Hour Count Duration Avg duration Apr 15 00 1 901ms 901ms 01 4 5s730ms 1s432ms 08 1 896ms 896ms 10 11 14s568ms 1s324ms 16 1 890ms 890ms 18 2 2s361ms 1s180ms -
DELETE FROM account_move WHERE id IN (569501, 568143);
Date: 2023-04-15 10:29:28 Duration: 1s687ms
-
DELETE FROM account_move WHERE id IN (568037, 570251);
Date: 2023-04-15 01:05:52 Duration: 1s684ms
-
DELETE FROM account_move WHERE id IN (570377, 570187);
Date: 2023-04-15 01:11:06 Duration: 1s679ms
14 797ms 817ms 810ms 7 5s675ms select "stock_picking".id from "stock_picking" where (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #14
Day Hour Count Duration Avg duration Apr 15 06 4 3s230ms 807ms 09 3 2s445ms 815ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:12 Duration: 817ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02966%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02966%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:16:09 Duration: 814ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02966%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02966%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02966%'))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:13:38 Duration: 812ms
15 795ms 811ms 800ms 11 8s808ms select min("stock_picking".id) as id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" AS "location_id" from "stock_picking" left join "stock_location" AS "stock_picking__location_id" on ("stock_picking"."location_id" = "stock_picking__location_id"."id") where (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) and ("stock_picking"."company_id" in (...)) group by "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" order by "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" limit ?;Times Reported Time consuming queries #15
Day Hour Count Duration Avg duration Apr 15 09 11 8s808ms 800ms -
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01534%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01534%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01534%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:44:38 Duration: 811ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:18:22 Duration: 805ms
-
SELECT min("stock_picking".id) AS id, count("stock_picking".id) AS "location_id_count", sum("stock_picking"."weight") AS "weight", "stock_picking"."location_id" as "location_id" FROM "stock_picking" LEFT JOIN "stock_location" AS "stock_picking__location_id" ON ("stock_picking"."location_id" = "stock_picking__location_id"."id") WHERE (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%05-F/INT/02764%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%05-F/INT/02764%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%05-F/INT/02764%'))) AND ("stock_picking"."company_id" in (1)) GROUP BY "stock_picking"."location_id", "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" ORDER BY "stock_picking__location_id"."complete_name", "stock_picking__location_id"."id" LIMIT 80;
Date: 2023-04-15 09:16:17 Duration: 804ms
16 534ms 554ms 541ms 13 7s33ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?)) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #16
Day Hour Count Duration Avg duration Apr 15 18 3 1s622ms 540ms 19 10 5s411ms 541ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:07:14 Duration: 554ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%9705110%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%970-5110%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%970-5110%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:55:15 Duration: 543ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%327540%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%327-540%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%327-540%')) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 19:09:01 Duration: 543ms
17 530ms 576ms 540ms 100 54s88ms select product_product.id from "product_product" left join "product_template" AS "product_product__product_tmpl_id" on ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") left join "ir_translation" AS "product_product__product_tmpl_id__name" on ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" and "product_product__product_tmpl_id__name"."type" = ? and "product_product__product_tmpl_id__name"."name" = ? and "product_product__product_tmpl_id__name"."lang" = ? and "product_product__product_tmpl_id__name"."value" != ?) where (("product_product"."active" = true) and (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent (?)) or (unaccent ("product_product"."default_code"::text) ilike unaccent (?))) or unaccent (coalesce("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent (?))) and (("product_product__product_tmpl_id"."company_id" in (...)) or "product_product__product_tmpl_id"."company_id" is null) order by product_product.default_code, product_product.condensed_internal_ref;Times Reported Time consuming queries #17
Day Hour Count Duration Avg duration Apr 15 17 48 26s38ms 542ms 18 52 28s50ms 539ms -
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPP%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPP%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPP%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:52:15 Duration: 576ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%SHIPPI%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%SHIPPI%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%SHIPPI%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 17:44:08 Duration: 562ms
-
SELECT product_product.id FROM "product_product" LEFT JOIN "product_template" AS "product_product__product_tmpl_id" ON ("product_product"."product_tmpl_id" = "product_product__product_tmpl_id"."id") LEFT JOIN "ir_translation" AS "product_product__product_tmpl_id__name" ON ("product_product__product_tmpl_id"."id" = "product_product__product_tmpl_id__name"."res_id" AND "product_product__product_tmpl_id__name"."type" = 'model' AND "product_product__product_tmpl_id__name"."name" = 'product.template,name' AND "product_product__product_tmpl_id__name"."lang" = 'en_US' AND "product_product__product_tmpl_id__name"."value" != '') WHERE (("product_product"."active" = true) AND (((unaccent ("product_product"."condensed_internal_ref"::text) ilike unaccent ('%%571L%%')) OR (unaccent ("product_product"."default_code"::text) ilike unaccent ('%571.L%'))) OR unaccent (COALESCE("product_product__product_tmpl_id__name"."value", "product_product__product_tmpl_id"."name")) ilike unaccent ('%571.L%'))) AND (("product_product__product_tmpl_id"."company_id" in (1)) OR "product_product__product_tmpl_id"."company_id" IS NULL) ORDER BY product_product.default_code, product_product.condensed_internal_ref;
Date: 2023-04-15 18:20:35 Duration: 562ms
18 509ms 538ms 516ms 18 9s293ms select "stock_picking".id from "stock_picking" where (("stock_picking"."location_id" = ?) and (((((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?)))) or (((unaccent ("stock_picking"."name"::text) ilike unaccent (?)) or (unaccent ("stock_picking"."all_references"::text) ilike unaccent (?))) or (unaccent ("stock_picking"."origin"::text) ilike unaccent (?))))) and ("stock_picking"."company_id" in (...)) order by "stock_picking"."priority" desc, "stock_picking"."scheduled_date" asc, "stock_picking"."id" desc limit ?;Times Reported Time consuming queries #18
Day Hour Count Duration Avg duration Apr 15 09 18 9s293ms 516ms -
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:34:35 Duration: 538ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:24:11 Duration: 532ms
-
SELECT "stock_picking".id FROM "stock_picking" WHERE (("stock_picking"."location_id" = 468) AND (((((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01372%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01372%'))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01411%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01411%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01411%')))) OR (((unaccent ("stock_picking"."name"::text) ilike unaccent ('%07-L/INT/01495%')) OR (unaccent ("stock_picking"."all_references"::text) ilike unaccent ('%07-L/INT/01495%'))) OR (unaccent ("stock_picking"."origin"::text) ilike unaccent ('%07-L/INT/01495%'))))) AND ("stock_picking"."company_id" in (1)) ORDER BY "stock_picking"."priority" DESC, "stock_picking"."scheduled_date" ASC, "stock_picking"."id" DESC LIMIT 80;
Date: 2023-04-15 09:41:46 Duration: 524ms
19 487ms 548ms 496ms 57 28s294ms select distinct ill.product_id from item_list_line as ill left join res_forecast_method as fm on fm.id = ill.method where ill.item_demand_plan_id = ? and ill.method not in (...);Times Reported Time consuming queries #19
Day Hour Count Duration Avg duration Apr 15 10 57 28s294ms 496ms -
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3028 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:06 Duration: 548ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3405 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:34 Duration: 510ms
-
select DISTINCT ill.product_id from item_list_line as ill LEFT JOIN res_forecast_method as fm ON fm.id = ill.method where ill.item_demand_plan_id = 3251 and ill.method not in (8, 7);
Date: 2023-04-15 10:35:18 Duration: 508ms
20 220ms 228ms 223ms 18 4s31ms 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 #20
Day Hour Count Duration Avg duration Apr 15 02 18 4s31ms 223ms -
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-04-15 02:52:01 Duration: 228ms
-
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-04-15 02:51:13 Duration: 227ms
-
SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") ASC, "product_template"."id" DESC;
Date: 2023-04-15 02:52:01 Duration: 226ms
Time consuming prepare
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
Time consuming bind
Rank Total duration Times executed Min duration Max duration Avg duration Query NO DATASET
-
Events
Log levels
Key values
- 4,252 Log entries
Events distribution
Key values
- 0 PANIC entries
- 0 FATAL entries
- 679 ERROR entries
- 0 WARNING entries
Most Frequent Errors/Events
Key values
- 675 Max number of times the same event was reported
- 679 Total events found
Rank Times reported Error 1 675 ERROR: could not obtain lock on row in relation "..."
Times Reported Most Frequent Error / Event #1
Day Hour Count Apr 15 00 56 01 73 02 56 03 40 04 41 05 36 06 40 07 44 08 46 09 44 10 22 11 9 12 8 13 11 14 9 15 10 16 12 17 7 18 9 19 9 20 7 21 11 22 41 23 34 - ERROR: could not obtain lock on row in relation "ir_cron"
Statement: SELECT * FROM ir_cron WHERE numbercall != 0 AND active AND nextcall <= (now() at time zone 'UTC') AND id=48 FOR UPDATE NOWAIT
Date: 2023-04-15 00:30:09
2 4 ERROR: could not serialize access due to concurrent update
Times Reported Most Frequent Error / Event #2
Day Hour Count Apr 15 04 1 13 1 18 2 - ERROR: could not serialize access due to concurrent update
Statement: UPDATE "bus_presence" SET "last_poll"='2023-04-15 04:59:30' WHERE id IN (33)
Date: 2023-04-15 04:59:30