The system tables like  only track active node usage, not idle nodes. Since idle nodes also count toward the pool's maximum capacity, their status cannot be directly captured through queries on system tables. To monitor both active and idle nodes within a pool, you’ll need to use the API to periodically fetch the pool status, as it provides comprehensive details, including idle nodes. Unfortunately, there isn’t a direct query-based solution to achieve this.