[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: Re: [SQL] backward SQL query
From: Rajesh Kumar Mallah <mallah () trade-india ! com>
Date: 2002-02-28 15:53:10
[Download RAW message or body]
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.
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic