How to check SOQL performance?

1. Go to Developer Console.

2. Navigate to Debug --> View Log Panels...

3. Select Execution Stack.

Trigger Execution Stack Developer console Salesforce

Visualforce Execution Stack Developer console Salesforce

Note:
Duration is in Milliseconds.