2 ms·

I tried to use your index advisor but lots of functions present in my query are not supported (bool_or, numeric, etc..). Moreover it crashes with big complex qu

I tried to use your index advisor but lots of functions present in my query are not supported (bool_or, numeric, etc..). Moreover it crashes with big complex query. I have also tried to setup pg agent but it’s been a few days and still not able to setup log insights for a self-hosted PG (and our pg logs works). Basically we spent our trial just to try to setup the agent . And still not completed. As a feedback, I think you should invest more in the onboarding phase and not counting days in trial if not logs are collected. Ironically if you record a screencast installing pganalyze on a digital ocean docker would be enough.

lfittl 5y ago
(author here) Thanks for trying out the pganalyze app! Sorry to hear about the challenges with log monitoring setup - happy to restart the trial and do a screenshare to debug - you can email me directly at lukas AT pganalyze.com On the index advisor errors: Sounds like you are running into errors with cases where the planner calls functions (e.g. for type conversion, expression simplification). We've recently improved some cases there, but numeric specifically I know there is a pending bugfix. Happy to take a closer look.