Query Performance Issue

[neslişah demirci <neslisah.demirci@xxxxxxxxx>]

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