Re: queries problems - Mailing list pgsql-sql

From Joÿffffffffffe3o Carvalho
Subject Re: queries problems
Date
Msg-id 20050908223348.21917.qmail@web50614.mail.yahoo.com
Whole thread Raw
In response to Re: queries problems  (Michael Fuhr <mike@fuhr.org>)
Responses Re: queries problems
List pgsql-sql
The problem here is to compare int2vector with int2.
 
Regards
João Carvalho


Michael Fuhr <mike@fuhr.org> escreveu:
[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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


Yahoo! Messenger com voz: PROMOÇÃO VOCÊ PODE LEVAR UMA VIAGEM NA CONVERSA. Participe!

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Statistics from Sequences
Next
From: Michael Fuhr
Date:
Subject: Re: queries problems