unanalyze a foreign table

Jeff Janes <[email protected]> Sun, 22 Dec 2019 14:21:32 -0500
Newsgroups gmane.comp.db.postgresql.general
Message-ID <CAMkU=1x0C6H-yUPimAb-kzO1FqNeHW06gNT7Dny2SY3Ua23j4Q@mail.gmail.com>
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.

delete from pg_statistic where starelid=418911;

The other option seems to be doing a `drop foreign table ... cascade`, but
then recreating all the cascaded drops is quite annoying and error prone.

I currently solved it by re-cloning my performance testing server from
upstream, but that also is not very convenient.  Is directly manipulating
the catalogs really the best way?

Cheers,

Jeff