From: | Jean Baro <jfbaro(at)gmail(dot)com> |
---|---|
To: | Jeremy Finzel <finzelj(at)gmail(dot)com> |
Cc: | Danylo Hlynskyi <abcz2(dot)uprola(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Batch insert heavily affecting query performance. |
Date: | 2017-12-27 16:34:32 |
Message-ID: | CA+fQeem6jR4UWcXicPr_5n1Y9SEV1ErHS-tYTAGZK9+Vcv+k=g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Thanks Jeremy,
We will provide a more complete EXPLAIN as other people have suggested.
I am glad we might end up with a much better performance (currently each
query takes around 2 seconds!).
Cheers
Em 27 de dez de 2017 14:02, "Jeremy Finzel" <finzelj(at)gmail(dot)com> escreveu:
> The EXPLAIN
>
> 'Index Scan using idx_user_country on card (cost=0.57..1854.66 rows=460
> width=922)'
> ' Index Cond: (((user_id)::text = '4684'::text) AND (user_country =
> 'BR'::bpchar))'
>
Show 3 runs of the full explain analyze plan on given condition so that we
can also see cold vs warm cache performance.
There is definitely something wrong as there is no way a query like that
should take 500ms. Your instinct is correct there.
From | Date | Subject | |
---|---|---|---|
Next Message | Jean Baro | 2017-12-27 16:36:10 | RE: Batch insert heavily affecting query performance. |
Previous Message | Jeff Janes | 2017-12-27 16:23:55 | Re: Batch insert heavily affecting query performance. |