Index scan ratio on dolibarr database tables
Number of Sequencial scan versus index scan per table during the audit period
Schema.Table | Sequencial scan | Index scan | Index vs Sequencial |
---|---|---|---|
public.llx_actioncomm | 3 | 8 | 72.73% |
public.llx_agefodd_contact | 10 | 0 | 0.00% |
public.llx_agefodd_convention | 0 | 11 | 100.00% |
public.llx_agefodd_facture | 42 | 160 | 79.21% |
public.llx_agefodd_formateur | 2 | 0 | 0.00% |
public.llx_agefodd_formation_catalogue | 11 | 7 | 38.89% |
public.llx_agefodd_opca | 25 | 0 | 0.00% |
public.llx_agefodd_place | 10 | 0 | 0.00% |
public.llx_agefodd_session | 28 | 26 | 48.15% |
public.llx_agefodd_session_adminsitu | 5 | 8 | 61.54% |
public.llx_agefodd_session_calendrier | 0 | 2 | 100.00% |
public.llx_agefodd_session_commercial | 5 | 0 | 0.00% |
public.llx_agefodd_session_contact | 5 | 0 | 0.00% |
public.llx_agefodd_session_formateur | 2 | 0 | 0.00% |
public.llx_agefodd_session_stagiaire | 8 | 11 | 57.89% |
public.llx_agefodd_stagiaire | 13 | 30 | 69.77% |
public.llx_agefodd_stagiaire_type | 2 | 0 | 0.00% |
public.llx_bank | 1 | 16 | 94.12% |
public.llx_bank_account | 3 | 0 | 0.00% |
public.llx_bookmark | 16 | 0 | 0.00% |
public.llx_boxes | 1 | 0 | 0.00% |
public.llx_boxes_def | 1 | 0 | 0.00% |
public.llx_c_actioncomm | 5 | 0 | 0.00% |
public.llx_c_availability | 16 | 0 | 0.00% |
public.llx_c_civilite | 11 | 0 | 0.00% |
public.llx_c_departements | 0 | 21 | 100.00% |
public.llx_c_effectif | 12 | 0 | 0.00% |
public.llx_c_forme_juridique | 6 | 0 | 0.00% |
public.llx_c_input_reason | 16 | 0 | 0.00% |
public.llx_c_paiement | 17 | 0 | 0.00% |
public.llx_c_payment_term | 17 | 0 | 0.00% |
public.llx_c_pays | 14 | 17 | 54.84% |
public.llx_c_propalst | 6 | 0 | 0.00% |
public.llx_c_stcomm | 12 | 0 | 0.00% |
public.llx_c_tva | 18 | 0 | 0.00% |
public.llx_c_type_contact | 1 | 0 | 0.00% |
public.llx_c_typent | 12 | 0 | 0.00% |
public.llx_commande | 48 | 42 | 46.67% |
public.llx_commande_fournisseur | 2 | 0 | 0.00% |
public.llx_commandedet | 5 | 10 | 66.67% |
public.llx_const | 22 | 0 | 0.00% |
public.llx_contrat | 4 | 0 | 0.00% |
public.llx_contratdet | 9 | 0 | 0.00% |
public.llx_document_model | 2 | 0 | 0.00% |
public.llx_element_contact | 0 | 1 | 100.00% |
public.llx_element_element | 2 | 0 | 0.00% |
public.llx_extrafields | 0 | 102 | 100.00% |
public.llx_facture | 4 | 90 | 95.74% |
public.llx_facture_fourn | 5 | 62 | 92.54% |
public.llx_facture_fourn_det | 0 | 17 | 100.00% |
public.llx_facturedet | 0 | 15 | 100.00% |
public.llx_menu | 15 | 0 | 0.00% |
public.llx_paiementfourn | 0 | 4 | 100.00% |
public.llx_paiementfourn_facturefourn | 0 | 26 | 100.00% |
public.llx_product | 3 | 51 | 94.44% |
public.llx_product_fournisseur_price | 1 | 0 | 0.00% |
public.llx_propal | 4 | 45 | 91.84% |
public.llx_propaldet | 0 | 9 | 100.00% |
public.llx_rights_def | 15 | 2655 | 99.44% |
public.llx_societe | 15 | 228 | 93.83% |
public.llx_socpeople | 8 | 68 | 89.47% |
public.llx_user | 45 | 19 | 29.69% |
public.llx_user_alert | 1 | 0 | 0.00% |
public.llx_user_param | 0 | 17 | 100.00% |
public.llx_user_rights | 0 | 15 | 100.00% |
public.llx_usergroup_rights | 15 | 0 | 0.00% |
public.llx_usergroup_user | 15 | 0 | 0.00% |