[UX] show-gpus should have a --use-spot option to only show the sorted price for spot

[Michaelvll]

Currently, sky show-gpus V100 shows the V100 GPUs with the cheapest on-demand price across multiple regions.

$ sky show-gpus V100  --cloud gcp
GPU   QTY  CLOUD  INSTANCE_TYPE  DEVICE_MEM  vCPUs  HOST_MEM  HOURLY_PRICE  HOURLY_SPOT_PRICE  REGION       
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 2.953       $ 1.037            us-central1  
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 5.906       $ 2.074            us-central1  
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 11.813      $ 4.148            us-central1  
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 23.626      $ 8.296            us-central1 

However, that spot price showing in the table may not necessarily be the cheapest, and we can see that asia-east1 has a higher on-demand price but lower spot price.

sky show-gpus V100  --cloud gcp --all-regions
GPU   QTY  CLOUD  INSTANCE_TYPE  DEVICE_MEM  vCPUs  HOST_MEM  HOURLY_PRICE  HOURLY_SPOT_PRICE  REGION        
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 2.953       $ 1.037            us-central1   
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 2.953       $ 1.037            us-east1      
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 2.953       $ 1.037            us-west1      
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 3.028       $ 0.845            asia-east1    
V100  1    GCP    n1-highmem-8   -           8      52GB      $ 3.071       $ 0.973            europe-west4  
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 5.906       $ 2.074            us-central1   
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 5.906       $ 2.074            us-east1      
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 5.906       $ 2.074            us-west1      
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 6.056       $ 1.690            asia-east1    
V100  2    GCP    n1-highmem-16  -           16     104GB     $ 6.142       $ 1.946            europe-west4  
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 11.813      $ 4.148            us-central1   
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 11.813      $ 4.148            us-east1      
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 11.813      $ 4.148            us-west1      
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 12.112      $ 3.381            asia-east1    
V100  4    GCP    n1-highmem-32  -           32     208GB     $ 12.284      $ 3.892            europe-west4  
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 23.626      $ 8.296            us-central1   
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 23.626      $ 8.296            us-east1      
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 23.626      $ 8.296            us-west1      
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 24.223      $ 6.761            asia-east1    
V100  8    GCP    n1-highmem-64  -           64     416GB     $ 24.568      $ 7.784            europe-west4

We should reduce the confusion by either having separate region columns for on-demand and spot price or an additional --use-spot option for only showing the spot prices.

[github-actions]

This issue is stale because it has been open 120 days with no activity. Remove stale label or comment or this will be closed in 10 days.