On 20-10-15 19:34, Jamie Koceniak wrote:
>
> Version:
>
> -----------------------------------------------------------------------------------------------
>
> PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
> 4.7.2-5) 4.7.2, 64-bit
>
> Query Plan
>
> http://explain.depesz.com/s/4s37
>
> Normally, this query takes around 200-300 ms to execute.
>
> However when several queries are run concurrently, query performance
> drops to 30-60 seconds.
>
Is the concurrency the cause or the result of the slowdown?
Are you executing the same query with the same parameters or do the
parameters differ, perhaps making PostgreSQL
choose different queryplan?