A nice primer on using EXPLAIN to see how Postgres’s execution planner has interpreted your query and ANALYZE to actually run the query and see the time it took to execute it according to that plan.