Identify bottlenck in postgresql

Hello, I'm PostgreSQL expert for about 13 years. I have been working as a developer and DBA on large scale projects like Turkish e-government portal (over 20 million of users ) and Turkish Cable TV project (about 2 million users) many years. Both are PostgreSQL projects. You should more explain to solve your problem. Do DBs have same data, DDL structure and infrastructure such as CPU, memory, disks (SSD, HDD, SAN etc.), operating system, file system etc.?

Hello how are you I would like to know what your problem is about I would like to participate in your problem I would like to know what it is about if it is a question or something else.

Hello Greetings of the day !! Hope you doing good. As per description, project is based on performance tuning. I have been working similar activity in Business Intelligence projects for GE Rail for 5 years. In one of project, Sql query taking long time to execute the operation as we have huge data set in database. Then we analyze the issue, figure out the KPI and enhance the performance. I am customer centric IT professional. I would like to discuss more on the projects details. So that we can have better understanding for what needs to done. It would be great to work with you and hopefully never disappoint you. I am new to this platform but not in the industry. On time delivery, proper communication and quality work are my top priority.