How to speed up indexing of csv file via logstash

To find that out you need to identify where the bottleneck is. It could be logstash, it could be elasticsearch. It could be CPU, it could (in elasticsearch) be disk throughput. It could be several other things. You need to monitor the components of your system and see which one is limiting throughput. Nobody can predict that without visibility into your servers.