• Home
  • SysInfo
  • Cluster
    • Databases sizes
    • Tablespaces sizes
    • Connections
      • Connections
      • Connections by type
    • Deadlocks
    • Cache utilization
    • Shared buffers statistics
      • Shared buffers utilization
      • Database in shared buffers
      • Usagecount in shared buffers
      • Usagecount in dirty buffers
    • Background writer
      • Bgwriter buffers written
      • Bgwriter buffers allocated
      • Bgwriter 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
    • Transaction throughput
    • Prepared transactions
    • Replication statistics
      • Wal bytes written
      • Replication lag
      • Canceled queries
      • Conflicts
    • Configurations
      • PostgreSQL configuration
      • PostgreSQL settings
      • PostgreSQL non default settings
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • postgres
      • Database info
      • Partitionned Tables
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Tables I/O stats
      • Indexes statistics
        • Size and tuples
        • Number of indexes
      • Buffercache 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
      • Transaction thoughput
      • Prepared transactions
      • Canceled queries
      • Conflicts
  • System
    • Cpu
    • Memory
    • Dirty memory
    • Swap
    • Memory workload
    • Load
    • Task list
    • Run queue
    • Context switches
    • Tasks created per second
    • Blocks
    • Transfers per second
    • Pages
      • Pages in/out
      • Pages faults
      • Pages scan
    • Devices
      • xvda
        • Cpu utilization
        • Read/write bytes per second
        • Transfert per second
        • Average I/O wait time
    • Network
      • eth0
        • Network utilization
        • Network errors
      • lo
        • Network utilization
        • Network errors
      • TCP
        • TCP utilization
        • TCP errors
    • Disk space use
      • Device xvda1
    • PostgreSQL
      • CPU
      • Context switches
      • Memory
      • Percent Memory use
      • Pages faults
      • I/O delay
      • Kb I/O
  • About

    Index scan ratio on postgres database tables

    Number of sequential scan versus index scan per table during the audit period.

    Schema.Table Sequencial scan Index scan Index vs Sequencial
    public.test1150.00%

Report generated by pgCluu 3.3.

Right click + "Save image as ..." to save the graph as PNG image