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 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_contact222
    public.llx_actioncomm.idx_actioncomm_fk_soc444
    public.llx_actioncomm.llx_actioncomm_pkey222
    public.llx_agefodd_convention.idx_fk_societe_conv101818
    public.llx_agefodd_convention.llx_agefodd_convention_pkey111
    public.llx_agefodd_facture.idx_fk_commande_fac808080
    public.llx_agefodd_facture.idx_fk_facture_fac808080
    public.llx_agefodd_formation_catalogue.llx_agefodd_formation_catalogue_pkey777
    public.llx_agefodd_session.fk_soc_session666
    public.llx_agefodd_session.llx_agefodd_session_pkey202020
    public.llx_agefodd_session_adminsitu.fk_agefodd_session_adminsitu8136136
    public.llx_agefodd_session_calendrier.idx_fk_agefodd_session_cal21212
    public.llx_agefodd_session_stagiaire.fk_session_sess_sta113636
    public.llx_agefodd_stagiaire.fk_soc_sta101010
    public.llx_agefodd_stagiaire.llx_agefodd_stagiaire_pkey204545
    public.llx_bank.idx_bank_fk_account1276967696
    public.llx_bank.llx_bank_pkey444
    public.llx_c_departements.llx_c_departements_pkey211212
    public.llx_c_pays.llx_c_pays_pkey171717
    public.llx_commande.idx_commande_fk_soc222
    public.llx_commande.llx_commande_pkey404040
    public.llx_commandedet.idx_commandedet_fk_product101010
    public.llx_element_contact.idx_element_contact_fk_socpeople100
    public.llx_extrafields.uk_extrafields_name10200
    public.llx_facture.idx_facture_fk_soc444
    public.llx_facture.llx_facture_pkey868585
    public.llx_facture_fourn.idx_facture_fourn_fk_soc343434
    public.llx_facture_fourn.llx_facture_fourn_pkey161616
    public.llx_facture_fourn.uk_facture_fourn_ref121212
    public.llx_facture_fourn_det.idx_facture_fourn_det_fk_facture161616
    public.llx_facture_fourn_det.llx_facture_fourn_det_pkey111
    public.llx_facturedet.idx_facturedet_fk_facture555
    public.llx_facturedet.idx_facturedet_fk_product101010
    public.llx_paiementfourn.llx_paiementfourn_pkey444
    public.llx_paiementfourn_facturefourn.idx_paiementfourn_facturefourn_fk_facture2211
    public.llx_paiementfourn_facturefourn.uk_paiementfourn_facturefourn444
    public.llx_product.llx_product_pkey513535
    public.llx_propal.idx_propal_fk_soc222
    public.llx_propal.llx_propal_pkey431111
    public.llx_propaldet.idx_propaldet_fk_product666
    public.llx_propaldet.idx_propaldet_fk_propal333
    public.llx_rights_def.llx_rights_def_pkey265525802580
    public.llx_societe.llx_societe_pkey228221221
    public.llx_socpeople.idx_socpeople_fk_soc121212
    public.llx_socpeople.llx_socpeople_pkey562020
    public.llx_user.llx_user_pkey191919
    public.llx_user_param.uk_user_param1700
    public.llx_user_rights.uk_user_rights1518850

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.