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 […]

Primary keys

SELECT cra.conseq, a.attname FROM _t_class t INNER JOIN _t_attribute a ON t.oid = a.attrelid AND t.relname = ‘CUSTOMER’ INNER JOIN _t_constraint c ON t.oid = c.conrelid AND c.contype = ‘p’ […]