Hi SriBhargav94,
Enable but do not execute:
When you configure an activity with this option the workflow will execute until this activity. In other words, the current activity will not be executed and the workflow will keep the temporary worktable of previous activity intact for data review.
You need follow steps to avoid the issues what you mentioned:
Purge the logs when they are not needed anymore. Workflow history is not purged automatically: all messages are kept by default. History can be purged via the File > Actions menu or by clicking the Actions button located in the toolbar above the list. Select Purge history.
Do not use the ‘Keep Interim Results’ option in a workflow properties on a production environment.
This option is used to analyze the results and is designed only for testing purposes and hence must be used only on dev or staging environments.
Avoid having disabled activities with flows going into them in your workflows. This leaves threads open and leads to many temporary tables that can consume a lot of space. Do not keep activities in ‘Do not enable’ or ‘Enable but do not execute’ states in your workflows.
Available in the Execution tab of workflow properties, the Log SQL queries in the journal option will log all SQL queries generated by the tool from the different activities. It is a good way to see what is actually executed by the platform. However, this option should only be used temporarily during development and not activated on production.
Hope it helps 
Regards,
Venu