After restoring vertica on a new node, the queries are taking longer time then expected. After taking back up only IP addresses were changed. Earlier it used to work fine.
Are all your projections with statistics ?
select * from projections where has_statistics='false';
And make sure you run statistics on the missing ones or full stats with
SELECT ANALYZE_HISTOGRAM('', 100);