compression_ratio fix for empty tables

gsmolk · gsmolk · commit b9937517359f · 2017-03-12T15:40:52.000+03:00
diff --git a/mamonsu/plugins/pgsql/cfs.py b/mamonsu/plugins/pgsql/cfs.py
@@ -21,6 +21,7 @@ class Cfs(Plugin):
     left join pg_catalog.pg_namespace n on n.oid = c.relnamespace
 where c.reltablespace in (select oid from pg_catalog.pg_tablespace where spcoptions::text ~ 'compression')
     and c.relkind IN ('r','v','m','S','f','')
+    and cfs_compression_ratio(c.oid::regclass) <> 'NaN'
 
 union all
 
@@ -32,7 +33,8 @@ class Cfs(Plugin):
     pg_catalog.pg_class as c
     left join pg_catalog.pg_namespace n on n.oid = c.relnamespace
 where c.reltablespace in (select oid from pg_catalog.pg_tablespace where spcoptions::text ~ 'compression')
-    and c.relkind = 'i' and n.nspname <> 'pg_toast';
+    and c.relkind = 'i' and n.nspname <> 'pg_toast'
+    and cfs_compression_ratio(c.oid::regclass) <> 'NaN';
 """
 
     activity_sql = """
