Times Reported Time consuming queries #1

x Hide

SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 189092)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 3708)) ORDER BY "item_list_line"."id" LIMIT 1;

Date: 2023-07-29 00:32:47
Duration: 11s113ms

SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 213564)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 3708)) ORDER BY "item_list_line"."id" LIMIT 1;

Date: 2023-07-29 00:37:14
Duration: 8s917ms

SELECT "item_list_line".id FROM "item_list_line" WHERE (((("item_list_line"."active" = true) AND ("item_list_line"."product_id" = 189114)) AND (("item_list_line"."method" not in (7, 8)) OR "item_list_line"."method" IS NULL)) AND ("item_list_line"."item_demand_plan_id" = 3708)) ORDER BY "item_list_line"."id" LIMIT 1;

Date: 2023-07-29 00:38:42
Duration: 7s770ms

x Hide

Times Reported Time consuming queries #2

x Hide

select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 172946 and item_demand_plan_id = 3708 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);

Date: 2023-07-29 00:41:36
Duration: 3s157ms

select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 210042 and item_demand_plan_id = 3704 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);

Date: 2023-07-29 00:30:22
Duration: 3s112ms

select date_part('year', invoice_date) as Year, date_part('month', invoice_date) as Month, date_part('day', invoice_date) as day, product_id, sum(product_uom_qty) as total from item_list_line where product_id = 209620 and item_demand_plan_id = 3703 group by product_id, date_part('month', invoice_date), date_part('year', invoice_date), date_part('day', invoice_date) order by date_part('year', invoice_date), date_part('month', invoice_date), date_part('day', invoice_date);

Date: 2023-07-29 00:32:08
Duration: 2s958ms

x Hide

Times Reported Time consuming queries #3

x Hide

DELETE FROM account_move_line WHERE id IN (2804585, 2804586, 2797543, 2797544, 2797545, 2797546, 2797547, 2797548, 2797549, 2797550, 2797551, 2797552, 2797553, 2797554, 2797555, 2797556, 2797557, 2797558, 2797559, 2797560, 2797561, 2797562, 2797563, 2797564, 2797565, 2797566, 2797567, 2797568);

Date: 2023-07-29 10:35:27
Duration: 25s514ms

DELETE FROM account_move_line WHERE id IN (2808543, 2808544, 2808545, 2808546, 2808547, 2808548, 2808549, 2808550, 2808551, 2808552, 2808553, 2808554, 2808555, 2808556, 2808557, 2808558, 2808559, 2808560, 2808561, 2808562, 2808563, 2808564, 2808577, 2808578);

Date: 2023-07-29 10:30:37
Duration: 21s814ms

DELETE FROM account_move_line WHERE id IN (2809250, 2809251, 2768083, 2768084, 2768085, 2768086, 2768087, 2768088, 2768089, 2768090, 2768091, 2768092, 2768093, 2768094, 2768095, 2768096, 2768097, 2768098, 2768099, 2768100, 2768101, 2768102, 2768103);

Date: 2023-07-29 10:23:44
Duration: 20s830ms

x Hide

Times Reported Time consuming queries #4

x Hide

update item_list_line set method = 8, min_product_len_1 = 31, min_product_len_2 = 41, min_baseline_size = 36, seasonal_period = 0 where product_id = 220302 and item_demand_plan_id = 3708;

Date: 2023-07-29 00:03:17
Duration: 1s880ms

update item_list_line set method = 8, min_product_len_1 = 31, min_product_len_2 = 41, min_baseline_size = 36, seasonal_period = 0 where product_id = 195964 and item_demand_plan_id = 3708;

Date: 2023-07-29 00:00:20
Duration: 1s758ms

update item_list_line set method = 8, min_product_len_1 = 31, min_product_len_2 = 41, min_baseline_size = 36, seasonal_period = 0 where product_id = 221920 and item_demand_plan_id = 3708;

Date: 2023-07-29 00:03:31
Duration: 1s754ms

x Hide

