pg_stat_activity

[Bala Venkat <akpgeek@xxxxxxxxx>]

We are using postgres 9.0.  When I looked at the pg_stat_activity table.

I have some rows where there is difference of 2 hours between  backend_start  and xact_start

But there is only few milli seconds between xact_start and query_start. 

All them have wait as false.

My question is,  is the query still executing and also why would there be that much time difference between backend_start  and xact_start

Appreciate your thoughts and inputs..

thanks a lot..

Attachment: Screen Shot 2014-04-02 at 2.59.32 PM.png
Description: PNG image

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general