Forums PostgreSQL.fr

merci je vais essayer.

merci de votre réponse rapide.
donc je dois tester debian 5 alors. comment en être certain ?

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

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).

non l'autovacum a été désactivé car en journée, il nuit fortement à la base et ralenti le travail des collègues. c'est pour ça que je le programme la nuit, (où le fait moi-même à la mi journée)

merci de votre conseil.
en fait une fois la base de données vacummée manuellement à 100% et réindexées totalement elle ne prend que 120Mo.
par contre en fin de journée elle atteind le 1.2Go de données (beaucoup de choses sont supprimées, puis remis à jour).

re-bonjour,

voilà j'ai testé la version 8.2 installée hors vm (donc soux Win7 x64). Les résultats sont bien meilleur : je passe de 16s à moins d'une seconde  pour cette grosse requête. J'ai aussi testé d'autres traitements et on gagne encore plus, surtout dans les recherches.
Pour ceux que ça intéresse, je place là-bas un tab récapitluatif (non terminé) : http://www.michael-remy.fr/forum/postgr … rmance.jpg

Il me reste encore à tester sur le portable SSD et il faudrait que je trouve aussi un moyen de réinstaller un linux etch4 avec pg8.2 mais c'est pas gagné pour ce dernier cas.

Pour infos, en téléchargeant pg8.2 sur le site officiel, il est indiqué que la version Windows est encore maintenant de la 8.2 (mais plus les autres plateformes). Enfin c'est ce que je comprends de cette phrase : "Note: Only PostgreSQL 8.2 and above are supported on Windows."

bonjour,

je reviens ici car depuis, la base a augmenté et les temps de réponses aussi hélas...
j'ai fait quelques tests et prises d'informations.

situation 0 : sur le vieux système non virtualisé  (2x xeon 5130 2 Go RAM HD scsi), la grosse requête prend maintenant 32s.
situation 1 : sur une workstation i7-975 2Go HD sata (virtualisé), la grosse requête prend 15s
situation 2 : sur un portable très récent i7 2640M (208Ghz) + SSD (toujours virtualisé) prend 14s

Sachat qu'il n'y a pas de matériel deux fois plus rapide que celui en situation 1, je commence à me faire des soucis !

En situation 0, la config de pg a été amélioré mais sans miracle.
En situation 1 et 2 : c'est la confif de base (d'installation)

Dans les trois situations, le cpu tourne à 95-100% et seulement 5-10% de ram utilisée seulement ! La base de fait que 150Mo. LA table ne compte que 30000 enregistrement et la requête en sort que 127.

où est le problème ? où est le fameux paramètre à changer ?  quel est le goulot d'étranglement ?

merci de votre aide.

ps: j'ai refait un explain analyse sur la situation 1 :

"Limit  (cost=22272.92..22273.17 rows=101 width=4) (actual time=40.590..40.621 rows=84 loops=1)"
"  ->  Sort  (cost=22272.92..22273.29 rows=149 width=4) (actual time=40.589..40.602 rows=84 loops=1)"
"        Sort Key: id"
"        ->  Bitmap Heap Scan on sale_order_line  (cost=3262.10..22267.54 rows=149 width=4) (actual time=4.669..40.470 rows=84 loops=1)"
"              Recheck Cond: ((((state)::text = 'confirmed'::text) OR ((state)::text = 'confirmed_wait'::text) OR ((state)::text = 'manquant'::text)) AND ((id = 17735) OR (id = 34489) OR (id = 36602) OR (id = 36671) OR (id = 17718) OR (id = 30733) OR (id =  (..)"
"              Filter: ((id = 7841) OR (id = 18141) OR (id = 13652) OR (id = 13651) OR (id = 13650) OR (id = 13597) OR (id = 13521) OR (id = 20416) OR (id = 33657) OR (id = 32359) OR (id = 32358) OR (id = 24557) OR (id = 32441) OR (id = 24556) OR (id = 2455 (..)"
"              ->  BitmapAnd  (cost=3262.10..3262.10 rows=277 width=0) (actual time=3.799..3.799 rows=0 loops=1)"
"                    ->  BitmapOr  (cost=46.23..46.23 rows=5207 width=0) (actual time=0.939..0.939 rows=0 loops=1)"
"                          ->  Bitmap Index Scan on sale_order_line_state  (cost=0.00..40.24 rows=4925 width=0) (actual time=0.868..0.868 rows=4895 loops=1)"
"                                Index Cond: ((state)::text = 'confirmed'::text)"
"                          ->  Bitmap Index Scan on sale_order_line_state  (cost=0.00..2.00 rows=1 width=0) (actual time=0.016..0.016 rows=0 loops=1)"
"                                Index Cond: ((state)::text = 'confirmed_wait'::text)"
"                          ->  Bitmap Index Scan on sale_order_line_state  (cost=0.00..3.99 rows=282 width=0) (actual time=0.055..0.055 rows=260 loops=1)"
"                                Index Cond: ((state)::text = 'manquant'::text)"
"                    ->  BitmapOr  (cost=3215.62..3215.62 rows=1605 width=0) (actual time=2.658..2.658 rows=0 loops=1)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=1)"
"                                Index Cond: (id = 17735)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1)"
"                                Index Cond: (id = 34489)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=1)"
"                                Index Cond: (id = 36602)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)"
"                                Index Cond: (id = 36671)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)"
"                                Index Cond: (id = 17718)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=1)"
"                                Index Cond: (id = 30733)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=1)"
"                                Index Cond: (id = 18491)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)"
"                                Index Cond: (id = 31810)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)"
"                                Index Cond: (id = 6221)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.001..0.001 rows=0 loops=1)"
"                                Index Cond: (id = 37533)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)"
"                                Index Cond: (id = 35502)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=1)"
"                                Index Cond: (id = 38551)"
"                          ->  Bitmap Index Scan on sale_order_line_pkey  (cost=0.00..2.00 rows=1 width=0) (actual time=0.001..0.001 rows=1 loops=1)"
"                                Index Cond: (id = 38550)"

...etc

"Total runtime: 61.115 ms"

nous sommes d'accord : il aurait û le demander à l'utilisateur.

en fait, je suis un peu agacé car sur une machine linux où je l'ai installé 1000fois, il n'y a pas ce problème (brêche ouverte car pas de firewall logiciel installé par défaut) donc je suis rentré dans le mur avec mon installation sous windows....

j'ai aussi résolu (par hasard) ce souci;

en fait j'ai essayé un mot de passe compliqué genre 12AZQSWXZEDXS, l'installeur refusait
ensuite j'ai essayé le mot de passe classique de pg 'postgres' aucas où...et ça marchait pas
ensuite par agcement j'ai essayé n'importe quoi soit 'hh' et bingo ça a marché !

en fait, après des recherches sur des forum US, il semblerait que l'installeur a un problème de "rigueur" dans la véracité du tst du mot de passe. je ne suis pas seul à avoir eu ce souci.