Viraj Jasani created PHOENIX-6907:
-------------------------------------

             Summary: Explain Plan should output region locations with servers
                 Key: PHOENIX-6907
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6907
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Viraj Jasani
            Assignee: Viraj Jasani


As of today, explain plan provides details related to scan key range size, size 
of the scan lists (for parallel scans), hints, client/server sorted by, order 
by, server filter etc. It provides as much close details to the physical plans 
as possible.

If we could also make explain plan output to include region locations that also 
contains regionserver details on which the region is currently residing, this 
might turn out to be really good insights. For full table scans, this also 
means that we would end up including very higher number of region locations and 
it would not be ideal to print all of them in the output. We can enforce a 
limit on the num of region locations to print (default value could be 10 or 
so). For point lookup and range scans, we can find the region locations with 
regionserver as quite useful for the real time analysis of slowness experienced 
by the given query.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to