How to trace client sql requests?
| От | James B. Byrne |
|---|---|
| Тема | How to trace client sql requests? |
| Дата | |
| Msg-id | 59259.216.185.71.24.1247247537.squirrel@webmail.harte-lyne.ca обсуждение исходный текст |
| Ответы |
Re: How to trace client sql requests?
Re: How to trace client sql requests? |
| Список | pgsql-general |
I have a situation with a Rails project where test data in mysteriously "disappearing" in the middle of a test run. I would like to see the exact SQL of all client requests issued against a single table during a fixed time span. How can I best accomplish this in PostgreSQL? #client_min_messages = notice #log_min_messages = notice #log_min_duration_statement = -1 ... #log_duration = off Which of these, if any, should I alter; and to what? Am I constrained to system wide logging or can this be enabled by database? Regards, -- *** E-Mail is NOT a SECURE channel *** James B. Byrne mailto:ByrneJB@Harte-Lyne.ca Harte & Lyne Limited http://www.harte-lyne.ca 9 Brockley Drive vox: +1 905 561 1241 Hamilton, Ontario fax: +1 905 561 0757 Canada L8E 3C3
В списке pgsql-general по дате отправления: