Postgresql Query Analyzer On Function

Question

I've been using postgresql's explain syntax to analyze queries. However, I tried to run it against a custom function, sproc, but it does not analyze it. Is there a way to use explain against a function? If not natively is there a way to programmatically export the function body and have the query analyzer fun against that?

You can do this with the auto_explain module: dba.stackexchange.com/questions/84414/… — Nick Barnes
– Nick Barnes, Commented Jul 11, 2015 at 9:40

Richard Huxton · Accepted Answer · 2015-07-10 22:00:23Z

1

Not really, and given PostgreSQL's pluggable procedural languages it's unlikely to happen in a general way. In any case, EXPLAIN for functions that are more than just a query with parameters is perhaps not well-defined as a concept.

A typical work-around is to extract the query-part and do PREPARE foo(...) ... SELECT followed by EXPLAIN EXECUTE foo(...). This lets you see the plan for a simple parameterised select.

answered Jul 10, 2015 at 22:00

Richard Huxton

23.6k5 gold badges43 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql Query Analyzer On Function

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related