{"id":115,"date":"2017-04-23T04:31:56","date_gmt":"2017-04-23T04:31:56","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=115"},"modified":"2017-05-17T08:17:20","modified_gmt":"2017-05-17T08:17:20","slug":"table-and-index-sizes-in-db-doc-4","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/04\/23\/table-and-index-sizes-in-db-doc-4\/","title":{"rendered":"Table and index sizes in DB Doc 4"},"content":{"rendered":"<p>Starting from DB Doc 4, table and index objects now have size properties.<\/p>\n<p>For tables, the following size properties are available:<\/p>\n<ul>\n<li>total size<\/li>\n<li>table size (excludes indexes and toast sizes)<\/li>\n<li>indexes size<\/li>\n<li>toast size<\/li>\n<\/ul>\n<p>For indexes, there is a single size property. \u00a0In all the report templates, the size properties are displayed.<\/p>\n<p>In PDF and DOC reports:<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-117\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size01.png\" alt=\"\" width=\"801\" height=\"499\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size01.png 801w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size01-300x187.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size01-768x478.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size01-150x93.png 150w\" sizes=\"(max-width: 801px) 100vw, 801px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In HTML and CHM reports:<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-122\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size02.png\" alt=\"\" width=\"836\" height=\"700\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size02.png 836w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size02-300x251.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size02-768x643.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size02-150x126.png 150w\" sizes=\"(max-width: 836px) 100vw, 836px\" \/><\/p>\n<p>DB Doc also displays the largest 20 tables and indexes by size in the template reports. \u00a0As usual, you can always customize the number of tables\/indexes to display, and the details shown.<\/p>\n<p>In PDF and DOC reports:<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-121\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03.png\" alt=\"\" width=\"800\" height=\"488\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03.png 800w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03-300x183.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03-768x468.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03-150x92.png 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-119\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03a.png\" alt=\"\" width=\"800\" height=\"485\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03a.png 800w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03a-300x182.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03a-768x466.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size03a-150x91.png 150w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In HTML and CHM reports:<\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-123\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04-1.png\" alt=\"\" width=\"848\" height=\"787\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04-1.png 848w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04-1-300x278.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04-1-768x713.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04-1-150x139.png 150w\" sizes=\"(max-width: 848px) 100vw, 848px\" \/><\/p>\n<p style=\"padding-left: 30px;\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-118\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04a.png\" alt=\"\" width=\"855\" height=\"773\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04a.png 855w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04a-300x271.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04a-768x694.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2017\/04\/dbdoc_size04a-150x136.png 150w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Take a look at the completes samples available here: <a href=\"http:\/\/www.yohz.com\/dbdoc_samples.htm\">http:\/\/www.yohz.com\/dbdoc_samples.htm<\/a><\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2017\/04\/23\/table-and-index-sizes-in-db-doc-4\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2017\/04\/23\/table-and-index-sizes-in-db-doc-4\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Starting from DB Doc 4, table and index objects now have size properties. For tables, the following size properties are available: total size table size (excludes indexes and toast sizes) indexes size toast size For indexes, there is a single size property. \u00a0In all the report templates, the size properties are displayed. In PDF and [&hellip;]<\/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],"tags":[3,31,30,32],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/115"}],"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=115"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/115\/revisions"}],"predecessor-version":[{"id":124,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/115\/revisions\/124"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}