Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lD515-0003vu-DP for pgsql-admin@arkaria.postgresql.org; Fri, 19 Feb 2021 12:36:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lD514-0003wg-4G for pgsql-admin@arkaria.postgresql.org; Fri, 19 Feb 2021 12:36:14 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lD513-0003wZ-T6 for pgsql-admin@lists.postgresql.org; Fri, 19 Feb 2021 12:36:13 +0000 Received: from mail-qt1-x836.google.com ([2607:f8b0:4864:20::836]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lD511-0000Uz-CO for pgsql-admin@lists.postgresql.org; Fri, 19 Feb 2021 12:36:13 +0000 Received: by mail-qt1-x836.google.com with SMTP id b24so3745297qtp.13 for ; Fri, 19 Feb 2021 04:36:11 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=tiUtZAfl5dnR4hONFbIvRt6AnU16Mfeekl0ATDjNct8=; b=P7OsWc8DYE4CKnjm4qXt6y+4Jyp9Ux8DjRr8z61ztWVe04DHZoDQccHJImR+rfl3aF b3NXoj91+VL7J7ZauG3KSd31FYTQz8yKqieH4gM0q3x8ev4F5PuZ474YpaHZD626uTlL D0niu06LYRQ1VEQUqvvbQMegeJNYbHUE5mAcPx360bJihNxgaWbRdbZPeYce7CiHRYhO SIA5Om3O0o0W6Z4YqqqTa6MeLsSflKvbC3AzckDX7U8HIY9Vr7llSQm0AEaFs3hRAp7Y ZfhPFjDWOXpzuTuwd7z9FlvjgU0eztlkx0gazm1tLI5/oB3YPDqJ4L5B+JKC7gcUJnHl SxoQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=tiUtZAfl5dnR4hONFbIvRt6AnU16Mfeekl0ATDjNct8=; b=qh29vj4WfkE8KaWlvpL5d/xBjYyA2bLnKn3shAo/S/I62JLxi5mBfqlIRJLrpNE2y4 EPaV6Ha04QL7N5tsMPfXGJkCHQWt4l6ETlb3hxPkb9ScZcVJPCkDPG87+uZ1Oo8E7apq v/eAsRhtV1yt5ahKKBYP90jQDOqakMn5sZre5t6Ww+yI81uD9Cfka9AxDvfYZJ1KsfhR tJgXy8CilGtPZwwoqF/YAcJRRoq/sRPnRQwiNBp6POSHE3oi08iFMhL2yERalSRsPFlT jtpvKDBlhrkVD5kkzb+Oel9O20hznDVYs7AQz6rX6k+yS85oOk3Q5qVcdQBDsMUaUmNU mjOg== X-Gm-Message-State: AOAM533646CsOHuk2/7qJnheS7MJMRi4+oSCjRxo5EmpjcrJwbC+NwGk Qj1pGsNGUWSSaSuEN7n2JupQSY0+144= X-Google-Smtp-Source: ABdhPJxyBrVk0sv3JY+AvlaqWsHe5x4aqiYvT8YJansjS5WNHKXcCT96GiaQqS5vDXzrUPqtXsFS5g== X-Received: by 2002:ac8:8c3:: with SMTP id y3mr8458678qth.388.1613738168950; Fri, 19 Feb 2021 04:36:08 -0800 (PST) Received: from [192.168.254.67] (h178.165.133.40.static.ip.windstream.net. [40.133.165.178]) by smtp.gmail.com with ESMTPSA id m8sm3342599qkm.58.2021.02.19.04.36.08 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 19 Feb 2021 04:36:08 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-6CE1D442-0E16-4EAA-BBE6-C46A6A337B57 Content-Transfer-Encoding: 7bit From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: Looking find the each row size of table Date: Fri, 19 Feb 2021 07:36:07 -0500 Message-Id: References: Cc: pgsql-admin@lists.postgresql.org In-Reply-To: To: dbatoCloud Solution X-Mailer: iPad Mail (18D52) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail-6CE1D442-0E16-4EAA-BBE6-C46A6A337B57 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable pg_column_size returns the number of bytes with no formatting at all. Do som= ething like select pg_size_pretty(pg_column_size(my_column) / 1024) would g= ive you the value in Kbytes, further calculation in the same manner could co= nvert this into Mbytes, Gbytes, or whatever you need. =E2=80=94 Jay Sent from my iPad > On Feb 19, 2021, at 7:28 AM, dbatoCloud Solution w= rote: >=20 > =EF=BB=BF > Dear All, > I want to find out each row size of a table in PostgreSQL?=20 > I got pg_column_size() function. Could you please someone help me? Will th= is function return size in KB or MB? > =20 >=20 > =20 >=20 > Thanks & Best Wishes, >=20 > Ashok >=20 > =20 >=20 > --------------------------------------------------------------------------= ------------------------------------------- >=20 > Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103) >=20 > Dubai , UAE | BLR , INDIA >=20 > M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922 >=20 > W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com=20 --Apple-Mail-6CE1D442-0E16-4EAA-BBE6-C46A6A337B57 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable pg_column_size returns the number of bytes w= ith no formatting at all. Do something like select pg_size_pretty(pg_column_= size(my_column) / 1024)  would give you the value in Kbytes, further ca= lculation in the same manner could convert this into Mbytes, Gbytes, or what= ever you need.
=E2=80=94
Jay

Sent from= my iPad

On Feb 19, 2021= , at 7:28 AM, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
<= br>
=EF=BB=BF
Dear All,
 I want to find out ea= ch row size of a table in PostgreSQL? 
I got pg_col= umn_size() function. Could you please someone help me? Will this function re= turn size in KB or MB?

 

 

Thanks & Best= Wishes,

Ashok

 

-----------------------------------------------------= ----------------------------------------------------------------

A= shokkumar Mani  (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UA= E | BLR , I= NDIA

M:= +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W:= https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@gmail.com

= --Apple-Mail-6CE1D442-0E16-4EAA-BBE6-C46A6A337B57--