# 使用 Homebrew, Nix 安装 dexter 查看 dexter 的安装路径、可执行文件、元数据以及面向 AI 代理工作流的安全说明。 ## 安装 ```sh sudo av install brew:dexter ``` 其他安装命令: ### macOS - Homebrew (100%): ```sh brew install dexter ``` 证据: local Homebrew formula metadata ### Linux - Nix (92%): ```sh nix profile install nixpkgs#dexter ``` 证据: nixpkgs package indexes: pkgs/by-name/de/dexter/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## 软件包事实 - **软件包键:** brew:dexter - **软件包管理器:** Homebrew - **软件包管理器页面:** - **版本:** 0.6.3 - **来源摘要:** Automatic indexer for Postgres - **主页:** - **仓库:** - **许可证:** MIT - **源码归档:** - **最后更新:** 2026-06-22T14:03:09-07:00 - **已生成:** 2026-08-04T22:13:35+00:00 ## 可执行文件 - dexter (cli) - dexter (别名) ## 依赖 - libpq - ruby ## 安装行为 - post-install 钩子: 未定义 - Bottle: 可用 于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux ## 版本和新鲜度 - 页面生成时间: 2026-08-04 - 管理器版本: 0.6.3 - 管理器更新时间: 2026-06-22 - 本地数据: OK - 上游仓库: https://github.com/ankane/dexter - 检测到的最新版本: v0.6.3 (当前) ## 项目历史与用法 Dexter is an automatic index recommender for PostgreSQL that analyzes query sources and proposes indexes using HypoPG before optionally creating them. ### 项目历史 The official tag history starts in 2017, and the changelog shows a steady 0.x series focused on safer index suggestions, more input sources, PostgreSQL compatibility, Docker and Linux packaging, and support for newer Ruby and PostgreSQL versions. ### 采用历史 Dexter entered the PostgreSQL performance-tool niche as a command-line utility that can read pg_stat_statements, live activity, log files, SQL files, and stdin. Its README documents installation through RubyGems, Docker, Homebrew, and Linux packages. ### 使用方式 A typical run points Dexter at a database and a query source, such as `dexter -d dbname --pg-stat-statements`. By default it reports candidate indexes; creating indexes requires an explicit `--create` flag. ### 为什么软件包爱好者会关心 The package is notable because it bridges application-level package managers and database-server extension packaging: the CLI is easy to install, but useful operation also depends on HypoPG being present and enabled on the PostgreSQL server. ### 时间线 - 2017: v0.1.0 appears in the official tag history. - 2017: early releases add pg_stat_statements, psql-style connection options, CSV input, multicolumn indexes, and schema support. - 2023: v0.5.0 adds normalized-query support and changes several input and HypoPG safety defaults. - 2025: v0.6.0 adds Linux packages for Ubuntu 24.04 and Debian 12 while dropping older runtime support. ### Related projects - Dexter is tightly related to PostgreSQL, pg_stat_statements, pg_stat_activity, server log analysis, pg_query, and the HypoPG extension for hypothetical indexes. ### 来源 - - - ## 安全说明 narrow executable package without higher-risk signals. - **Geiger 风险:** 绿色 / 低 - narrow executable package without higher-risk signals ## 源数据库详情 - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** dexter - **Version Scheme:** 0 - **Revision:** 1 - **Conflicts With:** dexter-lsp - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## 其他软件包管理器记录 - Nix - dexter: normalized package name match | nixpkgs package indexes: pkgs/by-name/de/dexter/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## 相关链接 - [Source-control packages](https://pkg.so/zh-hans/source-control-tools/) - Belongs to a source-control command family. - [Terminal utility packages](https://pkg.so/zh-hans/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://pkg.so/zh-hans/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://pkg.so/zh-hans/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [ruby](https://pkg.so/zh-hans/brew/ruby/) - Runtime dependency declared by Homebrew. - [libpq](https://pkg.so/zh-hans/brew/libpq/) - Runtime dependency declared by Homebrew. - [postgresql@14](https://pkg.so/zh-hans/brew/postgresql-14/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@16](https://pkg.so/zh-hans/brew/postgresql-16/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@17](https://pkg.so/zh-hans/brew/postgresql-17/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@18](https://pkg.so/zh-hans/brew/postgresql-18/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgresql@15](https://pkg.so/zh-hans/brew/postgresql-15/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [postgis](https://pkg.so/zh-hans/brew/postgis/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [lazysql](https://pkg.so/zh-hans/brew/lazysql/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [doltgres](https://pkg.so/zh-hans/brew/doltgres/) - Shares pkgdb curated category or tags: cli, data, database, postgresql. - [pgslice](https://pkg.so/zh-hans/brew/pgslice/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres. - [pgsync](https://pkg.so/zh-hans/brew/pgsync/) - Both packages touch the same language runtime or ecosystem. Shared terms: cli, data, database, libpq, postgres. - [kitchen-sync](https://pkg.so/zh-hans/brew/kitchen-sync/) - Local metadata places this package in an adjacent workflow. Shared terms: cli, data, database, libpq, postgresql. ## Combined YAML source View the package source record on GitHub. [combined/dexter.yml](https://github.com/mxcl/pkgdb/blob/main/combined/dexter.yml) ## 来源 - pkg.so package database - Geiger risk classifier - package-page enrichment - curated package history - package version freshness - pkgdb category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph