From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Jan Oravec <oravecja(at)intrak(dot)tuke(dot)sk> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: backward SQL query |
Date: | 2002-02-28 15:41:10 |
Message-ID: | 3C7E4F96.622A82C4@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
in 7.2 PGSQL you can do select * from pg_stat_activity ;
provided you have enable statistics collection.
regds
Mallah.
Karel Zak wrote:
> On Thu, Feb 28, 2002 at 12:34:23PM +0100, Jan Oravec wrote:
> >
> > I have WEB aplication, whitch browse some data from database.
> > Can anybody tell me how I can know, which SQL query was used for display
> > this data, without know source of aplication, whitch use it and when I'm
> > administrator of this database. I want it use for control which data are
> > correct and whitch not.
>
> See your $(PGDATA)/potgresql.conf and debug_* options, an example
> debug_print_query.
>
> Or may be you can try postmaster "-d" option.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Céline Rivière | 2002-02-28 15:44:42 | CREATE FUNCTION and LANGUAGE 'C' |
Previous Message | Céline Rivière | 2002-02-28 14:44:31 | Stored procedures returning TEXT |