PostgreSQL Performance Issue

Hello,

I seem to be having performance issues whilst executing Postgres Queries.

 

I have a PostgreSQL DB running on AWS, if I run a simply query from a desktop query via a desktop client the query executes in milliseconds. If I run the very same query in mode using the same credentials and connection the query takes 10 mins plus.

 

Anyone have any ideas?

 

ps. The query is 

 

SELECT *

FROM table

where ID IN(SELECT tblID FROM Table2)

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 5 mths agoLast active
  • 9Views
  • 1 Following