pgCluu :: Example

Unused Indexes on dolibarr database

List of indexes never used (idx_scan to 0)

Shema	Table	Index	Code
public	llx_accountingaccount	idx_accountingaccount_fk_pcg_version	CREATE INDEX idx_accountingaccount_fk_pcg_version ON llx_accountingaccount USING btree (fk_pcg_version)
public	llx_actioncomm	idx_actioncomm_datea	CREATE INDEX idx_actioncomm_datea ON llx_actioncomm USING btree (datea)
public	llx_actioncomm_extrafields	idx_actioncomm_extrafields	CREATE INDEX idx_actioncomm_extrafields ON llx_actioncomm_extrafields USING btree (fk_object)
public	llx_adherent	idx_adherent_fk_adherent_type	CREATE INDEX idx_adherent_fk_adherent_type ON llx_adherent USING btree (fk_adherent_type)
public	llx_adherent_extrafields	idx_adherent_options	CREATE INDEX idx_adherent_options ON llx_adherent_extrafields USING btree (fk_object)
public	llx_adherent_type_extrafields	idx_adherent_type_extrafields	CREATE INDEX idx_adherent_type_extrafields ON llx_adherent_type_extrafields USING btree (fk_object)
public	llx_agefodd_contact	idx_agefodd_contact_fk_socpeople	CREATE INDEX idx_agefodd_contact_fk_socpeople ON llx_agefodd_contact USING btree (fk_socpeople)
public	llx_agefodd_convention	idx_fk_agefodd_session_conv	CREATE INDEX idx_fk_agefodd_session_conv ON llx_agefodd_convention USING btree (fk_agefodd_session)
public	llx_agefodd_facture	idx_fk_societe_fac	CREATE INDEX idx_fk_societe_fac ON llx_agefodd_facture USING btree (fk_societe)
public	llx_agefodd_formateur	idx_agefodd_formateur_fk_socpeople	CREATE INDEX idx_agefodd_formateur_fk_socpeople ON llx_agefodd_formateur USING btree (fk_socpeople)
public	llx_agefodd_formateur	idx_agefodd_formateur_fk_user	CREATE INDEX idx_agefodd_formateur_fk_user ON llx_agefodd_formateur USING btree (fk_user)
public	llx_agefodd_formation_catalogue_extrafields	idx_agefodd_formation_catalogue_extrafields	CREATE INDEX idx_agefodd_formation_catalogue_extrafields ON llx_agefodd_formation_catalogue_extrafields USING btree (fk_object)
public	llx_agefodd_formation_objectifs_peda	fk_formation_catalogue_obj_peda	CREATE INDEX fk_formation_catalogue_obj_peda ON llx_agefodd_formation_objectifs_peda USING btree (fk_formation_catalogue)
public	llx_agefodd_place	archive_place	CREATE INDEX archive_place ON llx_agefodd_place USING btree (archive)
public	llx_agefodd_session_contact	fk_session_sess_contact	CREATE INDEX fk_session_sess_contact ON llx_agefodd_session_contact USING btree (fk_session_agefodd)
public	llx_agefodd_session_extrafields	idx_agefodd_session_extrafields	CREATE INDEX idx_agefodd_session_extrafields ON llx_agefodd_session_extrafields USING btree (fk_object)
public	llx_agefodd_session_formateur	idx_fk_agefodd_sess_formateur	CREATE INDEX idx_fk_agefodd_sess_formateur ON llx_agefodd_session_formateur USING btree (fk_agefodd_formateur)
public	llx_agefodd_session_stagiaire	fk_agefodd_stagiaire_type_sess_sta	CREATE INDEX fk_agefodd_stagiaire_type_sess_sta ON llx_agefodd_session_stagiaire USING btree (fk_agefodd_stagiaire_type)
public	llx_agefodd_stagiaire	nom_sta	CREATE INDEX nom_sta ON llx_agefodd_stagiaire USING btree (nom)
public	llx_agefodd_training_admlevel	fk_agefodd_training_admlevel	CREATE INDEX fk_agefodd_training_admlevel ON llx_agefodd_training_admlevel USING btree (fk_training)
public	llx_bank	idx_bank_datev	CREATE INDEX idx_bank_datev ON llx_bank USING btree (datev)
public	llx_boxes	idx_boxes_boxid	CREATE INDEX idx_boxes_boxid ON llx_boxes USING btree (box_id)
public	llx_boxes	idx_boxes_fk_user	CREATE INDEX idx_boxes_fk_user ON llx_boxes USING btree (fk_user)
public	llx_c_action_trigger	idx_action_trigger_rang	CREATE INDEX idx_action_trigger_rang ON llx_c_action_trigger USING btree (rang)
public	llx_c_ziptown	idx_c_ziptown_fk_county	CREATE INDEX idx_c_ziptown_fk_county ON llx_c_ziptown USING btree (fk_county)
public	llx_categorie	idx_categorie_label	CREATE INDEX idx_categorie_label ON llx_categorie USING btree (label)
public	llx_categorie	idx_categorie_type	CREATE INDEX idx_categorie_type ON llx_categorie USING btree (type)
public	llx_categorie_fournisseur	idx_categorie_fournisseur_fk_categorie	CREATE INDEX idx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur USING btree (fk_categorie)
public	llx_categorie_fournisseur	idx_categorie_fournisseur_fk_societe	CREATE INDEX idx_categorie_fournisseur_fk_societe ON llx_categorie_fournisseur USING btree (fk_societe)
public	llx_categorie_member	idx_categorie_member_fk_categorie	CREATE INDEX idx_categorie_member_fk_categorie ON llx_categorie_member USING btree (fk_categorie)
public	llx_categorie_member	idx_categorie_member_fk_member	CREATE INDEX idx_categorie_member_fk_member ON llx_categorie_member USING btree (fk_member)
public	llx_categorie_product	idx_categorie_product_fk_categorie	CREATE INDEX idx_categorie_product_fk_categorie ON llx_categorie_product USING btree (fk_categorie)
public	llx_categorie_product	idx_categorie_product_fk_product	CREATE INDEX idx_categorie_product_fk_product ON llx_categorie_product USING btree (fk_product)
public	llx_categorie_societe	idx_categorie_societe_fk_categorie	CREATE INDEX idx_categorie_societe_fk_categorie ON llx_categorie_societe USING btree (fk_categorie)
public	llx_categorie_societe	idx_categorie_societe_fk_societe	CREATE INDEX idx_categorie_societe_fk_societe ON llx_categorie_societe USING btree (fk_societe)
public	llx_commande	idx_commande_fk_account	CREATE INDEX idx_commande_fk_account ON llx_commande USING btree (fk_account)
public	llx_commande	idx_commande_fk_currency	CREATE INDEX idx_commande_fk_currency ON llx_commande USING btree (fk_currency)
public	llx_commande	idx_commande_fk_projet	CREATE INDEX idx_commande_fk_projet ON llx_commande USING btree (fk_projet)
public	llx_commande	idx_commande_fk_user_author	CREATE INDEX idx_commande_fk_user_author ON llx_commande USING btree (fk_user_author)
public	llx_commande	idx_commande_fk_user_cloture	CREATE INDEX idx_commande_fk_user_cloture ON llx_commande USING btree (fk_user_cloture)
public	llx_commande	idx_commande_fk_user_valid	CREATE INDEX idx_commande_fk_user_valid ON llx_commande USING btree (fk_user_valid)
public	llx_commande_extrafields	idx_commande_extrafields	CREATE INDEX idx_commande_extrafields ON llx_commande_extrafields USING btree (fk_object)
public	llx_commande_fournisseur	idx_commande_fournisseur_fk_soc	CREATE INDEX idx_commande_fournisseur_fk_soc ON llx_commande_fournisseur USING btree (fk_soc)
public	llx_commande_fournisseur_dispatch	idx_commande_fournisseur_dispatch_fk_commande	CREATE INDEX idx_commande_fournisseur_dispatch_fk_commande ON llx_commande_fournisseur_dispatch USING btree (fk_commande)
public	llx_commande_fournisseur_extrafields	idx_commande_fournisseur_extrafields	CREATE INDEX idx_commande_fournisseur_extrafields ON llx_commande_fournisseur_extrafields USING btree (fk_object)
public	llx_contrat	idx_contrat_fk_soc	CREATE INDEX idx_contrat_fk_soc ON llx_contrat USING btree (fk_soc)
public	llx_contrat	idx_contrat_fk_user_author	CREATE INDEX idx_contrat_fk_user_author ON llx_contrat USING btree (fk_user_author)
public	llx_contratdet	idx_contratdet_date_fin_validite	CREATE INDEX idx_contratdet_date_fin_validite ON llx_contratdet USING btree (date_fin_validite)
public	llx_contratdet	idx_contratdet_date_ouverture	CREATE INDEX idx_contratdet_date_ouverture ON llx_contratdet USING btree (date_ouverture)
public	llx_contratdet	idx_contratdet_date_ouverture_prevue	CREATE INDEX idx_contratdet_date_ouverture_prevue ON llx_contratdet USING btree (date_ouverture_prevue)
public	llx_contratdet	idx_contratdet_fk_contrat	CREATE INDEX idx_contratdet_fk_contrat ON llx_contratdet USING btree (fk_contrat)
public	llx_contratdet	idx_contratdet_fk_product	CREATE INDEX idx_contratdet_fk_product ON llx_contratdet USING btree (fk_product)
public	llx_contratdet_log	idx_contratdet_log_date	CREATE INDEX idx_contratdet_log_date ON llx_contratdet_log USING btree (date)
public	llx_contratdet_log	idx_contratdet_log_fk_contratdet	CREATE INDEX idx_contratdet_log_fk_contratdet ON llx_contratdet_log USING btree (fk_contratdet)
public	llx_ecm_directories	idx_ecm_directories_fk_user_c	CREATE INDEX idx_ecm_directories_fk_user_c ON llx_ecm_directories USING btree (fk_user_c)
public	llx_ecm_directories	idx_ecm_directories_fk_user_m	CREATE INDEX idx_ecm_directories_fk_user_m ON llx_ecm_directories USING btree (fk_user_m)
public	llx_element_contact	fk_element_contact_fk_c_type_contact	CREATE INDEX fk_element_contact_fk_c_type_contact ON llx_element_contact USING btree (fk_c_type_contact)
public	llx_events	idx_events_dateevent	CREATE INDEX idx_events_dateevent ON llx_events USING btree (dateevent)
public	llx_expedition	idx_expedition_fk_shipping_method	CREATE INDEX idx_expedition_fk_shipping_method ON llx_expedition USING btree (fk_shipping_method)
public	llx_expedition	idx_expedition_fk_soc	CREATE INDEX idx_expedition_fk_soc ON llx_expedition USING btree (fk_soc)
public	llx_expedition	idx_expedition_fk_user_author	CREATE INDEX idx_expedition_fk_user_author ON llx_expedition USING btree (fk_user_author)
public	llx_expedition	idx_expedition_fk_user_valid	CREATE INDEX idx_expedition_fk_user_valid ON llx_expedition USING btree (fk_user_valid)
public	llx_expeditiondet	idx_expeditiondet_fk_expedition	CREATE INDEX idx_expeditiondet_fk_expedition ON llx_expeditiondet USING btree (fk_expedition)
public	llx_facture	idx_facture_fk_account	CREATE INDEX idx_facture_fk_account ON llx_facture USING btree (fk_account)
public	llx_facture	idx_facture_fk_user_author	CREATE INDEX idx_facture_fk_user_author ON llx_facture USING btree (fk_user_author)
public	llx_facture_extrafields	idx_facture_extrafields	CREATE INDEX idx_facture_extrafields ON llx_facture_extrafields USING btree (fk_object)
public	llx_facture_fourn	idx_facture_fourn_date_lim_reglement	CREATE INDEX idx_facture_fourn_date_lim_reglement ON llx_facture_fourn USING btree (date_lim_reglement)
public	llx_facture_fourn	idx_facture_fourn_fk_user_valid	CREATE INDEX idx_facture_fourn_fk_user_valid ON llx_facture_fourn USING btree (fk_user_valid)
public	llx_facture_rec	idx_facture_rec_fk_projet	CREATE INDEX idx_facture_rec_fk_projet ON llx_facture_rec USING btree (fk_projet)
public	llx_facture_rec	idx_facture_rec_fk_soc	CREATE INDEX idx_facture_rec_fk_soc ON llx_facture_rec USING btree (fk_soc)
public	llx_facture_rec	idx_facture_rec_fk_user_author	CREATE INDEX idx_facture_rec_fk_user_author ON llx_facture_rec USING btree (fk_user_author)
public	llx_fichinter	idx_fichinter_fk_soc	CREATE INDEX idx_fichinter_fk_soc ON llx_fichinter USING btree (fk_soc)
public	llx_fichinterdet	idx_fichinterdet_fk_fichinter	CREATE INDEX idx_fichinterdet_fk_fichinter ON llx_fichinterdet USING btree (fk_fichinter)
public	llx_holiday	idx_holiday_date_debut	CREATE INDEX idx_holiday_date_debut ON llx_holiday USING btree (date_debut)
public	llx_holiday	idx_holiday_date_fin	CREATE INDEX idx_holiday_date_fin ON llx_holiday USING btree (date_fin)
public	llx_livraison	idx_livraison_fk_soc	CREATE INDEX idx_livraison_fk_soc ON llx_livraison USING btree (fk_soc)
public	llx_livraison	idx_livraison_fk_user_author	CREATE INDEX idx_livraison_fk_user_author ON llx_livraison USING btree (fk_user_author)
public	llx_livraison	idx_livraison_fk_user_valid	CREATE INDEX idx_livraison_fk_user_valid ON llx_livraison USING btree (fk_user_valid)
public	llx_livraisondet	idx_livraisondet_fk_expedition	CREATE INDEX idx_livraisondet_fk_expedition ON llx_livraisondet USING btree (fk_livraison)
public	llx_mailing_cibles	idx_mailing_cibles_email	CREATE INDEX idx_mailing_cibles_email ON llx_mailing_cibles USING btree (email)
public	llx_menu	idx_menu_menuhandler_type	CREATE INDEX idx_menu_menuhandler_type ON llx_menu USING btree (menu_handler. type)
public	llx_opensurvey_comments	idx_id_comment	CREATE INDEX idx_id_comment ON llx_opensurvey_comments USING btree (id_comment)
public	llx_opensurvey_comments	idx_id_sondage	CREATE INDEX idx_id_sondage ON llx_opensurvey_comments USING btree (id_sondage)
public	llx_opensurvey_sondage	idx_date_fin	CREATE INDEX idx_date_fin ON llx_opensurvey_sondage USING btree (date_fin)
public	llx_opensurvey_sondage	idx_id_sondage_admin	CREATE INDEX idx_id_sondage_admin ON llx_opensurvey_sondage USING btree (id_sondage_admin)
public	llx_opensurvey_user_studs	idx_opensurvey_user_studs_id_sondage	CREATE INDEX idx_opensurvey_user_studs_id_sondage ON llx_opensurvey_user_studs USING btree (id_sondage)
public	llx_opensurvey_user_studs	idx_opensurvey_user_studs_id_users	CREATE INDEX idx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs USING btree (id_users)
public	llx_opensurvey_user_studs	idx_opensurvey_user_studs_nom	CREATE INDEX idx_opensurvey_user_studs_nom ON llx_opensurvey_user_studs USING btree (nom)
public	llx_paiementfourn_facturefourn	idx_paiementfourn_facturefourn_fk_paiement	CREATE INDEX idx_paiementfourn_facturefourn_fk_paiement ON llx_paiementfourn_facturefourn USING btree (fk_paiementfourn)
public	llx_prelevement_facture	idx_prelevement_facture_fk_prelevement_lignes	CREATE INDEX idx_prelevement_facture_fk_prelevement_lignes ON llx_prelevement_facture USING btree (fk_prelevement_lignes)
public	llx_prelevement_lignes	idx_prelevement_lignes_fk_prelevement_bons	CREATE INDEX idx_prelevement_lignes_fk_prelevement_bons ON llx_prelevement_lignes USING btree (fk_prelevement_bons)
public	llx_product	idx_product_barcode	CREATE INDEX idx_product_barcode ON llx_product USING btree (barcode)
public	llx_product	idx_product_import_key	CREATE INDEX idx_product_import_key ON llx_product USING btree (import_key)
public	llx_product	idx_product_label	CREATE INDEX idx_product_label ON llx_product USING btree (label)
public	llx_product_association	idx_product_association_fils	CREATE INDEX idx_product_association_fils ON llx_product_association USING btree (fk_product_fils)
public	llx_product_extrafields	idx_product_extrafields	CREATE INDEX idx_product_extrafields ON llx_product_extrafields USING btree (fk_object)
public	llx_product_fournisseur_price	idx_product_fourn_price_fk_product	CREATE INDEX idx_product_fourn_price_fk_product ON llx_product_fournisseur_price USING btree (fk_product. entity)
public	llx_product_fournisseur_price	idx_product_fourn_price_fk_soc	CREATE INDEX idx_product_fourn_price_fk_soc ON llx_product_fournisseur_price USING btree (fk_soc. entity)
public	llx_product_fournisseur_price	idx_product_fournisseur_price_fk_user	CREATE INDEX idx_product_fournisseur_price_fk_user ON llx_product_fournisseur_price USING btree (fk_user)
public	llx_product_price_by_qty	idx_product_price_by_qty_fk_product_price	CREATE INDEX idx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty USING btree (fk_product_price)
public	llx_product_stock	idx_product_stock_fk_entrepot	CREATE INDEX idx_product_stock_fk_entrepot ON llx_product_stock USING btree (fk_entrepot)
public	llx_product_stock	idx_product_stock_fk_product	CREATE INDEX idx_product_stock_fk_product ON llx_product_stock USING btree (fk_product)
public	llx_projet	idx_projet_fk_soc	CREATE INDEX idx_projet_fk_soc ON llx_projet USING btree (fk_soc)
public	llx_projet_extrafields	idx_projet_extrafields	CREATE INDEX idx_projet_extrafields ON llx_projet_extrafields USING btree (fk_object)
public	llx_projet_task	idx_projet_task_fk_projet	CREATE INDEX idx_projet_task_fk_projet ON llx_projet_task USING btree (fk_projet)
public	llx_projet_task	idx_projet_task_fk_user_creat	CREATE INDEX idx_projet_task_fk_user_creat ON llx_projet_task USING btree (fk_user_creat)
public	llx_projet_task	idx_projet_task_fk_user_valid	CREATE INDEX idx_projet_task_fk_user_valid ON llx_projet_task USING btree (fk_user_valid)
public	llx_projet_task_extrafields	idx_projet_task_extrafields	CREATE INDEX idx_projet_task_extrafields ON llx_projet_task_extrafields USING btree (fk_object)
public	llx_propal	idx_propal_fk_account	CREATE INDEX idx_propal_fk_account ON llx_propal USING btree (fk_account)
public	llx_propal	idx_propal_fk_user_author	CREATE INDEX idx_propal_fk_user_author ON llx_propal USING btree (fk_user_author)
public	llx_propal	idx_propal_fk_user_cloture	CREATE INDEX idx_propal_fk_user_cloture ON llx_propal USING btree (fk_user_cloture)
public	llx_propal	idx_propal_fk_user_valid	CREATE INDEX idx_propal_fk_user_valid ON llx_propal USING btree (fk_user_valid)
public	llx_societe	idx_societe_user_creat	CREATE INDEX idx_societe_user_creat ON llx_societe USING btree (fk_user_creat)
public	llx_societe	idx_societe_user_modif	CREATE INDEX idx_societe_user_modif ON llx_societe USING btree (fk_user_modif)
public	llx_societe_extrafields	idx_societe_extrafields	CREATE INDEX idx_societe_extrafields ON llx_societe_extrafields USING btree (fk_object)
public	llx_societe_remise_except	idx_societe_remise_except_fk_user	CREATE INDEX idx_societe_remise_except_fk_user ON llx_societe_remise_except USING btree (fk_user)
public	llx_socpeople	idx_socpeople_fk_user_creat	CREATE INDEX idx_socpeople_fk_user_creat ON llx_socpeople USING btree (fk_user_creat)
public	llx_socpeople_extrafields	idx_socpeople_extrafields	CREATE INDEX idx_socpeople_extrafields ON llx_socpeople_extrafields USING btree (fk_object)
public	llx_stock_mouvement	idx_stock_mouvement_fk_entrepot	CREATE INDEX idx_stock_mouvement_fk_entrepot ON llx_stock_mouvement USING btree (fk_entrepot)
public	llx_stock_mouvement	idx_stock_mouvement_fk_product	CREATE INDEX idx_stock_mouvement_fk_product ON llx_stock_mouvement USING btree (fk_product)
public	llx_user	uk_user_fk_societe	CREATE INDEX uk_user_fk_societe ON llx_user USING btree (fk_societe)
public	llx_user_extrafields	idx_user_extrafields	CREATE INDEX idx_user_extrafields ON llx_user_extrafields USING btree (fk_object)
public	llx_usergroup_user	fk_usergroup_user_fk_user	CREATE INDEX fk_usergroup_user_fk_user ON llx_usergroup_user USING btree (fk_user)
public	llx_usergroup_user	fk_usergroup_user_fk_usergroup	CREATE INDEX fk_usergroup_user_fk_usergroup ON llx_usergroup_user USING btree (fk_usergroup)