Collect additional Session details such as sessions variables and the last statement execution timestamp #74257
Description
There has been feedback on improving SQL observability at the Sessions level. Specifically, we should provide additional observability information into Sessions such as
- #transaction executions (done)
- List of transaction fingerprints (IDs) (done)
- total 'active' time (done)
- Session variables
- Last statement execution time (today we have oldest_query_start which represents the current start time of the active statement)
- Last transaction execution time and the text
- Most Recent Transaction (entire SQL text of the most recent transaction)
Feedback from customers:
- It is not easily identifiable as to what is keeping a session connection open
- Are connection parameters having an adverse affect within the environment?
Related issue: #67888
Epic: CRDB-9087
Jira issue: CRDB-11992