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

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 total

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 detect who

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Tom Lane
Craig Ringer cr...@2ndquadrant.com 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

Re: [HACKERS] Auto explain target tables

2013-07-22 Thread Craig Ringer
On 07/23/2013 12:52 PM, Tom Lane wrote: Craig Ringer cr...@2ndquadrant.com 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