pg_stat_activity

From: Bala Venkat <akpgeek(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: pg_stat_activity
Date: 2014-04-02 19:00:20
Message-ID: CACnhOfJkBq3KAZQuzsyrRracjTYs=dbxoWgdEtexrmETf9eG-A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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..

Attachment Content-Type Size
image/png 57.7 KB

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2014-04-02 19:17:27 Re: pg_stat_activity
Previous Message Victor Sterpu 2014-04-02 18:24:43 Re: Lock problem