# 使用 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
- **主页:** <https://github.com/ankane/dexter>
- **仓库:** <https://github.com/ankane/dexter>
- **最后更新:** 2026-06-22T14:03:09-07:00
- **已生成:** 2026-08-03T19:37:03+00:00

## 可执行文件

- dexter (别名)

## 安装行为

- Bottle: 不可用

## 版本和新鲜度

- 页面生成时间: 2026-08-03
- 管理器版本: 0.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.

### 来源

- <https://github.com/ankane/dexter#readme>
- <https://github.com/ankane/dexter/blob/master/CHANGELOG.md>
- <https://github.com/ankane/dexter/tags>


## 安全说明

narrow executable package without higher-risk signals.

- **Geiger 风险:** 绿色 / 低
- narrow executable package without higher-risk signals

## 其他软件包管理器记录

- 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


## 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
- curated package history
- pkgdb category and tag curation
- external package-manager database matches
- cross-ecosystem install command graph