pgCluu
  • Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilisation
      • Database in shared buffers
      • Usagecount in shared buffers
      • Usagecount in dirty buffers
    • Background writer
      • Background writer buffers
      • Background writer counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Checkpoints counter
      • Checkpoints write time
      • Archiver stats
    • Queries Reads / Writes
      • Read tuples
      • Write ratio
      • Read vs Write queries
      • Commits vs Rollbacks
    • Replication statistics
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • dolibarr
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Redundant indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • mantis
      • Database info
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • Insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • Unused Indexes
        • Missing indexes
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
    • opm
      • Database info
      • Indexes statistics
      • Buffercache Statistics
        • Buffercache per relation
        • Buffer I/O per relation
      • Statements statistics
      • Database size
      • Connections
        • Connections
        • Connections by type
      • Cache utilization
      • Locks
        • Deadlocks
        • Locks per types
        • Locks per modes
        • Locks granted or not
      • Temporary files
        • Temporary files
        • Temporary files size
      • Queries Reads / Writes
        • Read tuples
        • Write ratio
        • Read vs Write queries
        • Commits vs Rollbacks
      • Canceled queries
      • Conflicts
  • pgBouncer
    • dolibarr
      • Clients / servers connections
      • Average queries duration
      • Queries per second
  • System
    • Cpu
    • Memory
    • Swap
    • Load
    • Process
    • Run queue
    • Blocks
    • Pages
    • Devices
      • sda
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • sdb
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji2
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji3
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji4
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji5
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji6
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji7
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • pdc_bhcccjdji8
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
      • cryptswap1
        • Cpu utilization
        • Read/write bytes per second
        • Average service time
    • Network
      • lo
        • Network utilization
        • Network errors
      • eth0
        • Network utilization
        • Network errors
  • About

    Missing indexes on dolibarr database

    List of DDL to create missing indexes on foreign keys.

    Table Missing index
    llx_prelevement_factureCREATE INDEX idx_llx_prelevement_facture_fk_prelevement_lignes ON llx_prelevement_facture (fk_prelevement_lignes)
    llx_actioncomm_extrafieldsCREATE INDEX idx_llx_actioncomm_extrafields_rowid ON llx_actioncomm_extrafields (rowid)
    llx_stock_mouvementCREATE INDEX idx_llx_stock_mouvement_rowid ON llx_stock_mouvement (rowid)
    llx_notifyCREATE INDEX idx_llx_notify_rowid ON llx_notify (rowid)
    llx_contratdet_logCREATE INDEX idx_llx_contratdet_log_rowid ON llx_contratdet_log (rowid)
    llx_contratdetCREATE INDEX idx_llx_contratdet_rowid ON llx_contratdet (rowid)
    llx_agefodd_sessionCREATE INDEX idx_llx_agefodd_session_fk_formation_catalogue ON llx_agefodd_session (fk_formation_catalogue)
    llx_agefodd_formation_catalogue_extrafieldsCREATE INDEX idx_llx_agefodd_formation_catalogue_extrafields_rowid ON llx_agefodd_formation_catalogue_extrafields (rowid)
    llx_mailingCREATE INDEX idx_llx_mailing_rowid ON llx_mailing (rowid)
    llx_textsCREATE INDEX idx_llx_texts_rowid ON llx_texts (rowid)
    llx_agefodd_session_contactCREATE INDEX idx_llx_agefodd_session_contact_rowid ON llx_agefodd_session_contact (rowid)
    llx_expeditionCREATE INDEX idx_llx_expedition_fk_shipping_method ON llx_expedition (fk_shipping_method)
    llx_paiement_factureCREATE INDEX idx_llx_paiement_facture_fk_facture ON llx_paiement_facture (fk_facture)
    llx_product_fournisseur_priceCREATE INDEX idx_llx_product_fournisseur_price_rowid ON llx_product_fournisseur_price (rowid)
    llx_accountingaccountCREATE INDEX idx_llx_accountingaccount_fk_pcg_version ON llx_accountingaccount (fk_pcg_version)
    llx_projet_extrafieldsCREATE INDEX idx_llx_projet_extrafields_rowid ON llx_projet_extrafields (rowid)
    llx_product_langCREATE INDEX idx_llx_product_lang_rowid ON llx_product_lang (rowid)
    llx_facture_fourn_detCREATE INDEX idx_llx_facture_fourn_det_rowid ON llx_facture_fourn_det (rowid)
    llx_agefodd_placeCREATE INDEX idx_llx_agefodd_place_rowid ON llx_agefodd_place (rowid)
    llx_projet_task_timeCREATE INDEX idx_llx_projet_task_time_rowid ON llx_projet_task_time (rowid)
    llx_agefodd_reg_interieurCREATE INDEX idx_llx_agefodd_reg_interieur_rowid ON llx_agefodd_reg_interieur (rowid)
    llx_contratdet_logCREATE INDEX idx_llx_contratdet_log_fk_contratdet ON llx_contratdet_log (fk_contratdet)
    llx_document_modelCREATE INDEX idx_llx_document_model_rowid ON llx_document_model (rowid)
    llx_facturedet_recCREATE INDEX idx_llx_facturedet_rec_rowid ON llx_facturedet_rec (rowid)
    llx_fichinterdetCREATE INDEX idx_llx_fichinterdet_rowid ON llx_fichinterdet (rowid)
    llx_c_paiementCREATE INDEX idx_llx_c_paiement_id ON llx_c_paiement (id)
    llx_propalCREATE INDEX idx_llx_propal_fk_projet ON llx_propal (fk_projet)
    llx_agefodd_opcaCREATE INDEX idx_llx_agefodd_opca_rowid ON llx_agefodd_opca (rowid)
    llx_element_contactCREATE INDEX idx_llx_element_contact_rowid ON llx_element_contact (rowid)
    llx_c_availabilityCREATE INDEX idx_llx_c_availability_rowid ON llx_c_availability (rowid)
    llx_agefodd_formation_objectifs_pedaCREATE INDEX idx_llx_agefodd_formation_objectifs_peda_fk_formation_catalogue ON llx_agefodd_formation_objectifs_peda (fk_formation_catalogue)
    llx_livraisondetCREATE INDEX idx_llx_livraisondet_rowid ON llx_livraisondet (rowid)
    llx_c_paper_formatCREATE INDEX idx_llx_c_paper_format_rowid ON llx_c_paper_format (rowid)
    llx_mailing_ciblesCREATE INDEX idx_llx_mailing_cibles_rowid ON llx_mailing_cibles (rowid)
    llx_agefodd_session_stagiaireCREATE INDEX idx_llx_agefodd_session_stagiaire_fk_stagiaire ON llx_agefodd_session_stagiaire (fk_stagiaire)
    llx_expeditionCREATE INDEX idx_llx_expedition_rowid ON llx_expedition (rowid)
    llx_agefodd_formation_catalogue_typeCREATE INDEX idx_llx_agefodd_formation_catalogue_type_rowid ON llx_agefodd_formation_catalogue_type (rowid)
    llx_agefodd_session_formateurCREATE INDEX idx_llx_agefodd_session_formateur_rowid ON llx_agefodd_session_formateur (rowid)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_rowid ON llx_societe_remise_except (rowid)
    llx_usergroup_userCREATE INDEX idx_llx_usergroup_user_fk_usergroup ON llx_usergroup_user (fk_usergroup)
    llx_domainCREATE INDEX idx_llx_domain_rowid ON llx_domain (rowid)
    llx_notify_defCREATE INDEX idx_llx_notify_def_rowid ON llx_notify_def (rowid)
    llx_categorie_productCREATE INDEX idx_llx_categorie_product_fk_categorie ON llx_categorie_product (fk_categorie)
    llx_holiday_usersCREATE INDEX idx_llx_holiday_users_fk_user ON llx_holiday_users (fk_user)
    llx_compta_accountCREATE INDEX idx_llx_compta_account_rowid ON llx_compta_account (rowid)
    llx_productCREATE INDEX idx_llx_product_rowid ON llx_product (rowid)
    llx_fichinterdetCREATE INDEX idx_llx_fichinterdet_fk_fichinter ON llx_fichinterdet (fk_fichinter)
    llx_c_civiliteCREATE INDEX idx_llx_c_civilite_rowid ON llx_c_civilite (rowid)
    llx_projet_taskCREATE INDEX idx_llx_projet_task_fk_projet ON llx_projet_task (fk_projet)
    llx_donCREATE INDEX idx_llx_don_rowid ON llx_don (rowid)
    llx_expeditiondetCREATE INDEX idx_llx_expeditiondet_rowid ON llx_expeditiondet (rowid)
    llx_c_action_triggerCREATE INDEX idx_llx_c_action_trigger_rowid ON llx_c_action_trigger (rowid)
    llx_factureCREATE INDEX idx_llx_facture_rowid ON llx_facture (rowid)
    llx_projet_task_extrafieldsCREATE INDEX idx_llx_projet_task_extrafields_rowid ON llx_projet_task_extrafields (rowid)
    llx_ecm_documentsCREATE INDEX idx_llx_ecm_documents_rowid ON llx_ecm_documents (rowid)
    llx_societe_logCREATE INDEX idx_llx_societe_log_id ON llx_societe_log (id)
    llx_fichinterCREATE INDEX idx_llx_fichinter_rowid ON llx_fichinter (rowid)
    llx_commande_extrafieldsCREATE INDEX idx_llx_commande_extrafields_rowid ON llx_commande_extrafields (rowid)
    llx_agefodd_session_contactCREATE INDEX idx_llx_agefodd_session_contact_fk_session_agefodd ON llx_agefodd_session_contact (fk_session_agefodd)
    llx_c_actioncommCREATE INDEX idx_llx_c_actioncomm_id ON llx_c_actioncomm (id)
    llx_paiementfournCREATE INDEX idx_llx_paiementfourn_rowid ON llx_paiementfourn (rowid)
    llx_ecm_directoriesCREATE INDEX idx_llx_ecm_directories_fk_user_c ON llx_ecm_directories (fk_user_c)
    llx_c_forme_juridiqueCREATE INDEX idx_llx_c_forme_juridique_rowid ON llx_c_forme_juridique (rowid)
    llx_accountingtransactionCREATE INDEX idx_llx_accountingtransaction_rowid ON llx_accountingtransaction (rowid)
    llx_bank_categCREATE INDEX idx_llx_bank_categ_rowid ON llx_bank_categ (rowid)
    llx_c_prospectlevelCREATE INDEX idx_llx_c_prospectlevel_code ON llx_c_prospectlevel (code)
    llx_c_tvaCREATE INDEX idx_llx_c_tva_rowid ON llx_c_tva (rowid)
    llx_product_cnv_livre_contratCREATE INDEX idx_llx_product_cnv_livre_contrat_rowid ON llx_product_cnv_livre_contrat (rowid)
    llx_commandeCREATE INDEX idx_llx_commande_fk_currency ON llx_commande (fk_currency)
    llx_projet_taskCREATE INDEX idx_llx_projet_task_rowid ON llx_projet_task (rowid)
    llx_agefodd_training_admlevelCREATE INDEX idx_llx_agefodd_training_admlevel_rowid ON llx_agefodd_training_admlevel (rowid)
    llx_facture_fournCREATE INDEX idx_llx_facture_fourn_fk_user_author ON llx_facture_fourn (fk_user_author)
    llx_bankCREATE INDEX idx_llx_bank_rowid ON llx_bank (rowid)
    llx_entityCREATE INDEX idx_llx_entity_rowid ON llx_entity (rowid)
    llx_c_input_reasonCREATE INDEX idx_llx_c_input_reason_rowid ON llx_c_input_reason (rowid)
    llx_categorie_memberCREATE INDEX idx_llx_categorie_member_fk_categorie_fk_member ON llx_categorie_member (fk_categorie.fk_member)
    llx_socpeopleCREATE INDEX idx_llx_socpeople_fk_soc ON llx_socpeople (fk_soc)
    llx_c_propalstCREATE INDEX idx_llx_c_propalst_id ON llx_c_propalst (id)
    llx_c_type_contactCREATE INDEX idx_llx_c_type_contact_rowid ON llx_c_type_contact (rowid)
    llx_categorie_memberCREATE INDEX idx_llx_categorie_member_fk_categorie ON llx_categorie_member (fk_categorie)
    llx_commandeCREATE INDEX idx_llx_commande_fk_soc ON llx_commande (fk_soc)
    llx_propalCREATE INDEX idx_llx_propal_fk_currency ON llx_propal (fk_currency)
    llx_export_modelCREATE INDEX idx_llx_export_model_rowid ON llx_export_model (rowid)
    llx_holiday_eventsCREATE INDEX idx_llx_holiday_events_rowid ON llx_holiday_events (rowid)
    llx_agefodd_session_commercialCREATE INDEX idx_llx_agefodd_session_commercial_fk_session_agefodd ON llx_agefodd_session_commercial (fk_session_agefodd)
    llx_agefodd_stagiaire_certifCREATE INDEX idx_llx_agefodd_stagiaire_certif_rowid ON llx_agefodd_stagiaire_certif (rowid)
    llx_prelevement_lignesCREATE INDEX idx_llx_prelevement_lignes_fk_prelevement_bons ON llx_prelevement_lignes (fk_prelevement_bons)
    llx_propaldetCREATE INDEX idx_llx_propaldet_rowid ON llx_propaldet (rowid)
    llx_propalCREATE INDEX idx_llx_propal_fk_user_valid ON llx_propal (fk_user_valid)
    llx_user_paramCREATE INDEX idx_llx_user_param_param_fk_user_entity ON llx_user_param (param.fk_user.entity)
    llx_product_priceCREATE INDEX idx_llx_product_price_rowid ON llx_product_price (rowid)
    llx_propalCREATE INDEX idx_llx_propal_rowid ON llx_propal (rowid)
    llx_product_extrafieldsCREATE INDEX idx_llx_product_extrafields_rowid ON llx_product_extrafields (rowid)
    llx_projetCREATE INDEX idx_llx_projet_fk_soc ON llx_projet (fk_soc)
    llx_entrepotCREATE INDEX idx_llx_entrepot_rowid ON llx_entrepot (rowid)
    llx_factureCREATE INDEX idx_llx_facture_fk_currency ON llx_facture (fk_currency)
    llx_categorie_fournisseurCREATE INDEX idx_llx_categorie_fournisseur_fk_societe ON llx_categorie_fournisseur (fk_societe)
    llx_product_fournisseur_priceCREATE INDEX idx_llx_product_fournisseur_price_fk_product ON llx_product_fournisseur_price (fk_product)
    llx_adherent_extrafieldsCREATE INDEX idx_llx_adherent_extrafields_rowid ON llx_adherent_extrafields (rowid)
    llx_agefodd_sessionCREATE INDEX idx_llx_agefodd_session_rowid ON llx_agefodd_session (rowid)
    llx_agefodd_session_stagiaireCREATE INDEX idx_llx_agefodd_session_stagiaire_fk_session_agefodd ON llx_agefodd_session_stagiaire (fk_session_agefodd)
    llx_c_shipment_modeCREATE INDEX idx_llx_c_shipment_mode_rowid ON llx_c_shipment_mode (rowid)
    llx_commandedetCREATE INDEX idx_llx_commandedet_rowid ON llx_commandedet (rowid)
    llx_facture_fourn_detCREATE INDEX idx_llx_facture_fourn_det_fk_facture_fourn ON llx_facture_fourn_det (fk_facture_fourn)
    llx_holiday_configCREATE INDEX idx_llx_holiday_config_name ON llx_holiday_config (name)
    llx_element_contactCREATE INDEX idx_llx_element_contact_fk_c_type_contact ON llx_element_contact (fk_c_type_contact)
    llx_element_tagCREATE INDEX idx_llx_element_tag_rowid ON llx_element_tag (rowid)
    llx_propalCREATE INDEX idx_llx_propal_fk_user_author ON llx_propal (fk_user_author)
    llx_societe_remiseCREATE INDEX idx_llx_societe_remise_rowid ON llx_societe_remise (rowid)
    llx_menuCREATE INDEX idx_llx_menu_rowid ON llx_menu (rowid)
    llx_opensurvey_commentsCREATE INDEX idx_llx_opensurvey_comments_id_comment ON llx_opensurvey_comments (id_comment)
    llx_opensurvey_commentsCREATE INDEX idx_llx_opensurvey_comments_id_comment ON llx_opensurvey_comments (id_comment)
    llx_contratdetCREATE INDEX idx_llx_contratdet_fk_product ON llx_contratdet (fk_product)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_fk_facture ON llx_societe_remise_except (fk_facture)
    llx_categorie_associationCREATE INDEX idx_llx_categorie_association_fk_categorie_mere_fk_categorie_fille ON llx_categorie_association (fk_categorie_mere.fk_categorie_fille)
    llx_categorie_associationCREATE INDEX idx_llx_categorie_association_fk_categorie_mere_fk_categorie_fille ON llx_categorie_association (fk_categorie_mere.fk_categorie_fille)
    llx_commande_fournisseurCREATE INDEX idx_llx_commande_fournisseur_rowid ON llx_commande_fournisseur (rowid)
    llx_energie_groupeCREATE INDEX idx_llx_energie_groupe_rowid ON llx_energie_groupe (rowid)
    llx_c_typentCREATE INDEX idx_llx_c_typent_id ON llx_c_typent (id)
    llx_categorie_societeCREATE INDEX idx_llx_categorie_societe_fk_societe ON llx_categorie_societe (fk_societe)
    llx_usergroup_rightsCREATE INDEX idx_llx_usergroup_rights_fk_usergroup ON llx_usergroup_rights (fk_usergroup)
    llx_pos_tmpCREATE INDEX idx_llx_pos_tmp_id ON llx_pos_tmp (id)
    llx_c_stcommCREATE INDEX idx_llx_c_stcomm_id ON llx_c_stcomm (id)
    llx_accounting_systemCREATE INDEX idx_llx_accounting_system_rowid ON llx_accounting_system (rowid)
    llx_agefodd_session_contactCREATE INDEX idx_llx_agefodd_session_contact_fk_agefodd_contact ON llx_agefodd_session_contact (fk_agefodd_contact)
    llx_facturedetCREATE INDEX idx_llx_facturedet_fk_facture ON llx_facturedet (fk_facture)
    llx_livraisonCREATE INDEX idx_llx_livraison_fk_user_valid ON llx_livraison (fk_user_valid)
    llx_categorie_productCREATE INDEX idx_llx_categorie_product_fk_product_fk_categorie ON llx_categorie_product (fk_product.fk_categorie)
    llx_agefodd_session_extrafieldsCREATE INDEX idx_llx_agefodd_session_extrafields_rowid ON llx_agefodd_session_extrafields (rowid)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_fk_facture_line ON llx_societe_remise_except (fk_facture_line)
    llx_accountingaccountCREATE INDEX idx_llx_accountingaccount_rowid ON llx_accountingaccount (rowid)
    llx_localtaxCREATE INDEX idx_llx_localtax_rowid ON llx_localtax (rowid)
    llx_adherent_type_extrafieldsCREATE INDEX idx_llx_adherent_type_extrafields_rowid ON llx_adherent_type_extrafields (rowid)
    llx_facture_extrafieldsCREATE INDEX idx_llx_facture_extrafields_rowid ON llx_facture_extrafields (rowid)
    llx_factureCREATE INDEX idx_llx_facture_fk_facture_source ON llx_facture (fk_facture_source)
    llx_bank_urlCREATE INDEX idx_llx_bank_url_rowid ON llx_bank_url (rowid)
    llx_paiementchargeCREATE INDEX idx_llx_paiementcharge_rowid ON llx_paiementcharge (rowid)
    llx_c_ziptownCREATE INDEX idx_llx_c_ziptown_rowid ON llx_c_ziptown (rowid)
    llx_facture_recCREATE INDEX idx_llx_facture_rec_fk_soc ON llx_facture_rec (fk_soc)
    llx_bookmarkCREATE INDEX idx_llx_bookmark_rowid ON llx_bookmark (rowid)
    llx_user_extrafieldsCREATE INDEX idx_llx_user_extrafields_rowid ON llx_user_extrafields (rowid)
    llx_agefodd_session_commercialCREATE INDEX idx_llx_agefodd_session_commercial_rowid ON llx_agefodd_session_commercial (rowid)
    llx_adherent_typeCREATE INDEX idx_llx_adherent_type_rowid ON llx_adherent_type (rowid)
    llx_agefodd_contactCREATE INDEX idx_llx_agefodd_contact_fk_socpeople ON llx_agefodd_contact (fk_socpeople)
    llx_agefodd_formation_objectifs_pedaCREATE INDEX idx_llx_agefodd_formation_objectifs_peda_rowid ON llx_agefodd_formation_objectifs_peda (rowid)
    llx_paiementfourn_facturefournCREATE INDEX idx_llx_paiementfourn_facturefourn_rowid ON llx_paiementfourn_facturefourn (rowid)
    llx_c_regionsCREATE INDEX idx_llx_c_regions_fk_pays ON llx_c_regions (fk_pays)
    llx_agefodd_contactCREATE INDEX idx_llx_agefodd_contact_rowid ON llx_agefodd_contact (rowid)
    llx_prelevement_bonsCREATE INDEX idx_llx_prelevement_bons_rowid ON llx_prelevement_bons (rowid)
    llx_categorie_fournisseurCREATE INDEX idx_llx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur (fk_categorie)
    llx_actioncommCREATE INDEX idx_llx_actioncomm_id ON llx_actioncomm (id)
    llx_eventsCREATE INDEX idx_llx_events_rowid ON llx_events (rowid)
    llx_socpeople_extrafieldsCREATE INDEX idx_llx_socpeople_extrafields_rowid ON llx_socpeople_extrafields (rowid)
    llx_printer_ippCREATE INDEX idx_llx_printer_ipp_rowid ON llx_printer_ipp (rowid)
    llx_product_langCREATE INDEX idx_llx_product_lang_fk_product ON llx_product_lang (fk_product)
    llx_document_generatorCREATE INDEX idx_llx_document_generator_rowid ON llx_document_generator (rowid)
    llx_projet_taskCREATE INDEX idx_llx_projet_task_fk_user_creat ON llx_projet_task (fk_user_creat)
    llx_bank_classCREATE INDEX idx_llx_bank_class_lineid_fk_categ ON llx_bank_class (lineid.fk_categ)
    llx_bank_classCREATE INDEX idx_llx_bank_class_lineid_fk_categ ON llx_bank_class (lineid.fk_categ)
    llx_agefodd_sessionCREATE INDEX idx_llx_agefodd_session_fk_session_place ON llx_agefodd_session (fk_session_place)
    llx_agefodd_factureCREATE INDEX idx_llx_agefodd_facture_fk_session ON llx_agefodd_facture (fk_session)
    llx_livraisonCREATE INDEX idx_llx_livraison_fk_soc ON llx_livraison (fk_soc)
    llx_livraisonCREATE INDEX idx_llx_livraison_fk_user_author ON llx_livraison (fk_user_author)
    llx_bank_accountCREATE INDEX idx_llx_bank_account_rowid ON llx_bank_account (rowid)
    llx_facture_fournCREATE INDEX idx_llx_facture_fourn_rowid ON llx_facture_fourn (rowid)
    llx_categorie_societeCREATE INDEX idx_llx_categorie_societe_fk_categorie ON llx_categorie_societe (fk_categorie)
    llx_agefodd_session_stagiaireCREATE INDEX idx_llx_agefodd_session_stagiaire_rowid ON llx_agefodd_session_stagiaire (rowid)
    llx_agefodd_formateurCREATE INDEX idx_llx_agefodd_formateur_rowid ON llx_agefodd_formateur (rowid)
    llx_agefodd_session_calendrierCREATE INDEX idx_llx_agefodd_session_calendrier_fk_actioncomm ON llx_agefodd_session_calendrier (fk_actioncomm)
    llx_agefodd_conventionCREATE INDEX idx_llx_agefodd_convention_rowid ON llx_agefodd_convention (rowid)
    llx_adherentCREATE INDEX idx_llx_adherent_rowid ON llx_adherent (rowid)
    llx_product_fournisseur_priceCREATE INDEX idx_llx_product_fournisseur_price_fk_user ON llx_product_fournisseur_price (fk_user)
    llx_c_currenciesCREATE INDEX idx_llx_c_currencies_code_iso ON llx_c_currencies (code_iso)
    llx_c_type_feesCREATE INDEX idx_llx_c_type_fees_id ON llx_c_type_fees (id)
    llx_facture_recCREATE INDEX idx_llx_facture_rec_rowid ON llx_facture_rec (rowid)
    llx_contratCREATE INDEX idx_llx_contrat_rowid ON llx_contrat (rowid)
    llx_bordereau_chequeCREATE INDEX idx_llx_bordereau_cheque_rowid ON llx_bordereau_cheque (rowid)
    llx_commandedetCREATE INDEX idx_llx_commandedet_fk_commande ON llx_commandedet (fk_commande)
    llx_product_price_by_qtyCREATE INDEX idx_llx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty (fk_product_price)
    llx_usergroupCREATE INDEX idx_llx_usergroup_rowid ON llx_usergroup (rowid)
    llx_categorie_memberCREATE INDEX idx_llx_categorie_member_fk_member ON llx_categorie_member (fk_member)
    llx_propalCREATE INDEX idx_llx_propal_fk_soc ON llx_propal (fk_soc)
    llx_commandeCREATE INDEX idx_llx_commande_fk_user_author ON llx_commande (fk_user_author)
    llx_facture_recCREATE INDEX idx_llx_facture_rec_fk_projet ON llx_facture_rec (fk_projet)
    llx_import_modelCREATE INDEX idx_llx_import_model_rowid ON llx_import_model (rowid)
    llx_c_chargesocialesCREATE INDEX idx_llx_c_chargesociales_id ON llx_c_chargesociales (id)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_fk_facture_source ON llx_societe_remise_except (fk_facture_source)
    llx_projetCREATE INDEX idx_llx_projet_rowid ON llx_projet (rowid)
    llx_cronjobCREATE INDEX idx_llx_cronjob_rowid ON llx_cronjob (rowid)
    llx_product_stockCREATE INDEX idx_llx_product_stock_rowid ON llx_product_stock (rowid)
    llx_product_fournisseur_price_logCREATE INDEX idx_llx_product_fournisseur_price_log_rowid ON llx_product_fournisseur_price_log (rowid)
    llx_user_rightsCREATE INDEX idx_llx_user_rights_rowid ON llx_user_rights (rowid)
    llx_agefodd_training_admlevelCREATE INDEX idx_llx_agefodd_training_admlevel_fk_training ON llx_agefodd_training_admlevel (fk_training)
    llx_usergroup_rightsCREATE INDEX idx_llx_usergroup_rights_rowid ON llx_usergroup_rights (rowid)
    llx_agefodd_stagiaireCREATE INDEX idx_llx_agefodd_stagiaire_civilite ON llx_agefodd_stagiaire (civilite)
    llx_commande_fournisseur_extrafieldsCREATE INDEX idx_llx_commande_fournisseur_extrafields_rowid ON llx_commande_fournisseur_extrafields (rowid)
    llx_factureCREATE INDEX idx_llx_facture_fk_soc ON llx_facture (fk_soc)
    llx_agefodd_stagiaireCREATE INDEX idx_llx_agefodd_stagiaire_rowid ON llx_agefodd_stagiaire (rowid)
    llx_droitpret_rapportCREATE INDEX idx_llx_droitpret_rapport_rowid ON llx_droitpret_rapport (rowid)
    llx_holidayCREATE INDEX idx_llx_holiday_rowid ON llx_holiday (rowid)
    llx_c_regionsCREATE INDEX idx_llx_c_regions_rowid ON llx_c_regions (rowid)
    llx_propaldetCREATE INDEX idx_llx_propaldet_fk_propal ON llx_propaldet (fk_propal)
    llx_export_comptaCREATE INDEX idx_llx_export_compta_rowid ON llx_export_compta (rowid)
    llx_contratCREATE INDEX idx_llx_contrat_fk_soc ON llx_contrat (fk_soc)
    llx_factureCREATE INDEX idx_llx_facture_fk_projet ON llx_facture (fk_projet)
    llx_facture_recCREATE INDEX idx_llx_facture_rec_fk_user_author ON llx_facture_rec (fk_user_author)
    llx_deplacementCREATE INDEX idx_llx_deplacement_rowid ON llx_deplacement (rowid)
    llx_contratCREATE INDEX idx_llx_contrat_fk_user_author ON llx_contrat (fk_user_author)
    llx_factureCREATE INDEX idx_llx_facture_fk_user_valid ON llx_facture (fk_user_valid)
    llx_societe_extrafieldsCREATE INDEX idx_llx_societe_extrafields_rowid ON llx_societe_extrafields (rowid)
    llx_userCREATE INDEX idx_llx_user_rowid ON llx_user (rowid)
    llx_c_field_listCREATE INDEX idx_llx_c_field_list_rowid ON llx_c_field_list (rowid)
    llx_societe_ribCREATE INDEX idx_llx_societe_rib_rowid ON llx_societe_rib (rowid)
    llx_comptaCREATE INDEX idx_llx_compta_rowid ON llx_compta (rowid)
    llx_socpeopleCREATE INDEX idx_llx_socpeople_fk_user_creat ON llx_socpeople (fk_user_creat)
    llx_element_elementCREATE INDEX idx_llx_element_element_rowid ON llx_element_element (rowid)
    llx_agefodd_session_commercialCREATE INDEX idx_llx_agefodd_session_commercial_fk_user_com ON llx_agefodd_session_commercial (fk_user_com)
    llx_prelevement_factureCREATE INDEX idx_llx_prelevement_facture_rowid ON llx_prelevement_facture (rowid)
    llx_user_entrepotCREATE INDEX idx_llx_user_entrepot_rowid ON llx_user_entrepot (rowid)
    llx_holiday_configCREATE INDEX idx_llx_holiday_config_rowid ON llx_holiday_config (rowid)
    llx_categorie_fournisseurCREATE INDEX idx_llx_categorie_fournisseur_fk_categorie_fk_societe ON llx_categorie_fournisseur (fk_categorie.fk_societe)
    llx_facture_fournCREATE INDEX idx_llx_facture_fourn_fk_projet ON llx_facture_fourn (fk_projet)
    llx_agefodd_session_stagiaireCREATE INDEX idx_llx_agefodd_session_stagiaire_fk_agefodd_stagiaire_type ON llx_agefodd_session_stagiaire (fk_agefodd_stagiaire_type)
    llx_c_input_methodCREATE INDEX idx_llx_c_input_method_rowid ON llx_c_input_method (rowid)
    llx_compta_compte_generauxCREATE INDEX idx_llx_compta_compte_generaux_rowid ON llx_compta_compte_generaux (rowid)
    llx_propalCREATE INDEX idx_llx_propal_fk_user_cloture ON llx_propal (fk_user_cloture)
    llx_agefodd_factureCREATE INDEX idx_llx_agefodd_facture_rowid ON llx_agefodd_facture (rowid)
    llx_categorie_societeCREATE INDEX idx_llx_categorie_societe_fk_categorie_fk_societe ON llx_categorie_societe (fk_categorie.fk_societe)
    llx_energie_compteur_releveCREATE INDEX idx_llx_energie_compteur_releve_rowid ON llx_energie_compteur_releve (rowid)
    llx_agefodd_placeCREATE INDEX idx_llx_agefodd_place_fk_pays ON llx_agefodd_place (fk_pays)
    llx_agefodd_stagiaire_typeCREATE INDEX idx_llx_agefodd_stagiaire_type_rowid ON llx_agefodd_stagiaire_type (rowid)
    llx_rights_defCREATE INDEX idx_llx_rights_def_id_entity ON llx_rights_def (id.entity)
    llx_contratdetCREATE INDEX idx_llx_contratdet_fk_contrat ON llx_contratdet (fk_contrat)
    llx_ecm_directoriesCREATE INDEX idx_llx_ecm_directories_rowid ON llx_ecm_directories (rowid)
    llx_societeCREATE INDEX idx_llx_societe_rowid ON llx_societe (rowid)
    llx_prelevement_rejetCREATE INDEX idx_llx_prelevement_rejet_rowid ON llx_prelevement_rejet (rowid)
    llx_holiday_logsCREATE INDEX idx_llx_holiday_logs_rowid ON llx_holiday_logs (rowid)
    llx_product_cnv_livreCREATE INDEX idx_llx_product_cnv_livre_rowid ON llx_product_cnv_livre (rowid)
    llx_facture_fournCREATE INDEX idx_llx_facture_fourn_fk_soc ON llx_facture_fourn (fk_soc)
    llx_agefodd_session_calendrierCREATE INDEX idx_llx_agefodd_session_calendrier_fk_agefodd_session ON llx_agefodd_session_calendrier (fk_agefodd_session)
    llx_livraisonCREATE INDEX idx_llx_livraison_rowid ON llx_livraison (rowid)
    llx_categorieCREATE INDEX idx_llx_categorie_rowid ON llx_categorie (rowid)
    llx_extrafieldsCREATE INDEX idx_llx_extrafields_rowid ON llx_extrafields (rowid)
    llx_adherentCREATE INDEX idx_llx_adherent_fk_soc ON llx_adherent (fk_soc)
    llx_societe_pricesCREATE INDEX idx_llx_societe_prices_rowid ON llx_societe_prices (rowid)
    llx_boxes_defCREATE INDEX idx_llx_boxes_def_rowid ON llx_boxes_def (rowid)
    llx_categorie_productCREATE INDEX idx_llx_categorie_product_fk_product ON llx_categorie_product (fk_product)
    llx_agefodd_session_adminsituCREATE INDEX idx_llx_agefodd_session_adminsitu_rowid ON llx_agefodd_session_adminsitu (rowid)
    llx_agefodd_session_admlevelCREATE INDEX idx_llx_agefodd_session_admlevel_rowid ON llx_agefodd_session_admlevel (rowid)
    llx_product_associationCREATE INDEX idx_llx_product_association_rowid ON llx_product_association (rowid)
    llx_commandeCREATE INDEX idx_llx_commande_fk_user_cloture ON llx_commande (fk_user_cloture)
    llx_facture_fourn_extrafieldsCREATE INDEX idx_llx_facture_fourn_extrafields_rowid ON llx_facture_fourn_extrafields (rowid)
    llx_societe_commerciauxCREATE INDEX idx_llx_societe_commerciaux_rowid ON llx_societe_commerciaux (rowid)
    llx_commande_fournisseurCREATE INDEX idx_llx_commande_fournisseur_fk_soc ON llx_commande_fournisseur (fk_soc)
    llx_agefodd_calendrierCREATE INDEX idx_llx_agefodd_calendrier_rowid ON llx_agefodd_calendrier (rowid)
    llx_boxesCREATE INDEX idx_llx_boxes_rowid ON llx_boxes (rowid)
    llx_c_revenuestampCREATE INDEX idx_llx_c_revenuestamp_rowid ON llx_c_revenuestamp (rowid)
    llx_paiement_factureCREATE INDEX idx_llx_paiement_facture_fk_paiement ON llx_paiement_facture (fk_paiement)
    llx_projet_taskCREATE INDEX idx_llx_projet_task_fk_user_valid ON llx_projet_task (fk_user_valid)
    llx_prelevement_facture_demandeCREATE INDEX idx_llx_prelevement_facture_demande_rowid ON llx_prelevement_facture_demande (rowid)
    llx_agefodd_certificate_typeCREATE INDEX idx_llx_agefodd_certificate_type_rowid ON llx_agefodd_certificate_type (rowid)
    llx_c_ziptownCREATE INDEX idx_llx_c_ziptown_fk_county ON llx_c_ziptown (fk_county)
    llx_agefodd_session_calendrierCREATE INDEX idx_llx_agefodd_session_calendrier_rowid ON llx_agefodd_session_calendrier (rowid)
    llx_commandeCREATE INDEX idx_llx_commande_rowid ON llx_commande (rowid)
    llx_socpeopleCREATE INDEX idx_llx_socpeople_rowid ON llx_socpeople (rowid)
    llx_c_barcode_typeCREATE INDEX idx_llx_c_barcode_type_rowid ON llx_c_barcode_type (rowid)
    llx_product_price_by_qtyCREATE INDEX idx_llx_product_price_by_qty_rowid ON llx_product_price_by_qty (rowid)
    llx_paiementCREATE INDEX idx_llx_paiement_rowid ON llx_paiement (rowid)
    llx_facture_fournCREATE INDEX idx_llx_facture_fourn_fk_user_valid ON llx_facture_fourn (fk_user_valid)
    llx_propal_merge_pdf_productCREATE INDEX idx_llx_propal_merge_pdf_product_rowid ON llx_propal_merge_pdf_product (rowid)
    llx_c_departementsCREATE INDEX idx_llx_c_departements_rowid ON llx_c_departements (rowid)
    llx_expeditiondetCREATE INDEX idx_llx_expeditiondet_fk_expedition ON llx_expeditiondet (fk_expedition)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_fk_soc ON llx_societe_remise_except (fk_soc)
    llx_transaction_bplcCREATE INDEX idx_llx_transaction_bplc_rowid ON llx_transaction_bplc (rowid)
    llx_commande_fournisseur_logCREATE INDEX idx_llx_commande_fournisseur_log_rowid ON llx_commande_fournisseur_log (rowid)
    llx_expeditionCREATE INDEX idx_llx_expedition_fk_user_author ON llx_expedition (fk_user_author)
    llx_livraisondetCREATE INDEX idx_llx_livraisondet_fk_livraison ON llx_livraisondet (fk_livraison)
    llx_propal_extrafieldsCREATE INDEX idx_llx_propal_extrafields_rowid ON llx_propal_extrafields (rowid)
    llx_constCREATE INDEX idx_llx_const_rowid ON llx_const (rowid)
    llx_prelevement_lignesCREATE INDEX idx_llx_prelevement_lignes_rowid ON llx_prelevement_lignes (rowid)
    llx_usergroup_userCREATE INDEX idx_llx_usergroup_user_fk_user ON llx_usergroup_user (fk_user)
    llx_expeditionCREATE INDEX idx_llx_expedition_fk_soc ON llx_expedition (fk_soc)
    llx_factureCREATE INDEX idx_llx_facture_fk_user_author ON llx_facture (fk_user_author)
    llx_tvaCREATE INDEX idx_llx_tva_rowid ON llx_tva (rowid)
    llx_c_payment_termCREATE INDEX idx_llx_c_payment_term_rowid ON llx_c_payment_term (rowid)
    llx_societe_addressCREATE INDEX idx_llx_societe_address_rowid ON llx_societe_address (rowid)
    llx_energie_compteurCREATE INDEX idx_llx_energie_compteur_rowid ON llx_energie_compteur (rowid)
    llx_fichinterCREATE INDEX idx_llx_fichinter_fk_soc ON llx_fichinter (fk_soc)
    llx_agefodd_conventionCREATE INDEX idx_llx_agefodd_convention_fk_agefodd_session ON llx_agefodd_convention (fk_agefodd_session)
    llx_facturedetCREATE INDEX idx_llx_facturedet_rowid ON llx_facturedet (rowid)
    llx_commandeCREATE INDEX idx_llx_commande_fk_user_valid ON llx_commande (fk_user_valid)
    llx_user_rightsCREATE INDEX idx_llx_user_rights_fk_user ON llx_user_rights (fk_user)
    llx_commandeCREATE INDEX idx_llx_commande_fk_projet ON llx_commande (fk_projet)
    llx_chargesocialesCREATE INDEX idx_llx_chargesociales_rowid ON llx_chargesociales (rowid)
    llx_agefodd_session_formateurCREATE INDEX idx_llx_agefodd_session_formateur_fk_session ON llx_agefodd_session_formateur (fk_session)
    llx_paiement_factureCREATE INDEX idx_llx_paiement_facture_rowid ON llx_paiement_facture (rowid)
    llx_cotisationCREATE INDEX idx_llx_cotisation_rowid ON llx_cotisation (rowid)
    llx_opensurvey_user_studsCREATE INDEX idx_llx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs (id_users)
    llx_opensurvey_user_studsCREATE INDEX idx_llx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs (id_users)
    llx_product_subproductCREATE INDEX idx_llx_product_subproduct_rowid ON llx_product_subproduct (rowid)
    llx_usergroup_userCREATE INDEX idx_llx_usergroup_user_rowid ON llx_usergroup_user (rowid)
    llx_agefodd_certif_stateCREATE INDEX idx_llx_agefodd_certif_state_rowid ON llx_agefodd_certif_state (rowid)
    llx_adherentCREATE INDEX idx_llx_adherent_fk_adherent_type ON llx_adherent (fk_adherent_type)
    llx_c_ecotaxeCREATE INDEX idx_llx_c_ecotaxe_rowid ON llx_c_ecotaxe (rowid)
    llx_societe_remise_exceptCREATE INDEX idx_llx_societe_remise_except_fk_user ON llx_societe_remise_except (fk_user)
    llx_c_effectifCREATE INDEX idx_llx_c_effectif_id ON llx_c_effectif (id)
    llx_opensurvey_sondageCREATE INDEX idx_llx_opensurvey_sondage_id_sondage ON llx_opensurvey_sondage (id_sondage)
    llx_agefodd_session_adminsituCREATE INDEX idx_llx_agefodd_session_adminsitu_fk_agefodd_session ON llx_agefodd_session_adminsitu (fk_agefodd_session)
    llx_user_alertCREATE INDEX idx_llx_user_alert_rowid ON llx_user_alert (rowid)
    llx_agefodd_session_formateurCREATE INDEX idx_llx_agefodd_session_formateur_fk_agefodd_formateur ON llx_agefodd_session_formateur (fk_agefodd_formateur)
    llx_boxesCREATE INDEX idx_llx_boxes_box_id ON llx_boxes (box_id)
    llx_user_clicktodialCREATE INDEX idx_llx_user_clicktodial_fk_user ON llx_user_clicktodial (fk_user)
    llx_commande_fournisseur_dispatchCREATE INDEX idx_llx_commande_fournisseur_dispatch_rowid ON llx_commande_fournisseur_dispatch (rowid)
    llx_agefodd_formation_catalogueCREATE INDEX idx_llx_agefodd_formation_catalogue_rowid ON llx_agefodd_formation_catalogue (rowid)
    llx_expeditionCREATE INDEX idx_llx_expedition_fk_user_valid ON llx_expedition (fk_user_valid)
    llx_ecm_directoriesCREATE INDEX idx_llx_ecm_directories_fk_user_m ON llx_ecm_directories (fk_user_m)
    llx_c_paysCREATE INDEX idx_llx_c_pays_rowid ON llx_c_pays (rowid)
    llx_commande_fournisseurdetCREATE INDEX idx_llx_commande_fournisseurdet_rowid ON llx_commande_fournisseurdet (rowid)

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.