[GENERAL] Re: explain analyze a procedure verbosely - to find which statement in it takes longer

Thank you for the replies - Using a shared library seemed too difficult for me at this moment, so I've prepended explain analyze to each query in my proc and the worst offender is this one: # explain analyze delete from pref_rounds r using temp_rids t where

[GENERAL] Re: explain analyze a procedure verbosely - to find which statement in it takes longer

This seems to have helped: # create index pref_cards_rid_index on pref_cards(rid); CREATE INDEX # \d pref_cards; Table public.pref_cards Column |Type | Modifiers -+-+--- rid | integer