Postgres Pro
Downloads
Home   >   mailing lists

Tracing used SQL statments - Mailing list pgsql-admin

From Matthew Pinhorn
Subject Tracing used SQL statments
Date
Msg-id 20030625152610.B28118@iona.com
Whole thread Raw
Responses Re: Tracing used SQL statments  (Andrew Perrin <clists@perrin.socsci.unc.edu>)
Re: Tracing used SQL statments  (Charles Hornberger <charlie@hss.caltech.edu>)
List pgsql-admin
Tree view 
Hello,

    I am wondering if somebody can help me. I want to know if there is a
way that I can make some kind of a log file of all of the SQL statements that
are used in my database. It was suggested to make that I could make a trace
of them and I am not sure how to do that.

    I have inherited a database from a former co-worker and now I am
starting to get crashes. The crashes has SET TRANSACTION ISOLATION LEVEL
messages in the log file. So I think that there is a lock on the database.
 And if I can see the queries that are causing the crash I might be able
to fix the problem.

Thanks

Matthew

--
Matthew Pinhorn                         E-Mail: mailto:matthew.pinhorn@iona.com
IONA                                     WWW:    http://www.orbacus.com
Making Software Work Together (tm)       Phone:  (709) 738-3725 x 10

pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [SQL] database & table size
Next
From: Andrew Perrin
Date:
Subject: Re: Tracing used SQL statments