I do not know of way to undo an analyze once its committed. I do not know
the danger in deleting an entry in pg_statistic
What you can do in the future is make copy of the Statics for this table,
analyze, if it negatively affect results put the copy back.
Another option is to do
begin ;
ANALYZE
I did a manual ANALYZE of a foreign table, to see if it would make a
troublesome query better. It did, but it also made some other queries that
were previously fine to become far worse. Is there a way to undo the
analyze? I can muck around in the catalogs like below, but seems really
grotty.
de
