On 05/16/2015 10:44 PM, Maks Materkov wrote:
I have a database, table "users", with column "profile_id", and the
following query:
EXPLAIN ANALYZE SELECT * FROM users_user WHERE profile_id IN (...50 ids...);
Result:
Index Scan using users_user_83a0eb3f on users_user (cost=0.50..292.22
rows=50
width=633) (actual time=0.039..0.622 rows=44 loops=1)
Index Cond: (profile_id = ANY ('{2445564,... 50 ids....}'::integer[]))
Planning time: 0.322 ms
Execution time: 5192.321 ms
This query takes ~5 seconds. (about ~5 million rows in table). I have a
btree index on this column. Is there any way to speed up query?
That does not seem right. Try again only using 'EXPLAIN (ANALYZE
1,BUFFERS 1)'
Also what version are you on and what are shared_buffers set to?
--Sam
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
