Duplicate Indexes
These indexes exist, but aren’t needed. Remove them
for faster writes.
rails generate migration remove_unneeded_indexes
And paste
remove_index :product_product, name: "product_product_product_tmpl_id_index", column: :product_tmpl_id
| Details |
On product_product
product_product_product_tmpl_id_index (product_tmpl_id)
is covered by
product_product_product_tmpl_id_default_code_idx (product_tmpl_id, default_code)
|
Slow Queries
Slow queries take 20 ms or more on average and have been called at least 100 times.
Explain queries to see where to add indexes.
| Total Time |
Average Time |
Calls |
|
1,328 min
22%
|
171 ms
|
466,147
odoo
|
SELECT "production_schedule_line".id FROM "production_schedule_line" WHERE ("production_schedule_line"."production_ticket_id" IS NULL AND ("production_schedule_line"."to_skip" IS NULL or "production_schedule_line"."to_skip" = $1 )) ORDER BY "production_schedule_line"."id"
|
|
72 min
1%
|
461 ms
|
9,329
odoo
|
SELECT "material_requisition_line".id FROM "material_requisition_line" LEFT JOIN "res_partner" as "material_requisition_line__partner_id" ON ("material_requisition_line"."partner_id" = "material_requisition_line__partner_id"."id") LEFT JOIN "product_category" as "material_requisition_line__categ_id" ON ("material_requisition_line"."categ_id" = "material_requisition_line__categ_id"."id") LEFT JOIN "product_product" as "material_requisition_line__product_id" ON ("material_requisition_line"."product_id" = "material_requisition_line__product_id"."id") WHERE ("material_requisition_line"."requisition_id" in ($1)) ORDER BY "material_requisition_line__partner_id"."display_name" ,"material_requisition_line__categ_id"."parent_left" ,"material_requisition_line__product_id"."default_code" ,"material_requisition_line__product_id"."id"
|
|
8 min
0.1%
|
696 ms
|
688
odoo
|
SELECT "material_requisition_line".id FROM "material_requisition_line" LEFT JOIN "res_partner" as "material_requisition_line__partner_id" ON ("material_requisition_line"."partner_id" = "material_requisition_line__partner_id"."id") LEFT JOIN "product_category" as "material_requisition_line__categ_id" ON ("material_requisition_line"."categ_id" = "material_requisition_line__categ_id"."id") LEFT JOIN "product_product" as "material_requisition_line__product_id" ON ("material_requisition_line"."product_id" = "material_requisition_line__product_id"."id") WHERE ((("material_requisition_line"."state" = $1) AND ("material_requisition_line"."dispatch_qty" > $2)) AND "material_requisition_line"."out_transfer_id" IS NULL ) ORDER BY "material_requisition_line__partner_id"."display_name" ,"material_requisition_line__categ_id"."parent_left" ,"material_requisition_line__product_id"."default_code" ,"material_requisition_line__product_id"."id"
|