Reindex table

sql

REINDEX TABLE public.users;

Explanation

See summary for usage details.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Vacuum, Analyze, and Maintenance

Reclaim dead tuples and maintain visibility data.

Open In sheetsqlsame section

Rewrite a bloated table more aggressively.

Open In sheetsqlsame section

Vacuum and refresh planner stats in one command.

Open In sheetsqlsame section

Show extra detail while updating planner statistics.

Open In sheetsqlsame section

Check whether autovacuum is enabled.

Open In sheetsqlsame section

Delete in chunks to avoid huge transactions.

Open In sheetsql1 tag match