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 like this worthwhile? Will
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
On nie, wrz 29, 2013 at 02:09:07 -0700, Ken Tanzer wrote:
> 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 e
On Sun, Sep 29, 2013 at 2:24 PM, Ken Tanzer wrote:
> 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: unexp
>
> 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
On Sun, Sep 29, 2013 at 2:09 AM, Ken Tanzer wrote:
> 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 re
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
