{"id":173,"date":"2017-05-12T07:29:32","date_gmt":"2017-05-12T07:29:32","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=173"},"modified":"2017-05-16T10:37:06","modified_gmt":"2017-05-16T10:37:06","slug":"postgresql-statistics","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/05\/12\/postgresql-statistics\/","title":{"rendered":"PostgreSQL statistics"},"content":{"rendered":"

PostgreSQL has a neat set of pg_stat views<\/a> from which you can obtain statistics for tables, indexes, etc. \u00a0From DB Doc<\/a> 4.2 and PgComment<\/a> 1.2 onwards, you can now view the database, table, and index statistics in the DB Doc reports and in PgComment object inspector.<\/p>\n

In DB Doc, database statistics are displayed on the database properties page<\/p>\n

\"\"<\/p>\n

table statistics are displayed on each tables’ properties page<\/p>\n

\"\"<\/p>\n

and index statistics (idx_scan, idx_tup_read, idx_tup_fetch) are displayed as part of the index definitions.<\/p>\n

\"\"<\/p>\n

If you choose not to display the statistics, just deselect the Display database, table, and index statistics<\/strong> option.<\/p>\n

\"\"<\/p>\n

 <\/p>\n

PgComment<\/a>, our free tool to easily add\/modify comments to your PostgreSQL objects, displays the statistics details in the object inspector window.<\/p>\n

– database statistics<\/p>\n

\"\"<\/p>\n

 <\/p>\n

– table statistics<\/p>\n

\"\"<\/p>\n

 <\/p>\n

– index statistics<\/p>\n

\"\"<\/p>\n

<\/fb:like><\/div>
<\/div><\/div>","protected":false},"excerpt":{"rendered":"

PostgreSQL has a neat set of pg_stat views from which you can obtain statistics for tables, indexes, etc. \u00a0From DB Doc 4.2 and PgComment 1.2 onwards, you can now view the database, table, and index statistics in the DB Doc reports and in PgComment object inspector. In DB Doc, database statistics are displayed on the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6,22],"tags":[3,28,23,8,27],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/173"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=173"}],"version-history":[{"count":3,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/173\/revisions"}],"predecessor-version":[{"id":190,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/173\/revisions\/190"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}