Section: Performance and file settings

Inspect page size

sql
sql
PRAGMA page_size;
Explanation

Page size is part of the file format and relevant for some performance and storage investigations.

Learn the surrounding workflow

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

Related commands

Same sheet · prioritizing Performance and file settings
Set cache size
Adjust the number of pages or kibibytes used for page cache.
OpenIn sheetsqlsame section
Set synchronous mode
Control durability vs speed tradeoffs.
OpenIn sheetsqlsame section
Control temporary storage location
Choose file-backed or memory temp storage.
OpenIn sheetsqlsame section
Track application schema version
Read or set the user-defined schema version number.
OpenIn sheetsqlsame section
Enable foreign key enforcement
Turn on FK checks for the current connection.
OpenIn sheetsql1 tag match
Check current foreign key setting
Read whether FK enforcement is enabled.
OpenIn sheetsql1 tag match