With appropriately-sized hardware, if the query results are found in memory, they may be returned within milliseconds.
Complex queries requiring results aggregation over huge indexes may take a few seconds.