# pg_statio_user_tables

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: pg_statio_user_tables
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/system-catalogs/catalogs/pg_statio_user_tables
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/system-catalogs/catalogs/pg_statio_user_tables.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/system-catalogs/catalogs/pg_statio_user_tables.adoc
description: The pg_statio_user_tables contains one row for each user table in the current database, showing statistics columns filled with zeros.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/system-catalogs/catalogs/pg_statio_user_tables.md -->

The `pg_statio_user_tables` contains one row for each user table in the current database, showing statistics columns filled with zeros.

## [](#columns)Columns

The following columns are available for querying in `pg_statio_user_tables` :

| Column | Type | Description |
| --- | --- | --- |
| relid | int | This column represents the table ID |
| relname | text | This column represents the table name |
| schemaname | text | This column represents the schema name that this table is in |
| heap_blks_read | int | unused |
| heap_blks_hit | int | unused |
| idx_blks_read | int | unused |
| idx_blks_hit | int | unused |
| toast_blks_read | int | unused |
| toast_blks_hit | int | unused |
| tidx_blks_read | int | unused |
| tidx_blks_hit | int | unused |

## [](#examples)Examples

1.  Create a new table:

    ```sql
    CREATE TABLE example_table (
        data text,
        cluster text,
        storage int
    );
    ```

2.  Run the query combined with a `WHERE` clause to look up based on the table name (`relname`):

    ```sql
    SELECT relid, schemaname, relname FROM pg_statio_user_tables;
    ```

3.  This returns the table size in bytes:

    ```sql
     relid | schemaname |  relname
    -------+------------+---------------
     16384 | public     | job
     16385 | public     | example_table
    (2 rows)
    ```