While querying a large table after ingesting more recent records, the query execution takes a long time. The explain plan shows - Predicate Value out of range
Environment
Vertica analytics Database: v12.0.4-26Situation
If there is a query with a predicate value more recent than the predicates covered by analyze statistics then the query will take longer to execute and PREDICATE VALUE OUT-OF-RANGE will be in EXPLAIN.If we run the same query but with an older predicate value the query will be faster.
If a data ingestion happens too quickly on a certain table, it is not feasible to run explain plan on it too frequently.
