如何查看当前会话ID以及登录时间?

答：执行如下SQL可查看当前会话ID以及登录时间。

--查看当前会话ID。
gaussdb=# SELECT pg_backend_pid() AS session_id;
session_id    
-----------------
 139883131631360
(1 row)

--查看当前会话的登录时间。
gaussdb=# SELECT pg_stat_activity.backend_start AS login_time FROM pg_stat_activity WHERE pg_stat_activity.pid = pg_backend_pid();
 login_time           
-------------------------------
 2024-07-19 16:39:45.429437+08
(1 row)