Where is page setting "clear cache" saved in database?

Where does MODX save the setting "clear cache" of a resource? I can't find it in the database, especially not in modx_site_content. Does MODX store the value in the filesystem? I'm asking because I would like to disable the setting for a huge load of resources and don't want to do this one by one.

It is in the site_content table, the "cacheable" field.

This is not saved. The default behavior is for it to be checked when you edit a Resource, and that state should be preserved while editing that Resource. There was a suggestion to add a setting to control this default behavior, but this has not been implemented yet.

Then I've always had the wrong idea of what that was for. Learn something new every day!

Clear Cache on Save and Cacheable are two separate things. A Resource can be marked as Cacheable or not (this is saved in the database), and the checkbox for clearing the cache on save simply indicates if the changes you make should be immediately reflected by clearing any cached copies of all Resources (this has to be done because changes to the Resource may reflect changes to other Resources, i.e. menus, getResources calls, etc.) and regenerating other parts of the cache that might be affected by the change.