The sessions table contains database server session and associated client information. One row is returned for each session connected to each server in the current IMA management domain.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| server | 1 | varchar(64) | Database server name. |
| session_index | 0 | integer4 | Internal index for the current session. |
| session_id | 2 | varchar(32) | Internal identifier of the database server session |
| client_connect | 0 | varchar(32) | Database name opened by the client. |
| client_host | 0 | varchar(32) | Host name where the client process is running. |
| client_info | 0 | varchar(128) | The complete client connection string |
| client_pid | 0 | integer4 | Client process id. |
| client_tty | 0 | varchar(32) | Client terminal name. |
| client_user | 0 | varchar(32) | Login username of the client process. |
| db_name | 0 | varchar(32) | Database name opened by the session. |
| db_lockmode | 0 | varchar(32) | String representation of the database lockmode. |
| db_owner | 0 | varchar(32) | Owner of the opened database. |
| description | 0 | varchar(64) | Session description as set by the client. |
| effective_user | 0 | varchar(32) | Effective user name, this is the username specified with the -u flag. |
| effective_group | 0 | integer4 | Effective session group id. |
| server_pid | 0 | integer4 | Operating system process id of the server |
| real_user | 0 | varchar(32) | Real username, this is the client login name. |
| session_name | 0 | varchar(32) | Session name, for user sessions this is the same as the effective user. |
| terminal | 0 | varchar(32) | Terminal name attached to the client process. |