2017-10-03 17:17 GMT+02:00 Adam Brusselback <adambrusselback@xxxxxxxxx>:
There is also the option of pg_stat_statements: https://www.postgresql.org/docs/ and auto_explain: https://www.current/static/ pgstatstatements.html postgresql.org/docs/current/ static/auto-explain.html These should help you identify what is slowing things down. There is no reason I could think of you should be seeing a 10x slowdown between Postgres and Oracle, so you'll likely have to just profile it to find out.
depends what is inside.
The max 10x slow down is possible if you are hit some unoptimized cases. The times about 1ms - 10ms shows so procedure (code) can be very sensitive to some impacts.
Regards
Pavel
