How to clear visibility data on db

temporal advanced visibility stores too much data on db, some tables even store more than 1000GB, how to clear visibility data?

I’m using 1.24.1 version and set retention period just one day, but visibility data on db is not affected by retention period