My query is returning many rows but I'm only interested in the query processing time. How do I omit the query output and check for query processing time?
FORMAT Null to your query to configure the output format to
Null. This prevents data from being transmitted to the client.
count() AS total,
GROUP BY customer_id
ORDER BY total DESC
The response will return the number of rows processed and the elapsed time, but 0 rows will be returned:
0 rows in set. Elapsed: 25.288 sec. Processed 222.04 million rows, 13.50 GB (8.78 million rows/s., 533.77 MB/s.)