openerp-community team mailing list archive
-
openerp-community team
-
Mailing list archive
-
Message #04005
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