How long does the same query take to execute in the SQL Editor in the Neon console? You can see the time in the bottom right corner. If it's also slow in the SQL Editor, tTry using the Analyze button to debug why.
Maybe try using a larger compute size too. You might be using the default scaling that starts of 0.25 CPU