Skip site navigation (1) Skip section navigation (2)

Re: gin/gist indexes show twice

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Timon <timosha(at)gmail(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: gin/gist indexes show twice
Date: 2011-03-28 09:28:25
Message-ID: 4D9054B9.8080006@lelarge.info (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le 28/03/2011 10:57, Timon a écrit :
> yup, seem that problem is not with git/gist indexes.
> I have found the query for this grid in file
> pgadmin/schema/pgIndex.cpp line 670.
> 
> I run this query in Sql Query tool and get same results:
> SELECT
> 	indexrelname,
> 	idx_scan, idx_tup_read, idx_tup_fetch,
> 	pg_size_pretty(pg_relation_size(indexrelid)),
> 	refclassid, refobjid, deptype,
> 	refclassid::regclass, refobjid::regclass
> FROM pg_stat_all_indexes stat
> 	JOIN pg_class cls ON cls.oid=indexrelid
> 	LEFT JOIN pg_depend dep ON (dep.classid = cls.tableoid AND dep.objid
> = cls.oid AND dep.refobjsubid = '0')
> --	LEFT OUTER JOIN pg_constraint con ON (con.tableoid = dep.refclassid
> AND con.oid = dep.refobjid)
> WHERE schemaname = 'public'
> 	AND
> 	stat.relname = 'user_attr_text'
> 	--AND con.contype IS NULL
> ORDER BY indexrelname
> 

I'm wondering why you commented the left join on pg_constraint. It could
be your issue.

pgAdmin doesn't have these lines commented, and, AFAICT, it works. See
http://git.postgresql.org/gitweb?p=pgadmin3.git;a=blob;f=pgadmin/schema/pgIndex.cpp;h=4f270eedc03fd9e8fd3033ec627ca304462ff7bd;hb=HEAD#l670.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

In response to

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2011-03-28 10:00:49
Subject: pgAdmin III commit: Fix the GCC build.
Previous:From: TimonDate: 2011-03-28 08:57:48
Subject: Re: gin/gist indexes show twice

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group