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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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