dexter

{
  "aliases": [],
  "alternatives": [],
  "build_dependencies": [],
  "categories": [],
  "caveats": null,
  "conflicts_with": [
    "dexter-lsp"
  ],
  "dependencies": [
    "libpq",
    "ruby"
  ],
  "deprecated": 0,
  "deprecation_reason": null,
  "desc": "Automatic indexer for Postgres",
  "disable_reason": null,
  "disabled": 0,
  "enrichment_fetched_at": "2026-06-20T23:36:55+00:00",
  "first_seen": "2026-06-20T23:34:18+00:00",
  "full_name": "dexter",
  "github_default_branch": "master",
  "github_last_commit_at": "2026-06-20T03:40:26Z",
  "github_readme_excerpt": "# Dexter\n\nThe automatic indexer for Postgres\n\n[Read about how it works](https://ankane.org/introducing-dexter) or [watch the talk](https://www.youtube.com/watch?v=Mni_1yTaNbE)\n\n[![Build Status](https://github.com/ankane/dexter/actions/workflows/build.yml/badge.svg)](https://github.com/ankane/dexter/actions)\n\n## Installation\n\nFirst, install [HypoPG](https://github.com/HypoPG/hypopg) on your database server. This doesn\u2019t require a restart.\n\n```sh\ncd /tmp\ncurl -L https://github.com/HypoPG/hypopg/archive/1.4.3.tar.gz | tar xz\ncd hypopg-1.4.3\nmake\nmake install # may need sudo\n```\n\nAnd enable it in databases where you want to use Dexter:\n\n```sql\nCREATE EXTENSION hypopg;\n```\n\nSee the [installation notes](#hypopg-installation-notes) if you run into issues.\n\nThen install the command line tool with:\n\n```sh\ngem install pgdexter\n```\n\nThe command line tool is also available with [Docker](#docker), [Homebrew](#homebrew), or as a [Linux package](guides/Linux.md).\n\n## How to Use\n\nDexter needs a connection to your database and a source of queries (like [pg_stat_statements](https://www.postgresql.org/docs/current/pgstatstatements.html)) to process.\n\n```sh\ndexter -d dbname --pg-stat-statements\n```\n\nThis finds slow queries and generates output like:\n\n```\nStarted\nProcessing 189 new query fingerprints\nIndex found: public.genres_movies (genre_id)\nIndex found: public.genres_movies (movie_id)\nIndex found: public.movies (title)\nIndex found: public.ratings (movie_id)\nIndex found: public.ratings (rating)\nIndex found: public.ratings (user_id)\n```\n\nTo be safe, Dexter will not create indexes unless you pass the `--create` flag. In this case, you\u2019ll see:\n\n```\nIndex found: public.ratings (user_id)\nCreating index: CREATE INDEX CONCURRENTLY ON \"public\".\"ratings\" (\"user_id\")\nIndex created: 15243 ms\n```\n\n## Connection Options\n\nDexter supports the same connection options as psql.\n\n```\n-h host -U user -p 5432 -d dbname\n```\n\nThis includes URIs:\n\n```\npostgresql://user:pass@host:5432/dbname\n```\n\nand connect",
  "github_repo": "ankane/dexter",
  "github_stars": 2082,
  "github_topics": [],
  "homepage": "https://github.com/ankane/dexter",
  "homepage_og_description": null,
  "homepage_og_image": null,
  "homepage_title": null,
  "installs_30d": 7,
  "installs_365d": 320,
  "installs_90d": 55,
  "keg_only": 0,
  "keg_only_reason": null,
  "last_seen": "2026-06-20T23:34:18+00:00",
  "license": "MIT",
  "llm_generated_at": null,
  "llm_model": null,
  "name": "dexter",
  "oldnames": [],
  "one_liner": null,
  "optional_dependencies": [],
  "rank_30d": 9707,
  "rank_365d": 6163,
  "rank_90d": 7072,
  "raw_hash": "a2dcf4a38d626f10",
  "recommended_dependencies": [],
  "revision": 1,
  "ruby_source_path": "Formula/d/dexter.rb",
  "tap": "homebrew/core",
  "test_dependencies": [
    "postgresql@18"
  ],
  "uses_from_macos": [],
  "version_head": null,
  "version_stable": "0.6.3",
  "versioned_formulae": [],
  "why_use_this": null
}