Show
Ignore:
Timestamp:
12/03/08 17:25:11 (5 years ago)
Author:
denish
Message:

Fix to remove duplicate rows from table growth monitor report.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/table_growth/otools.summarize_table_growth.sql

    r19 r26  
    2525    from otools.table_growth a  
    2626    where sum_flag=1 and capture_time between (current_date - '1 month'::interval) and current_date  
    27     group by table_owner, schema_name, table_name, actual_size
     27    group by table_owner, schema_name, table_name
    2828    -- now remove older rows 
    2929    delete from otools.table_growth where sum_flag = 1;