I saw an entry in the table v_monitor.resources_queues with a pool name called "< spot >" - what does it mean?
sorry, I just realized that "< spot >" was removed after posting the question due to the < and > signs.
It's not a resource pool exactly, but rather indicates the query is in queue and not in the resource pool yet.
Between the time a query arrives at the resource manager and when the node schedules a thread to marshal it through the resource manager, the query will be on something called the "spot queue" and thus will appear this way on resource_queues.
If queries remain on the spot queue for any length of time, then there is something iffy going on - most likely due to a sub-optimal resource pool design.
Can you share the screenshot and output of following
select * from resource_pools
select * from resource_queues
Sorry, I can't post that information.
But no, the pool name "< spot >" does not exist in resource_pools.
And as mentioned in the question, I found it in the table resource_queues table.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.