X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 49F7AD8505 for ; Thu, 1 Sep 2005 23:03:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 92434-06 for ; Fri, 2 Sep 2005 02:03:46 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 2C355D8038 for ; Thu, 1 Sep 2005 23:03:45 -0300 (ADT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j8223k9a028150 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 1 Sep 2005 20:03:49 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j8223kSl058479; Thu, 1 Sep 2005 20:03:46 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j8223kbR058478; Thu, 1 Sep 2005 20:03:46 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 1 Sep 2005 20:03:46 -0600 From: Michael Fuhr To: =?iso-8859-1?Q?Jo=FFffffffffffe3o?= Carvalho Cc: pgsql-sql@postgresql.org Subject: Re: queries problems Message-ID: <20050902020346.GA58397@winnie.fuhr.org> Reply-To: pgsql-sql@postgresql.org References: <20050902005048.GA44591@winnie.fuhr.org> <20050902013345.76648.qmail@web50603.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20050902013345.76648.qmail@web50603.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.005 required=5 tests=[AWL=0.005] X-Spam-Level: X-Archive-Number: 200509/6 X-Sequence-Number: 22553 [Please copy the mailing list on replies so others can contribute to and learn from the discussion.] On Thu, Sep 01, 2005 at 10:33:44PM -0300, Joćo Carvalho wrote: > Michael Fuhr escreveu: > > http://www.postgresql.org/docs/8.0/static/monitoring.html > > http://www.postgresql.org/docs/8.0/static/catalogs.html > > Tanks a lot, it is part of that information in there. I resolved > the schema problem and probably the toast table problem. but I still > can“t get any information in there about the users of the locks and > wich atributes are part of each index. For locks, you can join pg_locks.pid with pg_stat_activity.procpid and get user names from pg_stat_activity.usename. http://www.postgresql.org/docs/8.0/static/view-pg-locks.html http://www.postgresql.org/docs/8.0/static/monitoring-stats.html#MONITORING-STATS-VIEWS-TABLE For index attributes, see pg_index.indkey and pg_attribute.attnum, or the pg_get_indexdef() function. http://www.postgresql.org/docs/8.0/static/catalog-pg-index.html http://www.postgresql.org/docs/8.0/static/catalog-pg-attribute.html http://www.postgresql.org/docs/8.0/static/functions-info.html#FUNCTIONS-INFO-CATALOG-TABLE -- Michael Fuhr