"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
>> If you haven't a clue, try attaching to each process with a debugger and
>> printing out the global variable debug_query_string.
> How do I do that?
Having identified the process PIDs, you can do
gdb /path/to/postgres-executable
gdb> attach PID
gdb> p debug_query_string
gdb> bt -- might as well do this while you're here
gdb> quit
This assumes you have gdb handy. There is a way to do this with adb
too, but I don't use it enough to remember.
regards, tom lane