Hey John, and thanks for the input.
On Wed, Oct 16, 2013 at 11:00 AM, John Melesky wrote:
> On Wed, Oct 16, 2013 at 12:20 AM, Ken Tanzer wrote:
>
>> First and foremost (and primarily directed to people who are kind enough
>> to provide help on this list), is a script li
On Wed, Oct 9, 2013 at 10:39 AM, John Melesky
wrote:
> (off-list)
>
(on-list)
> I doubt I'm the first to ask, but have you considered putting this up on
> github (or similar) so others can contribute more easily and keep it
> up-to-date?
>
> If that's not in the cards, are you opposed to someone
Thanks for the suggestions, help and feedback. New version attached.
3. When extracting table names you are missing:
>a. Index Scan Backward
>b. Bitmap Heap Scan
> 4. When extracting index names, you're missing Index Only Scans and Index
> Scan Backwards.
If someone can send me analyze
>
> p.s., This script runs fine on my computer (Ubuntu 13.04), but on a
>> Fedora 11 machine it dies with
>>
>> pg_analyze_info.sh: line 18: unexpected EOF while looking for matching `)'
>> pg_analyze_info.sh: line 57: syntax error: unexpected end of file
>>
>> If anyone knows why, or encounters
I just sent off to this list for query help, and found the process of
gathering all the requested info somewhat tedious. So I created a little
BASH script to try to pull together as much of this information as
possible.
The script reads an analyze file, and generates SQL queries to retrieve the
f
