| From: | Katsuya Okizaki <miotsukushi0800(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(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-08 22:54:03 |
| Message-ID: | CAAe6QrAE931TgY_HDPWkEhjwK1Az4hhKvBCgxbtgiwFKB79LQA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear David,
Thank you for your prompt reply.
This is exactly what I was looking for. Thank you for your help.
Best regards,
Katsuya Okizaki
2023年2月8日(水) 8:51 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:
> 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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2023-02-08 22:57:04 | Re: How to create directory format backup |
| Previous Message | Erik Wienhold | 2023-02-08 22:45:04 | Re: How to create directory format backup |