clpong
1 Nickel

which view / table that i can view the resource queue configuration setting?

Hi,

I need help on how to view the configuration setting value for each resource queue.

Recently i have created some resource queues. However, i need to check what are the priority setting, active_statement for each resource queue before i need to implement another resource queue.

I come across some of the view eg: gp_toolkit.gp_resqueue_status, but it show the current statement priority rather matching resource queue to all of the configuration value.

 

Any idea?

0 Kudos
3 Replies
banana_hammock
1 Nickel

Re: which view / table that i can view the resource queue configuration setting?

I think these are the views you're looking for in gp_toolkit:

gp_resq_activity          

gp_resq_activity_by_queue 

gp_resq_priority_backend  

gp_resq_priority_statement

clpong
1 Nickel

Re: which view / table that i can view the resource queue configuration setting?

Thanks Jamie! The other pg_catalog views that you sent me -pg_resqueuecapability, pg_resqueue, pg_resourcetype, and pg_resqueue_attributes. They are good for checking the resource queue configurations.

Highlighted
ViadeaZhu
1 Nickel

Re: which view / table that i can view the resource queue configuration setting?

One way to get what you want:

gpadmin=# select relname from pg_class where relname~'resq' and relkind in ('r','v');

          relname          

----------------------------

pg_stat_resqueues

pg_resqueue_status

pg_resqueue_attributes

pg_resqueue

pg_resqueuecapability

gp_resq_activity

gp_resq_activity_by_queue

gp_resq_priority_backend

gp_resq_priority_statement

gp_resq_role

gp_locks_on_resqueue

gp_resqueue_status

(12 rows)