>
>
> - Does the analyse output below mean that it only scanned 51538 of 65463
> rows in the table? Is school_id 36 just being missed in the sample? (This
> happens when the analyse is repeated )
>
Is there a transaction which had deleted all of school_id=36, and then was
just left open indefinitely without either committing or rolling back?
That would explain it, and I don't know of anything else that could. The
deleted but not committed tuples are still live, but don't get sampled.
Cheers,
Jeff