Community: Framework mailing list archives

expert-framework@mail.odoo.com

Re: unused database indexes

by
Camptocamp France SAS, Alexandre Fayolle - Camptocamp
- 04/14/2016 05:24:25
On 14/04/2016 11:06, Alexandre Fayolle wrote:
> Also suspicious given the number of records are the unused indices on
> mail tables:
> 
> mail_message_message_id_index

this one is the largest one, with 250.53 MB	(1509670 tuples)

* mail_message_subtype_id_index is 48MB (1509670 tuples too)
* stock_move_name_index is 18.39 MB	(123281 tuples)




-- 
Alexandre Fayolle
Chef de Projet
Tel : +33 4 58 48 20 30

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
http://www.camptocamp.com