Resource groups
Resource groups isolate competing query workloads inside a single QuestDB instance.
This page covers running the feature: what an instance needs, how to choose
limits, what to watch, and what to do when something looks wrong. For what the
limits guarantee, read the concept page. For
statement syntax, see
CREATE RESOURCE GROUP and its
siblings.
Requirements
- QuestDB Enterprise.
- Access control enabled (
acl.enabled=true). Groups can be created without it, but mapping statements require it, since mappings attach to ACL principals. Without it, a session can still choose a group withSET RESOURCE GROUP. - The worker pools that execute SQL must run in Fiber mode, which is the default.
- The
RESOURCE GROUP ADMINpermission for group management, mappings,GRANT USE ON RESOURCE GROUPand instance-wide inspection throughresource_groups(). Ordinary users need no permission to callcurrent_resource_group()and check their own query's group. - The
USE RESOURCE GROUPpermission for a principal that chooses a group other than its own for a session or a request. See SET RESOURCE GROUP.
Mapping a principal to a resource group grants it nothing by itself. The user
still needs HTTP or PGWIRE to connect and SELECT on the tables it queries,
as described in RBAC.
Fiber mode
Every Fiber setting defaults to true, so a stock instance already satisfies
this requirement and there is nothing to check. It matters only on an instance
whose worker pools were tuned by hand.
If a SQL pool is in legacy mode, resource groups left at their default turn
themselves off at startup and log an error naming the pool and the setting to
change. Setting resource.groups.enabled=true explicitly on such an instance
fails startup with that same error.
Each protocol is governed by the setting for the pool that actually serves it:
- HTTP and PostgreSQL run on their own pool when
http.worker.countorpg.worker.countis above zero, governed byhttp.worker.fiber.enabledandpg.worker.fiber.enabled. - With those counts at their default of zero, both run on the shared network
pool, governed by
shared.network.worker.fiber.enabled. - Parallel query work follows
shared.query.worker.fiber.enabledwhenever the shared query pool has workers. A pool set to zero workers turns parallel SQL off and needs no check of its own.
The two instance-wide settings, resource.groups.enabled and
resource.groups.process.memory.limit.bytes, are described in the
resource groups configuration reference.
Neither is reloadable, so turning the feature off is a restart. Definitions and
mappings stay in the catalog either way, so nothing is lost while it is off.
Changing a live instance
Three things are worth knowing before you change policy on a running system:
- Changes apply online. An
ALTERdoes not cancel anything running at that moment. Slots already held are kept, an already queued request keeps its deadline, and only subsequent allocations check a new memory budget. A new CPU limit reaches running queries at their next CPU slice, or for a query that was running before CPU scheduling engaged, when it next suspends. A new scheduling policy re-queues the work waiting for CPU. See effect on queries already running. - A drop is refused while principals are still mapped. Unmap them first. Once unmapped, the group can be dropped while its queries are still running, and they carry on under the settings it had. See what happens to queries still using it.
DEFAULTis alterable but cannot be dropped or renamed. Giving it limits is how you bound everything that is not explicitly mapped. That includes the built-in admin, which cannot be mapped and runs inDEFAULTunless its session chooses another group.
Mapping changes affect queries that start after the change, never one already
running. For the resolution order, including ASSUME SERVICE ACCOUNT, see
who a resource group applies to.
On a replicated cluster a change takes effect on each instance as the catalog reaches it, so a replica that is behind keeps applying the previous policy. See Replication and catalog lag.
Choosing limits
The accepted values and their defaults are in the
CREATE RESOURCE GROUP parameter table.
What matters when picking them:
- An unset parameter is not always "unlimited".
cpu_weightfalls back to 100,queue_timeoutto 30 seconds andscheduling_policytofifo, while the two admission counts and the CPU limit really are unlimited when unset. - Weights are only meaningful relative to other groups. A group at
cpu_weight = 50gets a third of query CPU whileDEFAULTalso has work, and all of it whenDEFAULTis idle. Setting a weight on a lone group does nothing. - A weight shares, a limit caps. A weight decides the split while groups
compete and lets a group use what the others leave idle.
cpu_limitcaps a group at a part of the node even when the rest is idle, so leave it unset unless the group must never use more. Below its limit a group still competes by weight: if it must also reach its limit while others are busy, give it a weight whosecpu_min_share_pctis at least itscpu_limit_pct. - Whole cores make the strictest cap. A limit that comes to a whole number
of cores, such as
'25%'on 16 CPUs, has no CPU budget, so the group cannot burst above it or carry debt.cpu_limit_coresshows what a limit comes to. - A small limit changes how queries run. A group limited to one core or less
runs parallel queries single-threaded, and a
CREATE TABLE ... AS SELECTkeeps one of the group's workers until it finishes. Leave room for short queries beside a group's copies. See A CPU limit is a ceiling. fairis opt-in.fifofinishes long batch queries soonest. Switch a group tofairwhen its users, or its queries, must make progress side by side.- No group memory ceiling does not mean unlimited memory. A principal's own
limit,
cairo.query.memory.limit.bytesand the process budget all still apply, and a group ceiling only ever lowers the result. See memory limits.
Start permissive, watch the counters in inspecting, then tighten. Policy changes apply online, so there is no need to get this right first time.
Common scenarios
The instance stops answering while CPU looks idle
Every HTTP or PGWire worker is occupied by a large query, new requests are not picked up, and instance CPU is low because those queries run on one core each. Clients time out and retry, which produces more of the same queries.
1. Separate the workloads into groups. While DEFAULT is the only group,
queries hold their workers exactly as they do with the feature disabled. CPU
scheduling engages as soon as a second group exists, and a query then yields its
worker at the checkpoints that already make it cancellable, so a long
single-threaded scan releases the worker while it is still running, the instance
keeps accepting connections, and CPU is split by weight:
CREATE RESOURCE GROUP dashboards WITH (cpu_weight = 400);
CREATE RESOURCE GROUP adhoc WITH (cpu_weight = 100);
ALTER USER app SET RESOURCE GROUP dashboards;
ALTER USER analyst SET RESOURCE GROUP adhoc;
questdb_resource_groups_cpu_managed_dispatch reports 1 while scheduling is
engaged, which is whenever a group besides DEFAULT exists or any group has a
CPU limit or the fair policy. A query that
started before the second group was created keeps its worker until it next
suspends or finishes, and a query that never reaches a checkpoint holds its
worker either way, so this does not remove every cause of an unresponsive
instance.
2. Bound concurrent requests with admission.
ALTER RESOURCE GROUP adhoc SET (
max_active_queries = 4,
max_queued_queries = 8,
queue_timeout = '5s'
);
The fifth concurrent query waits instead of running, and it does not hold a
worker while it waits. The thirteenth fails immediately with
Resource Group admission queue is full, so a client that keeps resending gets
a clear answer in seconds instead of adding to the pile.
Admission directly bounds the number of concurrent queries; weights do not, so the two are complementary. Clients should use bounded retries with backoff after admission failures.
Afterwards the symptom is also diagnosable rather than mysterious. Low instance
CPU together with a high queued_queries and a rising
oldest_queue_wait_millis on one group says the work is being held at the
admission gate, not that the machine is busy. query_activity() shows which
group each running query was admitted to.
What resource groups do not do here: they do not make the slow plan faster, and
they do not bound how long one query may run. Wall-clock limits still come from
the instance-wide
query.timeout, and that
clock includes time spent waiting in the admission queue: a query can time out
before it starts, and the error then says
while queued for Resource Group admission.
Dashboards must stay responsive while analysts run heavy queries
Use weights. Shares are per group, not per query, so a group running fifty queries does not outvote a group running one:
CREATE RESOURCE GROUP dashboards WITH (cpu_weight = 400);
CREATE RESOURCE GROUP analysts WITH (cpu_weight = 100);
When these are the only competing groups and both can use their shares, weights target a 4:1 split of managed query CPU. Actual use also depends on runnable work and available parallelism. When analysts are idle, dashboards can use the available query CPU. Weights are integers from 1 to 10000 and every group starts at 100, so a group left alone keeps an equal share against any group you do not change.
A background job must yield to everything else
Give it a small weight and a small concurrency limit:
CREATE RESOURCE GROUP exports WITH (cpu_weight = 10, max_active_queries = 1);
Under contention the job receives a tenth of the CPU that a group at the default weight of 100 receives, and it runs one query at a time. When nothing else has work it uses the CPU that would otherwise be idle; unless it has a CPU limit, resource groups do not hold CPU back from a group that is alone.
One workload must not exhaust query memory
Bound the group rather than each query, so the limit holds however many queries the workload starts:
CREATE RESOURCE GROUP reporting WITH (memory_limit = '8G');
A query that would push the group over its budget fails with
query memory limit exceeded reporting scope=group, and releases what it
held.
An ingestion or automation account runs queries too
A service account cannot belong to an ACL group, so it has no mapping to
inherit. Without a direct mapping it runs in DEFAULT, so map it explicitly:
CREATE RESOURCE GROUP automation WITH (cpu_weight = 50, max_active_queries = 2);
ALTER SERVICE ACCOUNT ingest_bot SET RESOURCE GROUP automation;
This governs the queries the account runs. It does not throttle ingestion itself, which resource groups do not manage.
Many teams share one instance
Map ACL groups rather than individual users, and use MAPPING PRIORITY to
decide what happens to someone who belongs to more than one:
ALTER GROUP analysts SET RESOURCE GROUP adhoc MAPPING PRIORITY 10;
ALTER GROUP oncall SET RESOURCE GROUP dashboards MAPPING PRIORITY 20;
Someone in both groups resolves to dashboards, because the higher priority
wins. If two mappings tie on priority, the one whose resource group was created
first wins, so keep priorities distinct. A direct mapping on the user beats
every group mapping regardless of priority, which is the way to make one person
an exception without touching the groups:
ALTER USER lead_analyst SET RESOURCE GROUP dashboards;
MAPPING PRIORITY is rejected on user and service account mappings, because
those are one-to-one and have nothing to break a tie between. Confirm any of
this from the client's own session with SELECT current_resource_group();.
A tenant must never use more than its part of the node
Capacity sold by the core needs a ceiling rather than a share:
CREATE RESOURCE GROUP tenant_a WITH (cpu_limit = '25%');
CREATE RESOURCE GROUP tenant_b WITH (cpu_limit = '25%');
ALTER SERVICE ACCOUNT tenant_a_app SET RESOURCE GROUP tenant_a;
ALTER SERVICE ACCOUNT tenant_b_app SET RESOURCE GROUP tenant_b;
On a node with 16 CPUs each tenant uses at most 4 cores, even while the rest of
the node is idle, and cpu_limit_cores in
resource_groups() shows what
the limit comes to on a given node. A quarter of 16 CPUs is a whole number of
cores, so the cap has no budget to run ahead of. A limit only caps, though: with
the default weights each tenant's cpu_min_share_pct is about 33, above its
limit, so each tenant also gets its 4 cores while DEFAULT is busy. The CPU the
tenants cannot use goes to the other groups and to work outside resource groups,
such as ingestion.
Size the limit for the tenant's heaviest statements. A
CREATE TABLE ... AS SELECT keeps one of the group's workers until it
finishes, and a limit of one core or less runs every parallel query of the
group single-threaded. See
A CPU limit is a ceiling.
One user's queries crowd out the rest of a team
In the default fifo order, a user who starts several long queries holds the
group's workers while everyone else's queries wait behind them. Divide the
group between its users instead:
ALTER RESOURCE GROUP analysts SET (scheduling_policy = 'fair');
Busy users now split the group evenly, and one user alone can still use all of
it. With max_active_queries set, admission also takes the user with the fewest
admitted queries first, so one user's queue no longer keeps the others out. See
the scheduling policy.
One account sends both urgent and routine queries
A monitoring account that evaluates alert rules and serves dashboards needs the alerts to win, while its mapping gives it one group. Let the account choose:
CREATE RESOURCE GROUP alerts WITH (cpu_weight = 400);
CREATE RESOURCE GROUP dashboards WITH (cpu_weight = 100);
ALTER USER monitoring SET RESOURCE GROUP dashboards;
GRANT USE ON RESOURCE GROUP alerts TO monitoring;
The connections that evaluate alert rules come from a pool of their own and run
SET RESOURCE GROUP alerts once after connecting. A pool shared with dashboards
would hand a switched connection to dashboard queries, unless it resets every
session with DISCARD ALL or RESET ALL. An HTTP client sends
resource_group=alerts with each alert query instead. Everything else stays in
dashboards. Other users cannot choose alerts without the same grant, so the
heavier group stays reserved for the work you grant it to. See
SET RESOURCE GROUP.
Operators need a protected share
Management statements such as ALTER RESOURCE GROUP and CANCEL QUERY are not
managed, so they never wait for a group's admission or CPU however busy the
instance is. The queries operators run to diagnose a busy instance, such as
SELECT * FROM query_activity() or resource_groups(), are managed, so give
them a group of their own:
CREATE RESOURCE GROUP ops WITH (cpu_weight = 5);
ALTER USER dba SET RESOURCE GROUP ops;
While every group is busy, ops can count on its cpu_min_share_pct, and it
uses more when other groups are idle. Diagnostic queries are light, so a small
weight is enough: what matters is that they do not wait behind the workload.
Leave the group's admission limits unset, so they are not queued either.
The built-in admin cannot be mapped. It runs in DEFAULT unless its session runs
SET RESOURCE GROUP ops, which needs no grant, so lowering the weight of
DEFAULT also lowers the built-in admin's share.
Inspecting
resource_groups() returns one
row per group, combining the configured policy with live counters. The columns
that matter day to day:
active_queriesandqueued_queriesfor live admission state, andoldest_queue_wait_millisfor how long the longest waiter has waited. A high queue with a rising wait means work is held at the gate, not that the machine is busy.admission_rejectionsandadmission_timeoutsfor work already turned away.memory_used_bytesagainstmemory_limit_bytesfor headroom.cpu_min_share_pctfor the share of query CPU each group can count on while every group has work, up to its CPU limit, andcpu_limit_pct,cpu_limit_coresandscheduling_policyfor its CPU limit and policy.
Weights are relative, so they need not add up to 100, but weights that do read directly as percentages:
ALTER RESOURCE GROUP DEFAULT SET (cpu_weight = 1);
CREATE RESOURCE GROUP IF NOT EXISTS ops WITH (cpu_weight = 5);
CREATE RESOURCE GROUP trading WITH (
cpu_weight = 45,
scheduling_policy = 'fair'
);
CREATE RESOURCE GROUP research WITH (cpu_weight = 49, cpu_limit = '75%');
SELECT name, cpu_weight, cpu_min_share_pct, cpu_limit_pct, cpu_limit_cores,
scheduling_policy
FROM resource_groups()
ORDER BY name;
On a node with 16 CPUs:
| name | cpu_weight | cpu_min_share_pct | cpu_limit_pct | cpu_limit_cores | scheduling_policy |
|---|---|---|---|---|---|
| DEFAULT | 1 | 1.0 | 0 | 0.0 | fifo |
| ops | 5 | 5.0 | 0 | 0.0 | fifo |
| research | 49 | 49.0 | 75 | 12.0 | fifo |
| trading | 45 | 45.0 | 0 | 0.0 | fair |
The smallest weight is 1, so DEFAULT, which also holds the built-in admin's
queries, takes at least one point of a scheme that adds up to 100. research
can count on 49% of query CPU, about 7.8 cores, while every group is busy, and
can use idle CPU up to its limit of 12 cores, while the other groups can use all
of it. cpu_min_share_pct does not account for limits: a group whose limit is
below its percentage gets only its limit, and the rest goes to the other groups.
Mappings are attributes of the principals themselves. SHOW USERS and
SHOW SERVICE ACCOUNTS carry a resource_group column, and SHOW GROUPS
carries resource_group and resource_group_priority; all are NULL for an
unmapped principal. Each statement can be used as a subquery, so
SELECT name FROM (SHOW GROUPS) WHERE resource_group = 'reporting' lists the
ACL groups mapped to one resource group.
current_resource_group() returns the calling query's group, which is the
quickest way to confirm a mapping from the client's own connection:
SELECT current_resource_group();
An unmapped principal gets DEFAULT, not NULL. NULL means the query was
never admitted to a group at all, which happens when the feature is disabled and
on a replica whose group catalog is not ready. Note that DEFAULT is returned
even while CPU scheduling is disengaged, because assignment and CPU slicing are
separate things. See the
function reference for
permissions and return values.
query_activity() carries a resource_group column, so you can see which group
each running query was admitted to. It follows the same rule, DEFAULT for an
unmapped principal and NULL only when no group was assigned:
SELECT resource_group, username, query_start, query
FROM query_activity()
WHERE resource_group IS NOT NULL
ORDER BY query_start;
Monitoring
Metrics require metrics.enabled=true, which is off by default. The Prometheus
endpoint then exposes one series per group, labelled with resource_group, plus
five instance-wide series describing the feature itself. Every name, type and
meaning is in the
metrics reference.
Two signals are worth alerting on: a non-zero
questdb_resource_groups_cpu_scheduler_degraded, which means CPU weights, CPU
limits and the fair policy are no longer enforced until the next restart, and
a steadily growing questdb_resource_group_admission_timeouts_total, which
means a group's queue settings are rejecting work the application expects to
succeed. questdb_resource_groups_cpu_managed_dispatch stays at 1 after the
scheduler degrades, because it reports whether the groups and their policies
require CPU scheduling, not whether it is working.
Errors clients see
| Message | Cause | Usual fix |
|---|---|---|
Resource Group admission queue is full | The group is at max_active_queries and its queue is at max_queued_queries | Raise the limits, or let the client retry |
Resource Group admission queue timeout | The query waited longer than queue_timeout | Raise queue_timeout or max_active_queries, or reduce concurrency |
| Either admission error while fetching a later page | A suspended cursor re-enters admission when the client asks for more rows | Adjust admission limits or retry the query with backoff; the failed cursor cannot continue |
query memory limit exceeded | A single-query, group or process memory limit rejected an allocation | scope in the message names the level: query, group or process. Reduce memory use or raise that limit |
Resource Group is assigned to an ACL entity | DROP RESOURCE GROUP while principals are still mapped | UNSET RESOURCE GROUP on those principals first; the message names one of them in [entity=...] |
built-in Resource Group cannot be dropped / cannot be renamed | DROP or RENAME on DEFAULT | Alter it instead |
Access denied for <principal> [USE RESOURCE GROUP on <group>] | The session or request chose a group the principal may not use, or the permission was revoked since | GRANT USE ON RESOURCE GROUP, or RESET RESOURCE GROUP to return to the mapped group |
Resource Group does not exist [name=...] | SET RESOURCE GROUP named a group that does not exist | Correct the name |
Resource Group chosen by SET RESOURCE GROUP or the resource_group parameter does not exist | The session's group was dropped or renamed, or the resource_group parameter names no group; names are case-sensitive except DEFAULT | SET RESOURCE GROUP to an existing group, RESET RESOURCE GROUP, or correct the parameter |
Resource Group switching needs a session, ... | SET RESOURCE GROUP sent over HTTP or another connection without a session | Send the resource_group parameter with the HTTP request |
SET LOCAL RESOURCE GROUP is not supported, ... | SET LOCAL used for a group, which applies to the whole session | Use SET RESOURCE GROUP |
Troubleshooting
A group's CPU share is not what I configured. Weights only apply while
groups compete. Check active_queries on both groups at the same moment: if one
is idle, the other is expected to use everything, unless it has a CPU limit. A
query that started before CPU scheduling engaged stays outside it until it next
suspends or finishes; every other query starts sharing at its next checkpoint.
A degraded scheduler, reported by
questdb_resource_groups_cpu_scheduler_degraded, stops sharing altogether. Also
confirm the work you are watching is managed at all, since ingestion, WAL apply
and view refresh are outside the feature. query_activity() shows the group
each running query belongs to, which is the quickest way to tell whether the
load you are watching is attributed where you expect.
A group with a CPU limit waits while the node is idle. That is the
difference between a limit and a weight: a limit holds even when nothing else
runs. Compare the group's use with cpu_limit_cores. If the group should use
idle CPU, raise the limit or remove it with RESET (cpu_limit) and rely on its
weight instead.
A group uses more CPU than its limit. Measure over a minute or more rather
than reading an instant: sample cpu_nanos_total twice and divide the
difference by the elapsed nanoseconds to get the cores the group used, which
compares directly with cpu_limit_cores. The counter covers the CPU that
queries use on their workers; process-level tools also show garbage collection,
JIT compilation and WAL apply, which no group is charged for. Under a fractional
limit a group can also exceed its rate on purpose: a parallel query above one
core runs past it for a moment before it repays it, and back-to-back
CREATE TABLE ... AS SELECT copies can keep a group close to a whole core. A
limit that comes to whole cores avoids both.
Queries queue at admission in a group with a CPU limit. A query keeps its
admission slot while it waits for its group's CPU budget, so under a tight limit
queued_queries grows although the group uses no more CPU than its limit. Raise
the limit if the wait is too long; raising max_active_queries only lets more
queries wait for the same budget.
A short query waits behind a copy in a group with a limit. A
CREATE TABLE ... AS SELECT keeps one of the group's workers until it finishes,
so when it holds the last one the group may have, the group's other queries wait
for it under either scheduling policy. Raise the limit so the group can hold
more than one worker, or copy with INSERT ... SELECT into an existing table,
which gives up its worker like any query.
Queries fail after SET RESOURCE GROUP succeeded. The group and the
permission to use it are checked again at the start of every managed query, so
a revoke fails the session's next query. The session remembers the group by
name, so dropping or renaming the group does the same. Choose the group again,
under its new name if it was renamed, or run RESET RESOURCE GROUP. See
errors clients see.
Queries on a fresh replica are not limited. Until the catalog has
replicated, a replica runs queries unmanaged and counts them in
questdb_resource_groups_catalog_lag_unmanaged_queries_total. The counter stops
growing once questdb_resource_groups_catalog_current reaches 1.
Promotion fails naming the resource group catalog. With the feature enabled,
SWITCH ROLE TO PRIMARY does not admit writes over a catalog that is unreadable
or that the replica has not received yet. The node lands in the UNKNOWN role
and still serves reads; the server log names
RESOURCE_GROUP_CATALOG_UNAVAILABLE with the reason. When the reason is
Resource Group catalog table is not locally available, replication has not
delivered the catalog table yet: wait for it and run SWITCH ROLE TO PRIMARY
again. Any other reason means the table cannot be read, and retrying does not
help: promote another replica, or restart this node as primary with
resource.groups.enabled=false, which turns the check into a logged error. See
Refusals and the torn state.
Startup fails naming the resource group catalog. The catalog table cannot be
created or read while the feature is enabled; the startup error names the
Resource Group catalog and the reason. Starting with
resource.groups.enabled=false logs the condition instead of failing.
Startup fails naming a worker pool. A pool that executes SQL is in legacy
mode while resource.groups.enabled=true was set explicitly. Either restore the
default Fiber mode for that pool or stop setting the property, which lets the
instance start with resource groups off.
The feature is off although the default is on. Check the log at startup for
an error naming a worker pool, and check SHOW PARAMETERS for the value that
took effect. A legacy SQL pool turns the feature off when the property is left
unset. SHOW PARAMETERS reporting resource.groups.enabled as true, together
with questdb_resource_groups_enabled at 1, confirms the feature is actually
running.
Limitations
- Only query statements are managed. See which statements are managed.
- Memory accounting covers tracked native query memory, not JVM heap, resident set size or memory-mapped table pages. See memory limits.
- CPU control is cooperative, so shares hold over a short window rather than instantaneously, and a query that cannot reach a cooperative checkpoint holds its worker until it does. See cooperative CPU scheduling.
- Principal mapping changes affect new queries. Group budgets change online; dropping a group retains its runtime state for existing queries until they finish. See changing a live instance.
- A CPU limit holds on average, not at every instant. A fractional limit lets a
group run about 100 milliseconds of its rate ahead, a parallel query above
one core can run past the rate before it repays it, and while every running
query of a group is a statement that cannot give up its worker, such as a
CREATE TABLE ... AS SELECT, the group may run one parallel task beyond its cap. See A CPU limit is a ceiling. - In a group with a CPU limit, a
CREATE TABLE ... AS SELECTruns single-threaded and keeps its worker until it finishes, and under a fractional limit back-to-back copies can keep a group close to a whole core however small its limit. In a group without a limit, its parallel tasks are not charged to the group. - A group chosen per session or request does not reach
COPY ... TOexports, exports through/exp, or queries over QWP, which run in the principal's mapped group. See SET RESOURCE GROUP. - A statement waiting for its group's CPU budget keeps its locks, such as the
table writer of an
INSERT ... SELECT. fairhas no weights between users, andcpu_limitapplies to a whole group, not to one user. A user who needs a different share or a cap of its own needs its own group.- With resource groups enabled, the instance keeps as many reduce queues
reserved for groups with a CPU limit as it has shared ones, which
cairo.page.frame.shard.countsets: 4, or the number of query workers if that is smaller. They cost about 2.3 KB of native memory per queue slot: about 150 KB with 4 query workers, and about 2.3 MB at the largest default queue size. Each group takes the next reserved queue the first time it runs a query under a limit and keeps it, so groups start to share reserved queues once more groups have taken one than there are queues, counting groups that were dropped since. Groups that share a reserved queue can hold up each other's parallel queries while one of them waits for its budget. A parallel query that started before its group had a limit stays on a shared queue until it finishes.