Home > mailing lists

Query Performance Issue - Mailing list pgsql-performance

From	neslişah demirci
Subject	Query Performance Issue
Date	December 27, 2018 22:25:47
Msg-id	CABFxtPedz4zL+aPWut4+=um4av1aAXr6OVRfRB_6K7mJKMbEcw@mail.gmail.com Whole thread Raw
Responses	Re: Query Performance Issue Re: Query Performance Issue Re: Query Performance Issue
List	pgsql-performance

Hi everyone ,

Have this explain analyze output :

https://explain.depesz.com/s/Pra8a

Appreciated for any help .

PG version

-----------------------------------------------------------------------------------------------------------

PostgreSQL 9.6.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit

OS version :

CentOS Linux release 7.5.1804 (Core)

shared_buffers : 4GB

work_mem : 8MB

From: Justin Pryzby
Date: 27 December 2018, 19:55:33
Subject: Re: PostgreSQL Read IOPS limit per connection

From: Haroldo Kerry
Date: 27 December 2018, 22:33:40
Subject: Re: PostgreSQL Read IOPS limit per connection