Times Reported Time consuming queries #5

x Hide

COPY public.mail_tracking_value (id, field, field_desc, field_type, old_value_integer, old_value_float, old_value_monetary, old_value_char, old_value_text, old_value_datetime, new_value_integer, new_value_float, new_value_monetary, new_value_char, new_value_text, new_value_datetime, mail_message_id, tracking_sequence, create_uid, create_date, write_uid, write_date) TO stdout;

Date: 2023-07-29 09:07:14
Duration: 3m43s

x Hide

Times Reported Time consuming queries #6

x Hide

SELECT id FROM ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 209298 and date::date = DATE '2023-08-06T00:00:00'::timestamp and item_demand_plan_id = 3711 and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) t WHERE t.rnum > 0;

Date: 2023-07-29 00:33:28
Duration: 559ms

SELECT id FROM ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 209776 and date::date = DATE '2023-08-06T00:00:00'::timestamp and item_demand_plan_id = 3703 and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) t WHERE t.rnum > 0;

Date: 2023-07-29 00:33:08
Duration: 539ms

SELECT id FROM ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 209317 and date::date = DATE '2023-08-27T00:00:00'::timestamp and item_demand_plan_id = 3711 and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) t WHERE t.rnum > 0;

Date: 2023-07-29 00:34:04
Duration: 499ms

x Hide

Times Reported Time consuming queries #7

x Hide

select count(id) as total_count from item_list_line where item_demand_plan_id = 3711 and active = True;

Date: 2023-07-29 00:33:06
Duration: 5s775ms

select count(id) as total_count from item_list_line where item_demand_plan_id = 3709 and active = True;

Date: 2023-07-29 00:32:23
Duration: 5s758ms

select count(id) as total_count from item_list_line where item_demand_plan_id = 3701 and active = True;

Date: 2023-07-29 00:35:16
Duration: 5s637ms

x Hide

Times Reported Time consuming queries #8

x Hide

COPY public.item_list_line (id, item_demand_plan_id, product_id, selling_branch, product_uom_qty, invoice_date, warehouse_id, method, inventory_vendor_id, create_uid, create_date, write_uid, write_date, active, min_product_len_1, min_product_len_2, min_baseline_size, seasonal_period, supercede_product_id, superceded, campaign_id, source_id, medium_id, message_main_attachment_id, access_token, ref_id, ref) TO stdout;

Date: 2023-07-29 09:02:13
Duration: 1m14s

x Hide

Times Reported Time consuming queries #9

x Hide

COPY public.mail_message (id, subject, date, body, parent_id, model, res_id, record_name, message_type, subtype_id, mail_activity_type_id, is_internal, email_from, author_id, no_auto_thread, message_id, reply_to, mail_server_id, moderation_status, moderator_id, email_layout_xmlid, add_sign, create_uid, create_date, write_uid, write_date, email_cc, email_bcc, email_to, ks_email_cc_string, ks_email_bcc_string, ks_cc_partners, ks_bcc_partners) TO stdout;

Date: 2023-07-29 09:03:31
Duration: 1m13s

x Hide

Times Reported Time consuming queries #10

x Hide

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 = 3711 and ill.method not in (8, 7);

Date: 2023-07-29 00:31:51
Duration: 2s237ms

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 = 3709 and ill.method not in (8, 7);

Date: 2023-07-29 00:33:40
Duration: 2s207ms

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 = 3708 and ill.method not in (8, 7);

Date: 2023-07-29 00:28:53
Duration: 2s73ms

x Hide

Times Reported Time consuming queries #11

x Hide

DELETE FROM account_move WHERE id IN (789006, 760661, 789005);

Date: 2023-07-29 10:36:22
Duration: 3s367ms

DELETE FROM account_move WHERE id IN (786205, 732866);

Date: 2023-07-29 10:29:22
Duration: 2s343ms

DELETE FROM account_move WHERE id IN (789586, 784659);

Date: 2023-07-29 10:41:31
Duration: 2s333ms

x Hide

