Skip site navigation (1) Skip section navigation (2)

Finding current SQL activity

From: Thusitha Kodikara <kthusi(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Finding current SQL activity
Date: 2006-10-18 08:06:06
Message-ID: 20061018080606.90849.qmail@web56608.mail.re3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi,

I would like to find the current (and very recent) SQL statements.  I went through 'pg_stat_activity'. But it showed only the current statement I was issuing. Going through the defintion of 'pg_stat_activity' I came across pg_stat_get_backend_activity(), and I thought if I could get the source of this function I would be able to further. But I can't see the definition of this function.

Am I on the right direction, or is there an easier way? I would appreciate if someone can give some suggestions.

Thanks in advance.

-Thusitha

Responses

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2006-10-18 09:06:32
Subject: Re: Finding current SQL activity
Previous:From: binberatiDate: 2006-10-18 02:35:17
Subject: FastCgi / PostgreSQL: FATAL: Ident authentication failed for user "user_name"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group