Logging SQL queries?

From: Steve Lane <slane(at)fmpro(dot)com>
To: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Logging SQL queries?
Date: 2002-07-17 03:40:14
Message-ID: B95A514E.1057D%slane@fmpro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all:

I want to do some profiling of a large application I run under postgres.
Ideally I'd like to capture just the queries that are submitted to the
database. It would be rather annoying to have to log them from the
application layer, so I'm hoping there's some suitable log-level setting on
the back end that can do this. Something that could log only the queries to
a different specific file would be excellent, but any flavor of this would
be good.

Thanks,

steve

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-17 03:50:12 Re: COPY seems to work, but no data in the table
Previous Message Tom Lane 2002-07-17 03:30:58 Re: Fortran functions?