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

2013-02-06 Thread Alexander Farber
Hello, I've read in the docs, that every table should better have primary key and so I've rearranged my 8.4.13 database: added primary keys to each table (some of the primary keys are pairs of columns) and dropped all other indices. And I've probably dropped few indices too many, because a

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

2013-02-06 Thread Pavel Stehule
Hello 2013/2/6 Alexander Farber alexander.far...@gmail.com: Hello, I've read in the docs, that every table should better have primary key and so I've rearranged my 8.4.13 database: added primary keys to each table (some of the primary keys are pairs of columns) and dropped all other

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

2013-02-06 Thread Alban Hertroys
On 6 February 2013 11:03, Alexander Farber alexander.far...@gmail.comwrote: begin insert into pref_ban2 select id, first_name, last_name, city,