Clickhouse bloom filter index seems too slow

I had executed the following querybut it has processed ~1B rows and took total time of 75 seconds for a simple count.