Removing apps with 'IsDeleted' flag

Question

Hello,

We currently have around ~3,500 workflow listed as deleted in the Alteryx Gallery diagnostics panel. I was able to located the list of actual apps by extracting information from MongoDB. Should I be concerned about the MongoDB size due to this?

The fact that I'm able to see them in the MongoDB table and while accessing the Scheduler on Designer (View Schedules > Workflows), makes me think that apps are stored somewhere in the database.

TheCoffeeDude · Answer

Yes, you should be concerned about the space that deleted workflows are taking up. On my server, they're currently taking up about 28GB of database space. I've heard of people stating that they purged the workflows from their server, but haven't shared exactly how they're doing it.

gabrielvilella · Answer

Deleting a workflow from the Gallery does not delete the workflow file from MongoDB. It is just a flag set to deleted state, as you identified. At this point is not possible to remove the workflow file from MongoDB. Having a MongoDB large in size can impact the Server performance. What you can do is to enable the persistence options within System Settings to delete some other files after a certain number of days.

jforte · Answer

Lots of objects are maintained in the MongoDB (Not just WF's) after being "deleted", which in Alteryx terms means "Flagged as deleted".

Depending on the size of your user base and setup, if could be a issue.