Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Craig Ringer
On 07/23/2013 12:52 PM, Tom Lane wrote: > Craig Ringer writes: >>> Showing that I'm still very much learning this area myself, a bit more >>> looking around found: >>> http://www.postgresql.org/docs/current/static/querytree.html >>> which makes it clear that the range table for the query will cont

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Tom Lane
Craig Ringer writes: >> Showing that I'm still very much learning this area myself, a bit more >> looking around found: >> http://www.postgresql.org/docs/current/static/querytree.html >> which makes it clear that the range table for the query will contain >> what you want. I suspect you'll need to

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Craig Ringer
On 07/23/2013 11:41 AM, Craig Ringer wrote: > On 07/23/2013 11:24 AM, Craig Ringer wrote: >> On 07/21/2013 10:42 PM, Миша Тюрин wrote: >>> >>> hi, list, again. the next proposal into auto explain. one would be happy if >>> could set list of target tables and indexes. sometimes it is very hard to

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Craig Ringer
On 07/23/2013 11:24 AM, Craig Ringer wrote: > On 07/21/2013 10:42 PM, Миша Тюрин wrote: >> >> hi, list, again. the next proposal into auto explain. one would be happy if >> could set list of target tables and indexes. sometimes it is very hard to >> detect who is using your indexes. but turn tota

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Craig Ringer
On 07/21/2013 10:42 PM, Миша Тюрин wrote: > > hi, list, again. the next proposal into auto explain. one would be happy if > could set list of target tables and indexes. sometimes it is very hard to > detect who is using your indexes. but turn total logging on under thousands > transactions per

[HACKERS] Auto explain target tables

2013-07-21 Thread Миша Тюрин
hi, list, again. the next proposal into auto explain. one would be happy if could set list of target tables and indexes. sometimes it is very hard to detect who is using your indexes. but turn total logging on under thousands transactions per seconds is not seems like nice idea couse size of re