PGSnap 0.2.0

General

Installed products
pg_config
pg_controldata
General configuration
Autovacuum configuration
Last log file

Global Objects

Databases
Databases in cache
Roles
Users' Objects
Users Space allocated
Tablespaces
Tablespaces' objects
Large Objects

Database Objects

Schemas
Tables
Tables in cache
Fragmented Tables
Tables Without PKEY
Tables With 5+ indexes
Tables With FKEY constraints
Views
Sequences
Indexes
Fragmented Indexes
Functions
Languages

Activities

Sessions
Process
Locks
Cursors
Prepared statements
Prepared transactions

Statistics

bgwriter
Cache hit ratio
Databases
Tables
Last vacuumed Tables
Last analyzed Tables
Indexes

Other tools

pgPool-II
pgBouncer
Slony