Download List


pg_store_plans records execution statistics for every selected plans and stores the execution plans. pg_store_plans is basically a derivative work of pg_stat_statements so it is very similar to pg_stat_plans since they share the same origin and cl...

System Requirements

System requirement is not defined

發布 2020-01-30 19:38
pg_store_plans12 1.4 (7 files 隱藏)


Version 1.4 is fixed a bug and got a new feature since 1.3.

Verision 1.4 is available only for PostgreSQL 12 or later.

  • Bugs:
    • The content of the pg_store_plans.plan is converted from storage format (raw string) to printing format. Queries that output the column gets ERROR when the converted string had characters that need encoding after the length of raw string, or when the conversion made the plan string shorter.
  • New features:
    • pg_store_plans view now has three new columns min_time, max_time and stddev_time as pg_stat_statements has.


バージョン1.4は PostgreSQL 12 以降のみで利用可能です。

  • バグ
    • pg_store_plans.plans の内容は表示前に格納形式から表示形式に変換されます。このカラムを出力するクエリは以下の場合にエラーとなります。
      • 変換後の文字列が変換前の長さよりも後ろにエンコーディングが必要な文字を含んでいた場合
      • 変換後の文字列が変換魔よりも短くなった場合。
  • 新機能
    • pg_stat_statements と同様の max_time, min_time, stddev_time の3つのカラムが pg_store_plans ビューに追加されました。