> ## Documentation Index
> Fetch the complete documentation index at: https://docs.moonly.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Get transaction statistics

> Returns statistical information about database transactions.



## OpenAPI

````yaml openapi.json get /transactions/statistics
openapi: 3.0.0
info:
  title: Aurora Database API
  description: >-
    Comprehensive database management API providing dynamic database
    connections, real-time table operations, advanced querying, and transaction
    logging. Supports both managed PostgreSQL databases and external database
    connections with full CRUD operations.
  contact:
    name: Aurora Development Team
    email: support@aurora.com
  license:
    name: MIT
    url: https://opensource.org/licenses/MIT
  version: '1.0'
servers:
  - url: /api
    description: Aurora API Server
security:
  - sanctum: []
tags:
  - name: Database Management
    description: >-
      🗄️ **Create, manage, and connect databases** - Start here to set up your
      PostgreSQL databases or connect to existing ones. These endpoints let you
      create managed databases, test connections, and handle basic database
      operations.
  - name: Table Operations
    description: >-
      📊 **Design your data structure** - Build and manage tables within your
      databases. Create tables with custom names, get table information, and
      organize your data structure exactly how you need it.
  - name: Column Management
    description: >-
      🏗️ **Define your data fields** - Add columns to your tables with various
      data types like text, numbers, dates, and more. Configure column
      properties, validation rules, and organize your data schema.
  - name: Formula Management
    description: >-
      🧮 **Create calculated fields** - Build dynamic Formula columns that
      automatically calculate values based on other columns in your table.
      Perfect for CRM calculations like deal values, commissions, and lead
      scoring.
  - name: Data Operations
    description: >-
      📝 **Work with your data** - The core endpoints for managing your actual
      data. Insert new records, update existing ones, delete data, and retrieve
      information with powerful filtering and search capabilities.
  - name: Advanced Queries
    description: >-
      🔍 **Powerful data analysis** - Advanced querying capabilities including
      complex filtering, aggregations, grouping, and custom search operations.
      Perfect for analytics and reporting.
  - name: Transaction History
    description: >-
      📋 **Audit and monitoring** - Track all changes and operations performed
      on your databases. View transaction logs, get statistics, and maintain a
      complete audit trail of your data operations.
  - name: Account
    description: Account
  - name: Agents
    description: Agents
  - name: Agents - Skills
    description: Agents - Skills
  - name: Agents - Tools
    description: Agents - Tools
  - name: Agents - Runs
    description: Agents - Runs
  - name: Row Comments
    description: Row Comments
  - name: Bulk Data Operations
    description: Bulk Data Operations
  - name: Browser Utilities
    description: Browser Utilities
  - name: Utility Management
    description: Utility Management
  - name: File Utilities
    description: File Utilities
  - name: Image Utilities
    description: Image Utilities
  - name: Media Utilities
    description: Media Utilities
  - name: Vector Collections
    description: Vector Collections
  - name: Vector Store
    description: Vector Store
  - name: Vector Points
    description: Vector Points
  - name: Vector Search
    description: Vector Search
paths:
  /transactions/statistics:
    get:
      tags:
        - Transaction History
      summary: Get transaction statistics
      description: Returns statistical information about database transactions.
      operationId: getTransactionStatistics
      parameters:
        - name: database_id
          in: query
          description: Filter statistics by database ID
          schema:
            type: string
            format: uuid
      responses:
        '200':
          description: Statistics retrieved successfully
          content:
            application/json:
              schema:
                properties:
                  total_transactions:
                    type: integer
                  successful_transactions:
                    type: integer
                  failed_transactions:
                    type: integer
                  average_execution_time_ms:
                    type: number
                  total_affected_rows:
                    type: integer
                type: object
      security:
        - sanctum: []
components:
  securitySchemes:
    sanctum:
      type: apiKey
      description: Enter token in format (Bearer <token>)
      name: Authorization
      in: header

````