[doc] adding way to examine the plan type of prepared statements

From: torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [doc] adding way to examine the plan type of prepared statements
Date: 2020-11-18 02:04:34
Message-ID: 1286b656581b9930c9a2582076c8d073@oss.nttdata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Currently, EXPLAIN is the only way to know whether the plan is generic
or custom according to the manual of PREPARE.

https://www.postgresql.org/docs/devel/sql-prepare.html

After commit d05b172, we can also use pg_prepared_statements view to
examine the plan types.

How about adding this explanation like the attached patch?

Regards,

--
Atsushi Torikoshi

Attachment Content-Type Size
v1-0001-add-way-to-examine-plan-type.patch text/x-diff 1.2 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message torikoshia 2020-11-18 02:04:53 [doc] plan invalidation when statistics are update
Previous Message Alvaro Herrera 2020-11-18 02:04:18 Re: VACUUM (DISABLE_PAGE_SKIPPING on)