The story
From obsessive behavior observed in some dogs. The figurative sense refers to the frenzied activity without any useful purpose inherent in this behavior
Etymology from Wiktionary, CC BY-SA 4.0.
chase one's tail
Today it means: To busily try to perform many tasks or to repeatedly revise one's plans, especially with inefficient use of one's time and limited results. Full definition →