On 06/24/2014 10:15 PM, CS_DBA wrote: > I added a PK constraint on the id column and created this json index: > > create index mytest_json_col_idx on mytest ((task->'name')); > > However the planner never uses the index... > > > EXPLAIN SELECT (mytest.task->>'name') as name, > > COUNT((mytest.task->>'name')) AS task_count > > FROM mytest > > GROUP BY (mytest.task->>'name') > > ORDER BY 2 DESC; > > > Am I missing something?
Yes, you're querying task->>'name' but the index is on task->'name'. -- Vik -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
