SizeOfTable.sql

SELECT
  pg_size_pretty(total_bytes) AS total,
  pg_size_pretty(index_bytes) AS index,
  pg_size_pretty(toast_bytes) AS toast,
  pg_size_pretty(total_bytes - index_bytes - toast_bytes) AS table
FROM (
  SELECT
    pg_total_relation_size(c.oid) AS total_bytes,
    pg_indexes_size(c.oid) AS index_bytes,
    coalesce(pg_total_relation_size(reltoastrelid), 0) AS toast_bytes
  FROM pg_class c
  WHERE c.oid = 'app_public.my_table_here'::regclass
) a;