← Back to team overview

openerp-community team mailing list archive

Re: Tools to analyse OpenERP databases size

 

Hi,

@Oscar, Thanks a lot. I forgot this good doc I saw at Openerp Days. Yes
it's the kind of information I want to have.

But I agree with Ferdinand, it could be great to have some modules in
OpenERP available to do that.

If some people are interesting to work on that, please contact me.

Regards.




[image: logo]
*Sylvain LE GAL*  Service informatique
  *GRAP* SCIC SARL   *Groupement Régional Alimentaire de Proximité*   3
Grande rue des feuillants 69001 Lyon   Bureau : (+33) 09.72.32.33.17
Astreinte : (+33) 06.81.85.61.43  Site web : www.grap.coop
Twitter : @legalsylvain <https://twitter.com/legalsylvain>


2013/11/16 Ferdinand Gassauer <f.gassauer@xxxxxxxxxx>

>  On 2013-11-16 01:42, Oscar Alca wrote:
>
> Maybe this can be usefull to you:
>
> https://drive.google.com/file/d/1CB23k0i9A0fS8nAR4Iyh6l2q0s6BP_Jmc8z-h7i1vwLPtM2n2qd97r-_EQ7y/edit?usp=sharing
>
>
> Hmm
> it would be great if all these proposals were available as a module and
> immediately usable.
> I know that this implies changing postgres config parameters, but I think
> it would be admin friendly to allow peeking into the stats without all the
> hazel to install it.
>
>
>
> On Wed, Nov 13, 2013 at 9:32 AM, Sylvain LE GAL <sylvain.legal@xxxxxxxxx>wrote:
>
>>    Hi all,
>>
>>  I would like to analyse my openerp databases, and specially the reason
>> of the size of my databases. I would like to have a simple tools that
>> indicate wich module "generates" data with the goal to be able to analyse,
>> reduce, optimize, etc...
>>  Basically, I would have a report that mention for a database :
>>  - module 'account' : 1,2 Gb ;
>>  - module 'stock' : 2,1 Gb ;
>> - module 'product' : 280 Mb ;
>>  - module 'base' : 50 Mb ;
>> - ...
>>
>>  1/ does this module exist ?
>> This kind of module doesn't seem to exist in official addons neither in
>> server-env-tools <https://launchpad.net/%7Eserver-env-tools-core-editors>.
>>
>>
>>  2/ If not, are there some persons interested to work on it ? I think
>> that it's possible using openobject request & some sysadmin requests<https://wiki-bsse.ethz.ch/display/ITDOC/Check+size+of+tables+and+objects+in+PostgreSQL+database>on PostgreSQL.
>>
>>
>>  Thanks !
>>
>>    [image: logo]
>> *Sylvain LE GAL *  Service informatique
>>   *GRAP* SCIC SARL   *Groupement Régional Alimentaire de Proximité*
>>   Twitter : @legalsylvain <https://twitter.com/legalsylvain>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~openerp-community
>> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~openerp-community
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
>  --
>
>
>
>
> Ing. Oscar Alcalá Rivera
> *312-107-1704* · oszckar@xxxxxxxxx <ozckar@xxxxxxxxx>
>
> Paseo de Bugambilias 251 · Villa de alvarez, Colima, CP 28978
> Tlf: *3123111122*
>
> *Open Source Enthusiast*
>      [image: twitter] <http://twitter.com/oscarolar> [image: linkedIn]<http://www.linkedin.com/pub/oscar-alcal%C3%A1/3b/a79/922>
>    [image: Google+] <http://plus.google.com/107659954580035981067/posts>
>
> [image: eco] No me imprimas si no es necesario. Protejamos el medio
> ambiente
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~openerp-community
> Post to     : openerp-community@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~openerp-community
> More help   : https://help.launchpad.net/ListHelp
>
>
>

References