Logstash jdbc_static filter plugin performing very poorly (nearly not at all)

Those threads are waiting to obtain a connection to the database. It could indicate a connection leak, a loss of connectivity to the database, or some connections getting wedged. I do not have a database with which I could test how to diagnose that.

I cannot be sure, but I don't think you are hitting issue #27.