Re: [JDBC] Statement is still active at the back-end even after closing

​

Query executed to check the activity:

SELECT pid, datname, now() - pg_stat_activity.query_start AS duration, state, query

FROM pg_stat_activity

WHERE now() - pg_stat_activity.query_start > interval '1 second';

Output from psql:

  pid  | datname |    duration     | state |           query           

-------+---------+-----------------+-------+---------------------------

 17775 | xxxx   | 00:00:07.481294 | idle  | SELECT 1 FROM core.Person