Overwhelming

I wonder at what point Joseph Smith found it overwhelming to have the keys off each dispensation given into his care. Was it as the visions opened it did the weight of what he was entrusted with hit him at some later point?