psql's EXPLAIN basically shows you the execution plan, IIRC. MySQL's EXPLAIN provides the information about what keys will be hit for which joins in a more com

psql's EXPLAIN basically shows you the execution plan, IIRC. MySQL's EXPLAIN provides the information about what keys will be hit for which joins in a more compact fashion.