• 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
    • Canceled queries
    • Replication statistics
      • Wal bytes written
      • Replication lag
      • 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
    • contrib_regression
      • Database info
      • Partitionned Tables
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
      • 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
    • gilles
      • Database info
      • Partitionned Tables
      • Tables statistics
        • Index scan ratio
        • Vacuums/analyzes
        • insert/update/delete
        • Live vs dead tuples
        • Size and tuples
        • Unlogged tables
        • Tables I/O stats
      • Indexes statistics
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • 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
    • pgbench
      • 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
        • Index read/fetch
        • Size and tuples
        • Indexes I/O stats
        • 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
    • postgres
      • Database info
      • Partitionned Tables
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
      • 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
    • TCP
      • TCP utilization
      • TCP errors
    • Disk space use
      • Device nvme0n1p1
      • Device nvme0n1p2
      • Device vgubuntu-root
    • PostgreSQL
      • CPU
      • Context switches
      • Memory
      • Percent Memory use
      • Pages faults
      • I/O delay
      • Kb I/O
  • About

    Index scan ratio on pgbench 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.pgbench_branches330099.01%

Report generated by pgCluu 3.4.

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