AWS policy results table size and necessity clarification

CloudQuery Plugins
1

What’s the table of aws_policy_results? I didn’t see it in CloudQuery AWS Plugin Documentation.

  • Why is it so big?
  • Is there any way to reduce the size?
  • Do we need it?
                table_name                 | total_size | row_estimate
-------------------------------------------+------------+--------------
aws_policy_results                         | 18 GB      |      70700000
2

Hey @calm-walrus,

aws_policy_results typically comes from running CloudQuery’s security and compliance policy frameworks. Those can be found here and here.

If you don’t need those results, you could remove it. I’d say check what’s in the table and if there’s data in there that’s old or no longer needed, you can delete the data and reduce the size.

3

I got the points.

So before executing the policy.sql, we should drop its table first. Otherwise, the table size will keep growing.

I ran the test, and it seems the result is no different compared to the old way (didn’t drop the table).

However, its table size is far smaller now.