Re: Too many IDLE in current_query

"francescoboccacci@libero.it" <francescoboccacci@libero.it> wrote:

> i'm checking my postgresql server to try to monitoring all
> activity that are running.
> i run this query:
>
> postgres=#  select
> current_timestamp - query_start as runtime,
> current_query
> from pg_stat_activity
> order by 1 desc;

> The strange thing is that there are quesries that are running from
> 34 days.I think is strange.

query_start is the last time a query started; it doesn't indicate
that it's still running.  In fact <IDLE> means it isn't.  You should
probably exclude rows where xact_start is null or where
current_query = '<IDLE>'.

-Kevin