"Paul Mackay" <mackaypaul@xxxxxxxxx> writes: > I understand that the query plan of a function is determined at > CREATION and remains the same whatever the parameter(s) value. I > suppose then that this plan is stored somewhere in a system table ? You are misinformed. It's determined the first time that function is executed in a given backend, and stored in backend-local memory. There's no way that I know of to look at it. -Doug