Load directly into Elasticsearch: it supports SQL as well as visualizations and simple querying via Kibana, and is far more performant than PostgreSQL for this

Load directly into Elasticsearch: it supports SQL as well as visualizations and simple querying via Kibana, and is far more performant than PostgreSQL for this kind of thing. Ingest speed is tunable via number of shards and translog sync frequency, so no need for message queue if things get busy.