2

if I use

explain (analyze true, verbose true, costs true, buffers true)
select * from mystoredprocedurefunction(arg1, arg2);

I do not get any information about what the server is actually doing inside my sp. Instead I get 5 rows describing that I invoked a function and that it took a long time. How do I look into my stored procedure and see what is going on? I have something very inefficient occurring.

Jeremy Holovacs
  • 1,241
  • 4
  • 20
  • 27

1 Answers1

3

Look into the module auto-explain.

Very similar, recent question with answers:

Erwin Brandstetter
  • 175,982
  • 27
  • 439
  • 600