Index read/fetch on dolibarr database indexes
Number of index entries returned by index scans, and number of live table rows fetched by simple index scans using that index during the audit period
Schema.Table.Index | Index scan | Index entries returned | Live table rows fetched |
---|---|---|---|
public.llx_actioncomm.idx_actioncomm_fk_contact | 2 | 2 | 2 |
public.llx_actioncomm.idx_actioncomm_fk_soc | 4 | 4 | 4 |
public.llx_actioncomm.llx_actioncomm_pkey | 2 | 2 | 2 |
public.llx_agefodd_convention.idx_fk_societe_conv | 10 | 18 | 18 |
public.llx_agefodd_convention.llx_agefodd_convention_pkey | 1 | 1 | 1 |
public.llx_agefodd_facture.idx_fk_commande_fac | 80 | 80 | 80 |
public.llx_agefodd_facture.idx_fk_facture_fac | 80 | 80 | 80 |
public.llx_agefodd_formation_catalogue.llx_agefodd_formation_catalogue_pkey | 7 | 7 | 7 |
public.llx_agefodd_session.fk_soc_session | 6 | 6 | 6 |
public.llx_agefodd_session.llx_agefodd_session_pkey | 20 | 20 | 20 |
public.llx_agefodd_session_adminsitu.fk_agefodd_session_adminsitu | 8 | 136 | 136 |
public.llx_agefodd_session_calendrier.idx_fk_agefodd_session_cal | 2 | 12 | 12 |
public.llx_agefodd_session_stagiaire.fk_session_sess_sta | 11 | 36 | 36 |
public.llx_agefodd_stagiaire.fk_soc_sta | 10 | 10 | 10 |
public.llx_agefodd_stagiaire.llx_agefodd_stagiaire_pkey | 20 | 45 | 45 |
public.llx_bank.idx_bank_fk_account | 12 | 7696 | 7696 |
public.llx_bank.llx_bank_pkey | 4 | 4 | 4 |
public.llx_c_departements.llx_c_departements_pkey | 21 | 12 | 12 |
public.llx_c_pays.llx_c_pays_pkey | 17 | 17 | 17 |
public.llx_commande.idx_commande_fk_soc | 2 | 2 | 2 |
public.llx_commande.llx_commande_pkey | 40 | 40 | 40 |
public.llx_commandedet.idx_commandedet_fk_product | 10 | 10 | 10 |
public.llx_element_contact.idx_element_contact_fk_socpeople | 1 | 0 | 0 |
public.llx_extrafields.uk_extrafields_name | 102 | 0 | 0 |
public.llx_facture.idx_facture_fk_soc | 4 | 4 | 4 |
public.llx_facture.llx_facture_pkey | 86 | 85 | 85 |
public.llx_facture_fourn.idx_facture_fourn_fk_soc | 34 | 34 | 34 |
public.llx_facture_fourn.llx_facture_fourn_pkey | 16 | 16 | 16 |
public.llx_facture_fourn.uk_facture_fourn_ref | 12 | 12 | 12 |
public.llx_facture_fourn_det.idx_facture_fourn_det_fk_facture | 16 | 16 | 16 |
public.llx_facture_fourn_det.llx_facture_fourn_det_pkey | 1 | 1 | 1 |
public.llx_facturedet.idx_facturedet_fk_facture | 5 | 5 | 5 |
public.llx_facturedet.idx_facturedet_fk_product | 10 | 10 | 10 |
public.llx_paiementfourn.llx_paiementfourn_pkey | 4 | 4 | 4 |
public.llx_paiementfourn_facturefourn.idx_paiementfourn_facturefourn_fk_facture | 22 | 1 | 1 |
public.llx_paiementfourn_facturefourn.uk_paiementfourn_facturefourn | 4 | 4 | 4 |
public.llx_product.llx_product_pkey | 51 | 35 | 35 |
public.llx_propal.idx_propal_fk_soc | 2 | 2 | 2 |
public.llx_propal.llx_propal_pkey | 43 | 11 | 11 |
public.llx_propaldet.idx_propaldet_fk_product | 6 | 6 | 6 |
public.llx_propaldet.idx_propaldet_fk_propal | 3 | 3 | 3 |
public.llx_rights_def.llx_rights_def_pkey | 2655 | 2580 | 2580 |
public.llx_societe.llx_societe_pkey | 228 | 221 | 221 |
public.llx_socpeople.idx_socpeople_fk_soc | 12 | 12 | 12 |
public.llx_socpeople.llx_socpeople_pkey | 56 | 20 | 20 |
public.llx_user.llx_user_pkey | 19 | 19 | 19 |
public.llx_user_param.uk_user_param | 17 | 0 | 0 |
public.llx_user_rights.uk_user_rights | 15 | 1885 | 0 |