Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Correction to the schema for the DBSTAT virtual table. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
a30aad4d5c92f022df40db51f5748eaf |
User & Date: | drh 2017-06-26 14:43:46.357 |
Context
2017-07-01
| ||
23:24 | Attempt to improve the INSERT documentation. (check-in: 6b1a2005d8 user: drh tags: branch-3.19) | |
2017-06-29
| ||
14:47 | Initial draft of release notes for version 3.20.0. (check-in: fe054454f3 user: drh tags: trunk) | |
2017-06-26
| ||
14:43 | Correction to the schema for the DBSTAT virtual table. (check-in: a30aad4d5c user: drh tags: trunk) | |
2017-06-17
| ||
13:51 | Add a reference to the Jim Gray paper to the faster-than-filesystem article. (check-in: b37cb6bc60 user: drh tags: trunk) | |
Changes
Changes to pages/dbstat.in.
︙ | ︙ | |||
58 59 60 61 62 63 64 | name in the FROM clause of the query. (See further discussion of [table-valued functions in the FROM clause] for more details.) <p> The schema for the dbstat virtual table is this: <codeblock> CREATE TABLE dbstat( | | | | | | | | | | | | | 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | name in the FROM clause of the query. (See further discussion of [table-valued functions in the FROM clause] for more details.) <p> The schema for the dbstat virtual table is this: <codeblock> CREATE TABLE dbstat( name TEXT, -- Name of table or index path TEXT, -- Path to page from root pageno INTEGER, -- Page number pagetype TEXT, -- 'internal', 'leaf' or 'overflow' ncell INTEGER, -- Cells on page (0 for overflow) payload INTEGER, -- Bytes of payload on this page unused INTEGER, -- Bytes of unused space on this page mx_payload INTEGER, -- Largest payload size of all cells on this page pgoffset INTEGER, -- Offset of page in file pgsize INTEGER, -- Size of the page schema TEXT HIDDEN -- Database schema being analyzed ); </codeblock> <p> There is a single row of the dbstat table for each page in the database file. Freelist pages, the lock page, and pointer-map pages of the database file do not appear in the |
︙ | ︙ |