Home > mailing lists

pg_stat_activity - Mailing list pgsql-general

From	Bala Venkat
Subject	pg_stat_activity
Date	April 2, 2014 22:00:27
Msg-id	CACnhOfJkBq3KAZQuzsyrRracjTYs=dbxoWgdEtexrmETf9eG-A@mail.gmail.com Whole thread Raw
Responses	Re: pg_stat_activity (Jeff Janes <jeff.janes@gmail.com>)
List	pgsql-general

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..

From: "Victor Sterpu"
Date: 02 April 2014, 21:25:47
Subject: Re: Lock problem

From: Jeff Janes
Date: 02 April 2014, 22:17:34
Subject: Re: pg_stat_activity