Skip to content

Instantly share code, notes, and snippets.

@amit-naudiyal

amit-naudiyal/gist:2514ef08068b039be79e

Created May 5, 2014 03:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save amit-naudiyal/2514ef08068b039be79e to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save amit-naudiyal/2514ef08068b039be79e to your computer and use it in GitHub Desktop.
Download ZIP
smsi_indexing_expectations
Raw
gistfile1.txt
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