logging statements from hibernate to valid SQL

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема logging statements from hibernate to valid SQL
Дата
Msg-id 1dd6057e1002090200i742a26eau4c01f2743ad320ed@mail.gmail.com
обсуждение исходный текст
Ответы Re: logging statements from hibernate to valid SQL  (Andy Dale <andy.dale@gmail.com>)
Список pgsql-general
Hi,
I'm trying to log statements that are being fired from hibernate, so that i can benchmark them without hibernate itself.
I want to fire the SQL at the database directly and see what difference i can make by tweaking things.

But when i set log_statement = 'all', the logging looks like this:

2010-02-09 00:12:32 CET LOG:  execute <unnamed>: select nextval ('schema.sequence')
2010-02-09 00:12:32 CET LOG:  execute <unnamed>: insert into schema.tabe (field1, field2, field3, ...) values ($1, $2, $3, ...)
2010-02-09 00:12:32 CET DETAIL:  parameters: $1 = '1', $2 = NULL, $3 = '654767', ...)

Now, how can i get these $1 etc values to be replaced with their values, so that i can produce valid SQL?
Is there a postgresql.conf setting, or maybe some perl script that goes around?
(of course, it's more than just 3 lines.... I can't do it by hand.)

thx!

WBL

--
"Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw

В списке pgsql-general по дате отправления:

Предыдущее
От: Anton Maksimenkov
Дата:
Сообщение: Re: Memory Usage and OpenBSD
Следующее
От: Fredric Fredricson
Дата:
Сообщение: Re: Order by and strings