Home > mailing lists

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

From	Andreas Joseph Krogh
Subject	Re: [GENERAL] Question slow query
Date	January 12, 2017 09:48:21
Msg-id	VisenaEmail.3d.dcd47ba5e256a39c.15990c87654@tc7-visena Whole thread Raw
In response to	[GENERAL] Question slow query (Patrick B <patrickbakerbr@gmail.com>)
Responses	Re: [GENERAL] Question slow query (Patrick B <patrickbakerbr@gmail.com>)
List	pgsql-general

Tree view

På torsdag 12. januar 2017 kl. 03:15:59, skrev Patrick B <patrickbakerbr@gmail.com>:

Hi guys,

I've got a slow query, running at 25 seconds.
                          ->  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
As you can see, 13.725.231 rows were removed by Filter..

Should I create an index for this column?
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?