Re: find query beening executed

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Jaume Sabater <jsabater(at)gmail(dot)com>
Cc: Julius Tuskenis <julius(at)nsoft(dot)lt>, pgsql-admin(at)postgresql(dot)org
Subject: Re: find query beening executed
Date: 2009-10-22 09:47:31
Message-ID: dcc563d10910220247x3955cb51p1b6bfcc0b71a7af7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Oct 22, 2009 at 2:50 AM, Jaume Sabater <jsabater(at)gmail(dot)com> wrote:
> On Thu, Oct 22, 2009 at 10:38 AM, Julius Tuskenis <julius(at)nsoft(dot)lt> wrote:
>
>> Thank you. I'll ask to log long lasting queries, but still - isn't there a
>> way to see on what postgres works in real time?
>
> I use pg_top for that.

Does it give full queries, even if they're long? That would be really
useful sometimes.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message shruti shruti 2009-10-22 11:51:03 cursor problem
Previous Message Jaume Sabater 2009-10-22 08:50:47 Re: find query beening executed