
Check for indexes that are the prefix of other indexes. For example if we have these 2 indexes

.. code-block:: javascript

   db.getSiblingDB("testdb").test_col.createIndex({"f1": 1, "f2": -1, "f3": 1, "f4": 1}, {"name": "idx_01"});
   db.getSiblingDB("testdb").test_col.createIndex({"f1": 1, "f2": -1, "f3": 1}, {"name": "idx_02"});


The index ``idx_02`` is the prefix of ``idx_01`` because it has the same
keys in the same order so, ``idx_02`` can be dropped.

Unused indexes.
~~~~~~~~~~~~~~~

This check gets the ``$indexstats`` for all indexes and reports those
having ``accesses.ops`` = 0.

Usage
=====

Run the program as ``pt-mongodb-index-check <command> [flags]``

Available commands

================ ================================== Command Description ================ ================================== check-duplicated Run checks for duplicated indexes. check-unused Run check for unused indexes. check-all Run all checks ================ ==================================

Available flags


+----------------------------+----------------------------------------+
| Flag                       | Description                            |
+============================+========================================+
| –all-databases             | Check in all databases excluding       |
|                            | system dbs.                            |
+----------------------------+----------------------------------------+
| –databases=DATABASES,…     | Comma separated list of databases to   |
|                            | check.                                 |
+----------------------------+----------------------------------------+
| –all-collections           | Check in all collections in the        |
|                            | selected databases.                    |
+----------------------------+----------------------------------------+
| –collections=COLLECTIONS,… | Comma separated list of collections to |
|                            | check.                                 |
+----------------------------+----------------------------------------+
| –mongodb.uri=              | Connection URI                         |
+----------------------------+----------------------------------------+
| –json                      | Show output as JSON                    |
+----------------------------+----------------------------------------+
| –version                   | Show version information               |
+----------------------------+----------------------------------------+

Authors
=======

Carlos Salguero