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 mantis 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.mantis_bug_file_table.idx_bug_file_bug_id6525608228
    public.mantis_bug_file_table.mantis_bug_file_table_pkey171717
    public.mantis_bug_history_table.idx_bug_history_bug_id25926192501
    public.mantis_bug_monitor_table.mantis_bug_monitor_table_pkey646464
    public.mantis_bug_relationship_table.idx_relationship_destination522522522
    public.mantis_bug_relationship_table.idx_relationship_source518518518
    public.mantis_bug_revision_table.idx_bug_rev_id_time555
    public.mantis_bug_revision_table.mantis_bug_revision_table_pkey242424
    public.mantis_bug_table.idx_bug_status21967143779
    public.mantis_bug_table.idx_project75126860
    public.mantis_bug_table.mantis_bug_table_pkey420428200
    public.mantis_bug_text_table.mantis_bug_text_table_pkey212212212
    public.mantis_bugnote_table.idx_bug4945564706
    public.mantis_bugnote_table.mantis_bugnote_table_pkey1874940
    public.mantis_bugnote_text_table.mantis_bugnote_text_table_pkey260882604026040
    public.mantis_category_table.idx_category_project_name25942
    public.mantis_category_table.mantis_category_table_pkey565656
    public.mantis_custom_field_project_table.mantis_custom_field_project_table_pkey194194194
    public.mantis_custom_field_string_table.idx_custom_field_bug171515
    public.mantis_custom_field_table.mantis_custom_field_table_pkey172172172
    public.mantis_email_table.mantis_email_table_pkey252252252
    public.mantis_filters_table.mantis_filters_table_pkey353634
    public.mantis_project_hierarchy_table.idx_project_hierarchy_child_id444416416
    public.mantis_project_table.mantis_project_table_pkey150150150
    public.mantis_project_user_list_table.idx_project_user296296296
    public.mantis_project_user_list_table.mantis_project_user_list_table_pkey261948148
    public.mantis_sponsorship_table.idx_sponsorship_bug_id200
    public.mantis_user_table.idx_access448800
    public.mantis_user_table.idx_user_cookie_string144135129
    public.mantis_user_table.idx_user_username383938
    public.mantis_user_table.mantis_user_table_pkey10451045316

© Gilles Darold 2012-2014

Report generated by pgCluu 2.0.