Re: The query plan get all columns but I'm using only one column.

2020-04-30 Thread Moises Lopez
Michael, Your complete explanation is very helpful! I appreciate it Thank you so much! Regards! El jue., 30 abr. 2020 a las 10:52, Michael Lewis () escribió: > In staging environment we have disabled autovacuum since that it is a >> testing environment and the database are restored very often.

Re: The query plan get all columns but I'm using only one column.

2020-04-30 Thread Michael Lewis
> > In staging environment we have disabled autovacuum since that it is a > testing environment and the database are restored very often. > But in production environment it is enabled autovacuum=on > > The weird case is that production was slow and staging environment was > faster. > You haven't s