Times Reported Time consuming queries #1

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 = 186753 and item_demand_plan_id = 3827 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: 2024-02-04 08:47:10
Duration: 3s980ms

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 = 203851 and item_demand_plan_id = 3835 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: 2024-02-04 06:16:15
Duration: 2s814ms

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 = 215458 and item_demand_plan_id = 3827 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: 2024-02-04 09:00:28
Duration: 2s643ms

x Hide

Times Reported Time consuming queries #2

x Hide

SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-04 08:50:40
Duration: 890ms

SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-04 08:16:08
Duration: 884ms

SELECT "ir_attachment".id FROM "ir_attachment" WHERE (("ir_attachment"."res_field" IS NULL AND (unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-%/web.assets_common.css'))) AND (NOT ((unaccent ("ir_attachment"."url"::text) like unaccent ('/web/content/%-f34fa30/%%%'))))) ORDER BY "ir_attachment"."id" DESC;

Date: 2024-02-04 09:07:16
Duration: 883ms

x Hide

Times Reported Time consuming queries #3

x Hide

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-04 21:32:49') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_960"', '["pointspring_master","calendar.alarm",19498]', '["pointspring_master","mail.channel",54]', '["pointspring_master","mail.channel",55]', '["pointspring_master","mail.channel",469]', '["pointspring_master","res.partner",19498]', '["pointspring_master","ir.needaction",19498]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-04 21:33:39
Duration: 704ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-04 08:44:20') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_1028"', '["pointspring_master","calendar.alarm",19566]', '["pointspring_master","mail.channel",242]', '["pointspring_master","mail.channel",431]', '["pointspring_master","mail.channel",505]', '["pointspring_master","mail.channel",523]', '["pointspring_master","res.partner",19566]', '["pointspring_master","ir.needaction",19566]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-04 08:45:11
Duration: 679ms

SELECT "bus_bus".id FROM "bus_bus" WHERE (("bus_bus"."create_date" > '2024-02-04 09:08:56') AND ("bus_bus"."channel" in ('"bundle_changed"', '"notify_branch_changed_984"', '["pointspring_master","calendar.alarm",19522]', '["pointspring_master","mail.channel",39]', '["pointspring_master","mail.channel",40]', '["pointspring_master","mail.channel",50]', '["pointspring_master","mail.channel",329]', '["pointspring_master","mail.channel",330]', '["pointspring_master","mail.channel",422]', '["pointspring_master","res.partner",19522]', '["pointspring_master","ir.needaction",19522]'))) ORDER BY "bus_bus"."id";

Date: 2024-02-04 09:09:46
Duration: 662ms

x Hide

Times Reported Time consuming queries #4

x Hide

update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (194306) and warehouse_id = (46));

Date: 2024-02-04 09:01:25
Duration: 224ms

update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (178051) and warehouse_id = (46));

Date: 2024-02-04 09:01:33
Duration: 221ms

update product_warehouse_inventory set sft_stk_qty = 0 where id = ( select id from product_warehouse_inventory where product_id = (209187) and warehouse_id = (46));

Date: 2024-02-04 08:51:20
Duration: 220ms

x Hide

Times Reported Time consuming queries #5

x Hide

with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 172771 and item_demand_plan_id = 3827 AND date::date = DATE '2024-02-29' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;

Date: 2024-02-04 08:22:56
Duration: 516ms

with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 203875 and item_demand_plan_id = 3835 AND date::date = DATE '2024-02-29' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;

Date: 2024-02-04 06:16:12
Duration: 484ms

with data as ( SELECT id, row_number() OVER w as rnum FROM forecasted_data where product_id = 249466 and item_demand_plan_id = 3835 AND date::date = DATE '2024-02-29' and active = True and is_forcast = True WINDOW w AS (PARTITION BY product_id, date, min_product_uom_qty, max_product_uom_qty ORDER BY id)) SELECT id FROM data WHERE rnum > 0;

Date: 2024-02-04 05:33:25
Duration: 445ms

x Hide

Times Reported Time consuming queries #6

x Hide

select id, class_code from product_warehouse_inventory where product_id = 178802 and warehouse_id = 38;

Date: 2024-02-04 08:16:11
Duration: 372ms

select id, class_code from product_warehouse_inventory where product_id = 178753 and warehouse_id = 38;

Date: 2024-02-04 08:16:16
Duration: 303ms

select id, class_code from product_warehouse_inventory where product_id = 251212 and warehouse_id = 35;

Date: 2024-02-04 08:09:22
Duration: 290ms

x Hide

Times Reported Time consuming queries #7

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

Date: 2024-02-04 08:15:56
Duration: 2s324ms

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

Date: 2024-02-04 08:28:55
Duration: 2s235ms

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

Date: 2024-02-04 09:00:31
Duration: 1s902ms

x Hide

Times Reported Time consuming queries #8

x Hide

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

Date: 2024-02-04 08:28:17
Duration: 4s88ms

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

Date: 2024-02-04 06:07:39
Duration: 3s839ms

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

Date: 2024-02-04 09:21:47
Duration: 3s687ms

x Hide

Times Reported Time consuming queries #9

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 = 3828 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-02-04 08:22:57
Duration: 2s74ms

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 = 3825 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-02-04 05:57:04
Duration: 1s999ms

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 = 3827 GROUP BY ill.item_demand_plan_id having count(ill.id) > 0;

Date: 2024-02-04 08:50:41
Duration: 1s845ms

x Hide

Times Reported Time consuming queries #10

x Hide

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;

Date: 2024-02-04 07:23:53
Duration: 610ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;

Date: 2024-02-04 05:30:10
Duration: 582ms

SELECT "product_template".id FROM "product_template" LEFT JOIN "ir_translation" AS "product_template__name" ON ("product_template"."id" = "product_template__name"."res_id" AND "product_template__name"."type" = 'model' AND "product_template__name"."name" = 'product.template,name' AND "product_template__name"."lang" = 'en_US' AND "product_template__name"."value" != '') WHERE (("product_template"."active" = true) AND (("product_template"."sale_ok" = true) AND (("product_template"."website_id" in (1)) OR "product_template"."website_id" IS NULL))) ORDER BY COALESCE("product_template"."is_published", false) DESC, COALESCE("product_template__name"."value", "product_template"."name") DESC, "product_template"."id" DESC;

Date: 2024-02-04 08:51:20
Duration: 582ms

x Hide

Times Reported Time consuming queries #11

x Hide

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

Date: 2024-02-04 05:57:05
Duration: 2s48ms

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

Date: 2024-02-04 08:45:36
Duration: 1s837ms

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

Date: 2024-02-04 08:09:25
Duration: 1s569ms

x Hide