You may find you want to set up resource pools before running queries to know how many resources a particular query needs. One way to do this is to create a small resource pool, profile the query, and note when the query is rejected. When the query is rejected, Vertica prints the resources that the query needs.
Let’s take a look at an example.
Read more here:
https://my.vertica.com/blog/vertica-tip ... ent-needs/