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

    Unused Indexes on dolibarr database

    List of indexes never used (idx_scan to 0)

    Shema Table Index Code
    publicllx_accountingaccountidx_accountingaccount_fk_pcg_versionCREATE INDEX idx_accountingaccount_fk_pcg_version ON llx_accountingaccount USING btree (fk_pcg_version)
    publicllx_actioncommidx_actioncomm_dateaCREATE INDEX idx_actioncomm_datea ON llx_actioncomm USING btree (datea)
    publicllx_actioncomm_extrafieldsidx_actioncomm_extrafieldsCREATE INDEX idx_actioncomm_extrafields ON llx_actioncomm_extrafields USING btree (fk_object)
    publicllx_adherentidx_adherent_fk_adherent_typeCREATE INDEX idx_adherent_fk_adherent_type ON llx_adherent USING btree (fk_adherent_type)
    publicllx_adherent_extrafieldsidx_adherent_optionsCREATE INDEX idx_adherent_options ON llx_adherent_extrafields USING btree (fk_object)
    publicllx_adherent_type_extrafieldsidx_adherent_type_extrafieldsCREATE INDEX idx_adherent_type_extrafields ON llx_adherent_type_extrafields USING btree (fk_object)
    publicllx_agefodd_contactidx_agefodd_contact_fk_socpeopleCREATE INDEX idx_agefodd_contact_fk_socpeople ON llx_agefodd_contact USING btree (fk_socpeople)
    publicllx_agefodd_conventionidx_fk_agefodd_session_convCREATE INDEX idx_fk_agefodd_session_conv ON llx_agefodd_convention USING btree (fk_agefodd_session)
    publicllx_agefodd_factureidx_fk_societe_facCREATE INDEX idx_fk_societe_fac ON llx_agefodd_facture USING btree (fk_societe)
    publicllx_agefodd_formateuridx_agefodd_formateur_fk_socpeopleCREATE INDEX idx_agefodd_formateur_fk_socpeople ON llx_agefodd_formateur USING btree (fk_socpeople)
    publicllx_agefodd_formateuridx_agefodd_formateur_fk_userCREATE INDEX idx_agefodd_formateur_fk_user ON llx_agefodd_formateur USING btree (fk_user)
    publicllx_agefodd_formation_catalogue_extrafieldsidx_agefodd_formation_catalogue_extrafieldsCREATE INDEX idx_agefodd_formation_catalogue_extrafields ON llx_agefodd_formation_catalogue_extrafields USING btree (fk_object)
    publicllx_agefodd_formation_objectifs_pedafk_formation_catalogue_obj_pedaCREATE INDEX fk_formation_catalogue_obj_peda ON llx_agefodd_formation_objectifs_peda USING btree (fk_formation_catalogue)
    publicllx_agefodd_placearchive_placeCREATE INDEX archive_place ON llx_agefodd_place USING btree (archive)
    publicllx_agefodd_session_contactfk_session_sess_contactCREATE INDEX fk_session_sess_contact ON llx_agefodd_session_contact USING btree (fk_session_agefodd)
    publicllx_agefodd_session_extrafieldsidx_agefodd_session_extrafieldsCREATE INDEX idx_agefodd_session_extrafields ON llx_agefodd_session_extrafields USING btree (fk_object)
    publicllx_agefodd_session_formateuridx_fk_agefodd_sess_formateurCREATE INDEX idx_fk_agefodd_sess_formateur ON llx_agefodd_session_formateur USING btree (fk_agefodd_formateur)
    publicllx_agefodd_session_stagiairefk_agefodd_stagiaire_type_sess_staCREATE INDEX fk_agefodd_stagiaire_type_sess_sta ON llx_agefodd_session_stagiaire USING btree (fk_agefodd_stagiaire_type)
    publicllx_agefodd_stagiairenom_staCREATE INDEX nom_sta ON llx_agefodd_stagiaire USING btree (nom)
    publicllx_agefodd_training_admlevelfk_agefodd_training_admlevelCREATE INDEX fk_agefodd_training_admlevel ON llx_agefodd_training_admlevel USING btree (fk_training)
    publicllx_bankidx_bank_datevCREATE INDEX idx_bank_datev ON llx_bank USING btree (datev)
    publicllx_boxesidx_boxes_boxidCREATE INDEX idx_boxes_boxid ON llx_boxes USING btree (box_id)
    publicllx_boxesidx_boxes_fk_userCREATE INDEX idx_boxes_fk_user ON llx_boxes USING btree (fk_user)
    publicllx_c_action_triggeridx_action_trigger_rangCREATE INDEX idx_action_trigger_rang ON llx_c_action_trigger USING btree (rang)
    publicllx_c_ziptownidx_c_ziptown_fk_countyCREATE INDEX idx_c_ziptown_fk_county ON llx_c_ziptown USING btree (fk_county)
    publicllx_categorieidx_categorie_labelCREATE INDEX idx_categorie_label ON llx_categorie USING btree (label)
    publicllx_categorieidx_categorie_typeCREATE INDEX idx_categorie_type ON llx_categorie USING btree (type)
    publicllx_categorie_fournisseuridx_categorie_fournisseur_fk_categorieCREATE INDEX idx_categorie_fournisseur_fk_categorie ON llx_categorie_fournisseur USING btree (fk_categorie)
    publicllx_categorie_fournisseuridx_categorie_fournisseur_fk_societeCREATE INDEX idx_categorie_fournisseur_fk_societe ON llx_categorie_fournisseur USING btree (fk_societe)
    publicllx_categorie_memberidx_categorie_member_fk_categorieCREATE INDEX idx_categorie_member_fk_categorie ON llx_categorie_member USING btree (fk_categorie)
    publicllx_categorie_memberidx_categorie_member_fk_memberCREATE INDEX idx_categorie_member_fk_member ON llx_categorie_member USING btree (fk_member)
    publicllx_categorie_productidx_categorie_product_fk_categorieCREATE INDEX idx_categorie_product_fk_categorie ON llx_categorie_product USING btree (fk_categorie)
    publicllx_categorie_productidx_categorie_product_fk_productCREATE INDEX idx_categorie_product_fk_product ON llx_categorie_product USING btree (fk_product)
    publicllx_categorie_societeidx_categorie_societe_fk_categorieCREATE INDEX idx_categorie_societe_fk_categorie ON llx_categorie_societe USING btree (fk_categorie)
    publicllx_categorie_societeidx_categorie_societe_fk_societeCREATE INDEX idx_categorie_societe_fk_societe ON llx_categorie_societe USING btree (fk_societe)
    publicllx_commandeidx_commande_fk_accountCREATE INDEX idx_commande_fk_account ON llx_commande USING btree (fk_account)
    publicllx_commandeidx_commande_fk_currencyCREATE INDEX idx_commande_fk_currency ON llx_commande USING btree (fk_currency)
    publicllx_commandeidx_commande_fk_projetCREATE INDEX idx_commande_fk_projet ON llx_commande USING btree (fk_projet)
    publicllx_commandeidx_commande_fk_user_authorCREATE INDEX idx_commande_fk_user_author ON llx_commande USING btree (fk_user_author)
    publicllx_commandeidx_commande_fk_user_clotureCREATE INDEX idx_commande_fk_user_cloture ON llx_commande USING btree (fk_user_cloture)
    publicllx_commandeidx_commande_fk_user_validCREATE INDEX idx_commande_fk_user_valid ON llx_commande USING btree (fk_user_valid)
    publicllx_commande_extrafieldsidx_commande_extrafieldsCREATE INDEX idx_commande_extrafields ON llx_commande_extrafields USING btree (fk_object)
    publicllx_commande_fournisseuridx_commande_fournisseur_fk_socCREATE INDEX idx_commande_fournisseur_fk_soc ON llx_commande_fournisseur USING btree (fk_soc)
    publicllx_commande_fournisseur_dispatchidx_commande_fournisseur_dispatch_fk_commandeCREATE INDEX idx_commande_fournisseur_dispatch_fk_commande ON llx_commande_fournisseur_dispatch USING btree (fk_commande)
    publicllx_commande_fournisseur_extrafieldsidx_commande_fournisseur_extrafieldsCREATE INDEX idx_commande_fournisseur_extrafields ON llx_commande_fournisseur_extrafields USING btree (fk_object)
    publicllx_contratidx_contrat_fk_socCREATE INDEX idx_contrat_fk_soc ON llx_contrat USING btree (fk_soc)
    publicllx_contratidx_contrat_fk_user_authorCREATE INDEX idx_contrat_fk_user_author ON llx_contrat USING btree (fk_user_author)
    publicllx_contratdetidx_contratdet_date_fin_validiteCREATE INDEX idx_contratdet_date_fin_validite ON llx_contratdet USING btree (date_fin_validite)
    publicllx_contratdetidx_contratdet_date_ouvertureCREATE INDEX idx_contratdet_date_ouverture ON llx_contratdet USING btree (date_ouverture)
    publicllx_contratdetidx_contratdet_date_ouverture_prevueCREATE INDEX idx_contratdet_date_ouverture_prevue ON llx_contratdet USING btree (date_ouverture_prevue)
    publicllx_contratdetidx_contratdet_fk_contratCREATE INDEX idx_contratdet_fk_contrat ON llx_contratdet USING btree (fk_contrat)
    publicllx_contratdetidx_contratdet_fk_productCREATE INDEX idx_contratdet_fk_product ON llx_contratdet USING btree (fk_product)
    publicllx_contratdet_logidx_contratdet_log_dateCREATE INDEX idx_contratdet_log_date ON llx_contratdet_log USING btree (date)
    publicllx_contratdet_logidx_contratdet_log_fk_contratdetCREATE INDEX idx_contratdet_log_fk_contratdet ON llx_contratdet_log USING btree (fk_contratdet)
    publicllx_ecm_directoriesidx_ecm_directories_fk_user_cCREATE INDEX idx_ecm_directories_fk_user_c ON llx_ecm_directories USING btree (fk_user_c)
    publicllx_ecm_directoriesidx_ecm_directories_fk_user_mCREATE INDEX idx_ecm_directories_fk_user_m ON llx_ecm_directories USING btree (fk_user_m)
    publicllx_element_contactfk_element_contact_fk_c_type_contactCREATE INDEX fk_element_contact_fk_c_type_contact ON llx_element_contact USING btree (fk_c_type_contact)
    publicllx_eventsidx_events_dateeventCREATE INDEX idx_events_dateevent ON llx_events USING btree (dateevent)
    publicllx_expeditionidx_expedition_fk_shipping_methodCREATE INDEX idx_expedition_fk_shipping_method ON llx_expedition USING btree (fk_shipping_method)
    publicllx_expeditionidx_expedition_fk_socCREATE INDEX idx_expedition_fk_soc ON llx_expedition USING btree (fk_soc)
    publicllx_expeditionidx_expedition_fk_user_authorCREATE INDEX idx_expedition_fk_user_author ON llx_expedition USING btree (fk_user_author)
    publicllx_expeditionidx_expedition_fk_user_validCREATE INDEX idx_expedition_fk_user_valid ON llx_expedition USING btree (fk_user_valid)
    publicllx_expeditiondetidx_expeditiondet_fk_expeditionCREATE INDEX idx_expeditiondet_fk_expedition ON llx_expeditiondet USING btree (fk_expedition)
    publicllx_factureidx_facture_fk_accountCREATE INDEX idx_facture_fk_account ON llx_facture USING btree (fk_account)
    publicllx_factureidx_facture_fk_user_authorCREATE INDEX idx_facture_fk_user_author ON llx_facture USING btree (fk_user_author)
    publicllx_facture_extrafieldsidx_facture_extrafieldsCREATE INDEX idx_facture_extrafields ON llx_facture_extrafields USING btree (fk_object)
    publicllx_facture_fournidx_facture_fourn_date_lim_reglementCREATE INDEX idx_facture_fourn_date_lim_reglement ON llx_facture_fourn USING btree (date_lim_reglement)
    publicllx_facture_fournidx_facture_fourn_fk_user_validCREATE INDEX idx_facture_fourn_fk_user_valid ON llx_facture_fourn USING btree (fk_user_valid)
    publicllx_facture_recidx_facture_rec_fk_projetCREATE INDEX idx_facture_rec_fk_projet ON llx_facture_rec USING btree (fk_projet)
    publicllx_facture_recidx_facture_rec_fk_socCREATE INDEX idx_facture_rec_fk_soc ON llx_facture_rec USING btree (fk_soc)
    publicllx_facture_recidx_facture_rec_fk_user_authorCREATE INDEX idx_facture_rec_fk_user_author ON llx_facture_rec USING btree (fk_user_author)
    publicllx_fichinteridx_fichinter_fk_socCREATE INDEX idx_fichinter_fk_soc ON llx_fichinter USING btree (fk_soc)
    publicllx_fichinterdetidx_fichinterdet_fk_fichinterCREATE INDEX idx_fichinterdet_fk_fichinter ON llx_fichinterdet USING btree (fk_fichinter)
    publicllx_holidayidx_holiday_date_debutCREATE INDEX idx_holiday_date_debut ON llx_holiday USING btree (date_debut)
    publicllx_holidayidx_holiday_date_finCREATE INDEX idx_holiday_date_fin ON llx_holiday USING btree (date_fin)
    publicllx_livraisonidx_livraison_fk_socCREATE INDEX idx_livraison_fk_soc ON llx_livraison USING btree (fk_soc)
    publicllx_livraisonidx_livraison_fk_user_authorCREATE INDEX idx_livraison_fk_user_author ON llx_livraison USING btree (fk_user_author)
    publicllx_livraisonidx_livraison_fk_user_validCREATE INDEX idx_livraison_fk_user_valid ON llx_livraison USING btree (fk_user_valid)
    publicllx_livraisondetidx_livraisondet_fk_expeditionCREATE INDEX idx_livraisondet_fk_expedition ON llx_livraisondet USING btree (fk_livraison)
    publicllx_mailing_ciblesidx_mailing_cibles_emailCREATE INDEX idx_mailing_cibles_email ON llx_mailing_cibles USING btree (email)
    publicllx_menuidx_menu_menuhandler_typeCREATE INDEX idx_menu_menuhandler_type ON llx_menu USING btree (menu_handler. type)
    publicllx_opensurvey_commentsidx_id_commentCREATE INDEX idx_id_comment ON llx_opensurvey_comments USING btree (id_comment)
    publicllx_opensurvey_commentsidx_id_sondageCREATE INDEX idx_id_sondage ON llx_opensurvey_comments USING btree (id_sondage)
    publicllx_opensurvey_sondageidx_date_finCREATE INDEX idx_date_fin ON llx_opensurvey_sondage USING btree (date_fin)
    publicllx_opensurvey_sondageidx_id_sondage_adminCREATE INDEX idx_id_sondage_admin ON llx_opensurvey_sondage USING btree (id_sondage_admin)
    publicllx_opensurvey_user_studsidx_opensurvey_user_studs_id_sondageCREATE INDEX idx_opensurvey_user_studs_id_sondage ON llx_opensurvey_user_studs USING btree (id_sondage)
    publicllx_opensurvey_user_studsidx_opensurvey_user_studs_id_usersCREATE INDEX idx_opensurvey_user_studs_id_users ON llx_opensurvey_user_studs USING btree (id_users)
    publicllx_opensurvey_user_studsidx_opensurvey_user_studs_nomCREATE INDEX idx_opensurvey_user_studs_nom ON llx_opensurvey_user_studs USING btree (nom)
    publicllx_paiementfourn_facturefournidx_paiementfourn_facturefourn_fk_paiementCREATE INDEX idx_paiementfourn_facturefourn_fk_paiement ON llx_paiementfourn_facturefourn USING btree (fk_paiementfourn)
    publicllx_prelevement_factureidx_prelevement_facture_fk_prelevement_lignesCREATE INDEX idx_prelevement_facture_fk_prelevement_lignes ON llx_prelevement_facture USING btree (fk_prelevement_lignes)
    publicllx_prelevement_lignesidx_prelevement_lignes_fk_prelevement_bonsCREATE INDEX idx_prelevement_lignes_fk_prelevement_bons ON llx_prelevement_lignes USING btree (fk_prelevement_bons)
    publicllx_productidx_product_barcodeCREATE INDEX idx_product_barcode ON llx_product USING btree (barcode)
    publicllx_productidx_product_import_keyCREATE INDEX idx_product_import_key ON llx_product USING btree (import_key)
    publicllx_productidx_product_labelCREATE INDEX idx_product_label ON llx_product USING btree (label)
    publicllx_product_associationidx_product_association_filsCREATE INDEX idx_product_association_fils ON llx_product_association USING btree (fk_product_fils)
    publicllx_product_extrafieldsidx_product_extrafieldsCREATE INDEX idx_product_extrafields ON llx_product_extrafields USING btree (fk_object)
    publicllx_product_fournisseur_priceidx_product_fourn_price_fk_productCREATE INDEX idx_product_fourn_price_fk_product ON llx_product_fournisseur_price USING btree (fk_product. entity)
    publicllx_product_fournisseur_priceidx_product_fourn_price_fk_socCREATE INDEX idx_product_fourn_price_fk_soc ON llx_product_fournisseur_price USING btree (fk_soc. entity)
    publicllx_product_fournisseur_priceidx_product_fournisseur_price_fk_userCREATE INDEX idx_product_fournisseur_price_fk_user ON llx_product_fournisseur_price USING btree (fk_user)
    publicllx_product_price_by_qtyidx_product_price_by_qty_fk_product_priceCREATE INDEX idx_product_price_by_qty_fk_product_price ON llx_product_price_by_qty USING btree (fk_product_price)
    publicllx_product_stockidx_product_stock_fk_entrepotCREATE INDEX idx_product_stock_fk_entrepot ON llx_product_stock USING btree (fk_entrepot)
    publicllx_product_stockidx_product_stock_fk_productCREATE INDEX idx_product_stock_fk_product ON llx_product_stock USING btree (fk_product)
    publicllx_projetidx_projet_fk_socCREATE INDEX idx_projet_fk_soc ON llx_projet USING btree (fk_soc)
    publicllx_projet_extrafieldsidx_projet_extrafieldsCREATE INDEX idx_projet_extrafields ON llx_projet_extrafields USING btree (fk_object)
    publicllx_projet_taskidx_projet_task_fk_projetCREATE INDEX idx_projet_task_fk_projet ON llx_projet_task USING btree (fk_projet)
    publicllx_projet_taskidx_projet_task_fk_user_creatCREATE INDEX idx_projet_task_fk_user_creat ON llx_projet_task USING btree (fk_user_creat)
    publicllx_projet_taskidx_projet_task_fk_user_validCREATE INDEX idx_projet_task_fk_user_valid ON llx_projet_task USING btree (fk_user_valid)
    publicllx_projet_task_extrafieldsidx_projet_task_extrafieldsCREATE INDEX idx_projet_task_extrafields ON llx_projet_task_extrafields USING btree (fk_object)
    publicllx_propalidx_propal_fk_accountCREATE INDEX idx_propal_fk_account ON llx_propal USING btree (fk_account)
    publicllx_propalidx_propal_fk_user_authorCREATE INDEX idx_propal_fk_user_author ON llx_propal USING btree (fk_user_author)
    publicllx_propalidx_propal_fk_user_clotureCREATE INDEX idx_propal_fk_user_cloture ON llx_propal USING btree (fk_user_cloture)
    publicllx_propalidx_propal_fk_user_validCREATE INDEX idx_propal_fk_user_valid ON llx_propal USING btree (fk_user_valid)
    publicllx_societeidx_societe_user_creatCREATE INDEX idx_societe_user_creat ON llx_societe USING btree (fk_user_creat)
    publicllx_societeidx_societe_user_modifCREATE INDEX idx_societe_user_modif ON llx_societe USING btree (fk_user_modif)
    publicllx_societe_extrafieldsidx_societe_extrafieldsCREATE INDEX idx_societe_extrafields ON llx_societe_extrafields USING btree (fk_object)
    publicllx_societe_remise_exceptidx_societe_remise_except_fk_userCREATE INDEX idx_societe_remise_except_fk_user ON llx_societe_remise_except USING btree (fk_user)
    publicllx_socpeopleidx_socpeople_fk_user_creatCREATE INDEX idx_socpeople_fk_user_creat ON llx_socpeople USING btree (fk_user_creat)
    publicllx_socpeople_extrafieldsidx_socpeople_extrafieldsCREATE INDEX idx_socpeople_extrafields ON llx_socpeople_extrafields USING btree (fk_object)
    publicllx_stock_mouvementidx_stock_mouvement_fk_entrepotCREATE INDEX idx_stock_mouvement_fk_entrepot ON llx_stock_mouvement USING btree (fk_entrepot)
    publicllx_stock_mouvementidx_stock_mouvement_fk_productCREATE INDEX idx_stock_mouvement_fk_product ON llx_stock_mouvement USING btree (fk_product)
    publicllx_useruk_user_fk_societeCREATE INDEX uk_user_fk_societe ON llx_user USING btree (fk_societe)
    publicllx_user_extrafieldsidx_user_extrafieldsCREATE INDEX idx_user_extrafields ON llx_user_extrafields USING btree (fk_object)
    publicllx_usergroup_userfk_usergroup_user_fk_userCREATE INDEX fk_usergroup_user_fk_user ON llx_usergroup_user USING btree (fk_user)
    publicllx_usergroup_userfk_usergroup_user_fk_usergroupCREATE INDEX fk_usergroup_user_fk_usergroup ON llx_usergroup_user USING btree (fk_usergroup)

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.