Persistence and system conection

The connection record shows existing connection. If the connection no longer exists, you won't be able to see it in the "show sys conn" output.

Persistence table can hold records even after the connection is dropped depending on timeout interval for that persistence record. So, a connection that is no longer active will not exist in the connection table but can exist as a persistence record in the persistence table till the persistence timeout is reached.

When the same client IP initiates a connection before the persistence timeout, it will be sent to the same backend server based on the persistence record.