Changeset 16
- Timestamp:
- 07/01/08 18:14:16 (10 years ago)
- Files:
-
- trunk/table_growth/otools.collect_table_growth.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/table_growth/otools.collect_table_growth.sql
r15 r16 3 3 as $$ 4 4 insert into otools.table_growth (table_owner, schema_name, table_name, actual_size, growth_size, sum_flag, capture_time) 5 select pg_get_userbyid(c.relowner) AS table_owner, n.nspname AS schema_name, c.relname AS table_name, pg_ relation_size(c.oid), 0, 0, current_date5 select pg_get_userbyid(c.relowner) AS table_owner, n.nspname AS schema_name, c.relname AS table_name, pg_total_relation_size(c.oid), 0, 0, current_date 6 6 from pg_class c JOIN pg_namespace n ON (c.relnamespace=n.oid) where relkind = 'r' and reltuples > 25000; 7 7 $$ language sql;