Created
May 5, 2014 03:35
-
-
Save amit-naudiyal/2514ef08068b039be79e to your computer and use it in GitHub Desktop.
smsi_indexing_expectations
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| hsrs collection | |
| ----------------- | |
| smsiProductionMongo:PRIMARY> db.hsrs.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c4c"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "media_queue_id" : 1 | |
| }, | |
| "name" : "media_queue_id_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c4d"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "created_at" : 1 | |
| }, | |
| "name" : "created_at_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c4e"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "updated_at" : 1 | |
| }, | |
| "name" : "updated_at_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c4f"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "checked_out_at" : 1 | |
| }, | |
| "name" : "checked_out_at_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c50"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "checked_in_at" : 1 | |
| }, | |
| "name" : "checked_in_at_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c51"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "state" : 1 | |
| }, | |
| "name" : "state_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51d6739af1a935b8c52"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "chunk_id" : 1 | |
| }, | |
| "name" : "chunk_id_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d51e6739af1a935b8c53"), | |
| "ns" : "simulscribe_production.hsrs", | |
| "key" : { | |
| "result" : 1 | |
| }, | |
| "name" : "result_1", | |
| "background" : true, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| employee_datas collection | |
| -------------------------- | |
| smsiProductionMongo:PRIMARY> db.employee_datas.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.employee_datas", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c54"), | |
| "ns" : "simulscribe_production.employee_datas", | |
| "key" : { | |
| "employee_id" : 1 | |
| }, | |
| "name" : "employee_id_1", | |
| "unique" : true, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| allowed_ip_ranges collection | |
| ----------------------------- | |
| smsiProductionMongo:PRIMARY> db.allowed_ip_ranges.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.allowed_ip_ranges", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c55"), | |
| "ns" : "simulscribe_production.allowed_ip_ranges", | |
| "key" : { | |
| "range" : 1 | |
| }, | |
| "name" : "range_1", | |
| "unique" : true, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| account_datas collection | |
| ------------------------ | |
| smsiProductionMongo:PRIMARY> db.account_datas.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.account_datas", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "key" : { | |
| "workflow_level_ids" : 1 | |
| }, | |
| "name" : "workflow_level_ids_1", | |
| "ns" : "simulscribe_production.account_datas", | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c57"), | |
| "ns" : "simulscribe_production.account_datas", | |
| "key" : { | |
| "account_id" : 1 | |
| }, | |
| "name" : "account_id_1", | |
| "background" : true, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| workflows collection | |
| --------------------- | |
| smsiProductionMongo:PRIMARY> db.workflows.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.workflows", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c58"), | |
| "ns" : "simulscribe_production.workflows", | |
| "key" : { | |
| "name" : 1 | |
| }, | |
| "name" : "name_1", | |
| "background" : 1, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| media_queues collection | |
| ------------------------- | |
| smsiProductionMongo:PRIMARY> db.media_queues.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.media_queues", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c59"), | |
| "ns" : "simulscribe_production.media_queues", | |
| "key" : { | |
| "name" : 1 | |
| }, | |
| "name" : "name_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5a"), | |
| "ns" : "simulscribe_production.media_queues", | |
| "key" : { | |
| "priority" : 1 | |
| }, | |
| "name" : "priority_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5b"), | |
| "ns" : "simulscribe_production.media_queues", | |
| "key" : { | |
| "language" : 1 | |
| }, | |
| "name" : "language_1", | |
| "background" : true, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5c"), | |
| "ns" : "simulscribe_production.media_queues", | |
| "key" : { | |
| "length" : 1 | |
| }, | |
| "name" : "length_1", | |
| "background" : true, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| media_queue_assignments collection | |
| ----------------------------------- | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.media_queue_assignments", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c60"), | |
| "ns" : "simulscribe_production.media_queue_assignments", | |
| "key" : { | |
| "employee_data_id" : 1 | |
| }, | |
| "name" : "employee_data_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5766739af1a935b8c61"), | |
| "ns" : "simulscribe_production.media_queue_assignments", | |
| "key" : { | |
| "media_queue_id" : 1 | |
| }, | |
| "name" : "media_queue_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| media_queue_monitors collection | |
| ------------------------------ | |
| smsiProductionMongo:PRIMARY> db.media_queue_monitors.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.media_queue_monitors", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5d"), | |
| "ns" : "simulscribe_production.media_queue_monitors", | |
| "key" : { | |
| "media_queue_id" : 1 | |
| }, | |
| "name" : "media_queue_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5e"), | |
| "ns" : "simulscribe_production.media_queue_monitors", | |
| "key" : { | |
| "enabled" : 1 | |
| }, | |
| "name" : "enabled_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8d5626739af1a935b8c5f"), | |
| "ns" : "simulscribe_production.media_queue_monitors", | |
| "key" : { | |
| "notified_at" : 1 | |
| }, | |
| "name" : "notified_at_1", | |
| "background" : 1, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| reports collection | |
| -------------------- | |
| smsiProductionMongo:PRIMARY> db.reports.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.reports", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################################# | |
| medias collection | |
| -------------------- | |
| smsiProductionMongo:PRIMARY> db.medias.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a275"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "account_id" : 1 | |
| }, | |
| "name" : "account_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a276"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "employee_id" : 1 | |
| }, | |
| "name" : "employee_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a277"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "workflow_id" : 1 | |
| }, | |
| "name" : "workflow_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a278"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "scratch_queue_id" : 1 | |
| }, | |
| "name" : "scratch_queue_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a279"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "scrub_queue_id" : 1 | |
| }, | |
| "name" : "scrub_queue_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a27a"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "visibility_state" : 1 | |
| }, | |
| "name" : "visibility_state_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a27b"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "state" : 1 | |
| }, | |
| "name" : "state_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa59534b2f8b2f8a27c"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "created_at" : 1 | |
| }, | |
| "name" : "created_at_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfa69534b2f8b2f8a27d"), | |
| "ns" : "simulscribe_production.medias", | |
| "key" : { | |
| "checked_in_at" : 1 | |
| }, | |
| "name" : "checked_in_at_1", | |
| "background" : 1, | |
| "v" : 0 | |
| } | |
| ] | |
| ############################################################################################ | |
| asrs collection | |
| ---------------- | |
| smsiProductionMongo:PRIMARY> db.asrs.getIndexes() | |
| [ | |
| { | |
| "name" : "_id_", | |
| "ns" : "simulscribe_production.asrs", | |
| "key" : { | |
| "_id" : 1 | |
| }, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfab9534b2f8b2f8a27e"), | |
| "ns" : "simulscribe_production.asrs", | |
| "key" : { | |
| "media_id" : 1 | |
| }, | |
| "name" : "media_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfab9534b2f8b2f8a27f"), | |
| "ns" : "simulscribe_production.asrs", | |
| "key" : { | |
| "chunk_id" : 1 | |
| }, | |
| "name" : "chunk_id_1", | |
| "background" : 1, | |
| "v" : 0 | |
| }, | |
| { | |
| "_id" : ObjectId("52d8dfac9534b2f8b2f8a280"), | |
| "ns" : "simulscribe_production.asrs", | |
| "key" : { | |
| "probability" : 1 | |
| }, | |
| "name" : "probability_1", | |
| "background" : 1, | |
| "v" : 0 | |
| } | |
| ] | |
| ##################################################################################### |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment