The PostgreSQL agents triggers a huge amount of the following alarm:
"The index size for yourTableName in yourDatabase is currently x% of the total table size. You may want to ensure the index table is being vacuumed in order to compact its size."
Even when vacuum the table the alarm does not disappear.
If a table is pretty small and the index is complex, it could happen that the index size is 20% of the table size.
Please run the following two SQL statements against the problematic database to get the size of the table and index:
Table size:
select pg_size_pretty(pg_relation_size('yourTableName'));
Index size:
select pg_size_pretty(pg_indexes_size('yourTableName'));
Based on these values please check if Foglight triggers a correct alarm. The thresholds for the conditions are:
Warning = 20%
Critical = 25%
Fatal = 40%
If the alarm is correct, you can exclude specific tables from the rule.
The rule condition considers the amount of tuples in the table. If the amount of tuples is over 100, then the rule will consider this table in the evaluation. The threshold is set via registry variable "PostgreSQL_Minimum_Tuple_Size" and can be changed. Default value is 100. To change the value follow the steps below:
If a more granular approach is needed, set a specific registry value for specific table objects.
Please contact our Professional Services team if you need help to customize the rule or registry variable.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center