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

On Thu, Aug 31, 2017 at 1:50 AM, Syam Pillai <syam(at)engravgroup(dot)com> wrote:

> ​
> 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
>
>
​state = "idle" which means that they query column is showing the last
executed query - not something that is presently running.

David J.
​