PostgreSQL - All tables and record count

public_tables_and_counts.sql

SELECT
  table_schema,
  table_name,
(xpath('/row/cnt/text()', xml_count))[1]::text::int AS row_count
FROM (
  SELECT
    table_name,
    table_schema,
    query_to_xml(format('select count(*) as cnt from %I.%I', table_schema, table_name), FALSE, TRUE, '') AS xml_count
  FROM
    information_schema.tables
  WHERE
    table_schema = 'public') t;