Received: from trade-india.com (unknown [130.94.20.28]) by postgresql.org (Postfix) with SMTP id 07312475BB1 for ; Thu, 28 Feb 2002 10:37:50 -0500 (EST) Received: (qmail 5442 invoked from network); 28 Feb 2002 15:43:29 -0000 Received: from ptil-235-129-del.primus-india.net (HELO trade-india.com) (203.196.129.235) by 130.94.22.209 with SMTP; 28 Feb 2002 15:43:29 -0000 Message-ID: <3C7E4F96.622A82C4@trade-india.com> Date: Thu, 28 Feb 2002 21:11:10 +0530 From: Rajesh Kumar Mallah X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: Jan Oravec Cc: pgsql-sql@postgresql.org Subject: Re: backward SQL query References: <3C7E15BF.000003.01684@elvin.intrak.tuke.sk> <20020228125502.B20893@zf.jcu.cz> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/451 X-Sequence-Number: 6872 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. >