i want know, while i am executing select query , what are proceses running in background ?

Can you explain about that..