Jan Wieck

/Jan Wieck

About Jan Wieck

This author has not yet filled in any details.
So far Jan Wieck has created 2 blog entries.

PL/pgSQL Profiler 3 (plprofiler) is released

Finding performance problems in deeply nested PL/pgSQL business logic is difficult.One of the reasons is that PL/pgSQL hides anything happening in the PL code. None of the SQL queries inside of all the nested function and trigger calls ever shows up in...

By | November 3rd, 2016|Categories: OpenSCG, PostgreSQL, PostgreSQL Blogs|Tags: , , |Comments Off on PL/pgSQL Profiler 3 (plprofiler) is released

My PL/pgSQL code is stuck, but where?

In the short time that I am enhancing the PL profiler (https://bitbucket.org/openscg/plprofiler) I have been asked multiple times if it can be abused as a debugging aid. Not directly. The conversation goes something like this:Q: When my PL code is stuc...

By | July 16th, 2016|Categories: PostgreSQL|Comments Off on My PL/pgSQL code is stuck, but where?