JustinMcNamara74/goom_altered_tables.md

## goom_altered_tables.md

      
    Raw
  

              goom_altered_tables.md
            
          
    List all altered tabled

Run the command:

nz_alterd_tables

Sample Results:


Database
Schema
Table Name
Size (Bytes)
# Of Versions


DB1
SCHEMA1
TABLE1
59,506,688
2


DB2
SCHEMA2
TABLE2
1,538,129,920
2


Groom All altered tables

Run the command:

nz_alterd_tables -groom

Sample Results:

Grooming SCHEMA1.DB1.TABLE1     @ 2017-07-28 05:56:04
NOTICE:  Groom will not purge records deleted by transactions that started after 2017-07-28 05:51:02, the start time of the oldest unfinished stablexid transaction 0x3e2bf0a.
NOTICE:  If this process is interrupted please either repeat GROOM VERSIONS or issue 'GENERATE STATISTICS ON "TABLE1"'
NOTICE:  Groom processed 0 pages; purged 0 records; scan size unchanged; table size unchanged.
GROOM VERSIONS
Elapsed time: 0m3.761s
....
....

Groom an single DB

Run the command:

nz_groom [db_name]

Example:
nz_groom DB1

Sample Results:


Name
Remaining Rows
Remaining Size
Reclaimable Rows
Reclaimable Size
NON-Groomable Rows


TABLE1
100
542,112
5,000
2,123,315
0


TABLE2
54
542,112
5,000
2,123,315
0


TABLE3
460,000
23,056,093
0
0
0


TABLE4
100
542,112
5,000
7,923,315
10
Name	Remaining Rows	Remaining Size	Reclaimable Rows	Reclaimable Size	NON-Groomable Rows
TABLE1	100	542,112	5,000	2,123,315	0
TABLE2	54	542,112	5,000	2,123,315	0
TABLE3	460,000	23,056,093	0	0	0
TABLE4	100	542,112	5,000	7,923,315	10