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
Jan 11, 2024 2:14pm 0 VERSION_BUMP 3e14d02b
Oct 1, 2023 8:08am 0 VERSION_BUMP 63810268
May 27, 2023 9:37pm 0 VERSION_BUMP 9a74da70
May 27, 2023 11:41am 0 VERSION_BUMP 9b5a2369
« Back to VersTracker  |  Browse Packages  |  About