README.md in pgdexter-0.3.3 vs README.md in pgdexter-0.3.4
- old
+ new
@@ -6,16 +6,16 @@
[](https://travis-ci.org/ankane/dexter)
## Installation
-First, install [HypoPG](https://github.com/dalibo/hypopg) on your database server. This doesn’t require a restart.
+First, install [HypoPG](https://github.com/HypoPG/hypopg) on your database server. This doesn’t require a restart.
```sh
cd /tmp
-curl -L https://github.com/dalibo/hypopg/archive/1.1.0.tar.gz | tar xz
-cd hypopg-1.1.0
+curl -L https://github.com/HypoPG/hypopg/archive/1.1.1.tar.gz | tar xz
+cd hypopg-1.1.1
make
make install # may need sudo
```
> Note: If you have issues, make sure `postgresql-server-dev-*` is installed.
@@ -102,16 +102,22 @@
```sh
dexter <connection-options> <file1> <file2>
```
+or collect running queries with: [master]
+
+```sh
+dexter <connection-options> --pg-stat-activity
+```
+
or use the [pg_stat_statements](https://www.postgresql.org/docs/current/static/pgstatstatements.html) extension:
```sh
dexter <connection-options> --pg-stat-statements
```
-> Note: Logs are highly preferred over pg_stat_statements, as pg_stat_statements often doesn’t store enough information to optimize queries.
+> Note: Logs or running queries are highly preferred over pg_stat_statements, as pg_stat_statements often doesn’t store enough information to optimize queries.
### Collection Options
To prevent one-off queries from being indexed, specify a minimum number of calls before a query is considered for indexing