↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / System Administration Functions

pg_ls_tmpdir

Read the PG 18 manual

Returns the name, size, and last modification time (mtime) of each ordinary file in the temporary file directory for the specified tablespace.

Reading PG 18current·documented in 9 of 27 versions, 12 to 20

Signatures & examples

pg_ls_tmpdir ( [ tablespace oid ] ) → setof record ( name text, size bigint, modification timestamp with time zone )
Returns the name, size, and last modification time (mtime) of each ordinary file in the temporary file directory for the specified tablespace. If tablespace is not provided, the pg_default tablespace is examined. Filenames beginning with a dot, directories, and other special files are excluded.
Version history 2
  1. 12 → 13 changed
  2. 11 → 12 added

Definition snapshot: b7bd9cda · English manual source