[GENERAL] Question slow query - Mailing list pgsql-general

                          ->  Bitmap Heap Scan on ja_notes r_1103088  (cost=234300.55..1254978.62 rows=553275 width=101) (actual time=1423.411..10572.549 rows=475646 loops=1)                               Recheck Cond: (n_type = ANY ('{note,note_1,note_2}'::n_type[]))                               Filter: (timezone('Etc/UTC'::text, d_modified) >= '2016-08-07 23:12:34'::timestamp without time zone)                               Rows Removed by Filter: 13725231

d_modified              | timestamp with time zone | default statement_timestamp()

I tried but it didn't help... the query doesn't even hit the index.

CREATE INDEX q ON test USING BTREE (d_modified);

Am I missing something? 

Thanks!