lightdb for postgresql 系列【查看活跃session信息】

SELECT query_id                                                      as sql_id,
       pid                                                           as pid,
       host(client_addr)                                             AS cl_addr,
       client_port                                                   AS cl_port,
       datname,
       usename,
       application_name                                              AS application_name,
       backend_type,
       wait_event_type                                               AS wait_event_type,
       wait_event,
       state,
       date_trunc('seconds', clock_timestamp() - xact_start)::text   AS xact_age,
       date_trunc('seconds', clock_timestamp() - query_start)::text  AS query_age,
       date_trunc('seconds', clock_timestamp() - state_change)::text AS change_age,
       regexp_replace(query, E'\\s+', ' ', 'g')                      AS query
FROM lt_stat_activity
WHERE -- ((clock_timestamp() - xact_start) > '{{.QueryAgeThresh}}'::interval
      --OR (clock_timestamp() - query_start) > '{{.QueryAgeThresh}}'::interval)  AND
      state != 'idle' -- if .ShowNoIdle
ORDER BY pid DESC;