Re: Batch insert heavily affecting query performance.

From: Jeremy Finzel <finzelj(at)gmail(dot)com>
To: Jean Baro <jfbaro(at)gmail(dot)com>
Cc: Danylo Hlynskyi <abcz2(dot)uprola(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Batch insert heavily affecting query performance.
Date: 2017-12-27 16:02:31
Message-ID: CAMa1XUjrFEQ3KxBCQ38FmKy783CJ3GJ7gjVzNA7ssurkhuJpiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>
> 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jean Baro 2017-12-27 16:23:55 Re: Batch insert heavily affecting query performance.
Previous Message Mike Sofen 2017-12-27 15:58:38 RE: Batch insert heavily affecting query performance.