EXPLAIN ANALYZEcan be used in front of select statements in Postgres to get the performance metrics of a query.
EXPLAIN ANALYZE