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.
I think these are the views you're looking for in gp_toolkit:
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.
One way to get what you want:
gpadmin=# select relname from pg_class where relname~'resq' and relkind in ('r','v');