User sessions

select current_sid;

select *
from _t_sessctx;

select *
from _vt_dbos_connection;

SELECT s.id,
s.status,
s.dbname,
(cast(s.conntime as timestamp) + tofs.tzoffset) connection_started,
now() current_dt,
now() – (cast(s.conntime as timestamp) + tofs.tzoffset) connection_duration
FROM _v_session s,
_vt_pg_time_offset tofs;