My general recommendation is to avoid performance testing in specs.
We have some examples where we try to monitor for N+1s in a spec, but they all tend to be pretty fragile.
Its a very very tough problem with no obvious solution, all solutions come with compromises so we generally avoid this and just monitor production for this kind of stuff.