README.md in pgdexter-0.1.3 vs README.md in pgdexter-0.1.4
- old
+ new
@@ -11,16 +11,16 @@
```sh
wget https://github.com/dalibo/hypopg/archive/1.0.0.tar.gz
tar xf 1.0.0.tar.gz
cd hypopg-1.0.0
make
-make install
+make install # may need sudo
```
> Note: If you have issues, make sure `postgresql-server-dev-*` is installed.
-Enable logging for slow queries.
+Enable logging for slow queries in your Postgres config file.
```ini
log_min_duration_statement = 10 # ms
```
@@ -28,10 +28,12 @@
```sh
gem install pgdexter
```
+The command line tool is also available as a [Linux package](guides/Linux.md).
+
## How to Use
Dexter needs a connection to your database and a log file to process.
```sh
@@ -58,16 +60,24 @@
2017-06-25T17:52:22+00:00 Index found: ratings (user_id)
2017-06-25T17:52:22+00:00 Creating index: CREATE INDEX CONCURRENTLY ON "ratings" ("user_id")
2017-06-25T17:52:37+00:00 Index created: 15243 ms
```
+## Single Statement Mode
+
+You can also pass a single statement with:
+
+```sh
+dexter <database-url> -s "SELECT * FROM ..."
+```
+
## Options
Name | Description | Default
--- | --- | ---
exclude | prevent specific tables from being indexed | None
interval | time to wait between processing queries, in seconds | 60
-log-level | `debug` gives additional info for suggested indexes<br />`debug2` gives additional info for all processed queries | info
+log-level | `debug` gives additional info for suggested indexes<br />`debug2` gives additional info for processed queries | info
log-sql | log SQL statements executed | false
min-time | only process queries consuming a min amount of DB time, in minutes | 0
## Future Work