MIME-Version: 1.0
In-Reply-To: <1507042486.2998.1.camel@cybertec.at>
References: 
 <CADrzpjHChC6q0NGMG0wZUFvj-A0QO3WL9JONLcmRRCZuPnQQNQ@mail.gmail.com>
 <1507042486.2998.1.camel@cybertec.at>
From: Adam Brusselback <adambrusselback@gmail.com>
Date: Tue, 3 Oct 2017 11:17:38 -0400
Message-ID: 
 <CAMjNa7dQYE44gisjODEWECs82oAjj5Q7pDDhFKmP_aYX3dZYow@mail.gmail.com>
Subject: Re: Stored Procedure Performance
To: Purav Chovatia <puravc@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary="001a11c15ad0e08306055aa5fd66"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--001a11c15ad0e08306055aa5fd66
Content-Type: text/plain; charset="UTF-8"

There is also the option of pg_stat_statements:
https://www.postgresql.org/docs/current/static/pgstatstatements.html and
auto_explain:
https://www.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.

--001a11c15ad0e08306055aa5fd66
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_extra">There is also the option of pg_=
stat_statements:=C2=A0<a href=3D"https://www.postgresql.org/docs/current/st=
atic/pgstatstatements.html">https://www.postgresql.org/docs/current/static/=
pgstatstatements.html</a> and auto_explain:=C2=A0<a href=3D"https://www.pos=
tgresql.org/docs/current/static/auto-explain.html">https://www.postgresql.o=
rg/docs/current/static/auto-explain.html</a></div><div class=3D"gmail_extra=
"><br></div><div class=3D"gmail_extra">These should help you identify what =
is slowing things down.=C2=A0 There is no reason I could think of you shoul=
d be seeing a 10x slowdown between Postgres and Oracle, so you&#39;ll likel=
y have to just profile it to find out.</div></div>

--001a11c15ad0e08306055aa5fd66--