Thanks @Brenden for the detailed explanation.
I checked the following link:
https://docs.kentico.com/k12/deploying-websites/content-staging
I went to the staging application and found one instance mentioned there. So I assume because of that, the Staging table grew in size. Also, the mentioned instance in Staging application was non-functional.
So, here are my questions:
-
If I remove that instance from the staging application, will it impact our current site?
-
Do I have to still clear staging tables manually?
I will try to test it by downloading the database on my local.