Changeset 142 for trunk/tools

Show
Ignore:
Timestamp:
05/19/10 19:34:43 (4 years ago)
Author:
ssteinpreis
Message:

Modified to include as follows in order to have report maintain consistent 'snapshot' while checking for bloat. print $fh begin; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;\n;

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/tools/pg_bloat_report.pl

    r141 r142  
    251251  ) AS rs 
    252252  JOIN pg_class cc ON cc.relname = rs.tablename and cc.relkind = 'r' 
    253   JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' AND nn.nspname !~ '^pg_temp' 
     253  JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' AND nn.nspname !~ '^pg_temp' 
    254254) AS sml 
    255255WHERE sml.relpages - otta > 128