X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 45B1E52AB2
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 15 Jul 2005 05:19:29 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 80418-06
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Fri, 15 Jul 2005 08:19:20 +0000 (GMT)
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.177])
	by svr1.postgresql.org (Postfix) with ESMTP id BDFE652BC7
	for <pgsql-performance@postgresql.org>;
	Fri, 15 Jul 2005 05:19:16 -0300 (ADT)
Received: from p548F1BEE.dip0.t-ipconnect.de [84.143.27.238]
	(helo=pse.dyndns.org)
	by mrelayeu.kundenserver.de with ESMTP (Nemesis),
	id 0ML21M-1DtLPf078E-0005Zr; Fri, 15 Jul 2005 10:19:15 +0200
Received: from pse1 ([192.168.0.3]) by pse.dyndns.org with esmtp (Exim 4.44)
	id 1DtLPd-0003rO-I9; Fri, 15 Jul 2005 10:19:13 +0200
Message-ID: <42D7717C.7020208@pse-consulting.de>
Date: Fri, 15 Jul 2005 08:19:08 +0000
From: Andreas Pflug <pgadmin@pse-consulting.de>
User-Agent: Mozilla Thunderbird 1.0 (X11/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Agha Asif Raza <aghaasif@gmail.com>,
	pgsql-performance@postgresql.org
Subject: Re: Profiler for PostgreSQL
References: <200507140627.j6E6RWv11806@candle.pha.pa.us>
In-Reply-To: <200507140627.j6E6RWv11806@candle.pha.pa.us>
X-Enigmail-Version: 0.89.5.0
X-Enigmail-Supports: pgp-inline, pgp-mime
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:0ce7ee5c3478b8d72edd8e05ccd40b70
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.314 tagged_above=0 required=5 tests=AWL,
	FORGED_RCVD_HELO
X-Spam-Level: 
X-Archive-Number: 200507/213
X-Sequence-Number: 13454

Bruce Momjian wrote:
> Agha Asif Raza wrote:
> 
>>Is there any MS-SQL Server like 'Profiler' available for PostgreSQL? A 
>>profiler is a tool that monitors the database server and outputs a detailed 
>>trace of all the transactions/queries that are executed on a database during 
>>a specified period of time. Kindly let me know if any of you knows of such a 
>>tool for PostgreSQL.
>> Agha Asif Raza
> 
> 
> Sure see log_statement in postgresql.conf.  There are a lot of settings
> in there to control what is logged.

There's nothing really comparable at the moment, but some tasks can be 
done with log_statement.
I'm planning to implement a full-blown profiling like MSSQL's, but don't 
expect this too soon (I'm thinking about this for a year now. So many 
plans, so little time).

Regards,
Andreas