How do a user-defined function that returns a table executes a query?

From: Katsuya Okizaki <miotsukushi0800(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: How do a user-defined function that returns a table executes a query?
Date: 2023-02-07 23:49:01
Message-ID: CAAe6QrDV884w99u1z8r6ybyi55iir4+Z-YU+ZBNHT6rKi+oBTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

I hope this message finds you in good health and spirits. I am reaching out
to this incredible community for some guidance and advice. I am currently
trying to understand how a user-defined function that returns a table
executes a query.

In a normal SQL, we can use the EXPLAIN command to view the execution plan.
However, in this case, I am not sure how a user-defined function work.

If anyone has faced a similar situation and found a way to view the
execution plan, I would greatly appreciate your insights and suggestions.

Thank you for taking the time to read my message. I look forward to hearing
from you.

Best regards,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2023-02-07 23:50:50 Re: How do a user-defined function that returns a table executes a query?
Previous Message Brad White 2023-02-07 23:42:11 Re: PostgreSQL