macOS
Homebrew已验证 · 100%
brew install dexterlocal Homebrew formula metadata
安装
其他安装命令
Linux
Nix已验证 · 92%
nix profile install nixpkgs#dexternixpkgs package indexes · pkgs/by-name/de/dexter/package.nix · 来源: api.github.com
概览
软件包摘要
Automatic indexer for Postgres
历史
项目历史与用法
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.
风险分类器
绿色 风险 · 低 置信度 · appliance
原因
- narrow executable package without higher-risk signals
信号
- metadata:no-higher-risk-signals
安装行为
- formula 元数据中未记录 Homebrew post-install 钩子。
- Homebrew bottle 元数据适用于 6 个平台目标。
- 安装时包含 2 个运行时依赖。
建议审查
在无人值守的代理使用前，请检查该工具是否读取明文凭据、写入远程状态、发布制品或调用插件。
可执行文件
已安装的可执行文件
| 命令 | 类型 | 暴露范围 | 备注 |
|---|---|---|---|
dexter | cli | 全局可执行文件 |
新鲜度
版本和新鲜度
这些信号区分页生成时间、软件包管理器活动和上游发布比较。只有存在证据 URL 和可比较版本时，才会提示版本落后。
页面生成时间2026-07-25
管理器版本0.6.3
管理器更新时间2026-06-22
本地数据OK
上游当前
检测到的最新版本v0.6.3
https://github.com/ankane/dexter
- OK没有生成新鲜度警告。
安装元数据
软件包元数据
| 软件包键 | brew:dexter |
|---|---|
| 版本 | 0.6.3 |
| 软件包管理器 | Homebrew |
| 软件包管理器页面 | https://formulae.brew.sh/formula/dexter |
| 主页 | https://github.com/ankane/dexter |
| 仓库 | https://github.com/ankane/dexter |
| 上游文档 | https://github.com/ankane/dexter#readme |
| 许可证 | MIT |
| 源码归档 | https://github.com/ankane/dexter/archive/refs/tags/v0.6.3.tar.gz |
| 最后更新 | 2026-06-22T14:03:09-07:00 |
| Pulse | updated |
| 依赖 | libpq, ruby |
| Bottle | 可用 (于 arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux) |
| Homebrew post-install | 未定义 |
| 服务 | 未声明 |
注册表事实
源数据库详情
| Source Database | Homebrew formula API |
|---|---|
| Tap | homebrew/core |
| Full Name | dexter |
| Version Scheme | 0 |
| Revision | 1 |
| Conflicts With |
|
| Bottle Stable Root URL | https://ghcr.io/v2/homebrew/core |
| Deprecated | no |
| Disabled | no |
| Keg Only | no |
| URL Keys |
|
源数据库匹配
其他软件包管理器记录
匹配项来自外部软件包管理器索引，并与本地 Automic Vault 软件包链接分开显示。
Nix95%
dexter
nix profile install nixpkgs#dexter- normalized package name match
- 匹配方式：Dexter
来源线索
由仓库数据生成
此页面由 av-web 从 scripts/generate-pkg-sqlite.py 生成的私有软件包 SQLite 工件提供。
Combined YAML source
View the package source record on GitHub.
使用的来源
- Geiger risk classifier
- Nucleus package database
- av.db category and tag curation
- cross-ecosystem install command graph
- curated package history
- external package-manager database matches
- package relationship graph
- package version freshness
- package-page enrichment