Calculate Request Queue Length: Quick Tip
Jim Knicely, Vertica Principal Solution Architect
November 7, 2018
The RESOURCE_ACQUISITIONS system table retains information about resources (memory, open file handles, threads) acquired by each running request. Each request is uniquely identified by its transaction and statement IDs within a given session. From this system table, you can calculate how long a request was queued in a resource pool before acquiring the resources it...