dexter ☆
« Back to VersTracker
Description:
Automatic indexer for Postgres
Type: Formula  |  Latest Version: 0.6.3@0  |  Tracked Since: Dec 17, 2025
Links: Homepage  |  formulae.brew.sh
Category: Databases
Tags: postgresql database indexing performance devops cli
Install: brew install dexter
About:
Dexter is a command-line tool that automatically creates optimal indexes for your PostgreSQL database. It analyzes your slow queries and suggests the most effective indexes to improve performance. By leveraging PostgreSQL's built-in statistics, it removes the guesswork from database optimization.
Key Features:
  • Automated index recommendations based on query analysis
  • Zero-configuration setup and execution
  • Supports both Postgres and Amazon Redshift
  • Generates index definitions ready for execution
  • Integrates with query logs for real-world performance tuning
Use Cases:
  • Optimizing slow queries in production PostgreSQL databases
  • Reducing database load by adding missing indexes
  • Automating database performance tuning in CI/CD pipelines
  • Analyzing query patterns from logs to identify bottlenecks
Alternatives:
  • pg_stat_statements – PostgreSQL extension that tracks execution stats but doesn't provide automated index recommendations like Dexter
  • hypopg – PostgreSQL extension for hypothetical indexes, requires manual testing whereas Dexter automates the discovery process
Version History
Detected Version Rev Change Commit
Dec 26, 2024 5:42pm 1 VERSION_BUMP 0090c941
Sep 12, 2024 4:53pm 0 VERSION_BUMP 080f8d7c
« Back to VersTracker  |  Browse Packages  |  About