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

    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_actioncomm3872.73%
    public.llx_agefodd_contact1000.00%
    public.llx_agefodd_convention011100.00%
    public.llx_agefodd_facture4216079.21%
    public.llx_agefodd_formateur200.00%
    public.llx_agefodd_formation_catalogue11738.89%
    public.llx_agefodd_opca2500.00%
    public.llx_agefodd_place1000.00%
    public.llx_agefodd_session282648.15%
    public.llx_agefodd_session_adminsitu5861.54%
    public.llx_agefodd_session_calendrier02100.00%
    public.llx_agefodd_session_commercial500.00%
    public.llx_agefodd_session_contact500.00%
    public.llx_agefodd_session_formateur200.00%
    public.llx_agefodd_session_stagiaire81157.89%
    public.llx_agefodd_stagiaire133069.77%
    public.llx_agefodd_stagiaire_type200.00%
    public.llx_bank11694.12%
    public.llx_bank_account300.00%
    public.llx_bookmark1600.00%
    public.llx_boxes100.00%
    public.llx_boxes_def100.00%
    public.llx_c_actioncomm500.00%
    public.llx_c_availability1600.00%
    public.llx_c_civilite1100.00%
    public.llx_c_departements021100.00%
    public.llx_c_effectif1200.00%
    public.llx_c_forme_juridique600.00%
    public.llx_c_input_reason1600.00%
    public.llx_c_paiement1700.00%
    public.llx_c_payment_term1700.00%
    public.llx_c_pays141754.84%
    public.llx_c_propalst600.00%
    public.llx_c_stcomm1200.00%
    public.llx_c_tva1800.00%
    public.llx_c_type_contact100.00%
    public.llx_c_typent1200.00%
    public.llx_commande484246.67%
    public.llx_commande_fournisseur200.00%
    public.llx_commandedet51066.67%
    public.llx_const2200.00%
    public.llx_contrat400.00%
    public.llx_contratdet900.00%
    public.llx_document_model200.00%
    public.llx_element_contact01100.00%
    public.llx_element_element200.00%
    public.llx_extrafields0102100.00%
    public.llx_facture49095.74%
    public.llx_facture_fourn56292.54%
    public.llx_facture_fourn_det017100.00%
    public.llx_facturedet015100.00%
    public.llx_menu1500.00%
    public.llx_paiementfourn04100.00%
    public.llx_paiementfourn_facturefourn026100.00%
    public.llx_product35194.44%
    public.llx_product_fournisseur_price100.00%
    public.llx_propal44591.84%
    public.llx_propaldet09100.00%
    public.llx_rights_def15265599.44%
    public.llx_societe1522893.83%
    public.llx_socpeople86889.47%
    public.llx_user451929.69%
    public.llx_user_alert100.00%
    public.llx_user_param017100.00%
    public.llx_user_rights015100.00%
    public.llx_usergroup_rights1500.00%
    public.llx_usergroup_user1500.00%

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.