Bill Kirtley <b...@actbluetech.com> writes:
> For what it's worth:
> select xmin,* from pg_index where indexrelid =
> 'users_key_index'::regclass;
> xmin | indexrelid | indrelid | indnatts | indisunique | indisprimary
> | indisclustered | indisvalid | indcheckxmin | indisready | indkey |
> indclass | indoption | indexprs | indpred
> ------+------------+----------+----------+-------------+--------------
> +----------------+------------+--------------+------------+--------
> +----------+-----------+----------+---------
> 1006 | 15076176 | 17516 | 1 | f | f
> | f | t | f | t | 10
> | 10042 | 0 | |
Uh ... 'users_key_index'? What's that? What would actually be the most
useful is to compare the pg_index entries for the working and
non-working indexes (the ones on email and key).
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
