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: 52665
Row progression: 52665, 10533, 0

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

Existing indexes
- id PRIMARY

to speed up

Total Time	Average Time	Calls
78 min 0.8%	22 ms	209,917 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
3,563 min 36%	243 ms	879,669 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"`
78 min 0.8%	22 ms	209,917 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: 52665 Row progression: 52665, 10533, 0 Row estimates - state (=): 10533 - create_date (sort): 1 Existing indexes - id PRIMARY`