Stream is taking more time in query execution

Hi Team,
We saw that stream phase is taking more when we checked the plan of the query execution. Below is the screenshot. Please let us know what does this stream phase does and why its taking more time.

In general terms the cost of the stream service is directly related to the amount of data that is sent across the wire, and you have sent 26MB, which is non negligible.
Bear in mind that stream goes at the speed at which the client is willing to receive the data, and it could very well be that the UI took a bit of time to format the 28K documents that the query returned.
You will find that if you execute the query through the command line and curl, and disabling pretty output, the stream operator will take much less.

1 Like