postgresql-17-toastinfo

Show storage structure of varlena datatypes in PostgreSQL

Description

This PostgreSQL extension exposes the internal storage structure of variable-length datatypes, called varlena.

The function pg_toastinfo describes the storage form of a datum:

* null for NULLs

* ordinary for non-varlena datatypes

* short inline varlena for varlena values up to 126 bytes (1 byte header)

* long inline varlena, (un)compressed for varlena values up to 1GiB

(4 bytes header)

* toasted varlena, (un)compressed for varlena values up to 1GiB stored in

TOAST tables

The function pg_toastpointer returns a varlena's chunk_id oid in the corresponding TOAST table. It returns NULL on non-varlena input.

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Hint: upload an image here from your clipboard with Ctrl-V

Homepage

Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…