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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Katsuya Okizaki <miotsukushi0800(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How do a user-defined function that returns a table executes a query?
Date: 2023-02-07 23:50:50
Message-ID: CAKFQuwa3gEHGnvAoUsNcEHZtoEwR8=Ak5OKAGrMzP590p01U6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 7, 2023 at 4:49 PM Katsuya Okizaki <miotsukushi0800(at)gmail(dot)com>
wrote:

> 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.
>
>
https://www.postgresql.org/docs/current/auto-explain.html

David J.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brad White 2023-02-08 00:00:29 Re: A Small psql Suggestion
Previous Message Katsuya Okizaki 2023-02-07 23:49:01 How do a user-defined function that returns a table executes a query?