Vous n'êtes pas identifié(e).
bonjour,
je gère une base de données d'un ERP (270 tables en tout...) sous postgreSQL.
Le soir la base de données fait environs 1.4Go .
Chaque matin/nuit on procède à un vacum complet et à un réindex complet aussi. Après cette opération la base ne fait que 120 Mo. (soit 10x fois moins).
Dans l'entreprise, les collègues (30 travaillent dessus) disent que le matin l'ERP est rapide et vers la fin de journée il rame.
Je suppose que cela est dû à la base de données qui devient trop grosse par rapport aux ressources du serveur.
Ou bien, cette croissance dans la journée est-elle due à une mauvaise structure de la base (trop d'indexs par ci et là) ou à autre chose ?
La base de l'erp subit bcp de miseàjour (update) et suppression dans la journée et très peu de suppression. Et évidement constament des SELECT.
que puis-je y faire ?
merci de votre conseil.
Hors ligne
Y a bcp de suppression ou pas ? car vous vous contredisez dans votre explication.
Hors ligne
Bonjour,
j'ai déjà répondu dans l'autre thread mais je reprend ici car plus de détails.
Quand vous dites vacuum, est-ce un vacuum full ?
Y a-t-il beaucoup de suppression ou peu de suppression ?
Comme dit dans l'autre message, il faudrait vérifier que l'autovacuum est activé, puis qu'il est suffisamment agressif pour se lancer assez fréquemment. Quelle est l'architecture du serveur ? et les paramètres de configuration principaux (shared_buffers, work_mem, maintenance_work_mem ...)? S'il s'agit d'une version 8.1, il faudrait songer à migrer vers une version supportée, et mieux une version beaucoup plus récente telle que la 9.1.
Vous pouvez également tracer les requêtes les plus lentes et fournir un explain analyze de ces requêtes le matin (quand elles sont rapides) et le soir (quand elles sont lentes).
Julien.
https://rjuju.github.io/
Hors ligne
en fin de journée la base doit taffer que sur les disques.
Hors ligne
oui j'ai fait une erreur de frappe : c'est donc :
beacuoup de modifications et de suppression , très peu d'insertions . Et évidement constament des SELECT.
j'ai désactivé l'autovacum et le fait faire la nuit (ou quand j'ai le temps à midi par moi-même). En fait l'activité constante de l'autovacum générait des ralentissement constant durant l'activité des collègues. Je suppose que bcp de tables/index ou relations étaient mises en attente à cause de lui.
Migrer la base de donner d'un ERP n'est pas aussi simple que ça, vous pensez bien qu'il y a aussi l'applicatif qui doit suivre. J'ai déjà essayé de le passer en 8.4 mais il y a des requêtes non supportées qu'il faut faire réécrire et valider.
Par contre en 8.2, aucun souci, mais le gain de perf est moindre..
j'ai déjà essayer de trouver les requêtes les plus lentes en loguant ce qui dure plus d'une seconde mais il y en a trop.
En fait il faudrait que psotgresql fasse ce que Mysql fait très bien : il affiche le nombre de fois qu'une requête est utilisée. Mais ça je n'ai pas trouvé comment l'obtenir avec postgres.
De même j'aurai besoin de savoir quels indexes ne servent à rien car l'ERP en crée tout seul en fonction de critère stupide.
En regardant la ta taille de certains index avec pgadmin, dès fois c'est plus gros que la taille elle-même ce qui je pense est complète anormale non ?
Hors ligne
pour trouver les index non utilisés : select relname,indexrelname, idx_scan from pg_stat_user_indexes order by idx_scan
Dernière modification par kenrio (20/08/2012 15:50:33)
Hors ligne
Quel système de disque avez-vous sur le serveur ? Si l'autovacuum pénalise le serveur, vous pouvez essayer de le rendre moins aggressif, ou plus aggressif. Sinon, vous pouvez toujours modifier les paramètres pour faire en sorte que l'autovacuum ne lance qu'analyze, ce qui devrait déjà améliorer un peu la situation sur la fin de journée.
Julien.
https://rjuju.github.io/
Hors ligne
Par ailleurs, ça tourne sur quoi, physiquement, pour qu'un autovacuum qui se déclenche sur une base de 120Mo fasse ramer l'application ?
Marc.
Hors ligne
un vieux xeon à 4 coeurs (bi-cpu à 2.0G) mais comme pg8.1 n'utilise que 1 coeur ça ne sere à rien (sous debian etch), avec 4go de ram, et vieux disque dur raid scsi (mais plus lent que les sata maintenant) et surtout 20 utilisateurs simultanés.
l'année dernière, par curiosité, j'avais copié l'erp sur mon notebook récent (dual core i7 2.8Ghz ssd) et il y avait un rapport x5 en vitesse sur certain traitement (j'avais comparé en étant seul sur le l'ERP après la journée).
Hors ligne
Attention, postgres n'utilise qu'un cœur par backend, donc avec 20 utilisateurs simultanés, avoir plusieurs cœurs sera utile.
J'avais également oublié de vous répondre pour le nombre de fois qu'une requête est lancée. Vous pouvez utiliser l'outil pgBadger qui parsera vos logs pour afficher ce genre d'informations (les plus couteuses par temps cumulés, les plus longues ...). Avec ces informations, vous pourrez tester un explain analyze des requêtes les plus longues le matin et le soir, et voir si cela est du à des statistiques trop vieilles, auquel cas il faudra lancer plus régulièrement des analyze.
Pouvez-vous me dire quels sont les paramètres maintenance_work_mem,shared_buffers, effective_cache_size ? Et s'agit-il d'un serveur dédié pour postgres ?
Julien.
https://rjuju.github.io/
Hors ligne
Attention, postgres n'utilise qu'un cœur par backend, donc avec 20 utilisateurs simultanés, avoir plusieurs cœurs sera utile.
J'avais également oublié de vous répondre pour le nombre de fois qu'une requête est lancée. Vous pouvez utiliser l'outil pgBadger qui parsera vos logs pour afficher ce genre d'informations (les plus couteuses par temps cumulés, les plus longues ...). Avec ces informations, vous pourrez tester un explain analyze des requêtes les plus longues le matin et le soir, et voir si cela est du à des statistiques trop vieilles, auquel cas il faudra lancer plus régulièrement des analyze.
Pouvez-vous me dire quels sont les paramètres maintenance_work_mem,shared_buffers, effective_cache_size ? Et s'agit-il d'un serveur dédié pour postgres ?
merci de votre réponse.
est-ce que l'outil d'analyse dont vous parler permet de rationnaliser les requêtes ? c-a-d est-ce qu'il comprend que "select * from a where x=1" est la même requête que "select * from a where x=2" ?
car si il me sort que les requêtes longues, alors le log le fait déjà ça.
oui c'est un serveur dédié.
Hors ligne
Oui, bien sur cet outil permet de normaliser les requêtes. Et il n'analysera bien sur que les requêtes qui se trouvent dans les logs, donc si vous mettez un log_min_duration_statement à 1 seconde, les requêtes les plus rapides ne seront pas utilisées. Cela nécessite également un peu de paramétrage sur l'affichage des logs (traces en anglais, log_line_prefix spécifique). Cela est indiqué dans le readme de pgBadger, disponible sur https://github.com/dalibo/pgbadger.
Julien.
https://rjuju.github.io/
Hors ligne
pour trouver les index non utilisés : select relname,indexrelname, idx_scan from pg_stat_user_indexes order by idx_scan
je l'ai fait et voilà ce que j'obtiens :
les 4/5 sont à zéro.
et les plus élevés sont à 33818998
mais est-ce depusi quand ? remise à zéro chaque jour ou depuis la création de la base ?
cpn_sale_document_kind;cpn_sale_document_kind_pkey;0
wkf;wkf_pkey;0
cpn_account_analyse;cpn_account_analyse_pkey;0
cpn_account_analyse;cpn_account_analyse_user_id_index;0
cpn_hr_affiliation;cpn_hr_affiliation_pkey;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_alloc_id_index;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_instructororganiza;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_period_id_index;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_alerte_user_id2_in;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_affiliation_id_ind;0
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_alerte_user_id1_in;0
perm;perm_pkey;0
res_roles;res_roles_pkey;0
wkf_triggers;wkf_triggers_pkey;0
wkf_transition;wkf_transition_pkey;0
wkf_activity;wkf_activity_pkey;0
mrp_procurement;mrp_procurement_location_id_index;0
mrp_procurement;mrp_procurement_move_id_index;0
mrp_procurement;mrp_procurement_product_id_index;0
mrp_procurement;mrp_procurement_product_uom_index;0
mrp_procurement;mrp_procurement_purchase_id_index;0
mrp_procurement;mrp_procurement_purchase_line_id_index;0
product_product;product_product_pkey;0
product_product;product_product_product_tmpl_id_index;0
product_uom;product_uom_accounting_uos_id_index;0
product_uom;product_uom_category_id_index;0
stock_warehouse_orderpoint;stock_warehouse_orderpoint_pkey;0
stock_warehouse_orderpoint;stock_warehouse_orderpoint_procurement_id_index;0
stock_warehouse_orderpoint;stock_warehouse_orderpoint_product_id_index;0
stock_warehouse_orderpoint;stock_warehouse_orderpoint_product_uom_index;0
stock_warehouse_orderpoint;stock_warehouse_orderpoint_warehouse_id_index;0
stock_warehouse;stock_warehouse_pkey;0
stock_warehouse;stock_warehouse_lot_input_id_index;0
stock_warehouse;stock_warehouse_lot_output_id_index;0
stock_warehouse;stock_warehouse_lot_stock_id_index;0
wkf_logs;wkf_logs_pkey;0
stock_production_lot_revision;stock_production_lot_revision_pkey;0
stock_production_lot_revision;stock_production_lot_revision_author_id_index;0
stock_production_lot_revision;stock_production_lot_revision_lot_id_index;0
stock_production_lot;stock_production_lot_pkey;0
stock_tracking;stock_tracking_pkey;0
stock_location;stock_location_pkey;0
stock_location;stock_location_account_id_index;0
stock_location;stock_location_location_id_index;0
sale_order_line;sale_order_line_address_allotment_id_index;0
sale_order_line;sale_order_line_date_planned;0
sale_order_line;sale_order_line_procurement_id_index;0
sale_order_line;sale_order_line_product_packaging_index;0
sale_order_line;sale_order_line_product_uom_index;0
sale_order_line;sale_order_line_product_uos_index;0
sale_order_line;sale_order_line_service_id_index;0
sale_order_line;sale_order_utilisation_reste;0
stock_move;stock_move_address_id_index;0
stock_move;stock_move_location_id_index;0
stock_move;stock_move_lot_id_index;0
stock_move;stock_move_move_dest_id_index;0
stock_move;stock_move_prodlot_id_index;0
stock_move;stock_move_product_packaging_index;0
stock_move;stock_move_product_uom_index;0
stock_move;stock_move_product_uos_index;0
stock_move;stock_move_tracking_id_index;0
res_partner_address;name_index;0
res_partner_address;res_partner_address_country_id_index;0
res_partner_address;res_partner_address_function_index;0
res_partner_address;res_partner_address_state_id_index;0
res_partner_address;street_index;0
stock_lot;stock_lot_pkey;0
stock_move_lot;stock_move_lot_pkey;0
stock_move_lot;stock_move_lot_address_id_index;0
stock_move_lot;stock_move_lot_loc_dest_id_index;0
stock_move_lot;stock_move_lot_lot_id_index;0
res_partner;res_partner_autorisation_primaire_shop_id_index;0
res_partner;res_partner_autorisation_secondaire_shop_id_index;0
res_partner;res_partner_bank_name_id_index;0
res_partner;res_partner_client_lien_index;0
res_partner;res_partner_coper_diag_id_index;0
res_partner;res_partner_copier_diag_id_index;0
res_partner;res_partner_exit_why_index;0
res_partner;res_partner_mode_contact_id_index;0
res_partner;res_partner_mode_payment_id_index;0
res_partner;res_partner_option_releve_shop_id_index;0
res_partner;res_partner_origin_index;0
res_partner;res_partner_payment_term_index;0
res_partner;res_partner_pricelist_version_id_index;0
res_partner;res_partner_responsible_index;0
res_partner;res_partner_user_id_index;0
stock_picking;stock_picking_address_id_index;0
stock_picking;stock_picking_loc_move_id_index;0
stock_picking;stock_picking_location_dest_id_index;0
stock_picking;stock_picking_location_id_index;0
stock_picking;stock_picking_lot_id_index;0
stock_picking;stock_picking_move_lot_id_index;0
product_packaging;product_packaging_pkey;0
product_packaging;product_packaging_product_id_index;0
product_packaging;product_packaging_ul_index;0
stock_inventory;stock_inventory_pkey;0
account_account;account_account_currency_id_index;0
stock_move_history_ids;stock_move_history_ids_child_id_index;0
stock_move_history_ids;stock_move_history_ids_parent_id_index;0
account_analytic_account;account_analytic_account_pkey;0
account_analytic_account;account_analytic_account_contact_id_index;0
account_analytic_account;account_analytic_account_parent_id_index;0
account_analytic_account;account_analytic_account_partner_id_index;0
sale_shop;sale_shop_coord_commercial_id_index;0
sale_shop;sale_shop_coord_direction_id_index;0
sale_shop;sale_shop_coord_financier_id_index;0
sale_shop;sale_shop_coord_rh_id_index;0
sale_shop;sale_shop_invoice_partner_address_id_index;0
sale_shop;sale_shop_partner_id_index;0
sale_shop;sale_shop_payment_default_id_index;0
sale_shop;sale_shop_pricelist_id_index;0
sale_shop;sale_shop_project_id_index;0
sale_shop;sale_shop_warehouse_id_index;0
stock_incoterms;stock_incoterms_pkey;0
stock_inventory_line;stock_inventory_line_pkey;0
stock_inventory_line;stock_inventory_line_inventory_id_index;0
stock_inventory_line;stock_inventory_line_location_id_index;0
stock_inventory_line;stock_inventory_line_product_id_index;0
stock_inventory_line;stock_inventory_line_product_uom_index;0
stock_inventory_move_rel;stock_inventory_move_rel_inventory_id_index;0
stock_inventory_move_rel;stock_inventory_move_rel_move_id_index;0
sale_shop_account;sale_shop_account_account_id_index;0
sale_shop_account;sale_shop_account_shop_id_index;0
sale_order;sale_order_comment_notice_user_id_index;0
sale_order;sale_order_conditions_reglement_id_index;0
sale_order;sale_order_date;0
sale_order;sale_order_document_kind_id2_index;0
sale_order;sale_order_document_kind_id_index;0
sale_order;sale_order_mad_contract_kind_id2_index;0
sale_order;sale_order_mad_contract_kind_id_index;0
sale_order;sale_order_mad_post_id_index;0
sale_order;sale_order_name;0
sale_order;sale_order_origin_index;0
sale_order;sale_order_partner_invoice_id_index;0
sale_order;sale_order_partner_order_id_index;0
sale_order;sale_order_pricelist_id_index;0
sale_order;sale_order_project_id_index;0
sale_order;sale_order_purpose_id_index;0
sale_order;sale_order_referent_address_partner_id_index;0
sale_order;sale_order_reject_reason_index;0
sale_order;sale_order_user_id_index;0
sale_order;sale_order_alerte_user_id_index;0
sale_order;sale_order_responsable_planning_user_id_index;0
product_pricelist;product_pricelist_pkey;0
product_pricelist;product_pricelist_currency_id_index;0
sale_order_picking_rel;sale_order_picking_rel_picking_id_index;0
purpose_set;purpose_set_pkey;0
purpose_set;purpose_set_partner_id_index;0
purpose_set;purpose_set_pricelist_id_index;0
purpose_set;purpose_set_shop_id_index;0
cpn_sale_reason;cpn_sale_reason_pkey;0
cpn_hr_employee_post;cpn_hr_employee_post_pkey;0
sale_order_shop_post;sale_order_shop_post_post_id_index;0
sale_order_shop_post;sale_order_shop_post_shop_id_index;0
sale_order_tax;sale_order_tax_tax_id_index;0
account_tax;account_tax_pkey;0
account_tax;account_tax_account_collected_id_index;0
account_tax;account_tax_account_paid_id_index;0
account_tax;account_tax_parent_id_index;0
sale_order_modifications;sale_order_modifications_product_id_index;0
sale_order_modifications;sale_order_modifications_reason_id_index;0
sale_order_modifications;sale_order_modifications_user_id_index;0
campaign_campaign;campaign_campaign_pkey;0
res_partner_organiz;res_partner_organiz_gir_id_index;0
res_partner_organiz;res_partner_organiz_partner_organiz_id_index;0
sale_order_payment;sale_order_payment_pkey;0
sale_order_payment;sale_order_payment_account_id_index;0
sale_order_payment;sale_order_payment_order_id_index;0
sale_order_line_property_rel;sale_order_line_property_rel_order_id_index;0
sale_order_line_property_rel;sale_order_line_property_rel_property_id_index;0
mrp_property;mrp_property_pkey;0
mrp_property;mrp_property_group_id_index;0
product_template;product_template_pkey;0
product_template;product_template_categ_id_index;0
product_template;product_template_product_manager_index;0
product_template;product_template_type_index;0
product_template;product_template_uom_id_index;0
product_template;product_template_uom_po_id_index;0
product_template;product_template_uos_id_index;0
cpn_hr_employee_contract_kind;cpn_hr_employee_contract_kind_pkey;0
sale_order_assistant_isolations;sale_order_assistant_isolations_raison_c_index;0
sale_order_assistant_isolations;sale_order_assistant_isolations_raison_e_index;0
account_invoice_line;account_invoice_line_account_id_index;0
account_invoice_line;account_invoice_line_service_id_index;0
account_invoice_line;account_invoice_line_uos_id_index;0
sale_order_infos;sale_order_infos_product_id_index;0
cpn_hr_employee;cpn_hr_employee_country_birth_index;0
cpn_hr_employee;cpn_hr_employee_dep_id_index;0
cpn_hr_employee;cpn_hr_employee_end_reason_index;0
cpn_hr_employee;cpn_hr_employee_famillysituation_index;0
cpn_hr_employee;cpn_hr_employee_formation_level_index;0
cpn_hr_employee;cpn_hr_employee_option_fiche_salariale_shop_id_index;0
cpn_hr_employee;cpn_hr_employee_option_releve_heures_shop_id_index;0
cpn_hr_employee;cpn_hr_employee_post_id_index;0
cpn_hr_employee;cpn_hr_employee_reject_reason_index;0
cpn_hr_employee;cpn_hr_employee_title_index;0
cpn_hr_employee;cpn_hr_employee_user_id2_index;0
account_invoice;account_invoice_account_id_index;0
account_invoice;account_invoice_address_contact_id_index;0
account_invoice;account_invoice_address_invoice_id_index;0
account_invoice;account_invoice_currency_id_index;0
account_invoice;account_invoice_journal_id_index;0
account_invoice;account_invoice_move_id_index;0
account_invoice;account_invoice_payment_term_index;0
account_invoice;account_invoice_project_id_index;0
cpn_hr_employee_holidays_kind;cpn_hr_employee_holidays_kind_pkey;0
cpn_hr_employee_holidays_kind;cpn_hr_employee_holidays_kind_kind_hour_index;0
res_request;res_request_ref_employee_id_index;0
res_request;res_request_ref_partner_id_index;0
res_company;res_company_pkey;0
res_company;res_company_currency_id_index;0
res_company;res_company_parent_id_index;0
res_company;res_company_partner_id_index;0
sale_order_assistant_periodes;sale_order_assistant_periodes_assistant_employee_id_index;0
sale_order_assistant_periodes;sale_order_assistant_periodes_raison_c_index;0
sale_order_assistant_periodes;sale_order_assistant_periodes_raison_e_index;0
res_payterm;res_payterm_pkey;0
res_request_history;res_request_history_pkey;0
res_request_history;res_request_history_act_from_index;0
res_request_history;res_request_history_act_to_index;0
res_request_history;res_request_history_req_id_index;0
res_request_link;res_request_link_pkey;0
res_partner_out_reason;res_partner_out_reason_pkey;0
product_pricelist_version;product_pricelist_version_pkey;0
product_pricelist_version;product_pricelist_version_pricelist_id_index;0
res_partner_som;res_partner_som_pkey;0
res_partner_title;res_partner_title_pkey;0
res_partner_function;res_partner_function_pkey;0
cpn_account_analyse_groupe;cpn_account_analyse_groupe_pkey;0
cpn_account_analyse_groupe;cpn_account_analyse_groupe_user_id_index;0
res_partner_canal;res_partner_canal_pkey;0
res_partner_mode_payment;res_partner_mode_payment_pkey;0
cpn_partner_gir;cpn_partner_gir_pkey;0
cpn_partner_diag;cpn_partner_diag_pkey;0
cpn_partner_diag;cpn_partner_diag_address_partner_id_index;0
cpn_partner_diag;cpn_partner_diag_partner_id_index;0
cpn_partner_diag;cpn_partner_diag_user_id_index;0
res_partner_event_type;res_partner_event_type_pkey;0
cpn_account_analyse_point;cpn_account_analyse_point_pkey;0
cpn_account_analyse_point;cpn_account_analyse_point_groupe_id_index;0
res_partner_event;res_partner_event_canal_id_index;0
res_partner_event;res_partner_event_som_index;0
res_partner_event;res_partner_event_user_id_index;0
res_partner_bank;res_partner_bank_pkey;0
res_partner_bank;res_partner_bank_partner_id_index;0
res_partner_category_type;res_partner_category_type_pkey;0
res_partner_category;res_partner_category_pkey;0
res_partner_category;res_partner_category_parent_id_index;0
res_partner_category;res_partner_category_type_id_index;0
res_groups;res_groups_pkey;0
res_lang;res_lang_pkey;0
res_country;res_country_pkey;0
res_country_state;res_country_state_pkey;0
res_country_state;res_country_state_country_id_index;0
res_currency;res_currency_pkey;0
purchase_order_line;purchase_order_line_pkey;0
purchase_order_line;purchase_order_line_move_dest_id_index;0
purchase_order_line;purchase_order_line_move_id_index;0
purchase_order_line;purchase_order_line_order_id_index;0
purchase_order_line;purchase_order_line_product_id_index;0
purchase_order_line;purchase_order_line_product_uom_index;0
purchase_order_taxe;purchase_order_taxe_ord_id_index;0
purchase_order_taxe;purchase_order_taxe_tax_id_index;0
purchase_order;purchase_order_pkey;0
purchase_order;purchase_order_dest_address_id_index;0
purchase_order;purchase_order_invoice_id_index;0
purchase_order;purchase_order_location_id_index;0
purchase_order;purchase_order_partner_address_id_index;0
purchase_order;purchase_order_partner_id_index;0
purchase_order;purchase_order_picking_id_index;0
purchase_order;purchase_order_pricelist_id_index;0
purchase_order;purchase_order_project_id_index;0
purchase_order;purchase_order_validator_index;0
purchase_order;purchase_order_warehouse_id_index;0
product_ul;product_ul_pkey;0
account_uos;account_uos_pkey;0
product_uom_categ;product_uom_categ_pkey;0
product_supplierinfo;product_supplierinfo_pkey;0
product_supplierinfo;product_supplierinfo_name_index;0
product_supplierinfo;product_supplierinfo_product_id_index;0
product_taxes_rel;product_taxes_rel_prod_id_index;0
product_taxes_rel;product_taxes_rel_tax_id_index;0
product_category;product_category_pkey;0
product_category;product_category_parent_id_index;0
product_template_name;product_template_name_pkey;0
product_template_name;product_template_name_partner_id_index;0
product_template_name;product_template_name_template_id_index;0
product_pricelist_item;product_pricelist_item_pkey;0
product_pricelist_item;product_pricelist_item_base_pricelist_id_index;0
product_pricelist_item;product_pricelist_item_categ_id_index;0
product_pricelist_item;product_pricelist_item_price_version_id_index;0
product_pricelist_item;product_pricelist_item_product_id_index;0
product_pricelist_item;product_pricelist_item_product_tmpl_id_index;0
product_pricelist_type;product_pricelist_type_pkey;0
product_price_type;product_price_type_pkey;0
product_price_type;product_price_type_currency_id_index;0
mrp_routing_workcenter;mrp_routing_workcenter_pkey;0
mrp_routing_workcenter;mrp_routing_workcenter_routing_id_index;0
mrp_routing_workcenter;mrp_routing_workcenter_workcenter_id_index;0
mrp_routing;mrp_routing_pkey;0
mrp_routing;mrp_routing_location_id_index;0
account_analytic_journal;account_analytic_journal_pkey;0
mrp_workcenter;mrp_workcenter_pkey;0
mrp_workcenter;mrp_workcenter_costs_cycle_account_id_index;0
mrp_workcenter;mrp_workcenter_costs_general_account_id_index;0
mrp_workcenter;mrp_workcenter_costs_hour_account_id_index;0
mrp_workcenter;mrp_workcenter_costs_journal_id_index;0
mrp_production_workcenter_line;mrp_production_workcenter_line_pkey;0
mrp_production_workcenter_line;mrp_production_workcenter_line_production_id_index;0
mrp_production_workcenter_line;mrp_production_workcenter_line_workcenter_id_index;0
mrp_production;mrp_production_pkey;0
mrp_production;mrp_production_bom_id_index;0
mrp_production;mrp_production_location_dest_id_index;0
mrp_production;mrp_production_location_src_id_index;0
mrp_production;mrp_production_move_created_id_index;0
mrp_production;mrp_production_move_prod_id_index;0
mrp_production;mrp_production_picking_id_index;0
mrp_production;mrp_production_product_id_index;0
mrp_production;mrp_production_product_uom_index;0
mrp_property_group;mrp_property_group_pkey;0
mrp_production_move_ids;mrp_production_move_ids_move_id_index;0
mrp_production_move_ids;mrp_production_move_ids_production_id_index;0
mrp_production_product_line;mrp_production_product_line_pkey;0
mrp_production_product_line;mrp_production_product_line_product_id_index;0
mrp_production_product_line;mrp_production_product_line_product_uom_index;0
mrp_production_product_line;mrp_production_product_line_production_id_index;0
mrp_procurement_property_rel;mrp_procurement_property_rel_procurement_id_index;0
mrp_procurement_property_rel;mrp_procurement_property_rel_property_id_index;0
mrp_bom;mrp_bom_pkey;0
mrp_bom;mrp_bom_bom_id_index;0
mrp_bom;mrp_bom_product_id_index;0
mrp_bom;mrp_bom_product_uom_index;0
mrp_bom;mrp_bom_routing_id_index;0
mrp_bom_property_rel;mrp_bom_property_rel_bom_id_index;0
mrp_bom_property_rel;mrp_bom_property_rel_property_id_index;0
mrp_bom_revision;mrp_bom_revision_pkey;0
mrp_bom_revision;mrp_bom_revision_author_id_index;0
mrp_bom_revision;mrp_bom_revision_bom_id_index;0
ir_ui_view_sc;ir_ui_view_sc_pkey;0
ir_ui_view;ir_ui_view_inherit_id_index;0
ir_values;ir_values_user_id_index;0
cpn_eval_item;cpn_eval_item_pkey;0
item_product_rel;item_product_rel_item_id_index;0
item_product_rel;item_product_rel_product_id_index;0
ir_sequence_type;ir_sequence_type_pkey;0
ir_sequence;ir_sequence_pkey;0
ir_ui_menu_group_rel;ir_ui_menu_group_rel_gid_index;0
ir_ui_menu_group_rel;ir_ui_menu_group_rel_menu_id_index;0
ir_ui_menu;ir_ui_menu_pkey;0
ir_model_fields;ir_model_fields_pkey;0
ir_report_custom_fields;ir_report_custom_fields_pkey;0
ir_report_custom_fields;ir_report_custom_fields_fc0_operande_index;0
ir_report_custom_fields;ir_report_custom_fields_fc1_operande_index;0
ir_report_custom_fields;ir_report_custom_fields_fc2_operande_index;0
ir_report_custom_fields;ir_report_custom_fields_fc3_operande_index;0
ir_report_custom_fields;ir_report_custom_fields_field_child0_index;0
ir_report_custom_fields;ir_report_custom_fields_field_child1_index;0
ir_report_custom_fields;ir_report_custom_fields_field_child2_index;0
ir_report_custom_fields;ir_report_custom_fields_field_child3_index;0
ir_report_custom_fields;ir_report_custom_fields_report_id_index;0
ir_report_custom;ir_report_custom_pkey;0
ir_report_custom;ir_report_custom_field_parent_index;0
ir_report_custom;ir_report_custom_menu_id_index;0
ir_report_custom;ir_report_custom_model_id_index;0
ir_module_module_dependency;ir_module_module_dependency_pkey;0
ir_module_module_dependency;ir_module_module_dependency_module_dest_id_index;0
ir_module_module_dependency;ir_module_module_dependency_module_id_index;0
ir_module_module;ir_module_module_pkey;0
ir_module_module;ir_module_module_category_id_index;0
ir_module_repository;ir_module_repository_pkey;0
ir_property;ir_property_pkey;0
ir_property;ir_property_company_id_index;0
ir_property;ir_property_fields_id_index;0
ir_model_fields_group_rel;ir_model_fields_group_rel_field_id_index;0
ir_model_fields_group_rel;ir_model_fields_group_rel_group_id_index;0
ir_module_category;ir_module_category_pkey;0
ir_module_category;ir_module_category_parent_id_index;0
ir_exports_line;ir_exports_line_pkey;0
ir_exports;ir_exports_pkey;0
ir_exports;ir_exports_user_id_index;0
ir_model_access;ir_model_access_pkey;0
ir_model_access;ir_model_access_group_id_index;0
ir_model_access;ir_model_access_model_id_index;0
delivery_grid_state_rel;delivery_grid_state_rel_grid_id_index;0
delivery_grid_state_rel;delivery_grid_state_rel_state_id_index;0
delivery_grid;delivery_grid_pkey;0
delivery_grid;delivery_grid_carrier_id_index;0
ir_actions;ir_actions_pkey;0
ir_attachment;ir_attachment_pkey;0
ir_cron;ir_cron_user_id_index;0
ir_default;ir_default_pkey;0
ir_default;ir_default_uid_index;0
crm_segmentation;crm_segmentation_pkey;0
crm_segmentation;crm_segmentation_categ_id_index;0
delivery_carrier;delivery_carrier_pkey;0
delivery_carrier;delivery_carrier_partner_id_index;0
delivery_carrier;delivery_carrier_product_id_index;0
delivery_grid_country_rel;delivery_grid_country_rel_country_id_index;0
delivery_grid_country_rel;delivery_grid_country_rel_grid_id_index;0
delivery_grid_line;delivery_grid_line_pkey;0
delivery_grid_line;delivery_grid_line_grid_id_index;0
crm_case_history;crm_case_history_pkey;0
crm_case_history;crm_case_history_canal_id_index;0
crm_case_history;crm_case_history_case_id_index;0
crm_case_history;crm_case_history_som_index;0
crm_case_history;crm_case_history_user_id_index;0
crm_case;crm_case_pkey;0
crm_case;crm_case_canal_id_index;0
crm_case;crm_case_categ_id_index;0
crm_case;crm_case_document_id_index;0
crm_case;crm_case_partner_address_id_index;0
crm_case;crm_case_partner_id_index;0
crm_case;crm_case_som_index;0
crm_case;crm_case_user_id_index;0
crm_segmentation_line;crm_segmentation_line_pkey;0
crm_segmentation_line;crm_segmentation_line_segmentation_id_index;0
cpn_sale_paragraphe;cpn_sale_paragraphe_pkey;0
crm_case_categ;crm_case_categ_pkey;0
calevent_delete_reason;calevent_delete_reason_pkey;0
cpn_pointing_paid;cpn_pointing_paid_pkey;0
cpn_pointing_paid;cpn_pointing_paid_delete_reason_index;0
cpn_pointing_paid;cpn_pointing_paid_shop_id_index;0
cpn_pointing;cpn_pointing_pkey;0
cpn_pointing;cpn_pointing_address_id_index;0
cpn_pointing;cpn_pointing_employee_id_index;0
cpn_partner_letter_kind;cpn_partner_letter_kind_pkey;0
cpn_partner_letter_template;cpn_partner_letter_template_pkey;0
cpn_partner_letter_template;cpn_partner_letter_template_kind_id_index;0
cpn_partner_letter_template;cpn_partner_letter_template_user_id_index;0
cpn_partner_letter;cpn_partner_letter_pkey;0
cpn_partner_letter;cpn_partner_letter_address_partner_id_index;0
cpn_partner_letter;cpn_partner_letter_employee_id_index;0
cpn_partner_letter;cpn_partner_letter_partner_id_index;0
cpn_partner_letter;cpn_partner_letter_template_id_index;0
cpn_partner_letter;cpn_partner_letter_user_id_index;0
cpn_partner_diag_domaine;cpn_partner_diag_domaine_pkey;0
cpn_partner_diag_element;cpn_partner_diag_element_diag_id_index;0
cpn_partner_diag_element;cpn_partner_diag_element_domaine_id_index;0
cpn_hr_paragraphe;cpn_hr_paragraphe_pkey;0
cpn_hr_paragraphe;cpn_hr_paragraphe_contract_kind_id_index;0
cpn_combo_kind_end;cpn_combo_kind_end_pkey;0
cpn_hr_sortie;cpn_hr_sortie_pkey;0
cpn_hr_sortie;cpn_hr_sortie_categorie_emploi_id_index;0
cpn_hr_sortie;cpn_hr_sortie_categorie_formation_id_index;0
cpn_hr_sortie;cpn_hr_sortie_employee_id_index;0
cpn_hr_sortie;cpn_hr_sortie_type_contrat_index;0
cpn_parametre;cpn_parametre_pkey;0
cpn_hr_equipment_historique;cpn_hr_equipment_historique_employee_id_index;0
cpn_hr_equipment_historique;cpn_hr_equipment_historique_user_id_index;0
cpn_hr_equipment;cpn_hr_equipment_pkey;0
cpn_hr_employee_region;cpn_hr_employee_region_pkey;0
cpn_hr_employee_reason;cpn_hr_employee_reason_pkey;0
cpn_hr_employee_period;cpn_hr_employee_period_pkey;0
cpn_combo_kind_hour;cpn_combo_kind_hour_pkey;0
cpn_hr_employee_rdv_kind;cpn_hr_employee_rdv_kind_pkey;0
cpn_hr_employee_rdv_kind;cpn_hr_employee_rdv_kind_kind_hour_index;0
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_doctor_index;0
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_kind_hour_index;0
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_partner_id_index;0
cpn_hr_employee_out_reason;cpn_hr_employee_out_reason_pkey;0
cpn_hr_employee_letter;cpn_hr_employee_letter_address_partner_id_index;0
cpn_hr_employee_letter;cpn_hr_employee_letter_partner_id_index;0
cpn_hr_employee_letter;cpn_hr_employee_letter_template_id_index;0
cpn_hr_employee_letter;cpn_hr_employee_letter_user_id_index;0
cpn_hr_employee_level;cpn_hr_employee_level_pkey;0
cpn_hr_employee_mail_kind;cpn_hr_employee_mail_kind_pkey;0
cpn_hr_employee_mail_template;cpn_hr_employee_mail_template_pkey;0
cpn_hr_employee_mail_template;cpn_hr_employee_mail_template_kind_id_index;0
cpn_hr_employee_mail_template;cpn_hr_employee_mail_template_user_id_index;0
cpn_hr_employee_alloc;cpn_hr_employee_alloc_pkey;0
cpn_hr_employee_information;cpn_hr_employee_information_pkey;0
cpn_hr_employee_information;cpn_hr_employee_information_parent_id_index;0
cpn_hr_employee_famillysituation;cpn_hr_employee_famillysituation_pkey;0
cpn_hr_employee_formation;cpn_hr_employee_formation_niveau_formation_id_index;0
cpn_hr_employee_dep;cpn_hr_employee_dep_pkey;0
cpn_hr_employee_dep;cpn_hr_employee_dep_region_id_index;0
cpn_hr_employee_embauchage;cpn_hr_employee_embauchage_pkey;0
cpn_hr_employee_embauchage;cpn_hr_employee_embauchage_contract_kind_id_index;0
cpn_hr_employee_embauchage;cpn_hr_employee_embauchage_employee_id_index;0
cpn_hr_employee_constraint_rel;cpn_hr_employee_constraint_rel_constraint_id_index;0
cpn_hr_employee_constraint_rel;cpn_hr_employee_constraint_rel_employee_id_index;0
cpn_hr_employee_constraint;cpn_hr_employee_constraint_pkey;0
cpn_hr_employee_constraint;cpn_hr_employee_constraint_constraint_kind_index;0
cpn_hr_employee_contact;cpn_hr_employee_contact_user_id_index;0
cpn_hr_employee_consent_extension;cpn_hr_employee_consent_extension_pkey;0
cpn_hr_employee_consent_extension;cpn_hr_employee_consent_extension_consent_id_index;0
cpn_hr_employee_consent_extension;cpn_hr_employee_consent_extension_employee_id_index;0
cpn_hr_employee_consent_extension;cpn_hr_employee_consent_extension_shop_id_index;0
cpn_hr_employee_consent_historic;cpn_hr_employee_consent_historic_pkey;0
cpn_hr_employee_consent_historic;cpn_hr_employee_consent_historic_consent_id_index;0
cpn_hr_employee_consent_historic;cpn_hr_employee_consent_historic_shop_id_index;0
cpn_hr_employee_consent;cpn_hr_employee_consent_shop_id_index;0
cpn_hr_employee_constraint_kind;cpn_hr_employee_constraint_kind_pkey;0
cpn_hr_employee_circuit_renewing;cpn_hr_employee_circuit_renewing_pkey;0
cpn_hr_employee_circuit_renewing;cpn_hr_employee_circuit_renewing_contract_kind_id_index;0
cpn_hr_employee_circuit;cpn_hr_employee_circuit_alerte_user_id_index;0
cpn_hr_employee_circuit;cpn_hr_employee_circuit_contract_kind_id2_index;0
cpn_hr_employee_circuit;cpn_hr_employee_circuit_contract_kind_id_index;0
cpn_hr_employee_circuit;cpn_hr_employee_circuit_end_reason_index;0
cpn_hr_employee_circuit_additionalclause;cpn_hr_employee_circuit_additionalclause_pkey;0
cpn_hr_employee_circuit_additionalclause;cpn_hr_employee_circuit_additionalclause_contract_kind_id_index;0
cpn_hr_employee_affectation;cpn_hr_employee_affectation_equipment_index;0
cpn_hr_employee_affectation;cpn_hr_employee_affectation_responsable_index;0
cpn_eval_note_line;cpn_eval_note_line_pkey;0
cpn_eval_note_line;cpn_eval_note_line_grp_id_index;0
cpn_eval_note_line;cpn_eval_note_line_item_line_id_index;0
cpn_hr_employee_appointment_employee;cpn_hr_employee_appointment_employee_employee_id_index;0
cpn_hr_employee_appointment;cpn_hr_employee_appointment_partner_id_index;0
cpn_hr_employee_appointment;cpn_hr_employee_appointment_rdv_kind_index;0
cpn_hr_employee_appointment;cpn_hr_employee_appointment_user_id_index;0
cpn_eval_sati_item_line;cpn_eval_sati_item_line_pkey;0
cpn_eval_sati_item_line;cpn_eval_sati_item_line_grp_id_index;0
cpn_eval_sati_item_line;cpn_eval_sati_item_line_item_id_index;0
cpn_eval_sati_note_line;cpn_eval_sati_note_line_pkey;0
cpn_eval_sati_note_line;cpn_eval_sati_note_line_eval_sati_id_index;0
cpn_eval_sati_note_line;cpn_eval_sati_note_line_item_line_id_index;0
cpn_eval_sati;cpn_eval_sati_pkey;0
cpn_eval_sati;cpn_eval_sati_employee_id_index;0
cpn_eval_sati;cpn_eval_sati_handle_user_id_index;0
cpn_eval_sati;cpn_eval_sati_inter_user_id_index;0
cpn_eval_sati;cpn_eval_sati_order_id_index;0
cpn_eval_sati;cpn_eval_sati_partner_id_index;0
cpn_eval_contract;cpn_eval_contract_referent_id_index;0
cpn_account_hour;cpn_account_hour_address_intervention_id_index;0
cpn_account_hour;cpn_account_hour_kind_id_index;0
cpn_account_hour;cpn_account_hour_kind_index;0
cpn_account_hour;cpn_account_hour_user_id_index;0
cpn_account_hour;date_end_inv_index;0
cpn_account_hour;date_end_paid_index;0
cpn_account_hour;date_start_inv_index;0
cpn_account_hour;date_start_paid_index;0
cpn_eval_item_line;cpn_eval_item_line_pkey;0
cpn_eval_item_line;cpn_eval_item_line_cat_id_index;0
cpn_eval_item_line;cpn_eval_item_line_item_id_index;0
cpn_eval_grp;cpn_eval_grp_pkey;0
cpn_eval_cat;cpn_eval_cat_pkey;0
cpn_account_money;cpn_account_money_bank_partner_id_index;0
cpn_account_hour_possible;cpn_account_hour_possible_address_intervention_id_index;0
cpn_account_hour_possible;cpn_account_hour_possible_user_id_index;0
cpn_account_hour_export;cpn_account_hour_export_categorie_horaire_index;0
cpn_account_hour_export;cpn_account_hour_export_employee_id_index;0
cpn_account_hour_export;cpn_account_hour_export_medical_id_index;0
campaign_partner_history;campaign_partner_history_pkey;0
campaign_partner_history;campaign_partner_history_camp_partner_id_index;0
campaign_partner_history;campaign_partner_history_step_id_index;0
campaign_partner;campaign_partner_pkey;0
campaign_partner;campaign_partner_campaign_id_index;0
campaign_partner;campaign_partner_part_adr_id_index;0
campaign_partner;campaign_partner_partner_id_index;0
campaign_partner;campaign_partner_step_index;0
campaign_partner;campaign_partner_user_id_index;0
campaign_step;campaign_step_pkey;0
campaign_step;campaign_step_campaign_id_index;0
calevent_test;calevent_test_pkey;0
calevent_test;calevent_test_employee_id_index;0
audittrail_log;audittrail_log_pkey;0
audittrail_log;audittrail_log_object_id_index;0
audittrail_log;audittrail_log_user_id_index;0
audittrail_rule;audittrail_rule_pkey;0
audittrail_rule;audittrail_rule_object_id_index;0
calevent_depend;calevent_depend_pkey;0
calevent_excepts;calevent_excepts_pkey;0
calevent_excepts;calevent_excepts_calevent_item_id_index;0
account_journal;account_journal_pkey;0
account_journal;account_journal_default_credit_account_id_index;0
account_journal;account_journal_default_debit_account_id_index;0
account_journal;account_journal_sequence_id_index;0
account_journal;account_journal_view_id_index;0
account_move;account_move_pkey;0
account_move;account_move_journal_id_index;0
account_move;account_move_period_id_index;0
account_period;account_period_pkey;0
account_period;account_period_fiscalyear_id_index;0
account_transfer;account_transfer_pkey;0
account_transfer;account_transfer_account_dest_id_index;0
account_transfer;account_transfer_account_src_id_index;0
account_transfer;account_transfer_adjust_account_id_index;0
account_transfer;account_transfer_journal_id_index;0
account_transfer;account_transfer_move_id_index;0
account_transfer;account_transfer_partner_id_index;0
account_transfer;account_transfer_period_id_index;0
account_transfer;account_transfer_project_id_index;0
audittail_rules_users;audittail_rules_users_rule_id_index;0
audittail_rules_users;audittail_rules_users_user_id_index;0
account_model;account_model_pkey;0
account_model;account_model_journal_id_index;0
account_subscription;account_subscription_pkey;0
account_subscription;account_subscription_model_id_index;0
account_transfer_invoice;account_transfer_invoice_invoice_id_index;0
account_transfer_invoice;account_transfer_invoice_transfer_id_index;0
account_payment_term_line;account_payment_term_line_pkey;0
account_payment_term_line;account_payment_term_line_payment_id_index;0
account_fiscalyear;account_fiscalyear_pkey;0
account_fiscalyear;account_fiscalyear_company_id_index;0
account_subscription_line;account_subscription_line_pkey;0
account_subscription_line;account_subscription_line_move_id_index;0
account_subscription_line;account_subscription_line_subscription_id_index;0
account_followup_followup_line;account_followup_followup_line_pkey;0
account_followup_followup_line;account_followup_followup_line_followup_id_index;0
account_bank_statement;account_bank_statement_pkey;0
account_bank_statement;account_bank_statement_account_id_index;0
account_move_line;account_move_line_pkey;0
account_move_line;account_move_line_account_id_index;0
account_move_line;account_move_line_currency_id_index;0
account_move_line;account_move_line_followup_line_id_index;0
account_move_line;account_move_line_journal_id_index;0
account_move_line;account_move_line_move_id_index;0
account_move_line;account_move_line_partner_id_index;0
account_move_line;account_move_line_period_id_index;0
account_move_line;account_move_line_reconcile_id_index;0
account_move_line;account_move_line_statement_id_index;0
account_move_reconcile;account_move_reconcile_pkey;0
account_model_line;account_model_line_pkey;0
account_model_line;account_model_line_account_id_index;0
account_model_line;account_model_line_currency_id_index;0
account_model_line;account_model_line_model_id_index;0
account_model_line;account_model_line_partner_id_index;0
account_journal_group_rel;account_journal_group_rel_group_id_index;0
account_journal_group_rel;account_journal_group_rel_journal_id_index;0
account_journal_period;account_journal_period_pkey;0
account_journal_period;account_journal_period_journal_id_index;0
account_journal_period;account_journal_period_period_id_index;0
account_journal_type_rel;account_journal_type_rel_journal_id_index;0
account_journal_type_rel;account_journal_type_rel_type_id_index;0
account_account_type;account_account_type_pkey;0
account_journal_view;account_journal_view_pkey;0
account_invoice_tax;account_invoice_tax_account_id_index;0
account_journal_column;account_journal_column_pkey;0
account_journal_column;account_journal_column_view_id_index;0
account_invoice_line_tax;account_invoice_line_tax_tax_id_index;0
account_followup_followup;account_followup_followup_pkey;0
account_followup_followup;account_followup_followup_company_id_index;0
account_bank_account;account_bank_account_pkey;0
account_bank_account;account_bank_account_account_id_index;0
account_bank_account;account_bank_account_bank_id_index;0
account_bank_account;account_bank_account_currency_id_index;0
account_bank_account;account_bank_account_journal_id_index;0
account_bank;account_bank_pkey;0
account_bank;account_bank_partner_id_index;0
account_budget_post_dotation;account_budget_post_dotation_pkey;0
account_budget_post_dotation;account_budget_post_dotation_period_id_index;0
account_budget_post_dotation;account_budget_post_dotation_post_id_index;0
account_budget_rel;account_budget_rel_account_id_index;0
account_budget_rel;account_budget_rel_budget_id_index;0
account_budget_post;account_budget_post_pkey;0
account_analytic_unittype;account_analytic_unittype_pkey;0
account_analytic_unittype;account_analytic_unittype_general_account_id_index;0
account_analytic_unittype;account_analytic_unittype_journal_id_index;0
account_analytic_line;account_analytic_line_pkey;0
account_analytic_line;account_analytic_line_account_id_index;0
account_analytic_line;account_analytic_line_general_account_id_index;0
account_analytic_line;account_analytic_line_journal_id_index;0
account_analytic_line;account_analytic_line_move_id_index;0
account_analytic_line;account_analytic_line_unit_id_index;0
res_users;res_users_login_key;0
res_users;res_users_login_uniq;0
res_users;res_users_pkey;0
res_users;res_users_address_id_index;0
res_users;res_users_company_id_index;0
account_account_rel;account_account_rel_child_id_index;0
account_account_rel;account_account_rel_parent_id_index;0
account_account_tax_default_rel;account_account_tax_default_rel_account_id_index;0
account_account_tax_default_rel;account_account_tax_default_rel_tax_id_index;0
cpn_account_analyse_ligne;cpn_account_analyse_ligne_analyse_id_index;0
cpn_account_analyse_ligne;cpn_account_analyse_ligne_user_id_index;0
ir_act_window;ir_act_window_pkey;0
ir_translation;ir_translation_pkey;0
account_invoice_line;account_invoice_line_product_id_index;1
cpn_hr_employee_circuit;cpn_hr_employee_circuit_consent_index;1
cpn_account_qr_import;cpn_account_qr_import_address_intervention_id_index;1
cpn_account_qr_import;cpn_account_qr_import_employee_id_index;1
sale_order_line;sale_order_line_incharge_index;2
cpn_hr_employee;cpn_hr_employee_user_id_index;2
account_invoice;account_invoice_payment_mode_id_index;2
ir_model;ir_model_pkey;2
cpn_hr_equipment_historique;cpn_hr_equipment_historique_equip_id_index;2
sale_order;sale_order_partner_incharge_id_index;3
account_invoice;account_invoice_partner_incharge_id_index;3
cpn_hr_employee_information_employee;cpn_hr_employee_information_employee_information_id_index;3
stock_picking;stock_picking_sale_id_index;4
account_payment_term;account_payment_term_pkey;4
cpn_account_hour;cpn_account_hour_migration_order_id_index;4
cpn_account_hour;cpn_account_hour_shop_id_index;5
sale_shop;sale_shop_pkey;6
account_invoice;account_invoice_avoir_invoice_id_index;6
account_invoice;account_invoice_facture_source_invoice_id_index;6
account_invoice_rel;account_invoice_rel_invoice2_id_index;6
sale_order;sale_order_assistant_employee_id_index;7
sale_order;sale_order_document_kind_id2_employee_id_index;7
sale_order;sale_order_employee_id_index;7
sale_order;sale_order_mad_employee_id_index;7
sale_order_assistant_isolations;sale_order_assistant_isolations_assistant_employee_id_index;7
cpn_hr_employee_holidays;cpn_hr_employee_holidays_employee_id2_index;7
cpn_account_hour_possible;cpn_account_hour_possible_order_id_index;7
cpn_hr_employee_holidays;cpn_hr_employee_holidays_kind_id_index;8
product_uom;product_uom_pkey;9
sale_order_line;sale_order_line_type;13
cpn_partner_ligne_aide;cpn_partner_ligne_aide_partner_id_index;17
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_name_index;21
cpn_account_hour_export;cpn_account_hour_export_rdv_id_index;25
res_partner_category_rel;res_partner_category_rel_category_id_index;26
cpn_account_hour;date_end_real_index;26
calevent_item;recurrence_no_end_index;27
sale_order;sale_order_shop_id_index;29
sale_order_line;sale_order_line_sale_type_int_index;31
ir_exports_line;ir_exports_line_export_id_index;32
cpn_account_money;cpn_account_money_payment_mode_id_index;32
cpn_hr_employee_circuit_additionalclause;cpn_hr_employee_circuit_additionalclause_circuit_id_index;46
cpn_sale_paragraphe;cpn_sale_paragraphe_document_kind_id_index;50
cpn_hr_employee_circuit_renewing;cpn_hr_employee_circuit_renewing_circuit_id_index;60
sale_order_line_invoice_rel;sale_order_line_invoice_rel_invoice_id_index;61
calevent_item;recurrence_end_date_index;63
cpn_account_hour_export;cpn_account_hour_export_holiday_id_index;65
sale_order_picking_rel;sale_order_picking_rel_order_id_index;83
sale_order_invoice_rel;sale_order_invoice_rel_order_id_index;83
cpn_hr_employee_consent;cpn_hr_employee_consent_pkey;84
cpn_hr_employee_appointment_employee;cpn_hr_employee_appointment_employee_appointment_id_index;87
cpn_hr_equipment_historique;cpn_hr_equipment_historique_pkey;90
res_partner;name_inde;92
cpn_account_hour_possible;cpn_account_hour_possible_qr_import_id_index;93
cpn_account_hour;cpn_account_hour_shop_id_inv_index;122
cpn_account_hour_possible;cpn_account_hour_possible_partner_id_index;124
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_pkey;127
res_partner;kind_index;135
cpn_hr_employee_consent;cpn_hr_employee_consent_employee_id_index;136
cpn_hr_employee_holidays;cpn_hr_employee_holidays_shop_id_index;144
cpn_account_money;cpn_account_money_shop_id_index;146
cpn_hr_employee_appointment;cpn_hr_employee_appointment_shop_id_index;191
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_shop_id_index;193
cpn_hr_employee;cpn_hr_employee_post_id2_index;195
stock_move;stock_move_product_id_index;222
res_partner_address;type_index;234
stock_move;stock_move_picking_id_index;252
sale_order_line;sale_order_line_partner_id_index;311
cpn_eval_note_line;cpn_eval_note_line_eval_id_index;317
cpn_account_hour_possible;cpn_account_hour_possible_employee_id_index;322
ir_ui_view_sc;ir_ui_view_sc_user_id_index;340
cpn_hr_employee_medical_visit;cpn_hr_employee_medical_visit_employee_id_index;377
cpn_hr_employee_circuit_renewing;cpn_hr_employee_circuit_renewing_post_id_index;381
cpn_parametre;cpn_parametre_user_id_index;397
cpn_hr_employee_circuit_additionalclause;cpn_hr_employee_circuit_additionalclause_post_id_index;406
cpn_hr_employee;cpn_hr_employee_state;415
cpn_partner_ligne_aide;cpn_partner_ligne_aide_pkey;448
cpn_hr_employee_formation;cpn_hr_employee_formation_employee_id_index;460
cpn_hr_employee_formation;cpn_hr_employee_formation_pkey;480
stock_picking;stock_picking_pkey;559
res_partner;res_partner_parent_id_index;630
stock_move;stock_move_pkey;686
sale_order_modifications;sale_order_modifications_order_id_index;737
account_invoice_tax;account_invoice_tax_pkey;820
res_request;res_request_pkey;891
cpn_hr_employee_circuit;cpn_hr_employee_circuit_post_id_index;995
ir_cron;ir_cron_pkey;1087
account_invoice;account_invoice_shop_id_index;1131
account_invoice;account_invoice_generation_index;1543
calevent_item;calevent_item_event_begin;1712
res_partner_organiz;res_partner_organiz_partner_id_index;1793
res_partner_category_rel;res_partner_category_rel_partner_id_index;1973
cpn_account_money;cpn_account_money_partner_id_index;2015
cpn_partner_diag_element;cpn_partner_diag_element_pkey;2172
stock_move;stock_move_location_dest_id_index;2262
calevent_item;calevent_item_date_premiere;2620
sale_order;sale_order_partner_shipping_id_index;2634
sale_order_line_employee;sale_order_line_employee_employee_id_index;2763
cpn_hr_employee_holidays;cpn_hr_employee_holidays_employee_id_index;2801
cpn_hr_employee_circuit;cpn_hr_employee_circuit_employee_id_index;2961
account_invoice_rel;account_invoice_rel_invoice_id_index;2996
calevent_item;calevent_item_event_end;3279
ir_model_data;ir_model_data_pkey;3411
cpn_hr_employee_experience;cpn_hr_employee_experience_employee_id_index;3537
res_request;res_request_act_from_index;3540
res_partner_event;res_partner_event_partner_id_index;3557
cpn_hr_employee_study;cpn_hr_employee_study_employee_id_index;3588
sale_order_assistant_isolations;sale_order_assistant_isolations_pkey;3670
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_employee_id_index;4039
cpn_hr_employee_affectation;cpn_hr_employee_affectation_employee_id_index;4143
res_request;res_request_act_to_index;4160
cpn_hr_employee_dispo;cpn_hr_employee_dispo_employee_id_index;4188
calevent_item;calevent_item_recurrence_exist;4499
cpn_account_hour_possible;cpn_account_hour_possible_sale_order_line_index;4571
cpn_hr_employee_contact;cpn_hr_employee_contact_partner_id_index;4865
sale_order_assistant_periodes;sale_order_assistant_periodes_pkey;5066
calevent_item;calevent_item_parent_id_index;5841
cpn_eval_contract;cpn_eval_contract_employee_id_index;6309
cpn_account_analyse_ligne;cpn_account_analyse_ligne_pkey;6417
cpn_hr_employee_study;cpn_hr_employee_study_pkey;7308
cpn_account_money;cpn_account_money_invoice_id_index;7614
wkf_triggers;wkf_triggers_instance_id_index;8641
calevent_item;calevent_item_liste_employes;9088
cpn_hr_employee_contact;cpn_hr_employee_contact_employee_id_index;10429
account_invoice_line;account_invoice_line_hour_id2_index;10480
account_invoice_line;account_invoice_line_hour_id_index;10480
cpn_account_hour;cpn_account_hour_zone_a_cheval_hour_id_index;10480
cpn_account_hour_possible;cpn_account_hour_possible_hour_id_index;10480
cpn_account_hour_export;cpn_account_hour_export_hour_id_index;10480
res_partner_address;res_partner_address_partner_id_index;11908
sale_order;sale_order_state;11966
sale_order_assistant_isolations;sale_order_assistant_isolations_order_id_index;12039
ir_values;ir_values_pkey;12046
cpn_hr_employee_circuit;cpn_hr_employee_circuit_order_id_index;12188
cpn_hr_employee_socialorganization_depending;cpn_hr_employee_socialorganization_depending_pkey;13386
stock_move;stock_move_sale_line_id_index;14519
sale_order_line_invoice_rel;sale_order_line_invoice_rel_order_line_id_index;14540
sale_order_line;sale_order_line_product_id_index;17353
sale_order_infos;sale_order_infos_order_id_index;18456
sale_order_line;sale_order_line_state;18568
cpn_account_hour_export;cpn_account_hour_export_pkey;19439
cpn_eval_contract;cpn_eval_contract_pkey;19812
cpn_hr_employee_letter;cpn_hr_employee_letter_employee_id_index;26018
account_invoice_generation;account_invoice_generation_pkey;27460
sale_order_assistant_periodes;sale_order_assistant_periodes_order_id_index;28046
sale_order;sale_order_partner_id_index;28797
cpn_account_hour_possible;cpn_account_hour_possible_pkey;30032
cpn_hr_employee_appointment;cpn_hr_employee_appointment_employee_id_index;32385
sale_order_invoice_rel;sale_order_invoice_rel_invoice_id_index;32945
cpn_account_money;cpn_account_money_order_id_index;41185
sale_order_infos;sale_order_infos_pkey;42180
cpn_hr_employee_affectation;cpn_hr_employee_affectation_pkey;43396
cpn_account_hour;cpn_account_hour_sale_order_line_employee_index;43722
cpn_account_hour_possible;cpn_account_hour_possible_sale_order_line_employee_index;43722
ir_translation;ir_translation_res_id;45168
cpn_account_money;cpn_account_money_pkey;45837
cpn_hr_employee_experience;cpn_hr_employee_experience_pkey;49371
cpn_account_hour;cpn_account_hour_calevent_item_id_index;51491
cpn_account_hour;date_start_real_index;54323
sale_order_modifications;sale_order_modifications_pkey;54759
ir_ui_view;ir_ui_view_pkey;55213
cpn_hr_employee_dispo;cpn_hr_employee_dispo_pkey;55424
cpn_account_hour;date_end_index;60630
cpn_account_hour;state_index;62961
cpn_account_qr_import;cpn_account_qr_import_pkey;65529
cpn_hr_employee;cpn_hr_employee_name;66932
res_partner_event;res_partner_event_pkey;71112
cpn_hr_employee_information_employee;cpn_hr_employee_information_employee_employee_id_index;72088
account_account;account_account_pkey;74704
cpn_account_hour;cpn_account_hour_employee_id_index;74791
wkf_triggers;wkf_triggers_workitem_id_index;86219
cpn_hr_employee_letter;cpn_hr_employee_letter_pkey;93248
cpn_hr_employee_phone;cpn_hr_employee_phone_pkey;102950
account_invoice_line_tax;account_invoice_line_tax_invoice_line_id_index;105736
cpn_account_hour;cpn_account_hour_partner_id_index;106857
cpn_account_hour;date_start_index;129734
calevent_item;heure_fin_index;150317
cpn_account_hour;cpn_account_hour_order_id_index;164786
res_partner_organiz;res_partner_organiz_pkey;170428
cpn_hr_employee_circuit;cpn_hr_employee_circuit_pkey;180111
cpn_hr_employee_phone;cpn_hr_employee_phone_employee_id_index;186318
account_invoice;account_invoice_partner_id_index;199540
calevent_item;heure_debut_index;225874
cpn_account_hour;cpn_account_hour_sale_order_line_index;338429
account_invoice_tax;account_invoice_tax_invoice_id_index;340292
wkf_workitem;wkf_workitem_pkey;348962
cpn_hr_employee_circuit;cpn_hr_employee_circuit_shop_id_index;352336
account_invoice_line;account_invoice_line_invoice_id_index;356111
cpn_account_qr_export;cpn_account_qr_export_pkey;359738
cpn_hr_employee_appointment;cpn_hr_employee_appointment_pkey;362713
sale_order_line;sale_order_line_order_id_index;366743
calevent_item;order_id_index;415462
cpn_hr_employee_contact;cpn_hr_employee_contact_pkey;423060
wkf_workitem;wkf_workitem_inst_id_index;445139
account_invoice_line;account_invoice_line_pkey;473235
wkf_instance;wkf_instance_pkey;503242
wkf_instance;wkf_instance_res_type_index;541471
mrp_procurement;mrp_procurement_pkey;558279
sale_order_line_employee;sale_order_line_employee_order_line_id_index;760893
calevent_item;order_line_id_index;1074707
wkf_instance;wkf_instance_res_id_index;1831695
account_invoice;account_invoice_pkey;2590469
cpn_hr_employee_holidays;cpn_hr_employee_holidays_pkey;2752724
res_partner;res_partner_pkey;3016064
sale_order_line_employee;sale_order_line_employee_pkey;3127230
res_partner_address;res_partner_address_pkey;3292980
cpn_hr_employee;cpn_hr_employee_pkey;3865725
cpn_account_hour;cpn_account_hour_pkey;4601822
sale_order_tax;sale_order_tax_order_line_id_index;4654481
sale_order;sale_order_pkey;6640536
calevent_resources;calevent_resources_calevent_item_id_index;7148394
cpn_hr_employee_appointment;cpn_hr_employee_appointment_order_line_id_index;7619148
calevent_resources;calevent_resources_res_model_index;11962939
calevent_resources;calevent_resources_res_id_index;12504484
ir_translation;ir_translation_ltn;13453513
calevent_resources;calevent_resources_pkey;20660655
calevent_item;calevent_item_pkey;25750256
sale_order_line;sale_order_line_pkey;33818998
Hors ligne
Oui c'est depuis le début.(je crois)
L'erp c'est une appli maison ? ou un mélange entre une appli "connue" et des modifications maison ?
Dernière modification par kenrio (21/08/2012 10:20:49)
Hors ligne
Il existe la fonction "pg_stat_reset()" permettant de remettre à 0 les statistiques, mais je ne crois pas qu'il soit possible d'accéder à cette date en version 8.1.
Julien.
https://rjuju.github.io/
Hors ligne
