reference/catalog/pg_resqueue_status.html.md.erb

---
title: pg_resqueue_status
---

The `pg_resqueue_status` view allows administrators to see status and activity for a workload management resource queue. It shows how many queries are waiting to run and how many queries are currently active in the system from a particular resource queue.

<a id="topic1__fp141982"></a>

<table>
<caption><span class="tablecap">Table 1. pg\_resqueue\_status</span></caption>
<colgroup>
<col width="25%" />
<col width="25%" />
<col width="25%" />
<col width="25%" />
</colgroup>
<thead>
<tr class="header">
<th>column</th>
<th>type</th>
<th>references</th>
<th>description</th>
</tr>
</thead>
<tbody>
<tr class="odd">
<td><code class="ph codeph">rsqname</code></td>
<td>name</td>
<td>pg_resqueue_ rsqname</td>
<td>The name of the resource queue.</td>
</tr>
<tr class="even">
<td><code class="ph codeph">segmem</code></td>
<td>text</td>
<td> </td>
<td>The calculated virtual segment memory resource quota.</td>
</tr>
<tr class="odd">
<td><code class="ph codeph">segcore</code></td>
<td>text</td>
<td> </td>
<td>The calculated virtual segment core resource quota.</td>
</tr>
<tr class="even">
<td><code class="ph codeph">segsize</code></td>
<td>text</td>
<td> </td>
<td>The number of virtual segments that can be allocated to the resource queue.</td>
</tr>
<tr class="odd">
<td><code class="ph codeph">segsizemax</code></td>
<td>text</td>
<td> </td>
<td>The maximum number of virtual segments that can be allocated to the resource queue.</td>
</tr>
<tr class="even">
<td><code class="ph codeph">inusemem</code></td>
<td>text</td>
<td> </td>
<td>Aggregated in-use memory by running statements.</td>
</tr>
<tr class="odd">
<td><code class="ph codeph">inusecore</code></td>
<td>text</td>
<td> </td>
<td>Aggregated in-use core by running statements.</td>
</tr>
<tr class="even">
<td><code class="ph codeph">rsqholders</code></td>
<td>text</td>
<td> </td>
<td>The number of resource holders for running statements. A resource holder is a running statement whose allocated resources from the resource manager has not been returned yet., In other words, the statement holds some resources allocated from the resource manager.</td>
</tr>
<tr class="odd">
<td><code class="ph codeph">resqwaiters</code></td>
<td>text</td>
<td> </td>
<td>The number of resource requests that are queued and waiting for the resource.</td>
</tr>
<tr class="even">
<td><code class="ph codeph">paused</code></td>
<td>text</td>
<td> </td>
<td>The dynamic pause status of the resource queue. There are three possible statuses:
<ul>
<li><code class="ph codeph">T</code> : Queue is paused for the allocation of resources to queued and incoming requests.</li>
<li><code class="ph codeph">F</code> : Queue is in a normal working status.</li>
<li><code class="ph codeph">R</code> : Queue is paused and may have encountered resource fragmentation.</li>
</ul></td>
</tr>
</tbody>
</table>

: <span class="tablecap">Table 1. pg\_resqueue\_status</span>