Finding current SQL activity - Mailing list pgsql-admin

From Thusitha Kodikara
Subject Finding current SQL activity
Date
Msg-id 20061018080606.90849.qmail@web56608.mail.re3.yahoo.com
Whole thread Raw
Responses Re: Finding current SQL activity
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Missing Earth Distance Functions Under Debian
Next
From: Achilleas Mantzios
Date:
Subject: Re: Finding current SQL activity