Enterprise Postgres 17 リリース情報

2.2.207 pg_stat_statementsのSELECT問い合わせ実行の統計処理の変更

非互換

FUJITSU Enterprise Postgres 13では、pg_stat_statementsでSELECT問い合わせ実行に関して、「FOR UPDATE」オプションがあるかどうかを区別して、統計情報を収集します。

FUJITSU Enterprise Postgres 12以前の場合

SELECT問い合わせの「FOR UPDATE」オプションを区別せず、統計情報を収集します。

[例]

=# SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id;
…
=# SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id FOR UPDATE;
…
=# SELECT calls, query FROM pg_stat_statements ORDER BY query COLLATE "C";
 calls |                            query
-------+--------------------------------------------------------------
     2 | SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id;
     1 | SELECT pg_stat_statements_reset();
(2 rows) 

FUJITSU Enterprise Postgres 13の場合

SELECT問い合わせの「FOR UPDATE」オプションを区別して、統計情報を収集します。

[例]

=# SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id;
…
=# SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id FOR UPDATE;
…
=# SELECT calls, query FROM pg_stat_statements ORDER BY query COLLATE "C";
 calls |                                 query
-------+------------------------------------------------------------------------
     1 | SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id
     1 | SELECT * FROM pgss_a JOIN pgss_b ON pgss_b.a_id = pgss_a.id FOR UPDATE
     1 | SELECT pg_stat_statements_reset()
(3 rows)

対処方法

ありません。