Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Collect planner stats

Refresh planner statistics for a table.

Back to sheetBrowse commands
Sign in to save
Section: Database Administration Utilities

Collect planner stats

sql
sql
ANALYZE public.users;
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

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

Compare commandsView fixes

Related commands

Same sheet · prioritizing Database Administration Utilities
Vacuum and analyze
Run vacuum/analyze from the shell.
OpenIn sheetbashsame section
Create database from shell
Create a database using the `createdb` utility.
OpenIn sheetbashsame section
Drop database from shell
Drop a database using the `dropdb` utility.
OpenIn sheetbashsame section
Create role from shell
Interactively create a new role.
OpenIn sheetbashsame section
Drop role from shell
Remove a role using the command-line utility.
OpenIn sheetbashsame section
Reindex database
Rebuild indexes in a database.
OpenIn sheetbashsame section