On Tue, Nov 22, 2011 at 7:49 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Lonni J Friedman <netllama@xxxxxxxxx> writes: >> I suspect you're right. I just ran strace against that PID again, and >> now all the lseek & read FD's are referrring to a different number >> (115), so that means its moved onto something new since I looked a few >> hours ago? > >> Anyway, I think this is what you were referring to: >> /proc/30188/fd/115 -> /var/lib/pgsql/data/base/64793/72633.10 > >> How do I correlate that file to an actual database object? > > 64793 is the pg_database.oid of the database, and 72633 is the > pg_class.relfilenode value of the table/index. Its definitely an index. Thanks for your help, I just need to be patient now that I understand how to better monitor this. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
