
{"id":5948,"date":"2024-08-21T10:17:02","date_gmt":"2024-08-21T10:17:02","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=5948"},"modified":"2024-08-21T10:19:38","modified_gmt":"2024-08-21T10:19:38","slug":"unlocking-postgresqls-potential-with-pgstattuple","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/","title":{"rendered":"Unlocking PostgreSQL\u2019s potential with pgstattuple"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>pgstattuple<\/strong> is an open-source utility in PostgreSQL, provided as an extension. It helps manage and clear table bloat, which in turn improves table performance. It&#8217;s ability to provide detailed insights into the extent of bloat, makes <strong>pgstattuple<\/strong> a crucial tool for optimizing database efficiency and ensuring that your tables operate smoothly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL is renowned for its robustness, flexibility, and advanced features. One such feature, pgstattuple, provides invaluable insights into the health and efficiency of your database tables and indexes. In this blog, we&#8217;ll delve into what pgstattuple is, how it works, and how it can be a game-changer for database maintenance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">What is pgstattuple?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>pgstattuple<\/strong> is an extension for PostgreSQL that helps you analyze the physical storage of database tables. It provides detailed statistics on the space usage within your database, including how much space is wasted due to bloat. This information is crucial for maintaining optimal performance and ensuring efficient use of disk space.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Why is pgstattuple Important?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Over time, PostgreSQL databases can accumulate bloat due to various operations like inserts, updates, and deletes. This bloat results in unused space within tables and indexes, which can degrade performance and lead to inefficient storage use. <strong>pgstattuple<\/strong> helps you identify and quantify this bloat, allowing you to take corrective actions such as vacuuming or reindexing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Creating the Extension and Table<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# create Extension pgstattuple;\nCREATE EXTENSION\npostgres=# create table test (id int, name varchar(90));\nCREATE TABLE<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;Install the pgstattuple extension, which is necessary for analyzing bloat in tables. A table named test is created with two columns: id and name.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Insert Data into the Table<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# INSERT INTO test (id, name)\nSELECT generate_series(1, 50) AS id, 'some_text' AS name;\nINSERT 0 50<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We insert 50 rows into the <code>test<\/code> table. Each row has an <code>id<\/code> from 1 to 50, and the <code>name<\/code> is set to <code>'some_text'<\/code>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">&nbsp;Initial Bloat Check<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check Table Bloat Using<strong> pgstattuple:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# select * from pgstattuple ('test');\n-&#091; RECORD 1 ]------+------\ntable_len          | 8192\ntuple_count        | 50\ntuple_len          | 1900\ntuple_percent      | 23.19\ndead_tuple_count   | 0\ndead_tuple_len     | 0\ndead_tuple_percent | 0\nfree_space         | 5964\nfree_percent       | 72.8<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The initial check shows:\n<ul class=\"wp-block-list\">\n<li><strong>table_len<\/strong>: Total table size in bytes (8192 bytes).<\/li>\n\n\n\n<li><strong>tuple_count<\/strong>: Number of live tuples (50).<\/li>\n\n\n\n<li><strong>tuple_len<\/strong>: Total size of live tuples (1900 bytes).<\/li>\n\n\n\n<li><strong>dead_tuple_count<\/strong>: Number of dead tuples (0).<\/li>\n\n\n\n<li><strong>free_space<\/strong>: Free space available in the table (5964 bytes).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>At this stage, there are no dead tuples, meaning there is no bloat.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step4<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Creating Bloat<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Delete Some Rows:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# DELETE FROM test WHERE id BETWEEN 41 AND 50;\nDELETE 10<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We deleted 10 rows from the table where the id is between 41 and 50.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Check Bloat <\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# select * from pgstattuple ('test');\n-&#091; RECORD 1 ]------+------\ntable_len          | 8192\ntuple_count        | 40\ntuple_len          | 1520\ntuple_percent      | 18.55\ndead_tuple_count   | 10\ndead_tuple_len     | 380\ndead_tuple_percent | 4.64\nfree_space         | 5964\nfree_percent       | 72.8<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li>After the deletion:\n<ul class=\"wp-block-list\">\n<li><strong>dead_tuple_count<\/strong>: The number of dead tuples is now 10, indicating bloat.<\/li>\n\n\n\n<li><strong>dead_tuple_len<\/strong>: Size of dead tuples (380 bytes).<\/li>\n\n\n\n<li><strong>free_space<\/strong>: Free space remains the same (5964 bytes), but bloat is now present.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\">Removing Bloat<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Vacuum the Table:<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# vacuum test;\nVACUUM<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Running VACUUM helps to reclaim space from dead tuples, thus reducing bloat.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Check Bloat After Vacuuming:<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# select * from pgstattuple ('test');\n-&#091; RECORD 1 ]------+------\ntable_len          | 8192\ntuple_count        | 40\ntuple_len          | 1520\ntuple_percent      | 18.55\ndead_tuple_count   | 0\ndead_tuple_len     | 0\ndead_tuple_percent | 0\nfree_space         | 6404\nfree_percent       | 78.17<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">After vacuuming:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>dead_tuple_count<\/strong>: The dead tuples are now 0, meaning bloat has been cleared.<\/li>\n\n\n\n<li><strong>free_space<\/strong>: The free space has increased to 6404 bytes<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Note: It is recommended to schedule the <code>VACUUM<\/code> activity during off-peak hours.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>pgstattuple<\/strong> is an indispensable tool for PostgreSQL database administrators aiming to maintain optimal performance and efficient storage. By offering detailed insights into table and space utilization, it helps identify areas where space is being wasted and performance may be degraded. Regular use of <strong>pgstattuple<\/strong> can reveal critical information about dead tuples, free space, and overall storage efficiency.<br>Incorporating <strong>pgstattuple<\/strong> into your database maintenance routine allows for proactive management, helping to mitigate issues related to bloat before they impact performance. By analyzing the results, you can make informed decisions about vacuuming, reindexing, and adjusting autovacuum settings, ultimately leading to a healthier and more efficient PostgreSQL environment. In this blog, we used <strong>pgstattuple<\/strong> to monitor and manage table bloat effectively in order to ensure optimal database performance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction pgstattuple is an open-source utility in PostgreSQL, provided as an extension. It helps manage and clear table bloat, which [&hellip;]<\/p>\n","protected":false},"author":13,"featured_media":5968,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1,23,42,89],"tags":[],"class_list":["post-5948","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-others","category-postgresql-14","category-postgresql-15","category-postgresql-16"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction pgstattuple is an open-source utility in PostgreSQL, provided as an extension. It helps manage and clear table bloat, which [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-08-21T10:17:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-21T10:19:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3600\" \/>\n\t<meta property=\"og:image:height\" content=\"1890\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Shameer Bhupathi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shameer Bhupathi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\"},\"author\":{\"name\":\"Shameer Bhupathi\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\"},\"headline\":\"Unlocking PostgreSQL\u2019s potential with pgstattuple\",\"datePublished\":\"2024-08-21T10:17:02+00:00\",\"dateModified\":\"2024-08-21T10:19:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\"},\"wordCount\":581,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png\",\"articleSection\":[\"Others\",\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\",\"name\":\"Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png\",\"datePublished\":\"2024-08-21T10:17:02+00:00\",\"dateModified\":\"2024-08-21T10:19:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png\",\"width\":3600,\"height\":1890},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unlocking PostgreSQL\u2019s potential with pgstattuple\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5\",\"name\":\"Shameer Bhupathi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g\",\"caption\":\"Shameer Bhupathi\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB","og_description":"Introduction pgstattuple is an open-source utility in PostgreSQL, provided as an extension. It helps manage and clear table bloat, which [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2024-08-21T10:17:02+00:00","article_modified_time":"2024-08-21T10:19:38+00:00","og_image":[{"width":3600,"height":1890,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png","type":"image\/png"}],"author":"Shameer Bhupathi","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Shameer Bhupathi","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/"},"author":{"name":"Shameer Bhupathi","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5"},"headline":"Unlocking PostgreSQL\u2019s potential with pgstattuple","datePublished":"2024-08-21T10:17:02+00:00","dateModified":"2024-08-21T10:19:38+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/"},"wordCount":581,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png","articleSection":["Others","PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/","url":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/","name":"Unlocking PostgreSQL\u2019s potential with pgstattuple - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png","datePublished":"2024-08-21T10:17:02+00:00","dateModified":"2024-08-21T10:19:38+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png","width":3600,"height":1890},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/unlocking-postgresqls-potential-with-pgstattuple\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Unlocking PostgreSQL\u2019s potential with pgstattuple"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/422480fbefed0b2cee82aeab232110f5","name":"Shameer Bhupathi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cfa95999202132ded07acd24f6faf25dca145a6c3efe47919204f115ffbf625?s=96&d=mm&r=g","caption":"Shameer Bhupathi"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",3600,1890,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",3600,1890,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",3600,1890,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1-300x158.png",300,158,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1-1024x538.png",1024,538,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1-1536x806.png",1536,806,true],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1-2048x1075.png",2048,1075,true],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",1200,630,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",870,457,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",600,315,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2024\/08\/image-4-1.png",600,315,false]},"rttpg_author":{"display_name":"Shameer Bhupathi","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/shameer-bhupathi\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/business\/others\/\" rel=\"category tag\">Others<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction pgstattuple is an open-source utility in PostgreSQL, provided as an extension. It helps manage and clear table bloat, which [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=5948"}],"version-history":[{"count":14,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5948\/revisions"}],"predecessor-version":[{"id":5970,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/5948\/revisions\/5970"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/5968"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=5948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=5948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=5948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}