Postgres Pro
Downloads
Home   >   mailing lists

Re: Lock and pg_stat - Mailing list pgsql-performance

From Robert Haas
Subject Re: Lock and pg_stat
Date
Msg-id CA+Tgmoa8HmzG8uufz3u4UnimFweOoSU3oDmdLvESHrsx32=QZw@mail.gmail.com
Whole thread Raw
In response to Lock and pg_stat  ("Desbiens, Eric" <edesbiens@lxdata.com>)
List pgsql-performance
Tree view 
On Mon, May 13, 2013 at 9:05 AM, Desbiens, Eric <edesbiens@lxdata.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

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1
Next
From: Christoph Berg
Date:
Subject: Re: RT3.4 query needed a lot more tuning with 9.2 than it did with 8.1