crdb.txt

 $ cockroach sql --url 'postgres://postgres:<PW>@us-central1-352.gcp-us-central1.cockroachlabs.cloud:26257/satellite?sslmode=verify-full&sslrootcert=us-central1-ca.crt' --execute "select node_id, session_id, session_start, oldest_query_start, age(clock_timestamp(), oldest_query_start::timestamptz), substring(active_queries,0,50) as query from [show sessions] where oldest_query_start is not null order by oldest_query_start asc limit 10;"
  node_id |            session_id            |          session_start           |        oldest_query_start        |       age       |                       query
+---------+----------------------------------+----------------------------------+----------------------------------+-----------------+---------------------------------------------------+
        1 | 15ea0c2329edfa000000000000000001 | 2020-01-15 11:32:44.513491+00:00 | 2020-01-15 12:59:16.03245+00:00  | 02:53:43.354511 | INSERT INTO used_serials(serial_number_id, storag
        1 | 15ea0c232b4c65570000000000000001 | 2020-01-15 11:32:44.536482+00:00 | 2020-01-15 13:00:10.090745+00:00 | 02:52:49.29626  | INSERT INTO used_serials(serial_number_id, storag
        1 | 15ea0c4e43c3a9ad0000000000000001 | 2020-01-15 11:35:49.630511+00:00 | 2020-01-15 13:00:33.254493+00:00 | 02:52:26.132524 | INSERT INTO used_serials(serial_number_id, storag
        1 | 15ea0da864d856470000000000000001 | 2020-01-15 12:00:36.244246+00:00 | 2020-01-15 13:00:58.689772+00:00 | 02:52:00.697258 | INSERT INTO used_serials(serial_number_id, storag
        3 | 15ea0da86c0f82920000000000000003 | 2020-01-15 12:00:36.365279+00:00 | 2020-01-15 13:01:26.296956+00:00 | 02:51:33.090083 | INSERT INTO used_serials(serial_number_id, storag
        3 | 15ea0da86dae6d650000000000000003 | 2020-01-15 12:00:36.392497+00:00 | 2020-01-15 13:02:15.923785+00:00 | 02:50:43.463263 | INSERT INTO used_serials(serial_number_id, storag
        1 | 15ea0db5d04146840000000000000001 | 2020-01-15 12:01:33.880794+00:00 | 2020-01-15 13:03:16.341522+00:00 | 02:49:43.045535 | INSERT INTO used_serials(serial_number_id, storag
        3 | 15ea0d933c6653800000000000000003 | 2020-01-15 11:59:05.371346+00:00 | 2020-01-15 13:03:56.815243+00:00 | 02:49:02.571822 | INSERT INTO used_serials(serial_number_id, storag
        1 | 15ea0da86a59d1a20000000000000001 | 2020-01-15 12:00:36.336597+00:00 | 2020-01-15 13:04:07.095889+00:00 | 02:48:52.291184 | INSERT INTO used_serials(serial_number_id, storag
        3 | 15ea0dadcebd40af0000000000000003 | 2020-01-15 12:00:59.495689+00:00 | 2020-01-15 13:04:10.15396+00:00  | 02:48:49.233123 | INSERT INTO used_serials(serial_number_id, storag
(10 rows)