Received: from wm.hub.org (unknown [200.46.204.128]) by mail.postgresql.org (Postfix) with ESMTP id ED9A163404E for ; Wed, 31 Mar 2010 12:18:18 -0300 (ADT) Received: from maia (wm.hub.org [200.46.204.128]) by wm.hub.org (Postfix) with ESMTP id CE6FC2EE226 for ; Wed, 31 Mar 2010 15:18:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from rs47.luxsci.com (rs47.luxsci.com [65.61.166.88]) by mail.postgresql.org (Postfix) with ESMTP id A11A7633200 for ; Wed, 31 Mar 2010 04:27:46 -0300 (ADT) Received: from gnanam (ABTS-TN-Static-186.58.165.122.airtelbroadband.in [122.165.58.186] (may be forged)) (authenticated bits=0) by rs47.luxsci.com (8.13.1/8.13.7) with ESMTP id o2V7Re4h021804; Wed, 31 Mar 2010 02:27:42 -0500 Reply-To: From: "Gnanakumar" To: References: <007a01cad09d$33907af0$9ab170d0$@com> In-Reply-To: <007a01cad09d$33907af0$9ab170d0$@com> Subject: Re: Statistics Collector not collecting server activities Date: Wed, 31 Mar 2010 12:57:35 +0530 Organization: Zoniac Software Private Limited Message-ID: <008b01cad0a3$a50782e0$ef1688a0$@com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_008C_01CAD0D1.BEBFBEE0" X-Mailer: Microsoft Office Outlook 12.0 thread-index: AcrQnS95SkfuX6vjQrGmDciSF5EK2wABd3FA X-MS-TNEF-Correlator: 00000000FFE3983AD75C93419DA73DB02195F4D584344A00 Content-Language: en-us X-Archive-Number: 201003/290 X-Sequence-Number: 34089 This is a multipart message in MIME format. ------=_NextPart_000_008C_01CAD0D1.BEBFBEE0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I'm also seeing a weird thing. If I do 'show stats_start_collector;' inside psql, it says 'off'. I've also restarted my server many times after making all the changes. As per 8.2 doc, http://www.postgresql.org/docs/8.2/interactive/runtime-config-statistics.htm l, stats_start_collector is on by default. From: Gnanakumar [mailto:gnanam@zoniac.com] Sent: Wednesday, March 31, 2010 12:11 PM To: pgsql-admin@postgresql.org Subject: Statistics Collector not collecting server activities Hi, Even though I've enabled statistics collector in our server, it is not collecting statistics, and because of this autovacuum is also not running as expected. PostgreSQL version 8.2 Parameters enabled related to this are: # - Query/Index Statistics Collector - #stats_command_string = on #update_process_title = on #stats_start_collector = on #stats_block_level = off #stats_row_level = off stats_block_level = on stats_row_level = on #stats_reset_on_server_start = off # - Statistics Monitoring - #log_parser_stats = off #log_planner_stats = off #log_executor_stats = off #log_statement_stats = off I'm always getting zero value for all the tables. select pg_stat_get_tuples_inserted((select oid from pg_class where relname = 'mytable')); select pg_stat_get_tuples_updated((select oid from pg_class where relname = 'mytable')); select pg_stat_get_tuples_deleted((select oid from pg_class where relname = 'mytable')); ------=_NextPart_000_008C_01CAD0D1.BEBFBEE0 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IicHAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQOQBgAoFwAANQAAAAsAAgABAAAAAwAmAAAAAAALACkAAAAAAAsA KwAAAAAAAwAuAAAAAAAeAHAAAQAAADYAAABTdGF0aXN0aWNzIENvbGxlY3RvciBub3QgY29sbGVj dGluZyBzZXJ2ZXIgYWN0aXZpdGllcwAAAAIBcQABAAAAGwAAAAHK0J0veUpH7l+r40Kxpg3IkheR CtsAAXdxQAALAAEOAAAAAAIBCg4BAAAAGAAAAAAAAAD/45g611yTQZ2nPbAhlfTVwoAAAAMAFA4B AAAAHgAoDgEAAAAiAAAAMDAwMDAwMDMBZ25hbmFtQHpvbmlhYy5jb20BWk9OSUFDAAAAHgApDgEA AAAiAAAAMDAwMDAwMDMBZ25hbmFtQHpvbmlhYy5jb20BWk9OSUFDAAAAAwDeP59OAAADAPE/CQQA AAMAAlkAABYAAwAJWQIAAAALAAGACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAA4AIIAYA AAAAAMAAAAAAAABGAAAAABCFAAAAAAAACwANgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAAAAAAL ADqACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAPYAIIAYAAAAAAMAAAAAAAABGAAAAABiF AAAAAAAACwBSgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAADAFOACCAGAAAAAADAAAAAAAAA RgAAAAABhQAAAAAAAAMAoIADIAYAAAAAAMAAAAAAAABGAAAAAAGBAAAAAAAAAwCigAMgBgAAAAAA wAAAAAAAAEYAAAAAE4EAAAEAAAALAKSAAyAGAAAAAADAAAAAAAAARgAAAAAcgQAAAAAAAAMApYAD IAYAAAAAAMAAAAAAAABGAAAAACOBAAD///9/AwC8gAMgBgAAAAAAwAAAAAAAAEYAAAAAEIEAAAAA AAADAL6AAyAGAAAAAADAAAAAAAAARgAAAAAqgQAAAAAAAAsAv4ADIAYAAAAAAMAAAAAAAABGAAAA ACaBAAAAAAAABQDBgAMgBgAAAAAAwAAAAAAAAEYAAAAAAoEAAAAAAAAAAAAAHgDDgAMgBgAAAAAA wAAAAAAAAEYAAAAAJ4EAAAEAAAABAAAAAAAAAAsAxYADIAYAAAAAAMAAAAAAAABGAAAAAAOBAAAA AAAAAwDGgAMgBgAAAAAAwAAAAAAAAEYAAAAAEYEAAAAAAAALADaBAyAGAAAAAADAAAAAAAAARgAA AAAkgQAAAAAAAAsAN4EDIAYAAAAAAMAAAAAAAABGAAAAACyBAAAAAAAAAwA4gQMgBgAAAAAAwAAA AAAAAEYAAAAAKYEAAAAAAAADAD2BAyAGAAAAAADAAAAAAAAARgAAAAASgQAAAQAAAB4AQIEDIAYA AAAAAMAAAAAAAABGAAAAACGBAAABAAAAAQAAAAAAAAALAB8OAQAAAAIB+A8BAAAAEAAAAP/jmDrX XJNBnac9sCGV9NUCAfoPAQAAABAAAAD/45g611yTQZ2nPbAhlfTVAwD+DwUAAAACAQkQAQAAAJMR AACPEQAA3E4AAExaRnUvjB9+AwAKAHJjcGcxMjWCMgNDaHRtbDEDMfhiaWQEAAMwAQMB9wqAJwKk A+MCAGNoCsBzZfh0MCAHEwKAEIMAUARWvwhVB7ISVQ5RAwERVzIGAPsGwxJVMwRGEVkTaxJjCO9t Cfc7GU8OMDUSUgxgY2cAUAsJAWQzNhHgC6U0ciAQgipcDrIBkA4QOWQgPA6yIHgO0ACAOkh2PSII cG46BPBoYmUAwHMtbQ3gA2Bzam8BgC0FoG0f0A7QIl0fdW8f/yEJITBmDeBleyQlIeZ3In8jjyVw BbBkjSHmeCWfJq86ZXgkcA0h120okA6wdHA6L6ovKPUuINcuIXEvJDRiLwHQMDQvDiAtgG0LIccr p3cvwC53My4BBbBnL1RSL1JFhEMtDrI0MCI+EmOfHmcVcAqjMW8yf2czHgDxHyBlYWQxXQ7xM882 TzUepDYO8DwHgAGQIG4yYQeAPUcJ8ASQYXSvBbEFoAIwCfB0KJBNIOaUIFcn0SAOICAoJFA3HrAE kAmAIAeAD1B1bS4pMU43rzNTNDkRc3Q4eWxlMV4/oQqjPCEELS0KoyAvKiBGGQIhIEQBEAuAaXRp UwIgBCAqL0H0QAISLbpmANBlCqQBkQMwe0QlISDQbHk6QwdAaWIvBRAaYETHCrBuIRBlLcQxOhVw MTUgSBAVcNtIUh4AM0iCGmB9CqNEH/FFL1RhaANxRq9HtA7wfjZIo0gQHgAeAEj5QkJTRz/yQs9C EnAuTSEgTuMFsADAbCwgRlBRGg9QPnZRGEpKAMAwQAuAOjB3C4BMKVRELQbgAkAhgS55LhAwMQUw TClJswCQel0kgDlWcFbPRbYiBxMiuCwicwBxV9AGciJMKSUYwzo5kHZ5SSZhOmlGUG5rUbBzR1FR Ekj8eXAEkF0iU4shIFfQP/I8LXAFEAWwQyBGEDk571s/CjJMKTqweCFQBYM6MPFDQTp1bgSBXSFh 4VymfnYEAEMgCYBdb11AQoBsvRjgdwmAXp9fr1tOcAhw3wtQYe9i/2QJZWNFAMADEPlPYzE3Zv9o Az/wXiBqAP8EkCEgOZACcFifWa9av1vPm20PbhA4bk9vX2wtGVD/C1BccXCfca9yv2FPV0hmwPxp Zw6wXDBRY1bvP/J99yNJRFESQ2hwT8Fhda8esHYPdxgqwHAY8S0CIHN4f1fUMTBYRElFCrBne0+g BmBjQzIcI0qGV+M4/C41C4BNcVZwVM9UgYhzfzvwif5JJlKyhn9FQYYiOveMFkkmQdA+Pm8/ch8B LCAvP/8+Lz85QcFbBpAgZwc6sDzAISAgOV0+PPcfgY7EHxBvKOARgF4gAQG7gUIEIHYqsTrhPOF0 IeCfZWAPQADAKIGFMDI2IeDeL47EkECUckGwWwnwD1D8Zl2OoZIfky+UP5VDC2B+eQhgBUCWKpSl lQKXEnD1lhxkOjBhl2GXx5AxnIuvm7CYb5DPkd9nP6IvNS9XM3+mjx5YNRHgPAbgZAZ5UcAAcGc9 RU4t9lUF8F0iPQoylhCqw2oUv6XwHnMAIQMwqhKFMDNI0H+sRhHgHisdcahvrt8eozm9TbA8UrE6 cAtgBBA9jBa/rCkAAK2Pr++0jx4rNjTxn58QsgRRJ7Lvs/9nODTxp2ViZVCQcj0ne/gnuQ+FuhNJ um4mIzgybiCzAoCsSCc5DlC5121c8L5sm2ERsH2gqjBc8CB9kZ8LIKSctnWsR61pdGjB4bIuvl9u YmVgv7thAUD3ude+MJrwSVKgm3DFj79i/ja/vABQudeVQGawu7E6MOxzX8wxACBfGMGQkIww3QWw O8j/v2/AeyALgACQ8wEAR0BzcVGhQyDCn8Ov/8t2nQAEIM2fyg/LGyQx1G+/zq/Ae8V8HfA08ZUg cKX+/w5AoQPbzsCAkDJHUawprDf/HXGsVQqi34gKgaxXCrHhmP+0LQHAkDHbzrZv5S+3P7hP/70/ um+7f7yP6g/a79ePxp//x6rb/90P3h/fL+A/4U/iX//jb+R/5t/8P+ev6L/tr+rfv+vv7P+9v9f/ 2Q8BRHZPoP/BYxlQzJM8oqnweuEIgPlh/9Gv0r/A9ALQqfBDMDmwlgDuYR0QE7FtkGvB42aQxRH/ T6ARcaowCRDaf++f84/0n//1r/a/98/43wFf+v/9Xxmf//4v/z8ELxe/Am8Dfx5/D1//Ee/wz/Hf EL8RzxLfE+8U//8WDxcfGC8ZPxufMP8cbx1/3yJvH58gryG/NddBlgBeIW4giACoMMjAY1GwNm9h NUpDaHhAZp+AC5B0cNA6Ly93PYAug1DMkJZnCQHRIC44YGcvOvH0cy86sS+KEA2RShBDMFkIgC9y bCANEi1rkG5dT+BnZ+FrwcyQaT7QLl8Lkp4QOPpP4JzgZKeCZgNC8NCRdHtIWVBFwFJMSU5LID0P Ph/nPy9AP0FJfX1CoULwd9D5gWFjZtaggVCtaUSPRZ9/Rq9Hv0FXKq8ruVCKKS8v+mGl8CwKPwtP y3bMT81R59CAlgCN8CBiqfCVlQ8//yRfKE8pXypvK38sjy2fUj//L78yH2M/Mu8z/zjvYV83L/84 P2gfWP9bjyWPJp9aX1tv/1x/XY9en1+vYL9hz2LfZT//ep+xK2ufeE97/3+vsP9qdSepwMJwCeA6 bo3wZTt9g4QtzVBLYGcwqsAJgCNAQjVDNERGijJwFHQ7jKBkQ3FnOjP9heIgigKHFWuPfs+BL4mv v2XPZt+ID2j/qaGN+2Ktbytpf2qEZrKwdEhQaXo8ZTqXgIXjk9NYgG1pwGx5OiJUYcvwDdD4Iiwi 1BDQoEhQCeCi0GwiOzxjauR3h6DIwHdPmyCfYIfPkaRGcpXgOv9yz3PfkW+aiZBqnC+Sb5N//ZSP Ojxjla+Ws5dfmG/IFGxHbmpADeB1DdA8kFsnDdCVYM1QOmenQm1AKnqysGlNsC5OoG1dbYksMdWg kEFyrCuHoGX/d99UPp9vkG+sB7JgTXCaD5ud38fnVwlwhBBzZNQgjdFATXewDsAgMzHRQCwyMKHQ hcAyocAxIPxQTamfqq+rv6zPrd+u7z24CFRycLDvsf/H9nBnzdERLYZAlVBuQEvsta8/tr+3z7jf ue+6/6/5dWJealdxvM+937L3U0EHIP5DV0eD8IbwVzUOAgnUDWD3TcLRYELQc2z/bg9x/5pf/5tv dS92P3dPw995b4sf2O/9wSswz3FMwH2rnr/aT94f/9sf3C/dP9+f42+Lr4y/jc//4t/PH26fb6/o 79B+1D/VT//WX9dv2H/ln/Rf5m/nf+iN/EhpU9zqT+4/70/wX/Fv//J/84/17wH/9r/3z+iP+h// +y/rv+zP+3/8j/2f/q8Lf38AzwMvEe8D/wUPBh8QAkVLTfBqUHSjgHVntHBJwQjfIzgyMTcKK1NQ 6w+oTfAgsKBha0CzkFZj/8t1VzlqUBggD3HEP1UfViT/zYM7IM4wV8LMjstHOyBqQP2FMGJXcFiQ lpBX8FWgGADXV9FYkFeQdk2wdaeQV8L/FjAV0B3fHu8P1cyCTiGo8PfNQRWAG5B4OnBNwLOQWN// CG8MXw1vDn8PjxCfEv8Sv/8xnxTfFe8Grym/CM8J3wrv/ysfLC8tPy5PL18wbzLPQY8fM580rzW/ tXBL9FNRTPsbYUnQaVgBTSE23zfvO9//PO89/z8PQB9Cf0I/UM9EX/9FbzYvSO84TzlfOm9KT0tf /0xvTX9Oj0+fUf9gv1LPU9/tVO9QXfCooGWlcEfwG5fvwIBkACkhF/BvI9XAgMiM/1bPWr9bz1zf Xe9e/2APYm8PcL9jP2RPVQ0jIC0gxFF1zYB5L0mlMKWA+8svzDMtaL9pz2rfa+9s//9uD28fcX9x P4DPc190b1VP/3jvV29Yf1mPek97X3xvfX9/fo9/n4H/kL+Cz4PfhO8juRwic1+pQZSwpTBfR0Dr pGDNQT0dkG6F/4cPiv//jA+NH44vjz+Rn5FfoC+TfzOUj3V6dXCz4CkgX3C4cm9js8CWkM4AdMwQ /5efmK+Zv5rPm9+c753/nw//oW+u76I/o0+E/6cPqB+IL/+JP6hvqX+qj6ufuG+tv7Af/77fsO+x /7MPlfocIbqAlqH/zAamv7U/uS+6P7tPvF+9b/++f8Dfzm/Br8K/s3+1/7cP/9M/1E/VX9Zv13/Y j9mf2q//27/cz93f3u/f/+EP4h/jL//kP+VP5l/nb+h/6Y/qn+uv/+y/7c/u3+/v8P/yD/Mf9C// 9T/2T/df+G/5f/qP+5/8r//9v/7P/98A7wH/Aw8EHwUv/wY/B08IXwlvCn8LjwyfDa//Dr8PzxDf Ee8S/xQPFR8WL/8XPxhPGV8abxt/HI8dnx6v/x+/IM8h3yLvI/8lDyYfJy//KD8pTypfK28sfy2P Lp8vr/8wvzHPMt8z7zT/Ng83Hzgv/zk/Ok87XzxvPX8+jz+fQK//Qb9Cz0PfRO9F/0cPSB9JL/9K P0tPTF9Nb05/T49Qn1Gv/1K/U89U31XvVv9YD1kfWi//Wz9cT11fXm9ff2CPYZ9ir/9jv2TPZd9m 72f/aQ9qH2sv/2w/bU9uX29vcH9xj3Kfc6//dL91z3bfd+94/3oPex98L/99P35Pf1+Ab4F/go+D n4Sv/4W/hs+H34jvif+LD4wfjS//jj+PT5BfkW+Sf5OPlJ+Vr/+Wv5fPmN+Z75r/nA+dH54v/58/ oE+hX6Jvo3+kj6Wfpq//p7+oz6nfqu+r/60Prh+vL/+wP7FPsl+zb8bFtPDP9LWH/8tQtm/G78f/ yQ/KH8svzD9/zU/Pr8E/0H/Rj9Kfv1EjAnPCwHRzX2JsbwBja19sZXZlbMAgPSBvZma5j7qf/7uv vL+9z77fv+/CT8IP0L+HxC/FP8ZPX3Jvd8e//8jPyd/K78v/zQ/OH88v0Y9/3s/SX9Nv1H/c5McP 1uJu/9dP2F/Zb9p/24/cn92v4A//38/uX+Hv4v/kD9Zb5g/nH//oL+k/6k/rX+xv7s/uj/z/D/Cv 8b/VL9YxZXNldKpf9KBfAsBy1rByAyD//gD4ANbkuX/1z/bf9+/4///6D/sf/X/9Pwyf/18AbwF6 /wRvBX+0z7XfEc0GvwfPCN//Fa8K/w1fHB8OLw8/EE/Gd1AgLSBT5MFp5LBpkGNzIE30oGl0IHD4 aW5nIjAR3xLvFt8X7/8Y/xoPGx8dfx0/LB8fXyBv/xEvJD8TTxRfFW8lnyavJ7//KM8p3yrvLU88 Dy4fLy8wP/Ijx3BnXz3BAzEDkuTg/9bvMf817zb/OA85HzovOz9/PZ9K7z5vP39Aj0GUTjBu/m5C L0M/RE9FX0ZvR39Ij39Jn0v/WV9Mz03fTu9BG2XweGVjdSNRUT9ST1Nf/1RvVX9Wj1efWK9bD2h/ W98PXO9d/0E55LJlbWVu/wLgYE9hX2JvY39kj2WfZq//Z79qH3efau9r/20Pdb9wz/8zHzQvfR9y L3M/dE91X3Zvv3jPeI+In3qve78BiUl+7yAjODIxN4A7OTKJhbhtIIxAd2F5IvAuZwLQIpAjkXoD QG8gwnaMQHVlIGaMEJDRedbQdGiSYImQx2ACsC7/fX9+j4J/g4+En4Wvhr+JH/+I35v/iv+MD3zP lB+N33///4EPlX+Wj5efmK+Zv5rPnS+/q++d/58PoB8CwNaQYwPginBulF+RUV90dVDAHQKwXyOA AzFu4GQoKPGxdW9pZJJw1lCQwLHhb68jtv+4D6mVd5MQAqAgMQKgbG5hbwBvoSdtwnmTQycpKTuh L6I//6Yvpz+oT6lfqm+sz6yPwc+/rq+vv7DPsd+y4bKwZG7R/7OPtJ+1r7a/t8+437nvuv//vA+9 H74vvz/AT8Kv1o/Df+/Ej8Wfxq+yPGTcccjfye//yv/MD80fzi/PP9BP0V/Sbz/Tf9SP1Z/X/+vf 2M0xMOHlUS9kaXbbCegY6lwn7d/xr+S2NTjm0WJvvGR55b7zT/Xf5MY35tErpBLlvTP3ZX36sAAD AA00/T+jBgMADzT9P6MGAgEUNAEAAAAQAAAATklUQfm/uAEAqgA32W4AAAIBfwABAAAAMQAAADAw MDAwMDAwRkZFMzk4M0FENzVDOTM0MTlEQTczREIwMjE5NUY0RDU4NDM0NEEwMAAAAAADAAYQc7Cb WwMABxCBBAAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAElNQUxTT1NFRUlOR0FXRUlSRFRI SU5HSUZJRE9TSE9XU1RBVFNTVEFSVENPTExFQ1RPUjtJTlNJREVQU1FMLElUU0FZU09GRklWRUFM U09SRVNUQVJURURNWVNFUlZFUk1BTlkAAAAA4v4= ------=_NextPart_000_008C_01CAD0D1.BEBFBEE0--