README.md in pgdexter-0.3.0 vs README.md in pgdexter-0.3.1

- old
+ new

@@ -128,11 +128,11 @@ ```sh dexter --input-format csv ``` -When steaming logs, specify the time to wait between processing queries +When streaming logs, specify the time to wait between processing queries ```sh dexter --interval 60 # seconds ``` @@ -148,10 +148,18 @@ ```sh tail -F -n +1 /usr/local/var/postgres/server.log | dexter dbname ``` +## Analyze + +For best results, make sure your tables have been recently analyzed so statistics are up-to-date. You can ask Dexter to analyze tables it comes across that haven’t been analyzed in the past hour with: + +```sh +dexter --analyze +``` + ## Tables You can exclude large or write-heavy tables from indexing with: ```sh @@ -168,17 +176,9 @@ See how Dexter is processing queries with: ```sh dexter --log-sql --log-level debug2 -``` - -## Analyze - -For best results, make sure your tables have been recently analyzed so statistics are up-to-date. You can ask Dexter to analyze tables it comes across that haven’t been analyzed in the past hour with: - -```sh -dexter --analyze ``` ## Hosted Postgres Some hosted providers like Amazon RDS and Heroku do not support the HypoPG extension, which Dexter needs to run. See [how to use Dexter](guides/Hosted-Postgres.md) in these cases.