If you have only recently analyzed the tables in the query, close your psql session (if that's what you were using) and
thenrestart it. I've gotten burned by asking a query using the function, which I believe is when PG creates the plan
forthe function, and then making significant changes to the tables behind it (new index, bulk insert, etc.). By
startinga new session, the function will be re-planned according to up to date statistics or using newly created
indices.
