一覧へ戻る
ankane/pghero.sql（新しいタブで開きます）
主要言語: PLpgSQL
Postgres insights made easy
- star 数
- 157
- watcher 数
- 1
- fork 数
- 14
- issue 数
- 0
- 最終更新
- 2020/04/16
gem-hunter主要言語: PLpgSQL
Postgres insights made easy
Note: This has been replaced with PgHero.
Postgres insights made easy
Supports PostgreSQL 9.4+
A big thanks to Craig Kerstiens and Heroku for the initial queries 👏
View all running queries with:
SELECT * FROM pghero_running_queries;
Queries running for longer than five minutes
SELECT * FROM pghero_long_running_queries;
Queries can be killed by pid with:
SELECT pghero_kill(123);
Kill all running queries with:
SELECT pghero_kill_all();All usage
SELECT * FROM pghero_index_usage;
Missing indexes
SELECT * FROM pghero_missing_indexes;
Unused Indexes
SELECT * FROM pghero_unused_indexes;
Largest tables and indexes
SELECT * FROM pghero_relation_sizes;
SELECT pghero_index_hit_rate();and
SELECT pghero_table_hit_rate();Both should be above 99%.
Run this command from your shell:
curl https://raw.githubusercontent.com/ankane/pghero.sql/master/install.sql | psql db_nameor copy its contents into a SQL console.
curl https://raw.githubusercontent.com/ankane/pghero.sql/master/uninstall.sql | psql db_nameEveryone is encouraged to help improve this project. Here are a few ways you can help: