Kibana outputs limit

[gurunga011 (Zatom)]

Hi everyone. I am trying to see the time it takes to process all of my outputs in kibana console(Version 6x..). My outputs are in millions. And kibana console just shows me only 1002 outputs. How do I fix this? I am using a sql api and my code looks like this:

POST /_xpack/sql?format=txt
{
"query":"""
SELECT vehicle_name
FROM vehicle
"""
}

[rashmi (kulkarni)]

@gurunga011

millions. And kibana console just shows me only 1002 outputs. How do I fix this? I am using a sql api and my code looks like this:

Probably you can use the [scroll API ] ?(Request body search | Elasticsearch Guide [8.11] | Elastic).