Here's the full query I'm trying to do:
explain select
users.status,
users.oid as oid,
users.type as type,
users.exclusive as exclusive,
userse.o_initials as exclusive_initials,
users.name_processed as name_processed,
users.o_company as o_company,
unix_timestamp(users.created) as c
OK, say you're trying to find all the non-exact duplicates in a table, and especially
do it with a single query, so that the check can be part of a user interface.
Then naturally you're going to have a slow query, because it has to compare
every row with every other row.
You ought to be able to