Debugging Your PL/pgSQL Code by Jim Mlodgenski

Wednesday, November 16 at 2:20-3:15

PL/pgSQL is a very robust development language that allows you to write complex business logic. The downside is, however, as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs and become useless.

In this talk, we will:

  • Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler that let you look inside the black box call PL/pgSQL
  • Demonstrate how the PL Profiler can identify problem areas in your functions
  • Setting breakpoints in functions and triggers
  • Stepping through PL/pgSQL functions
  • Discuss the performance impact of running the extensions on production environments

About the speaker

Jim is CTO of OpenSCG and has more than 15 years of experience developing data intensive applications and infrastructure. Prior to joining OpenSCG, Jim was CEO at StormDB, a Postgres-XC scalable public cloud solution. Prior to StormDB, Jim was Chief Architect at EnterpriseDB, leading EnterpriseDB’s technology direction across EnterpriseDB’s cloud offerings and multiple product lines.

Jim also is long-time active member in the PostgreSQL community, co-founding both the New York and Philadelphia PostgreSQL meetup groups. He is also a director at the US PostgreSQL Association and co-chair of PGConf US.

Monday, September 12, 2016 - 08:45