Adarsh Sharma escribió: > [cur:1835/26FAFEF8, xid:471303469, rmid:11(Btree), len/tot_len:18/5754, > info:8, prev:1835/26FAFEB0] insert_leaf: s/d/r:1663/1228184/1363155 tid > 28366/20
> Is dere any document where i can co-relate this tid with relations/indexes > in the database. I tried but not able to find :- > > wap_prod_adserve=# SELECT relname, oid FROM pg_class where oid=1363155 ; > relname | oid > ---------+----- > (0 rows) Probably the reason you don't find any rows is because you're querying the wrong column. The "r" stands for relfilenode, and thus you must use relfilenode in the WHERE clause, not oid: SELECT relname, oid FROM pg_class where relfilenode=1363155 ; -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
