pretty much anything with lots of kinds and ids all at once. Its quicker when the filter matches the index. Things like pubkeyKind (1 kind, 1 pubkey) etc.

It could take very long if the filter plan fails and it has to fall back to a linear scan