Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
c_stmtstatus_counter.html

Index Summary Markup Original


R-17341-41375-54397-54408-61756-02302-26643-35471 tcl slt th3 src

This is the number of times that SQLite has stepped forward in a table as part of a full table scan.

/* IMP: R-17341-41375 */
# EVIDENCE-OF: R-17341-41375 This is the number of times that SQLite has
# stepped forward in a table as part of a full table scan.

R-29161-24939-37010-28632-36605-59202-44014-09658 tcl slt th3 src

This is the number of sort operations that have occurred.

/* IMP: R-29161-24939 */
# EVIDENCE-OF: R-29161-24939 This is the number of sort operations that
# have occurred.

R-14672-19530-25387-57734-27624-49837-27929-41109 tcl slt th3 src

This is the number of rows inserted into transient indices that were created automatically in order to help joins run faster.

/* IMP: R-14672-19530 */
# EVIDENCE-OF: R-14672-19530 This is the number of rows inserted into
# transient indices that were created automatically in order to help
# joins run faster.

R-46780-34130-42515-13535-26112-08732-08829-27411 tcl slt th3 src

This is the number of virtual machine operations executed by the prepared statement if that number is less than or equal to 2147483647.

/* IMP: R-46780-34130 */
# EVIDENCE-OF: R-46780-34130 This is the number of virtual machine
# operations executed by the prepared statement if that number is less
# than or equal to 2147483647.

R-54913-41491-50260-09040-49829-18676-09673-35147 tcl slt th3 src

This is the number of times that the prepare statement has been automatically regenerated due to schema changes or changes to bound parameters that might affect the query plan.

/* IMP: R-54913-41491 */
# EVIDENCE-OF: R-54913-41491 This is the number of times that the
# prepare statement has been automatically regenerated due to schema
# changes or changes to bound parameters that might affect the query
# plan.

R-22511-33242-53982-27627-41881-51518-34601-24400 tcl slt th3 src

This is the number of times that the prepared statement has been run.

/* IMP: R-22511-33242 */
# EVIDENCE-OF: R-22511-33242 This is the number of times that the
# prepared statement has been run.

R-23138-20648-33254-30193-19354-36765-51385-50744 tcl slt th3 src

SQLITE_STMTSTATUS_FILTER_HIT is the number of times that a join step was bypassed because a Bloom filter returned not-found.

/* IMP: R-23138-20648 */
# EVIDENCE-OF: R-23138-20648 SQLITE_STMTSTATUS_FILTER_HIT is the number
# of times that a join step was bypassed because a Bloom filter returned
# not-found.

R-61862-04293-61183-46877-49121-08671-06264-56801 tcl slt th3 src

This is the approximate number of bytes of heap memory used to store the prepared statement.

/* IMP: R-61862-04293 */
# EVIDENCE-OF: R-61862-04293 This is the approximate number of bytes of
# heap memory used to store the prepared statement.

R-17403-41821-06964-23183-41391-40881-28445-64765 tcl slt th3 src

This value is not actually a counter, and so the resetFlg parameter to sqlite3_stmt_status() is ignored when the opcode is SQLITE_STMTSTATUS_MEMUSED.

/* IMP: R-17403-41821 */
# EVIDENCE-OF: R-17403-41821 This value is not actually a counter, and
# so the resetFlg parameter to sqlite3_stmt_status() is ignored when the
# opcode is SQLITE_STMTSTATUS_MEMUSED.