Tracing used SQL statments

Поиск
Список
Период
Сортировка
От Matthew Pinhorn
Тема Tracing used SQL statments
Дата
Msg-id 20030625152610.B28118@iona.com
обсуждение исходный текст
Ответы Re: Tracing used SQL statments  (Andrew Perrin <clists@perrin.socsci.unc.edu>)
Re: Tracing used SQL statments  (Charles Hornberger <charlie@hss.caltech.edu>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: [SQL] database & table size
Следующее
От: Andrew Perrin
Дата:
Сообщение: Re: Tracing used SQL statments