Mostly agree although you should probably spend a bit more time testing on a more realistic setup.

At least run some plans on the real database with real sized data and real statistics.

Similar to how mocks/stubs are great until they aren't.

That won't magic away statistics problems, but it's still good practice to acknowledge the lower app environments tend to not reflect performance of the production one.