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 07771D861B for ; Thu, 1 Sep 2005 21:50:52 -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 76082-05 for ; Fri, 2 Sep 2005 00:50:49 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id 71327D860B for ; Thu, 1 Sep 2005 21:50:47 -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 j820omOJ028095 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Thu, 1 Sep 2005 18:50:51 -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 j820omIT044686; Thu, 1 Sep 2005 18:50:48 -0600 (MDT) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j820omaY044685; Thu, 1 Sep 2005 18:50:48 -0600 (MDT) (envelope-from mfuhr) Date: Thu, 1 Sep 2005 18:50:48 -0600 From: Michael Fuhr To: =?iso-8859-1?Q?Jo=FFffffffffffe3o?= Carvalho Cc: pgsql-sql@postgresql.org Subject: Re: queries problems Message-ID: <20050902005048.GA44591@winnie.fuhr.org> References: <20050902003300.57378.qmail@web50613.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: <20050902003300.57378.qmail@web50613.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/5 X-Sequence-Number: 22552 On Fri, Sep 02, 2005 at 12:33:00AM +0000, Jo˙ffffffffffe3o Carvalho wrote: > I want information about the following statistics: > -List lock users > -Show schema owners, it may also so more schema information > -Check if a certain table has a toast table See "Monitoring Database Activity" and "System Catalogs" in the documentation. Here are links to the documentation for the latest released version of PostgreSQL: http://www.postgresql.org/docs/8.0/static/monitoring.html http://www.postgresql.org/docs/8.0/static/catalogs.html -- Michael Fuhr