X_APPROXIMATE_COUNT_FILTERED

an estimate was asked of a filtered chain

approximateCount() reads reltuples out of pg_class, which knows nothing about a predicate, so posts.where({ orgId }).approximateCount() would answer for the whole TABLE while reading as "roughly how many of mine". Refused rather than answered, because the wrong answer is plausible and unbounded

<entity>.count() — the exact answer for a filtered chain. approximateCount() answers for the whole table only