Changeset 49

Show
Ignore:
Timestamp:
08/25/09 15:24:39 (5 years ago)
Author:
depesz
Message:

make tables report return really only tables

Files:

Legend:

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

    r46 r49  
    249249    ) AS foo 
    250250  ) AS rs 
    251   JOIN pg_class cc ON cc.relname = rs.tablename 
     251  JOIN pg_class cc ON cc.relname = rs.tablename and cc.relkind = 'r' 
    252252  JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname = rs.schemaname AND nn.nspname <> 'information_schema' 
    253253) AS sml