query that shows if the tables might need analyze and vacuum
|Added at||2016-12-27 17:12|
i have this doubt I loking for a query that returns if my tables from given schema need analyze and vacuum before wraparound wich can not happen, so far i got this query:
I'm looking for an output like this:
table | need analyze(y/n) | vacuum wraparound(y/n) | vacuum(already got on query above)
the "vacuum wraparound(y/n)" field is when the XID is close to reach the maximum value
if anyone can help me, I appreciate this.