# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1548268771 -7200
# Node ID 984ccb104a6e4586a703cd457f8dc967a8b914e0
# Parent  fb128fcaf50a9e92de3f271bd77775824ac1161b
Size of types.

diff -r fb128fcaf50a -r 984ccb104a6e postgres.rst
--- a/postgres.rst	Thu Jan 10 14:13:45 2019 +0200
+++ b/postgres.rst	Wed Jan 23 20:39:31 2019 +0200
@@ -289,6 +289,15 @@
   LEFT JOIN pg_class t ON t.reltoastrelid = p.oid
   ORDER BY p.relpages DESC;
 
+Size of types::
+
+  SELECT pg_column_size(5::smallint);
+  SELECT pg_column_size(5::int);
+  SELECT pg_column_size(5::bigint);
+
+https://wiki.postgresql.org/wiki/Disk_Usage
+   Finding the size of various object in your database.
+
 MVCC and transaction id
 =======================