Deleted records from frontend still showing in database

Hi dev, I really don't know why I'm still seeing deleted posts in tableplus after which it has been deleted from the frontend, I tried to use tinker to query the model to see if I still have the records but the result was null which means I don't have the deleted records anymore.... I tried to use mysql cli to check the database table but to my surprise mysql still shows the deleted records...... kindly help me out please... thanks