>
> Each table in your database has an entry in the pg_class table. Something
> like:
>
> SELECT relallvisible from pg_class where oid = 'build.household'::regclass;
>
> would show you the value, however, I think a problem here is unlikely
> since that would just control the likelihood of an index-only-scan vs
> an index-scan. You're getting a Seq-scan, which I imagine is going to
> be quite a bit more expensive than even an index scan.
>
relallvisible has a value of 0 for that table on both databases.