'how to find out memory consumption of sql statements inside PL/pgSQL function without using auto-explain
I have a dynamic PL/pgSQL function with input parameters like (source table name, target table name, timestamps). It consists of few select statements and creation of temp tables, update/insert in final table.
I need to find out memory allocation and consumption of individual sql statements when this function is executed. Basically I need an 'explain analyze' kind of o/p for a PL/pgSQL function. do not have access to auto-explain.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|