• 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

    Live vs dead tuples on pgbench database tables

    Number of live and dead tuples per table at end of the audit period.

    Schema.Table Live tuples Dead tuples Dead vs Live
    public.pgbench_accounts174440553.28%
    public.pgbench_history50364000.00%

Report generated by pgCluu 3.4.

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