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