Re: Database is slow, vacuum hangs - Mailing list pgsql-admin

From Tom Lane
Subject Re: Database is slow, vacuum hangs
Date
Msg-id 1849.1015020724@sss.pgh.pa.us
Whole thread Raw
In response to Re: Database is slow, vacuum hangs  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
"Nick Fankhauser" <nickf@ontko.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

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Database is slow, vacuum hangs
Next
From: Zak Greant
Date:
Subject: Re: PHP ODBC conflict