SHOW_CONNECTIONS

SHOW_CONNECTIONS returns a list of active sessions on the current worker.

To see sessions across the cluster, see SHOW_SERVER_STATUS.

Permissions

The role must have the SUPERUSER permissions.

Syntax

show_connections_statement ::=
    SELECT SHOW_CONNECTIONS()
    ;

Parameters

None

Returns

This function returns a list of active sessions. If no sessions are active on the worker, the result set will be empty.

Result columns
ip The worker hostname or IP
conn_id Connection ID
conn_start_time Connection start timestamp
stmt_id Statement ID. Connections with no active statement display -1.
stmt_start_time Statement start timestamp
stmt Statement text

Notes

  • This utility shows the active connections. Some sessions may be actively connected, but not currently running a statement.
  • A connection is typically reused. There could be many statements under a single connection ID.

Examples

Using SHOW_CONNECTIONS to get statement IDs

t=> SELECT SHOW_CONNECTIONS();
ip           | conn_id | conn_start_time     | stmt_id | stmt_start_time     | stmt
-------------+---------+---------------------+---------+---------------------+--------------------------
192.168.1.91 |     103 | 2019-12-24 00:01:27 |     129 | 2019-12-24 00:38:18 | SELECT GET_DATE(), * F...
192.168.1.91 |      23 | 2019-12-24 00:01:27 |      -1 | 2019-12-24 00:01:27 |
192.168.1.91 |      22 | 2019-12-24 00:01:27 |      -1 | 2019-12-24 00:01:27 |
192.168.1.91 |      26 | 2019-12-24 00:01:28 |      -1 | 2019-12-24 00:01:28 |

The statement ID we’re interested in is 129. We can see the connection started at 00:01:27, while the statement started at 00:38:18.