Обсуждение: BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements

Поиск
Список
Период
Сортировка

BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements

От
held911@163.com
Дата:
The following bug has been logged on the website:

Bug reference:      13413
Logged by:          lidong.he
Email address:      held911@163.com
PostgreSQL version: 9.4.1
Operating system:   linux
Description:

this function is ok in pg 9.3.5.  But , it does not work in pg 9.4.1. it's
like follow:
b2c_product=# deallocate all;
DEALLOCATE ALL
b2c_product=# select query from pg_stat_statements where query ~*
'deallocate';
 query
-------
(0 rows)

b2c_product=# select query from pg_stat_activity where query ~* 'deallocate'
limit 2;
                                  query
-------------------------------------------------------------------------
 select query from pg_stat_activity where query ~* 'deallocate' limit 2;
  DEALLOCATE ALL;
(2 rows)

Re: BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements

От
Tom Lane
Дата:
held911@163.com writes:
> this function is ok in pg 9.3.5.  But , it does not work in pg 9.4.1.

This is not a bug, it's an intentional behavioral change.  See the 9.4
release notes:

    * Make pg_stat_statements ignore DEALLOCATE commands (Fabien Coelho)

      It already ignored PREPARE, as well as planning time in general,
      so this seems more consistent.


            regards, tom lane

Re: BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements

От
q
Дата:
VGhpcyBpcyBteSBmYXVsdC5JICByZWFkIHRoZSA5LjQgcmVsZWFzZSBwYXJ0bHksbm90IGFsbCAu
CkkgcmVhZCB0aGUgZG9jdW1lbnQgYWJvdXQgdGhlIHBnX3N0YXRfc3RhbWVudCBsaWtlIGZvbGxv
dzoKCkYuMjkuIHBnX3N0YXRfc3RhdGVtZW50cwoKVGhlIHBnX3N0YXRfc3RhdGVtZW50cyBtb2R1
bGUgcHJvdmlkZXMgYSBtZWFucyBmb3IgdHJhY2tpbmcgZXhlY3V0aW9uIHN0YXRpc3RpY3Mgb2Yg
YWxsIFNRTCBzdGF0ZW1lbnRzIGV4ZWN1dGVkIGJ5IGEgc2VydmVyLgoKU28sIEkgbWlzdW5kZXJz
dGFuZCBpdC4KCgpUaGFucyBmb3IgeW91ciByZXBseS4KICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgIGJlc3QgcmVnYXJkcwoKCgoKCgoKCgpBdCAyMDE1LTA2LTA4
IDIzOjA4OjM0LCAiVG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3JvdGU6Cj5oZWxkOTEx
QDE2My5jb20gd3JpdGVzOgo+PiB0aGlzIGZ1bmN0aW9uIGlzIG9rIGluIHBnIDkuMy41LiAgQnV0
ICwgaXQgZG9lcyBub3Qgd29yayBpbiBwZyA5LjQuMS4KPgo+VGhpcyBpcyBub3QgYSBidWcsIGl0
J3MgYW4gaW50ZW50aW9uYWwgYmVoYXZpb3JhbCBjaGFuZ2UuICBTZWUgdGhlIDkuNAo+cmVsZWFz
ZSBub3RlczoKPgo+CSogTWFrZSBwZ19zdGF0X3N0YXRlbWVudHMgaWdub3JlIERFQUxMT0NBVEUg
Y29tbWFuZHMgKEZhYmllbiBDb2VsaG8pCj4KPgkgIEl0IGFscmVhZHkgaWdub3JlZCBQUkVQQVJF
LCBhcyB3ZWxsIGFzIHBsYW5uaW5nIHRpbWUgaW4gZ2VuZXJhbCwKPgkgIHNvIHRoaXMgc2VlbXMg
bW9yZSBjb25zaXN0ZW50Lgo+Cj4KPgkJCXJlZ2FyZHMsIHRvbSBsYW5lCg==