Times Reported Time consuming queries #12

x Hide

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3709 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2023-07-29 00:32:37
Duration: 1s447ms

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3706 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2023-07-29 00:34:03
Duration: 1s435ms

select ill.item_demand_plan_id from item_list_line ill LEFT JOIN item_demand_plan as idp ON ill.item_demand_plan_id = idp.id where ill.method is NULL and idp.active = True and ill.item_demand_plan_id = 3704 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2023-07-29 00:34:36
Duration: 1s410ms

x Hide

Times Reported Time consuming queries #13

x Hide

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-29 00:31:34') AND ("bus_bus"."channel" in ('"bundle_changed"', '["pointspring_master","calendar.alarm",19550]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",113]', '["pointspring_master","mail.channel",114]', '["pointspring_master","mail.channel",115]', '["pointspring_master","mail.channel",116]', '["pointspring_master","mail.channel",443]', '["pointspring_master","mail.channel",450]', '["pointspring_master","mail.channel",479]', '["pointspring_master","mail.channel",484]', '["pointspring_master","mail.channel",535]', '["pointspring_master","mail.channel",537]', '["pointspring_master","res.partner",19550]', '["pointspring_master","ir.needaction",19550]'))) ORDER BY "bus_bus"."id";

Date: 2023-07-29 00:32:24
Duration: 374ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-29 00:28:00') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_980"', '["pointspring_master","calendar.alarm",19518]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",27]', '["pointspring_master","mail.channel",28]', '["pointspring_master","mail.channel",489]', '["pointspring_master","res.partner",19518]', '["pointspring_master","ir.needaction",19518]'))) ORDER BY "bus_bus"."id";

Date: 2023-07-29 00:28:51
Duration: 366ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2023-07-29 00:33:11') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_952"', '["pointspring_master","calendar.alarm",19490]', '["pointspring_master","mail.channel",1]', '["pointspring_master","mail.channel",68]', '["pointspring_master","mail.channel",70]', '["pointspring_master","mail.channel",522]', '["pointspring_master","res.partner",19490]', '["pointspring_master","ir.needaction",19490]'))) ORDER BY "bus_bus"."id";

Date: 2023-07-29 00:34:02
Duration: 366ms

x Hide

Times Reported Time consuming queries #14

x Hide

select count(id) from item_list_line where item_demand_plan_id = 3711;

Date: 2023-07-29 00:33:08
Duration: 1s686ms

select count(id) from item_list_line where item_demand_plan_id = 3709;

Date: 2023-07-29 00:32:25
Duration: 1s520ms

select count(id) from item_list_line where item_demand_plan_id = 3708;

Date: 2023-07-29 00:29:00
Duration: 1s374ms

x Hide

Times Reported Time consuming queries #15

x Hide

SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (205668)) ORDER BY "sale_line_report"."id";

Date: 2023-07-29 22:47:24
Duration: 148ms

SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (205665)) ORDER BY "sale_line_report"."id";

Date: 2023-07-29 22:48:15
Duration: 147ms

SELECT "sale_line_report".id FROM "sale_line_report" WHERE ("sale_line_report"."real_line_id" in (205664)) ORDER BY "sale_line_report"."id";

Date: 2023-07-29 22:47:44
Duration: 143ms

x Hide

Times Reported Time consuming queries #16

x Hide

COPY public.website_visitor (id, name, access_token, active, website_id, partner_id, country_id, lang_id, timezone, visit_count, create_date, last_connection_datetime, create_uid, write_uid, write_date) TO stdout;

Date: 2023-07-29 09:09:25
Duration: 28s281ms

x Hide

Times Reported Time consuming queries #17

x Hide

UPDATE "sale_order_line" SET "write_uid" = 1146, "write_date" = (now() at time zone 'UTC') WHERE id IN (205664);

Date: 2023-07-29 22:47:45
Duration: 271ms

UPDATE "sale_order_line" SET "write_uid" = 1146, "write_date" = (now() at time zone 'UTC') WHERE id IN (205669);

