Thread: BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements
BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements
From
held911@163.com
Date:
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)
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
VGhpcyBpcyBteSBmYXVsdC5JICByZWFkIHRoZSA5LjQgcmVsZWFzZSBwYXJ0bHksbm90IGFsbCAu CkkgcmVhZCB0aGUgZG9jdW1lbnQgYWJvdXQgdGhlIHBnX3N0YXRfc3RhbWVudCBsaWtlIGZvbGxv dzoKCkYuMjkuIHBnX3N0YXRfc3RhdGVtZW50cwoKVGhlIHBnX3N0YXRfc3RhdGVtZW50cyBtb2R1 bGUgcHJvdmlkZXMgYSBtZWFucyBmb3IgdHJhY2tpbmcgZXhlY3V0aW9uIHN0YXRpc3RpY3Mgb2Yg YWxsIFNRTCBzdGF0ZW1lbnRzIGV4ZWN1dGVkIGJ5IGEgc2VydmVyLgoKU28sIEkgbWlzdW5kZXJz dGFuZCBpdC4KCgpUaGFucyBmb3IgeW91ciByZXBseS4KICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIGJlc3QgcmVnYXJkcwoKCgoKCgoKCgpBdCAyMDE1LTA2LTA4 IDIzOjA4OjM0LCAiVG9tIExhbmUiIDx0Z2xAc3NzLnBnaC5wYS51cz4gd3JvdGU6Cj5oZWxkOTEx QDE2My5jb20gd3JpdGVzOgo+PiB0aGlzIGZ1bmN0aW9uIGlzIG9rIGluIHBnIDkuMy41LiAgQnV0 ICwgaXQgZG9lcyBub3Qgd29yayBpbiBwZyA5LjQuMS4KPgo+VGhpcyBpcyBub3QgYSBidWcsIGl0 J3MgYW4gaW50ZW50aW9uYWwgYmVoYXZpb3JhbCBjaGFuZ2UuICBTZWUgdGhlIDkuNAo+cmVsZWFz ZSBub3RlczoKPgo+CSogTWFrZSBwZ19zdGF0X3N0YXRlbWVudHMgaWdub3JlIERFQUxMT0NBVEUg Y29tbWFuZHMgKEZhYmllbiBDb2VsaG8pCj4KPgkgIEl0IGFscmVhZHkgaWdub3JlZCBQUkVQQVJF LCBhcyB3ZWxsIGFzIHBsYW5uaW5nIHRpbWUgaW4gZ2VuZXJhbCwKPgkgIHNvIHRoaXMgc2VlbXMg bW9yZSBjb25zaXN0ZW50Lgo+Cj4KPgkJCXJlZ2FyZHMsIHRvbSBsYW5lCg==