This project is not covered by Drupal’s security advisory policy.

Smart View Query Analyzer helps identify performance risks in Drupal Views before they impact production. It provides a centralized dashboard that evaluates each View based on query complexity, relationships, field count, caching configuration, and pager usage.

The module assigns a risk level (Low, Medium, High, Critical) and highlights potential issues using danger flags, enabling developers to quickly detect and optimize inefficient Views.

Features

📊 Centralized Dashboard

  • Overview of all Views with risk classification
  • Summary of total Views, and risk distribution

⚠️ Risk Analysis

  • Automatically categorizes Views as:
  • Low
  • Medium
  • High
  • Critical

🔍 Detailed View Inspection

  • Number of relationships
  • Field count
  • Cache configuration status
  • Pager usage

🚩 Danger Flags

  • Identifies risky configurations such as:
  • Missing caching
  • Excessive fields or relationships
  • Potential performance bottlenecks

🧠 Actionable Insights

  • Drill-down “Analyze” option for each View
  • SQL-level inspection and optimization hints

⚡ Developer-Friendly

  • Helps catch issues early in development
  • Useful during code review and pre-deployment checks

How It Works

  1. The module scans all available Views.
  2. Each View is evaluated based on multiple factors:
    • Query complexity indicators
    • Relationships and joins
    • Number of fields
    • Cache settings
    • Pager configuration
  3. A risk score is calculated and displayed.
  4. Developers can click Analyze → to view detailed insights and suggestions.
Supporting organizations: 

Project information

Releases