---
name: "DBIx::Class::Storage::Statistics"
section: "3pm"
platform: "linux"
package: "libdbix-class-perl"
version: "0.082844-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/DBIx::Class::Storage::Statistics"
---

# DBIx::Class::Storage::Statistics(3pm)

SQL Statistics

## NAME

DBIx::Class::Storage::Statistics - SQL Statistics

## SYNOPSIS

## DESCRIPTION

This class is called by DBIx::Class::Storage::DBI as a means of collecting statistics on its actions.  Using this class alone merely prints the SQL executed, the fact that it completes and begin/end notification for transactions.

To really use this class you should subclass it and create your own method for collecting the statistics as discussed in DBIx::Class::Manual::Cookbook.

## METHODS

### new

Returns a new DBIx::Class::Storage::Statistics object.

### debugfh

Sets or retrieves the filehandle used for trace/debug output.  This should be an IO::Handle compatible object (only the print method is used). By default it is initially set to STDERR - although see discussion of the DBIC\_TRACE environment variable.

Invoked as a getter it will lazily open a filehandle and set it to autoflush (if one is not already set).

### print

Prints the specified string to our debugging filehandle.  Provided to save our methods the worry of how to display the message.

### silence

Turn off all output if set to true.

### txn\_begin

Called when a transaction begins.

### txn\_rollback

Called when a transaction is rolled back.

### txn\_commit

Called when a transaction is committed.

### svp\_begin

Called when a savepoint is created.

### svp\_release

Called when a savepoint is released.

### svp\_rollback

Called when rolling back to a savepoint.

### query\_start

Called before a query is executed.  The first argument is the SQL string being executed and subsequent arguments are the parameters used for the query.

### query\_end

Called when a query finishes executing.  Has the same arguments as query\_start.

## FURTHER QUESTIONS?

Check the list of additional DBIC resources.

## COPYRIGHT AND LICENSE

This module is free software copyright by the DBIx::Class (DBIC) authors. You can redistribute it and/or modify it under the same terms as the DBIx::Class library.