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)

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)

Suggested Indexes

Add indexes to speed up queries.

rails generate migration add_suggested_indexes

And paste

commit_db_transaction
add_index :material_requisition, [:state, :create_date], algorithm: :concurrently

Details

CREATE INDEX CONCURRENTLY ON material_requisition (state, create_date)

Rows: 50269
Row progression: 50269, 10054, 0

Row estimates
- state (=): 10054
- create_date (sort): 1

Existing indexes
- id PRIMARY

to speed up

Total Time	Average Time	Calls
43 min 0.8%	21 ms	122,326 odoo
`SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."state" = $1) ORDER BY "material_requisition"."create_date" DESC`

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,865 min 33%	232 ms	482,753 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" = false )) ORDER BY "production_schedule_line"."id"`
43 min 0.8%	21 ms	122,326 odoo
`SELECT "material_requisition".id FROM "material_requisition" WHERE ("material_requisition"."state" = $1) ORDER BY "material_requisition"."create_date" DESC` Details `CREATE INDEX CONCURRENTLY ON material_requisition (state, create_date)` `Rows: 50269 Row progression: 50269, 10054, 0 Row estimates - state (=): 10054 - create_date (sort): 1 Existing indexes - id PRIMARY`