root/trunk/table_growth/table_growth_report.sh

Revision 14, 382 bytes (checked in by robert, 6 years ago)

table growth monitor for pg

Line 
1 select 'Top 10 Tables Growth For:-  '||to_char(current_date - '1 month'::interval,'Mon-YYYY') as Month ;
2
3 select
4     table_owner, schema_name, table_name, growth_size as Growth_size_MB
5 from
6     otools.table_growth
7 where
8     sum_flag = 2
9     and
10     to_char(capture_time,'mm')=to_char((current_date - '1 month'::interval),'mm')
11 order by
12     growth_size desc
13 limit
14     10;
Note: See TracBrowser for help on using the browser.