• 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
      • Background writer buffers
      • Background writer counters
    • Temporary files
      • Temporary files
      • Temporary files size
    • Wal / Checkpoint
      • Wal files
      • Wal bytes written
      • 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
      • Database/Roles settings
      • PostgreSQL ALTER SYSTEM configuration
      • PostgreSQL recovery configuration
      • PostgreSQL authorization
      • User Name Maps
      • Pgbouncer settings
  • Databases
    • engine
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing 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
      • Canceled queries
      • Conflicts
    • engine2
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing 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
      • Canceled queries
      • Conflicts
    • engine_dao_tests
      • Database info
      • Tables statistics
        • Size and tuples
      • Indexes statistics
        • Size and tuples
        • Unused Indexes
        • Redundant indexes
        • Missing 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
      • Canceled queries
      • Conflicts
    • postgres
      • Database info
      • 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
      • Canceled queries
      • Conflicts
  • About




  • Size of engine2 database

    Database sizes.





  • Connections by type on engine2 database

    Connections by type including idle ones.





  • Affected tuples per operation on engine2 database

    Affected rows on databases grouped by statement family.





  • Cache hit/miss ratio on engine2 database

    Per database cache hit/miss ratio.





  • Commits/Rollbacks per second on engine2 database

    Number of commits / rollbacks per second and number of backends per database.





  • Write ratio on engine2 database

    Write ratio on databases excluding templates and postgres.





  • Read tuples on engine2 database

    Show entries returned from the index and live rows fetched from the tables. The latter will be less if any dead or not-yet-committed rows are fetched using the index.





  • Number of deadlocks on engine2 database

    Number of deadlocks detected in this database.





  • Number of canceled queries on engine2 database

    Number of queries canceled due to conflicts with recovery in this database. [Conflicts occur only on standby servers]





  • Number of temporary files on engine2 database

    Number of temporary files created by queries per database.





  • Size of temporary data on engine2 database

    Amount of data written to temporary files created by queries per database.




  • Database engine2

    • 24.87 MB Total size
    • 0 Installed extensions
    • 0 Schemas
    • - Last manual vacuum
    • - Last manual analyze
    • 0 Stored procedures
    • 0 Triggers
    • 17 sequences
    • 22 composite types
    • 389 indexes
    • 154 tables
    • 104 toast tables
    • 124 views

© Gilles Darold 2012-2015

Report generated by pgCluu 2.4.