Re: Lock and pg_stat

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "Desbiens, Eric" <edesbiens(at)lxdata(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Lock and pg_stat
Date: 2013-05-14 12:44:56
Message-ID: CA+Tgmoa8HmzG8uufz3u4UnimFweOoSU3oDmdLvESHrsx32=QZw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, May 13, 2013 at 9:05 AM, Desbiens, Eric <edesbiens(at)lxdata(dot)com> wrote:
> I tried also:
>
> select * from pg_class where oid=30352481;
>
> but didn't got anything

You probably want where relfilenode=30352481.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christoph Berg 2013-05-15 06:48:20 Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
Previous Message Robert Haas 2013-05-14 12:12:55 Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1