I have 10 sql files that contains different OLAP queries.
I want to run them as a batch. Meaning by batch, Postgres will consider each file as a batch and execute the queries at once (depends on its own managing process)
The follow command, execute each query one by one
psql -h localhost -d databasename -U user -p port -a -q -f input.sql -o output.txt
Is that possible ? and how to calculate the time it takes to execute that batch sql queries ?