How do a user-defined function that returns a table executes a query? - Mailing list pgsql-general

From Katsuya Okizaki
Subject How do a user-defined function that returns a table executes a query?
Date
Msg-id CAAe6QrDV884w99u1z8r6ybyi55iir4+Z-YU+ZBNHT6rKi+oBTg@mail.gmail.com
Whole thread Raw
Responses Re: How do a user-defined function that returns a table executes a query?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: How do a user-defined function that returns a table executes a query?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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,

pgsql-general by date:

Previous
From: Brad White
Date:
Subject: Re: PostgreSQL
Next
From: "David G. Johnston"
Date:
Subject: Re: How do a user-defined function that returns a table executes a query?