I wanted to ask you about how the VACUUM ANALYZE works. is it possible that something can happen in order to reset its effects forcing to execute the VACUUM ANALYZE comand again?
Yes, lots of modifications (INSERT,UPDATE,DELETE) to the table in question.