Date: 2023-07-29 22:47:26
Duration: 260ms

UPDATE "sale_order_line" SET "write_uid" = 1146, "write_date" = (now() at time zone 'UTC') WHERE id IN (205666);

Date: 2023-07-29 22:47:46
Duration: 213ms

x Hide

Times Reported Time consuming queries #18

x Hide

COPY public.sale_history_line (id, history_data_link, company_id, customer_id, product_id, invoice_id, product_name, name, product_uom_qty, price_unit, cost_price_unit, price_subtotal, cost_subtotal, gross_profit, rebate_amount, rebate_subtotal, invoice_item_no, inventory_product_categ, inventory_part_type, inventory_short_vendor_name, currency_id, core_sales_amount, core_cost_amount, labor_amount, serial_number, labor_flag, note, under_warranty, contact_reference, contact_name, selling_branch, vehicle_unit_no, vehicle_identification_number, vehicle_odometer, customer_reference_no, sales_obtain, sale_order_no, sale_order_date, invoice_number, invoice_date, user_id, exception_sale, create_uid, create_date, write_uid, write_date, product_pricelist_item_id, history_id, history_date, history_type, so_line_id, new_user_id, gross_profit_amount, is_shipping, move_options, manufacturing_usage, technician_id) TO stdout;

Date: 2023-07-29 09:08:17
Duration: 21s358ms

x Hide

Times Reported Time consuming queries #19

x Hide

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 = 3710 and ill.method not in (8, 7) and ill.method is Not NULL;

Date: 2023-07-29 00:32:16
Duration: 5s482ms

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 = 3709 and ill.method not in (8, 7) and ill.method is Not NULL;

Date: 2023-07-29 00:32:41
Duration: 5s103ms

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 = 3711 and ill.method not in (8, 7) and ill.method is Not NULL;

Date: 2023-07-29 00:31:51
Duration: 2s291ms

x Hide

Times Reported Time consuming queries #20

x Hide

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (209324, 209130, 209137, 209151, 209206, 209210, 209225, 209227, 209231, 209233, 209241, 209250, 209251, 209259, 209268, 209271, 209298, 209305, 209308, 209312, 209314, 209316, 209317, 209320, 209322, 209323, 209326, 209329, 209331, 209333, 209334, 209335, 209354, 209356, 209361, 209366, 209370, 209371, 209372, 209373, 209374, 209375, 209378, 209380, 209381, 209382, 209390, 209398, 209423, 209435, 209468, 209469, 209502, 209505, 209513, 209517, 209518, 209524, 209525, 209526, 209527, 209528, 209529, 209555, 209561, 209562, 209563, 209567, 209572, 209603, 209605, 209606, 209607, 209608, 209609, 209610, 209612, 209616, 209620, 209626, 209699, 209754, 209766, 209782, 209800, 209802, 209804, 209805, 209818, 209819, 209832, 209844, 209852, 209857, 209860, 209876, 209880, 209886, 209899, 209901, 209905, 209906, 209907, 209933, 209938, 209941, 209952, 209995, 210020, 210023, 210025, 210027, 210034, 210041, 210051, 210052, 210070, 210076, 210079, 210103, 210115, 210118, 210124)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-07-29 00:34:22
Duration: 266ms

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (209909, 209371, 209373, 209603, 209608, 209610, 209612, 209620, 209643, 209644, 209694, 209703, 209730, 209736, 209775, 209789, 209795, 209800, 209801, 209818, 209819, 209859, 209860, 209873, 209885, 209886, 209888, 209901, 209972, 209993, 210021, 210025, 210041, 210042, 210052, 210092, 210103, 210113)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-07-29 00:29:44
Duration: 247ms

SELECT "product_warehouse_inventory".id FROM "product_warehouse_inventory" WHERE ("product_warehouse_inventory"."product_id" in (209278)) ORDER BY "product_warehouse_inventory"."warehouse_name";

Date: 2023-07-29 00:41:07
Duration: 237ms