Live vs dead tuples on dolibarr database tables
Number of live and dead tuples per table at end of the audit period
| Schema.Table | Live tuples | Dead tuples | Dead vs Live |
|---|---|---|---|
| public.llx_accounting_system | 2 | 0 | 0.00% |
| public.llx_accountingaccount | 438 | 0 | 0.00% |
| public.llx_actioncomm | 4337 | 0 | 0.00% |
| public.llx_agefodd_calendrier | 6 | 0 | 0.00% |
| public.llx_agefodd_contact | 12 | 0 | 0.00% |
| public.llx_agefodd_convention | 51 | 0 | 0.00% |
| public.llx_agefodd_facture | 79 | 7 | 8.14% |
| public.llx_agefodd_formateur | 12 | 0 | 0.00% |
| public.llx_agefodd_formation_catalogue | 10 | 2 | 16.67% |
| public.llx_agefodd_formation_objectifs_peda | 43 | 0 | 0.00% |
| public.llx_agefodd_place | 7 | 0 | 0.00% |
| public.llx_agefodd_session | 64 | 17 | 20.99% |
| public.llx_agefodd_session_adminsitu | 1088 | 20 | 1.81% |
| public.llx_agefodd_session_admlevel | 5 | 0 | 0.00% |
| public.llx_agefodd_session_calendrier | 312 | 6 | 1.89% |
| public.llx_agefodd_session_commercial | 64 | 0 | 0.00% |
| public.llx_agefodd_session_contact | 16 | 0 | 0.00% |
| public.llx_agefodd_session_formateur | 58 | 1 | 1.69% |
| public.llx_agefodd_session_stagiaire | 272 | 6 | 2.16% |
| public.llx_agefodd_stagiaire | 233 | 4 | 1.69% |
| public.llx_agefodd_stagiaire_type | 6 | 0 | 0.00% |
| public.llx_agefodd_training_admlevel | 170 | 0 | 0.00% |
| public.llx_bank | 3789 | 53 | 1.38% |
| public.llx_bank_account | 5 | 0 | 0.00% |
| public.llx_bank_categ | 5 | 0 | 0.00% |
| public.llx_bank_class | 3267 | 0 | 0.00% |
| public.llx_bank_url | 7446 | 6 | 0.08% |
| public.llx_bookmark | 3 | 0 | 0.00% |
| public.llx_bordereau_cheque | 79 | 6 | 7.06% |
| public.llx_boxes | 13 | 26 | 66.67% |
| public.llx_boxes_def | 19 | 0 | 0.00% |
| public.llx_c_action_trigger | 26 | 0 | 0.00% |
| public.llx_c_actioncomm | 21 | 0 | 0.00% |
| public.llx_c_availability | 4 | 0 | 0.00% |
| public.llx_c_barcode_type | 6 | 0 | 0.00% |
| public.llx_c_chargesociales | 13 | 0 | 0.00% |
| public.llx_c_civilite | 4 | 0 | 0.00% |
| public.llx_c_currencies | 137 | 0 | 0.00% |
| public.llx_c_departements | 449 | 0 | 0.00% |
| public.llx_c_ecotaxe | 38 | 0 | 0.00% |
| public.llx_c_effectif | 7 | 0 | 0.00% |
| public.llx_c_field_list | 8 | 0 | 0.00% |
| public.llx_c_forme_juridique | 131 | 0 | 0.00% |
| public.llx_c_input_method | 5 | 0 | 0.00% |
| public.llx_c_input_reason | 11 | 0 | 0.00% |
| public.llx_c_paiement | 12 | 0 | 0.00% |
| public.llx_c_paper_format | 19 | 0 | 0.00% |
| public.llx_c_payment_term | 7 | 0 | 0.00% |
| public.llx_c_pays | 247 | 0 | 0.00% |
| public.llx_c_propalst | 5 | 0 | 0.00% |
| public.llx_c_prospectlevel | 4 | 0 | 0.00% |
| public.llx_c_regions | 123 | 0 | 0.00% |
| public.llx_c_revenuestamp | 1 | 0 | 0.00% |
| public.llx_c_shipment_mode | 8 | 0 | 0.00% |
| public.llx_c_stcomm | 5 | 0 | 0.00% |
| public.llx_c_tva | 89 | 0 | 0.00% |
| public.llx_c_type_contact | 41 | 0 | 0.00% |
| public.llx_c_type_fees | 3 | 0 | 0.00% |
| public.llx_c_typent | 10 | 0 | 0.00% |
| public.llx_chargesociales | 2 | 0 | 0.00% |
| public.llx_commande | 104 | 0 | 0.00% |
| public.llx_commande_fournisseur | 11 | 0 | 0.00% |
| public.llx_commande_fournisseur_log | 49 | 0 | 0.00% |
| public.llx_commande_fournisseurdet | 42 | 0 | 0.00% |
| public.llx_commandedet | 153 | 0 | 0.00% |
| public.llx_const | 274 | 12 | 4.20% |
| public.llx_contrat | 2 | 0 | 0.00% |
| public.llx_contratdet | 3 | 0 | 0.00% |
| public.llx_document_model | 10 | 0 | 0.00% |
| public.llx_don | 2 | 0 | 0.00% |
| public.llx_element_contact | 700 | 1 | 0.14% |
| public.llx_element_element | 299 | 4 | 1.32% |
| public.llx_entity | 1 | 0 | 0.00% |
| public.llx_export_model | 1 | 0 | 0.00% |
| public.llx_facture | 756 | 35 | 4.42% |
| public.llx_facture_fourn | 3202 | 264 | 7.62% |
| public.llx_facture_fourn_det | 5397 | 23 | 0.42% |
| public.llx_facture_rec | 3 | 0 | 0.00% |
| public.llx_facturedet | 1323 | 8 | 0.60% |
| public.llx_facturedet_rec | 3 | 0 | 0.00% |
| public.llx_fichinter | 4 | 0 | 0.00% |
| public.llx_fichinterdet | 9 | 0 | 0.00% |
| public.llx_holiday | 2 | 4 | 66.67% |
| public.llx_holiday_config | 8 | 46 | 85.19% |
| public.llx_holiday_logs | 2 | 0 | 0.00% |
| public.llx_holiday_users | 15 | 2 | 11.76% |
| public.llx_menu | 270 | 0 | 0.00% |
| public.llx_paiement | 552 | 1 | 0.18% |
| public.llx_paiement_facture | 594 | 0 | 0.00% |
| public.llx_paiementcharge | 2 | 0 | 0.00% |
| public.llx_paiementfourn | 3183 | 5 | 0.16% |
| public.llx_paiementfourn_facturefourn | 3259 | 2 | 0.06% |
| public.llx_product | 92 | 7 | 7.07% |
| public.llx_product_fournisseur_price | 1 | 0 | 0.00% |
| public.llx_product_fournisseur_price_log | 1 | 0 | 0.00% |
| public.llx_product_price | 257 | 0 | 0.00% |
| public.llx_propal | 600 | 68 | 10.18% |
| public.llx_propal_merge_pdf_product | 2 | 0 | 0.00% |
| public.llx_propaldet | 1181 | 43 | 3.51% |
| public.llx_rights_def | 130 | 0 | 0.00% |
| public.llx_societe | 526 | 19 | 3.49% |
| public.llx_societe_commerciaux | 408 | 0 | 0.00% |
| public.llx_societe_remise | 10 | 0 | 0.00% |
| public.llx_societe_remise_except | 56 | 1 | 1.75% |
| public.llx_societe_rib | 3 | 0 | 0.00% |
| public.llx_socpeople | 632 | 21 | 3.22% |
| public.llx_tva | 2 | 0 | 0.00% |
| public.llx_user | 15 | 15 | 50.00% |
| public.llx_user_rights | 713 | 0 | 0.00% |
| public.llx_usergroup | 5 | 0 | 0.00% |
| public.llx_usergroup_rights | 197 | 0 | 0.00% |
| public.llx_usergroup_user | 26 | 0 | 0.00% |